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_DROP_SHIP_GRP dependencies on OE_DEBUG_PUB

Line 39: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

35: --
36: L_Drop_Ship_Source_Count Number(4);
37:
38: --
39: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
40: --
41: Begin
42:
43: Open L_Drop_Ship_Source_ID_Csr ;

Line 71: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

67: P_PO_Line_ID In Number,
68: P_Line_Location_ID In Number, P_PO_Release_ID In Number Default Null)
69: IS
70: --
71: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
72: --
73: BEGIN
74:
75: Insert Into OE_Drop_Ship_Sources

Line 156: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

152: WHERE Drop_Ship_source_ID = P_Interface_Source_Line_ID
153: FOR UPDATE OF Requisition_Header_ID NOWAIT; -- bug 4503620
154:
155: --
156: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
157: --
158: BEGIN
159:
160: SavePoint Update_Req_Info_GRP;

Line 237: oe_debug_pub.add('OEXUDSHB.pls:Update_Req_Info- unable to lock the line',1);

233: EXCEPTION
234: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN -- bug 4503620
235: Rollback to Update_Req_Info_Grp;
236: IF l_debug_level > 0 THEN
237: oe_debug_pub.add('OEXUDSHB.pls:Update_Req_Info- unable to lock the line',1);
238: END IF;
239: fnd_message.set_name('ONT', 'OE_LINE_LOCKED');
240: -- msg not added in OE as the msg ctx is not set
241: P_Msg_Data := FND_MESSAGE.GET;

Line 297: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

293: WHERE requisition_header_id = P_Requisition_Header_ID
294: AND process_flag = P_Process_Flag
295: AND request_id = P_Request_Id;
296: --
297: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
298: --
299: BEGIN
300:
301: SAVEPOINT UPDATE_ALL_REQS_IN_PROCESS;

Line 400: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

396: AND Requisition_Header_ID = P_Req_Header_ID
397: FOR Update of PO_Header_ID NOWAIT; -- bug 4503620
398:
399: --
400: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
401: --
402: BEGIN
403:
404: SavePoint Update_PO_Info_GRP;

Line 459: oe_debug_pub.add('OEXUDSHB.pls:Update_PO_Info-unable to lock the line',1);

455: EXCEPTION
456: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN -- bug 4503620
457: Rollback to Update_PO_Info_GRP;
458: IF l_debug_level > 0 THEN
459: oe_debug_pub.add('OEXUDSHB.pls:Update_PO_Info-unable to lock the line',1);
460: END IF;
461: fnd_message.set_name('ONT', 'OE_LINE_LOCKED');
462: -- msg not added in OE as the msg ctx is not set
463: P_Msg_Data := FND_MESSAGE.GET;

Line 494: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

490: FROM OE_Drop_Ship_Sources
491: WHERE Requisition_Line_ID = P_Req_Line_ID;
492:
493: --
494: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
495: --
496: BEGIN
497: OPEN L_Drop_Ship_Csr;
498: FETCH L_Drop_Ship_Csr Into L_Line_Id;

Line 525: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

521: SELECT Line_Id
522: FROM OE_Drop_Ship_Sources
523: WHERE Line_Location_Id = P_PO_Line_Location_ID;
524: --
525: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
526: --
527: BEGIN
528: OPEN L_Drop_Ship_Csr;
529:

Line 565: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

561: ,x_msg_count OUT NOCOPY NUMBER
562: ,x_return_status OUT NOCOPY VARCHAR2
563: )
564: IS
565: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
566: l_line_id NUMBER;
567: l_header_id NUMBER;
568: l_org_id NUMBER;
569: l_num_lines NUMBER;

Line 578: OE_DEBUG_PUB.Add('Entering Update_Drop_Ship_Links...',1);

574:
575: SAVEPOINT Update_Drop_Ship_Links_GRP;
576:
577: IF l_debug_level > 0 THEN
578: OE_DEBUG_PUB.Add('Entering Update_Drop_Ship_Links...',1);
579: END IF;
580:
581: Get_Drop_Ship_Line_ids
582: ( p_po_header_id => p_po_header_id

Line 608: OE_DEBUG_PUB.Add('Updated the Drop Ship Links...',1);

604: WHERE line_id = l_line_id
605: AND header_id = l_header_id;
606:
607: IF l_debug_level > 0 THEN
608: OE_DEBUG_PUB.Add('Updated the Drop Ship Links...',1);
609: END IF;
610:
611: END IF;
612:

Line 614: OE_DEBUG_PUB.Add('Exiting Update_Drop_Ship_Links...',1);

610:
611: END IF;
612:
613: IF l_debug_level > 0 THEN
614: OE_DEBUG_PUB.Add('Exiting Update_Drop_Ship_Links...',1);
615: END IF;
616:
617: EXCEPTION
618:

Line 622: OE_DEBUG_PUB.Add('No DAta Found in Update_Drop_Ship_Links...',1);

618:
619: WHEN NO_DATA_FOUND THEN
620:
621: IF l_debug_level > 0 THEN
622: OE_DEBUG_PUB.Add('No DAta Found in Update_Drop_Ship_Links...',1);
623: END IF;
624:
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626:

Line 658: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

654: Function Is_Receipt_For_Drop_Ship
655: ( p_rcv_transaction_id IN NUMBER
656: )RETURN BOOLEAN
657: IS
658: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
659: l_line_id NUMBER;
660: BEGIN
661:
662: IF l_debug_level > 0 THEN

Line 663: OE_DEBUG_PUB.Add('Entering Is_Receipt_For_Drop_Ship...'||

659: l_line_id NUMBER;
660: BEGIN
661:
662: IF l_debug_level > 0 THEN
663: OE_DEBUG_PUB.Add('Entering Is_Receipt_For_Drop_Ship...'||
664: p_rcv_transaction_id,1);
665: END IF;
666:
667: SELECT ol.line_id

Line 683: OE_DEBUG_PUB.Add('Exiting Is_Receipt_For_Drop_Ship...',1);

679:
680: RETURN TRUE;
681:
682: IF l_debug_level > 0 THEN
683: OE_DEBUG_PUB.Add('Exiting Is_Receipt_For_Drop_Ship...',1);
684: END IF;
685:
686: EXCEPTION
687: WHEN NO_DATA_FOUND THEN

Line 689: OE_DEBUG_PUB.Add('No Data Found in Is_Receipt_For_Drop_Ship...',1);

685:
686: EXCEPTION
687: WHEN NO_DATA_FOUND THEN
688: IF l_debug_level > 0 THEN
689: OE_DEBUG_PUB.Add('No Data Found in Is_Receipt_For_Drop_Ship...',1);
690: END IF;
691: RETURN FALSE;
692: END Is_Receipt_For_Drop_Ship;
693:

Line 731: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

727: , x_org_id OUT NOCOPY NUMBER
728: )
729:
730: IS
731: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
732: BEGIN
733:
734: IF l_debug_level > 0 THEN
735: OE_DEBUG_PUB.Add('Entering Get_Drop_Ship_Line_ids...' || p_mode,1);

Line 735: OE_DEBUG_PUB.Add('Entering Get_Drop_Ship_Line_ids...' || p_mode,1);

731: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
732: BEGIN
733:
734: IF l_debug_level > 0 THEN
735: OE_DEBUG_PUB.Add('Entering Get_Drop_Ship_Line_ids...' || p_mode,1);
736: END IF;
737:
738: -- Check for Open Lines and Not Shipped Yet Lines
739:

Line 763: OE_DEBUG_PUB.Add('no open order line', 5);

759:
760: WHEN NO_DATA_FOUND THEN
761:
762: IF l_debug_level > 0 THEN
763: OE_DEBUG_PUB.Add('no open order line', 5);
764: END IF;
765:
766: IF p_mode is NULL THEN
767:

Line 769: OE_DEBUG_PUB.Add('No Data Found first sql', 2);

765:
766: IF p_mode is NULL THEN
767:
768: IF l_debug_level > 0 THEN
769: OE_DEBUG_PUB.Add('No Data Found first sql', 2);
770: END IF;
771:
772: x_line_id := NULL;
773: x_header_id := NULL;

Line 792: OE_DEBUG_PUB.Add('line found now '|| x_line_id, 2);

788: AND oel.line_id = ds.line_id
789: AND oel.header_id = ds.header_id;
790:
791: IF l_debug_level > 0 THEN
792: OE_DEBUG_PUB.Add('line found now '|| x_line_id, 2);
793: END IF;
794:
795: EXCEPTION
796:

Line 800: OE_DEBUG_PUB.Add('multiple receipts ', 2);

796:
797: WHEN TOO_MANY_ROWS THEN
798:
799: IF l_debug_level > 0 THEN
800: OE_DEBUG_PUB.Add('multiple receipts ', 2);
801: END IF;
802: x_line_id := -99;
803:
804: SELECT oel.header_id,

Line 817: OE_DEBUG_PUB.Add('sql error * '|| sqlerrm, 2);

813: AND rownum = 1;
814:
815: WHEN OTHERS THEN
816: IF l_debug_level > 0 THEN
817: OE_DEBUG_PUB.Add('sql error * '|| sqlerrm, 2);
818: END IF;
819: RAISE;
820: END;
821:

Line 828: OE_DEBUG_PUB.Add('rcv txn id '|| p_rcv_transaction_id, 2);

824:
825: ELSIF p_mode = 2 THEN
826:
827: IF l_debug_level > 0 THEN
828: OE_DEBUG_PUB.Add('rcv txn id '|| p_rcv_transaction_id, 2);
829: END IF;
830:
831: SELECT MAX(OL.line_id)
832: INTO x_line_id

Line 858: OE_DEBUG_PUB.Add('Exiting Get_Drop_Ship_Line_ids...'||x_num_lines,1);

854: AND oel.line_id = ds.line_id
855: AND oel.header_id = ds.header_id;
856:
857: IF l_debug_level > 0 THEN
858: OE_DEBUG_PUB.Add('Exiting Get_Drop_Ship_Line_ids...'||x_num_lines,1);
859: END IF;
860:
861: EXCEPTION
862:

Line 865: OE_DEBUG_PUB.Add('No Data Found in Get_Drop_Ship_Line_ids', 2);

861: EXCEPTION
862:
863: WHEN NO_DATA_FOUND THEN
864: IF l_debug_level > 0 THEN
865: OE_DEBUG_PUB.Add('No Data Found in Get_Drop_Ship_Line_ids', 2);
866: END IF;
867: x_num_lines := NULL;
868: x_line_id := NULL;
869: x_header_id := NULL;

Line 874: OE_DEBUG_PUB.Add('Too Many Rows in Get_Drop_Ship_Line_ids', 2);

870: x_org_id := NULL;
871:
872: WHEN TOO_MANY_ROWS THEN
873: IF l_debug_level > 0 THEN
874: OE_DEBUG_PUB.Add('Too Many Rows in Get_Drop_Ship_Line_ids', 2);
875: END IF;
876:
877: RAISE;
878:

Line 921: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

917: ,x_msg_count OUT NOCOPY NUMBER
918: ,x_return_status OUT NOCOPY VARCHAR2
919: )
920: IS
921: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
922: l_line_id NUMBER;
923: l_header_id NUMBER;
924: l_org_id NUMBER;
925: l_num_lines NUMBER;

Line 931: OE_DEBUG_PUB.Add('Entering Get_Order_Line_Status...',1);

927:
928: x_return_status := FND_API.G_RET_STS_SUCCESS;
929:
930: IF l_debug_level > 0 THEN
931: OE_DEBUG_PUB.Add('Entering Get_Order_Line_Status...',1);
932: END IF;
933:
934: Get_Drop_Ship_Line_ids
935: ( p_po_header_id => p_po_header_id

Line 963: OE_DEBUG_PUB.Add('Exiting Get_Order_Line_Status...',1);

959: x_on_hold := NULL;
960: x_order_line_status := NULL;
961:
962: IF l_debug_level > 0 THEN
963: OE_DEBUG_PUB.Add('Exiting Get_Order_Line_Status...',1);
964: END IF;
965:
966: EXCEPTION
967:

Line 971: OE_DEBUG_PUB.Add('No DAta Found in Update_Drop_Ship_Links...',1);

967:
968: WHEN NO_DATA_FOUND THEN
969:
970: IF l_debug_level > 0 THEN
971: OE_DEBUG_PUB.Add('No DAta Found in Update_Drop_Ship_Links...',1);
972: END IF;
973:
974: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
975:

Line 1055: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1051: l_access_mode VARCHAR2(1);
1052: l_current_org_id NUMBER;
1053: l_reset_policy BOOLEAN;
1054: --
1055: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1056: --
1057: BEGIN
1058: IF l_debug_level > 0 THEN
1059: OE_DEBUG_PUB.Add('Entering Get_Order_Line_Info '||p_mode,1);

Line 1059: OE_DEBUG_PUB.Add('Entering Get_Order_Line_Info '||p_mode,1);

1055: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1056: --
1057: BEGIN
1058: IF l_debug_level > 0 THEN
1059: OE_DEBUG_PUB.Add('Entering Get_Order_Line_Info '||p_mode,1);
1060: END IF;
1061:
1062: x_return_status := FND_API.G_RET_STS_SUCCESS;
1063: l_access_mode := mo_global.Get_access_mode; -- MOAC

Line 1078: OE_DEBUG_PUB.Add('line_id '|| l_line_id || 'om org ' || l_org_id,3);

1074: ,x_header_id => l_header_id
1075: ,x_org_id => l_org_id);
1076:
1077: IF l_debug_level > 0 THEN
1078: OE_DEBUG_PUB.Add('line_id '|| l_line_id || 'om org ' || l_org_id,3);
1079: END IF;
1080:
1081: IF l_line_id is NULL THEN
1082: IF l_debug_level > 0 THEN

Line 1083: OE_DEBUG_PUB.Add

1079: END IF;
1080:
1081: IF l_line_id is NULL THEN
1082: IF l_debug_level > 0 THEN
1083: OE_DEBUG_PUB.Add
1084: ('no line for this po_location_id '|| p_po_line_location_id,3);
1085: END IF;
1086: RAISE FND_API.G_EXC_ERROR;
1087: END IF;

Line 1095: OE_DEBUG_PUB.Add(' po org '|| l_po_org_id, 5);

1091: FROM po_line_locations_all
1092: WHERE line_location_id = p_po_line_location_id;
1093:
1094: IF l_debug_level > 0 THEN
1095: OE_DEBUG_PUB.Add(' po org '|| l_po_org_id, 5);
1096: END IF;
1097:
1098: IF l_po_org_id <> l_org_id THEN
1099: -- MOAC

Line 1121: OE_DEBUG_PUB.Add('context switched ' || x_return_status,3);

1117: ,x_msg_count => x_msg_count
1118: ,x_msg_data => x_msg_data );
1119:
1120: IF l_debug_level > 0 THEN
1121: OE_DEBUG_PUB.Add('context switched ' || x_return_status,3);
1122: END IF;
1123:
1124: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1125: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1146: OE_DEBUG_PUB.Add('context switched for no context' || x_return_status,3);

1142: ,x_msg_count => x_msg_count
1143: ,x_msg_data => x_msg_data );
1144:
1145: IF l_debug_level > 0 THEN
1146: OE_DEBUG_PUB.Add('context switched for no context' || x_return_status,3);
1147: END IF;
1148:
1149: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1150: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1167: OE_DEBUG_PUB.Add

1163:
1164: IF l_line_id = -99 THEN
1165:
1166: IF l_debug_level > 0 THEN
1167: OE_DEBUG_PUB.Add
1168: ('order number '|| x_order_line_info_rec.sales_order_number,3);
1169: END IF;
1170: RETURN;
1171:

Line 1230: oe_debug_pub.add('from oe_order_lines '

1226: AND oelup.lookup_code = oel.flow_status_code
1227: AND oelup.lookup_type = 'LINE_FLOW_STATUS';
1228:
1229: IF l_debug_level > 0 THEN
1230: oe_debug_pub.add('from oe_order_lines '
1231: || x_order_line_info_rec.customer_product_description
1232: || l_shipping_method_code, 3);
1233: END IF;
1234:

Line 1259: OE_DEBUG_PUB.Add

1255: ,x_zip => l_zip
1256: ,x_country => l_country);
1257:
1258: IF l_debug_level > 0 THEN
1259: OE_DEBUG_PUB.Add
1260: ('got ship to ct name and location: '
1261: || x_order_line_info_rec.ship_to_customer_name || '-'
1262: || x_order_line_info_rec.ship_to_customer_location,5);
1263: END IF;

Line 1276: OE_DEBUG_PUB.Add

1272:
1273: IF p_mode = 1 OR
1274: p_mode = 2 THEN
1275: IF l_debug_level > 0 THEN
1276: OE_DEBUG_PUB.Add
1277: ('sales order info: '
1278: || x_order_line_info_rec.sales_order_line_number || '-'
1279: || x_order_line_info_rec.sales_order_line_ordered_qty || '-'
1280: || x_order_line_info_rec.sales_order_line_shipped_qty || '-'

Line 1305: OE_DEBUG_PUB.Add

1301: x_order_line_info_rec.ship_to_contact_phone := null;
1302: END IF;
1303:
1304: IF l_debug_level > 0 THEN
1305: OE_DEBUG_PUB.Add
1306: ('got ship to contact details: '
1307: || x_order_line_info_rec.ship_to_contact_name || '-'
1308: || x_order_line_info_rec.ship_to_contact_fax || '-'
1309: || x_order_line_info_rec.ship_to_contact_phone || '-'

Line 1346: OE_DEBUG_PUB.Add

1342: x_order_line_info_rec.deliver_to_customer_zip := l_zip;
1343: x_order_line_info_rec.deliver_to_customer_country := l_country;
1344:
1345: IF l_debug_level > 0 THEN
1346: OE_DEBUG_PUB.Add
1347: ('got deliver to ct details: '
1348: || x_order_line_info_rec.deliver_to_customer_name || '-'
1349: || x_order_line_info_rec.deliver_to_customer_location || '-'
1350: || x_order_line_info_rec.deliver_to_customer_address || '-', 5);

Line 1374: OE_DEBUG_PUB.Add

1370: x_order_line_info_rec.deliver_to_contact_phone := null;
1371: END IF;
1372:
1373: IF l_debug_level > 0 THEN
1374: OE_DEBUG_PUB.Add
1375: ('got deliver to contact details: '
1376: || x_order_line_info_rec.deliver_to_contact_name || '-'
1377: || x_order_line_info_rec.deliver_to_contact_fax || '-'
1378: || x_order_line_info_rec.deliver_to_contact_phone || '-'

Line 1405: oe_debug_pub.add('here'|| l_shipping_method_code, 1);

1401: RAISE FND_API.G_EXC_ERROR;
1402: END IF;
1403:
1404: IF l_shipping_method_code is NOT NULL THEN
1405: oe_debug_pub.add('here'|| l_shipping_method_code, 1);
1406:
1407: SELECT ship_method_meaning
1408: INTO x_order_line_info_rec.shipping_method
1409: FROM wsh_carrier_services wshca

Line 1415: OE_DEBUG_PUB.Add

1411:
1412: END IF;
1413:
1414: IF l_debug_level > 0 THEN
1415: OE_DEBUG_PUB.Add
1416: ('got ct product and ship method: '
1417: || x_order_line_info_rec.customer_product_description || '-'
1418: || x_order_line_info_rec.shipping_method, 5);
1419: END IF;

Line 1435: OE_DEBUG_PUB.Add('context reset tp po org: ' || l_po_org_id,3);

1431: ,resp_id => l_orig_resp_id
1432: ,resp_appl_id => l_orig_resp_appl_id);
1433:
1434: IF l_debug_level > 0 THEN
1435: OE_DEBUG_PUB.Add('context reset tp po org: ' || l_po_org_id,3);
1436: END IF;
1437:
1438: l_reset_context := 0;
1439:

Line 1443: OE_DEBUG_PUB.Add('Leaving Get_Order_Line_Info',1);

1439:
1440: END IF; */
1441:
1442: IF l_debug_level > 0 THEN
1443: OE_DEBUG_PUB.Add('Leaving Get_Order_Line_Info',1);
1444: END IF;
1445:
1446: EXCEPTION
1447: WHEN FND_API.G_EXC_ERROR THEN

Line 1451: OE_DEBUG_PUB.Add('error in Get_Order_Line_Info '||sqlerrm,1);

1447: WHEN FND_API.G_EXC_ERROR THEN
1448: x_return_status := FND_API.G_RET_STS_ERROR;
1449:
1450: IF l_debug_level > 0 THEN
1451: OE_DEBUG_PUB.Add('error in Get_Order_Line_Info '||sqlerrm,1);
1452: END IF;
1453:
1454: WHEN others THEN
1455:

Line 1459: OE_DEBUG_PUB.Add('error in Get_Order_Line_Info '||sqlerrm,1);

1455:
1456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1457:
1458: IF l_debug_level > 0 THEN
1459: OE_DEBUG_PUB.Add('error in Get_Order_Line_Info '||sqlerrm,1);
1460: END IF;
1461:
1462: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1463: THEN

Line 1501: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1497: (p_entity = 'PO_HEADERS' AND
1498: po_header_id = cp_entity_id)
1499: FOR UPDATE NOWAIT;
1500:
1501: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1502: I NUMBER := 1;
1503: l_line_id NUMBER;
1504:
1505: BEGIN

Line 1508: OE_DEBUG_PUB.Add('Entering Purge_Drop_Ship_PO_Links...',1);

1504:
1505: BEGIN
1506:
1507: IF l_debug_level > 0 THEN
1508: OE_DEBUG_PUB.Add('Entering Purge_Drop_Ship_PO_Links...',1);
1509: END IF;
1510:
1511: x_return_status := FND_API.G_RET_STS_SUCCESS;
1512:

Line 1516: OE_DEBUG_PUB.Add('Entity:'||p_entity,1);

1512:
1513: FOR I in 1..p_entity_id_tbl.COUNT LOOP
1514:
1515: IF l_debug_level > 0 THEN
1516: OE_DEBUG_PUB.Add('Entity:'||p_entity,1);
1517: OE_DEBUG_PUB.Add('Entity ID :'||p_entity_id_tbl(I),1);
1518: END IF;
1519:
1520: IF p_entity = 'PO_REQUISITION_HEADERS' OR

Line 1517: OE_DEBUG_PUB.Add('Entity ID :'||p_entity_id_tbl(I),1);

1513: FOR I in 1..p_entity_id_tbl.COUNT LOOP
1514:
1515: IF l_debug_level > 0 THEN
1516: OE_DEBUG_PUB.Add('Entity:'||p_entity,1);
1517: OE_DEBUG_PUB.Add('Entity ID :'||p_entity_id_tbl(I),1);
1518: END IF;
1519:
1520: IF p_entity = 'PO_REQUISITION_HEADERS' OR
1521: p_entity = 'PO_HEADERS' THEN

Line 1527: OE_DEBUG_PUB.Add('After Locking : '||l_line_id, 2);

1523: OPEN c_dropship(p_entity_id_tbl(I));
1524: FETCH c_dropship INTO l_line_id;
1525:
1526: IF l_debug_level > 0 THEN
1527: OE_DEBUG_PUB.Add('After Locking : '||l_line_id, 2);
1528: END IF;
1529: CLOSE c_dropship;
1530:
1531: DELETE

Line 1539: OE_DEBUG_PUB.Add('After Deleting: '||l_line_id, 2);

1535: (p_entity = 'PO_HEADERS' AND
1536: po_header_id = p_entity_id_tbl(I));
1537:
1538: IF l_debug_level > 0 THEN
1539: OE_DEBUG_PUB.Add('After Deleting: '||l_line_id, 2);
1540: END IF;
1541:
1542: END IF;
1543:

Line 1547: OE_DEBUG_PUB.Add('Exiting Purge_Drop_Ship_PO_Links...',1);

1543:
1544: END LOOP;
1545:
1546: IF l_debug_level > 0 THEN
1547: OE_DEBUG_PUB.Add('Exiting Purge_Drop_Ship_PO_Links...',1);
1548: END IF;
1549:
1550:
1551: EXCEPTION

Line 1558: OE_DEBUG_PUB.Add('UnExp Error in Purge_Drop_Ship_PO_Links...'||sqlerrm,4);

1554:
1555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1556:
1557: IF l_debug_level > 0 THEN
1558: OE_DEBUG_PUB.Add('UnExp Error in Purge_Drop_Ship_PO_Links...'||sqlerrm,4);
1559: END IF;
1560:
1561: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1562: THEN

Line 1594: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

1590: ,x_msg_data OUT NOCOPY VARCHAR2
1591: ,x_return_status OUT NOCOPY VARCHAR2
1592: )
1593: IS
1594: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1595: I NUMBER := 1;
1596: l_count NUMBER := 0;
1597:
1598: BEGIN

Line 1601: OE_DEBUG_PUB.Add('Entering Purge_Drop_Ship_PO_Validation...',1);

1597:
1598: BEGIN
1599:
1600: IF l_debug_level > 0 THEN
1601: OE_DEBUG_PUB.Add('Entering Purge_Drop_Ship_PO_Validation...',1);
1602: END IF;
1603:
1604: x_return_status := FND_API.G_RET_STS_SUCCESS;
1605: x_purge_allowed_tbl := VAL_STATUS_TBL_TYPE();

Line 1612: OE_DEBUG_PUB.Add('Entity:'||p_entity,1);

1608:
1609: FOR I in 1..p_entity_id_tbl.COUNT LOOP
1610:
1611: IF l_debug_level > 0 THEN
1612: OE_DEBUG_PUB.Add('Entity:'||p_entity,1);
1613: OE_DEBUG_PUB.Add('Entity ID :'||p_entity_id_tbl(I),1);
1614: END IF;
1615:
1616: IF p_entity = 'PO_REQUISITION_HEADERS' OR

Line 1613: OE_DEBUG_PUB.Add('Entity ID :'||p_entity_id_tbl(I),1);

1609: FOR I in 1..p_entity_id_tbl.COUNT LOOP
1610:
1611: IF l_debug_level > 0 THEN
1612: OE_DEBUG_PUB.Add('Entity:'||p_entity,1);
1613: OE_DEBUG_PUB.Add('Entity ID :'||p_entity_id_tbl(I),1);
1614: END IF;
1615:
1616: IF p_entity = 'PO_REQUISITION_HEADERS' OR
1617: p_entity = 'PO_HEADERS' THEN

Line 1646: OE_DEBUG_PUB.Add('Line is Open :'||l_count);

1642:
1643: IF l_count > 0 THEN
1644:
1645: IF l_debug_level > 0 THEN
1646: OE_DEBUG_PUB.Add('Line is Open :'||l_count);
1647: END IF;
1648:
1649: x_purge_allowed_tbl(I) := 'N';
1650:

Line 1653: OE_DEBUG_PUB.Add('Line is Closed:'||l_count);

1649: x_purge_allowed_tbl(I) := 'N';
1650:
1651: ELSE
1652: IF l_debug_level > 0 THEN
1653: OE_DEBUG_PUB.Add('Line is Closed:'||l_count);
1654: END IF;
1655:
1656: x_purge_allowed_tbl(I) := 'Y';
1657:

Line 1665: OE_DEBUG_PUB.Add('Purge Table Count...'||x_purge_allowed_tbl.COUNT,1);

1661:
1662: END LOOP;
1663:
1664: IF l_debug_level > 0 THEN
1665: OE_DEBUG_PUB.Add('Purge Table Count...'||x_purge_allowed_tbl.COUNT,1);
1666: OE_DEBUG_PUB.Add('Exiting Purge_Drop_Ship_PO_Validation...',1);
1667: END IF;
1668:
1669: EXCEPTION

Line 1666: OE_DEBUG_PUB.Add('Exiting Purge_Drop_Ship_PO_Validation...',1);

1662: END LOOP;
1663:
1664: IF l_debug_level > 0 THEN
1665: OE_DEBUG_PUB.Add('Purge Table Count...'||x_purge_allowed_tbl.COUNT,1);
1666: OE_DEBUG_PUB.Add('Exiting Purge_Drop_Ship_PO_Validation...',1);
1667: END IF;
1668:
1669: EXCEPTION
1670:

Line 1676: OE_DEBUG_PUB.Add('UnExp Error in Purge_Drop_Ship_PO_Validation...'||sqlerrm,4);

1672:
1673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1674:
1675: IF l_debug_level > 0 THEN
1676: OE_DEBUG_PUB.Add('UnExp Error in Purge_Drop_Ship_PO_Validation...'||sqlerrm,4);
1677: END IF;
1678:
1679: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1680: THEN