eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_OE_OLA_TRIGGER_PKG dependencies on UTL_FILE

Line 359: v_myfilehandle UTL_FILE.FILE_TYPE ; -- This is for File handling

355:
356: rec_cur_get_rma_entry_lines cur_get_rma_entry_lines%ROWTYPE;
357: v_debug VARCHAR2(1); --File.Sql.35 Cbabu := 'N' ; -- Added by Aparajita on 29-may-2002
358: v_utl_location VARCHAR2(512) ; --For Log file.
359: v_myfilehandle UTL_FILE.FILE_TYPE ; -- This is for File handling
360: v_hook VARCHAR2(6) ;
361: v_tax_line_count NUMBER ; --ashish for bug # 2519043
362: -- warehouse_not_found EXCEPTION ;
363:

Line 608: WHERE LOWER(name) = 'utl_file_dir';

604: SUBSTR (value,1,INSTR(value,',') -1)
605: )
606: INTO v_utl_location
607: FROM v$parameter
608: WHERE LOWER(name) = 'utl_file_dir';
609:
610: -- if there are more than one directory defined for the parameter pick up the first one.
611:
612: IF v_utl_location IS NULL THEN

Line 613: -- utl file dir not defined, log file cannot be generated.

609:
610: -- if there are more than one directory defined for the parameter pick up the first one.
611:
612: IF v_utl_location IS NULL THEN
613: -- utl file dir not defined, log file cannot be generated.
614: v_debug := 'N';
615: ELSE
616: -- open the file in append mode.
617: v_myfilehandle := utl_file.fopen(v_utl_location, 'OE_ORDER_LINES_ALL_triggers_ja.LOG','A');

Line 617: v_myfilehandle := utl_file.fopen(v_utl_location, 'OE_ORDER_LINES_ALL_triggers_ja.LOG','A');

613: -- utl file dir not defined, log file cannot be generated.
614: v_debug := 'N';
615: ELSE
616: -- open the file in append mode.
617: v_myfilehandle := utl_file.fopen(v_utl_location, 'OE_ORDER_LINES_ALL_triggers_ja.LOG','A');
618: END IF;
619:
620: EXCEPTION
621: WHEN OTHERS THEN

Line 632: utl_file.put_line(v_myfilehandle,'** START OF TRIGGER JA_IN_OE_ORDER_LINES_AIU_TRG AFTER INSERT OR UPDATE ON OE_ORDER_LINES_ALL FOR EACH ROW ~ ' || TO_CHAR(SYSDATE,'dd/mm/rrrr hh24:mi:ss'));

628:
629: -- Added by Aparajita for writing onto the log file
630: IF v_debug = 'Y' THEN
631: -- log start of trigger
632: utl_file.put_line(v_myfilehandle,'** START OF TRIGGER JA_IN_OE_ORDER_LINES_AIU_TRG AFTER INSERT OR UPDATE ON OE_ORDER_LINES_ALL FOR EACH ROW ~ ' || TO_CHAR(SYSDATE,'dd/mm/rrrr hh24:mi:ss'));
633: utl_file.put_line(v_myfilehandle,'Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));
634: END IF; -- v_debug
635:
636:

Line 633: utl_file.put_line(v_myfilehandle,'Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));

629: -- Added by Aparajita for writing onto the log file
630: IF v_debug = 'Y' THEN
631: -- log start of trigger
632: utl_file.put_line(v_myfilehandle,'** START OF TRIGGER JA_IN_OE_ORDER_LINES_AIU_TRG AFTER INSERT OR UPDATE ON OE_ORDER_LINES_ALL FOR EACH ROW ~ ' || TO_CHAR(SYSDATE,'dd/mm/rrrr hh24:mi:ss'));
633: utl_file.put_line(v_myfilehandle,'Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));
634: END IF; -- v_debug
635:
636:
637: /*

Line 724: utl_file.put_line(v_myfilehandle,'Returning at STANDARD , RETURN, V_Source_Document_Type_Id' );

720: THEN
721: /* End of bug 5401180 */
722:
723: IF v_debug = 'Y' THEN
724: utl_file.put_line(v_myfilehandle,'Returning at STANDARD , RETURN, V_Source_Document_Type_Id' );
725: utl_file.put_line(v_myfilehandle,'** END OF TRIGGER jai_oe_ola_ariu_t5 AFTER INSERT OR UPDATE ON OE_ORDER_LINES_ALL FOR EACH ROW ~ ' || TO_CHAR(SYSDATE,'dd/mm/rrrr hh24:mi:ss'));
726: utl_file.fclose(v_myfilehandle);
727: END IF; -- v_debug
728: RETURN;

Line 725: utl_file.put_line(v_myfilehandle,'** END OF TRIGGER jai_oe_ola_ariu_t5 AFTER INSERT OR UPDATE ON OE_ORDER_LINES_ALL FOR EACH ROW ~ ' || TO_CHAR(SYSDATE,'dd/mm/rrrr hh24:mi:ss'));

721: /* End of bug 5401180 */
722:
723: IF v_debug = 'Y' THEN
724: utl_file.put_line(v_myfilehandle,'Returning at STANDARD , RETURN, V_Source_Document_Type_Id' );
725: utl_file.put_line(v_myfilehandle,'** END OF TRIGGER jai_oe_ola_ariu_t5 AFTER INSERT OR UPDATE ON OE_ORDER_LINES_ALL FOR EACH ROW ~ ' || TO_CHAR(SYSDATE,'dd/mm/rrrr hh24:mi:ss'));
726: utl_file.fclose(v_myfilehandle);
727: END IF; -- v_debug
728: RETURN;
729: END IF;

Line 726: utl_file.fclose(v_myfilehandle);

722:
723: IF v_debug = 'Y' THEN
724: utl_file.put_line(v_myfilehandle,'Returning at STANDARD , RETURN, V_Source_Document_Type_Id' );
725: utl_file.put_line(v_myfilehandle,'** END OF TRIGGER jai_oe_ola_ariu_t5 AFTER INSERT OR UPDATE ON OE_ORDER_LINES_ALL FOR EACH ROW ~ ' || TO_CHAR(SYSDATE,'dd/mm/rrrr hh24:mi:ss'));
726: utl_file.fclose(v_myfilehandle);
727: END IF; -- v_debug
728: RETURN;
729: END IF;
730:

Line 2487: utl_file.put_line(v_myfilehandle, ' Inside ELSE OF NEW.SPLIT_FROM_LINE_ID IS NOT NULL ' || v_transaction_name);

2483: -- End of Bug 3344454
2484: END IF;
2485: -- Added by Aparajita for writing onto the log file
2486: IF v_debug = 'Y' THEN
2487: utl_file.put_line(v_myfilehandle, ' Inside ELSE OF NEW.SPLIT_FROM_LINE_ID IS NOT NULL ' || v_transaction_name);
2488: END IF;
2489:
2490: -- Else if the line is a fresh line , Unsplitted
2491: /*

Line 2541: utl_file.put_line(v_myfilehandle, ' v_assessable_value -> '||v_assessable_value);

2537: ln_vat_assessable_value := nvl(ln_vat_assessable_value,0) * v_line_quantity;
2538:
2539:
2540: IF v_debug = 'Y' THEN
2541: utl_file.put_line(v_myfilehandle, ' v_assessable_value -> '||v_assessable_value);
2542: END IF;
2543:
2544: --IF v_order_category not in ('ORDER','MIXED','RETURN')
2545:

Line 2553: utl_file.put_line(v_myfilehandle, ' inside IF OF v_line_category_code IN (ORDER) OR v_transaction_name = RMA_LEGACY_INSERT');

2549:
2550: IF ( (v_line_category_code='ORDER') OR (v_transaction_name='RMA_LEGACY_INSERT') ) THEN --and V_Order_Source_Type = 'Internal'
2551:
2552: IF v_debug = 'Y' THEN
2553: utl_file.put_line(v_myfilehandle, ' inside IF OF v_line_category_code IN (ORDER) OR v_transaction_name = RMA_LEGACY_INSERT');
2554: END IF;
2555:
2556: -- When ship to site is changed
2557: IF NVL(pr_new.ship_to_ORG_id,0) <> NVL(pr_old.ship_to_ORG_id,0) THEN

Line 2559: utl_file.put_line(v_myfilehandle, ' BEFORE DELETING WHEN ship TO org has changed');

2555:
2556: -- When ship to site is changed
2557: IF NVL(pr_new.ship_to_ORG_id,0) <> NVL(pr_old.ship_to_ORG_id,0) THEN
2558: IF v_debug = 'Y' THEN
2559: utl_file.put_line(v_myfilehandle, ' BEFORE DELETING WHEN ship TO org has changed');
2560: END IF;
2561:
2562: IF ( v_transaction_name = 'RMA_LEGACY_INSERT') THEN
2563:

Line 2578: utl_file.put_line(v_myfilehandle, ' BEFORE calling jai_cmn_tax_defaultation_pkg.ja_in_cust_default_taxes ');

2574: END IF;
2575:
2576: -- End of Ship to site changed
2577: IF v_debug = 'Y' THEN
2578: utl_file.put_line(v_myfilehandle, ' BEFORE calling jai_cmn_tax_defaultation_pkg.ja_in_cust_default_taxes ');
2579: END IF;
2580:
2581: jai_cmn_tax_defaultation_pkg.ja_in_cust_default_taxes (
2582: v_warehouse_id,

Line 2593: utl_file.put_line(v_myfilehandle, ' BEFORE calling jai_cmn_tax_defaultation_pkg.ja_in_org_default_taxes ');

2589: );
2590:
2591: IF v_tax_category_id IS NULL THEN
2592: IF v_debug = 'Y' THEN
2593: utl_file.put_line(v_myfilehandle, ' BEFORE calling jai_cmn_tax_defaultation_pkg.ja_in_org_default_taxes ');
2594: END IF;
2595:
2596: jai_cmn_tax_defaultation_pkg.ja_in_org_default_taxes (
2597: v_warehouse_id,

Line 2604: utl_file.put_line(v_myfilehandle, ' BEFORE setting v_line_tax_amount := v_line_amount ');

2600: );
2601:
2602: ELSE /* elsif of v_tax_category_id IS NULL */
2603: IF v_debug = 'Y' THEN
2604: utl_file.put_line(v_myfilehandle, ' BEFORE setting v_line_tax_amount := v_line_amount ');
2605: END IF;
2606: v_line_tax_amount := v_line_amount;
2607: END IF;
2608:

Line 2611: utl_file.put_line(v_myfilehandle, ' inside IF OF RMA_LEGACY_INSERT ');

2607: END IF;
2608:
2609: IF v_transaction_name = 'RMA_LEGACY_INSERT' THEN
2610: IF v_debug = 'Y' THEN
2611: utl_file.put_line(v_myfilehandle, ' inside IF OF RMA_LEGACY_INSERT ');
2612: END IF;
2613:
2614: OPEN get_rma_tax_lines_count_cur;
2615: FETCH get_rma_tax_lines_count_cur INTO v_so_tax_lines_count;

Line 2620: utl_file.put_line(v_myfilehandle, ' inside ELSE OF RMA_LEGACY_INSERT ');

2616: CLOSE get_rma_tax_lines_count_cur;
2617:
2618: ELSE --14
2619: IF v_debug = 'Y' THEN
2620: utl_file.put_line(v_myfilehandle, ' inside ELSE OF RMA_LEGACY_INSERT ');
2621: END IF;
2622:
2623: OPEN get_so_tax_lines_count_cur(v_header_id,v_line_id);
2624: FETCH get_so_tax_lines_count_cur INTO v_so_tax_lines_count;

Line 2630: utl_file.put_line(v_myfilehandle, ' inside IF OF v_so_tax_lines_count = 0 ');

2626: END IF;
2627:
2628: IF v_so_tax_lines_count = 0 THEN
2629: IF v_debug = 'Y' THEN
2630: utl_file.put_line(v_myfilehandle, ' inside IF OF v_so_tax_lines_count = 0 ');
2631: END IF;
2632: jai_cmn_tax_defaultation_pkg.ja_in_calc_prec_taxes (
2633: transaction_name => v_transaction_name,
2634: p_tax_category_id => v_tax_category_id,

Line 2659: utl_file.put_line(v_myfilehandle, ' inside IF OF V_SHIPMENT_SCHEDULE_LINE_ID IS NULL ');

2655: END IF; -- v_line_category_code IN ('ORDER') THEN
2656:
2657: IF V_SHIPMENT_SCHEDULE_LINE_ID IS NULL THEN
2658: IF v_debug = 'Y' THEN
2659: utl_file.put_line(v_myfilehandle, ' inside IF OF V_SHIPMENT_SCHEDULE_LINE_ID IS NULL ');
2660: END IF;
2661:
2662: IF v_transaction_name = 'RMA_LEGACY_INSERT' THEN
2663: OPEN get_rma_lines_count_cur(v_line_id);

Line 2675: utl_file.put_line(v_myfilehandle, ' inside IF OF v_so_lines_count = 0 ');

2671:
2672: IF v_so_lines_count = 0 THEN
2673:
2674: IF v_debug = 'Y' THEN
2675: utl_file.put_line(v_myfilehandle, ' inside IF OF v_so_lines_count = 0 ');
2676: END IF;
2677: IF v_transaction_name = 'RMA_LEGACY_INSERT' THEN
2678: IF v_debug = 'Y' THEN -- added by sriram - because it was causing errors when utl_file is not setup bug # 2687045
2679: utl_file.put_line(v_myfilehandle, 'BEFORE opening return_tax_amount_Cur ');

Line 2678: IF v_debug = 'Y' THEN -- added by sriram - because it was causing errors when utl_file is not setup bug # 2687045

2674: IF v_debug = 'Y' THEN
2675: utl_file.put_line(v_myfilehandle, ' inside IF OF v_so_lines_count = 0 ');
2676: END IF;
2677: IF v_transaction_name = 'RMA_LEGACY_INSERT' THEN
2678: IF v_debug = 'Y' THEN -- added by sriram - because it was causing errors when utl_file is not setup bug # 2687045
2679: utl_file.put_line(v_myfilehandle, 'BEFORE opening return_tax_amount_Cur ');
2680: END IF;
2681: OPEN return_tax_amount_Cur(v_header_id, pr_new.LINE_ID);
2682: FETCH return_tax_amount_Cur INTO v_line_tax_amount;

Line 2679: utl_file.put_line(v_myfilehandle, 'BEFORE opening return_tax_amount_Cur ');

2675: utl_file.put_line(v_myfilehandle, ' inside IF OF v_so_lines_count = 0 ');
2676: END IF;
2677: IF v_transaction_name = 'RMA_LEGACY_INSERT' THEN
2678: IF v_debug = 'Y' THEN -- added by sriram - because it was causing errors when utl_file is not setup bug # 2687045
2679: utl_file.put_line(v_myfilehandle, 'BEFORE opening return_tax_amount_Cur ');
2680: END IF;
2681: OPEN return_tax_amount_Cur(v_header_id, pr_new.LINE_ID);
2682: FETCH return_tax_amount_Cur INTO v_line_tax_amount;
2683: CLOSE return_tax_amount_Cur;

Line 2690: utl_file.put_line(v_myfilehandle, ' Total tax : ' || v_line_tax_amount);

2686: FETCH order_tax_amount_Cur INTO v_line_tax_amount;
2687: CLOSE order_tax_amount_Cur;
2688: END IF;
2689: IF v_debug = 'Y' THEN
2690: utl_file.put_line(v_myfilehandle, ' Total tax : ' || v_line_tax_amount);
2691: END IF;
2692:
2693: IF v_transaction_name = 'RMA_LEGACY_INSERT' THEN
2694: IF v_debug = 'Y' THEN

Line 2695: utl_file.put_line(v_myfilehandle, ' BEFORE INSERTING RECORD INTO JAI_OM_OE_RMA_LINES ');

2691: END IF;
2692:
2693: IF v_transaction_name = 'RMA_LEGACY_INSERT' THEN
2694: IF v_debug = 'Y' THEN
2695: utl_file.put_line(v_myfilehandle, ' BEFORE INSERTING RECORD INTO JAI_OM_OE_RMA_LINES ');
2696: END IF;
2697: INSERT INTO JAI_OM_OE_RMA_LINES (
2698: rma_line_number,
2699: rma_line_id,

Line 2736: utl_file.put_line(v_myfilehandle, ' BEFORE INSERTING RECORD INTO JAI_OM_OE_SO_LINES ');

2732: v_assessable_value -- cbabu for Bug# 2687130
2733: );
2734: ELSE /* else if of v_transaction_name = 'RMA_LEGACY_INSERT' */
2735: IF v_debug = 'Y' THEN
2736: utl_file.put_line(v_myfilehandle, ' BEFORE INSERTING RECORD INTO JAI_OM_OE_SO_LINES ');
2737: END IF;
2738: -- the following select and if added by sriram
2739: -- bug # 2503978
2740:

Line 2864: utl_file.put_line(v_myfilehandle,'In the Loop Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));

2860: Loop
2861:
2862: IF v_debug = 'Y' THEN
2863: -- log start of trigger
2864: utl_file.put_line(v_myfilehandle,'In the Loop Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));
2865: end if;
2866:
2867: -- Select 'before insert into ja_in_oe_order_lines_aiu_trg 12345' into v_trigg_stat from dual;
2868:

Line 2968: utl_file.put_line(v_myfilehandle,'** SUCCESSFUL END OF TRIGGER jai_oe_ola_ariu_t5 AFTER INSERT OR UPDATE ON OE_ORDER_LINES_ALL FOR EACH ROW ~ ' || TO_CHAR(SYSDATE,'DD/mm/rrrr hh24:mi:ss'));

2964:
2965: -- Added by Aparajita for writing onto the log file
2966: IF v_debug = 'Y' THEN
2967: -- log start of trigger
2968: utl_file.put_line(v_myfilehandle,'** SUCCESSFUL END OF TRIGGER jai_oe_ola_ariu_t5 AFTER INSERT OR UPDATE ON OE_ORDER_LINES_ALL FOR EACH ROW ~ ' || TO_CHAR(SYSDATE,'DD/mm/rrrr hh24:mi:ss'));
2969: utl_file.put_line(v_myfilehandle,'Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));
2970: utl_file.fclose(v_myfilehandle);
2971: END IF; -- v_debug
2972:

Line 2969: utl_file.put_line(v_myfilehandle,'Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));

2965: -- Added by Aparajita for writing onto the log file
2966: IF v_debug = 'Y' THEN
2967: -- log start of trigger
2968: utl_file.put_line(v_myfilehandle,'** SUCCESSFUL END OF TRIGGER jai_oe_ola_ariu_t5 AFTER INSERT OR UPDATE ON OE_ORDER_LINES_ALL FOR EACH ROW ~ ' || TO_CHAR(SYSDATE,'DD/mm/rrrr hh24:mi:ss'));
2969: utl_file.put_line(v_myfilehandle,'Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));
2970: utl_file.fclose(v_myfilehandle);
2971: END IF; -- v_debug
2972:
2973: -- Select 'End of trigger ' into v_trigg_stat from dual;

Line 2970: utl_file.fclose(v_myfilehandle);

2966: IF v_debug = 'Y' THEN
2967: -- log start of trigger
2968: utl_file.put_line(v_myfilehandle,'** SUCCESSFUL END OF TRIGGER jai_oe_ola_ariu_t5 AFTER INSERT OR UPDATE ON OE_ORDER_LINES_ALL FOR EACH ROW ~ ' || TO_CHAR(SYSDATE,'DD/mm/rrrr hh24:mi:ss'));
2969: utl_file.put_line(v_myfilehandle,'Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));
2970: utl_file.fclose(v_myfilehandle);
2971: END IF; -- v_debug
2972:
2973: -- Select 'End of trigger ' into v_trigg_stat from dual;
2974:

Line 2979: utl_file.put_line(v_myfilehandle,'Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));

2975: EXCEPTION
2976: WHEN OTHERS THEN
2977: IF v_debug = 'Y' THEN
2978: -- log start of trigger
2979: utl_file.put_line(v_myfilehandle,'Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));
2980: utl_file.put_line(v_myfilehandle,'Error :' || SQLERRM );
2981: utl_file.put_line(v_myfilehandle,'** Error END OF TRIGGER jai_oe_ola_ariu_t5 AFTER INSERT OR UPDATE ON OE_ORDER_LINES_ALL FOR EACH ROW ~ ' || TO_CHAR(SYSDATE,'DD/mm/rrrr hh24:mi:ss'));
2982: utl_file.fclose(v_myfilehandle);
2983: END IF; -- v_debug

Line 2980: utl_file.put_line(v_myfilehandle,'Error :' || SQLERRM );

2976: WHEN OTHERS THEN
2977: IF v_debug = 'Y' THEN
2978: -- log start of trigger
2979: utl_file.put_line(v_myfilehandle,'Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));
2980: utl_file.put_line(v_myfilehandle,'Error :' || SQLERRM );
2981: utl_file.put_line(v_myfilehandle,'** Error END OF TRIGGER jai_oe_ola_ariu_t5 AFTER INSERT OR UPDATE ON OE_ORDER_LINES_ALL FOR EACH ROW ~ ' || TO_CHAR(SYSDATE,'DD/mm/rrrr hh24:mi:ss'));
2982: utl_file.fclose(v_myfilehandle);
2983: END IF; -- v_debug
2984:

Line 2981: utl_file.put_line(v_myfilehandle,'** Error END OF TRIGGER jai_oe_ola_ariu_t5 AFTER INSERT OR UPDATE ON OE_ORDER_LINES_ALL FOR EACH ROW ~ ' || TO_CHAR(SYSDATE,'DD/mm/rrrr hh24:mi:ss'));

2977: IF v_debug = 'Y' THEN
2978: -- log start of trigger
2979: utl_file.put_line(v_myfilehandle,'Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));
2980: utl_file.put_line(v_myfilehandle,'Error :' || SQLERRM );
2981: utl_file.put_line(v_myfilehandle,'** Error END OF TRIGGER jai_oe_ola_ariu_t5 AFTER INSERT OR UPDATE ON OE_ORDER_LINES_ALL FOR EACH ROW ~ ' || TO_CHAR(SYSDATE,'DD/mm/rrrr hh24:mi:ss'));
2982: utl_file.fclose(v_myfilehandle);
2983: END IF; -- v_debug
2984:
2985: --RAISE_APPLICATION_ERROR(-20002, 'ERROR - TRIGGER JA_IN_OE_ORDER_LINES_AIU_TRG : ' || SQLERRM);

Line 2982: utl_file.fclose(v_myfilehandle);

2978: -- log start of trigger
2979: utl_file.put_line(v_myfilehandle,'Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));
2980: utl_file.put_line(v_myfilehandle,'Error :' || SQLERRM );
2981: utl_file.put_line(v_myfilehandle,'** Error END OF TRIGGER jai_oe_ola_ariu_t5 AFTER INSERT OR UPDATE ON OE_ORDER_LINES_ALL FOR EACH ROW ~ ' || TO_CHAR(SYSDATE,'DD/mm/rrrr hh24:mi:ss'));
2982: utl_file.fclose(v_myfilehandle);
2983: END IF; -- v_debug
2984:
2985: --RAISE_APPLICATION_ERROR(-20002, 'ERROR - TRIGGER JA_IN_OE_ORDER_LINES_AIU_TRG : ' || SQLERRM);
2986: /* Added an exception block by Ramananda for bug#4570303 */