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 CSP_PARTS_ORDER

Line 1: PACKAGE BODY CSP_PARTS_ORDER AS

1: PACKAGE BODY CSP_PARTS_ORDER AS
2: /* $Header: cspvpodb.pls 120.72.12020000.6 2013/03/01 05:20:36 htank ship $ */
3:
4: --
5: -- Purpose: Create/Update/Cancel Internal Parts Order for Spares

Line 12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'csp_parts_order';

8: -- Person Date Comments
9: -- --------- ------ ------------------------------------------
10: -- phegde 05/01/01 Created new package body
11:
12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'csp_parts_order';
13: G_FILE_NAME CONSTANT VARCHAR2(30) := 'cspvpodb.pls';
14:
15: -- This procedure is to get the Unit Price for Internal Requisition
16: -- If the Currency Code is same for both Source and Destination Organization

Line 496: l_module_name varchar2(100) := 'csp.plsql.csp_parts_order.Cancel_Order';

492: l_source_operating_unit number;
493: l_org_id number;
494: l_user_id number;
495: new_user varchar2(240);
496: l_module_name varchar2(100) := 'csp.plsql.csp_parts_order.Cancel_Order';
497:
498: BEGIN
499:
500: SAVEPOINT Cancel_Order_PUB;

Line 1139: l_dist_Rec csp_parts_order.req_dist_rec_type;

1135:
1136: l_header_rec csp_parts_requirement.header_rec_type;
1137: l_line_rec csp_parts_requirement.line_rec_type;
1138: l_line_tbl csp_parts_requirement.Line_tbl_type;
1139: l_dist_Rec csp_parts_order.req_dist_rec_type;
1140:
1141: l_transferred_to_oe_flag VARCHAR2(1) := 'Y';
1142: l_msg varchar2(2000);
1143: -- Record and table types for oe process_order

Line 1597: 'csp.plsql.csp_parts_order.process_order',

1593: BEGIN
1594:
1595: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1596: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1597: 'csp.plsql.csp_parts_order.process_order',
1598: 'Begin');
1599: end if;
1600:
1601: SAVEPOINT Process_Order_PUB;

Line 1626: 'csp.plsql.csp_parts_order.process_order',

1622: fnd_profile.get('RESP_APPL_ID',orig_resp_appl_id);
1623:
1624: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1625: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1626: 'csp.plsql.csp_parts_order.process_order',
1627: 'l_user_id = ' || l_user_id
1628: || ', orig_resp_id = ' || orig_resp_id
1629: || ', orig_resp_appl_id = ' || orig_resp_appl_id);
1630: end if;

Line 1635: IF (l_line_Tbl.count <= 0 AND l_header_rec.operation <> CSP_PARTS_ORDER.G_OPR_CANCEL) THEN

1631:
1632: l_header_rec := px_header_rec;
1633: l_line_tbl := px_line_table;
1634:
1635: IF (l_line_Tbl.count <= 0 AND l_header_rec.operation <> CSP_PARTS_ORDER.G_OPR_CANCEL) THEN
1636: return;
1637: END IF;
1638:
1639: if l_header_rec.ship_to_location_id is null then

Line 1667: 'csp.plsql.csp_parts_order.process_order',

1663: l_first_org_id := l_org_id;
1664:
1665: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1666: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1667: 'csp.plsql.csp_parts_order.process_order',
1668: 'Original l_org_id from context = ' || l_org_id);
1669: end if;
1670:
1671: BEGIN

Line 1686: 'csp.plsql.csp_parts_order.process_order',

1682: END;
1683:
1684: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1685: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1686: 'csp.plsql.csp_parts_order.process_order',
1687: 'l_dest_operating_unit = ' || l_dest_operating_unit);
1688: end if;
1689:
1690: if l_dest_operating_unit is not null

Line 1697: 'csp.plsql.csp_parts_order.process_order',

1693: l_org_id := l_dest_operating_unit;
1694:
1695: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1696: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1697: 'csp.plsql.csp_parts_order.process_order',
1698: 'l_org_id changed to = ' || l_org_id);
1699: end if;
1700:
1701: end if;

Line 1708: 'csp.plsql.csp_parts_order.process_order',

1704: l_sr_org_id := l_org_id;
1705:
1706: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1707: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1708: 'csp.plsql.csp_parts_order.process_order',
1709: 'Setting org context for l_org_id = ' || l_org_id);
1710: end if;
1711:
1712: EXCEPTION

Line 1725: 'csp.plsql.csp_parts_order.process_order',

1721: CLOSE set_of_books_cur;
1722:
1723: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1724: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1725: 'csp.plsql.csp_parts_order.process_order',
1726: 'l_header_rec.operation = ' || l_header_rec.operation);
1727: end if;
1728:
1729: IF (l_header_rec.operation = CSP_PARTS_ORDER.G_OPR_CANCEL) THEN

Line 1729: IF (l_header_rec.operation = CSP_PARTS_ORDER.G_OPR_CANCEL) THEN

1725: 'csp.plsql.csp_parts_order.process_order',
1726: 'l_header_rec.operation = ' || l_header_rec.operation);
1727: end if;
1728:
1729: IF (l_header_rec.operation = CSP_PARTS_ORDER.G_OPR_CANCEL) THEN
1730: Cancel_Order( p_header_rec => l_header_rec,
1731: p_line_table => l_line_tbl,
1732: p_process_type => p_process_type,
1733: x_return_status => l_return_status,

Line 1745: 'csp.plsql.csp_parts_order.process_order',

1741: ELSE
1742:
1743: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1744: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1745: 'csp.plsql.csp_parts_order.process_order',
1746: 'p_process_Type = ' || p_process_Type);
1747: end if;
1748:
1749: IF (p_process_Type = 'BOTH' or p_process_type = 'ORDER') THEN

Line 1759: 'csp.plsql.csp_parts_order.process_order',

1755: CLOSE address_type_cur;
1756:
1757: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1758: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1759: 'csp.plsql.csp_parts_order.process_order',
1760: 'l_address_type = ' || l_address_type
1761: || ', l_ship_to_location_id = ' || l_ship_to_location_id
1762: || ', l_resource_id = ' || l_resource_id
1763: || ', l_resource_type = ' || l_resource_type);

Line 1775: 'csp.plsql.csp_parts_order.process_order',

1771: l_ship_to_location_id := nvl(l_header_rec.ship_to_location_id, l_ship_to_location_id);
1772:
1773: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1774: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1775: 'csp.plsql.csp_parts_order.process_order',
1776: 'l_address_type = ' || l_address_type
1777: || ', l_ship_to_location_id = ' || l_ship_to_location_id);
1778: end if;
1779:

Line 1874: 'csp.plsql.csp_parts_order.process_order',

1870: AND cia.incident_id = req.incident_id;
1871:
1872: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1873: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1874: 'csp.plsql.csp_parts_order.process_order',
1875: 'l_sr_org_id = ' || l_sr_org_id);
1876: end if;
1877:
1878: ELSIF (l_address_type = 'R') THEN

Line 1928: 'csp.plsql.csp_parts_order.process_order',

1924: END IF;
1925:
1926: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1927: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1928: 'csp.plsql.csp_parts_order.process_order',
1929: 'l_header_rec.requisition_header_id = ' || l_header_rec.requisition_header_id
1930: || ', l_header_rec.requisition_number = ' || l_header_rec.requisition_number);
1931: end if;
1932:

Line 1941: 'csp.plsql.csp_parts_order.process_order',

1937: CLOSE employee_id_cur;
1938:
1939: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1940: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1941: 'csp.plsql.csp_parts_order.process_order',
1942: 'l_employee_id = ' || l_employee_id);
1943: end if;
1944:
1945: -- bug 12805692

Line 1953: 'csp.plsql.csp_parts_order.process_order',

1949: end if;
1950:
1951: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1952: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1953: 'csp.plsql.csp_parts_order.process_order',
1954: 'l_employee_id = ' || l_employee_id);
1955: end if;
1956:
1957: END IF;

Line 1984: 'csp.plsql.csp_parts_order.process_order',

1980: END;
1981:
1982: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1983: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1984: 'csp.plsql.csp_parts_order.process_order',
1985: 'Inserting data into PO_REQUISITION_HEADERS');
1986: end if;
1987: -- create approved requisition headers
1988: -- insert into PO_REQUISITION_HEADERS

Line 2098: 'csp.plsql.csp_parts_order.process_order',

2094: );
2095:
2096: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2097: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2098: 'csp.plsql.csp_parts_order.process_order',
2099: 'Inserting data into PO_ACTION_HISTORY');
2100: end if;
2101: -- insert 2 lines of history, one for SUBMIT and one for APPROVE
2102: INSERT into PO_ACTION_HISTORY

Line 2147: 'csp.plsql.csp_parts_order.process_order',

2143: '' );
2144:
2145: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2146: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2147: 'csp.plsql.csp_parts_order.process_order',
2148: 'Inserting data into PO_ACTION_HISTORY');
2149: end if;
2150:
2151: INSERT into PO_ACTION_HISTORY

Line 2213: 'csp.plsql.csp_parts_order.process_order',

2209: END;
2210:
2211: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2212: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2213: 'csp.plsql.csp_parts_order.process_order',
2214: 'l_org_id = ' || l_org_id
2215: || ', l_source_operating_unit = ' || l_source_operating_unit);
2216: end if;
2217:

Line 2238: 'csp.plsql.csp_parts_order.process_order',

2234: END IF;
2235:
2236: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2237: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2238: 'csp.plsql.csp_parts_order.process_order',
2239: 'l_bill_to_site_use_id = ' || l_bill_to_site_use_id);
2240: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2241: 'csp.plsql.csp_parts_order.process_order',
2242: 'l_ship_to_contact_id = ' || l_ship_to_contact_id);

Line 2241: 'csp.plsql.csp_parts_order.process_order',

2237: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2238: 'csp.plsql.csp_parts_order.process_order',
2239: 'l_bill_to_site_use_id = ' || l_bill_to_site_use_id);
2240: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2241: 'csp.plsql.csp_parts_order.process_order',
2242: 'l_ship_to_contact_id = ' || l_ship_to_contact_id);
2243: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2244: 'csp.plsql.csp_parts_order.process_order',
2245: 'l_invoice_to_contact_id = ' || l_invoice_to_contact_id);

Line 2244: 'csp.plsql.csp_parts_order.process_order',

2240: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2241: 'csp.plsql.csp_parts_order.process_order',
2242: 'l_ship_to_contact_id = ' || l_ship_to_contact_id);
2243: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2244: 'csp.plsql.csp_parts_order.process_order',
2245: 'l_invoice_to_contact_id = ' || l_invoice_to_contact_id);
2246: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2247: 'csp.plsql.csp_parts_order.process_order',
2248: 'original l_header_rec.order_type_id = ' || l_header_rec.order_type_id);

Line 2247: 'csp.plsql.csp_parts_order.process_order',

2243: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2244: 'csp.plsql.csp_parts_order.process_order',
2245: 'l_invoice_to_contact_id = ' || l_invoice_to_contact_id);
2246: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2247: 'csp.plsql.csp_parts_order.process_order',
2248: 'original l_header_rec.order_type_id = ' || l_header_rec.order_type_id);
2249: end if;
2250:
2251: l_is_valid_order_type := -999;

Line 2265: 'csp.plsql.csp_parts_order.process_order',

2261: end if;
2262:
2263: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2264: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2265: 'csp.plsql.csp_parts_order.process_order',
2266: 'after validation l_header_rec.order_type_id = ' || l_header_rec.order_type_id);
2267: end if;
2268:
2269: -- get all required information for passing to process_orders

Line 2299: 'csp.plsql.csp_parts_order.process_order',

2295: END;
2296:
2297: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2298: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2299: 'csp.plsql.csp_parts_order.process_order',
2300: 'l_price_list_id = ' || l_price_list_id
2301: || ', l_currency_code = ' || l_currency_code
2302: || ', l_order_line_type_id = ' || l_order_line_type_id
2303: || ', l_line_price_list_id = ' || l_line_price_list_id

Line 2328: 'csp.plsql.csp_parts_order.process_order',

2324: END IF;
2325:
2326: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2327: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2328: 'csp.plsql.csp_parts_order.process_order',
2329: 'l_currency_code = ' || l_currency_code);
2330: end if;
2331:
2332: -- get customer and ship to site

Line 2339: 'csp.plsql.csp_parts_order.process_order',

2335: CLOSE cust_site_cur;
2336:
2337: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2338: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2339: 'csp.plsql.csp_parts_order.process_order',
2340: 'l_customer_id = ' || l_customer_id
2341: || ', l_site_use_id = ' || l_site_use_id
2342: || ', l_cust_acct_id = ' || l_cust_acct_id);
2343: end if;

Line 2355: 'csp.plsql.csp_parts_order.process_order',

2351: CLOSE get_cust_site_id;
2352:
2353: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2354: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2355: 'csp.plsql.csp_parts_order.process_order',
2356: 'l_cust_site_id=' || l_cust_site_id
2357: || ', l_customer_id=' || l_customer_id
2358: || ', l_party_site_id=' || l_party_site_id
2359: || ', l_tmp_org_id=' || l_tmp_org_id);

Line 2371: 'csp.plsql.csp_parts_order.process_order',

2367: close get_cust_site_id2;
2368:
2369: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2370: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2371: 'csp.plsql.csp_parts_order.process_order',
2372: 'l_cust_site_id=' || l_cust_site_id
2373: || ', l_customer_id=' || l_customer_id
2374: || ', l_party_site_id=' || l_party_site_id
2375: || ', l_tmp_org_id=' || l_tmp_org_id

Line 2409: 'csp.plsql.csp_parts_order.process_order',

2405: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2406:
2407: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2408: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2409: 'csp.plsql.csp_parts_order.process_order',
2410: 'populated v_cust_acct_site_rec');
2411: end if;
2412:
2413: v_cust_acct_site_rec.cust_acct_site_id := NULL;

Line 2446: 'csp.plsql.csp_parts_order.process_order',

2442: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2443:
2444: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2445: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2446: 'csp.plsql.csp_parts_order.process_order',
2447: 'x_cust_acct_site_id=' || x_cust_acct_site_id);
2448: end if;
2449:
2450: end if; -- if l_party_site_id IS NULL THEN # 2

Line 2486: 'csp.plsql.csp_parts_order.process_order',

2482: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2483:
2484: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2485: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2486: 'csp.plsql.csp_parts_order.process_order',
2487: 'populated v_cust_site_use_rec');
2488: end if;
2489:
2490: v_cust_site_use_rec.site_use_id := NULL;

Line 2507: 'csp.plsql.csp_parts_order.process_order',

2503: close get_bill_site_id;
2504:
2505: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2506: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2507: 'csp.plsql.csp_parts_order.process_order',
2508: 'v_bill_site_id = ' || v_bill_site_id);
2509: end if;
2510:
2511: if v_bill_site_id <> l_cust_site_id then

Line 2544: 'csp.plsql.csp_parts_order.process_order',

2540: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2541:
2542: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2543: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2544: 'csp.plsql.csp_parts_order.process_order',
2545: 'populated v_bill_acct_site_rec');
2546: end if;
2547:
2548: v_bill_acct_site_rec.cust_acct_site_id := NULL;

Line 2579: 'csp.plsql.csp_parts_order.process_order',

2575: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2576:
2577: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2578: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2579: 'csp.plsql.csp_parts_order.process_order',
2580: 'x_bill_acct_site_id=' || x_bill_acct_site_id);
2581: end if;
2582:
2583: /*

Line 2615: 'csp.plsql.csp_parts_order.process_order',

2611: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2612:
2613: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2614: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2615: 'csp.plsql.csp_parts_order.process_order',
2616: 'populated v_bill_site_use_rec');
2617: end if;
2618:
2619: v_bill_site_use_rec.site_use_id := NULL;

Line 2654: 'csp.plsql.csp_parts_order.process_order',

2650: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2651:
2652: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2653: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2654: 'csp.plsql.csp_parts_order.process_order',
2655: 'x_site_use_id=' || x_site_use_id);
2656: end if;
2657:
2658: v_cust_site_use_rec.bill_to_site_use_id := x_site_use_id;

Line 2672: 'csp.plsql.csp_parts_order.process_order',

2668: end if;
2669:
2670: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2671: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2672: 'csp.plsql.csp_parts_order.process_order',
2673: 'v_cust_site_use_rec.site_use_code=' || v_cust_site_use_rec.site_use_code
2674: || ', v_cust_site_use_rec.bill_to_site_use_id=' || v_cust_site_use_rec.bill_to_site_use_id);
2675: end if;
2676:

Line 2716: 'csp.plsql.csp_parts_order.process_order',

2712: end if;
2713:
2714: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2715: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2716: 'csp.plsql.csp_parts_order.process_order',
2717: 'x_site_use_id=' || x_site_use_id);
2718: end if;
2719:
2720: END LOOP;

Line 2735: 'csp.plsql.csp_parts_order.process_order',

2731: close get_new_cust_ids;
2732:
2733: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2734: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2735: 'csp.plsql.csp_parts_order.process_order',
2736: 'x_cust_acct_site_id=' || x_cust_acct_site_id
2737: || ', temp_ship_to_use_id=' || temp_ship_to_use_id);
2738: end if;
2739:

Line 2761: 'csp.plsql.csp_parts_order.process_order',

2757: CLOSE cust_site_cur;
2758:
2759: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2760: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2761: 'csp.plsql.csp_parts_order.process_order',
2762: 'l_customer_id=' || l_customer_id
2763: || ', l_site_use_id=' || l_site_use_id
2764: || ', l_cust_acct_id=' || l_cust_acct_id);
2765: end if;

Line 2781: 'csp.plsql.csp_parts_order.process_order',

2777: close get_primary_bill_to;
2778:
2779: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2780: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2781: 'csp.plsql.csp_parts_order.process_order',
2782: 'Primary Bill To is not available for source OU... Creating...');
2783: end if;
2784:
2785: if l_tmp_org_id is null then

Line 2795: 'csp.plsql.csp_parts_order.process_order',

2791: close get_primary_bill_to;
2792:
2793: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2794: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2795: 'csp.plsql.csp_parts_order.process_order',
2796: 'v_primary_bill_site_use_id = ' || v_primary_bill_site_use_id
2797: || ', v_primary_bill_site_id = ' || v_primary_bill_site_id);
2798: end if;
2799:

Line 2825: 'csp.plsql.csp_parts_order.process_order',

2821: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2822:
2823: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2824: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2825: 'csp.plsql.csp_parts_order.process_order',
2826: 'populated v_pri_bill_acct_site_rec');
2827: end if;
2828:
2829: v_pri_bill_acct_site_rec.cust_acct_site_id := NULL;

Line 2860: 'csp.plsql.csp_parts_order.process_order',

2856: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2857:
2858: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2859: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2860: 'csp.plsql.csp_parts_order.process_order',
2861: 'x_bill_acct_site_id=' || x_pri_bill_acct_site_id);
2862: end if;
2863:
2864:

Line 2890: 'csp.plsql.csp_parts_order.process_order',

2886: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2887:
2888: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2889: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2890: 'csp.plsql.csp_parts_order.process_order',
2891: 'populated v_pri_bill_site_use_rec');
2892: end if;
2893:
2894: v_pri_bill_site_use_rec.site_use_id := NULL;

Line 2929: 'csp.plsql.csp_parts_order.process_order',

2925: END IF; -- IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2926:
2927: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2928: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2929: 'csp.plsql.csp_parts_order.process_order',
2930: 'x_site_use_id=' || x_site_use_id);
2931: end if;
2932: else
2933: close get_primary_bill_to;

Line 2947: 'csp.plsql.csp_parts_order.process_order',

2943: END IF;
2944:
2945: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2946: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2947: 'csp.plsql.csp_parts_order.process_order',
2948: 'l_header_rec.order_header_id = ' || l_header_rec.order_header_id);
2949: end if;
2950:
2951: -- Required attributes (e.g. Order Type and Customer)

Line 2980: 'csp.plsql.csp_parts_order.process_order',

2976: end if;
2977:
2978: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2979: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2980: 'csp.plsql.csp_parts_order.process_order',
2981: 'l_oe_header_rec.ship_to_contact_id = ' || l_oe_header_rec.ship_to_contact_id);
2982: end if;
2983:
2984: if l_invoice_to_contact_id is not null and l_oe_header_rec.invoice_to_org_id is not null then

Line 2997: 'csp.plsql.csp_parts_order.process_order',

2993: end if;
2994:
2995: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
2996: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
2997: 'csp.plsql.csp_parts_order.process_order',
2998: 'l_oe_header_rec.INVOICE_TO_CONTACT_ID = ' || l_oe_header_rec.INVOICE_TO_CONTACT_ID);
2999: end if;
3000:
3001:

Line 3024: 'csp.plsql.csp_parts_order.process_order',

3020:
3021:
3022: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3023: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3024: 'csp.plsql.csp_parts_order.process_order',
3025: 'l_oe_header_rec.shipping_method_code = ' || l_oe_header_rec.shipping_method_code);
3026: end if;
3027:
3028: -- Other attributes

Line 3149: 'csp.plsql.csp_parts_order.process_order',

3145: CLOSE unit_of_measure_cur;
3146:
3147: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3148: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3149: 'csp.plsql.csp_parts_order.process_order',
3150: 'Getting Unit Price...');
3151: end if;
3152:
3153: /* Get Unit Price and Currency Code*/

Line 3165: 'csp.plsql.csp_parts_order.process_order',

3161: ,l_item_cost );
3162:
3163: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3164: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3165: 'csp.plsql.csp_parts_order.process_order',
3166: 'Inserting data into PO_REQUISITION_LINES...');
3167: end if;
3168:
3169: -- insert into po_requisition_lines table

Line 3267: 'csp.plsql.csp_parts_order.process_order',

3263: --s_chart_of_accounts_id := 101;
3264:
3265: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3266: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3267: 'csp.plsql.csp_parts_order.process_order',
3268: 'l_header_rec.dest_organization_id = ' || l_header_rec.dest_organization_id);
3269: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3270: 'csp.plsql.csp_parts_order.process_order',
3271: 'l_line_tbl(i).inventory_item_id = ' || l_line_tbl(i).inventory_item_id);

Line 3270: 'csp.plsql.csp_parts_order.process_order',

3266: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3267: 'csp.plsql.csp_parts_order.process_order',
3268: 'l_header_rec.dest_organization_id = ' || l_header_rec.dest_organization_id);
3269: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3270: 'csp.plsql.csp_parts_order.process_order',
3271: 'l_line_tbl(i).inventory_item_id = ' || l_line_tbl(i).inventory_item_id);
3272: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3273: 'csp.plsql.csp_parts_order.process_order',
3274: 'l_line_Tbl(i).dest_subinventory = ' || l_line_Tbl(i).dest_subinventory);

Line 3273: 'csp.plsql.csp_parts_order.process_order',

3269: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3270: 'csp.plsql.csp_parts_order.process_order',
3271: 'l_line_tbl(i).inventory_item_id = ' || l_line_tbl(i).inventory_item_id);
3272: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3273: 'csp.plsql.csp_parts_order.process_order',
3274: 'l_line_Tbl(i).dest_subinventory = ' || l_line_Tbl(i).dest_subinventory);
3275: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3276: 'csp.plsql.csp_parts_order.process_order',
3277: 'l_header_rec.dest_subinventory = ' || l_header_rec.dest_subinventory);

Line 3276: 'csp.plsql.csp_parts_order.process_order',

3272: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3273: 'csp.plsql.csp_parts_order.process_order',
3274: 'l_line_Tbl(i).dest_subinventory = ' || l_line_Tbl(i).dest_subinventory);
3275: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3276: 'csp.plsql.csp_parts_order.process_order',
3277: 'l_header_rec.dest_subinventory = ' || l_header_rec.dest_subinventory);
3278: end if;
3279:
3280: -- Get Charge Account ID

Line 3289: 'csp.plsql.csp_parts_order.process_order',

3285:
3286:
3287: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3288: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3289: 'csp.plsql.csp_parts_order.process_order',
3290: 'Checking Valid Account Id...');
3291: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3292: 'csp.plsql.csp_parts_order.process_order',
3293: 'l_dist_rec.code_combination_id = '

Line 3292: 'csp.plsql.csp_parts_order.process_order',

3288: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3289: 'csp.plsql.csp_parts_order.process_order',
3290: 'Checking Valid Account Id...');
3291: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3292: 'csp.plsql.csp_parts_order.process_order',
3293: 'l_dist_rec.code_combination_id = '
3294: || l_dist_rec.code_combination_id);
3295: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3296: 'csp.plsql.csp_parts_order.process_order',

Line 3296: 'csp.plsql.csp_parts_order.process_order',

3292: 'csp.plsql.csp_parts_order.process_order',
3293: 'l_dist_rec.code_combination_id = '
3294: || l_dist_rec.code_combination_id);
3295: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3296: 'csp.plsql.csp_parts_order.process_order',
3297: 'l_dist_rec.gl_encumbered_date = '
3298: || to_char(l_dist_rec.gl_encumbered_date, 'DD-MON-YYYY HH24:MI:SS'));
3299: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3300: 'csp.plsql.csp_parts_order.process_order',

Line 3300: 'csp.plsql.csp_parts_order.process_order',

3296: 'csp.plsql.csp_parts_order.process_order',
3297: 'l_dist_rec.gl_encumbered_date = '
3298: || to_char(l_dist_rec.gl_encumbered_date, 'DD-MON-YYYY HH24:MI:SS'));
3299: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3300: 'csp.plsql.csp_parts_order.process_order',
3301: 'l_chart_of_accounts_id = '
3302: || l_chart_of_accounts_id);
3303: end if;
3304:

Line 3370: 'csp.plsql.csp_parts_order.process_order',

3366: END IF;
3367:
3368: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3369: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3370: 'csp.plsql.csp_parts_order.process_order',
3371: 'prevent_encumbrance_flag = ' || l_dist_rec.prevent_encumbrance_flag
3372: || ', encumbered_flag = ' || l_dist_rec.encumbered_flag);
3373: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3374: 'csp.plsql.csp_parts_order.process_order',

Line 3374: 'csp.plsql.csp_parts_order.process_order',

3370: 'csp.plsql.csp_parts_order.process_order',
3371: 'prevent_encumbrance_flag = ' || l_dist_rec.prevent_encumbrance_flag
3372: || ', encumbered_flag = ' || l_dist_rec.encumbered_flag);
3373: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3374: 'csp.plsql.csp_parts_order.process_order',
3375: 'Inserting data into po_req_distributions ...');
3376: end if;
3377:
3378: -- create po_req_distributions

Line 3528: 'csp.plsql.csp_parts_order.process_order',

3524: END IF;
3525:
3526: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3527: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3528: 'csp.plsql.csp_parts_order.process_order',
3529: 'l_line_tbl(i).order_line_id ('
3530: || to_char(i) || ') = ' || l_line_tbl(i).order_line_id);
3531: end if;
3532:

Line 3561: 'csp.plsql.csp_parts_order.process_order',

3557:
3558:
3559: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3560: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3561: 'csp.plsql.csp_parts_order.process_order',
3562: 'l_line_tbl(i).arrival_date = ' || l_line_tbl(i).arrival_date);
3563: end if;
3564:
3565: if l_line_tbl(i).arrival_date is not null then

Line 3573: 'csp.plsql.csp_parts_order.process_order',

3569: end if;
3570:
3571: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3573: 'csp.plsql.csp_parts_order.process_order',
3574: 'l_oe_line_rec.promise_date = ' || l_oe_line_rec.promise_date);
3575: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3576: 'csp.plsql.csp_parts_order.process_order',
3577: 'l_oe_line_rec.request_date = ' || l_oe_line_rec.request_date);

Line 3576: 'csp.plsql.csp_parts_order.process_order',

3572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3573: 'csp.plsql.csp_parts_order.process_order',
3574: 'l_oe_line_rec.promise_date = ' || l_oe_line_rec.promise_date);
3575: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3576: 'csp.plsql.csp_parts_order.process_order',
3577: 'l_oe_line_rec.request_date = ' || l_oe_line_rec.request_date);
3578: end if;
3579:
3580: l_oe_line_rec.sold_to_org_id := l_cust_acct_id;

Line 3606: 'csp.plsql.csp_parts_order.process_order',

3602: l_oe_line_Rec.shipping_method_code := nvl(l_line_tbl(i).shipping_method_code, FND_API.G_MISS_CHAR);
3603:
3604: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3605: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3606: 'csp.plsql.csp_parts_order.process_order',
3607: 'l_oe_line_Rec.shipping_method_code = ' || l_oe_line_Rec.shipping_method_code);
3608: end if;
3609:
3610: l_oe_line_Rec.calculate_price_flag := 'N';

Line 3627: ELSIF (l_header_rec.operation = CSP_PARTS_ORDER.G_OPR_UPDATE) THEN

3623:
3624: l_oe_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
3625: END IF;
3626:
3627: ELSIF (l_header_rec.operation = CSP_PARTS_ORDER.G_OPR_UPDATE) THEN
3628: IF (p_process_Type = 'REQUISITION') THEN
3629: IF (l_line_Tbl(I).requisition_line_id IS NULL) THEN
3630: FND_MESSAGE.SET_NAME ('CSP', 'CSP_MISSING_PARAMETERS');
3631: FND_MESSAGE.SET_TOKEN ('PARAMETER', 'l_line_rec.requisition_line_id', FALSE);

Line 3719: 'csp.plsql.csp_parts_order.process_order',

3715: BEGIN
3716:
3717: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3718: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3719: 'csp.plsql.csp_parts_order.process_order',
3720: 'Deleting record from mtl_supply...');
3721: end if;
3722:
3723: DELETE FROM mtl_supply ms1

Line 3738: 'csp.plsql.csp_parts_order.process_order',

3734: AND ms1.supply_type_code = 'REQ';
3735:
3736: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3737: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3738: 'csp.plsql.csp_parts_order.process_order',
3739: 'Inserting data into mtl_supply...');
3740: end if;
3741:
3742: INSERT INTO mtl_supply

Line 3844: 'csp.plsql.csp_parts_order.process_order',

3840: new_resp_appl_id := substr(ltrim(new_user, new_resp_id), 3);
3841:
3842: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3843: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3844: 'csp.plsql.csp_parts_order.process_order',
3845: 'new_user = ' || new_user
3846: || ', new_user_id = ' || new_user_id
3847: || ', new_resp_id = ' || new_resp_id
3848: || ', new_resp_appl_id = ' || new_resp_appl_id);

Line 3877: 'csp.plsql.csp_parts_order.process_order',

3873: l_oe_control_rec.default_Attributes := TRUE;
3874:
3875: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3876: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3877: 'csp.plsql.csp_parts_order.process_order',
3878: 'Now finally calling OE_Order_PUB.Process_Order for operation = '
3879: || l_oe_header_rec.operation);
3880: end if;
3881:

Line 3892: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',

3888: if nvl(p_book_order, 'Y') = 'Y' then
3889: l_action_request_tbl(1).request_type := OE_GLOBALS.G_BOOK_ORDER;
3890: end if;
3891: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3892: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
3893: 'start calling requirement order dff hook...');
3894: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3895: 'csp.plsql.csp.plsql.csp_parts_order.process_order',
3896: 'Values of before calling the hook api PR Header : Attribute 1 : ' || px_header_rec.ATTRIBUTE1 || ' , ' ||

Line 3895: 'csp.plsql.csp.plsql.csp_parts_order.process_order',

3891: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3892: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
3893: 'start calling requirement order dff hook...');
3894: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3895: 'csp.plsql.csp.plsql.csp_parts_order.process_order',
3896: 'Values of before calling the hook api PR Header : Attribute 1 : ' || px_header_rec.ATTRIBUTE1 || ' , ' ||
3897: 'Attribute 2 : ' || px_header_rec.ATTRIBUTE2 || ' , ' ||
3898: 'Attribute 3 : ' || px_header_rec.ATTRIBUTE3 || ' , ' ||
3899: 'Attribute 4 :' || px_header_rec.ATTRIBUTE4 || ' , ' ||

Line 3912: 'csp.plsql.csp.plsql.csp_parts_order.process_order',

3908: 'Attribute 13: ' || px_header_rec.ATTRIBUTE13 || ' , ' ||
3909: 'Attribute 14: ' || px_header_rec.ATTRIBUTE14 || ' , ' ||
3910: 'Attribute 15: ' || px_header_rec.ATTRIBUTE15);
3911: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3912: 'csp.plsql.csp.plsql.csp_parts_order.process_order',
3913: 'Values of before calling the hook api OE Header : Attribute 1: ' || l_oe_header_rec.ATTRIBUTE1 || ' , ' ||
3914: 'Attribute 2: ' || l_oe_header_rec.ATTRIBUTE2 || ' , ' ||
3915: 'Attribute 3: ' || l_oe_header_rec.ATTRIBUTE3 || ' , ' ||
3916: 'Attribute 4: ' || l_oe_header_rec.ATTRIBUTE4 || ' , ' ||

Line 3930: 'csp.plsql.csp.plsql.csp_parts_order.process_order',

3926: 'Attribute 14: ' || l_oe_header_rec.ATTRIBUTE14 || ' , ' ||
3927: 'Attribute 15: ' || l_oe_header_rec.ATTRIBUTE15);
3928: for k in 1..px_line_table.count loop
3929: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3930: 'csp.plsql.csp.plsql.csp_parts_order.process_order',
3931: 'Values of before calling the hook api PR Line' || k || ': Attribute 1: ' || px_line_table(k).ATTRIBUTE1 || ' , ' ||
3932: 'Attribute 2: ' || px_line_table(k).ATTRIBUTE2 || ' , ' ||
3933: 'Attribute 3: ' || px_line_table(k).ATTRIBUTE3 || ' , ' ||
3934: 'Attribute 4: ' || px_line_table(k).ATTRIBUTE4 || ' , ' ||

Line 3949: 'csp.plsql.csp.plsql.csp_parts_order.process_order',

3945: 'Attribute 15: ' || px_line_table(k).ATTRIBUTE15);
3946: end loop;
3947: for k in 1..l_oe_line_tbl.count loop
3948: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3949: 'csp.plsql.csp.plsql.csp_parts_order.process_order',
3950: 'Values of before calling the hook api OE Line' || k || ': Attribute 1: ' || l_oe_line_tbl(k).ATTRIBUTE1 || ' , ' ||
3951: 'Attribute 2: ' || l_oe_line_tbl(k).ATTRIBUTE2 || ' , ' ||
3952: 'Attribute 3: ' || l_oe_line_tbl(k).ATTRIBUTE3 || ' , ' ||
3953: 'Attribute 4: ' || l_oe_line_tbl(k).ATTRIBUTE4 || ' , ' ||

Line 3975: 'csp.plsql.csp.plsql.csp_parts_order.process_order',

3971: ,px_oe_header_rec => l_oe_header_rec
3972: ,px_oe_line_table => l_oe_line_tbl);
3973: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
3974: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3975: 'csp.plsql.csp.plsql.csp_parts_order.process_order',
3976: 'Values of after calling the hook api PR Header : Attribute 1 : ' || px_header_rec.ATTRIBUTE1 || ' , ' ||
3977: 'Attribute 2 : ' || px_header_rec.ATTRIBUTE2 || ' , ' ||
3978: 'Attribute 3 : ' || px_header_rec.ATTRIBUTE3 || ' , ' ||
3979: 'Attribute 4 :' || px_header_rec.ATTRIBUTE4 || ' , ' ||

Line 3992: 'csp.plsql.csp.plsql.csp_parts_order.process_order',

3988: 'Attribute 13: ' || px_header_rec.ATTRIBUTE13 || ' , ' ||
3989: 'Attribute 14: ' || px_header_rec.ATTRIBUTE14 || ' , ' ||
3990: 'Attribute 15: ' || px_header_rec.ATTRIBUTE15);
3991: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
3992: 'csp.plsql.csp.plsql.csp_parts_order.process_order',
3993: 'Values of after calling the hook api OE Header : Attribute 1: ' || l_oe_header_rec.ATTRIBUTE1 || ' , ' ||
3994: 'Attribute 2: ' || l_oe_header_rec.ATTRIBUTE2 || ' , ' ||
3995: 'Attribute 3: ' || l_oe_header_rec.ATTRIBUTE3 || ' , ' ||
3996: 'Attribute 4: ' || l_oe_header_rec.ATTRIBUTE4 || ' , ' ||

Line 4010: 'csp.plsql.csp.plsql.csp_parts_order.process_order',

4006: 'Attribute 14: ' || l_oe_header_rec.ATTRIBUTE14 || ' , ' ||
4007: 'Attribute 15: ' || l_oe_header_rec.ATTRIBUTE15);
4008: for k in 1..px_line_table.count loop
4009: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4010: 'csp.plsql.csp.plsql.csp_parts_order.process_order',
4011: 'Values of after calling the hook api PR Line' || k || ': Attribute 1: ' || px_line_table(k).ATTRIBUTE1 || ' , ' ||
4012: 'Attribute 2: ' || px_line_table(k).ATTRIBUTE2 || ' , ' ||
4013: 'Attribute 3: ' || px_line_table(k).ATTRIBUTE3 || ' , ' ||
4014: 'Attribute 4: ' || px_line_table(k).ATTRIBUTE4 || ' , ' ||

Line 4029: 'csp.plsql.csp.plsql.csp_parts_order.process_order',

4025: 'Attribute 15: ' || px_line_table(k).ATTRIBUTE15);
4026: end loop;
4027: for k in 1..l_oe_line_tbl.count loop
4028: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4029: 'csp.plsql.csp.plsql.csp_parts_order.process_order',
4030: 'Values of after calling the hook api OE Line' || k || ': Attribute 1: ' || l_oe_line_tbl(k).ATTRIBUTE1 || ' , ' ||
4031: 'Attribute 2: ' || l_oe_line_tbl(k).ATTRIBUTE2 || ' , ' ||
4032: 'Attribute 3: ' || l_oe_line_tbl(k).ATTRIBUTE3 || ' , ' ||
4033: 'Attribute 4: ' || l_oe_line_tbl(k).ATTRIBUTE4 || ' , ' ||

Line 4046: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',

4042: 'Attribute 13: ' || l_oe_line_tbl(k).ATTRIBUTE13 || ' , ' ||
4043: 'Attribute 14: ' || l_oe_line_tbl(k).ATTRIBUTE14 || ' , ' ||
4044: 'Attribute 15: ' || l_oe_line_tbl(k).ATTRIBUTE15);
4045: end loop;
4046: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
4047: 'end of calling requirement order dff hook...');
4048: end if;
4049: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4050: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',

Line 4050: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',

4046: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
4047: 'end of calling requirement order dff hook...');
4048: end if;
4049: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4050: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
4051: 'Starting OW Debug...');
4052:
4053: oe_debug_pub.G_FILE := NULL;
4054: oe_debug_pub.debug_on;

Line 4058: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',

4054: oe_debug_pub.debug_on;
4055: oe_debug_pub.initialize;
4056: oe_debug_pub.setdebuglevel(5);
4057:
4058: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
4059: 'OE Debug File : '|| OE_DEBUG_PUB.Set_Debug_Mode('FILE'));
4060:
4061: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
4062: 'l_line_tbl.count = '|| l_line_tbl.count);

Line 4061: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',

4057:
4058: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
4059: 'OE Debug File : '|| OE_DEBUG_PUB.Set_Debug_Mode('FILE'));
4060:
4061: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
4062: 'l_line_tbl.count = '|| l_line_tbl.count);
4063: end if;
4064:
4065: OE_Order_PUB.Process_Order(

Line 4140: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',

4136: );
4137: END IF;
4138:
4139: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4140: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
4141: 'Stopping OE debug ...');
4142: oe_debug_pub.debug_off;
4143: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
4144: 'l_return_status = ' || l_return_status);

Line 4143: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',

4139: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4140: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
4141: 'Stopping OE debug ...');
4142: oe_debug_pub.debug_off;
4143: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_order',
4144: 'l_return_status = ' || l_return_status);
4145: end if;
4146:
4147: -- dbms_application_info.set_client_info(l_org_id);

Line 4170: 'csp.plsql.csp_parts_order.process_order',

4166: x_return_status := FND_API.G_RET_STS_ERROR;
4167:
4168: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4169: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4170: 'csp.plsql.csp_parts_order.process_order',
4171: 'Error in OE_Order_PUB.Process_Order API... Message = '
4172: || l_msg);
4173: end if;
4174:

Line 4255: 'csp.plsql.csp_parts_order.process_order',

4251: end if;
4252:
4253: if(FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4254: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
4255: 'csp.plsql.csp_parts_order.process_order',
4256: 'process_order API returning with x_return_status = ' || x_return_status);
4257: end if;
4258:
4259: EXCEPTION

Line 4430: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_purchase_req',

4426: BEGIN
4427: l_org_id := mo_global.get_current_org_id;
4428:
4429: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4430: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_purchase_req',
4431: 'Original l_org_id from context = ' || l_org_id);
4432: end if;
4433:
4434: BEGIN

Line 4448: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_purchase_req',

4444: RAISE EXCP_USER_DEFINED;
4445: END;
4446:
4447: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4448: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_purchase_req',
4449: 'l_dest_operating_unit = ' || l_dest_operating_unit);
4450: end if;
4451:
4452: if l_dest_operating_unit is not null and l_dest_operating_unit <> nvl(l_org_id, -999) then

Line 4456: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_purchase_req',

4452: if l_dest_operating_unit is not null and l_dest_operating_unit <> nvl(l_org_id, -999) then
4453: l_org_id := l_dest_operating_unit;
4454:
4455: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
4456: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, 'csp.plsql.csp_parts_order.process_purchase_req',
4457: 'l_org_id changed to = ' || l_org_id);
4458: end if;
4459: end if;
4460: po_moac_utils_pvt.set_org_context(l_org_id);

Line 4743: l_module_name varchar2(100) := 'csp.plsql.csp_parts_order.book_order';

4739: ,x_return_status OUT NOCOPY VARCHAR2
4740: ,x_msg_count OUT NOCOPY NUMBER
4741: ,x_msg_data OUT NOCOPY VARCHAR2
4742: ) IS
4743: l_module_name varchar2(100) := 'csp.plsql.csp_parts_order.book_order';
4744: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
4745: l_org_id number;
4746: l_org_org_id number;
4747:

Line 4880: l_module_name varchar2(100) := 'csp.plsql.csp_parts_order.upd_oe_line_ship_method';

4876: ,x_return_status OUT NOCOPY VARCHAR2
4877: ,x_msg_count OUT NOCOPY NUMBER
4878: ,x_msg_data OUT NOCOPY VARCHAR2
4879: ) IS
4880: l_module_name varchar2(100) := 'csp.plsql.csp_parts_order.upd_oe_line_ship_method';
4881: l_action_request_tbl OE_ORDER_PUB.Request_Tbl_Type;
4882: l_org_id number;
4883: l_org_org_id number;
4884: l_ship_from_org_id number;

Line 5084: l_module_name varchar2(100) := 'csp.plsql.csp_parts_order.upd_oe_ship_to_add';

5080: ,x_return_status OUT NOCOPY VARCHAR2
5081: ,x_msg_count OUT NOCOPY NUMBER
5082: ,x_msg_data OUT NOCOPY VARCHAR2
5083: ) IS
5084: l_module_name varchar2(100) := 'csp.plsql.csp_parts_order.upd_oe_ship_to_add';
5085: l_org_id number;
5086: l_org_org_id number;
5087: l_booked_orders number;
5088: l_header_rec csp_parts_requirement.header_rec_type;