when referring to the new or old values in a WHEN clause, you must omit the colon:
WHEN (:NEW.mgr is null)-- is wrong.
It will raise error
"ORA-00920: invalid relational operator"