1: PACKAGE BODY JAI_JMCR_TRIGGER_PKG AS
2: /* $Header: jai_jcmr_t.plb 120.4 2012/05/23 08:02:21 zxin ship $ */
3:
4: /*
5: REM +======================================================================+
169: /* Added an exception block by Ramananda for bug#4570303 */
170: EXCEPTION
171: WHEN OTHERS THEN
172: Pv_return_code := jai_constants.unexpected_error;
173: Pv_return_message := 'Encountered an error in JAI_JMCR_TRIGGER_PKG.ARIU_T1 ' || substr(sqlerrm,1,1900);
174:
175: END ARIU_T1 ;
176:
177: /*
327: /* Added an exception block by Ramananda for bug#4570303 */
328: EXCEPTION
329: WHEN OTHERS THEN
330: Pv_return_code := jai_constants.unexpected_error;
331: Pv_return_message := 'Encountered an error in JAI_JMCR_TRIGGER_PKG.ARIU_T2 ' || substr(sqlerrm,1,1900);
332:
333: END ARIU_T2 ;
334:
335: END JAI_JMCR_TRIGGER_PKG ;
331: Pv_return_message := 'Encountered an error in JAI_JMCR_TRIGGER_PKG.ARIU_T2 ' || substr(sqlerrm,1,1900);
332:
333: END ARIU_T2 ;
334:
335: END JAI_JMCR_TRIGGER_PKG ;