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.CSP_PARTS_ORDER dependencies on FND_LOG

Line 1253: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1249: l_item_cost NUMBER;
1250: l_scheduling_code VARCHAR2(30);
1251: BEGIN
1252:
1253: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1254: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1255: 'csp.plsql.csp_parts_order.process_order',
1256: 'Begin');
1257: end if;

Line 1254: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1250: l_scheduling_code VARCHAR2(30);
1251: BEGIN
1252:
1253: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1254: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1255: 'csp.plsql.csp_parts_order.process_order',
1256: 'Begin');
1257: end if;
1258:

Line 1301: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1297: INTO l_org_id
1298: FROM dual;
1299: po_moac_utils_pvt.set_org_context(l_org_id);
1300:
1301: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1302: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1303: 'csp.plsql.csp_parts_order.process_order',
1304: 'Setting org context for l_org_id = ' || l_org_id);
1305: end if;

Line 1302: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1298: FROM dual;
1299: po_moac_utils_pvt.set_org_context(l_org_id);
1300:
1301: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1302: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1303: 'csp.plsql.csp_parts_order.process_order',
1304: 'Setting org context for l_org_id = ' || l_org_id);
1305: end if;
1306:

Line 1318: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1314: OPEN set_of_books_cur (l_org_id);
1315: FETCH set_of_books_cur INTO l_set_of_books_id;
1316: CLOSE set_of_books_cur;
1317:
1318: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1319: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1320: 'csp.plsql.csp_parts_order.process_order',
1321: 'l_header_rec.operation = ' || l_header_rec.operation);
1322: end if;

Line 1319: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1315: FETCH set_of_books_cur INTO l_set_of_books_id;
1316: CLOSE set_of_books_cur;
1317:
1318: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1319: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1320: 'csp.plsql.csp_parts_order.process_order',
1321: 'l_header_rec.operation = ' || l_header_rec.operation);
1322: end if;
1323:

Line 1338: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1334: RAISE FND_API.G_EXC_ERROR;
1335: END IF;
1336: ELSE
1337:
1338: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1339: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1340: 'csp.plsql.csp_parts_order.process_order',
1341: 'p_process_Type = ' || p_process_Type);
1342: end if;

Line 1339: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1335: END IF;
1336: ELSE
1337:
1338: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1339: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1340: 'csp.plsql.csp_parts_order.process_order',
1341: 'p_process_Type = ' || p_process_Type);
1342: end if;
1343:

Line 1352: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1348: OPEN address_type_cur(l_header_rec.requirement_header_id);
1349: FETCH address_type_cur INTO l_address_type, l_ship_to_location_id, l_resource_id, l_resource_type;
1350: CLOSE address_type_cur;
1351:
1352: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1353: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1354: 'csp.plsql.csp_parts_order.process_order',
1355: 'l_address_type = ' || l_address_type
1356: || ', l_ship_to_location_id = ' || l_ship_to_location_id

Line 1353: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1349: FETCH address_type_cur INTO l_address_type, l_ship_to_location_id, l_resource_id, l_resource_type;
1350: CLOSE address_type_cur;
1351:
1352: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1353: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1354: 'csp.plsql.csp_parts_order.process_order',
1355: 'l_address_type = ' || l_address_type
1356: || ', l_ship_to_location_id = ' || l_ship_to_location_id
1357: || ', l_resource_id = ' || l_resource_id

Line 1464: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1460: WHERE CURRENT of req_number_cur;
1461: CLOSE req_number_cur;
1462: END IF;
1463:
1464: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1465: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1466: 'csp.plsql.csp_parts_order.process_order',
1467: 'l_header_rec.requisition_header_id = ' || l_header_rec.requisition_header_id
1468: || ', l_header_rec.requisition_number = ' || l_header_rec.requisition_number);

Line 1465: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1461: CLOSE req_number_cur;
1462: END IF;
1463:
1464: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1465: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1466: 'csp.plsql.csp_parts_order.process_order',
1467: 'l_header_rec.requisition_header_id = ' || l_header_rec.requisition_header_id
1468: || ', l_header_rec.requisition_number = ' || l_header_rec.requisition_number);
1469: end if;

Line 1501: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1497: po_message_s.sql_error('check_unique','010',sqlcode);
1498: raise;
1499: END;
1500:
1501: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1502: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1503: 'csp.plsql.csp_parts_order.process_order',
1504: 'Inserting data into PO_REQUISITION_HEADERS');
1505: end if;

Line 1502: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1498: raise;
1499: END;
1500:
1501: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1502: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1503: 'csp.plsql.csp_parts_order.process_order',
1504: 'Inserting data into PO_REQUISITION_HEADERS');
1505: end if;
1506:

Line 1616: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1612: null,
1613: null
1614: );
1615:
1616: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1617: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1618: 'csp.plsql.csp_parts_order.process_order',
1619: 'Inserting data into PO_ACTION_HISTORY');
1620: end if;

Line 1617: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1613: null
1614: );
1615:
1616: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1617: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1618: 'csp.plsql.csp_parts_order.process_order',
1619: 'Inserting data into PO_ACTION_HISTORY');
1620: end if;
1621:

Line 1666: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1662: '',
1663: null,
1664: '' );
1665:
1666: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1667: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1668: 'csp.plsql.csp_parts_order.process_order',
1669: 'Inserting data into PO_ACTION_HISTORY');
1670: end if;

Line 1667: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1663: null,
1664: '' );
1665:
1666: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1667: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1668: 'csp.plsql.csp_parts_order.process_order',
1669: 'Inserting data into PO_ACTION_HISTORY');
1670: end if;
1671:

Line 1732: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1728: FND_MSG_PUB.ADD;
1729: RAISE EXCP_USER_DEFINED;
1730: END;
1731:
1732: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1733: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1734: 'csp.plsql.csp_parts_order.process_order',
1735: 'l_org_id = ' || l_org_id
1736: || ', l_source_operating_unit = ' || l_source_operating_unit);

Line 1733: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1729: RAISE EXCP_USER_DEFINED;
1730: END;
1731:
1732: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1733: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1734: 'csp.plsql.csp_parts_order.process_order',
1735: 'l_org_id = ' || l_org_id
1736: || ', l_source_operating_unit = ' || l_source_operating_unit);
1737: end if;

Line 1754: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1750: ELSE
1751: l_source_operating_unit := l_org_id;
1752: END IF;
1753:
1754: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1755: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1756: 'csp.plsql.csp_parts_order.process_order',
1757: 'l_header_rec.order_type_id = ' || l_header_rec.order_type_id);
1758: end if;

Line 1755: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1751: l_source_operating_unit := l_org_id;
1752: END IF;
1753:
1754: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1755: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1756: 'csp.plsql.csp_parts_order.process_order',
1757: 'l_header_rec.order_type_id = ' || l_header_rec.order_type_id);
1758: end if;
1759:

Line 1788: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1784: -- exception handler
1785: null;
1786: END;
1787:
1788: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1789: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1790: 'csp.plsql.csp_parts_order.process_order',
1791: 'l_price_list_id = ' || l_price_list_id
1792: || ', l_currency_code = ' || l_currency_code

Line 1789: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1785: null;
1786: END;
1787:
1788: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1789: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1790: 'csp.plsql.csp_parts_order.process_order',
1791: 'l_price_list_id = ' || l_price_list_id
1792: || ', l_currency_code = ' || l_currency_code
1793: || ', l_order_line_type_id = ' || l_order_line_type_id

Line 1817: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1813:
1814: END;
1815: END IF;
1816:
1817: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1818: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1819: 'csp.plsql.csp_parts_order.process_order',
1820: 'l_currency_code = ' || l_currency_code);
1821: end if;

Line 1818: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1814: END;
1815: END IF;
1816:
1817: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1818: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1819: 'csp.plsql.csp_parts_order.process_order',
1820: 'l_currency_code = ' || l_currency_code);
1821: end if;
1822:

Line 1828: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1824: OPEN cust_site_cur;
1825: FETCH cust_site_cur INTO l_customer_id, l_site_use_id, l_cust_acct_id;
1826: CLOSE cust_site_cur;
1827:
1828: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1829: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1830: 'csp.plsql.csp_parts_order.process_order',
1831: 'l_customer_id = ' || l_customer_id
1832: || ', l_site_use_id = ' || l_site_use_id

Line 1829: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1825: FETCH cust_site_cur INTO l_customer_id, l_site_use_id, l_cust_acct_id;
1826: CLOSE cust_site_cur;
1827:
1828: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1829: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1830: 'csp.plsql.csp_parts_order.process_order',
1831: 'l_customer_id = ' || l_customer_id
1832: || ', l_site_use_id = ' || l_site_use_id
1833: || ', l_cust_acct_id = ' || l_cust_acct_id);

Line 1844: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1840: into l_header_rec.order_header_id
1841: from dual;
1842: END IF;
1843:
1844: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1845: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1846: 'csp.plsql.csp_parts_order.process_order',
1847: 'l_header_rec.order_header_id = ' || l_header_rec.order_header_id);
1848: end if;

Line 1845: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1841: from dual;
1842: END IF;
1843:
1844: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1845: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1846: 'csp.plsql.csp_parts_order.process_order',
1847: 'l_header_rec.order_header_id = ' || l_header_rec.order_header_id);
1848: end if;
1849:

Line 1963: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1959: OPEN unit_of_measure_cur(l_line_tbl(i).unit_of_measure);
1960: FETCH unit_of_measure_cur INTO l_unit_meas_lookup_code;
1961: CLOSE unit_of_measure_cur;
1962:
1963: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1964: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1965: 'csp.plsql.csp_parts_order.process_order',
1966: 'Getting Unit Price...');
1967: end if;

Line 1964: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1960: FETCH unit_of_measure_cur INTO l_unit_meas_lookup_code;
1961: CLOSE unit_of_measure_cur;
1962:
1963: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1964: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1965: 'csp.plsql.csp_parts_order.process_order',
1966: 'Getting Unit Price...');
1967: end if;
1968:

Line 1979: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1975: ,l_currency_code
1976: ,l_unit_price
1977: ,l_item_cost );
1978:
1979: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1980: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1981: 'csp.plsql.csp_parts_order.process_order',
1982: 'Inserting data into PO_REQUISITION_LINES...');
1983: end if;

Line 1980: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1976: ,l_unit_price
1977: ,l_item_cost );
1978:
1979: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1980: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1981: 'csp.plsql.csp_parts_order.process_order',
1982: 'Inserting data into PO_REQUISITION_LINES...');
1983: end if;
1984:

Line 2085: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2081: (l_header_rec.dest_organization_id,
2082: l_line_tbl(i).inventory_item_id,
2083: l_line_Tbl(i).dest_subinventory);
2084:
2085: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2086: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2087: 'csp.plsql.csp_parts_order.process_order',
2088: 'Checking Valid Account Id...');
2089: end if;

Line 2086: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2082: l_line_tbl(i).inventory_item_id,
2083: l_line_Tbl(i).dest_subinventory);
2084:
2085: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2086: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2087: 'csp.plsql.csp_parts_order.process_order',
2088: 'Checking Valid Account Id...');
2089: end if;
2090:

Line 2151: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2147: ELSE
2148: l_dist_rec.gl_encumbered_date := '';
2149: END IF;
2150:
2151: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2152: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2153: 'csp.plsql.csp_parts_order.process_order',
2154: 'Inserting data into po_req_distributions ...');
2155: end if;

Line 2152: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2148: l_dist_rec.gl_encumbered_date := '';
2149: END IF;
2150:
2151: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2152: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2153: 'csp.plsql.csp_parts_order.process_order',
2154: 'Inserting data into po_req_distributions ...');
2155: end if;
2156:

Line 2305: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2301: into l_line_tbl(i).order_line_id
2302: from dual;
2303: END IF;
2304:
2305: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2306: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2307: 'csp.plsql.csp_parts_order.process_order',
2308: 'l_line_tbl(i).order_line_id ('
2309: || to_char(i) || ') = ' || l_line_tbl(i).order_line_id);

Line 2306: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2302: from dual;
2303: END IF;
2304:
2305: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2306: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2307: 'csp.plsql.csp_parts_order.process_order',
2308: 'l_line_tbl(i).order_line_id ('
2309: || to_char(i) || ') = ' || l_line_tbl(i).order_line_id);
2310: end if;

Line 2452: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2448: END IF;
2449: */
2450: BEGIN
2451:
2452: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2453: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2454: 'csp.plsql.csp_parts_order.process_order',
2455: 'Deleting record from mtl_supply...');
2456: end if;

Line 2453: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2449: */
2450: BEGIN
2451:
2452: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2453: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2454: 'csp.plsql.csp_parts_order.process_order',
2455: 'Deleting record from mtl_supply...');
2456: end if;
2457:

Line 2471: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2467: AND pl.line_location_id IS NULL
2468: )
2469: AND ms1.supply_type_code = 'REQ';
2470:
2471: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2472: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2473: 'csp.plsql.csp_parts_order.process_order',
2474: 'Inserting data into mtl_supply...');
2475: end if;

Line 2472: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2468: )
2469: AND ms1.supply_type_code = 'REQ';
2470:
2471: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2472: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2473: 'csp.plsql.csp_parts_order.process_order',
2474: 'Inserting data into mtl_supply...');
2475: end if;
2476:

Line 2570: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2566: FETCH get_new_context
2567: INTO new_user_id,new_resp_id,new_resp_appl_id;
2568: CLOSE get_new_context;
2569:
2570: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2571: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2572: 'csp.plsql.csp_parts_order.process_order',
2573: 'new_user_id = ' || new_user_id
2574: || ', new_resp_id = ' || new_resp_id

Line 2571: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2567: INTO new_user_id,new_resp_id,new_resp_appl_id;
2568: CLOSE get_new_context;
2569:
2570: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2571: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2572: 'csp.plsql.csp_parts_order.process_order',
2573: 'new_user_id = ' || new_user_id
2574: || ', new_resp_id = ' || new_resp_id
2575: || ', new_resp_appl_id = ' || new_resp_appl_id);

Line 2600: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2596: -- Use the default settings
2597: l_oe_control_rec.controlled_operation := FALSE;
2598: l_oe_control_rec.default_Attributes := TRUE;
2599:
2600: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2601: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2602: 'csp.plsql.csp_parts_order.process_order',
2603: 'Now finally calling OE_Order_PUB.Process_Order for operation = '
2604: || l_oe_header_rec.operation);

Line 2601: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2597: l_oe_control_rec.controlled_operation := FALSE;
2598: l_oe_control_rec.default_Attributes := TRUE;
2599:
2600: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2601: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2602: 'csp.plsql.csp_parts_order.process_order',
2603: 'Now finally calling OE_Order_PUB.Process_Order for operation = '
2604: || l_oe_header_rec.operation);
2605: end if;

Line 2704: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

2700: , p_data => x_msg_data);
2701: End loop;
2702: x_return_status := FND_API.G_RET_STS_ERROR;
2703:
2704: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2705: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2706: 'csp.plsql.csp_parts_order.process_order',
2707: 'Error in OE_Order_PUB.Process_Order API... Message = '
2708: || l_msg);

Line 2705: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

2701: End loop;
2702: x_return_status := FND_API.G_RET_STS_ERROR;
2703:
2704: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2705: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2706: 'csp.plsql.csp_parts_order.process_order',
2707: 'Error in OE_Order_PUB.Process_Order API... Message = '
2708: || l_msg);
2709: end if;