Yikes- how awful. You'll never erase that from his memory.

IMO, you aren't allowed to drink again without an attendant who will monitor your intake and send your ass home in a cab before you get sloppy like that.

I think it's important to apologize gracefully not only to him, but to everyone, and most importantly, try to identify exactly why you let that happen.