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 1116: Fnd_File.PUT_LINE(Fnd_File.LOG, ' 1 START Delivery id = ' || p_delivery_id );

1112: v_ref_25 := 'delivery_id'; -- holds the column name -- 'delivery_id';
1113: /* Ramananda for File.Sql.35 */
1114:
1115: lv_block_no := '0';
1116: Fnd_File.PUT_LINE(Fnd_File.LOG, ' 1 START Delivery id = ' || p_delivery_id );
1117: FOR Each_record IN
1118: (
1119: SELECT *
1120: FROM JAI_OM_OE_GEN_TAXINV_T ja_tmp

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

1151: CLOSE c_conc_request_submit_date;
1152: /* Ends here Bug 4562791. Added by Lakshmi Gopalsami */
1153:
1154: 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
1155: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'2 Each_record.Delivery detail id = ' || Each_record.delivery_detail_id );
1156: v_tax_rate := 0; --2001/08/07 Jagdish
1157: lv_statement_no := '1';
1158:
1159: OPEN get_delivery_status(each_record.delivery_id);

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

1215: FETCH c_excise_tax_cnt INTO ln_excise_tax_cnt ;
1216: CLOSE c_excise_tax_cnt;
1217:
1218:
1219: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'4 v_register = ' || v_register
1220: ||', v_order_type_id = ' || v_order_type_id ||', v_excise_exempt_type = ' || v_excise_exempt_type
1221: );
1222:
1223: IF v_register IS NULL THEN --z999

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

1229: l_func_curr_det := jai_plsql_cache_pkg.return_sob_curr
1230: (p_org_id => v_organization_id );
1231: v_set_of_books_id := l_func_curr_det.ledger_id;
1232:
1233: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'7 v_set_of_books_id = ' || v_set_of_books_id);
1234: lv_statement_no := '7';
1235:
1236: /*
1237: Code changed by aiyer for the bug #3139718.

Line 1274: fnd_file.put_line( fnd_file.log,

1270: OPEN bonded_cur(v_organization_id, v_subinventory) ;
1271: FETCH bonded_cur INTO v_bonded_flag,v_trading_flag ;
1272: CLOSE bonded_cur ;
1273:
1274: fnd_file.put_line( fnd_file.log,
1275: p_delivery_id||', '||'8 v_organization_id = ' || v_organization_id
1276: ||', v_subinventory = ' || v_subinventory ||', v_bonded_flag = ' || v_bonded_flag
1277: ||', v_trading_flag = ' || v_trading_flag
1278: );

Line 1298: fnd_file.put_line(

1294: ); -- out parameter to get the register code
1295:
1296:
1297:
1298: fnd_file.put_line(
1299: fnd_file.log,
1300: p_delivery_id||', '||', v_register_code = ' || v_register_code
1301: );
1302: lv_statement_no := '10';

Line 1299: fnd_file.log,

1295:
1296:
1297:
1298: fnd_file.put_line(
1299: fnd_file.log,
1300: p_delivery_id||', '||', v_register_code = ' || v_register_code
1301: );
1302: lv_statement_no := '10';
1303: OPEN fin_year_cur(v_organization_id);

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

1323:
1324:
1325: --Added the below by kunkumar for bug#6121833
1326: IF NVL(v_modvat_tax_rate,0) = 0 THEN
1327: fnd_file.put_line(fnd_file.log, p_delivery_id||', '||'ERROR - MODVAT REVERSAL% SHOULD BE DEFINED IN ORGANIZATION ADDITIONAL INFORMATION ');
1328: errbuf := 'Error - MODVAT Reversal% should be defined in Organization Additional Information';
1329: retcode := 2; --to signal an error.
1330: return;
1331: END IF;

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

1333: END IF;
1334: END IF;
1335:
1336: lv_statement_no := '19';
1337: fnd_file.put_line(fnd_file.log, p_delivery_id||', '||'8.01 v_exempt_bal = ' || v_exempt_bal);
1338: v_exempt_bal := NVL(v_exempt_bal, 0) +( v_shp_qty * v_assessable_value * NVL(v_modvat_tax_rate,0))/100;
1339: fnd_file.put_line(fnd_file.log, p_delivery_id||', '||'8.02 v_exempt_bal = ' || v_exempt_bal);
1340: end if;
1341:

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

1335:
1336: lv_statement_no := '19';
1337: fnd_file.put_line(fnd_file.log, p_delivery_id||', '||'8.01 v_exempt_bal = ' || v_exempt_bal);
1338: v_exempt_bal := NVL(v_exempt_bal, 0) +( v_shp_qty * v_assessable_value * NVL(v_modvat_tax_rate,0))/100;
1339: fnd_file.put_line(fnd_file.log, p_delivery_id||', '||'8.02 v_exempt_bal = ' || v_exempt_bal);
1340: end if;
1341:
1342: /* following 3 lines of code added by bgowrava for Bug#5554420 */
1343: if nvl(v_old_delivery_id,0) <> nvl(each_record.delivery_id,-1)

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

1355: CLOSE get_prev_del_dtl;
1356: end if;
1357:
1358:
1359: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', 9 v_fin_year = ' || v_fin_year
1360: ||', v_old_delivery_id = ' || v_old_delivery_id );
1361: IF NVL(v_old_delivery_id,0) <> NVL(each_record.delivery_id,-1)
1362: or lv_exc_inv_gen_for_dlry_flag = 'N' /* condition added by bgowrava for bug#5554420 */
1363: THEN --f999

Line 1374: fnd_file.put_line(

1370: FETCH get_prev_del_dtl INTO v_old_register, v_old_excise_invoice_no;
1371: CLOSE get_prev_del_dtl;
1372: */
1373:
1374: fnd_file.put_line(
1375: fnd_file.log,
1376: p_delivery_id||', '||'15 v_old_register = ' || v_old_register
1377: ||', v_old_excise_invoice_no = ' || v_old_excise_invoice_no
1378: );

Line 1375: fnd_file.log,

1371: CLOSE get_prev_del_dtl;
1372: */
1373:
1374: fnd_file.put_line(
1375: fnd_file.log,
1376: p_delivery_id||', '||'15 v_old_register = ' || v_old_register
1377: ||', v_old_excise_invoice_no = ' || v_old_excise_invoice_no
1378: );
1379:

Line 1421: fnd_file.put_line(

1417: 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;
1418: CLOSE get_total_excise_amt;
1419:
1420:
1421: fnd_file.put_line(
1422: fnd_file.log,
1423: p_delivery_id||', 17 v_tot_excise_amt = ' || v_tot_excise_amt
1424: ||', v_tot_basic_ed_amt = ' || v_tot_basic_ed_amt ||', v_tot_addl_ed_amt = ' || v_tot_addl_ed_amt
1425: ||', v_tot_oth_ed_amt = ' || v_tot_oth_ed_amt

Line 1422: fnd_file.log,

1418: CLOSE get_total_excise_amt;
1419:
1420:
1421: fnd_file.put_line(
1422: fnd_file.log,
1423: p_delivery_id||', 17 v_tot_excise_amt = ' || v_tot_excise_amt
1424: ||', v_tot_basic_ed_amt = ' || v_tot_basic_ed_amt ||', v_tot_addl_ed_amt = ' || v_tot_addl_ed_amt
1425: ||', v_tot_oth_ed_amt = ' || v_tot_oth_ed_amt
1426: || ',v_mod_basic_ed_amt =' || v_mod_basic_ed_amt

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

1436: --Changed by Nagaraj.s for Enh#2415656
1437: OPEN pref_cur(v_organization_id, v_location_id);
1438: FETCH pref_cur INTO v_pref_rg23a, v_pref_rg23c, v_pref_pla,v_export_oriented_unit;
1439: CLOSE pref_cur;
1440: 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 );
1441:
1442: lv_statement_no := '14';
1443: ----Changed by Nagaraj.s for Enh#2415656
1444: OPEN rg_bal_cur(v_organization_id, v_location_id);

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

1445: FETCH rg_bal_cur INTO v_rg23a_balance, v_rg23c_balance, v_pla_balance,
1446: v_basic_pla_balance,v_additional_pla_balance,v_other_pla_balance;
1447: CLOSE rg_bal_cur;
1448:
1449: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'19 v_rg23a_bala = ' || v_rg23a_balance ||', v_rg23c_bal = '
1450: || v_rg23c_balance ||', v_pla_balae = ' || v_pla_balance );
1451:
1452: lv_statement_no := '15';
1453: OPEN ssi_unit_flag_cur(v_organization_id, v_location_id);

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

1517: lv_process_flag ,
1518: lv_process_message
1519: );
1520:
1521: fnd_file.put_line(fnd_file.log, p_delivery_id||', '||'18.1 The Value OF v_reg_type IS '|| v_reg_type);
1522: --**************************************************************************************************************************
1523: ELSE
1524: IF v_item_class NOT IN ('OTIN', 'OTEX') THEN
1525:

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

1559: lv_process_message
1560: );
1561: --Ends here......................................
1562: -------------------------------------------------------------------------------------------------------------------
1563: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'23 v_raise_exempt_flag = ' || v_raise_exempt_flag);
1564: v_basic_ed_amt := v_exempt_bal;
1565: v_tot_basic_ed_amt := NVL(v_tot_basic_ed_amt,0) + nvl(v_mod_basic_ed_amt,0) ; --+ v_exempt_bal; -- bug# 3207685
1566: v_remarks := 'Against Modvat Recovery'||'-'||v_excise_exempt_refno;
1567: --2001/11/01 Anuradha Parthasarathy

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

1583: v_lou_flag
1584: );
1585:
1586: if nvl(v_register_exp_date,sysdate) < sysdate then
1587: Fnd_File.PUT_LINE(Fnd_File.LOG,'Error Occured - The Validity Period of the Bond Register ' || v_register_exp_date || ' has lapsed');
1588: RAISE_APPLICATION_ERROR(-20121,'The Validity Period of the Bond Register has lapsed');
1589: end if;
1590:
1591:

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

1588: RAISE_APPLICATION_ERROR(-20121,'The Validity Period of the Bond Register has lapsed');
1589: end if;
1590:
1591:
1592: Fnd_File.PUT_LINE(Fnd_File.LOG,'LOU FLAG is ' || NVL(v_lou_flag,'N'));
1593:
1594: 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 );
1595:
1596: IF ( (nvl(v_lou_flag,'N') = 'N') and (NVL(v_register_balance,0) < NVL(v_tot_excise_amt,0)) ) THEN

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

1590:
1591:
1592: Fnd_File.PUT_LINE(Fnd_File.LOG,'LOU FLAG is ' || NVL(v_lou_flag,'N'));
1593:
1594: 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 );
1595:
1596: IF ( (nvl(v_lou_flag,'N') = 'N') and (NVL(v_register_balance,0) < NVL(v_tot_excise_amt,0)) ) THEN
1597:
1598: Fnd_File.PUT_LINE(Fnd_File.LOG,'Error Occured - Bonded Register Has Balance -> ' || TO_CHAR(v_register_balance)

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

1594: 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 );
1595:
1596: IF ( (nvl(v_lou_flag,'N') = 'N') and (NVL(v_register_balance,0) < NVL(v_tot_excise_amt,0)) ) THEN
1597:
1598: Fnd_File.PUT_LINE(Fnd_File.LOG,'Error Occured - Bonded Register Has Balance -> ' || TO_CHAR(v_register_balance)
1599: || ' ,which IS less than Excisable Amount -> ' || TO_CHAR(v_tot_excise_amt));
1600:
1601: RAISE_APPLICATION_ERROR(-20120, 'Bonded Register Has Balance -> ' || TO_CHAR(v_register_balance)
1602: || ' ,which IS less than Excisable Amount -> ' || TO_CHAR(v_tot_excise_amt));

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

1635: lv_statement_no := '21';
1636: OPEN register_code_meaning_cur(v_register_code,'JAI_REGISTER_TYPE'); /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
1637: FETCH register_code_meaning_cur INTO v_meaning;
1638: CLOSE register_code_meaning_cur;
1639: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'25 v_meaning = ' || v_meaning);
1640:
1641: lv_statement_no := '22';
1642: OPEN fin_year_cur(v_organization_id);
1643: FETCH fin_year_cur INTO v_fin_year;

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

1653:
1654: IF NVL(ln_number_of_Taxes,0) > 0 THEN /*Bug 5403048 End*/
1655: -- procedure call to the excise invoice number generation procedure added by sriram bug # 2663211
1656:
1657: fnd_file.put_line(fnd_file.log,'Calling the Excise Invoice Generation procedure with following parameters ');
1658: fnd_file.put_line(fnd_file.log,' Organization_id => ' || v_organization_id || ' Location_id => ' || v_location_id);
1659: fnd_file.put_line(fnd_file.log,'Order Type id => ' || v_order_type_id || 'Fin Year => ' || v_fin_year);
1660:
1661:

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

1654: IF NVL(ln_number_of_Taxes,0) > 0 THEN /*Bug 5403048 End*/
1655: -- procedure call to the excise invoice number generation procedure added by sriram bug # 2663211
1656:
1657: fnd_file.put_line(fnd_file.log,'Calling the Excise Invoice Generation procedure with following parameters ');
1658: fnd_file.put_line(fnd_file.log,' Organization_id => ' || v_organization_id || ' Location_id => ' || v_location_id);
1659: fnd_file.put_line(fnd_file.log,'Order Type id => ' || v_order_type_id || 'Fin Year => ' || v_fin_year);
1660:
1661:
1662: 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 1659: fnd_file.put_line(fnd_file.log,'Order Type id => ' || v_order_type_id || 'Fin Year => ' || v_fin_year);

1655: -- procedure call to the excise invoice number generation procedure added by sriram bug # 2663211
1656:
1657: fnd_file.put_line(fnd_file.log,'Calling the Excise Invoice Generation procedure with following parameters ');
1658: fnd_file.put_line(fnd_file.log,' Organization_id => ' || v_organization_id || ' Location_id => ' || v_location_id);
1659: fnd_file.put_line(fnd_file.log,'Order Type id => ' || v_order_type_id || 'Fin Year => ' || v_fin_year);
1660:
1661:
1662: 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);
1663:

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

1660:
1661:
1662: 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);
1663:
1664: fnd_file.put_line(fnd_file.log,'After Call to the procedure output values are following');
1665: fnd_file.put_line(fnd_file.log,'Excise Invoice Number generated => ' || v_exc_invoice_no);
1666:
1667: IF ERRBUF IS NOT NULL THEN
1668: Fnd_File.PUT_LINE(Fnd_File.LOG,'Error Message in the excise invoice generation procedure is => ' || ERRBUF);

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

1661:
1662: 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);
1663:
1664: fnd_file.put_line(fnd_file.log,'After Call to the procedure output values are following');
1665: fnd_file.put_line(fnd_file.log,'Excise Invoice Number generated => ' || v_exc_invoice_no);
1666:
1667: IF ERRBUF IS NOT NULL THEN
1668: Fnd_File.PUT_LINE(Fnd_File.LOG,'Error Message in the excise invoice generation procedure is => ' || ERRBUF);
1669: retcode :=2; --to signal an error.

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

1664: fnd_file.put_line(fnd_file.log,'After Call to the procedure output values are following');
1665: fnd_file.put_line(fnd_file.log,'Excise Invoice Number generated => ' || v_exc_invoice_no);
1666:
1667: IF ERRBUF IS NOT NULL THEN
1668: Fnd_File.PUT_LINE(Fnd_File.LOG,'Error Message in the excise invoice generation procedure is => ' || ERRBUF);
1669: retcode :=2; --to signal an error.
1670: v_ret_stat := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',ERRBUF);
1671: return;
1672: END IF;

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

1674: lv_exc_inv_gen_for_dlry_flag := 'Y'; --added by csahoo for bug#6077065
1675:
1676: /*Bug 5403048 Start*/
1677: ELSE
1678: 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 ');
1679: END IF;
1680: /*Bug 5403048 End*/
1681: END IF; --d999 --1
1682: ELSE

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

1681: END IF; --d999 --1
1682: ELSE
1683: v_reg_type := v_old_register;
1684: v_exc_invoice_no := v_old_excise_invoice_no;
1685: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'41 v_reg_type= ' ||v_reg_type);
1686: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'41 v_exc_invoice_no= ' ||v_exc_invoice_no);
1687: END IF; --e999
1688: END IF; --f999
1689:

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

1682: ELSE
1683: v_reg_type := v_old_register;
1684: v_exc_invoice_no := v_old_excise_invoice_no;
1685: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'41 v_reg_type= ' ||v_reg_type);
1686: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'41 v_exc_invoice_no= ' ||v_exc_invoice_no);
1687: END IF; --e999
1688: END IF; --f999
1689:
1690: lv_statement_no := '29';

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

1756: -- hits the registers.
1757: --The amounts which are taken care are: v_basic_ed_amt,v_oth_ed_amt,
1758: --v_addl_ed_amt, v_tot_basic_ed_amt .......................
1759:
1760: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', '||'42 v_item_class= ' ||v_item_class);
1761: IF v_register_code IS NOT NULL AND NVL(v_bonded_flag,'N') = 'Y' THEN --g999 --1
1762:
1763: /*
1764: || Start of bug 4566054

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

1849: );
1850:
1851: lv_statement_no := '31';
1852: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_part_i_register_id FROM dual;
1853: 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 );
1854: ELSIF v_item_class IN ('CGEX','CGIN') THEN
1855: v_qty_reg_type := 'C';
1856:
1857: ELSIF v_item_class IN ('RMIN','RMEX') THEN

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

1900: v_last_update_login
1901: );
1902: lv_statement_no := '33';
1903: SELECT JAI_CMN_RG_23AC_I_TRXS_S.CURRVAL INTO v_part_i_register_id FROM dual;
1904: 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 );
1905: END IF;
1906: END IF;
1907: -- Start of Bug 3446362
1908: /*

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

1917: OPEN c_ct3_flag_exists;
1918: FETCH c_ct3_flag_exists INTO ln_count;
1919: CLOSE c_ct3_flag_exists;
1920:
1921: fnd_file.put_line( fnd_file.log, p_delivery_id||', '||'44 v_old_delivery_id = ' ||v_old_delivery_id
1922: ||', 45 v_old_register = ' ||v_old_register||', 46 v_reg_type = ' ||v_reg_type
1923: ||', 47 value of ln_count '||ln_count
1924: );
1925:

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

1983: v_ref_25 , -- bug # 2769440
1984: v_ref_26 -- bug # 2769440
1985: );
1986:
1987: 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 );
1988: ELSIF v_reg_type IN ('PLA') THEN
1989: lv_statement_no := '35';
1990:
1991: /*

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

2025: v_ref_24 , -- bug # 2769440
2026: v_ref_25 , -- bug # 2769440
2027: v_ref_26 -- bug # 2769440
2028: );
2029: 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 );
2030: END IF;
2031: -- END IF; /* commented by bgowrava for forward porting Bug#5554420 */
2032: END IF;
2033:

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

2102: WHERE register_id = v_rg23_part_i_no;
2103: END IF;
2104: END IF;
2105:
2106: 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 );
2107: --2001/04/09 Manohar Mishra
2108: --Changed the cases
2109: IF NVL(v_register_code,'N') IN ('BOND_REG') AND
2110: NVL(v_old_delivery_id,0) <> NVL(each_record.delivery_id,-1) -- bug2389773 cbabu 24/02/2002. new check added

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

2160: OPEN bonded_cur(v_organization_id, v_subinventory);
2161: FETCH bonded_cur INTO v_bonded_flag, v_trading_flag;
2162: CLOSE bonded_cur;
2163:
2164: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', 48.1 v_register_code -> ' || v_register_code
2165: ||', v_trading_flag -> ' || v_trading_flag ||', v_item_trading_flag -> ' || v_item_trading_flag
2166: );
2167:
2168: /*

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

2214: v_total_rate := 0;
2215:
2216: FOR match_rec IN matched_receipt_cur(each_record.delivery_detail_id) LOOP -- cbabu for Bug# 2736191
2217:
2218: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||', 49.1 quantity_applied -> ' || match_rec.quantity_applied
2219: ||', receipt_id -> ' || match_rec.receipt_id
2220: );
2221:
2222: lv_statement_no := '58';

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

2232: END IF;
2233: --End bug 7043292
2234: v_total_quantity_applied := v_total_quantity_applied + match_rec.quantity_applied;
2235:
2236: fnd_file.put_line(fnd_file.log, p_delivery_id||', 49.2 v_register_id -> ' || v_register_id
2237: ||', v_exc_invoice_no -> ' || v_exc_invoice_no||', v_receipt_id -> ' || v_receipt_id
2238: ||', v_quantity_applied -> ' || v_quantity_applied||', v_qty_to_adjust -> ' || v_qty_to_adjust
2239: ||', v_excise_duty_rate -> ' || v_excise_duty_rate||', v_rate_per_unit -> ' || v_rate_per_unit
2240: ||', v_source_line_id -> ' || v_source_line_id||', v_source_header_id -> ' || v_source_header_id

Line 2343: fnd_file.put_line( fnd_file.log,

2339: END LOOP;
2340: --added by cbabu 27/03/02
2341: lv_statement_no := '62';
2342: --COMMIT;
2343: fnd_file.put_line( fnd_file.log,
2344: p_delivery_id||', '||'61 v_no_records_fetched = '||v_no_records_fetched
2345: ||', END OF deliver_id = '||p_delivery_id
2346: );
2347:

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

2361: ROLLBACK;
2362: lv_error_mesg := SQLERRM;
2363: ERRBUF := lv_error_mesg;
2364: RETCODE := '2';
2365: Fnd_File.PUT_LINE(Fnd_File.LOG, p_delivery_id||' Error occured = ' || lv_error_mesg);
2366: INSERT INTO JAI_CMN_ERRORS_T (
2367: APPLICATION_SOURCE ,
2368: error_message ,
2369: additional_error_mesg ,

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

2891: jai_om_wsh_pkg.process_delivery ( errbuf ,
2892: retcode ,
2893: pn_delivery_id
2894: ) ;
2895: 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);
2896: IF nvl(retcode,'0') <> '0' THEN
2897: ln_error_occured := 1;
2898: ln_success := 0;
2899: Rollback;

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

2896: IF nvl(retcode,'0') <> '0' THEN
2897: ln_error_occured := 1;
2898: ln_success := 0;
2899: Rollback;
2900: fnd_file.put_line ( fnd_file.log , 'delivery_id => ' || pn_delivery_id || 'Error is ' || errbuf ) ;
2901: else
2902:
2903: commit;
2904: ln_success := 1;

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

2910: From JAI_OM_OE_GEN_TAXINV_T
2911: )
2912: LOOP
2913: BEGIN
2914: fnd_file.put_line ( fnd_file.log , ' Calling jai_om_wsh_pkg.process_delivery with delivery id => ' || temp_rec.delivery_id );
2915: jai_om_wsh_pkg.process_delivery(errbuf ,
2916: retcode ,
2917: temp_rec.delivery_id
2918: ) ;

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

2915: jai_om_wsh_pkg.process_delivery(errbuf ,
2916: retcode ,
2917: temp_rec.delivery_id
2918: ) ;
2919: 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);
2920: IF nvl(retcode,'0') <> '0' THEN
2921: /* An Error has occured - rollback the changes done by the changes and proceed with the next one*/
2922: 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);
2923: ln_error_occured := 1;

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

2918: ) ;
2919: 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);
2920: IF nvl(retcode,'0') <> '0' THEN
2921: /* An Error has occured - rollback the changes done by the changes and proceed with the next one*/
2922: 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);
2923: ln_error_occured := 1;
2924: Rollback;
2925: else
2926: ln_success := 1; /* It will hold the status whether atleast one delivery was successfully processed*/