DBA Data[Home] [Help]

APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_AR_RCTLA_TRIGGER_PKG

Line 1: PACKAGE BODY JAI_AR_RCTLA_TRIGGER_PKG AS

1: PACKAGE BODY JAI_AR_RCTLA_TRIGGER_PKG AS
2: /* $Header: jai_ar_rctla_t.plb 120.22.12010000.5 2008/11/18 08:52:39 jmeena ship $ */
3: /*
4: REM +======================================================================+
5: REM NAME ARD_T1

Line 267: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARD_T1 ' || substr(sqlerrm,1,1900);

263: /* Added an exception block by Ramananda for bug#4570303 */
264: EXCEPTION
265: WHEN OTHERS THEN
266: Pv_return_code := jai_constants.unexpected_error;
267: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARD_T1 ' || substr(sqlerrm,1,1900);
268: END ARD_T1 ;
269:
270: /*
271: REM +======================================================================+

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

607: /* Added an exception block by Ramananda for bug#4570303 */
608: EXCEPTION
609: WHEN OTHERS THEN
610: Pv_return_code := jai_constants.unexpected_error;
611: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARI_T1 ' || substr(sqlerrm,1,1900);
612: END ARI_T1 ;
613:
614: /*
615: REM +======================================================================+

Line 4123: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARI_T2 ' || substr(sqlerrm,1,1900);

4119: vsqlerrm := SQLERRM;
4120:
4121: /* Added an exception block by Ramananda for bug#4570303 */
4122: Pv_return_code := jai_constants.unexpected_error;
4123: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARI_T2 ' || substr(sqlerrm,1,1900);
4124:
4125: lv_appl_src := 'JA_IN_OE_AR_LINES_INSERT_TRG' ;
4126: lv_err_msg := 'EXCEPTION Occured' ;
4127:

Line 4833: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARI_T3 ' || substr(sqlerrm,1,1900);

4829: /* Added an exception block by Ramananda for bug#4570303 */
4830: EXCEPTION
4831: WHEN OTHERS THEN
4832: Pv_return_code := jai_constants.unexpected_error;
4833: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARI_T3 ' || substr(sqlerrm,1,1900);
4834: END ARI_T3 ;
4835:
4836: /*
4837: REM +======================================================================+

Line 5502: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARIU_T1 ' || substr(sqlerrm,1,1900);

5498: VAR_SQLERRM := SUBSTR(VAR_SQLERRM,1,235);
5499:
5500: /* Added an exception block by Ramananda for bug#4570303 */
5501: Pv_return_code := jai_constants.unexpected_error;
5502: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARIU_T1 ' || substr(sqlerrm,1,1900);
5503:
5504: lv_appl_src := 'JA_IN_AR_LINES_INSERT_TRG';
5505: lv_add_err := 'CUSTOMER_TRX_ID = ' || TO_CHAR(pr_new.CUSTOMER_TRX_ID) || ' CUSTOMER_TRX_LINE_ID = ' || TO_CHAR(pr_new.CUSTOMER_TRX_LINE_ID) ;
5506:

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

6321: /* Added an exception block by Ramananda for bug#4570303 */
6322: EXCEPTION
6323: WHEN OTHERS THEN
6324: Pv_return_code := jai_constants.unexpected_error;
6325: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARU_T2 ' || substr(sqlerrm,1,1900);
6326: END ARU_T2 ;
6327:
6328: /* following procedure added by cbabu for bug#6012570 (5876390) */
6329: procedure import_projects_taxes

Line 6783: END JAI_AR_RCTLA_TRIGGER_PKG;

6779: return v_service_type;
6780:
6781: END;
6782:
6783: END JAI_AR_RCTLA_TRIGGER_PKG;