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.12020000.2 2013/01/19 00:51:59 cpati 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 2201: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Headers : '||to_char(p_header_id));

2197: l_msg_data VARCHAR2(2000);
2198:
2199: BEGIN
2200:
2201: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Headers : '||to_char(p_header_id));
2202:
2203: --16193599 Audit History Purge Start
2204: OPEN c_lock_audit_hist_ent1;
2205: CLOSE c_lock_audit_hist_ent1;

Line 2236: l_return_status := OE_Order_Purge_PVT.OE_Purge_Header_Adj

2232:
2233: CLOSE c_lock_header;
2234:
2235: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2236: l_return_status := OE_Order_Purge_PVT.OE_Purge_Header_Adj
2237: (
2238: p_purge_set_id => p_purge_set_id,
2239: p_header_id => p_header_id
2240: );

Line 2248: l_return_status := OE_Order_Purge_PVT.OE_Purge_Price_Attribs

2244: RETURN;
2245: END IF;
2246:
2247: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2248: l_return_status := OE_Order_Purge_PVT.OE_Purge_Price_Attribs
2249: (
2250: p_purge_set_id => p_purge_set_id,
2251: p_header_id => p_header_id
2252: );

Line 2260: l_return_status := OE_Order_Purge_PVT.OE_Purge_Order_Sales_Credits

2256: RETURN;
2257: END IF;
2258:
2259: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2260: l_return_status := OE_Order_Purge_PVT.OE_Purge_Order_Sales_Credits
2261: (
2262: p_purge_set_id => p_purge_set_id,
2263: p_header_id => p_header_id
2264: );

Line 2272: l_return_status := OE_Order_Purge_PVT.OE_Purge_Order_Sets

2268: RETURN;
2269: END IF;
2270:
2271: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2272: l_return_status := OE_Order_Purge_PVT.OE_Purge_Order_Sets
2273: (
2274: p_purge_set_id => p_purge_set_id,
2275: p_header_id => p_header_id
2276: );

Line 2284: l_return_status := OE_Order_Purge_PVT.OE_Purge_Order_Holds

2280: RETURN;
2281: END IF;
2282:
2283: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2284: l_return_status := OE_Order_Purge_PVT.OE_Purge_Order_Holds
2285: (
2286: p_purge_set_id => p_purge_set_id,
2287: p_header_id => p_header_id
2288: );

Line 2297: l_return_status := OE_Order_Purge_PVT.OE_Purge_Header_payments

2293: END IF;
2294:
2295: -- purge for multiple payments
2296: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2297: l_return_status := OE_Order_Purge_PVT.OE_Purge_Header_payments
2298: ( p_purge_set_id => p_purge_set_id,
2299: p_header_id => p_header_id
2300: );
2301: ELSE

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

2421: DELETE FROM oe_order_headers
2422: WHERE header_id = p_header_id;
2423: oe_debug_pub.add('deleted header='|| to_char(p_header_id));
2424:
2425: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Headers : ');
2426:
2427: x_return_status := FND_API.G_RET_STS_SUCCESS;
2428:
2429: EXCEPTION -- Exception handler to record error

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

2492: WHERE ds.header_id = p_header_id;
2493:
2494: BEGIN
2495:
2496: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Lines : '||to_char(p_header_id));
2497:
2498:
2499: OPEN c_purge_lines;
2500: LOOP

Line 2528: l_return_status := OE_Order_Purge_PVT.OE_Purge_Line_Adj

2524: END IF;
2525:
2526:
2527: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2528: l_return_status := OE_Order_Purge_PVT.OE_Purge_Line_Adj
2529: (
2530: p_purge_set_id => p_purge_set_id,
2531: p_header_id => p_header_id,
2532: p_line_id => l_line_id

Line 2541: l_return_status := OE_Order_Purge_PVT.OE_Purge_Line_Sales_Credits

2537: RETURN;
2538: END IF;
2539:
2540: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2541: l_return_status := OE_Order_Purge_PVT.OE_Purge_Line_Sales_Credits
2542: (
2543: p_purge_set_id => p_purge_set_id,
2544: p_header_id => p_header_id,
2545: p_line_id => l_line_id

Line 2554: l_return_status := OE_Order_Purge_PVT.OE_Purge_Line_Sets

2550: RETURN;
2551: END IF;
2552:
2553: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2554: l_return_status := OE_Order_Purge_PVT.OE_Purge_Line_Sets
2555: (
2556: p_purge_set_id => p_purge_set_id,
2557: p_header_id => p_header_id,
2558: p_line_id => l_line_id

Line 2568: l_return_status := OE_Order_Purge_PVT.OE_Purge_Line_payments

2564: END IF;
2565:
2566: -- purge for multiple payments.
2567: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2568: l_return_status := OE_Order_Purge_PVT.OE_Purge_Line_payments
2569: ( p_purge_set_id => p_purge_set_id,
2570: p_header_id => p_header_id,
2571: p_line_id => l_line_id
2572: );

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

2733: oe_debug_pub.add('Number of lines deleted : '||to_char(c_purge_lines%ROWCOUNT),1);
2734: CLOSE c_purge_lines;
2735:
2736: oe_debug_pub.add('deleted lines for header='|| to_char(p_header_id));
2737: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Lines : ');
2738:
2739: x_return_status := FND_API.G_RET_STS_SUCCESS;
2740:
2741: EXCEPTION -- Exception handler to record error

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

2795: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2796:
2797: BEGIN
2798:
2799: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Header_Adj : '||to_char(p_header_id));
2800:
2801: OPEN c_header_adj;
2802:
2803: LOOP

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

2865:
2866: oe_debug_pub.add('Number of price adjustments deleted : '||to_char(c_header_adj%ROWCOUNT),1);
2867: CLOSE c_header_adj;
2868:
2869: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Header_Adj : ');
2870:
2871: RETURN FND_API.G_RET_STS_SUCCESS;
2872:
2873: EXCEPTION -- Exception handler to record error

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

2929:
2930:
2931: BEGIN
2932:
2933: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Line_Adj : '||to_char(p_line_id));
2934: OPEN c_line_adj;
2935:
2936: LOOP
2937:

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

3010: END LOOP;
3011:
3012: oe_debug_pub.add('Number of price adjustments deleted : '||to_char(c_line_adj%ROWCOUNT),1);
3013: CLOSE c_line_adj;
3014: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Line_Adj : ');
3015:
3016: RETURN FND_API.G_RET_STS_SUCCESS;
3017:
3018: EXCEPTION -- Exception handler to record error

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

3049: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3050:
3051: BEGIN
3052:
3053: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Price_Attribs : '||to_char(p_header_id));
3054: OPEN c_order_price_attribs;
3055:
3056: LOOP
3057:

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

3073:
3074: oe_debug_pub.add('Number of order price attribs deleted : '||to_char(c_order_price_attribs%ROWCOUNT),1);
3075: CLOSE c_order_price_attribs;
3076:
3077: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Price_Attribs : ');
3078:
3079: RETURN FND_API.G_RET_STS_SUCCESS;
3080:
3081: EXCEPTION -- Exception handler to record error

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

3110: l_lock_sales_credit_id NUMBER;
3111: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3112:
3113: BEGIN
3114: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Order_Sales_Credits : '||to_char(p_header_id));
3115:
3116: OPEN c_order_sales_credits;
3117:
3118: LOOP

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

3135:
3136: oe_debug_pub.add('Number of order sales credit deleted : '||to_char(c_order_sales_credits%ROWCOUNT),1);
3137: CLOSE c_order_sales_credits;
3138:
3139: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Order_Sales_Credits : ');
3140: RETURN FND_API.G_RET_STS_SUCCESS;
3141:
3142: EXCEPTION -- Exception handler to record error
3143:

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

3173: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3174:
3175: BEGIN
3176:
3177: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Line_Sales_Credits : '||to_char(p_line_id));
3178: OPEN c_line_sales_credits;
3179:
3180: LOOP
3181:

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

3197:
3198: oe_debug_pub.add('Number of line sales credit deleted : '||to_char(c_line_sales_credits%ROWCOUNT),1);
3199: CLOSE c_line_sales_credits;
3200:
3201: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Line_Sales_Credits : ');
3202: RETURN FND_API.G_RET_STS_SUCCESS;
3203:
3204: EXCEPTION -- Exception handler to record error
3205:

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

3234: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3235:
3236: BEGIN
3237:
3238: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Order_Sets : '||to_char(p_header_id));
3239: OPEN c_order_sets;
3240:
3241: LOOP
3242:

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

3258:
3259: oe_debug_pub.add('Number of order sets deleted : '||to_char(c_order_sets%ROWCOUNT),1);
3260: CLOSE c_order_sets;
3261:
3262: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Order_Sets : ');
3263: RETURN FND_API.G_RET_STS_SUCCESS;
3264:
3265: EXCEPTION -- Exception handler to record error
3266:

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

3297: l_lock_set_id NUMBER;
3298: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3299:
3300: BEGIN
3301: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Line_Sets : '||to_char(p_line_id));
3302:
3303: OPEN c_line_sets;
3304:
3305: LOOP

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

3324:
3325: oe_debug_pub.add('Number of Line sets deleted : '||to_char(c_line_sets%ROWCOUNT),1);
3326: CLOSE c_line_sets;
3327:
3328: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Line_Sets : ');
3329: RETURN FND_API.G_RET_STS_SUCCESS;
3330:
3331: EXCEPTION -- Exception handler to record error
3332:

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

3379: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3380: l_count NUMBER := 0; -- bug 6148214
3381:
3382: BEGIN
3383: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_Order_Hold : '||to_char(p_header_id));
3384:
3385: OPEN c_order_holds;
3386:
3387: LOOP

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

3452:
3453: oe_debug_pub.add('Number of order holds deleted : '||to_char(c_order_holds%ROWCOUNT),1);
3454: CLOSE c_order_holds;
3455:
3456: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_Order_Holds : ');
3457: RETURN FND_API.G_RET_STS_SUCCESS;
3458:
3459: EXCEPTION -- Exception handler to record error
3460:

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

3479: IS
3480: l_return_status VARCHAR2(10);
3481: l_message VARCHAR2(2000);
3482: BEGIN
3483: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_RMA_Line_Receipts: '||to_char(p_line_id));
3484:
3485: RCV_RMA_RCPT_PURGE.Purge_Receipts(p_line_id,l_return_status,l_message);
3486:
3487: IF l_return_status = 'FALSE' THEN

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

3487: IF l_return_status = 'FALSE' THEN
3488: RETURN FND_API.G_RET_STS_ERROR;
3489: END IF;
3490:
3491: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_RMA_Line_Receipts.');
3492: RETURN FND_API.G_RET_STS_SUCCESS;
3493:
3494: EXCEPTION -- Exception handler to record error
3495: WHEN OTHERS THEN

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

3528: l_lock_lot_serial_id NUMBER;
3529: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3530: l_message VARCHAR2(2000);
3531: BEGIN
3532: oe_debug_pub.add('Entering OE_ORDER_PURGE_PVT.OE_Purge_RMA_Line_Lot_Srl: '||to_char(p_line_id));
3533:
3534:
3535: OPEN c_line_lot_serials;
3536:

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

3552: END LOOP;
3553:
3554: CLOSE c_line_lot_serials;
3555:
3556: oe_debug_pub.add('Exiting OE_ORDER_PURGE_PVT.OE_Purge_RMA_Line_Lot_Srl.');
3557: RETURN FND_API.G_RET_STS_SUCCESS;
3558:
3559: EXCEPTION -- Exception handler to record error
3560: WHEN OTHERS THEN

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

3767: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_QUOTE');
3768: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3769: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3770: l_error_message := FND_MESSAGE.GET;
3771: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Quotes(p_header_id);
3772:
3773: END IF;
3774:
3775: ELSE

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

3778: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_ORDER');
3779: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3780: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3781: l_error_message := FND_MESSAGE.GET;
3782: l_return_status := OE_ORDER_PURGE_PVT.Check_Open_Orders( p_header_id);
3783: END IF;
3784:
3785: IF l_return_status = FND_API.G_TRUE THEN
3786:

Line 3801: l_return_status := OE_ORDER_PURGE_PVT.check_open_invoiced_orders

3797: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_INVOICES');
3798: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3799: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3800: l_error_message := FND_MESSAGE.GET;
3801: l_return_status := OE_ORDER_PURGE_PVT.check_open_invoiced_orders
3802: ( TO_CHAR(p_order_number), l_order_type_name );
3803: END IF;
3804:
3805:

Line 3811: l_return_status := OE_ORDER_PURGE_PVT.check_open_returns

3807: FND_MESSAGE.SET_NAME('ONT','OE_PUR_OPEN_RETURNS');
3808: l_temp_mesg := FND_MESSAGE.GET_ENCODED;
3809: FND_MESSAGE.SET_ENCODED(l_temp_mesg);
3810: l_error_message := FND_MESSAGE.GET;
3811: l_return_status := OE_ORDER_PURGE_PVT.check_open_returns
3812: (p_order_number, p_order_type_name);
3813: END IF;
3814:
3815:

Line 3856: OE_ORDER_PURGE_PVT.Check_Open_PO_Reqs_Dropship

3852: PO_CODE_RELEASE_GRP.PRC_11i_Family_Pack_J AND
3853: OE_CODE_CONTROL.Code_Release_Level >= '110510' THEN
3854:
3855: l_return_status :=
3856: OE_ORDER_PURGE_PVT.Check_Open_PO_Reqs_Dropship
3857: (p_header_id => p_header_id );
3858:
3859: IF l_return_status = FND_API.G_FALSE THEN
3860:

Line 3885: END OE_Order_Purge_PVT;

3881:
3882: END check_is_purgable;
3883:
3884:
3885: END OE_Order_Purge_PVT;