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_WSH_PKG dependencies on FND_FILE

Line 1196: Fnd_File.PUT_LINE(Fnd_File.LOG, ' 1 START Delivery id = ' || p_delivery_id );

1192: v_ref_25 := 'delivery_id'; -- holds the column name -- 'delivery_id';
1193: /* Ramananda for File.Sql.35 */
1194:
1195: lv_block_no := '0';
1196: Fnd_File.PUT_LINE(Fnd_File.LOG, ' 1 START Delivery id = ' || p_delivery_id );
1197: FOR Each_record IN
1198: (
1199: SELECT *
1200: FROM JAI_OM_OE_GEN_TAXINV_T ja_tmp

Line 1235: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'2 Each_record.Delivery detail id = ' || Each_record.delivery_detail_id );

1231: CLOSE c_conc_request_submit_date;
1232: /* Ends here Bug 4562791. Added by Lakshmi Gopalsami */
1233:
1234: v_ref_10 := v_std_text || v_ord_num; -- instead of appending v_ref_10 every time , appending the so# to the standard text instead.-- bug # 3158976
1235: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'2 Each_record.Delivery detail id = ' || Each_record.delivery_detail_id );
1236: v_tax_rate := 0; --2001/08/07 Jagdish
1237: lv_statement_no := '1';
1238:
1239: OPEN get_delivery_status(each_record.delivery_id);

Line 1300: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'4 v_register = ' || v_register

1296: FETCH c_excise_tax_cnt INTO ln_excise_tax_cnt ;
1297: CLOSE c_excise_tax_cnt;
1298:
1299:
1300: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'4 v_register = ' || v_register
1301: ||', v_order_type_id = ' || v_order_type_id ||', v_excise_exempt_type = ' || v_excise_exempt_type
1302: );
1303:
1304: IF v_register IS NULL THEN --z999

Line 1314: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'7 v_set_of_books_id = ' || v_set_of_books_id);

1310: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
1311: (p_org_id => v_organization_id );
1312: v_set_of_books_id := l_func_curr_det.ledger_id;
1313:
1314: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'7 v_set_of_books_id = ' || v_set_of_books_id);
1315: lv_statement_no := '7';
1316:
1317: /*
1318: Code changed by aiyer for the bug #3139718.

Line 1355: fnd_file.put_line( fnd_file.log,

1351: OPEN bonded_cur(v_organization_id, v_subinventory) ;
1352: FETCH bonded_cur INTO v_bonded_flag,v_trading_flag ;
1353: CLOSE bonded_cur ;
1354:
1355: fnd_file.put_line( fnd_file.log,
1356: p_delivery_id||', '||'8 v_organization_id = ' || v_organization_id
1357: ||', v_subinventory = ' || v_subinventory ||', v_bonded_flag = ' || v_bonded_flag
1358: ||', v_trading_flag = ' || v_trading_flag
1359: );

Line 1366: fnd_file.put_line( fnd_file.log,'Subinventory '||v_subinventory ||' is neither bonded nor Tradable.Hence Excise Invoice Number cannot be generated.');

1362:
1363: --start additions for bug#8904363
1364: if nvl( v_bonded_flag,'X')='N' and nvl(v_trading_flag,'X')='N'
1365: then
1366: fnd_file.put_line( fnd_file.log,'Subinventory '||v_subinventory ||' is neither bonded nor Tradable.Hence Excise Invoice Number cannot be generated.');
1367: end if;
1368: --end additions for bug#8904363
1369:
1370:

Line 1387: fnd_file.put_line(

1383: ); -- out parameter to get the register code
1384:
1385:
1386:
1387: fnd_file.put_line(
1388: fnd_file.log,
1389: p_delivery_id||', '||', v_register_code = ' || v_register_code
1390: );
1391: lv_statement_no := '10';

Line 1388: fnd_file.log,

1384:
1385:
1386:
1387: fnd_file.put_line(
1388: fnd_file.log,
1389: p_delivery_id||', '||', v_register_code = ' || v_register_code
1390: );
1391: lv_statement_no := '10';
1392: OPEN fin_year_cur(v_organization_id);

Line 1416: fnd_file.put_line(fnd_file.log, p_delivery_id||', '||'ERROR - MODVAT REVERSAL% SHOULD BE DEFINED IN ORGANIZATION ADDITIONAL INFORMATION ');

1412:
1413:
1414: --Added the below by kunkumar for bug#6121833
1415: IF v_modvat_tax_rate IS NULL THEN --removed the nvl condition for bug#7647742 because even if modvat rate is 0 it gives the error
1416: fnd_file.put_line(fnd_file.log, p_delivery_id||', '||'ERROR - MODVAT REVERSAL% SHOULD BE DEFINED IN ORGANIZATION ADDITIONAL INFORMATION ');
1417: errbuf := 'Error - MODVAT Reversal% should be defined in Organization Additional Information';
1418: retcode := 2; --to signal an error.
1419: return;
1420: END IF;

Line 1426: fnd_file.put_line(fnd_file.log, p_delivery_id||', '||'8.01 v_exempt_bal = ' || v_exempt_bal);

1422: END IF;
1423: END IF;
1424:
1425: lv_statement_no := '19';
1426: fnd_file.put_line(fnd_file.log, p_delivery_id||', '||'8.01 v_exempt_bal = ' || v_exempt_bal);
1427: v_exempt_bal := NVL(v_exempt_bal, 0) +( v_shp_qty * v_assessable_value * NVL(v_modvat_tax_rate,0))/100;
1428: fnd_file.put_line(fnd_file.log, p_delivery_id||', '||'8.02 v_exempt_bal = ' || v_exempt_bal);
1429: end if;
1430:

Line 1428: fnd_file.put_line(fnd_file.log, p_delivery_id||', '||'8.02 v_exempt_bal = ' || v_exempt_bal);

1424:
1425: lv_statement_no := '19';
1426: fnd_file.put_line(fnd_file.log, p_delivery_id||', '||'8.01 v_exempt_bal = ' || v_exempt_bal);
1427: v_exempt_bal := NVL(v_exempt_bal, 0) +( v_shp_qty * v_assessable_value * NVL(v_modvat_tax_rate,0))/100;
1428: fnd_file.put_line(fnd_file.log, p_delivery_id||', '||'8.02 v_exempt_bal = ' || v_exempt_bal);
1429: end if;
1430:
1431: /* following 3 lines of code added by bgowrava for Bug#5554420 */
1432: if nvl(v_old_delivery_id,0) <> nvl(each_record.delivery_id,-1)

Line 1448: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', 9 v_fin_year = ' || v_fin_year

1444: CLOSE get_prev_del_dtl;
1445: end if;
1446:
1447:
1448: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', 9 v_fin_year = ' || v_fin_year
1449: ||', v_old_delivery_id = ' || v_old_delivery_id );
1450: IF NVL(v_old_delivery_id,0) <> NVL(each_record.delivery_id,-1)
1451: or lv_exc_inv_gen_for_dlry_flag = 'N' /* condition added by bgowrava for bug#5554420 */
1452: THEN --f999

Line 1463: fnd_file.put_line(

1459: FETCH get_prev_del_dtl INTO v_old_register, v_old_excise_invoice_no;
1460: CLOSE get_prev_del_dtl;
1461: */
1462:
1463: fnd_file.put_line(
1464: fnd_file.log,
1465: p_delivery_id||', '||'15 v_old_register = ' || v_old_register
1466: ||', v_old_excise_invoice_no = ' || v_old_excise_invoice_no
1467: );

Line 1464: fnd_file.log,

1460: CLOSE get_prev_del_dtl;
1461: */
1462:
1463: fnd_file.put_line(
1464: fnd_file.log,
1465: p_delivery_id||', '||'15 v_old_register = ' || v_old_register
1466: ||', v_old_excise_invoice_no = ' || v_old_excise_invoice_no
1467: );
1468:

Line 1510: fnd_file.put_line(

1506: FETCH get_total_excise_amt INTO v_tot_basic_ed_amt, v_tot_addl_ed_amt, v_tot_oth_ed_amt, v_tot_excise_amt;
1507: CLOSE get_total_excise_amt;
1508:
1509:
1510: fnd_file.put_line(
1511: fnd_file.log,
1512: p_delivery_id||', 17 v_tot_excise_amt = ' || v_tot_excise_amt
1513: ||', v_tot_basic_ed_amt = ' || v_tot_basic_ed_amt ||', v_tot_addl_ed_amt = ' || v_tot_addl_ed_amt
1514: ||', v_tot_oth_ed_amt = ' || v_tot_oth_ed_amt

Line 1511: fnd_file.log,

1507: CLOSE get_total_excise_amt;
1508:
1509:
1510: fnd_file.put_line(
1511: fnd_file.log,
1512: p_delivery_id||', 17 v_tot_excise_amt = ' || v_tot_excise_amt
1513: ||', v_tot_basic_ed_amt = ' || v_tot_basic_ed_amt ||', v_tot_addl_ed_amt = ' || v_tot_addl_ed_amt
1514: ||', v_tot_oth_ed_amt = ' || v_tot_oth_ed_amt
1515: || ',v_mod_basic_ed_amt =' || v_mod_basic_ed_amt

Line 1529: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'18 v_pref_rg23a = ' || v_pref_rg23a ||', v_pref_rg23c = ' || v_pref_rg23c ||', v_pref_pla = ' || v_pref_pla );

1525: --Changed by Nagaraj.s for Enh#2415656
1526: OPEN pref_cur(v_organization_id, v_location_id);
1527: FETCH pref_cur INTO v_pref_rg23a, v_pref_rg23c, v_pref_pla,v_export_oriented_unit;
1528: CLOSE pref_cur;
1529: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'18 v_pref_rg23a = ' || v_pref_rg23a ||', v_pref_rg23c = ' || v_pref_rg23c ||', v_pref_pla = ' || v_pref_pla );
1530:
1531: lv_statement_no := '14';
1532: ----Changed by Nagaraj.s for Enh#2415656
1533: OPEN rg_bal_cur(v_organization_id, v_location_id);

Line 1538: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'19 v_rg23a_bala = ' || v_rg23a_balance ||', v_rg23c_bal = '

1534: FETCH rg_bal_cur INTO v_rg23a_balance, v_rg23c_balance, v_pla_balance,
1535: v_basic_pla_balance,v_additional_pla_balance,v_other_pla_balance;
1536: CLOSE rg_bal_cur;
1537:
1538: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'19 v_rg23a_bala = ' || v_rg23a_balance ||', v_rg23c_bal = '
1539: || v_rg23c_balance ||', v_pla_balae = ' || v_pla_balance );
1540:
1541: lv_statement_no := '15';
1542: OPEN ssi_unit_flag_cur(v_organization_id, v_location_id);

Line 1610: fnd_file.put_line(fnd_file.log, p_delivery_id||', '||'18.1 The Value OF v_reg_type IS '|| v_reg_type);

1606: lv_process_flag ,
1607: lv_process_message
1608: );
1609:
1610: fnd_file.put_line(fnd_file.log, p_delivery_id||', '||'18.1 The Value OF v_reg_type IS '|| v_reg_type);
1611: --**************************************************************************************************************************
1612: ELSE
1613: IF v_item_class NOT IN ('OTIN', 'OTEX') THEN
1614:

Line 1652: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'23 v_raise_exempt_flag = ' || v_raise_exempt_flag);

1648: lv_process_message
1649: );
1650: --Ends here......................................
1651: -------------------------------------------------------------------------------------------------------------------
1652: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'23 v_raise_exempt_flag = ' || v_raise_exempt_flag);
1653: v_basic_ed_amt := v_exempt_bal;
1654: v_tot_basic_ed_amt := NVL(v_tot_basic_ed_amt,0) + nvl(v_mod_basic_ed_amt,0) ; --+ v_exempt_bal; -- bug# 3207685
1655: v_remarks := 'Against Modvat Recovery'||'-'||v_excise_exempt_refno;
1656: --2001/11/01 Anuradha Parthasarathy

Line 1676: Fnd_File.PUT_LINE(Fnd_File.LOG,'Error Occured - The Validity Period of the Bond Register ' || v_register_exp_date || ' has lapsed');

1672: v_lou_flag
1673: );
1674:
1675: if nvl(v_register_exp_date,sysdate) < sysdate then
1676: Fnd_File.PUT_LINE(Fnd_File.LOG,'Error Occured - The Validity Period of the Bond Register ' || v_register_exp_date || ' has lapsed');
1677: RAISE_APPLICATION_ERROR(-20121,'The Validity Period of the Bond Register has lapsed');
1678: end if;
1679:
1680:

Line 1681: Fnd_File.PUT_LINE(Fnd_File.LOG,'LOU FLAG is ' || NVL(v_lou_flag,'N'));

1677: RAISE_APPLICATION_ERROR(-20121,'The Validity Period of the Bond Register has lapsed');
1678: end if;
1679:
1680:
1681: Fnd_File.PUT_LINE(Fnd_File.LOG,'LOU FLAG is ' || NVL(v_lou_flag,'N'));
1682:
1683: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'24 v_bond_tax_amount = ' || v_bond_tax_amount||' , v_register_balance = ' || v_register_balance );
1684:
1685: IF ( (nvl(v_lou_flag,'N') = 'N') and (NVL(v_register_balance,0) < NVL(v_tot_excise_amt,0)) ) THEN

Line 1683: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'24 v_bond_tax_amount = ' || v_bond_tax_amount||' , v_register_balance = ' || v_register_balance );

1679:
1680:
1681: Fnd_File.PUT_LINE(Fnd_File.LOG,'LOU FLAG is ' || NVL(v_lou_flag,'N'));
1682:
1683: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'24 v_bond_tax_amount = ' || v_bond_tax_amount||' , v_register_balance = ' || v_register_balance );
1684:
1685: IF ( (nvl(v_lou_flag,'N') = 'N') and (NVL(v_register_balance,0) < NVL(v_tot_excise_amt,0)) ) THEN
1686:
1687: Fnd_File.PUT_LINE(Fnd_File.LOG,'Error Occured - Bonded Register Has Balance -> ' || TO_CHAR(v_register_balance)

Line 1687: Fnd_File.PUT_LINE(Fnd_File.LOG,'Error Occured - Bonded Register Has Balance -> ' || TO_CHAR(v_register_balance)

1683: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'24 v_bond_tax_amount = ' || v_bond_tax_amount||' , v_register_balance = ' || v_register_balance );
1684:
1685: IF ( (nvl(v_lou_flag,'N') = 'N') and (NVL(v_register_balance,0) < NVL(v_tot_excise_amt,0)) ) THEN
1686:
1687: Fnd_File.PUT_LINE(Fnd_File.LOG,'Error Occured - Bonded Register Has Balance -> ' || TO_CHAR(v_register_balance)
1688: || ' ,which IS less than Excisable Amount -> ' || TO_CHAR(v_tot_excise_amt));
1689:
1690: RAISE_APPLICATION_ERROR(-20120, 'Bonded Register Has Balance -> ' || TO_CHAR(v_register_balance)
1691: || ' ,which IS less than Excisable Amount -> ' || TO_CHAR(v_tot_excise_amt));

Line 1728: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'25 v_meaning = ' || v_meaning);

1724: lv_statement_no := '21';
1725: OPEN register_code_meaning_cur(v_register_code,'JAI_REGISTER_TYPE'); /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
1726: FETCH register_code_meaning_cur INTO v_meaning;
1727: CLOSE register_code_meaning_cur;
1728: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'25 v_meaning = ' || v_meaning);
1729:
1730: lv_statement_no := '22';
1731: OPEN fin_year_cur(v_organization_id);
1732: FETCH fin_year_cur INTO v_fin_year;

Line 1746: fnd_file.put_line(fnd_file.log,'Calling the Excise Invoice Generation procedure with following parameters ');

1742:
1743: IF NVL(ln_number_of_Taxes,0) > 0 THEN /*Bug 5403048 End*/
1744: -- procedure call to the excise invoice number generation procedure added by sriram bug # 2663211
1745:
1746: fnd_file.put_line(fnd_file.log,'Calling the Excise Invoice Generation procedure with following parameters ');
1747: fnd_file.put_line(fnd_file.log,' Organization_id => ' || v_organization_id || ' Location_id => ' || v_location_id);
1748: fnd_file.put_line(fnd_file.log,'Order Type id => ' || v_order_type_id || 'Fin Year => ' || v_fin_year);
1749:
1750:

Line 1747: fnd_file.put_line(fnd_file.log,' Organization_id => ' || v_organization_id || ' Location_id => ' || v_location_id);

1743: IF NVL(ln_number_of_Taxes,0) > 0 THEN /*Bug 5403048 End*/
1744: -- procedure call to the excise invoice number generation procedure added by sriram bug # 2663211
1745:
1746: fnd_file.put_line(fnd_file.log,'Calling the Excise Invoice Generation procedure with following parameters ');
1747: fnd_file.put_line(fnd_file.log,' Organization_id => ' || v_organization_id || ' Location_id => ' || v_location_id);
1748: fnd_file.put_line(fnd_file.log,'Order Type id => ' || v_order_type_id || 'Fin Year => ' || v_fin_year);
1749:
1750:
1751: jai_cmn_setup_pkg.generate_excise_invoice_no(v_organization_id,v_location_id,'O',v_order_type_id,v_fin_year,v_exc_invoice_no,ERRBUF);

Line 1748: fnd_file.put_line(fnd_file.log,'Order Type id => ' || v_order_type_id || 'Fin Year => ' || v_fin_year);

1744: -- procedure call to the excise invoice number generation procedure added by sriram bug # 2663211
1745:
1746: fnd_file.put_line(fnd_file.log,'Calling the Excise Invoice Generation procedure with following parameters ');
1747: fnd_file.put_line(fnd_file.log,' Organization_id => ' || v_organization_id || ' Location_id => ' || v_location_id);
1748: fnd_file.put_line(fnd_file.log,'Order Type id => ' || v_order_type_id || 'Fin Year => ' || v_fin_year);
1749:
1750:
1751: jai_cmn_setup_pkg.generate_excise_invoice_no(v_organization_id,v_location_id,'O',v_order_type_id,v_fin_year,v_exc_invoice_no,ERRBUF);
1752:

Line 1753: fnd_file.put_line(fnd_file.log,'After Call to the procedure output values are following');

1749:
1750:
1751: jai_cmn_setup_pkg.generate_excise_invoice_no(v_organization_id,v_location_id,'O',v_order_type_id,v_fin_year,v_exc_invoice_no,ERRBUF);
1752:
1753: fnd_file.put_line(fnd_file.log,'After Call to the procedure output values are following');
1754: fnd_file.put_line(fnd_file.log,'Excise Invoice Number generated => ' || v_exc_invoice_no);
1755:
1756: IF ERRBUF IS NOT NULL THEN
1757: Fnd_File.PUT_LINE(Fnd_File.LOG,'Error Message in the excise invoice generation procedure is => ' || ERRBUF);

Line 1754: fnd_file.put_line(fnd_file.log,'Excise Invoice Number generated => ' || v_exc_invoice_no);

1750:
1751: jai_cmn_setup_pkg.generate_excise_invoice_no(v_organization_id,v_location_id,'O',v_order_type_id,v_fin_year,v_exc_invoice_no,ERRBUF);
1752:
1753: fnd_file.put_line(fnd_file.log,'After Call to the procedure output values are following');
1754: fnd_file.put_line(fnd_file.log,'Excise Invoice Number generated => ' || v_exc_invoice_no);
1755:
1756: IF ERRBUF IS NOT NULL THEN
1757: Fnd_File.PUT_LINE(Fnd_File.LOG,'Error Message in the excise invoice generation procedure is => ' || ERRBUF);
1758: retcode :=2; --to signal an error.

Line 1757: Fnd_File.PUT_LINE(Fnd_File.LOG,'Error Message in the excise invoice generation procedure is => ' || ERRBUF);

1753: fnd_file.put_line(fnd_file.log,'After Call to the procedure output values are following');
1754: fnd_file.put_line(fnd_file.log,'Excise Invoice Number generated => ' || v_exc_invoice_no);
1755:
1756: IF ERRBUF IS NOT NULL THEN
1757: Fnd_File.PUT_LINE(Fnd_File.LOG,'Error Message in the excise invoice generation procedure is => ' || ERRBUF);
1758: retcode :=2; --to signal an error.
1759: v_ret_stat := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',ERRBUF);
1760: return;
1761: END IF;

Line 1767: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Excise Invoice Not Generated for delivery_detail_id : ' || each_record.delivery_detail_id || ' since there are no Excise Taxes ');

1763: lv_exc_inv_gen_for_dlry_flag := 'Y'; --added by csahoo for bug#6077065
1764:
1765: /*Bug 5403048 Start*/
1766: ELSE
1767: Fnd_File.PUT_LINE(Fnd_File.LOG, 'Excise Invoice Not Generated for delivery_detail_id : ' || each_record.delivery_detail_id || ' since there are no Excise Taxes ');
1768: END IF;
1769: /*Bug 5403048 End*/
1770: END IF; --d999 --1
1771: ELSE

Line 1774: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'41 v_reg_type= ' ||v_reg_type);

1770: END IF; --d999 --1
1771: ELSE
1772: v_reg_type := v_old_register;
1773: v_exc_invoice_no := v_old_excise_invoice_no;
1774: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'41 v_reg_type= ' ||v_reg_type);
1775: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'41 v_exc_invoice_no= ' ||v_exc_invoice_no);
1776: END IF; --e999
1777: END IF; --f999
1778:

Line 1775: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'41 v_exc_invoice_no= ' ||v_exc_invoice_no);

1771: ELSE
1772: v_reg_type := v_old_register;
1773: v_exc_invoice_no := v_old_excise_invoice_no;
1774: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'41 v_reg_type= ' ||v_reg_type);
1775: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'41 v_exc_invoice_no= ' ||v_exc_invoice_no);
1776: END IF; --e999
1777: END IF; --f999
1778:
1779: lv_statement_no := '29';

Line 1851: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'42 v_item_class= ' ||v_item_class);

1847: -- hits the registers.
1848: --The amounts which are taken care are: v_basic_ed_amt,v_oth_ed_amt,
1849: --v_addl_ed_amt, v_tot_basic_ed_amt .......................
1850:
1851: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'42 v_item_class= ' ||v_item_class);
1852: IF v_register_code IS NOT NULL AND NVL(v_bonded_flag,'N') = 'Y' THEN --g999 --1
1853:
1854: /*
1855: || Start of bug 4566054

Line 1955: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', 42.1 ja_in_rg_I_entry is made register_id -> ' || v_part_i_register_id );

1951: );
1952:
1953: lv_statement_no := '31';
1954: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_part_i_register_id FROM dual;
1955: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', 42.1 ja_in_rg_I_entry is made register_id -> ' || v_part_i_register_id );
1956: ELSIF v_item_class IN ('CGEX','CGIN') THEN
1957: v_qty_reg_type := 'C';
1958:
1959: ELSIF v_item_class IN ('RMIN','RMEX') THEN

Line 2006: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', 42.2 ja_in_rg23_part_I_entry is made, register_id -> ' || v_part_i_register_id );

2002: v_last_update_login
2003: );
2004: lv_statement_no := '33';
2005: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_part_i_register_id FROM dual;
2006: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', 42.2 ja_in_rg23_part_I_entry is made, register_id -> ' || v_part_i_register_id );
2007: END IF;
2008: END IF;
2009: -- Start of Bug 3446362
2010: /*

Line 2023: fnd_file.put_line( fnd_file.log, p_delivery_id||', '||'44 v_old_delivery_id = ' ||v_old_delivery_id

2019: OPEN c_ct3_flag_exists;
2020: FETCH c_ct3_flag_exists INTO ln_count;
2021: CLOSE c_ct3_flag_exists;
2022:
2023: fnd_file.put_line( fnd_file.log, p_delivery_id||', '||'44 v_old_delivery_id = ' ||v_old_delivery_id
2024: ||', 45 v_old_register = ' ||v_old_register||', 46 v_reg_type = ' ||v_reg_type
2025: ||', 47 value of ln_count '||ln_count
2026: );
2027:

Line 2089: fnd_file.put_line(fnd_file.log, p_delivery_id||', 46.1 ja_in_rg23_part_II_entry is made, v_exc_invoice_no -> ' || v_exc_invoice_no );

2085: v_ref_25 , -- bug # 2769440
2086: v_ref_26 -- bug # 2769440
2087: );
2088:
2089: fnd_file.put_line(fnd_file.log, p_delivery_id||', 46.1 ja_in_rg23_part_II_entry is made, v_exc_invoice_no -> ' || v_exc_invoice_no );
2090: ELSIF v_reg_type IN ('PLA') THEN
2091: lv_statement_no := '35';
2092:
2093: /*

Line 2131: fnd_file.put_line(fnd_file.log, p_delivery_id||', 46.2 ja_in_pla_entry is made, v_exc_invoice_no -> ' || v_exc_invoice_no );

2127: v_ref_24 , -- bug # 2769440
2128: v_ref_25 , -- bug # 2769440
2129: v_ref_26 -- bug # 2769440
2130: );
2131: fnd_file.put_line(fnd_file.log, p_delivery_id||', 46.2 ja_in_pla_entry is made, v_exc_invoice_no -> ' || v_exc_invoice_no );
2132: END IF;
2133: -- END IF; /* commented by bgowrava for forward porting Bug#5554420 */
2134: END IF;
2135:

Line 2208: fnd_file.put_line(fnd_file.log, p_delivery_id||', 46.3 v_rg23_part_ii_no -> ' || v_rg23_part_ii_no||', v_pla_register_no -> ' || v_pla_register_no );

2204: WHERE register_id = v_rg23_part_i_no;
2205: END IF;
2206: END IF;
2207:
2208: fnd_file.put_line(fnd_file.log, p_delivery_id||', 46.3 v_rg23_part_ii_no -> ' || v_rg23_part_ii_no||', v_pla_register_no -> ' || v_pla_register_no );
2209: --2001/04/09 Manohar Mishra
2210: --Changed the cases
2211: IF NVL(v_register_code,'N') IN ('BOND_REG') AND
2212: NVL(v_old_delivery_id,0) <> NVL(each_record.delivery_id,-1) -- bug2389773 cbabu 24/02/2002. new check added

Line 2266: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', 48.1 v_register_code -> ' || v_register_code

2262: OPEN bonded_cur(v_organization_id, v_subinventory);
2263: FETCH bonded_cur INTO v_bonded_flag, v_trading_flag;
2264: CLOSE bonded_cur;
2265:
2266: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', 48.1 v_register_code -> ' || v_register_code
2267: ||', v_trading_flag -> ' || v_trading_flag ||', v_item_trading_flag -> ' || v_item_trading_flag
2268: );
2269:
2270: /*

Line 2329: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', 49.1 quantity_applied -> ' || match_rec.quantity_applied

2325:
2326:
2327: FOR match_rec IN matched_receipt_cur(each_record.delivery_detail_id) LOOP -- cbabu for Bug# 2736191
2328:
2329: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', 49.1 quantity_applied -> ' || match_rec.quantity_applied
2330: ||', receipt_id -> ' || match_rec.receipt_id
2331: );
2332:
2333: lv_statement_no := '58';

Line 2347: fnd_file.put_line(fnd_file.log, p_delivery_id||', 49.2 v_register_id -> ' || v_register_id

2343: END IF;
2344: --End bug 7043292
2345: v_total_quantity_applied := v_total_quantity_applied + match_rec.quantity_applied;
2346:
2347: fnd_file.put_line(fnd_file.log, p_delivery_id||', 49.2 v_register_id -> ' || v_register_id
2348: ||', v_exc_invoice_no -> ' || v_exc_invoice_no||', v_receipt_id -> ' || v_receipt_id
2349: ||', v_quantity_applied -> ' || v_quantity_applied||', v_qty_to_adjust -> ' || v_qty_to_adjust
2350: ||', v_excise_duty_rate -> ' || v_excise_duty_rate||', v_rate_per_unit -> ' || v_rate_per_unit
2351: ||', v_source_line_id -> ' || v_source_line_id||', v_source_header_id -> ' || v_source_header_id

Line 2472: fnd_file.put_line( fnd_file.log,

2468: END LOOP;
2469: --added by cbabu 27/03/02
2470: lv_statement_no := '62';
2471: --COMMIT;
2472: fnd_file.put_line( fnd_file.log,
2473: p_delivery_id||', '||'61 v_no_records_fetched = '||v_no_records_fetched
2474: ||', END OF deliver_id = '||p_delivery_id
2475: );
2476:

Line 2494: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||' Error occured = ' || lv_error_mesg);

2490: ROLLBACK;
2491: lv_error_mesg := SQLERRM;
2492: ERRBUF := lv_error_mesg;
2493: RETCODE := '2';
2494: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||' Error occured = ' || lv_error_mesg);
2495: INSERT INTO JAI_CMN_ERRORS_T (
2496: APPLICATION_SOURCE ,
2497: error_message ,
2498: additional_error_mesg ,

Line 3024: fnd_file.put_line ( fnd_file.log , ' After call to jai_om_wsh_pkg.process_delivery with delivery id => ' || pn_delivery_id || ' return code => ' || retcode);

3020: jai_om_wsh_pkg.process_delivery ( errbuf ,
3021: retcode ,
3022: pn_delivery_id
3023: ) ;
3024: fnd_file.put_line ( fnd_file.log , ' After call to jai_om_wsh_pkg.process_delivery with delivery id => ' || pn_delivery_id || ' return code => ' || retcode);
3025: IF nvl(retcode,'0') <> '0' THEN
3026: ln_error_occured := 1;
3027: ln_success := 0;
3028: Rollback;

Line 3029: fnd_file.put_line ( fnd_file.log , 'delivery_id => ' || pn_delivery_id || 'Error is ' || errbuf ) ;

3025: IF nvl(retcode,'0') <> '0' THEN
3026: ln_error_occured := 1;
3027: ln_success := 0;
3028: Rollback;
3029: fnd_file.put_line ( fnd_file.log , 'delivery_id => ' || pn_delivery_id || 'Error is ' || errbuf ) ;
3030: else
3031:
3032: commit;
3033: ln_success := 1;

Line 3046: fnd_file.put_line ( fnd_file.log , ' Calling jai_om_wsh_pkg.process_delivery with delivery id => ' || temp_rec.delivery_id );

3042: and mo_global.check_access(jowla.org_id) = 'Y'
3043: ) /*Added join of table jai_om_wsh_lines_all and check_access by mmurtuza for bug 16308603*/
3044: LOOP
3045: BEGIN
3046: fnd_file.put_line ( fnd_file.log , ' Calling jai_om_wsh_pkg.process_delivery with delivery id => ' || temp_rec.delivery_id );
3047: jai_om_wsh_pkg.process_delivery(errbuf ,
3048: retcode ,
3049: temp_rec.delivery_id
3050: ) ;

Line 3051: fnd_file.put_line ( fnd_file.log , ' After call to jai_om_wsh_pkg.process_delivery with delivery id => ' || temp_rec.delivery_id || ' return code => ' || retcode);

3047: jai_om_wsh_pkg.process_delivery(errbuf ,
3048: retcode ,
3049: temp_rec.delivery_id
3050: ) ;
3051: fnd_file.put_line ( fnd_file.log , ' After call to jai_om_wsh_pkg.process_delivery with delivery id => ' || temp_rec.delivery_id || ' return code => ' || retcode);
3052: IF nvl(retcode,'0') <> '0' THEN
3053: /* An Error has occured - rollback the changes done by the changes and proceed with the next one*/
3054: fnd_file.put_line ( fnd_file.log , ' After call to jai_om_wsh_pkg.process_delivery with delivery id => ' || temp_rec.delivery_id || ' Error is => ' || errbuf);
3055: ln_error_occured := 1;

Line 3054: fnd_file.put_line ( fnd_file.log , ' After call to jai_om_wsh_pkg.process_delivery with delivery id => ' || temp_rec.delivery_id || ' Error is => ' || errbuf);

3050: ) ;
3051: fnd_file.put_line ( fnd_file.log , ' After call to jai_om_wsh_pkg.process_delivery with delivery id => ' || temp_rec.delivery_id || ' return code => ' || retcode);
3052: IF nvl(retcode,'0') <> '0' THEN
3053: /* An Error has occured - rollback the changes done by the changes and proceed with the next one*/
3054: fnd_file.put_line ( fnd_file.log , ' After call to jai_om_wsh_pkg.process_delivery with delivery id => ' || temp_rec.delivery_id || ' Error is => ' || errbuf);
3055: ln_error_occured := 1;
3056: Rollback;
3057: else
3058: ln_success := 1; /* It will hold the status whether atleast one delivery was successfully processed*/