We have all (at least most of them) the OEM service and parts manual on the forum :
3rd Gen Service and Parts Manuals
The service manual has the detailed wiring diagram. However keep in mind that these schematics cover all the available options and variances so they are a little cryptic to read.
That being said, there are very few things that can go wrong from a door lock perspective.
If the harnesses are not cutted out and all contacts are solid, and the physical lock mechanisms themsekves are fine, then next thing to check is the individual controls. One way to see if one of the controls is faulty and interferes with the operation is to disconnect them 1 by 1 and test the system. Only the main driver door controller cannot be disconnected as it controls the whole thing.
One thing you can do is if you have a spare battery, test every lock individually by putting a current on the door lock wires. it is a 3 wires system, ground + lead#1 + lead#2. The combination ground + 1 of the leads either opens the lock or closes it.
If everything checks out from that end, you then try doing the same thing from the Driver door controller harness. If all the door react properly, then your main driver door controller is shut and would need to be replaced. Sometimes them controllers get corroded and do not allow enough current to go through impairing the operation of the system. If you don't get enough current to the solenoids, they will only partly fire and return back to their position as if something was blocking the operation.
A multimeter would also allow you to monitor the current sent through the wires and see if there is enough current for the solenoids to operate properly, further acknowledging your diagnostic.
Hope this helps.