EBS Customizations (MOSC)

MOSC Banner

Before INSERT TRIGGER on table PER_ANALYSIS_CRITERIA give me tichnical error message before and afte

edited Mar 9, 2015 10:01AM in EBS Customizations (MOSC) 8 commentsAnswered

Hi,

i have created Before INSERT TRIGGER on table PER_ANALYSIS_CRITERIA to validate the SIT (Special Information Type) data, and if the validation fails, i am raising error through the following PLSQL:

HR_UTILITY.SET_MESSAGE(800, 'ARABSAT_DUPLICATE_01'); HR_UTILITY.RAISE_ERROR;

but the problem is: the raised error message is consists of three parts ( oracle technical error, my mcustom message and oracle technical error )

the complete raised error message:

===========================

SSV.do_dynamic_insert_for_java() is unable to insert new combination. into table PER_ANALYSIS_CRITERIA. SQLERRM: ORA-20001: Sorry...your depenet Rahaf Mohammad Fathallah Gaber not eligible for eduacation allowance, because he is under the age. ORA-06512: at "HR.XX_ARABSAT_VALIDATION", line 971 ORA-04088: error during execution of trigger 'HR.XX_ARABSAT_VALIDATION'

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center