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.CSTPPINV dependencies on FND_FILE

Line 73: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': begin <<'

69: l_err_code := '';
70: l_err_msg := '';
71:
72: IF l_debug = 'Y' THEN
73: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': begin <<'
74: || ' transaction_id: ' || i_txn_id
75: || ', cost group id: ' || i_cost_group_id
76: || ', cost type id: ' || i_cost_type_id
77: || ', pac period id: ' || i_pac_period_id

Line 619: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': return >>');

615: END IF;
616:
617: l_stmt_num := 200;
618: IF l_debug = 'Y' THEN
619: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': return >>');
620: END IF;
621:
622:
623: EXCEPTION

Line 735: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': begin <<'

731:
732: BEGIN
733:
734: IF l_debug = 'Y' THEN
735: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': begin <<'
736: || ' transaction_id: ' || i_txn_id);
737: END IF;
738:
739: -- initialize local variables

Line 770: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'

766: raise process_error;
767: END IF;
768:
769: IF l_debug = 'Y' THEN
770: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'
771: || ' l_conv_rate: ' || l_conv_rate);
772: END IF;
773:
774: /* Get shipment transaction_id */

Line 795: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'

791: FROM mtl_material_transactions
792: WHERE transaction_id = i_txn_id;
793:
794: IF l_debug = 'Y' THEN
795: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'
796: || ' l_shipment_txn_id: ' || l_shipment_txn_id
797: || ', l_txn_src_type_id: ' || l_txn_src_type_id
798: /* || ', l_txn_id: ' || l_txn_id */
799: || ', l_trp_cost: ' || l_trp_cost);

Line 814: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'

810: AND mip.from_organization_id = l_from_org
811: AND mip.to_organization_id = l_to_org;
812:
813: IF l_debug = 'Y' THEN
814: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'
815: || ' l_fob_point: ' || l_fob_point);
816: END IF;
817:
818: l_stmt_num := 20;

Line 861: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'

857:
858: l_stmt_num := 22;
859:
860: IF l_debug = 'Y' THEN
861: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'
862: || ' l_tprice_option: ' || l_tprice_option || ', process-discrete xfer: ' || l_pd_txfr_ind);
863: END IF;
864:
865: IF ((l_tprice_option = 2)

Line 884: fnd_file.put_line(fnd_file.log,'Transfer Price not available');

880: FROM mtl_material_transactions
881: WHERE transaction_id = l_shipment_txn_id;
882:
883: IF (l_txfr_price is NULL) THEN
884: fnd_file.put_line(fnd_file.log,'Transfer Price not available');
885: l_err_msg := 'CSTPPINV.get_interorg_cost : ' || to_char(l_stmt_num) ||' : '|| ' Transfer Price not available';
886: l_err_num := 9999;
887: raise process_error;
888: END IF;

Line 891: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'

887: raise process_error;
888: END IF;
889:
890: IF l_debug = 'Y' THEN
891: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'
892: || ' l_txfr_price: ' || l_txfr_price);
893: END IF;
894:
895: l_stmt_num := 30;

Line 925: fnd_file.put_line(fnd_file.log,' Regular Interorg Transfer:' || ' discrete-discrete xfer: ');

921:
922: -- discrete-discrete interorg transfer
923:
924: IF l_debug = 'Y' THEN
925: fnd_file.put_line(fnd_file.log,' Regular Interorg Transfer:' || ' discrete-discrete xfer: ');
926: END IF;
927:
928: IF ((l_tprice_option = 1)
929: AND ((i_txn_action_id in (21,22) AND l_txn_src_type_id = 8)

Line 982: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'

978: WHERE LEGAL_ENTITY = i_legal_entity
979: AND COST_TYPE_ID = i_cost_type_id;
980:
981: IF l_debug = 'Y' THEN
982: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'
983: || ' l_txfr_legal_entity: ' || l_txfr_legal_entity
984: || ', l_same_le_ct: ' || l_same_le_ct
985: || ', l_transfer_cost_flag (PACP): ' || l_transfer_cost_flag);
986: END IF;

Line 1009: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'

1005: L_COST_SOURCE_COST_GROUP := I_TXFR_COST_GROUP_ID;
1006: END IF;
1007:
1008: IF l_debug = 'Y' THEN
1009: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'
1010: || ' l_cost_source_cost_group: ' || l_cost_source_cost_group);
1011: END IF;
1012:
1013: IF (l_transfer_cost_flag = 'Y') THEN

Line 1016: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'

1012:
1013: IF (l_transfer_cost_flag = 'Y') THEN
1014:
1015: IF l_debug = 'Y' THEN
1016: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'
1017: || ' Same LE/CT Transfer with PACP enabled');
1018: END IF;
1019:
1020: /* Use PACP cost if available */

Line 1082: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'

1078:
1079: l_stmt_num := 80;
1080:
1081: IF l_debug = 'Y' THEN
1082: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'
1083: || ' Same LE/CT Transfer with PACP not enabled');
1084: END IF;
1085:
1086: /* PACP is not enabled. Use prior period sending CG PWAC Cost */

Line 1151: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':' || ' Different LE/CT Transfer:');

1147:
1148: l_stmt_num := 120;
1149:
1150: IF l_debug = 'Y' THEN
1151: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':' || ' Different LE/CT Transfer:');
1152: END IF;
1153:
1154: /* Sending and Receiving Orgs not in the same LE/CT
1155: Use MTA Cost */

Line 1184: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'

1180:
1181: END IF; /* IF (i_legal_entity = l_txfr_legal_entity AND l_same_le_ct > 0) THEN */
1182:
1183: IF l_debug = 'Y' THEN
1184: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'
1185: || ' l_sending_cg_cost: ' || l_sending_cg_cost);
1186: END IF;
1187:
1188:

Line 1208: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': l_ovhd_cost = ' || l_ovhd_cost);

1204: raise process_error;
1205: END IF;
1206:
1207: l_ovhd_cost := (l_trp_cost + l_txfr_credit) * l_conv_rate;
1208: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': l_ovhd_cost = ' || l_ovhd_cost);
1209:
1210: IF (l_ovhd_cost > 0) THEN
1211: CSTPPINV.add_elemental_cost(
1212: i_pac_period_id => i_pac_period_id,

Line 1240: fnd_file.put_line(fnd_file.log,' INVCONV process-discrete xfer');

1236:
1237: ELSE -- INVCONV Process-Discrete Transfer.
1238:
1239: IF l_debug = 'Y' THEN
1240: fnd_file.put_line(fnd_file.log,' INVCONV process-discrete xfer');
1241: END IF;
1242:
1243: l_stmt_num := 145;
1244:

Line 1289: fnd_file.put_line(fnd_file.log,' transfer price stamped: ' || i_transfer_price_pd);

1285:
1286: l_stmt_num := 150;
1287:
1288: IF l_debug = 'Y' THEN
1289: fnd_file.put_line(fnd_file.log,' transfer price stamped: ' || i_transfer_price_pd);
1290: fnd_file.put_line(fnd_file.log,' txn_axn_id/qty: ' || i_txn_action_id || '/' || i_txn_qty);
1291: END IF;
1292:
1293: /* Don't earn overhead for Transportation Cost for Direct Interorg Receipt */

Line 1290: fnd_file.put_line(fnd_file.log,' txn_axn_id/qty: ' || i_txn_action_id || '/' || i_txn_qty);

1286: l_stmt_num := 150;
1287:
1288: IF l_debug = 'Y' THEN
1289: fnd_file.put_line(fnd_file.log,' transfer price stamped: ' || i_transfer_price_pd);
1290: fnd_file.put_line(fnd_file.log,' txn_axn_id/qty: ' || i_txn_action_id || '/' || i_txn_qty);
1291: END IF;
1292:
1293: /* Don't earn overhead for Transportation Cost for Direct Interorg Receipt */
1294: /* Also transfer cost=transfer price for receiving org, intransit rcpt, fob rcpt */

Line 1298: fnd_file.put_line(fnd_file.log,' No MOH earned: ');

1294: /* Also transfer cost=transfer price for receiving org, intransit rcpt, fob rcpt */
1295: IF ((i_txn_action_id = 3 and i_txn_qty > 0) or (i_txn_action_id=12 and l_fob_point=2)) THEN
1296:
1297: IF l_debug = 'Y' THEN
1298: fnd_file.put_line(fnd_file.log,' No MOH earned: ');
1299: END IF;
1300:
1301: ELSE -- Earn MOH in all other cases
1302:

Line 1347: fnd_file.put_line(fnd_file.log,' transportation cost as MOH stamped: ' || l_trp_cost);

1343: SYSDATE,
1344: i_login_id);
1345:
1346: IF l_debug = 'Y' THEN
1347: fnd_file.put_line(fnd_file.log,' transportation cost as MOH stamped: ' || l_trp_cost);
1348: END IF;
1349:
1350: END IF; /* IF ((i_txn_action_id = 3 and i_txn_qty > 0) or (i_txn_action_id=12 and l_fob_point=2)) THEN */
1351:

Line 1357: fnd_file.put_line(fnd_file.log,l_api_name || ': ' || l_stmt_num || ': return >>');

1353:
1354: l_stmt_num := 200;
1355:
1356: IF l_debug = 'Y' THEN
1357: fnd_file.put_line(fnd_file.log,l_api_name || ': ' || l_stmt_num || ': return >>');
1358: END IF;
1359:
1360: EXCEPTION
1361:

Line 1371: fnd_file.put_line(fnd_file.log, o_err_msg);

1367: when OTHERS then
1368: o_err_num := SQLCODE;
1369: o_err_msg := 'CSTPPINV.get_interorg_cost (' || to_char(l_stmt_num) ||
1370: '): ' || substr(SQLERRM,1,200);
1371: fnd_file.put_line(fnd_file.log, o_err_msg);
1372:
1373: END get_interorg_cost;
1374:
1375: /*---------------------------------------------------------------------------

Line 1416: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': begin <<'

1412:
1413: BEGIN
1414:
1415: IF l_debug = 'Y' THEN
1416: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': begin <<'
1417: || ' source_transaction_id: ' || i_source_txn_id
1418: || ' source_cost: ' || i_source_cost);
1419: END IF;
1420:

Line 1441: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'

1437: FROM mtl_material_transactions
1438: WHERE transaction_id = i_source_txn_id;
1439:
1440: IF l_debug = 'Y' THEN
1441: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'
1442: || ' l_txfr_percent: ' || l_txfr_percent
1443: || ', l_txfr_cost: ' || l_txfr_cost
1444: || ', l_trp_cost: ' || l_trp_cost
1445: || ', l_shipment_txn_qty: ' || l_shipment_txn_qty);

Line 1463: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'

1459: x_txfr_credit := l_txfr_credit;
1460: x_trp_cost := l_trp_cost / abs(l_shipment_txn_qty);
1461:
1462: IF l_debug = 'Y' THEN
1463: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'
1464: || ' x_txfr_credit: ' || x_txfr_credit
1465: || ', x_trp_cost: ' || x_trp_cost);
1466: END IF;
1467:

Line 1471: fnd_file.put_line(fnd_file.log,l_api_name || ': ' || l_stmt_num || ': return >>');

1467:
1468: l_stmt_num := 40;
1469:
1470: IF l_debug = 'Y' THEN
1471: fnd_file.put_line(fnd_file.log,l_api_name || ': ' || l_stmt_num || ': return >>');
1472: END IF;
1473:
1474: EXCEPTION
1475:

Line 1480: fnd_file.put_line(fnd_file.log, o_err_msg);

1476: when OTHERS then
1477: o_err_num := SQLCODE;
1478: o_err_msg := 'CSTPPINV.get_txfr_trp_cost (' || to_char(l_stmt_num) ||
1479: '): ' || substr(SQLERRM,1,200);
1480: fnd_file.put_line(fnd_file.log, o_err_msg);
1481:
1482: END get_txfr_trp_cost;
1483:
1484: /*---------------------------------------------------------------------------

Line 1527: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': begin <<'

1523:
1524: BEGIN
1525:
1526: IF l_debug = 'Y' THEN
1527: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': begin <<'
1528: || ' i_txn_id: ' || i_txn_id);
1529: END IF;
1530:
1531: -- initialize local variables

Line 1593: fnd_file.put_line(fnd_file.log,l_api_name || ': ' || l_stmt_num || ': return >>');

1589:
1590: l_stmt_num := 40;
1591:
1592: IF l_debug = 'Y' THEN
1593: fnd_file.put_line(fnd_file.log,l_api_name || ': ' || l_stmt_num || ': return >>');
1594: END IF;
1595:
1596: EXCEPTION
1597:

Line 1607: fnd_file.put_line(fnd_file.log, o_err_msg);

1603: when OTHERS then
1604: o_err_num := SQLCODE;
1605: o_err_msg := 'CSTPPINV.add_elemental_cost (' || to_char(l_stmt_num) ||
1606: '): ' || substr(SQLERRM,1,200);
1607: fnd_file.put_line(fnd_file.log, o_err_msg);
1608: END add_elemental_cost;
1609:
1610: /*---------------------------------------------------------------------------
1611: | Procedure insert_elemental_cost()

Line 1650: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': begin <<'

1646:
1647: BEGIN
1648:
1649: IF l_debug = 'Y' THEN
1650: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': begin <<'
1651: || ' i_txn_id: ' || i_txn_id);
1652: END IF;
1653:
1654: -- initialize local variables

Line 1703: fnd_file.put_line(fnd_file.log,l_api_name || ': ' || l_stmt_num || ': return >>');

1699:
1700: l_stmt_num := 20;
1701:
1702: IF l_debug = 'Y' THEN
1703: fnd_file.put_line(fnd_file.log,l_api_name || ': ' || l_stmt_num || ': return >>');
1704: END IF;
1705:
1706: EXCEPTION
1707: when OTHERS then

Line 1711: fnd_file.put_line(fnd_file.log, o_err_msg);

1707: when OTHERS then
1708: o_err_num := SQLCODE;
1709: o_err_msg := 'CSTPPINV.insert_elemental_cost (' || to_char(l_stmt_num) ||
1710: '): ' || substr(SQLERRM,1,200);
1711: fnd_file.put_line(fnd_file.log, o_err_msg);
1712: END insert_elemental_cost;
1713:
1714:
1715: /*---------------------------------------------------------------------------

Line 1755: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': begin <<'

1751:
1752: BEGIN
1753:
1754: IF l_debug = 'Y' THEN
1755: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': begin <<'
1756: || ' i_txn_id: ' || i_txn_id);
1757: END IF;
1758:
1759: -- initialize local variables

Line 1832: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'

1828: x_pacp_used := 1;
1829: x_pacp_cost := l_pacp_pwac_cost;
1830:
1831: IF l_debug = 'Y' THEN
1832: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'
1833: || ' x_pacp_used: ' || x_pacp_used
1834: || ', x_pacp_cost: ' || x_pacp_cost);
1835: END IF;
1836:

Line 1840: fnd_file.put_line(fnd_file.log,l_api_name || ': ' || l_stmt_num || ': return >>');

1836:
1837: l_stmt_num := 110;
1838:
1839: IF l_debug = 'Y' THEN
1840: fnd_file.put_line(fnd_file.log,l_api_name || ': ' || l_stmt_num || ': return >>');
1841: END IF;
1842:
1843: EXCEPTION
1844:

Line 1849: fnd_file.put_line(fnd_file.log, o_err_msg);

1845: when OTHERS then
1846: o_err_num := SQLCODE;
1847: o_err_msg := 'CSTPPINV.get_pacp_cost (' || to_char(l_stmt_num) ||
1848: '): ' || substr(SQLERRM,1,200);
1849: fnd_file.put_line(fnd_file.log, o_err_msg);
1850:
1851: END get_pacp_cost;
1852:
1853: /*---------------------------------------------------------------------------

Line 1899: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': begin <<'

1895:
1896: BEGIN
1897:
1898: IF l_debug = 'Y' THEN
1899: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': begin <<'
1900: || ' transaction_id: ' || i_txn_id);
1901: END IF;
1902:
1903: -- initialize local variables

Line 2008: fnd_file.put_line(fnd_file.log,l_api_name || ': ' || l_stmt_num || ': return >>');

2004:
2005: l_stmt_num := 200;
2006:
2007: IF l_debug = 'Y' THEN
2008: fnd_file.put_line(fnd_file.log,l_api_name || ': ' || l_stmt_num || ': return >>');
2009: END IF;
2010:
2011: EXCEPTION
2012:

Line 2017: fnd_file.put_line(fnd_file.log, o_err_msg);

2013: when OTHERS then
2014: o_err_num := SQLCODE;
2015: o_err_msg := 'CSTPPINV.get_prev_period_cost (' || to_char(l_stmt_num) ||
2016: '): ' || substr(SQLERRM,1,200);
2017: fnd_file.put_line(fnd_file.log, o_err_msg);
2018:
2019: END get_prev_period_cost;
2020:
2021: /*---------------------------------------------------------------------------

Line 2063: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': begin <<'

2059:
2060: BEGIN
2061:
2062: IF l_debug = 'Y' THEN
2063: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': begin <<'
2064: || ' transaction_id: ' || i_txn_id
2065: || ' i_mta_txn_id: ' || i_mta_txn_id);
2066: END IF;
2067:

Line 2081: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': l_mta_txn_qty = ' || l_mta_txn_qty);

2077: FROM mtl_material_transactions
2078: WHERE transaction_id = i_mta_txn_id;
2079:
2080: IF l_debug = 'Y' THEN
2081: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': l_mta_txn_qty = ' || l_mta_txn_qty);
2082: END IF;
2083:
2084: /* Select the perpetual accounted value for the sending org's credit
2085: to On-hand (either Inventory or Expense accounting line type). */

Line 2100: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': l_perp_ship_cost = ' || l_perp_ship_cost);

2096: l_perp_ship_cost := 0;
2097: END;
2098:
2099: IF l_debug = 'Y' THEN
2100: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': l_perp_ship_cost = ' || l_perp_ship_cost);
2101: END IF;
2102:
2103: IF l_perp_ship_cost <> 0 THEN
2104: /* Insert all cost elements */

Line 2175: fnd_file.put_line(fnd_file.log,l_api_name || ': ' || l_stmt_num || ': return >>');

2171: l_stmt_num := 30;
2172: x_perp_ship_cost := l_perp_ship_cost;
2173:
2174: IF l_debug = 'Y' THEN
2175: fnd_file.put_line(fnd_file.log,l_api_name || ': ' || l_stmt_num || ': return >>');
2176: END IF;
2177:
2178: EXCEPTION
2179:

Line 2184: fnd_file.put_line(fnd_file.log, o_err_msg);

2180: when OTHERS then
2181: o_err_num := SQLCODE;
2182: o_err_msg := 'CSTPPINV.get_perp_ship_cost (' || to_char(l_stmt_num) ||
2183: '): ' || substr(SQLERRM,1,200);
2184: fnd_file.put_line(fnd_file.log, o_err_msg);
2185:
2186: END get_perp_ship_cost;
2187:
2188:

Line 2457: fnd_file.put_line(fnd_file.log,'In Cost_Acct_Events: Txn ID:' ||

2453: l_err_code := '';
2454: l_err_msg := '';
2455:
2456: l_stmt_num := 10;
2457: fnd_file.put_line(fnd_file.log,'In Cost_Acct_Events: Txn ID:' ||
2458: to_char(i_txn_id));
2459:
2460: /* Determine parent transaction id and parent_transaction organization id */
2461:

Line 2957: fnd_file.put_line(fnd_file.LOG, ' Start Processing group 1 - interorg txns across cost groups... '

2953: l_end_date :=to_date(i_end_date, 'YYYY/MM/DD HH24:MI:SS') + 0.99999;
2954:
2955: l_count :=0;
2956:
2957: fnd_file.put_line(fnd_file.LOG, ' Start Processing group 1 - interorg txns across cost groups... '
2958: || TO_CHAR(sysdate, 'DD-MON-RRRR HH24:MI:SS'));
2959:
2960: l_stmt_num := 10;
2961:

Line 2993: fnd_file.put_line(fnd_file.log,'txn_id:'||i_txn_id);

2989: i_txfr_org_id := trf_org_id_tab(i);
2990: i_subinventory_code := sub_inv_code_tab(i);
2991: i_trf_price := trf_price_tab(i);
2992:
2993: fnd_file.put_line(fnd_file.log,'txn_id:'||i_txn_id);
2994: fnd_file.put_line(fnd_file.log,'txn_action_id:'||i_txn_action_id);
2995: fnd_file.put_line(fnd_file.log,'txn_source_type_id:'||i_txn_src_type_id);
2996: fnd_file.put_line(fnd_file.log,'item_id:'||i_item_id);
2997:

Line 2994: fnd_file.put_line(fnd_file.log,'txn_action_id:'||i_txn_action_id);

2990: i_subinventory_code := sub_inv_code_tab(i);
2991: i_trf_price := trf_price_tab(i);
2992:
2993: fnd_file.put_line(fnd_file.log,'txn_id:'||i_txn_id);
2994: fnd_file.put_line(fnd_file.log,'txn_action_id:'||i_txn_action_id);
2995: fnd_file.put_line(fnd_file.log,'txn_source_type_id:'||i_txn_src_type_id);
2996: fnd_file.put_line(fnd_file.log,'item_id:'||i_item_id);
2997:
2998: /* Any intransit shipments in this cursor are FOB shipment processed by receiving CG,

Line 2995: fnd_file.put_line(fnd_file.log,'txn_source_type_id:'||i_txn_src_type_id);

2991: i_trf_price := trf_price_tab(i);
2992:
2993: fnd_file.put_line(fnd_file.log,'txn_id:'||i_txn_id);
2994: fnd_file.put_line(fnd_file.log,'txn_action_id:'||i_txn_action_id);
2995: fnd_file.put_line(fnd_file.log,'txn_source_type_id:'||i_txn_src_type_id);
2996: fnd_file.put_line(fnd_file.log,'item_id:'||i_item_id);
2997:
2998: /* Any intransit shipments in this cursor are FOB shipment processed by receiving CG,
2999: so we should be passing in the txfr_txn_org_id to determine expense status.

Line 2996: fnd_file.put_line(fnd_file.log,'item_id:'||i_item_id);

2992:
2993: fnd_file.put_line(fnd_file.log,'txn_id:'||i_txn_id);
2994: fnd_file.put_line(fnd_file.log,'txn_action_id:'||i_txn_action_id);
2995: fnd_file.put_line(fnd_file.log,'txn_source_type_id:'||i_txn_src_type_id);
2996: fnd_file.put_line(fnd_file.log,'item_id:'||i_item_id);
2997:
2998: /* Any intransit shipments in this cursor are FOB shipment processed by receiving CG,
2999: so we should be passing in the txfr_txn_org_id to determine expense status.
3000: Since this step hits receiving org's intransit, it is assumed to be asset sub,

Line 3098: fnd_file.put_line(fnd_file.LOG, 'COMPLETE Processing group 1 - interorg txns across cost groups:'

3094: CLOSE inter_trx;
3095:
3096: i_interorg_txn_grp1_cnt := l_count;
3097:
3098: fnd_file.put_line(fnd_file.LOG, 'COMPLETE Processing group 1 - interorg txns across cost groups:'
3099: ||l_count||'txns...'|| TO_CHAR(sysdate, 'DD-MON-RRRR HH24:MI:SS'));
3100:
3101:
3102: l_error_num := 0;

Line 3163: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV inter_trx');

3159: WHEN PROCESS_ERROR THEN
3160: o_err_num := l_error_num;
3161: o_err_code := l_error_code;
3162: o_err_msg := 'CSTPPINV.COST_INV_TXN:' || l_error_msg;
3163: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV inter_trx');
3164: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);
3165:
3166: WHEN CPPB_ERROR THEN
3167: o_err_num := l_error_num;

Line 3164: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);

3160: o_err_num := l_error_num;
3161: o_err_code := l_error_code;
3162: o_err_msg := 'CSTPPINV.COST_INV_TXN:' || l_error_msg;
3163: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV inter_trx');
3164: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);
3165:
3166: WHEN CPPB_ERROR THEN
3167: o_err_num := l_error_num;
3168: o_err_code := l_error_code;

Line 3170: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV while insert or update CPPB');

3166: WHEN CPPB_ERROR THEN
3167: o_err_num := l_error_num;
3168: o_err_code := l_error_code;
3169: o_err_msg := 'CSTPPINV:' || l_error_msg;
3170: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV while insert or update CPPB');
3171:
3172: WHEN EXP_FLAG_ERROR THEN
3173: o_err_num := l_error_num;
3174: o_err_code := l_error_code;

Line 3176: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.get_exp_flag');

3172: WHEN EXP_FLAG_ERROR THEN
3173: o_err_num := l_error_num;
3174: o_err_code := l_error_code;
3175: o_err_msg := 'CSTPPINV.get_exp_flag:' || l_error_msg;
3176: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.get_exp_flag');
3177: fnd_file.put_line(fnd_file.log,'item id:'||i_item_id || ' txn action id:' || i_txn_action_id
3178: || ' organization id:' || i_txn_org_id || ' transfer org id:' || i_txfr_org_id);
3179:
3180: WHEN OTHERS THEN

Line 3177: fnd_file.put_line(fnd_file.log,'item id:'||i_item_id || ' txn action id:' || i_txn_action_id

3173: o_err_num := l_error_num;
3174: o_err_code := l_error_code;
3175: o_err_msg := 'CSTPPINV.get_exp_flag:' || l_error_msg;
3176: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.get_exp_flag');
3177: fnd_file.put_line(fnd_file.log,'item id:'||i_item_id || ' txn action id:' || i_txn_action_id
3178: || ' organization id:' || i_txn_org_id || ' transfer org id:' || i_txfr_org_id);
3179:
3180: WHEN OTHERS THEN
3181: o_err_num := SQLCODE;

Line 3184: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.cost_interorg_txn_grp1');

3180: WHEN OTHERS THEN
3181: o_err_num := SQLCODE;
3182: o_err_msg := 'CSTPPINV (' || to_char(l_stmt_num) || '): '
3183: || substr(SQLERRM,1,150);
3184: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.cost_interorg_txn_grp1');
3185: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);
3186:
3187: END cost_interorg_txn_grp1;
3188:

Line 3185: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);

3181: o_err_num := SQLCODE;
3182: o_err_msg := 'CSTPPINV (' || to_char(l_stmt_num) || '): '
3183: || substr(SQLERRM,1,150);
3184: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.cost_interorg_txn_grp1');
3185: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);
3186:
3187: END cost_interorg_txn_grp1;
3188:
3189: -- ===================================================================================================

Line 3355: fnd_file.put_line(fnd_file.LOG, ' Start Processing group 2 - interorg txns across cost groups... '

3351: l_end_date :=to_date(i_end_date, 'YYYY/MM/DD HH24:MI:SS') + 0.99999;
3352:
3353: l_count :=0;
3354:
3355: fnd_file.put_line(fnd_file.LOG, ' Start Processing group 2 - interorg txns across cost groups... '
3356: || TO_CHAR(sysdate, 'DD-MON-RRRR HH24:MI:SS'));
3357:
3358: l_stmt_num := 10;
3359:

Line 3391: fnd_file.put_line(fnd_file.log,'txn_id:'||i_txn_id);

3387: i_txfr_org_id := trf_org_id_tab(i);
3388: i_subinventory_code := sub_inv_code_tab(i);
3389: i_trf_price := trf_price_tab(i);
3390:
3391: fnd_file.put_line(fnd_file.log,'txn_id:'||i_txn_id);
3392: fnd_file.put_line(fnd_file.log,'txn_action_id:'||i_txn_action_id);
3393: fnd_file.put_line(fnd_file.log,'txn_source_type_id:'||i_txn_src_type_id);
3394: fnd_file.put_line(fnd_file.log,'item_id:'||i_item_id);
3395:

Line 3392: fnd_file.put_line(fnd_file.log,'txn_action_id:'||i_txn_action_id);

3388: i_subinventory_code := sub_inv_code_tab(i);
3389: i_trf_price := trf_price_tab(i);
3390:
3391: fnd_file.put_line(fnd_file.log,'txn_id:'||i_txn_id);
3392: fnd_file.put_line(fnd_file.log,'txn_action_id:'||i_txn_action_id);
3393: fnd_file.put_line(fnd_file.log,'txn_source_type_id:'||i_txn_src_type_id);
3394: fnd_file.put_line(fnd_file.log,'item_id:'||i_item_id);
3395:
3396: get_exp_flag(i_item_id, i_txn_org_id, i_subinventory_code, l_exp_item,

Line 3393: fnd_file.put_line(fnd_file.log,'txn_source_type_id:'||i_txn_src_type_id);

3389: i_trf_price := trf_price_tab(i);
3390:
3391: fnd_file.put_line(fnd_file.log,'txn_id:'||i_txn_id);
3392: fnd_file.put_line(fnd_file.log,'txn_action_id:'||i_txn_action_id);
3393: fnd_file.put_line(fnd_file.log,'txn_source_type_id:'||i_txn_src_type_id);
3394: fnd_file.put_line(fnd_file.log,'item_id:'||i_item_id);
3395:
3396: get_exp_flag(i_item_id, i_txn_org_id, i_subinventory_code, l_exp_item,
3397: l_exp_flag, l_error_num, l_error_code, l_error_msg);

Line 3394: fnd_file.put_line(fnd_file.log,'item_id:'||i_item_id);

3390:
3391: fnd_file.put_line(fnd_file.log,'txn_id:'||i_txn_id);
3392: fnd_file.put_line(fnd_file.log,'txn_action_id:'||i_txn_action_id);
3393: fnd_file.put_line(fnd_file.log,'txn_source_type_id:'||i_txn_src_type_id);
3394: fnd_file.put_line(fnd_file.log,'item_id:'||i_item_id);
3395:
3396: get_exp_flag(i_item_id, i_txn_org_id, i_subinventory_code, l_exp_item,
3397: l_exp_flag, l_error_num, l_error_code, l_error_msg);
3398:

Line 3485: fnd_file.put_line(fnd_file.LOG, 'COMPLETE Processing group 2 - interorg txns across cost groups:'

3481: EXIT WHEN group2_interorg_trx%NOTFOUND;
3482: END LOOP;
3483: CLOSE group2_interorg_trx;
3484:
3485: fnd_file.put_line(fnd_file.LOG, 'COMPLETE Processing group 2 - interorg txns across cost groups:'
3486: ||l_count||'txns...'|| TO_CHAR(sysdate, 'DD-MON-RRRR HH24:MI:SS'));
3487:
3488:
3489: l_error_num := 0;

Line 3550: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV group2_interorg_trx');

3546: WHEN PROCESS_ERROR THEN
3547: o_err_num := l_error_num;
3548: o_err_code := l_error_code;
3549: o_err_msg := 'CSTPPINV.COST_INV_TXN:' || l_error_msg;
3550: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV group2_interorg_trx');
3551: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);
3552:
3553: WHEN CPPB_ERROR THEN
3554: o_err_num := l_error_num;

Line 3551: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);

3547: o_err_num := l_error_num;
3548: o_err_code := l_error_code;
3549: o_err_msg := 'CSTPPINV.COST_INV_TXN:' || l_error_msg;
3550: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV group2_interorg_trx');
3551: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);
3552:
3553: WHEN CPPB_ERROR THEN
3554: o_err_num := l_error_num;
3555: o_err_code := l_error_code;

Line 3557: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV while insert or update CPPB');

3553: WHEN CPPB_ERROR THEN
3554: o_err_num := l_error_num;
3555: o_err_code := l_error_code;
3556: o_err_msg := 'CSTPPINV:' || l_error_msg;
3557: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV while insert or update CPPB');
3558:
3559: WHEN EXP_FLAG_ERROR THEN
3560: o_err_num := l_error_num;
3561: o_err_code := l_error_code;

Line 3563: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.get_exp_flag');

3559: WHEN EXP_FLAG_ERROR THEN
3560: o_err_num := l_error_num;
3561: o_err_code := l_error_code;
3562: o_err_msg := 'CSTPPINV.get_exp_flag:' || l_error_msg;
3563: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.get_exp_flag');
3564: fnd_file.put_line(fnd_file.log,'item id:'||i_item_id || ' txn action id:' || i_txn_action_id
3565: || ' organization id:' || i_txn_org_id || ' transfer org id:' || i_txfr_org_id);
3566:
3567: WHEN OTHERS THEN

Line 3564: fnd_file.put_line(fnd_file.log,'item id:'||i_item_id || ' txn action id:' || i_txn_action_id

3560: o_err_num := l_error_num;
3561: o_err_code := l_error_code;
3562: o_err_msg := 'CSTPPINV.get_exp_flag:' || l_error_msg;
3563: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.get_exp_flag');
3564: fnd_file.put_line(fnd_file.log,'item id:'||i_item_id || ' txn action id:' || i_txn_action_id
3565: || ' organization id:' || i_txn_org_id || ' transfer org id:' || i_txfr_org_id);
3566:
3567: WHEN OTHERS THEN
3568: o_err_num := SQLCODE;

Line 3571: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.cost_interorg_txn_grp2');

3567: WHEN OTHERS THEN
3568: o_err_num := SQLCODE;
3569: o_err_msg := 'CSTPPINV (' || to_char(l_stmt_num) || '): '
3570: || substr(SQLERRM,1,150);
3571: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.cost_interorg_txn_grp2');
3572: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);
3573:
3574: END cost_interorg_txn_grp2;
3575:

Line 3572: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);

3568: o_err_num := SQLCODE;
3569: o_err_msg := 'CSTPPINV (' || to_char(l_stmt_num) || '): '
3570: || substr(SQLERRM,1,150);
3571: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.cost_interorg_txn_grp2');
3572: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);
3573:
3574: END cost_interorg_txn_grp2;
3575:
3576: -- ===================================================================================================

Line 3748: fnd_file.put_line(fnd_file.LOG, ' Start Processing group 2 - interorg txns within same cost group and non-interorg txns ... '

3744: l_end_date :=to_date(i_end_date, 'YYYY/MM/DD HH24:MI:SS') + 0.99999;
3745:
3746: l_count :=0;
3747:
3748: fnd_file.put_line(fnd_file.LOG, ' Start Processing group 2 - interorg txns within same cost group and non-interorg txns ... '
3749: || TO_CHAR(sysdate, 'DD-MON-RRRR HH24:MI:SS'));
3750:
3751: l_stmt_num := 10;
3752:

Line 3783: fnd_file.put_line(fnd_file.log,'txn_id:'||i_txn_id);

3779: i_txn_org_id := org_id_tab(i);
3780: i_txfr_org_id := trf_org_id_tab(i);
3781: i_subinventory_code := sub_inv_code_tab(i);
3782:
3783: fnd_file.put_line(fnd_file.log,'txn_id:'||i_txn_id);
3784: fnd_file.put_line(fnd_file.log,'txn_action_id:'||i_txn_action_id);
3785: fnd_file.put_line(fnd_file.log,'txn_source_type_id:'||i_txn_src_type_id);
3786: fnd_file.put_line(fnd_file.log,'item_id:'||i_item_id);
3787:

Line 3784: fnd_file.put_line(fnd_file.log,'txn_action_id:'||i_txn_action_id);

3780: i_txfr_org_id := trf_org_id_tab(i);
3781: i_subinventory_code := sub_inv_code_tab(i);
3782:
3783: fnd_file.put_line(fnd_file.log,'txn_id:'||i_txn_id);
3784: fnd_file.put_line(fnd_file.log,'txn_action_id:'||i_txn_action_id);
3785: fnd_file.put_line(fnd_file.log,'txn_source_type_id:'||i_txn_src_type_id);
3786: fnd_file.put_line(fnd_file.log,'item_id:'||i_item_id);
3787:
3788: l_stmt_num := 20;

Line 3785: fnd_file.put_line(fnd_file.log,'txn_source_type_id:'||i_txn_src_type_id);

3781: i_subinventory_code := sub_inv_code_tab(i);
3782:
3783: fnd_file.put_line(fnd_file.log,'txn_id:'||i_txn_id);
3784: fnd_file.put_line(fnd_file.log,'txn_action_id:'||i_txn_action_id);
3785: fnd_file.put_line(fnd_file.log,'txn_source_type_id:'||i_txn_src_type_id);
3786: fnd_file.put_line(fnd_file.log,'item_id:'||i_item_id);
3787:
3788: l_stmt_num := 20;
3789: get_exp_flag(i_item_id, i_txn_org_id, i_subinventory_code, l_exp_item,

Line 3786: fnd_file.put_line(fnd_file.log,'item_id:'||i_item_id);

3782:
3783: fnd_file.put_line(fnd_file.log,'txn_id:'||i_txn_id);
3784: fnd_file.put_line(fnd_file.log,'txn_action_id:'||i_txn_action_id);
3785: fnd_file.put_line(fnd_file.log,'txn_source_type_id:'||i_txn_src_type_id);
3786: fnd_file.put_line(fnd_file.log,'item_id:'||i_item_id);
3787:
3788: l_stmt_num := 20;
3789: get_exp_flag(i_item_id, i_txn_org_id, i_subinventory_code, l_exp_item,
3790: l_exp_flag, l_error_num, l_error_code, l_error_msg);

Line 3869: fnd_file.put_line(fnd_file.log,'Hook is used');

3865:
3866:
3867: /* Custom hook used */
3868: IF l_hook_used <> -1 THEN
3869: fnd_file.put_line(fnd_file.log,'Hook is used');
3870: END IF;
3871:
3872: ELSE
3873: /* other than wip source */

Line 3950: fnd_file.put_line(fnd_file.LOG, 'COMPLETE Processing group 2 - interorg txns within same cost group and non-interorg txns:'

3946: EXIT WHEN group2_trx%NOTFOUND;
3947: END LOOP;
3948: CLOSE group2_trx;
3949:
3950: fnd_file.put_line(fnd_file.LOG, 'COMPLETE Processing group 2 - interorg txns within same cost group and non-interorg txns:'
3951: ||l_count||'txns...'|| TO_CHAR(sysdate, 'DD-MON-RRRR HH24:MI:SS'));
3952:
3953:
3954: l_error_num := 0;

Line 4016: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV group2_trx');

4012: WHEN PROCESS_ERROR THEN
4013: o_err_num := l_error_num;
4014: o_err_code := l_error_code;
4015: o_err_msg := 'CSTPPINV.COST_INV_TXN:' || l_error_msg;
4016: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV group2_trx');
4017: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);
4018:
4019: WHEN CPPB_ERROR THEN
4020: o_err_num := l_error_num;

Line 4017: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);

4013: o_err_num := l_error_num;
4014: o_err_code := l_error_code;
4015: o_err_msg := 'CSTPPINV.COST_INV_TXN:' || l_error_msg;
4016: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV group2_trx');
4017: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);
4018:
4019: WHEN CPPB_ERROR THEN
4020: o_err_num := l_error_num;
4021: o_err_code := l_error_code;

Line 4023: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV group2_trx while insert or update CPPB');

4019: WHEN CPPB_ERROR THEN
4020: o_err_num := l_error_num;
4021: o_err_code := l_error_code;
4022: o_err_msg := 'CSTPPINV:' || l_error_msg;
4023: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV group2_trx while insert or update CPPB');
4024:
4025: WHEN EXP_FLAG_ERROR THEN
4026: o_err_num := l_error_num;
4027: o_err_code := l_error_code;

Line 4029: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.get_exp_flag');

4025: WHEN EXP_FLAG_ERROR THEN
4026: o_err_num := l_error_num;
4027: o_err_code := l_error_code;
4028: o_err_msg := 'CSTPPINV.get_exp_flag:' || l_error_msg;
4029: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.get_exp_flag');
4030: fnd_file.put_line(fnd_file.log,'item id:'||i_item_id || ' txn action id:' || i_txn_action_id
4031: || ' organization id:' || i_txn_org_id || ' transfer org id:' || i_txfr_org_id);
4032:
4033: WHEN CHARGE_WIP_ERROR THEN

Line 4030: fnd_file.put_line(fnd_file.log,'item id:'||i_item_id || ' txn action id:' || i_txn_action_id

4026: o_err_num := l_error_num;
4027: o_err_code := l_error_code;
4028: o_err_msg := 'CSTPPINV.get_exp_flag:' || l_error_msg;
4029: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.get_exp_flag');
4030: fnd_file.put_line(fnd_file.log,'item id:'||i_item_id || ' txn action id:' || i_txn_action_id
4031: || ' organization id:' || i_txn_org_id || ' transfer org id:' || i_txfr_org_id);
4032:
4033: WHEN CHARGE_WIP_ERROR THEN
4034: o_err_num := l_error_num;

Line 4037: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.charge_wip_material');

4033: WHEN CHARGE_WIP_ERROR THEN
4034: o_err_num := l_error_num;
4035: o_err_code := l_error_code;
4036: o_err_msg := 'CSTPPINV.charge_wip_material:' || l_error_msg;
4037: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.charge_wip_material');
4038: fnd_file.put_line(fnd_file.log,'item id:'||i_item_id || ' txn action id:' || i_txn_action_id
4039: || ' organization id:' || i_txn_org_id || ' Material Relief Algorithm:' || i_mat_relief_algo);
4040: fnd_file.put_line(fnd_file.log,' Expense Item:' || l_exp_item || ' Expense Flag:' || l_exp_flag);
4041:

Line 4038: fnd_file.put_line(fnd_file.log,'item id:'||i_item_id || ' txn action id:' || i_txn_action_id

4034: o_err_num := l_error_num;
4035: o_err_code := l_error_code;
4036: o_err_msg := 'CSTPPINV.charge_wip_material:' || l_error_msg;
4037: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.charge_wip_material');
4038: fnd_file.put_line(fnd_file.log,'item id:'||i_item_id || ' txn action id:' || i_txn_action_id
4039: || ' organization id:' || i_txn_org_id || ' Material Relief Algorithm:' || i_mat_relief_algo);
4040: fnd_file.put_line(fnd_file.log,' Expense Item:' || l_exp_item || ' Expense Flag:' || l_exp_flag);
4041:
4042: WHEN OTHERS THEN

Line 4040: fnd_file.put_line(fnd_file.log,' Expense Item:' || l_exp_item || ' Expense Flag:' || l_exp_flag);

4036: o_err_msg := 'CSTPPINV.charge_wip_material:' || l_error_msg;
4037: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.charge_wip_material');
4038: fnd_file.put_line(fnd_file.log,'item id:'||i_item_id || ' txn action id:' || i_txn_action_id
4039: || ' organization id:' || i_txn_org_id || ' Material Relief Algorithm:' || i_mat_relief_algo);
4040: fnd_file.put_line(fnd_file.log,' Expense Item:' || l_exp_item || ' Expense Flag:' || l_exp_flag);
4041:
4042: WHEN OTHERS THEN
4043: o_err_num := SQLCODE;
4044: o_err_msg := 'CSTPPINV (' || to_char(l_stmt_num) || '): '

Line 4046: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.cost_txn_grp2');

4042: WHEN OTHERS THEN
4043: o_err_num := SQLCODE;
4044: o_err_msg := 'CSTPPINV (' || to_char(l_stmt_num) || '): '
4045: || substr(SQLERRM,1,150);
4046: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.cost_txn_grp2');
4047: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);
4048:
4049: END cost_txn_grp2;
4050:

Line 4047: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);

4043: o_err_num := SQLCODE;
4044: o_err_msg := 'CSTPPINV (' || to_char(l_stmt_num) || '): '
4045: || substr(SQLERRM,1,150);
4046: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.cost_txn_grp2');
4047: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);
4048:
4049: END cost_txn_grp2;
4050:
4051: