How can I RAISE_APPLICATION_ERROR and do an INSERT in the same trigger?
Log type operations are usually done via AUTONOMOUS_TRANSACTION procedures.

Don't have a logging package, get one from GitHub.

https://github.com/OraOpenSource/Logger