IS there a way to provide logging of errors ( catching exceptions ) on Insert statement on client pr

Hello,

In scenarium of testing program for bulk insert ( like XML processing and inserts into E-R tables ) dealing with the need for the process of logging errors and catching exceptions on

ORA-Errors like ORA-6502, or not nullable column or unique key violation.

The program for transformation XML schema into E-R tables is coded by the outsorced third party client program for which code is not adaptable.

1.

Is there a way to catch the exceptions and log them into some table and catching some data from the row  on some system level like system database after servererror triggers so

that attributes for user, tables, and inserting values are accessible?