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.OE_ORDER_PURGE_PVT dependencies on OE_ORDER_PURGE_PVT

Line 1: PACKAGE BODY OE_ORDER_PURGE_PVT AS

1: PACKAGE BODY OE_ORDER_PURGE_PVT AS
2: /* $Header: OEXVPURB.pls 120.19 2008/01/08 19:38:44 shrgupta ship $ */
3:
4:
5: Procedure Select_Purge_Orders

Line 38: oe_debug_pub.add('Entering OE_Order_Purge_PVT.Select_Purge_Orders '||p_purge_set_id,1);

34: Where Purge_set_id = p_purge_set_id;
35:
36: BEGIN
37:
38: oe_debug_pub.add('Entering OE_Order_Purge_PVT.Select_Purge_Orders '||p_purge_set_id,1);
39:
40: fnd_file.put_line(FND_FILE.LOG,'Parameters :');
41: fnd_file.put_line(FND_FILE.LOG,' Purge Set Id : '||p_purge_set_id);
42: OPEN purge_set;

Line 82: oe_debug_pub.add('Exiting OE_Order_Purge_PVT '||p_purge_set_id,1);

78: l_count_selected ,
79: l_orders_per_commit);
80: END IF;
81:
82: oe_debug_pub.add('Exiting OE_Order_Purge_PVT '||p_purge_set_id,1);
83:
84:
85:
86: EXCEPTION

Line 420: OE_Order_Purge_PVT.Insert_Purge_Set

416: fnd_file.put_line(FND_FILE.LOG,' Purge Orders with Contract Terms: '||p_include_contractual_orders);
417:
418: oe_debug_pub.add('Where Condition : '||l_where_condition);
419:
420: OE_Order_Purge_PVT.Insert_Purge_Set
421: (
422: p_purge_set_name => p_purge_set_name,
423: p_purge_set_description => p_purge_set_description,
424: p_purge_set_request_Id => 1,

Line 937: OE_ORDER_PURGE_PVT.Insert_Purge_Set

933: IF l_debug_level > 0 THEN
934: oe_debug_pub.add('Where Condition : '||l_where_condition);
935: oe_debug_pub.add('Cursor Query : '||l_sql_stmt);
936: END IF;
937: OE_ORDER_PURGE_PVT.Insert_Purge_Set
938: (
939: p_purge_set_name => p_purge_set_name,
940: p_purge_set_description => p_purge_set_description,
941: p_purge_set_request_Id => 1,

Line 1087: oe_debug_pub.Add('Entering OE_Order_Purge_PVT.Select_Ids_Purge : '||p_purge_set_id,1);

1083:
1084:
1085: BEGIN
1086:
1087: oe_debug_pub.Add('Entering OE_Order_Purge_PVT.Select_Ids_Purge : '||p_purge_set_id,1);
1088:
1089: FOR I IN 1..p_count_selected
1090: LOOP
1091:

Line 1172: oe_debug_pub.Add('Exiting OE_Order_Purge_PVT.Select_Ids_Purge : '||p_purge_set_id,1);

1168: COMMIT;
1169:
1170: OE_DEBUG_PUB.Add('after update='|| to_char(SQL%ROWCOUNT));
1171:
1172: oe_debug_pub.Add('Exiting OE_Order_Purge_PVT.Select_Ids_Purge : '||p_purge_set_id,1);
1173:
1174: EXCEPTION
1175: WHEN OTHERS THEN
1176: fnd_file.put_line(FND_FILE.LOG,'*** Error In Generate purge set ** '||substr(sqlerrm,1,300));

Line 1204: oe_debug_pub.add('Entering OE_Order_Purge_PVT.Insert_Purge_Set : '||p_purge_set_name,1);

1200: l_orders_per_commit NUMBER;
1201:
1202: BEGIN
1203:
1204: oe_debug_pub.add('Entering OE_Order_Purge_PVT.Insert_Purge_Set : '||p_purge_set_name,1);
1205:
1206: SELECT OE_PURGE_SETS_S.NEXTVAL
1207: INTO l_purge_set_id
1208: FROM DUAL;

Line 1286: oe_debug_pub.add('Exiting OE_Order_Purge_PVT.Insert_Purge_Set : '||to_char(x_purge_set_id),1);

1282: oe_debug_pub.add('Value : '||l_buffer);
1283:
1284: END IF;
1285:
1286: oe_debug_pub.add('Exiting OE_Order_Purge_PVT.Insert_Purge_Set : '||to_char(x_purge_set_id),1);
1287:
1288: END Insert_Purge_Set;
1289:
1290: --Quote purge changes:

Line 1322: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.Check_And_Get_Detail : '||to_char(p_order_number));

1318: l_cnt NUMBER;
1319:
1320: BEGIN
1321:
1322: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.Check_And_Get_Detail : '||to_char(p_order_number));
1323: --Quote purge changes.To Select Transaction Phase code
1324: SELECT transaction_phase_code
1325: INTO l_transaction_phase_code
1326: FROM oe_order_headers

Line 1351: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Quotes(p_header_id);

1347: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_QUOTE');
1348: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
1349: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
1350: l_error_message := FND_MESSAGE.GET;
1351: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Quotes(p_header_id);
1352:
1353: END IF;
1354:
1355: ELSE

Line 1362: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Orders

1358: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
1359: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
1360: l_error_message := FND_MESSAGE.GET;
1361: --for Bug # 4516769
1362: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Orders
1363: ( p_header_id);
1364: END IF;
1365:
1366: IF l_return_status = FND_API.G_TRUE THEN

Line 1382: l_return_status := OE_ORDER_PURGE_PVT.check_open_invoiced_orders

1378: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_INVOICES');
1379: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
1380: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
1381: l_error_message := FND_MESSAGE.GET;
1382: l_return_status := OE_ORDER_PURGE_PVT.check_open_invoiced_orders
1383: ( TO_CHAR(p_order_number), l_order_type_name );
1384: END IF;
1385:
1386: IF l_return_status = FND_API.G_TRUE THEN

Line 1391: l_return_status := OE_ORDER_PURGE_PVT.check_open_returns

1387: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_RETURNS');
1388: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
1389: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
1390: l_error_message := FND_MESSAGE.GET;
1391: l_return_status := OE_ORDER_PURGE_PVT.check_open_returns
1392: (p_order_number, p_order_type_name);
1393: END IF;
1394:
1395: IF l_return_status = FND_API.G_TRUE THEN

Line 1436: OE_ORDER_PURGE_PVT.Check_Open_PO_Reqs_Dropship

1432: PO_CODE_RELEASE_GRP.PRC_11i_Family_Pack_J AND
1433: OE_CODE_CONTROL.Code_Release_Level >= '110510' THEN
1434:
1435: l_return_status :=
1436: OE_ORDER_PURGE_PVT.Check_Open_PO_Reqs_Dropship
1437: (p_header_id => p_header_id
1438: );
1439:
1440: IF l_return_status = FND_API.G_FALSE THEN

Line 1507: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.Check_And_Get_Detail : '||to_char(p_order_number));

1503: , 0
1504: ,660);
1505:
1506:
1507: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.Check_And_Get_Detail : '||to_char(p_order_number));
1508:
1509: END check_and_get_detail;
1510:
1511: --

Line 1550: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.Submit_Purge : '||to_char(p_purge_set_id));

1546:
1547: l_created_by oe_purge_sets.created_by%type;
1548: BEGIN
1549:
1550: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.Submit_Purge : '||to_char(p_purge_set_id));
1551: fnd_file.put_line(FND_FILE.LOG,'Parameters :');
1552: fnd_file.put_line(FND_FILE.LOG,'Purge Set Name : '||p_purge_set_id);
1553:
1554: OPEN cur_logged_in_user;

Line 1622: OE_ORDER_PURGE_PVT.oe_purge_headers

1618:
1619: BEGIN
1620:
1621:
1622: OE_ORDER_PURGE_PVT.oe_purge_headers
1623: (p_purge_set_id,
1624: l_header_id,
1625: l_return_status);
1626:

Line 1638: OE_ORDER_PURGE_PVT.oe_purge_lines

1634:
1635: BEGIN
1636:
1637: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1638: OE_ORDER_PURGE_PVT.oe_purge_lines
1639: (p_purge_set_id,
1640: l_header_id,
1641: l_return_status
1642: );

Line 1699: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.Submit_Purge : ');

1695: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of orders/quotes selected for purge : '||l_number_of_orders);
1696: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of orders/quotes purged successfully : '||l_purged_success);
1697: FND_FILE.PUT_LINE(FND_FILE.LOG,'Number of orders/quotes failed purge : '||l_purge_failure);
1698: --end of change for bug 3680441
1699: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.Submit_Purge : ');
1700:
1701: -- Begining of MOAC Changes
1702: ELSE
1703: fnd_file.put_line(FND_FILE.LOG,'Orders could not be Purged as the Purge Set selected is Created by another User.');

Line 1752: oe_debug_pub.add('Entering OE_Order_Purge_PVT.Delete_Purge_Set : '||to_char(p_purge_set_id),1);

1748: l_is_purged VARCHAR2(1) := NULL;
1749:
1750: BEGIN
1751:
1752: oe_debug_pub.add('Entering OE_Order_Purge_PVT.Delete_Purge_Set : '||to_char(p_purge_set_id),1);
1753:
1754: OPEN c_purge_set;
1755: FETCH c_purge_set into
1756: l_purge_set_name

Line 1793: oe_debug_pub.add('Exiting OE_Order_Purge_PVT.Delete_Purge_Set : '||to_char(p_purge_set_id),1);

1789: CLOSE c_purge_orders;
1790:
1791: x_return_status := FND_API.G_TRUE;
1792:
1793: oe_debug_pub.add('Exiting OE_Order_Purge_PVT.Delete_Purge_Set : '||to_char(p_purge_set_id),1);
1794:
1795: END Delete_Purge_Set;
1796:
1797: --Added this function to check for open quotes

Line 2121: ( 'OE_ORDER_PURGE_PVT'

2117: WHEN OTHERS THEN
2118: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2119: THEN
2120: OE_MSG_PUB.Add_Exc_Msg
2121: ( 'OE_ORDER_PURGE_PVT'
2122: ,'Check_Open_PO_Reqs_Dropship'
2123: );
2124: END IF;
2125: RAISE;

Line 2175: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Headers : '||to_char(p_header_id));

2171: l_msg_data VARCHAR2(2000);
2172:
2173: BEGIN
2174:
2175: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Headers : '||to_char(p_header_id));
2176:
2177: OPEN c_lock_header; -- Lock all rows to be purged
2178:
2179: CLOSE c_lock_header;

Line 2182: l_return_status := OE_Order_Purge_PVT.OE_Purge_Header_Adj

2178:
2179: CLOSE c_lock_header;
2180:
2181: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2182: l_return_status := OE_Order_Purge_PVT.OE_Purge_Header_Adj
2183: (
2184: p_purge_set_id => p_purge_set_id,
2185: p_header_id => p_header_id
2186: );

Line 2194: l_return_status := OE_Order_Purge_PVT.OE_Purge_Price_Attribs

2190: RETURN;
2191: END IF;
2192:
2193: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2194: l_return_status := OE_Order_Purge_PVT.OE_Purge_Price_Attribs
2195: (
2196: p_purge_set_id => p_purge_set_id,
2197: p_header_id => p_header_id
2198: );

Line 2206: l_return_status := OE_Order_Purge_PVT.OE_Purge_Order_Sales_Credits

2202: RETURN;
2203: END IF;
2204:
2205: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2206: l_return_status := OE_Order_Purge_PVT.OE_Purge_Order_Sales_Credits
2207: (
2208: p_purge_set_id => p_purge_set_id,
2209: p_header_id => p_header_id
2210: );

Line 2218: l_return_status := OE_Order_Purge_PVT.OE_Purge_Order_Sets

2214: RETURN;
2215: END IF;
2216:
2217: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2218: l_return_status := OE_Order_Purge_PVT.OE_Purge_Order_Sets
2219: (
2220: p_purge_set_id => p_purge_set_id,
2221: p_header_id => p_header_id
2222: );

Line 2230: l_return_status := OE_Order_Purge_PVT.OE_Purge_Order_Holds

2226: RETURN;
2227: END IF;
2228:
2229: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2230: l_return_status := OE_Order_Purge_PVT.OE_Purge_Order_Holds
2231: (
2232: p_purge_set_id => p_purge_set_id,
2233: p_header_id => p_header_id
2234: );

Line 2243: l_return_status := OE_Order_Purge_PVT.OE_Purge_Header_payments

2239: END IF;
2240:
2241: -- purge for multiple payments
2242: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2243: l_return_status := OE_Order_Purge_PVT.OE_Purge_Header_payments
2244: ( p_purge_set_id => p_purge_set_id,
2245: p_header_id => p_header_id
2246: );
2247: ELSE

Line 2371: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Headers : ');

2367: DELETE FROM oe_order_headers
2368: WHERE header_id = p_header_id;
2369: oe_debug_pub.add('deleted header='|| to_char(p_header_id));
2370:
2371: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Headers : ');
2372:
2373: x_return_status := FND_API.G_RET_STS_SUCCESS;
2374:
2375: EXCEPTION -- Exception handler to record error

Line 2442: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Lines : '||to_char(p_header_id));

2438: WHERE ds.header_id = p_header_id;
2439:
2440: BEGIN
2441:
2442: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Lines : '||to_char(p_header_id));
2443:
2444:
2445: OPEN c_purge_lines;
2446: LOOP

Line 2474: l_return_status := OE_Order_Purge_PVT.OE_Purge_Line_Adj

2470: END IF;
2471:
2472:
2473: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2474: l_return_status := OE_Order_Purge_PVT.OE_Purge_Line_Adj
2475: (
2476: p_purge_set_id => p_purge_set_id,
2477: p_header_id => p_header_id,
2478: p_line_id => l_line_id

Line 2487: l_return_status := OE_Order_Purge_PVT.OE_Purge_Line_Sales_Credits

2483: RETURN;
2484: END IF;
2485:
2486: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2487: l_return_status := OE_Order_Purge_PVT.OE_Purge_Line_Sales_Credits
2488: (
2489: p_purge_set_id => p_purge_set_id,
2490: p_header_id => p_header_id,
2491: p_line_id => l_line_id

Line 2500: l_return_status := OE_Order_Purge_PVT.OE_Purge_Line_Sets

2496: RETURN;
2497: END IF;
2498:
2499: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2500: l_return_status := OE_Order_Purge_PVT.OE_Purge_Line_Sets
2501: (
2502: p_purge_set_id => p_purge_set_id,
2503: p_header_id => p_header_id,
2504: p_line_id => l_line_id

Line 2514: l_return_status := OE_Order_Purge_PVT.OE_Purge_Line_payments

2510: END IF;
2511:
2512: -- purge for multiple payments.
2513: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2514: l_return_status := OE_Order_Purge_PVT.OE_Purge_Line_payments
2515: ( p_purge_set_id => p_purge_set_id,
2516: p_header_id => p_header_id,
2517: p_line_id => l_line_id
2518: );

Line 2683: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Lines : ');

2679: oe_debug_pub.add('Number of lines deleted : '||to_char(c_purge_lines%ROWCOUNT),1);
2680: CLOSE c_purge_lines;
2681:
2682: oe_debug_pub.add('deleted lines for header='|| to_char(p_header_id));
2683: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Lines : ');
2684:
2685: x_return_status := FND_API.G_RET_STS_SUCCESS;
2686:
2687: EXCEPTION -- Exception handler to record error

Line 2745: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Header_Adj : '||to_char(p_header_id));

2741: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2742:
2743: BEGIN
2744:
2745: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Header_Adj : '||to_char(p_header_id));
2746:
2747: OPEN c_header_adj;
2748:
2749: LOOP

Line 2815: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Header_Adj : ');

2811:
2812: oe_debug_pub.add('Number of price adjustments deleted : '||to_char(c_header_adj%ROWCOUNT),1);
2813: CLOSE c_header_adj;
2814:
2815: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Header_Adj : ');
2816:
2817: RETURN FND_API.G_RET_STS_SUCCESS;
2818:
2819: EXCEPTION -- Exception handler to record error

Line 2879: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Line_Adj : '||to_char(p_line_id));

2875:
2876:
2877: BEGIN
2878:
2879: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Line_Adj : '||to_char(p_line_id));
2880: OPEN c_line_adj;
2881:
2882: LOOP
2883:

Line 2960: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Line_Adj : ');

2956: END LOOP;
2957:
2958: oe_debug_pub.add('Number of price adjustments deleted : '||to_char(c_line_adj%ROWCOUNT),1);
2959: CLOSE c_line_adj;
2960: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Line_Adj : ');
2961:
2962: RETURN FND_API.G_RET_STS_SUCCESS;
2963:
2964: EXCEPTION -- Exception handler to record error

Line 2999: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Price_Attribs : '||to_char(p_header_id));

2995: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2996:
2997: BEGIN
2998:
2999: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Price_Attribs : '||to_char(p_header_id));
3000: OPEN c_order_price_attribs;
3001:
3002: LOOP
3003:

Line 3023: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Price_Attribs : ');

3019:
3020: oe_debug_pub.add('Number of order price attribs deleted : '||to_char(c_order_price_attribs%ROWCOUNT),1);
3021: CLOSE c_order_price_attribs;
3022:
3023: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Price_Attribs : ');
3024:
3025: RETURN FND_API.G_RET_STS_SUCCESS;
3026:
3027: EXCEPTION -- Exception handler to record error

Line 3060: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Order_Sales_Credits : '||to_char(p_header_id));

3056: l_lock_sales_credit_id NUMBER;
3057: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3058:
3059: BEGIN
3060: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Order_Sales_Credits : '||to_char(p_header_id));
3061:
3062: OPEN c_order_sales_credits;
3063:
3064: LOOP

Line 3085: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Order_Sales_Credits : ');

3081:
3082: oe_debug_pub.add('Number of order sales credit deleted : '||to_char(c_order_sales_credits%ROWCOUNT),1);
3083: CLOSE c_order_sales_credits;
3084:
3085: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Order_Sales_Credits : ');
3086: RETURN FND_API.G_RET_STS_SUCCESS;
3087:
3088: EXCEPTION -- Exception handler to record error
3089:

Line 3123: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Line_Sales_Credits : '||to_char(p_line_id));

3119: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3120:
3121: BEGIN
3122:
3123: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Line_Sales_Credits : '||to_char(p_line_id));
3124: OPEN c_line_sales_credits;
3125:
3126: LOOP
3127:

Line 3147: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Line_Sales_Credits : ');

3143:
3144: oe_debug_pub.add('Number of line sales credit deleted : '||to_char(c_line_sales_credits%ROWCOUNT),1);
3145: CLOSE c_line_sales_credits;
3146:
3147: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Line_Sales_Credits : ');
3148: RETURN FND_API.G_RET_STS_SUCCESS;
3149:
3150: EXCEPTION -- Exception handler to record error
3151:

Line 3184: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Order_Sets : '||to_char(p_header_id));

3180: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3181:
3182: BEGIN
3183:
3184: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Order_Sets : '||to_char(p_header_id));
3185: OPEN c_order_sets;
3186:
3187: LOOP
3188:

Line 3208: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Order_Sets : ');

3204:
3205: oe_debug_pub.add('Number of order sets deleted : '||to_char(c_order_sets%ROWCOUNT),1);
3206: CLOSE c_order_sets;
3207:
3208: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Order_Sets : ');
3209: RETURN FND_API.G_RET_STS_SUCCESS;
3210:
3211: EXCEPTION -- Exception handler to record error
3212:

Line 3247: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Line_Sets : '||to_char(p_line_id));

3243: l_lock_set_id NUMBER;
3244: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3245:
3246: BEGIN
3247: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Line_Sets : '||to_char(p_line_id));
3248:
3249: OPEN c_line_sets;
3250:
3251: LOOP

Line 3274: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Line_Sets : ');

3270:
3271: oe_debug_pub.add('Number of Line sets deleted : '||to_char(c_line_sets%ROWCOUNT),1);
3272: CLOSE c_line_sets;
3273:
3274: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Line_Sets : ');
3275: RETURN FND_API.G_RET_STS_SUCCESS;
3276:
3277: EXCEPTION -- Exception handler to record error
3278:

Line 3329: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Order_Hold : '||to_char(p_header_id));

3325: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3326: l_count NUMBER := 0; -- bug 6148214
3327:
3328: BEGIN
3329: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Order_Hold : '||to_char(p_header_id));
3330:
3331: OPEN c_order_holds;
3332:
3333: LOOP

Line 3402: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Order_Holds : ');

3398:
3399: oe_debug_pub.add('Number of order holds deleted : '||to_char(c_order_holds%ROWCOUNT),1);
3400: CLOSE c_order_holds;
3401:
3402: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Order_Holds : ');
3403: RETURN FND_API.G_RET_STS_SUCCESS;
3404:
3405: EXCEPTION -- Exception handler to record error
3406:

Line 3429: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_RMA_Line_Receipts: '||to_char(p_line_id));

3425: IS
3426: l_return_status VARCHAR2(10);
3427: l_message VARCHAR2(2000);
3428: BEGIN
3429: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_RMA_Line_Receipts: '||to_char(p_line_id));
3430:
3431: RCV_RMA_RCPT_PURGE.Purge_Receipts(p_line_id,l_return_status,l_message);
3432:
3433: IF l_return_status = 'FALSE' THEN

Line 3437: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_RMA_Line_Receipts.');

3433: IF l_return_status = 'FALSE' THEN
3434: RETURN FND_API.G_RET_STS_ERROR;
3435: END IF;
3436:
3437: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_RMA_Line_Receipts.');
3438: RETURN FND_API.G_RET_STS_SUCCESS;
3439:
3440: EXCEPTION -- Exception handler to record error
3441: WHEN OTHERS THEN

Line 3478: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_RMA_Line_Lot_Srl: '||to_char(p_line_id));

3474: l_lock_lot_serial_id NUMBER;
3475: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3476: l_message VARCHAR2(2000);
3477: BEGIN
3478: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_RMA_Line_Lot_Srl: '||to_char(p_line_id));
3479:
3480:
3481: OPEN c_line_lot_serials;
3482:

Line 3502: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_RMA_Line_Lot_Srl.');

3498: END LOOP;
3499:
3500: CLOSE c_line_lot_serials;
3501:
3502: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_RMA_Line_Lot_Srl.');
3503: RETURN FND_API.G_RET_STS_SUCCESS;
3504:
3505: EXCEPTION -- Exception handler to record error
3506: WHEN OTHERS THEN

Line 3717: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Quotes(p_header_id);

3713: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_QUOTE');
3714: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3715: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3716: l_error_message := FND_MESSAGE.GET;
3717: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Quotes(p_header_id);
3718:
3719: END IF;
3720:
3721: ELSE

Line 3728: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Orders( p_header_id);

3724: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_ORDER');
3725: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3726: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3727: l_error_message := FND_MESSAGE.GET;
3728: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Orders( p_header_id);
3729: END IF;
3730:
3731: IF l_return_status = FND_API.G_TRUE THEN
3732:

Line 3747: l_return_status := OE_ORDER_PURGE_PVT.check_open_invoiced_orders

3743: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_INVOICES');
3744: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3745: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3746: l_error_message := FND_MESSAGE.GET;
3747: l_return_status := OE_ORDER_PURGE_PVT.check_open_invoiced_orders
3748: ( TO_CHAR(p_order_number), l_order_type_name );
3749: END IF;
3750:
3751:

Line 3757: l_return_status := OE_ORDER_PURGE_PVT.check_open_returns

3753: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_RETURNS');
3754: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3755: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3756: l_error_message := FND_MESSAGE.GET;
3757: l_return_status := OE_ORDER_PURGE_PVT.check_open_returns
3758: (p_order_number, p_order_type_name);
3759: END IF;
3760:
3761:

Line 3802: OE_ORDER_PURGE_PVT.Check_Open_PO_Reqs_Dropship

3798: PO_CODE_RELEASE_GRP.PRC_11i_Family_Pack_J AND
3799: OE_CODE_CONTROL.Code_Release_Level >= '110510' THEN
3800:
3801: l_return_status :=
3802: OE_ORDER_PURGE_PVT.Check_Open_PO_Reqs_Dropship
3803: (p_header_id => p_header_id );
3804:
3805: IF l_return_status = FND_API.G_FALSE THEN
3806:

Line 3831: END OE_Order_Purge_PVT;

3827:
3828: END check_is_purgable;
3829:
3830:
3831: END OE_Order_Purge_PVT;