1: PACKAGE BODY JAI_JMCR_TRIGGER_PKG AS
2: /* $Header: jai_jcmr_t.plb 120.2 2007/08/21 10:45:48 vkaranam ship $ */
3:
4: /*
5: REM +======================================================================+
161: /* Added an exception block by Ramananda for bug#4570303 */
162: EXCEPTION
163: WHEN OTHERS THEN
164: Pv_return_code := jai_constants.unexpected_error;
165: Pv_return_message := 'Encountered an error in JAI_JMCR_TRIGGER_PKG.ARIU_T1 ' || substr(sqlerrm,1,1900);
166:
167: END ARIU_T1 ;
168:
169: /*
303: /* Added an exception block by Ramananda for bug#4570303 */
304: EXCEPTION
305: WHEN OTHERS THEN
306: Pv_return_code := jai_constants.unexpected_error;
307: Pv_return_message := 'Encountered an error in JAI_JMCR_TRIGGER_PKG.ARIU_T2 ' || substr(sqlerrm,1,1900);
308:
309: END ARIU_T2 ;
310:
311: END JAI_JMCR_TRIGGER_PKG ;
307: Pv_return_message := 'Encountered an error in JAI_JMCR_TRIGGER_PKG.ARIU_T2 ' || substr(sqlerrm,1,1900);
308:
309: END ARIU_T2 ;
310:
311: END JAI_JMCR_TRIGGER_PKG ;