Good point 212man.
There's a long list of causes of acute psychosis, including the ones you mention.
Apart from substances of abuse, it could be a metabolic cause such as diabetes or side-effect of medication.
A key point- not specified in AAIU report - is whether the FO was subsequently transferred to a general ward or whether he stayed in the psychiatric wing of the hospital....