I wanted to give you all another update.
Basically, I hooked up the Central Locking Control Module back up today to the car. The symptoms as previously mentioned are still the same. However, with it being hooked back up for the last hour or so. The interior cabin light still does not go off, so I just press the switch to the off position to keep the light off. When I press the lock button on the alarm remote, it does in fact lock the doors and the lights do flash indicating the alarm is "armed", but the blinking light by the console dash where the tow buttom is does not blink to confirm activation of the alarm.
I did a test before activating the alarm. I went ahead and turned the ignition on, had the drivers side window go 3/4 of the way down. I then activated the alarm, waited about 5 minutes and then proceeded to open the drivers door from INSIDE on the handle, that is something that would trigger the alarm but in this case it didn't do anything.
So far in the last hour, no lights have gone on, none of the fog lights, or the the tail lights, and since the alarm did not activate, that hasn't gone crazy yet or on at all for that matter ( even if I press the red button on the remote to activate the alarm, it does nothing ).
Looks to me right now like the only thing I do have working are the locks, they unlock and lock just fine. I did take the car out for a ride about 5 minutes around the neighborhood and it was just fine, brought it back and shut it off, no lights stayed on or alarm light blinking in the console and of course the interior lights still on so I switch it off and it stays off.
It pretty much looks like that Module needs to be replaced and I am glad I at least gave it an honest shot at fixing it my self and of course leak proofing my spoiler wing and plate is an easy $300 that I saved that the Dealer would've charged and now its a matter of finding a Module at a better price than what the dealer quoted and installing it my self will save so much money! by cleaning the pins on the connectors, I was able ( so far ) to accomplish some progress as the fog and tail lights do stay off and the alarm isn't chirping crazy for a solid hour since hookup.
Some may think this could be a solution and it may be since I can lock and unlock by pressing the button on the remote. In essense, every thing works but no active alarm and that is a major concern as I purchased it knowing it had an alarm and I want to make sure it operates with one properly. I also don't want to run a risk where it may go bonkers down the road and I don't want to start ripping that interior panels to get to the part to disconnect so I'm on the lookout for a Locking Central Control Module.
Does anyone have links where I may presently find one for sale?? one that IS in stock, not on back order where I would have to wait.

Thanks everyone.