If a manager in almost any major industry were found drunk in the gutter he'd be tossed out out the company as a site safety risk. By "major industry" I mean real jobs like mining / engineering / chemicals / pharmaceuticals / electronics with safety-critical requirements
Highly unlikely particularly for a first offence. The company would interview the individual to see if there was an alchohol dependancy issue or other issues. It is likely to re-assign the person to a task which can be monitored and isn't so critical or front line. It certainly wouldn't enhance the CV or career prospects though.