APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on JAI_AR_RCTA_TRIGGER_PKG

Line 1: PACKAGE BODY JAI_AR_RCTA_TRIGGER_PKG AS

1: PACKAGE BODY JAI_AR_RCTA_TRIGGER_PKG AS
2: /* $Header: jai_ar_rcta_t.plb 120.17.12010000.3 2008/11/10 06:56:00 csahoo ship $ */
3:
4: /*
5: || foll function created by csahoo - for seperate vat invoice num for unreg dealers - bug# 5233925

Line 287: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARI_T1 ' || substr(sqlerrm,1,1900);

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 +======================================================================+

Line 509: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARU_T1 ' || substr(sqlerrm,1,1900);

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 +======================================================================+

Line 621: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARU_T2 ' || substr(sqlerrm,1,1900);

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 +======================================================================+

Line 922: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARU_T3 ' || substr(sqlerrm,1,1900);

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: /*

Line 2361: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARU_T4 ' || substr(sqlerrm,1,1900);

2357: /* Added an exception block by Ramananda for bug#4570303 */
2358: EXCEPTION
2359: WHEN OTHERS THEN
2360: Pv_return_code := jai_constants.unexpected_error;
2361: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARU_T4 ' || substr(sqlerrm,1,1900);
2362:
2363: END ARU_T4 ;
2364:
2365: /*

Line 2764: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARU_T4. ' ||

2760: --RAISE_APPLICATION_ERROR(-20003,'exception occured during processing invoice ..' || v_trx_num || v_err_mesg);
2761:
2762: /* Added an exception block by Ramananda for bug#4570303 */
2763: Pv_return_code := jai_constants.unexpected_error;
2764: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARU_T4. ' ||
2765: 'Exception occured during processing invoice ..' || v_trx_num || v_err_mesg ;
2766:
2767: END ARU_T5 ;
2768:

Line 3209: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARI_T7 ' || substr(sqlerrm,1,1900);

3205: /* Added an exception block by Ramananda for bug#4570303 */
3206: EXCEPTION
3207: WHEN OTHERS THEN
3208: Pv_return_code := jai_constants.unexpected_error;
3209: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARI_T7 ' || substr(sqlerrm,1,1900);
3210:
3211: END ARU_T6 ;
3212: /*
3213: REM +======================================================================+

Line 3554: END JAI_AR_RCTA_TRIGGER_PKG ;

3550: pv_return_message := substr (sqlerrm,1,1999);
3551: pv_return_code := jai_constants.unexpected_error;
3552: END ARD_T1;
3553:
3554: END JAI_AR_RCTA_TRIGGER_PKG ;