What happens when somoene is accused of sexual harassment in the office?

If a person is accused of sexual harassment, will he be automatically fired? Is there a chance that he will still stay? After the investigation, would he probably resign because of the shame that he has been called out?