DBA Data[Home] [Help]

APPS.JAI_AP_ILA_TRIGGER_PKG dependencies on JAI_CONSTANTS

Line 31: Pv_return_code := jai_constants.unexpected_error;

27: and invoice_line_number = pr_new.line_number
28: and po_distribution_id is null;
29: EXCEPTION
30: WHEN OTHERS THEN
31: Pv_return_code := jai_constants.unexpected_error;
32: Pv_return_message := 'Encountered an error in JAI_AP_ILA_TRIGGER_PKG.ARI_T1 ' || substr(sqlerrm,1,1900);
33: END;
34:
35:

Line 152: pv_return_code := jai_constants.successful ;

148: v_myfilehandle UTL_FILE.FILE_TYPE;
149: v_debug CHAR(1) := 'N';
150:
151: BEGIN
152: pv_return_code := jai_constants.successful ;
153:
154: /*-------------------------------------------------------------------------------------------------------------------------
155: FILENAME: jai_ap_ida_t3.sql
156: CHANGE HISTORY:

Line 282: pv_return_code := jai_constants.successful ;

278: IF v_debug = 'Y' THEN
279: DECLARE
280: lv_name VARCHAR2 (10);
281: BEGIN
282: pv_return_code := jai_constants.successful ;
283: -- Modified by Brathod for SQL Literals
284: lv_name := 'utl_file_dir';
285: SELECT DECODE(SUBSTR (value,1,INSTR(value,',') -1),NULL,
286: Value,SUBSTR (value,1,INSTR(value,',') -1)) INTO v_utl_location

Line 734: Pv_return_code := jai_constants.unexpected_error;

730: END IF;
731: /* Added an exception block by Ramananda for bug#4570303 */
732: EXCEPTION
733: WHEN OTHERS THEN
734: Pv_return_code := jai_constants.unexpected_error;
735: Pv_return_message := 'Encountered an error in JAI_AP_ILA_TRIGGER_PKG.ARI_T1 ' || substr(sqlerrm,1,1900);
736: END ARI_T1 ;
737:
738: END JAI_AP_ILA_TRIGGER_PKG ;