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 379: v_myfilehandle UTL_FILE.FILE_TYPE ; -- This is for File handling

375:
376: rec_cur_get_rma_entry_lines cur_get_rma_entry_lines%ROWTYPE;
377: v_debug VARCHAR2(1); --File.Sql.35 Cbabu := 'N' ; -- Added by Aparajita on 29-may-2002
378: v_utl_location VARCHAR2(512) ; --For Log file.
379: v_myfilehandle UTL_FILE.FILE_TYPE ; -- This is for File handling
380: v_hook VARCHAR2(6) ;
381: v_tax_line_count NUMBER ; --ashish for bug # 2519043
382: -- warehouse_not_found EXCEPTION ;
383:

Line 615: Cause - In the changes done for bug 9436523, utl_file.put_line was called without

611: Fix: added logic to initialize v_converted_rate
612:
613: 22 09-Jun-2010 Bug 9786306
614: Issue - Interface trip stop ends in warning for partial (split) shipments.
615: Cause - In the changes done for bug 9436523, utl_file.put_line was called without
616: checking v_debug.
617: Fix - Added IF v_debug = 'Y' condition before calling utl_file.put_line.
618: 15. 03-sep-2010 vkaranam for bug#9963286
619: Issue: WRONG UOM IN RMA ORDER

Line 617: Fix - Added IF v_debug = 'Y' condition before calling utl_file.put_line.

613: 22 09-Jun-2010 Bug 9786306
614: Issue - Interface trip stop ends in warning for partial (split) shipments.
615: Cause - In the changes done for bug 9436523, utl_file.put_line was called without
616: checking v_debug.
617: Fix - Added IF v_debug = 'Y' condition before calling utl_file.put_line.
618: 15. 03-sep-2010 vkaranam for bug#9963286
619: Issue: WRONG UOM IN RMA ORDER
620: Fix: UOM in RMA order shall be same as the base Order.
621: populated UOM from base so lines instead of populating uom from IL shipment tables.

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

737: SUBSTR (value,1,INSTR(value,',') -1)
738: )
739: INTO v_utl_location
740: FROM v$parameter
741: WHERE LOWER(name) = 'utl_file_dir';
742:
743: -- if there are more than one directory defined for the parameter pick up the first one.
744:
745: IF v_utl_location IS NULL THEN

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

742:
743: -- if there are more than one directory defined for the parameter pick up the first one.
744:
745: IF v_utl_location IS NULL THEN
746: -- utl file dir not defined, log file cannot be generated.
747: v_debug := 'N';
748: ELSE
749: -- open the file in append mode.
750: v_myfilehandle := utl_file.fopen(v_utl_location, 'OE_ORDER_LINES_ALL_triggers_ja.LOG','A');

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

746: -- utl file dir not defined, log file cannot be generated.
747: v_debug := 'N';
748: ELSE
749: -- open the file in append mode.
750: v_myfilehandle := utl_file.fopen(v_utl_location, 'OE_ORDER_LINES_ALL_triggers_ja.LOG','A');
751: END IF;
752:
753: EXCEPTION
754: WHEN OTHERS THEN

Line 765: 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'));

761:
762: -- Added by Aparajita for writing onto the log file
763: IF v_debug = 'Y' THEN
764: -- log start of trigger
765: 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'));
766: utl_file.put_line(v_myfilehandle,'Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));
767: END IF; -- v_debug
768:
769:

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

762: -- Added by Aparajita for writing onto the log file
763: IF v_debug = 'Y' THEN
764: -- log start of trigger
765: 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'));
766: utl_file.put_line(v_myfilehandle,'Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));
767: END IF; -- v_debug
768:
769:
770: /*

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

853: THEN
854: /* End of bug 5401180 */
855:
856: IF v_debug = 'Y' THEN
857: utl_file.put_line(v_myfilehandle,'Returning at STANDARD , RETURN, V_Source_Document_Type_Id' );
858: 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'));
859: utl_file.fclose(v_myfilehandle);
860: END IF; -- v_debug
861: RETURN;

Line 858: 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'));

854: /* End of bug 5401180 */
855:
856: IF v_debug = 'Y' THEN
857: utl_file.put_line(v_myfilehandle,'Returning at STANDARD , RETURN, V_Source_Document_Type_Id' );
858: 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'));
859: utl_file.fclose(v_myfilehandle);
860: END IF; -- v_debug
861: RETURN;
862: END IF;

Line 859: utl_file.fclose(v_myfilehandle);

855:
856: IF v_debug = 'Y' THEN
857: utl_file.put_line(v_myfilehandle,'Returning at STANDARD , RETURN, V_Source_Document_Type_Id' );
858: 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'));
859: utl_file.fclose(v_myfilehandle);
860: END IF; -- v_debug
861: RETURN;
862: END IF;
863:

Line 3570: utl_file.put_line(v_myfilehandle,'** START OForder_tax_amount_Cur '|| v_header_id ||' line id '||v_line_id);

3566: END LOOP; --FOR Rec IN So_Tax_Lines_Cur( v_header_id, pr_new.SPLIT_FROM_LINE_ID)
3567:
3568: --start additions for bug#9436523
3569: IF v_debug = 'Y' THEN
3570: utl_file.put_line(v_myfilehandle,'** START OForder_tax_amount_Cur '|| v_header_id ||' line id '||v_line_id);
3571: END IF;
3572: OPEN order_tax_amount_Cur(v_header_id, v_line_id);
3573: FETCH order_tax_amount_Cur INTO v_header_tax_amount;
3574: CLOSE order_tax_amount_Cur;

Line 3576: utl_file.put_line(v_myfilehandle,'** v_header_tax_amount '||v_header_tax_amount);

3572: OPEN order_tax_amount_Cur(v_header_id, v_line_id);
3573: FETCH order_tax_amount_Cur INTO v_header_tax_amount;
3574: CLOSE order_tax_amount_Cur;
3575: IF v_debug = 'Y' THEN
3576: utl_file.put_line(v_myfilehandle,'** v_header_tax_amount '||v_header_tax_amount);
3577: END IF;
3578: --end additions for bug#9436523
3579: update JAI_OM_OE_SO_LINES
3580: set tax_amount = nvl(v_header_tax_amount,0),

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

3633: -- End of Bug 3344454
3634: END IF;
3635: -- Added by Aparajita for writing onto the log file
3636: IF v_debug = 'Y' THEN
3637: utl_file.put_line(v_myfilehandle, ' Inside ELSE OF NEW.SPLIT_FROM_LINE_ID IS NOT NULL ' || v_transaction_name);
3638: END IF;
3639:
3640: -- Else if the line is a fresh line , Unsplitted
3641: /*

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

3702: --added by peng.zheng for bug 10043656, ends
3703:
3704:
3705: IF v_debug = 'Y' THEN
3706: utl_file.put_line(v_myfilehandle, ' v_assessable_value -> '||v_assessable_value);
3707: END IF;
3708:
3709: --IF v_order_category not in ('ORDER','MIXED','RETURN')
3710:

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

3714:
3715: IF ( (v_line_category_code='ORDER') OR (v_transaction_name='RMA_LEGACY_INSERT') ) THEN --and V_Order_Source_Type = 'Internal'
3716:
3717: IF v_debug = 'Y' THEN
3718: utl_file.put_line(v_myfilehandle, ' inside IF OF v_line_category_code IN (ORDER) OR v_transaction_name = RMA_LEGACY_INSERT');
3719: END IF;
3720:
3721: -- When ship to site is changed
3722: IF NVL(pr_new.ship_to_ORG_id,0) <> NVL(pr_old.ship_to_ORG_id,0) THEN

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

3720:
3721: -- When ship to site is changed
3722: IF NVL(pr_new.ship_to_ORG_id,0) <> NVL(pr_old.ship_to_ORG_id,0) THEN
3723: IF v_debug = 'Y' THEN
3724: utl_file.put_line(v_myfilehandle, ' BEFORE DELETING WHEN ship TO org has changed');
3725: END IF;
3726:
3727: IF ( v_transaction_name = 'RMA_LEGACY_INSERT') THEN
3728:

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

3739: END IF;
3740:
3741: -- End of Ship to site changed
3742: IF v_debug = 'Y' THEN
3743: utl_file.put_line(v_myfilehandle, ' BEFORE calling jai_cmn_tax_defaultation_pkg.ja_in_cust_default_taxes ');
3744: END IF;
3745:
3746: /*lv_enable_gst_flag := JAI_GST_GENERAL_PKG.IS_GST_ENABLED;*/
3747: /*IF nvl(lv_enable_gst_flag,'N') = 'N' THEN*/

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

3756: v_tax_category_id
3757: );
3758: IF v_tax_category_id IS NULL THEN
3759: IF v_debug = 'Y' THEN
3760: utl_file.put_line(v_myfilehandle, ' BEFORE calling jai_cmn_tax_defaultation_pkg.ja_in_org_default_taxes ');
3761: END IF;
3762:
3763: jai_cmn_tax_defaultation_pkg.ja_in_org_default_taxes (
3764: v_warehouse_id,

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

3767: );
3768:
3769: ELSE /* elsif of v_tax_category_id IS NULL */
3770: IF v_debug = 'Y' THEN
3771: utl_file.put_line(v_myfilehandle, ' BEFORE setting v_line_tax_amount := v_line_amount ');
3772: END IF;
3773: v_line_tax_amount := v_line_amount;
3774: END IF;
3775:

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

3802: );
3803:
3804: IF v_tax_category_id IS NOT NULL THEN
3805: IF v_debug = 'Y' THEN
3806: utl_file.put_line(v_myfilehandle, ' BEFORE setting v_line_tax_amount := v_line_amount ');
3807: END IF;
3808: v_line_tax_amount := v_line_amount;
3809: END IF;
3810: END IF;*/--added by peng.zheng for bug 10043656, ends

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

3810: END IF;*/--added by peng.zheng for bug 10043656, ends
3811:
3812: IF v_transaction_name = 'RMA_LEGACY_INSERT' THEN
3813: IF v_debug = 'Y' THEN
3814: utl_file.put_line(v_myfilehandle, ' inside IF OF RMA_LEGACY_INSERT ');
3815: END IF;
3816:
3817: OPEN get_rma_tax_lines_count_cur;
3818: FETCH get_rma_tax_lines_count_cur INTO v_so_tax_lines_count;

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

3819: CLOSE get_rma_tax_lines_count_cur;
3820:
3821: ELSE --14
3822: IF v_debug = 'Y' THEN
3823: utl_file.put_line(v_myfilehandle, ' inside ELSE OF RMA_LEGACY_INSERT ');
3824: END IF;
3825:
3826: OPEN get_so_tax_lines_count_cur(v_header_id,v_line_id);
3827: FETCH get_so_tax_lines_count_cur INTO v_so_tax_lines_count;

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

3829: END IF;
3830:
3831: IF v_so_tax_lines_count = 0 THEN
3832: IF v_debug = 'Y' THEN
3833: utl_file.put_line(v_myfilehandle, ' inside IF OF v_so_tax_lines_count = 0 ');
3834: END IF;
3835: jai_cmn_tax_defaultation_pkg.ja_in_calc_prec_taxes (
3836: transaction_name => v_transaction_name,
3837: p_tax_category_id => v_tax_category_id,

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

3859: END IF; -- v_line_category_code IN ('ORDER') THEN
3860:
3861: IF V_SHIPMENT_SCHEDULE_LINE_ID IS NULL THEN
3862: IF v_debug = 'Y' THEN
3863: utl_file.put_line(v_myfilehandle, ' inside IF OF V_SHIPMENT_SCHEDULE_LINE_ID IS NULL ');
3864: END IF;
3865:
3866: IF v_transaction_name = 'RMA_LEGACY_INSERT' THEN
3867: OPEN get_rma_lines_count_cur(v_line_id);

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

3875:
3876: IF v_so_lines_count = 0 THEN
3877:
3878: IF v_debug = 'Y' THEN
3879: utl_file.put_line(v_myfilehandle, ' inside IF OF v_so_lines_count = 0 ');
3880: END IF;
3881: IF v_transaction_name = 'RMA_LEGACY_INSERT' THEN
3882: IF v_debug = 'Y' THEN -- added by sriram - because it was causing errors when utl_file is not setup bug # 2687045
3883: utl_file.put_line(v_myfilehandle, 'BEFORE opening return_tax_amount_Cur ');

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

3878: IF v_debug = 'Y' THEN
3879: utl_file.put_line(v_myfilehandle, ' inside IF OF v_so_lines_count = 0 ');
3880: END IF;
3881: IF v_transaction_name = 'RMA_LEGACY_INSERT' THEN
3882: IF v_debug = 'Y' THEN -- added by sriram - because it was causing errors when utl_file is not setup bug # 2687045
3883: utl_file.put_line(v_myfilehandle, 'BEFORE opening return_tax_amount_Cur ');
3884: END IF;
3885: OPEN return_tax_amount_Cur(v_header_id, pr_new.LINE_ID);
3886: FETCH return_tax_amount_Cur INTO v_line_tax_amount;

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

3879: utl_file.put_line(v_myfilehandle, ' inside IF OF v_so_lines_count = 0 ');
3880: END IF;
3881: IF v_transaction_name = 'RMA_LEGACY_INSERT' THEN
3882: IF v_debug = 'Y' THEN -- added by sriram - because it was causing errors when utl_file is not setup bug # 2687045
3883: utl_file.put_line(v_myfilehandle, 'BEFORE opening return_tax_amount_Cur ');
3884: END IF;
3885: OPEN return_tax_amount_Cur(v_header_id, pr_new.LINE_ID);
3886: FETCH return_tax_amount_Cur INTO v_line_tax_amount;
3887: CLOSE return_tax_amount_Cur;

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

3890: FETCH order_tax_amount_Cur INTO v_line_tax_amount;
3891: CLOSE order_tax_amount_Cur;
3892: END IF;
3893: IF v_debug = 'Y' THEN
3894: utl_file.put_line(v_myfilehandle, ' Total tax : ' || v_line_tax_amount);
3895: END IF;
3896:
3897: -- added for bug 11774053 by zhiwei.xin on 13-Sep-2012 begin
3898: IF NVL(pr_new.ordered_quantity, 0) = 0 then

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

3903: -- added for bug 11774053 by zhiwei.xin on 13-Sep-2012 end.
3904:
3905: IF v_transaction_name = 'RMA_LEGACY_INSERT' THEN
3906: IF v_debug = 'Y' THEN
3907: utl_file.put_line(v_myfilehandle, ' BEFORE INSERTING RECORD INTO JAI_OM_OE_RMA_LINES ');
3908: END IF;
3909: INSERT INTO JAI_OM_OE_RMA_LINES (
3910: rma_line_number,
3911: rma_line_id,

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

3944: v_assessable_value -- cbabu for Bug# 2687130
3945: );
3946: ELSE /* else if of v_transaction_name = 'RMA_LEGACY_INSERT' */
3947: IF v_debug = 'Y' THEN
3948: utl_file.put_line(v_myfilehandle, ' BEFORE INSERTING RECORD INTO JAI_OM_OE_SO_LINES ');
3949: END IF;
3950: -- the following select and if added by sriram
3951: -- bug # 2503978
3952:

Line 4080: 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));

4076: Loop
4077:
4078: IF v_debug = 'Y' THEN
4079: -- log start of trigger
4080: 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));
4081: end if;
4082:
4083: -- Select 'before insert into ja_in_oe_order_lines_aiu_trg 12345' into v_trigg_stat from dual;
4084:

Line 4187: 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'));

4183:
4184: -- Added by Aparajita for writing onto the log file
4185: IF v_debug = 'Y' THEN
4186: -- log start of trigger
4187: 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'));
4188: utl_file.put_line(v_myfilehandle,'Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));
4189: utl_file.fclose(v_myfilehandle);
4190: END IF; -- v_debug
4191:

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

4184: -- Added by Aparajita for writing onto the log file
4185: IF v_debug = 'Y' THEN
4186: -- log start of trigger
4187: 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'));
4188: utl_file.put_line(v_myfilehandle,'Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));
4189: utl_file.fclose(v_myfilehandle);
4190: END IF; -- v_debug
4191:
4192: -- Select 'End of trigger ' into v_trigg_stat from dual;

Line 4189: utl_file.fclose(v_myfilehandle);

4185: IF v_debug = 'Y' THEN
4186: -- log start of trigger
4187: 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'));
4188: utl_file.put_line(v_myfilehandle,'Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));
4189: utl_file.fclose(v_myfilehandle);
4190: END IF; -- v_debug
4191:
4192: -- Select 'End of trigger ' into v_trigg_stat from dual;
4193:

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

4194: EXCEPTION
4195: WHEN OTHERS THEN
4196: IF v_debug = 'Y' THEN
4197: -- log start of trigger
4198: utl_file.put_line(v_myfilehandle,'Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));
4199: utl_file.put_line(v_myfilehandle,'Error :' || SQLERRM );
4200: 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'));
4201: utl_file.fclose(v_myfilehandle);
4202: END IF; -- v_debug

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

4195: WHEN OTHERS THEN
4196: IF v_debug = 'Y' THEN
4197: -- log start of trigger
4198: utl_file.put_line(v_myfilehandle,'Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));
4199: utl_file.put_line(v_myfilehandle,'Error :' || SQLERRM );
4200: 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'));
4201: utl_file.fclose(v_myfilehandle);
4202: END IF; -- v_debug
4203:

Line 4200: 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'));

4196: IF v_debug = 'Y' THEN
4197: -- log start of trigger
4198: utl_file.put_line(v_myfilehandle,'Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));
4199: utl_file.put_line(v_myfilehandle,'Error :' || SQLERRM );
4200: 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'));
4201: utl_file.fclose(v_myfilehandle);
4202: END IF; -- v_debug
4203:
4204: --RAISE_APPLICATION_ERROR(-20002, 'ERROR - TRIGGER JA_IN_OE_ORDER_LINES_AIU_TRG : ' || SQLERRM);

Line 4201: utl_file.fclose(v_myfilehandle);

4197: -- log start of trigger
4198: utl_file.put_line(v_myfilehandle,'Header ID ~ Line ID :' || TO_CHAR(pr_new.header_id) || ' ~ ' || TO_CHAR(pr_new.line_id));
4199: utl_file.put_line(v_myfilehandle,'Error :' || SQLERRM );
4200: 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'));
4201: utl_file.fclose(v_myfilehandle);
4202: END IF; -- v_debug
4203:
4204: --RAISE_APPLICATION_ERROR(-20002, 'ERROR - TRIGGER JA_IN_OE_ORDER_LINES_AIU_TRG : ' || SQLERRM);
4205: /* Added an exception block by Ramananda for bug#4570303 */