what's-his-faced

adj.

Being in a state of intoxication and impaired ability.

Source: Wiktionary