Raise exception in Trigger after update
create or replace sometrigger
after update or insert on table_name
for each row
declare
begin
check_table_condition(:new.column_name);
--if proc throws exception
exception
when others then
RAISE_APPLICATION_ERROR(-20500, 'some message', TRUE);
end sometrigger;