DBA Data[Home] [Help]

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.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

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 2717: Pv_return_message := 'Encountered an error in JAI_AR_RCTA_TRIGGER_PKG.ARU_T4 ' || substr(sqlerrm,1,1900);

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

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

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:

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

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

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

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:

Line 4723: END JAI_AR_RCTA_TRIGGER_PKG ;

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 ;