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 577: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': return >>');

573: END IF;
574:
575: l_stmt_num := 200;
576: IF l_debug = 'Y' THEN
577: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': return >>');
578: END IF;
579:
580:
581: EXCEPTION

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

689:
690: BEGIN
691:
692: IF l_debug = 'Y' THEN
693: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': begin <<'
694: || ' transaction_id: ' || i_txn_id);
695: END IF;
696:
697: -- initialize local variables

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

724: raise process_error;
725: END IF;
726:
727: IF l_debug = 'Y' THEN
728: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'
729: || ' l_conv_rate: ' || l_conv_rate);
730: END IF;
731:
732: /* Get shipment transaction_id */

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

749: FROM mtl_material_transactions
750: WHERE transaction_id = i_txn_id;
751:
752: IF l_debug = 'Y' THEN
753: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'
754: || ' l_shipment_txn_id: ' || l_shipment_txn_id
755: || ', l_txn_src_type_id: ' || l_txn_src_type_id
756: /* || ', l_txn_id: ' || l_txn_id */
757: || ', l_trp_cost: ' || l_trp_cost);

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

768: AND mip.from_organization_id = l_from_org
769: AND mip.to_organization_id = l_to_org;
770:
771: IF l_debug = 'Y' THEN
772: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'
773: || ' l_fob_point: ' || l_fob_point);
774: END IF;
775:
776: l_stmt_num := 20;

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

815:
816: l_stmt_num := 22;
817:
818: IF l_debug = 'Y' THEN
819: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'
820: || ' l_tprice_option: ' || l_tprice_option || ', process-discrete xfer: ' || l_pd_txfr_ind);
821: END IF;
822:
823: IF ((l_tprice_option = 2)

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

838: FROM mtl_material_transactions
839: WHERE transaction_id = l_shipment_txn_id;
840:
841: IF (l_txfr_price is NULL) THEN
842: fnd_file.put_line(fnd_file.log,'Transfer Price not available');
843: l_err_msg := 'CSTPPINV.get_interorg_cost : ' || to_char(l_stmt_num) ||' : '|| ' Transfer Price not available';
844: l_err_num := 9999;
845: raise process_error;
846: END IF;

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

845: raise process_error;
846: END IF;
847:
848: IF l_debug = 'Y' THEN
849: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'
850: || ' l_txfr_price: ' || l_txfr_price);
851: END IF;
852:
853: l_stmt_num := 30;

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

879:
880: -- discrete-discrete interorg transfer
881:
882: IF l_debug = 'Y' THEN
883: fnd_file.put_line(fnd_file.log,' Regular Interorg Transfer:' || ' discrete-discrete xfer: ');
884: END IF;
885:
886: IF ((l_tprice_option = 1)
887: AND ((i_txn_action_id in (21,22) AND l_txn_src_type_id = 8)

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

936: WHERE LEGAL_ENTITY = i_legal_entity
937: AND COST_TYPE_ID = i_cost_type_id;
938:
939: IF l_debug = 'Y' THEN
940: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'
941: || ' l_txfr_legal_entity: ' || l_txfr_legal_entity
942: || ', l_same_le_ct: ' || l_same_le_ct
943: || ', l_transfer_cost_flag (PACP): ' || l_transfer_cost_flag);
944: END IF;

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

963: L_COST_SOURCE_COST_GROUP := I_TXFR_COST_GROUP_ID;
964: END IF;
965:
966: IF l_debug = 'Y' THEN
967: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'
968: || ' l_cost_source_cost_group: ' || l_cost_source_cost_group);
969: END IF;
970:
971: IF (l_transfer_cost_flag = 'Y') THEN

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

970:
971: IF (l_transfer_cost_flag = 'Y') THEN
972:
973: IF l_debug = 'Y' THEN
974: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'
975: || ' Same LE/CT Transfer with PACP enabled');
976: END IF;
977:
978: /* Use PACP cost if available */

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

1036:
1037: l_stmt_num := 80;
1038:
1039: IF l_debug = 'Y' THEN
1040: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'
1041: || ' Same LE/CT Transfer with PACP not enabled');
1042: END IF;
1043:
1044: /* PACP is not enabled. Use prior period sending CG PWAC Cost */

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

1105:
1106: l_stmt_num := 120;
1107:
1108: IF l_debug = 'Y' THEN
1109: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':' || ' Different LE/CT Transfer:');
1110: END IF;
1111:
1112: /* Sending and Receiving Orgs not in the same LE/CT
1113: Use MTA Cost */

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

1138:
1139: END IF; /* IF (i_legal_entity = l_txfr_legal_entity AND l_same_le_ct > 0) THEN */
1140:
1141: IF l_debug = 'Y' THEN
1142: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'
1143: || ' l_sending_cg_cost: ' || l_sending_cg_cost);
1144: END IF;
1145:
1146:

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

1162: raise process_error;
1163: END IF;
1164:
1165: l_ovhd_cost := (l_trp_cost + l_txfr_credit) * l_conv_rate;
1166: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': l_ovhd_cost = ' || l_ovhd_cost);
1167:
1168: IF (l_ovhd_cost > 0) THEN
1169: CSTPPINV.add_elemental_cost(
1170: i_pac_period_id => i_pac_period_id,

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

1194:
1195: ELSE -- INVCONV Process-Discrete Transfer.
1196:
1197: IF l_debug = 'Y' THEN
1198: fnd_file.put_line(fnd_file.log,' INVCONV process-discrete xfer');
1199: END IF;
1200:
1201: l_stmt_num := 145;
1202:

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

1243:
1244: l_stmt_num := 150;
1245:
1246: IF l_debug = 'Y' THEN
1247: fnd_file.put_line(fnd_file.log,' transfer price stamped: ' || i_transfer_price_pd);
1248: fnd_file.put_line(fnd_file.log,' txn_axn_id/qty: ' || i_txn_action_id || '/' || i_txn_qty);
1249: END IF;
1250:
1251: /* Don't earn overhead for Transportation Cost for Direct Interorg Receipt */

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

1244: l_stmt_num := 150;
1245:
1246: IF l_debug = 'Y' THEN
1247: fnd_file.put_line(fnd_file.log,' transfer price stamped: ' || i_transfer_price_pd);
1248: fnd_file.put_line(fnd_file.log,' txn_axn_id/qty: ' || i_txn_action_id || '/' || i_txn_qty);
1249: END IF;
1250:
1251: /* Don't earn overhead for Transportation Cost for Direct Interorg Receipt */
1252: /* Also transfer cost=transfer price for receiving org, intransit rcpt, fob rcpt */

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

1252: /* Also transfer cost=transfer price for receiving org, intransit rcpt, fob rcpt */
1253: IF ((i_txn_action_id = 3 and i_txn_qty > 0) or (i_txn_action_id=12 and l_fob_point=2)) THEN
1254:
1255: IF l_debug = 'Y' THEN
1256: fnd_file.put_line(fnd_file.log,' No MOH earned: ');
1257: END IF;
1258:
1259: ELSE -- Earn MOH in all other cases
1260:

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

1301: SYSDATE,
1302: i_login_id);
1303:
1304: IF l_debug = 'Y' THEN
1305: fnd_file.put_line(fnd_file.log,' transportation cost as MOH stamped: ' || l_trp_cost);
1306: END IF;
1307:
1308: 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 */
1309:

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

1311:
1312: l_stmt_num := 200;
1313:
1314: IF l_debug = 'Y' THEN
1315: fnd_file.put_line(fnd_file.log,l_api_name || ': ' || l_stmt_num || ': return >>');
1316: END IF;
1317:
1318: EXCEPTION
1319:

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

1325: when OTHERS then
1326: o_err_num := SQLCODE;
1327: o_err_msg := 'CSTPPINV.get_interorg_cost (' || to_char(l_stmt_num) ||
1328: '): ' || substr(SQLERRM,1,200);
1329: fnd_file.put_line(fnd_file.log, o_err_msg);
1330:
1331: END get_interorg_cost;
1332:
1333: /*---------------------------------------------------------------------------

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

1370:
1371: BEGIN
1372:
1373: IF l_debug = 'Y' THEN
1374: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': begin <<'
1375: || ' source_transaction_id: ' || i_source_txn_id
1376: || ' source_cost: ' || i_source_cost);
1377: END IF;
1378:

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

1395: FROM mtl_material_transactions
1396: WHERE transaction_id = i_source_txn_id;
1397:
1398: IF l_debug = 'Y' THEN
1399: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'
1400: || ' l_txfr_percent: ' || l_txfr_percent
1401: || ', l_txfr_cost: ' || l_txfr_cost
1402: || ', l_trp_cost: ' || l_trp_cost
1403: || ', l_shipment_txn_qty: ' || l_shipment_txn_qty);

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

1417: x_txfr_credit := l_txfr_credit;
1418: x_trp_cost := l_trp_cost / abs(l_shipment_txn_qty);
1419:
1420: IF l_debug = 'Y' THEN
1421: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'
1422: || ' x_txfr_credit: ' || x_txfr_credit
1423: || ', x_trp_cost: ' || x_trp_cost);
1424: END IF;
1425:

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

1425:
1426: l_stmt_num := 40;
1427:
1428: IF l_debug = 'Y' THEN
1429: fnd_file.put_line(fnd_file.log,l_api_name || ': ' || l_stmt_num || ': return >>');
1430: END IF;
1431:
1432: EXCEPTION
1433:

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

1434: when OTHERS then
1435: o_err_num := SQLCODE;
1436: o_err_msg := 'CSTPPINV.get_txfr_trp_cost (' || to_char(l_stmt_num) ||
1437: '): ' || substr(SQLERRM,1,200);
1438: fnd_file.put_line(fnd_file.log, o_err_msg);
1439:
1440: END get_txfr_trp_cost;
1441:
1442: /*---------------------------------------------------------------------------

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

1481:
1482: BEGIN
1483:
1484: IF l_debug = 'Y' THEN
1485: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': begin <<'
1486: || ' i_txn_id: ' || i_txn_id);
1487: END IF;
1488:
1489: -- initialize local variables

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

1547:
1548: l_stmt_num := 40;
1549:
1550: IF l_debug = 'Y' THEN
1551: fnd_file.put_line(fnd_file.log,l_api_name || ': ' || l_stmt_num || ': return >>');
1552: END IF;
1553:
1554: EXCEPTION
1555:

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

1561: when OTHERS then
1562: o_err_num := SQLCODE;
1563: o_err_msg := 'CSTPPINV.add_elemental_cost (' || to_char(l_stmt_num) ||
1564: '): ' || substr(SQLERRM,1,200);
1565: fnd_file.put_line(fnd_file.log, o_err_msg);
1566: END add_elemental_cost;
1567:
1568: /*---------------------------------------------------------------------------
1569: | Procedure insert_elemental_cost()

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

1604:
1605: BEGIN
1606:
1607: IF l_debug = 'Y' THEN
1608: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': begin <<'
1609: || ' i_txn_id: ' || i_txn_id);
1610: END IF;
1611:
1612: -- initialize local variables

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

1657:
1658: l_stmt_num := 20;
1659:
1660: IF l_debug = 'Y' THEN
1661: fnd_file.put_line(fnd_file.log,l_api_name || ': ' || l_stmt_num || ': return >>');
1662: END IF;
1663:
1664: EXCEPTION
1665: when OTHERS then

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

1665: when OTHERS then
1666: o_err_num := SQLCODE;
1667: o_err_msg := 'CSTPPINV.insert_elemental_cost (' || to_char(l_stmt_num) ||
1668: '): ' || substr(SQLERRM,1,200);
1669: fnd_file.put_line(fnd_file.log, o_err_msg);
1670: END insert_elemental_cost;
1671:
1672:
1673: /*---------------------------------------------------------------------------

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

1709:
1710: BEGIN
1711:
1712: IF l_debug = 'Y' THEN
1713: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': begin <<'
1714: || ' i_txn_id: ' || i_txn_id);
1715: END IF;
1716:
1717: -- initialize local variables

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

1786: x_pacp_used := 1;
1787: x_pacp_cost := l_pacp_pwac_cost;
1788:
1789: IF l_debug = 'Y' THEN
1790: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ':'
1791: || ' x_pacp_used: ' || x_pacp_used
1792: || ', x_pacp_cost: ' || x_pacp_cost);
1793: END IF;
1794:

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

1794:
1795: l_stmt_num := 110;
1796:
1797: IF l_debug = 'Y' THEN
1798: fnd_file.put_line(fnd_file.log,l_api_name || ': ' || l_stmt_num || ': return >>');
1799: END IF;
1800:
1801: EXCEPTION
1802:

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

1803: when OTHERS then
1804: o_err_num := SQLCODE;
1805: o_err_msg := 'CSTPPINV.get_pacp_cost (' || to_char(l_stmt_num) ||
1806: '): ' || substr(SQLERRM,1,200);
1807: fnd_file.put_line(fnd_file.log, o_err_msg);
1808:
1809: END get_pacp_cost;
1810:
1811: /*---------------------------------------------------------------------------

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

1853:
1854: BEGIN
1855:
1856: IF l_debug = 'Y' THEN
1857: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': begin <<'
1858: || ' transaction_id: ' || i_txn_id);
1859: END IF;
1860:
1861: -- initialize local variables

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

1962:
1963: l_stmt_num := 200;
1964:
1965: IF l_debug = 'Y' THEN
1966: fnd_file.put_line(fnd_file.log,l_api_name || ': ' || l_stmt_num || ': return >>');
1967: END IF;
1968:
1969: EXCEPTION
1970:

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

1971: when OTHERS then
1972: o_err_num := SQLCODE;
1973: o_err_msg := 'CSTPPINV.get_prev_period_cost (' || to_char(l_stmt_num) ||
1974: '): ' || substr(SQLERRM,1,200);
1975: fnd_file.put_line(fnd_file.log, o_err_msg);
1976:
1977: END get_prev_period_cost;
1978:
1979: /*---------------------------------------------------------------------------

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

2017:
2018: BEGIN
2019:
2020: IF l_debug = 'Y' THEN
2021: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': begin <<'
2022: || ' transaction_id: ' || i_txn_id
2023: || ' i_mta_txn_id: ' || i_mta_txn_id);
2024: END IF;
2025:

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

2035: FROM mtl_material_transactions
2036: WHERE transaction_id = i_mta_txn_id;
2037:
2038: IF l_debug = 'Y' THEN
2039: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': l_mta_txn_qty = ' || l_mta_txn_qty);
2040: END IF;
2041:
2042: /* Select the perpetual accounted value for the sending org's credit
2043: to On-hand (either Inventory or Expense accounting line type). */

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

2054: l_perp_ship_cost := 0;
2055: END;
2056:
2057: IF l_debug = 'Y' THEN
2058: fnd_file.put_line(fnd_file.log, l_api_name || ': ' || l_stmt_num || ': l_perp_ship_cost = ' || l_perp_ship_cost);
2059: END IF;
2060:
2061: IF l_perp_ship_cost <> 0 THEN
2062: /* Insert all cost elements */

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

2129: l_stmt_num := 30;
2130: x_perp_ship_cost := l_perp_ship_cost;
2131:
2132: IF l_debug = 'Y' THEN
2133: fnd_file.put_line(fnd_file.log,l_api_name || ': ' || l_stmt_num || ': return >>');
2134: END IF;
2135:
2136: EXCEPTION
2137:

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

2138: when OTHERS then
2139: o_err_num := SQLCODE;
2140: o_err_msg := 'CSTPPINV.get_perp_ship_cost (' || to_char(l_stmt_num) ||
2141: '): ' || substr(SQLERRM,1,200);
2142: fnd_file.put_line(fnd_file.log, o_err_msg);
2143:
2144: END get_perp_ship_cost;
2145:
2146:

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

2411: l_err_code := '';
2412: l_err_msg := '';
2413:
2414: l_stmt_num := 10;
2415: fnd_file.put_line(fnd_file.log,'In Cost_Acct_Events: Txn ID:' ||
2416: to_char(i_txn_id));
2417:
2418: /* Determine parent transaction id and parent_transaction organization id */
2419:

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

2903: l_end_date :=to_date(i_end_date, 'YYYY/MM/DD HH24:MI:SS') + 0.99999;
2904:
2905: l_count :=0;
2906:
2907: fnd_file.put_line(fnd_file.LOG, ' Start Processing group 1 - interorg txns across cost groups... '
2908: || TO_CHAR(sysdate, 'DD-MON-RRRR HH24:MI:SS'));
2909:
2910: l_stmt_num := 10;
2911:

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

2939: i_txfr_org_id := trf_org_id_tab(i);
2940: i_subinventory_code := sub_inv_code_tab(i);
2941: i_trf_price := trf_price_tab(i);
2942:
2943: fnd_file.put_line(fnd_file.log,'txn_id:'||i_txn_id);
2944: fnd_file.put_line(fnd_file.log,'txn_action_id:'||i_txn_action_id);
2945: fnd_file.put_line(fnd_file.log,'txn_source_type_id:'||i_txn_src_type_id);
2946: fnd_file.put_line(fnd_file.log,'item_id:'||i_item_id);
2947:

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

2940: i_subinventory_code := sub_inv_code_tab(i);
2941: i_trf_price := trf_price_tab(i);
2942:
2943: fnd_file.put_line(fnd_file.log,'txn_id:'||i_txn_id);
2944: fnd_file.put_line(fnd_file.log,'txn_action_id:'||i_txn_action_id);
2945: fnd_file.put_line(fnd_file.log,'txn_source_type_id:'||i_txn_src_type_id);
2946: fnd_file.put_line(fnd_file.log,'item_id:'||i_item_id);
2947:
2948: /* Any intransit shipments in this cursor are FOB shipment processed by receiving CG,

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

2941: i_trf_price := trf_price_tab(i);
2942:
2943: fnd_file.put_line(fnd_file.log,'txn_id:'||i_txn_id);
2944: fnd_file.put_line(fnd_file.log,'txn_action_id:'||i_txn_action_id);
2945: fnd_file.put_line(fnd_file.log,'txn_source_type_id:'||i_txn_src_type_id);
2946: fnd_file.put_line(fnd_file.log,'item_id:'||i_item_id);
2947:
2948: /* Any intransit shipments in this cursor are FOB shipment processed by receiving CG,
2949: so we should be passing in the txfr_txn_org_id to determine expense status.

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

2942:
2943: fnd_file.put_line(fnd_file.log,'txn_id:'||i_txn_id);
2944: fnd_file.put_line(fnd_file.log,'txn_action_id:'||i_txn_action_id);
2945: fnd_file.put_line(fnd_file.log,'txn_source_type_id:'||i_txn_src_type_id);
2946: fnd_file.put_line(fnd_file.log,'item_id:'||i_item_id);
2947:
2948: /* Any intransit shipments in this cursor are FOB shipment processed by receiving CG,
2949: so we should be passing in the txfr_txn_org_id to determine expense status.
2950: Since this step hits receiving org's intransit, it is assumed to be asset sub,

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

3042: EXIT WHEN inter_trx%NOTFOUND;
3043: END LOOP;
3044: CLOSE inter_trx;
3045:
3046: fnd_file.put_line(fnd_file.LOG, 'COMPLETE Processing group 1 - interorg txns across cost groups:'
3047: ||l_count||'txns...'|| TO_CHAR(sysdate, 'DD-MON-RRRR HH24:MI:SS'));
3048:
3049:
3050: l_error_num := 0;

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

3107: WHEN PROCESS_ERROR THEN
3108: o_err_num := l_error_num;
3109: o_err_code := l_error_code;
3110: o_err_msg := 'CSTPPINV.COST_INV_TXN:' || l_error_msg;
3111: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV inter_trx');
3112: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);
3113:
3114: WHEN CPPB_ERROR THEN
3115: o_err_num := l_error_num;

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

3108: o_err_num := l_error_num;
3109: o_err_code := l_error_code;
3110: o_err_msg := 'CSTPPINV.COST_INV_TXN:' || l_error_msg;
3111: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV inter_trx');
3112: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);
3113:
3114: WHEN CPPB_ERROR THEN
3115: o_err_num := l_error_num;
3116: o_err_code := l_error_code;

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

3114: WHEN CPPB_ERROR THEN
3115: o_err_num := l_error_num;
3116: o_err_code := l_error_code;
3117: o_err_msg := 'CSTPPINV:' || l_error_msg;
3118: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV while insert or update CPPB');
3119:
3120: WHEN EXP_FLAG_ERROR THEN
3121: o_err_num := l_error_num;
3122: o_err_code := l_error_code;

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

3120: WHEN EXP_FLAG_ERROR THEN
3121: o_err_num := l_error_num;
3122: o_err_code := l_error_code;
3123: o_err_msg := 'CSTPPINV.get_exp_flag:' || l_error_msg;
3124: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.get_exp_flag');
3125: fnd_file.put_line(fnd_file.log,'item id:'||i_item_id || ' txn action id:' || i_txn_action_id
3126: || ' organization id:' || i_txn_org_id || ' transfer org id:' || i_txfr_org_id);
3127:
3128: WHEN OTHERS THEN

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

3121: o_err_num := l_error_num;
3122: o_err_code := l_error_code;
3123: o_err_msg := 'CSTPPINV.get_exp_flag:' || l_error_msg;
3124: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.get_exp_flag');
3125: fnd_file.put_line(fnd_file.log,'item id:'||i_item_id || ' txn action id:' || i_txn_action_id
3126: || ' organization id:' || i_txn_org_id || ' transfer org id:' || i_txfr_org_id);
3127:
3128: WHEN OTHERS THEN
3129: o_err_num := SQLCODE;

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

3128: WHEN OTHERS THEN
3129: o_err_num := SQLCODE;
3130: o_err_msg := 'CSTPPINV (' || to_char(l_stmt_num) || '): '
3131: || substr(SQLERRM,1,150);
3132: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.cost_interorg_txn_grp1');
3133: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);
3134:
3135: END cost_interorg_txn_grp1;
3136:

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

3129: o_err_num := SQLCODE;
3130: o_err_msg := 'CSTPPINV (' || to_char(l_stmt_num) || '): '
3131: || substr(SQLERRM,1,150);
3132: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.cost_interorg_txn_grp1');
3133: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);
3134:
3135: END cost_interorg_txn_grp1;
3136:
3137: -- ===================================================================================================

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

3299: l_end_date :=to_date(i_end_date, 'YYYY/MM/DD HH24:MI:SS') + 0.99999;
3300:
3301: l_count :=0;
3302:
3303: fnd_file.put_line(fnd_file.LOG, ' Start Processing group 2 - interorg txns across cost groups... '
3304: || TO_CHAR(sysdate, 'DD-MON-RRRR HH24:MI:SS'));
3305:
3306: l_stmt_num := 10;
3307:

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

3335: i_txfr_org_id := trf_org_id_tab(i);
3336: i_subinventory_code := sub_inv_code_tab(i);
3337: i_trf_price := trf_price_tab(i);
3338:
3339: fnd_file.put_line(fnd_file.log,'txn_id:'||i_txn_id);
3340: fnd_file.put_line(fnd_file.log,'txn_action_id:'||i_txn_action_id);
3341: fnd_file.put_line(fnd_file.log,'txn_source_type_id:'||i_txn_src_type_id);
3342: fnd_file.put_line(fnd_file.log,'item_id:'||i_item_id);
3343:

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

3336: i_subinventory_code := sub_inv_code_tab(i);
3337: i_trf_price := trf_price_tab(i);
3338:
3339: fnd_file.put_line(fnd_file.log,'txn_id:'||i_txn_id);
3340: fnd_file.put_line(fnd_file.log,'txn_action_id:'||i_txn_action_id);
3341: fnd_file.put_line(fnd_file.log,'txn_source_type_id:'||i_txn_src_type_id);
3342: fnd_file.put_line(fnd_file.log,'item_id:'||i_item_id);
3343:
3344: get_exp_flag(i_item_id, i_txn_org_id, i_subinventory_code, l_exp_item,

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

3337: i_trf_price := trf_price_tab(i);
3338:
3339: fnd_file.put_line(fnd_file.log,'txn_id:'||i_txn_id);
3340: fnd_file.put_line(fnd_file.log,'txn_action_id:'||i_txn_action_id);
3341: fnd_file.put_line(fnd_file.log,'txn_source_type_id:'||i_txn_src_type_id);
3342: fnd_file.put_line(fnd_file.log,'item_id:'||i_item_id);
3343:
3344: get_exp_flag(i_item_id, i_txn_org_id, i_subinventory_code, l_exp_item,
3345: l_exp_flag, l_error_num, l_error_code, l_error_msg);

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

3338:
3339: fnd_file.put_line(fnd_file.log,'txn_id:'||i_txn_id);
3340: fnd_file.put_line(fnd_file.log,'txn_action_id:'||i_txn_action_id);
3341: fnd_file.put_line(fnd_file.log,'txn_source_type_id:'||i_txn_src_type_id);
3342: fnd_file.put_line(fnd_file.log,'item_id:'||i_item_id);
3343:
3344: get_exp_flag(i_item_id, i_txn_org_id, i_subinventory_code, l_exp_item,
3345: l_exp_flag, l_error_num, l_error_code, l_error_msg);
3346:

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

3429: EXIT WHEN group2_interorg_trx%NOTFOUND;
3430: END LOOP;
3431: CLOSE group2_interorg_trx;
3432:
3433: fnd_file.put_line(fnd_file.LOG, 'COMPLETE Processing group 2 - interorg txns across cost groups:'
3434: ||l_count||'txns...'|| TO_CHAR(sysdate, 'DD-MON-RRRR HH24:MI:SS'));
3435:
3436:
3437: l_error_num := 0;

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

3494: WHEN PROCESS_ERROR THEN
3495: o_err_num := l_error_num;
3496: o_err_code := l_error_code;
3497: o_err_msg := 'CSTPPINV.COST_INV_TXN:' || l_error_msg;
3498: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV group2_interorg_trx');
3499: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);
3500:
3501: WHEN CPPB_ERROR THEN
3502: o_err_num := l_error_num;

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

3495: o_err_num := l_error_num;
3496: o_err_code := l_error_code;
3497: o_err_msg := 'CSTPPINV.COST_INV_TXN:' || l_error_msg;
3498: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV group2_interorg_trx');
3499: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);
3500:
3501: WHEN CPPB_ERROR THEN
3502: o_err_num := l_error_num;
3503: o_err_code := l_error_code;

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

3501: WHEN CPPB_ERROR THEN
3502: o_err_num := l_error_num;
3503: o_err_code := l_error_code;
3504: o_err_msg := 'CSTPPINV:' || l_error_msg;
3505: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV while insert or update CPPB');
3506:
3507: WHEN EXP_FLAG_ERROR THEN
3508: o_err_num := l_error_num;
3509: o_err_code := l_error_code;

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

3507: WHEN EXP_FLAG_ERROR THEN
3508: o_err_num := l_error_num;
3509: o_err_code := l_error_code;
3510: o_err_msg := 'CSTPPINV.get_exp_flag:' || l_error_msg;
3511: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.get_exp_flag');
3512: fnd_file.put_line(fnd_file.log,'item id:'||i_item_id || ' txn action id:' || i_txn_action_id
3513: || ' organization id:' || i_txn_org_id || ' transfer org id:' || i_txfr_org_id);
3514:
3515: WHEN OTHERS THEN

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

3508: o_err_num := l_error_num;
3509: o_err_code := l_error_code;
3510: o_err_msg := 'CSTPPINV.get_exp_flag:' || l_error_msg;
3511: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.get_exp_flag');
3512: fnd_file.put_line(fnd_file.log,'item id:'||i_item_id || ' txn action id:' || i_txn_action_id
3513: || ' organization id:' || i_txn_org_id || ' transfer org id:' || i_txfr_org_id);
3514:
3515: WHEN OTHERS THEN
3516: o_err_num := SQLCODE;

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

3515: WHEN OTHERS THEN
3516: o_err_num := SQLCODE;
3517: o_err_msg := 'CSTPPINV (' || to_char(l_stmt_num) || '): '
3518: || substr(SQLERRM,1,150);
3519: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.cost_interorg_txn_grp2');
3520: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);
3521:
3522: END cost_interorg_txn_grp2;
3523:

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

3516: o_err_num := SQLCODE;
3517: o_err_msg := 'CSTPPINV (' || to_char(l_stmt_num) || '): '
3518: || substr(SQLERRM,1,150);
3519: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.cost_interorg_txn_grp2');
3520: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);
3521:
3522: END cost_interorg_txn_grp2;
3523:
3524: -- ===================================================================================================

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

3696: l_end_date :=to_date(i_end_date, 'YYYY/MM/DD HH24:MI:SS') + 0.99999;
3697:
3698: l_count :=0;
3699:
3700: fnd_file.put_line(fnd_file.LOG, ' Start Processing group 2 - interorg txns within same cost group and non-interorg txns ... '
3701: || TO_CHAR(sysdate, 'DD-MON-RRRR HH24:MI:SS'));
3702:
3703: l_stmt_num := 10;
3704:

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

3731: i_txn_org_id := org_id_tab(i);
3732: i_txfr_org_id := trf_org_id_tab(i);
3733: i_subinventory_code := sub_inv_code_tab(i);
3734:
3735: fnd_file.put_line(fnd_file.log,'txn_id:'||i_txn_id);
3736: fnd_file.put_line(fnd_file.log,'txn_action_id:'||i_txn_action_id);
3737: fnd_file.put_line(fnd_file.log,'txn_source_type_id:'||i_txn_src_type_id);
3738: fnd_file.put_line(fnd_file.log,'item_id:'||i_item_id);
3739:

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

3732: i_txfr_org_id := trf_org_id_tab(i);
3733: i_subinventory_code := sub_inv_code_tab(i);
3734:
3735: fnd_file.put_line(fnd_file.log,'txn_id:'||i_txn_id);
3736: fnd_file.put_line(fnd_file.log,'txn_action_id:'||i_txn_action_id);
3737: fnd_file.put_line(fnd_file.log,'txn_source_type_id:'||i_txn_src_type_id);
3738: fnd_file.put_line(fnd_file.log,'item_id:'||i_item_id);
3739:
3740: l_stmt_num := 20;

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

3733: i_subinventory_code := sub_inv_code_tab(i);
3734:
3735: fnd_file.put_line(fnd_file.log,'txn_id:'||i_txn_id);
3736: fnd_file.put_line(fnd_file.log,'txn_action_id:'||i_txn_action_id);
3737: fnd_file.put_line(fnd_file.log,'txn_source_type_id:'||i_txn_src_type_id);
3738: fnd_file.put_line(fnd_file.log,'item_id:'||i_item_id);
3739:
3740: l_stmt_num := 20;
3741: get_exp_flag(i_item_id, i_txn_org_id, i_subinventory_code, l_exp_item,

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

3734:
3735: fnd_file.put_line(fnd_file.log,'txn_id:'||i_txn_id);
3736: fnd_file.put_line(fnd_file.log,'txn_action_id:'||i_txn_action_id);
3737: fnd_file.put_line(fnd_file.log,'txn_source_type_id:'||i_txn_src_type_id);
3738: fnd_file.put_line(fnd_file.log,'item_id:'||i_item_id);
3739:
3740: l_stmt_num := 20;
3741: get_exp_flag(i_item_id, i_txn_org_id, i_subinventory_code, l_exp_item,
3742: l_exp_flag, l_error_num, l_error_code, l_error_msg);

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

3817:
3818:
3819: /* Custom hook used */
3820: IF l_hook_used <> -1 THEN
3821: fnd_file.put_line(fnd_file.log,'Hook is used');
3822: END IF;
3823:
3824: ELSE
3825: /* other than wip source */

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

3898: EXIT WHEN group2_trx%NOTFOUND;
3899: END LOOP;
3900: CLOSE group2_trx;
3901:
3902: fnd_file.put_line(fnd_file.LOG, 'COMPLETE Processing group 2 - interorg txns within same cost group and non-interorg txns:'
3903: ||l_count||'txns...'|| TO_CHAR(sysdate, 'DD-MON-RRRR HH24:MI:SS'));
3904:
3905:
3906: l_error_num := 0;

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

3964: WHEN PROCESS_ERROR THEN
3965: o_err_num := l_error_num;
3966: o_err_code := l_error_code;
3967: o_err_msg := 'CSTPPINV.COST_INV_TXN:' || l_error_msg;
3968: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV group2_trx');
3969: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);
3970:
3971: WHEN CPPB_ERROR THEN
3972: o_err_num := l_error_num;

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

3965: o_err_num := l_error_num;
3966: o_err_code := l_error_code;
3967: o_err_msg := 'CSTPPINV.COST_INV_TXN:' || l_error_msg;
3968: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV group2_trx');
3969: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);
3970:
3971: WHEN CPPB_ERROR THEN
3972: o_err_num := l_error_num;
3973: o_err_code := l_error_code;

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

3971: WHEN CPPB_ERROR THEN
3972: o_err_num := l_error_num;
3973: o_err_code := l_error_code;
3974: o_err_msg := 'CSTPPINV:' || l_error_msg;
3975: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV group2_trx while insert or update CPPB');
3976:
3977: WHEN EXP_FLAG_ERROR THEN
3978: o_err_num := l_error_num;
3979: o_err_code := l_error_code;

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

3977: WHEN EXP_FLAG_ERROR THEN
3978: o_err_num := l_error_num;
3979: o_err_code := l_error_code;
3980: o_err_msg := 'CSTPPINV.get_exp_flag:' || l_error_msg;
3981: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.get_exp_flag');
3982: fnd_file.put_line(fnd_file.log,'item id:'||i_item_id || ' txn action id:' || i_txn_action_id
3983: || ' organization id:' || i_txn_org_id || ' transfer org id:' || i_txfr_org_id);
3984:
3985: WHEN CHARGE_WIP_ERROR THEN

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

3978: o_err_num := l_error_num;
3979: o_err_code := l_error_code;
3980: o_err_msg := 'CSTPPINV.get_exp_flag:' || l_error_msg;
3981: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.get_exp_flag');
3982: fnd_file.put_line(fnd_file.log,'item id:'||i_item_id || ' txn action id:' || i_txn_action_id
3983: || ' organization id:' || i_txn_org_id || ' transfer org id:' || i_txfr_org_id);
3984:
3985: WHEN CHARGE_WIP_ERROR THEN
3986: o_err_num := l_error_num;

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

3985: WHEN CHARGE_WIP_ERROR THEN
3986: o_err_num := l_error_num;
3987: o_err_code := l_error_code;
3988: o_err_msg := 'CSTPPINV.charge_wip_material:' || l_error_msg;
3989: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.charge_wip_material');
3990: fnd_file.put_line(fnd_file.log,'item id:'||i_item_id || ' txn action id:' || i_txn_action_id
3991: || ' organization id:' || i_txn_org_id || ' Material Relief Algorithm:' || i_mat_relief_algo);
3992: fnd_file.put_line(fnd_file.log,' Expense Item:' || l_exp_item || ' Expense Flag:' || l_exp_flag);
3993:

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

3986: o_err_num := l_error_num;
3987: o_err_code := l_error_code;
3988: o_err_msg := 'CSTPPINV.charge_wip_material:' || l_error_msg;
3989: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.charge_wip_material');
3990: fnd_file.put_line(fnd_file.log,'item id:'||i_item_id || ' txn action id:' || i_txn_action_id
3991: || ' organization id:' || i_txn_org_id || ' Material Relief Algorithm:' || i_mat_relief_algo);
3992: fnd_file.put_line(fnd_file.log,' Expense Item:' || l_exp_item || ' Expense Flag:' || l_exp_flag);
3993:
3994: WHEN OTHERS THEN

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

3988: o_err_msg := 'CSTPPINV.charge_wip_material:' || l_error_msg;
3989: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.charge_wip_material');
3990: fnd_file.put_line(fnd_file.log,'item id:'||i_item_id || ' txn action id:' || i_txn_action_id
3991: || ' organization id:' || i_txn_org_id || ' Material Relief Algorithm:' || i_mat_relief_algo);
3992: fnd_file.put_line(fnd_file.log,' Expense Item:' || l_exp_item || ' Expense Flag:' || l_exp_flag);
3993:
3994: WHEN OTHERS THEN
3995: o_err_num := SQLCODE;
3996: o_err_msg := 'CSTPPINV (' || to_char(l_stmt_num) || '): '

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

3994: WHEN OTHERS THEN
3995: o_err_num := SQLCODE;
3996: o_err_msg := 'CSTPPINV (' || to_char(l_stmt_num) || '): '
3997: || substr(SQLERRM,1,150);
3998: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.cost_txn_grp2');
3999: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);
4000:
4001: END cost_txn_grp2;
4002:

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

3995: o_err_num := SQLCODE;
3996: o_err_msg := 'CSTPPINV (' || to_char(l_stmt_num) || '): '
3997: || substr(SQLERRM,1,150);
3998: fnd_file.put_line(fnd_file.log,'Errored out txns in CSTPPINV.cost_txn_grp2');
3999: fnd_file.put_line(fnd_file.log,'txn_id'||i_txn_id);
4000:
4001: END cost_txn_grp2;
4002:
4003: