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 1228: oe_debug_pub.add('from oe_order_lines '

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

Line 1257: OE_DEBUG_PUB.Add

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

Line 1274: OE_DEBUG_PUB.Add

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

Line 1303: OE_DEBUG_PUB.Add

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

Line 1344: OE_DEBUG_PUB.Add

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

Line 1372: OE_DEBUG_PUB.Add

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

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

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

Line 1413: OE_DEBUG_PUB.Add

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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