1: PACKAGE BODY JAI_AR_RCTA_TRIGGER_PKG AS
2: /* $Header: jai_ar_rcta_t.plb 120.44.12020000.3 2013/04/08 03:29:16 vkaranam ship $ */
3:
4: /*
5: || foll function created by csahoo - for seperate vat invoice num for unreg dealers - bug# 5233925
283: /* Added an exception block by Ramananda for bug#4570303 */
284: EXCEPTION
285: WHEN OTHERS THEN
286: Pv_return_code := jai_constants.unexpected_error;
287: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARI_T1 ' || substr(sqlerrm,1,1900);
288: END ARI_T1 ;
289:
290: /*
291: REM +======================================================================+
505: /* Added an exception block by Ramananda for bug#4570303 */
506: EXCEPTION
507: WHEN OTHERS THEN
508: Pv_return_code := jai_constants.unexpected_error;
509: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARU_T1 ' || substr(sqlerrm,1,1900);
510: END ARU_T1 ;
511:
512: /*
513: REM +======================================================================+
617: /* Added an exception block by Ramananda for bug#4570303 */
618: EXCEPTION
619: WHEN OTHERS THEN
620: Pv_return_code := jai_constants.unexpected_error;
621: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARU_T2 ' || substr(sqlerrm,1,1900);
622: END ARU_T2 ;
623:
624: /*
625: REM +======================================================================+
918: /* Added an exception block by Ramananda for bug#4570303 */
919: EXCEPTION
920: WHEN OTHERS THEN
921: Pv_return_code := jai_constants.unexpected_error;
922: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARU_T3 ' || substr(sqlerrm,1,1900);
923:
924: END ARU_T3 ;
925:
926: /*
2713: /* Added an exception block by Ramananda for bug#4570303 */
2714: EXCEPTION
2715: WHEN OTHERS THEN
2716: Pv_return_code := jai_constants.unexpected_error;
2717: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARU_T4 ' || substr(sqlerrm,1,1900);
2718: END ARU_T4 ;
2719:
2720: /*
2721: REM +======================================================================+
3285: --RAISE_APPLICATION_ERROR(-20003,'exception occured during processing invoice ..' || v_trx_num || v_err_mesg);
3286:
3287: /* Added an exception block by Ramananda for bug#4570303 */
3288: Pv_return_code := jai_constants.unexpected_error;
3289: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARU_T4. ' ||
3290: 'Exception occured during processing invoice ..' || v_trx_num || v_err_mesg ;
3291:
3292: END ARU_T5 ;
3293:
3781: /* Added an exception block by Ramananda for bug#4570303 */
3782: EXCEPTION
3783: WHEN OTHERS THEN
3784: Pv_return_code := jai_constants.unexpected_error;
3785: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARI_T7 ' || substr(sqlerrm,1,1900);
3786:
3787: END ARU_T6 ;
3788: /*
3789: REM +======================================================================+
4464:
4465: EXCEPTION
4466: WHEN OTHERS THEN
4467: Pv_return_code := jai_constants.unexpected_error;
4468: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARU_T8 ' || substr(sqlerrm,1,1900);
4469:
4470: END ARU_T8 ;
4471:
4472:
4719: pv_return_message := substr (sqlerrm,1,1999);
4720: pv_return_code := jai_constants.unexpected_error;
4721: END ARD_T1;
4722:
4723: END JAI_AR_RCTA_TRIGGER_PKG ;