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_OM_WDD_TRIGGER_PKG dependencies on UTL_FILE

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

1123: v_basic_pla_balance NUMBER;
1124: v_additional_pla_balance NUMBER;
1125: v_other_pla_balance NUMBER;
1126: v_error_message NUMBER; --This is for Capturing the Error Message
1127: v_myfilehandle UTL_FILE.FILE_TYPE; -- This is for File handling
1128: v_utl_location VARCHAR2(512);
1129: v_trip_id NUMBER;
1130: v_debug_flag VARCHAR2(1); --File.Sql.35 Cbabu := 'N'; -- Debug flag made to 'N' by arun iyer 12/03/2003 -- bug # 2828927
1131: --Ends here for Enh2415656

Line 2015: WHERE name = 'utl_file_dir';

2011: SELECT DECODE(SUBSTR (value,1,INSTR(value,',') -1),NULL,
2012: Value,SUBSTR (value,1,INSTR(value,',') -1))
2013: INTO v_utl_location
2014: FROM v$parameter
2015: WHERE name = 'utl_file_dir';
2016: EXCEPTION
2017: WHEN OTHERS THEN
2018: v_debug_flag:='N';
2019: END;

Line 2023: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location,'ja_in_wsh_dlry_dtls_au_trg.LOG','A');

2019: END;
2020: END IF;
2021:
2022: IF v_debug_flag ='Y' THEN
2023: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location,'ja_in_wsh_dlry_dtls_au_trg.LOG','A');
2024: UTL_FILE.PUT_LINE(v_myfilehandle,'************************START************************************');
2025: UTL_FILE.PUT_LINE(v_myfilehandle,'The TIME Stamp this ENTRY IS Created IS ' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS'));
2026: END IF;
2027:

Line 2024: UTL_FILE.PUT_LINE(v_myfilehandle,'START************');

2020: END IF;
2021:
2022: IF v_debug_flag ='Y' THEN
2023: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location,'ja_in_wsh_dlry_dtls_au_trg.LOG','A');
2024: UTL_FILE.PUT_LINE(v_myfilehandle,'************************START************************************');
2025: UTL_FILE.PUT_LINE(v_myfilehandle,'The TIME Stamp this ENTRY IS Created IS ' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS'));
2026: END IF;
2027:
2028: /*

Line 2025: UTL_FILE.PUT_LINE(v_myfilehandle,'The TIME Stamp this ENTRY IS Created IS ' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS'));

2021:
2022: IF v_debug_flag ='Y' THEN
2023: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location,'ja_in_wsh_dlry_dtls_au_trg.LOG','A');
2024: UTL_FILE.PUT_LINE(v_myfilehandle,'************************START************************************');
2025: UTL_FILE.PUT_LINE(v_myfilehandle,'The TIME Stamp this ENTRY IS Created IS ' ||TO_CHAR(SYSDATE,'DD/MM/RRRR HH24:MI:SS'));
2026: END IF;
2027:
2028: /*
2029: || Code added by aiyer for the bug 4035566

Line 2324: UTL_FILE.PUT_LINE(v_myfilehandle,'1 v_basic_excise_duty_amount -> '||v_basic_excise_duty_amount

2320: v_oth_excise_duty_amount := NVL(v_oth_excise_duty_amount,0) + v_tax_amount ;
2321: END IF;
2322:
2323: IF v_debug_flag ='Y' THEN
2324: UTL_FILE.PUT_LINE(v_myfilehandle,'1 v_basic_excise_duty_amount -> '||v_basic_excise_duty_amount
2325: ||', v_add_excise_duty_amount -> '|| v_add_excise_duty_amount
2326: ||', v_oth_excise_duty_amount -> '|| v_oth_excise_duty_amount
2327: );
2328: END IF; --3

Line 2915: UTL_FILE.PUT_LINE(v_myfilehandle,'2 BEFORE the assignment OF v_order_type_id');

2911: OPEN bonded_cur(v_organization_id, v_subinventory);
2912: FETCH bonded_cur INTO v_bonded_flag;
2913: CLOSE bonded_cur;
2914: IF v_debug_flag ='Y' THEN
2915: UTL_FILE.PUT_LINE(v_myfilehandle,'2 BEFORE the assignment OF v_order_type_id');
2916: END IF;
2917: v_order_type_id := v_source_header_type_id;
2918: IF v_debug_flag ='Y' THEN
2919: UTL_FILE.PUT_LINE(v_myfilehandle,'3 v_order_type_id IS '|| v_order_type_id);

Line 2919: UTL_FILE.PUT_LINE(v_myfilehandle,'3 v_order_type_id IS '|| v_order_type_id);

2915: UTL_FILE.PUT_LINE(v_myfilehandle,'2 BEFORE the assignment OF v_order_type_id');
2916: END IF;
2917: v_order_type_id := v_source_header_type_id;
2918: IF v_debug_flag ='Y' THEN
2919: UTL_FILE.PUT_LINE(v_myfilehandle,'3 v_order_type_id IS '|| v_order_type_id);
2920: END IF;
2921:
2922: -- added by sriram - bug # 3021588
2923:

Line 2942: UTL_FILE.PUT_LINE(v_myfilehandle,'4 AFTER the Register Code CURSOR');

2938: */
2939:
2940:
2941: IF v_debug_flag ='Y' THEN
2942: UTL_FILE.PUT_LINE(v_myfilehandle,'4 AFTER the Register Code CURSOR');
2943: END IF;
2944: OPEN fin_year_cur(v_organization_id);
2945: FETCH fin_year_cur INTO v_fin_year;
2946: CLOSE fin_year_cur;

Line 2948: UTL_FILE.PUT_LINE(v_myfilehandle,'5 AFTER the Financial Year CURSOR');

2944: OPEN fin_year_cur(v_organization_id);
2945: FETCH fin_year_cur INTO v_fin_year;
2946: CLOSE fin_year_cur;
2947: IF v_debug_flag ='Y' THEN
2948: UTL_FILE.PUT_LINE(v_myfilehandle,'5 AFTER the Financial Year CURSOR');
2949: END IF;
2950: IF v_delivery_id <> -1 THEN
2951: v_old_register := NULL;
2952: v_old_excise_invoice_no := NULL;

Line 2964: UTL_FILE.PUT_LINE(v_myfilehandle,'6 BEFORE the Preference cursors');

2960: v_tot_excise_amt := v_excise_amount;
2961: IF NVL(v_bonded_flag,'Y') = 'Y'
2962: AND ( NVL(v_tot_excise_amt,0) > 0 OR v_excise_exempt_type IS NOT NULL ) THEN
2963: IF v_debug_flag ='Y' THEN
2964: UTL_FILE.PUT_LINE(v_myfilehandle,'6 BEFORE the Preference cursors');
2965: END IF;
2966: --Changed by Nagaraj.s for Enh#2415656
2967: OPEN pref_cur(v_organization_id, v_location_id);
2968: FETCH pref_cur INTO v_pref_rg23a, v_pref_rg23c, v_pref_pla,v_export_oriented_unit;

Line 2972: UTL_FILE.PUT_LINE(v_myfilehandle,'7 BEFORE the RG Balance CURSOR');

2968: FETCH pref_cur INTO v_pref_rg23a, v_pref_rg23c, v_pref_pla,v_export_oriented_unit;
2969: CLOSE pref_cur;
2970: ----Changed by Nagaraj.s for Enh#2415656
2971: IF v_debug_flag ='Y' THEN
2972: UTL_FILE.PUT_LINE(v_myfilehandle,'7 BEFORE the RG Balance CURSOR');
2973: END IF;
2974: OPEN rg_bal_cur(v_organization_id, v_location_id);
2975: FETCH rg_bal_cur INTO v_rg23a_balance, v_rg23c_balance, v_pla_balance,
2976: v_basic_pla_balance,v_additional_pla_balance,v_other_pla_balance;

Line 2979: UTL_FILE.PUT_LINE(v_myfilehandle,'8 BEFORE the SSI Unit Flag CURSOR');

2975: FETCH rg_bal_cur INTO v_rg23a_balance, v_rg23c_balance, v_pla_balance,
2976: v_basic_pla_balance,v_additional_pla_balance,v_other_pla_balance;
2977: CLOSE rg_bal_cur;
2978: IF v_debug_flag ='Y' THEN
2979: UTL_FILE.PUT_LINE(v_myfilehandle,'8 BEFORE the SSI Unit Flag CURSOR');
2980: END IF;
2981: OPEN ssi_unit_flag_cur(v_organization_id, v_location_id);
2982: FETCH ssi_unit_flag_cur INTO v_ssi_unit_flag;
2983: CLOSE ssi_unit_flag_cur;

Line 2985: UTL_FILE.PUT_LINE(v_myfilehandle,'9 BEFORE the Register Code CURSOR');

2981: OPEN ssi_unit_flag_cur(v_organization_id, v_location_id);
2982: FETCH ssi_unit_flag_cur INTO v_ssi_unit_flag;
2983: CLOSE ssi_unit_flag_cur;
2984: IF v_debug_flag ='Y' THEN
2985: UTL_FILE.PUT_LINE(v_myfilehandle,'9 BEFORE the Register Code CURSOR');
2986: END IF;
2987:
2988:
2989: -- added by sriram - bug # 3021588

Line 3018: UTL_FILE.PUT_LINE(v_myfilehandle,'10 BEFORE the jai_om_wsh_processing_pkg.excise_balance_check FUNCTION');

3014: 'CT2_OTH', 'EXCISE_EXEMPT_CERT_OTH','CT3' ) THEN
3015: --***************************************************************************************************
3016: --Calling the Function by Nagaraj.s for Enh#2415656............................
3017: IF v_debug_flag ='Y' THEN
3018: UTL_FILE.PUT_LINE(v_myfilehandle,'10 BEFORE the jai_om_wsh_processing_pkg.excise_balance_check FUNCTION');
3019: UTL_FILE.FCLOSE(v_myfilehandle);
3020: END IF;
3021:
3022: open c_cess_amount(v_delivery_id);

Line 3019: UTL_FILE.FCLOSE(v_myfilehandle);

3015: --***************************************************************************************************
3016: --Calling the Function by Nagaraj.s for Enh#2415656............................
3017: IF v_debug_flag ='Y' THEN
3018: UTL_FILE.PUT_LINE(v_myfilehandle,'10 BEFORE the jai_om_wsh_processing_pkg.excise_balance_check FUNCTION');
3019: UTL_FILE.FCLOSE(v_myfilehandle);
3020: END IF;
3021:
3022: open c_cess_amount(v_delivery_id);
3023: fetch c_cess_amount into ln_cess_amount;

Line 3061: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location,'ja_in_wsh_dlry_dtls_au_trg.LOG','A');

3057: lv_process_message
3058: );
3059: --Ends here......................................
3060: IF v_debug_flag ='Y' THEN
3061: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location,'ja_in_wsh_dlry_dtls_au_trg.LOG','A');
3062: UTL_FILE.PUT_LINE(v_myfilehandle,'11 AFTER the jai_om_wsh_processing_pkg.excise_balance_check FUNCTION v_reg_type -> ' || v_reg_type);
3063: END IF;
3064: --***************************************************************************************************
3065: ELSE

Line 3062: UTL_FILE.PUT_LINE(v_myfilehandle,'11 AFTER the jai_om_wsh_processing_pkg.excise_balance_check FUNCTION v_reg_type -> ' || v_reg_type);

3058: );
3059: --Ends here......................................
3060: IF v_debug_flag ='Y' THEN
3061: v_myfilehandle := UTL_FILE.FOPEN(v_utl_location,'ja_in_wsh_dlry_dtls_au_trg.LOG','A');
3062: UTL_FILE.PUT_LINE(v_myfilehandle,'11 AFTER the jai_om_wsh_processing_pkg.excise_balance_check FUNCTION v_reg_type -> ' || v_reg_type);
3063: END IF;
3064: --***************************************************************************************************
3065: ELSE
3066: OPEN get_item_dtls(v_organization_id,v_inventory_item_id);

Line 3082: UTL_FILE.PUT_LINE(v_myfilehandle,'12 BEFORE the jai_om_wsh_pkg.get_excise_register_with_bal FUNCTION v_exempt_bal -> '|| v_exempt_bal);

3078: END IF;
3079: v_exempt_bal := (NVL(v_exempt_bal, 0) + v_shipped_quantity * v_assessable_value * NVL(v_modvat_tax_rate,0))/100;
3080: --*********************************************************************************************************
3081: IF v_debug_flag ='Y' THEN
3082: UTL_FILE.PUT_LINE(v_myfilehandle,'12 BEFORE the jai_om_wsh_pkg.get_excise_register_with_bal FUNCTION v_exempt_bal -> '|| v_exempt_bal);
3083: END IF;
3084: --Calling the Function by Nagaraj.s for Enh#2415656............................
3085:
3086: /*

Line 3130: UTL_FILE.PUT_LINE(v_myfilehandle,'13 AFTER the jai_om_wsh_pkg.get_excise_register_with_bal FUNCTION v_reg_type -> '|| v_reg_type);

3126: lv_process_message
3127: );
3128: --Ends here......................................
3129: IF v_debug_flag ='Y' THEN
3130: UTL_FILE.PUT_LINE(v_myfilehandle,'13 AFTER the jai_om_wsh_pkg.get_excise_register_with_bal FUNCTION v_reg_type -> '|| v_reg_type);
3131: END IF;
3132: --*********************************************************************************************************
3133: v_basic_ed_amt := v_exempt_bal;
3134: v_tot_basic_ed_amt := NVL(v_tot_basic_ed_amt,0) + v_exempt_bal;

Line 3137: UTL_FILE.PUT_LINE(v_myfilehandle,'14 v_basic_ed_amt -> '|| v_basic_ed_amt||', v_tot_basic_ed_amt -> '|| v_tot_basic_ed_amt);

3133: v_basic_ed_amt := v_exempt_bal;
3134: v_tot_basic_ed_amt := NVL(v_tot_basic_ed_amt,0) + v_exempt_bal;
3135: v_remarks := 'Against Modvat Recovery'||'-'||v_excise_exempt_refno;
3136: IF v_debug_flag ='Y' THEN
3137: UTL_FILE.PUT_LINE(v_myfilehandle,'14 v_basic_ed_amt -> '|| v_basic_ed_amt||', v_tot_basic_ed_amt -> '|| v_tot_basic_ed_amt);
3138: UTL_FILE.FCLOSE(v_myfilehandle);
3139: END IF;
3140: END IF;
3141: END IF;

Line 3138: UTL_FILE.FCLOSE(v_myfilehandle);

3134: v_tot_basic_ed_amt := NVL(v_tot_basic_ed_amt,0) + v_exempt_bal;
3135: v_remarks := 'Against Modvat Recovery'||'-'||v_excise_exempt_refno;
3136: IF v_debug_flag ='Y' THEN
3137: UTL_FILE.PUT_LINE(v_myfilehandle,'14 v_basic_ed_amt -> '|| v_basic_ed_amt||', v_tot_basic_ed_amt -> '|| v_tot_basic_ed_amt);
3138: UTL_FILE.FCLOSE(v_myfilehandle);
3139: END IF;
3140: END IF;
3141: END IF;
3142: END IF;