your trigger is defined to call cidr_staging.trigger_fct_tr_stg_adjudicative_status_ins, the error is report from there, but you give a definition for cidr_staging.trigger_fct_tr_stg_adjudicative_status_in, is that a copy/paste error, or have you actually posted the definition of a different procedure than the one in question?
> even I take the "E" values out the error is still occurred but if I dropped the function and trigger, the insert is fine
One more time: ***WHY*** are doing that?