DBA Data[Home] [Help]

APPS.JAI_AP_ILA_TRIGGER_PKG dependencies on JAI_CONSTANTS

Line 59: Pv_return_code := jai_constants.unexpected_error;

55: /*end bug 8425058*/
56:
57: EXCEPTION
58: WHEN OTHERS THEN
59: Pv_return_code := jai_constants.unexpected_error;
60: Pv_return_message := 'Encountered an error in JAI_AP_ILA_TRIGGER_PKG.ARI_T1 ' || substr(sqlerrm,1,1900);
61: END;
62:
63:

Line 183: pv_return_code := jai_constants.successful ;

179: lv_rcpt_tax_exists VARCHAR2(1) := NULL; --Added for Bug #12886913
180: lv_po_tax_exists VARCHAR2(1) := NULL; --Added for Bug #12886913
181:
182: BEGIN
183: pv_return_code := jai_constants.successful ;
184:
185: /*-------------------------------------------------------------------------------------------------------------------------
186: FILENAME: jai_ap_ida_t3.sql
187: CHANGE HISTORY:

Line 336: pv_return_code := jai_constants.successful ;

332: IF v_debug = 'Y' THEN
333: DECLARE
334: lv_name VARCHAR2 (10);
335: BEGIN
336: pv_return_code := jai_constants.successful ;
337: -- Modified by Brathod for SQL Literals
338: lv_name := 'utl_file_dir';
339: SELECT DECODE(SUBSTR (value,1,INSTR(value,',') -1),NULL,
340: Value,SUBSTR (value,1,INSTR(value,',') -1)) INTO v_utl_location

Line 851: Pv_return_code := jai_constants.unexpected_error;

847: Pv_return_message := 'Encountered an error in JAI_AP_ILA_TRIGGER_PKG.ARI_T1 as no data exists ' || substr(sqlerrm,1,1900);
848: END IF;
849: /* Added for bug 12886913 */ /* End */
850: WHEN OTHERS THEN
851: Pv_return_code := jai_constants.unexpected_error;
852: Pv_return_message := 'Encountered an error in JAI_AP_ILA_TRIGGER_PKG.ARI_T1 ' || substr(sqlerrm,1,1900);
853: END ARI_T1 ;
854:
855: END JAI_AP_ILA_TRIGGER_PKG ;