ON-INSERT Trigger Raised Unhandled Exception ORA-29273

ON-INSERT Trigger Raised Unhandled Exception ORA-29273 error whilst creating locstion thanks to contributors https://forums.oracle.com/forums/thread.jspa?threadID=1005316