[Home] [Help]
1: PACKAGE BODY JAI_AR_RCTLA_TRIGGER_PKG AS
2: /* $Header: jai_ar_rctla_t.plb 120.48.12020000.8 2013/03/25 01:19:17 vkaranam ship $ */
3: /*
4: REM +======================================================================+
5: REM NAME ARD_T1
289: /* Added an exception block by Ramananda for bug#4570303 */
290: EXCEPTION
291: WHEN OTHERS THEN
292: Pv_return_code := jai_constants.unexpected_error;
293: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARD_T1 ' || substr(sqlerrm,1,1900);
294: END ARD_T1 ;
295:
296: /*
297: REM +======================================================================+
633: /* Added an exception block by Ramananda for bug#4570303 */
634: EXCEPTION
635: WHEN OTHERS THEN
636: Pv_return_code := jai_constants.unexpected_error;
637: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARI_T1 ' || substr(sqlerrm,1,1900);
638: END ARI_T1 ;
639:
640: /*
641: REM +======================================================================+
2875: insertion of lines in table JAI_AR_TRX_LINES. Trigger
2876: JAI_AR_RCTA_ARIUD_T1 was fired before the header record is present in
2877: IL header table JAI_AR_TRXS. Hence the AutoInvoice goes into error.
2878: Fix: Modified the code in internal procedure process_taxes_for_ato_order of
2879: proceudre JAI_AR_RCTLA_TRIGGER_PKG.ARI_T2.
2880: Moved the insertion code into table JAI_AR_TRXS before
2881: the insertion of lines into IL taxes table.
2882:
2883: 39. 08-DEC-2008 JMEENA For Bug#5684033
4450: vsqlerrm := SQLERRM;
4451:
4452: /* Added an exception block by Ramananda for bug#4570303 */
4453: Pv_return_code := jai_constants.unexpected_error;
4454: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARI_T2 ' || substr(sqlerrm,1,1900);
4455:
4456: lv_appl_src := 'JA_IN_OE_AR_LINES_INSERT_TRG' ;
4457: lv_err_msg := 'EXCEPTION Occured' ;
4458:
5930: /* Added an exception block by Ramananda for bug#4570303 */
5931: EXCEPTION
5932: WHEN OTHERS THEN
5933: Pv_return_code := jai_constants.unexpected_error;
5934: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARI_T3 ' || substr(sqlerrm,1,1900);
5935: END ARI_T3 ;
5936:
5937:
5938:
6190:
6191: EXCEPTION
6192: WHEN OTHERS THEN
6193: Pv_return_code := jai_constants.unexpected_error;
6194: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARI_T4 ' || substr(sqlerrm,1,1900);
6195: END ;
6196:
6197: ------------------------------------------------------------------------------------------
6198: --Added by Xiao for Open Interface ER bug#11683927 on 01-Mar-2011, end
6954: VAR_SQLERRM := SUBSTR(VAR_SQLERRM,1,235);
6955:
6956: /* Added an exception block by Ramananda for bug#4570303 */
6957: Pv_return_code := jai_constants.unexpected_error;
6958: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARIU_T1 ' || substr(sqlerrm,1,1900);
6959:
6960: lv_appl_src := 'JA_IN_AR_LINES_INSERT_TRG';
6961: 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) ;
6962:
7818: /* Added an exception block by Ramananda for bug#4570303 */
7819: EXCEPTION
7820: WHEN OTHERS THEN
7821: Pv_return_code := jai_constants.unexpected_error;
7822: Pv_return_message := 'Encountered an error in JAI_AR_RCTLA_TRIGGER_PKG.ARU_T2 ' || substr(sqlerrm,1,1900);
7823: END ARU_T2 ;
7824:
7825: /* following procedure added by cbabu for bug#6012570 (5876390) */
7826: procedure import_projects_taxes
8276: return v_service_type;
8277:
8278: END;
8279:
8280: END JAI_AR_RCTLA_TRIGGER_PKG;