Require to call a PL/Sql Package automatically when the data from the integrator is loaded to the st

Hi All,

Require to call a PL/Sql Package automatically when the data from the integrator is loaded to the staging table.
This pl/sql table should automatically be called for every load so as to perform some custom validations.

If there are any custom failure in Validations during the execution of the PL/Sql package automatically, i wanted to show the results back in the Template.
Is this possible.

With Regards
Uday Raju