You might be over thinking this.
If it was a work function and everyone else was drinking then maybe your behaviour does not stand out as much as you think it did.
Did something bad happen that you can recall? An argument, a fight?
Or were you just too drunk?
My advice would be, whatever you decide with regards to your drinking, that alcohol and work do not mix.
If you have to attend work functions where drink is served, avoid it all you can and do not let anyone pressure you into drinking.
I have come to learn that for me, alcohol does not give me confidence, does not make me more sociable, does not make me witty or able to make great conversations.
It takes away everything that is nice about me.
Try not to let your thoughts spiral off out of control.
It may not be that much of a black and white situation.
Do you have a work friend you could confide in who might be able to help you understand what really happened and might make facing tomorrow easier?
Do not be worried about coming here and confiding with us.
It is nothing we have not seen or done ourselves before.