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

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

53: l_tp_location_name VARCHAR2(3200);
54: l_addr_id VARCHAR2(3200);
55:
56: --
57: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
58: --
59: BEGIN
60: IF l_debug_level > 0 THEN
61: oe_debug_pub.add( 'ADDRESS TYPE = '||P_ADDRESS_TYPE_IN ) ;

Line 61: oe_debug_pub.add( 'ADDRESS TYPE = '||P_ADDRESS_TYPE_IN ) ;

57: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
58: --
59: BEGIN
60: IF l_debug_level > 0 THEN
61: oe_debug_pub.add( 'ADDRESS TYPE = '||P_ADDRESS_TYPE_IN ) ;
62: END IF;
63: IF l_debug_level > 0 THEN
64: oe_debug_pub.add( 'ORG = '||P_ORG_ID_IN ) ;
65: END IF;

Line 64: oe_debug_pub.add( 'ORG = '||P_ORG_ID_IN ) ;

60: IF l_debug_level > 0 THEN
61: oe_debug_pub.add( 'ADDRESS TYPE = '||P_ADDRESS_TYPE_IN ) ;
62: END IF;
63: IF l_debug_level > 0 THEN
64: oe_debug_pub.add( 'ORG = '||P_ORG_ID_IN ) ;
65: END IF;
66: IF l_debug_level > 0 THEN
67: oe_debug_pub.add( 'ADDRESS ID = '||P_ADDRESS_ID_IN ) ;
68: END IF;

Line 67: oe_debug_pub.add( 'ADDRESS ID = '||P_ADDRESS_ID_IN ) ;

63: IF l_debug_level > 0 THEN
64: oe_debug_pub.add( 'ORG = '||P_ORG_ID_IN ) ;
65: END IF;
66: IF l_debug_level > 0 THEN
67: oe_debug_pub.add( 'ADDRESS ID = '||P_ADDRESS_ID_IN ) ;
68: END IF;
69:
70: IF p_address_type_in = 'CUSTOMER' THEN
71: l_address_type := 1;

Line 77: oe_debug_pub.add( 'BEFORE CALLING EC ADDRESS DERIVATION API' ) ;

73: l_address_type := 2;
74: END IF;
75:
76: IF l_debug_level > 0 THEN
77: oe_debug_pub.add( 'BEFORE CALLING EC ADDRESS DERIVATION API' ) ;
78: END IF;
79: ece_trading_partners_pub.ece_Get_Address_wrapper(
80: p_api_version_number => 1.0,
81: x_return_status => l_return_status,

Line 128: oe_debug_pub.add( 'ADDR1 = '||SUBSTR ( L_ADDR1 , 0 , 240 ) ) ;

124: x_region_2_out => l_region2,
125: x_region_3_out => l_region3);
126:
127: IF l_debug_level > 0 THEN
128: oe_debug_pub.add( 'ADDR1 = '||SUBSTR ( L_ADDR1 , 0 , 240 ) ) ;
129: END IF;
130: IF l_debug_level > 0 THEN
131: oe_debug_pub.add( 'CITY = '||L_CITY ) ;
132: END IF;

Line 131: oe_debug_pub.add( 'CITY = '||L_CITY ) ;

127: IF l_debug_level > 0 THEN
128: oe_debug_pub.add( 'ADDR1 = '||SUBSTR ( L_ADDR1 , 0 , 240 ) ) ;
129: END IF;
130: IF l_debug_level > 0 THEN
131: oe_debug_pub.add( 'CITY = '||L_CITY ) ;
132: END IF;
133: IF l_debug_level > 0 THEN
134: oe_debug_pub.add( 'ZIP = '||L_ZIP ) ;
135: END IF;

Line 134: oe_debug_pub.add( 'ZIP = '||L_ZIP ) ;

130: IF l_debug_level > 0 THEN
131: oe_debug_pub.add( 'CITY = '||L_CITY ) ;
132: END IF;
133: IF l_debug_level > 0 THEN
134: oe_debug_pub.add( 'ZIP = '||L_ZIP ) ;
135: END IF;
136: IF l_debug_level > 0 THEN
137: oe_debug_pub.add( 'COUNTRY = '||L_COUNTRY ) ;
138: END IF;

Line 137: oe_debug_pub.add( 'COUNTRY = '||L_COUNTRY ) ;

133: IF l_debug_level > 0 THEN
134: oe_debug_pub.add( 'ZIP = '||L_ZIP ) ;
135: END IF;
136: IF l_debug_level > 0 THEN
137: oe_debug_pub.add( 'COUNTRY = '||L_COUNTRY ) ;
138: END IF;
139:
140: EXCEPTION
141: WHEN OTHERS THEN

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

154: )
155: RETURN NUMBER
156: IS
157: --
158: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
159: --
160: BEGIN
161:
162: IF G_ORDER_TYPE_TBL.EXISTS(p_key)

Line 361: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

357: EXCEPTION
358: WHEN NO_DATA_FOUND THEN
359: IF G_ORDER_TYPE_TBL.EXISTS(p_key) THEN
360: IF l_debug_level > 0 THEN
361: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
362: END IF;
363: G_ORDER_TYPE_TBL.DELETE(p_key);
364: END IF;
365: RAISE NO_DATA_FOUND;

Line 369: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

365: RAISE NO_DATA_FOUND;
366: WHEN OTHERS THEN
367: IF G_ORDER_TYPE_TBL.EXISTS(p_key) THEN
368: IF l_debug_level > 0 THEN
369: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
370: END IF;
371: G_ORDER_TYPE_TBL.DELETE(p_key);
372: END IF;
373: OE_BULK_MSG_PUB.Add_Exc_Msg

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

383: )
384: RETURN NUMBER
385: IS
386: --
387: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
388: --
389: BEGIN
390:
391: IF G_LINE_TYPE_TBL.EXISTS(p_key) THEN

Line 422: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

418: EXCEPTION
419: WHEN NO_DATA_FOUND THEN
420: IF G_LINE_TYPE_TBL.EXISTS(p_key) THEN
421: IF l_debug_level > 0 THEN
422: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
423: END IF;
424: G_LINE_TYPE_TBL.DELETE(p_key);
425: END IF;
426: RAISE NO_DATA_FOUND;

Line 430: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

426: RAISE NO_DATA_FOUND;
427: WHEN OTHERS THEN
428: IF G_LINE_TYPE_TBL.EXISTS(p_key) THEN
429: IF l_debug_level > 0 THEN
430: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
431: END IF;
432: G_LINE_TYPE_TBL.DELETE(p_key);
433: END IF;
434: OE_BULK_MSG_PUB.Add_Exc_Msg

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

444: )
445: RETURN NUMBER
446: IS
447: --
448: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
449: --
450: BEGIN
451:
452: IF G_AGREEMENT_TBL.EXISTS(p_key)

Line 541: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

537: EXCEPTION
538: WHEN NO_DATA_FOUND THEN
539: IF G_AGREEMENT_TBL.EXISTS(p_key) THEN
540: IF l_debug_level > 0 THEN
541: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
542: END IF;
543: G_AGREEMENT_TBL.DELETE(p_key);
544: END IF;
545: RAISE NO_DATA_FOUND;

Line 549: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

545: RAISE NO_DATA_FOUND;
546: WHEN OTHERS THEN
547: IF G_AGREEMENT_TBL.EXISTS(p_key) THEN
548: IF l_debug_level > 0 THEN
549: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
550: END IF;
551: G_AGREEMENT_TBL.DELETE(p_key);
552: END IF;
553: OE_BULK_MSG_PUB.Add_Exc_Msg

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

584: --=================
585: */
586: -- INVCONV
587:
588: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
589: --
590: BEGIN
591:
592: IF G_ITEM_TBL.EXISTS(p_key1)

Line 712: oe_debug_pub.add( 'PROCESS INSTALLED' ) ;

708:
709: /* IF OE_Bulk_Order_PVT.G_PROCESS_INSTALLED_FLAG = 'Y' THEN
710:
711: IF l_debug_level > 0 THEN
712: oe_debug_pub.add( 'PROCESS INSTALLED' ) ;
713: END IF;
714:
715: IF INV_GMI_RSV_BRANCH.G_PROCESS_INV_INSTALLED = 'I' THEN
716: OPEN c_opm_item( l_key2

Line 729: oe_debug_pub.add( 'OPM item not found ', 1 ) ;

725: /*OPM HVOP need this in case of process warehouse and discrete item - Fully clear the process cache
726: IF c_opm_item%NOTFOUND THEN
727:
728: IF l_debug_level > 0 THEN
729: oe_debug_pub.add( 'OPM item not found ', 1 ) ;
730: END IF;
731: G_ITEM_TBL(p_key1).opm_item_id := NULL;
732: G_ITEM_TBL(p_key1).opm_item_um := NULL;
733: G_ITEM_TBL(p_key1).opm_item_um2 := NULL;

Line 755: oe_debug_pub.add( 'QUERYING BASED ON SHIP_FROM_ORG' , 3 ) ;

751:
752: IF (G_ITEM_TBL(p_key1).organization_id <> p_key2) THEN
753:
754: IF l_debug_level > 0 THEN
755: oe_debug_pub.add( 'QUERYING BASED ON SHIP_FROM_ORG' , 3 ) ;
756: END IF;
757:
758: -- invconv IF OE_Bulk_Order_PVT.G_PROCESS_INSTALLED_FLAG <> 'Y' THEN -- OPM HVOP added for error to test
759:

Line 803: oe_debug_pub.add( 'pal1 ' , 3 ) ;

799: WHERE INVENTORY_ITEM_ID = p_key1
800: AND ORGANIZATION_ID = p_key2; -- ship from org
801:
802: IF l_debug_level > 0 THEN
803: oe_debug_pub.add( 'pal1 ' , 3 ) ;
804: END IF;
805: -- INVCONV end if ;
806:
807:

Line 815: oe_debug_pub.add( 'pal2 ' , 3 ) ;

811: FROM mtl_parameters
812: WHERE organization_id = p_key2;
813: --bug 3798477
814: IF l_debug_level > 0 THEN
815: oe_debug_pub.add( 'pal2 ' , 3 ) ;
816: END IF;
817:
818: IF INV_GMI_RSV_BRANCH.Is_Org_Process_Org(p_key2) THEN
819: G_ITEM_TBL(p_key1).process_warehouse_flag := 'Y';

Line 824: oe_debug_pub.add( 'OPM IN OE_ORDER_CACHE.LOAD_ITEM PROCESS WAREHOUSE FLAG IS ' || G_ITEM_TBL ( P_KEY1 ) .PROCESS_WAREHOUSE_FLAG ) ;

820: ELSE
821: G_ITEM_TBL(p_key1).process_warehouse_flag := NULL;
822: END IF;
823: IF l_debug_level > 0 THEN
824: oe_debug_pub.add( 'OPM IN OE_ORDER_CACHE.LOAD_ITEM PROCESS WAREHOUSE FLAG IS ' || G_ITEM_TBL ( P_KEY1 ) .PROCESS_WAREHOUSE_FLAG ) ;
825: END IF;
826: IF l_debug_level > 0 THEN
827: oe_debug_pub.add( 'pal3 ' , 3 ) ;
828: END IF;

Line 827: oe_debug_pub.add( 'pal3 ' , 3 ) ;

823: IF l_debug_level > 0 THEN
824: oe_debug_pub.add( 'OPM IN OE_ORDER_CACHE.LOAD_ITEM PROCESS WAREHOUSE FLAG IS ' || G_ITEM_TBL ( P_KEY1 ) .PROCESS_WAREHOUSE_FLAG ) ;
825: END IF;
826: IF l_debug_level > 0 THEN
827: oe_debug_pub.add( 'pal3 ' , 3 ) ;
828: END IF;
829:
830:
831: END IF; -- if item tbl.org_id <> p_key2

Line 842: oe_debug_pub.add( 'NO DATA FOUND IN LOAD ITEM' ) ;

838:
839: EXCEPTION
840: WHEN NO_DATA_FOUND THEN
841: IF l_debug_level > 0 THEN
842: oe_debug_pub.add( 'NO DATA FOUND IN LOAD ITEM' ) ;
843: END IF;
844: IF G_ITEM_TBL.EXISTS(p_key1) THEN
845: IF l_debug_level > 0 THEN
846: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

Line 846: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

842: oe_debug_pub.add( 'NO DATA FOUND IN LOAD ITEM' ) ;
843: END IF;
844: IF G_ITEM_TBL.EXISTS(p_key1) THEN
845: IF l_debug_level > 0 THEN
846: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
847: END IF;
848: G_ITEM_TBL.DELETE(p_key1);
849: END IF;
850:

Line 862: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

858: WHEN OTHERS THEN
859:
860: IF G_ITEM_TBL.EXISTS(p_key1) THEN
861: IF l_debug_level > 0 THEN
862: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
863: END IF;
864: G_ITEM_TBL.DELETE(p_key1);
865: END IF;
866: OE_BULK_MSG_PUB.Add_Exc_Msg

Line 873: oe_debug_pub.add( 'pal4 ' , 3 ) ;

869: );
870: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
871:
872: IF l_debug_level > 0 THEN
873: oe_debug_pub.add( 'pal4 ' , 3 ) ;
874: END IF;
875: END Load_Item;
876:
877:

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

887: l_region2 VARCHAR2(3200) := NULL;
888: l_region3 VARCHAR2(3200) := NULL;
889: l_return_status VARCHAR2(30);
890: --
891: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
892: --
893: BEGIN
894:
895: IF G_SHIP_TO_TBL.EXISTS(p_key)

Line 926: oe_debug_pub.add( 'SHIP TO :'||P_KEY ) ;

922:
923: ELSIF p_default_attributes = 'Y' THEN
924:
925: IF l_debug_level > 0 THEN
926: oe_debug_pub.add( 'SHIP TO :'||P_KEY ) ;
927: END IF;
928: SELECT /* MOAC_SQL_CHANGE */ s.site_use_id
929: ,a.cust_account_id
930: ,s.warehouse_id

Line 1041: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

1037: EXCEPTION
1038: WHEN NO_DATA_FOUND THEN
1039: IF G_SHIP_TO_TBL.EXISTS(p_key) THEN
1040: IF l_debug_level > 0 THEN
1041: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
1042: END IF;
1043: G_SHIP_TO_TBL.DELETE(p_key);
1044: END IF;
1045: IF l_debug_level > 0 THEN

Line 1046: oe_debug_pub.add( 'NO DATA FOUND IN LOAD SHIP TO' ) ;

1042: END IF;
1043: G_SHIP_TO_TBL.DELETE(p_key);
1044: END IF;
1045: IF l_debug_level > 0 THEN
1046: oe_debug_pub.add( 'NO DATA FOUND IN LOAD SHIP TO' ) ;
1047: END IF;
1048: RAISE NO_DATA_FOUND;
1049: WHEN OTHERS THEN
1050: IF G_SHIP_TO_TBL.EXISTS(p_key) THEN

Line 1052: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

1048: RAISE NO_DATA_FOUND;
1049: WHEN OTHERS THEN
1050: IF G_SHIP_TO_TBL.EXISTS(p_key) THEN
1051: IF l_debug_level > 0 THEN
1052: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
1053: END IF;
1054: G_SHIP_TO_TBL.DELETE(p_key);
1055: END IF;
1056: OE_BULK_MSG_PUB.Add_Exc_Msg

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

1072: l_msg_count NUMBER;
1073: l_msg_data VARCHAR2(2000);
1074: l_org_id NUMBER;
1075: --
1076: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1077: --
1078: BEGIN
1079:
1080: IF G_SOLD_TO_TBL.EXISTS(p_key)

Line 1129: oe_debug_pub.add( 'AFTER CALL TO THE EDI API , RET STATUS: ' ||L_TP_RET_STATUS ) ;

1125: ,p_msg_count => l_msg_count
1126: ,p_msg_data => l_msg_data);
1127:
1128: IF l_debug_level > 0 THEN
1129: oe_debug_pub.add( 'AFTER CALL TO THE EDI API , RET STATUS: ' ||L_TP_RET_STATUS ) ;
1130: END IF;
1131:
1132: IF l_tp_ret = FALSE then
1133: IF l_debug_level > 0 THEN

Line 1134: oe_debug_pub.add( 'TP SETUP FALSE FOR :'||P_KEY ) ;

1130: END IF;
1131:
1132: IF l_tp_ret = FALSE then
1133: IF l_debug_level > 0 THEN
1134: oe_debug_pub.add( 'TP SETUP FALSE FOR :'||P_KEY ) ;
1135: END IF;
1136: G_SOLD_TO_TBL(p_key).tp_setup := FALSE;
1137: ELSE
1138: IF l_debug_level > 0 THEN

Line 1139: oe_debug_pub.add( 'TP SETUP TRUE FOR :'||P_KEY ) ;

1135: END IF;
1136: G_SOLD_TO_TBL(p_key).tp_setup := FALSE;
1137: ELSE
1138: IF l_debug_level > 0 THEN
1139: oe_debug_pub.add( 'TP SETUP TRUE FOR :'||P_KEY ) ;
1140: END IF;
1141: G_SOLD_TO_TBL(p_key).tp_setup := TRUE;
1142: END IF;
1143:

Line 1158: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

1154: EXCEPTION
1155: WHEN NO_DATA_FOUND THEN
1156: IF G_SOLD_TO_TBL.EXISTS(p_key) THEN
1157: IF l_debug_level > 0 THEN
1158: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
1159: END IF;
1160: G_SOLD_TO_TBL.DELETE(p_key);
1161: END IF;
1162: RAISE NO_DATA_FOUND;

Line 1166: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

1162: RAISE NO_DATA_FOUND;
1163: WHEN OTHERS THEN
1164: IF G_SOLD_TO_TBL.EXISTS(p_key) THEN
1165: IF l_debug_level > 0 THEN
1166: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
1167: END IF;
1168: G_SOLD_TO_TBL.DELETE(p_key);
1169: END IF;
1170: OE_BULK_MSG_PUB.Add_Exc_Msg

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

1186: l_tp_ret_status VARCHAR2(30);
1187: l_msg_count NUMBER;
1188: l_msg_data VARCHAR2(2000);
1189: --
1190: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1191: --
1192: Cursor End_Customer_site(p_site_use_code VARCHAR,p_key NUMBER) IS
1193: SELECT a.cust_acct_site_id
1194: FROM hz_cust_site_uses_all b, hz_cust_acct_sites_all a

Line 1224: oe_debug_pub.add('found sold to site use id');

1220: FETCH End_customer_site
1221: INTO G_END_CUSTOMER_TBL(p_key).address_id;
1222: IF End_customer_site%FOUND then
1223: CLOSE End_customer_site;
1224: oe_debug_pub.add('found sold to site use id');
1225: goto site_found;
1226: ELSE
1227: CLOSE End_customer_site;
1228: END IF;

Line 1235: oe_debug_pub.add('found sold to site use id');

1231: FETCH End_customer_site
1232: INTO G_END_CUSTOMER_TBL(p_key).address_id;
1233: IF End_customer_site%FOUND then
1234: CLOSE End_customer_site;
1235: oe_debug_pub.add('found sold to site use id');
1236: goto site_found;
1237: ELSE
1238: CLOSE End_customer_site;
1239: END IF;

Line 1246: oe_debug_pub.add('found sold to site use id');

1242: FETCH End_customer_site
1243: INTO G_END_CUSTOMER_TBL(p_key).address_id;
1244: IF End_customer_site%FOUND then
1245: CLOSE End_customer_site;
1246: oe_debug_pub.add('found sold to site use id');
1247: goto site_found;
1248: ELSE
1249: CLOSE End_customer_site;
1250: END IF;

Line 1257: oe_debug_pub.add('found sold to site use id');

1253: FETCH End_customer_site
1254: INTO G_END_CUSTOMER_TBL(p_key).address_id;
1255: IF End_customer_site%FOUND then
1256: CLOSE End_customer_site;
1257: oe_debug_pub.add('found sold to site use id');
1258: goto site_found;
1259: ELSE
1260: CLOSE End_customer_site;
1261: END IF;

Line 1280: oe_debug_pub.add( 'AFTER CALL TO THE EDI API , RET STATUS: ' ||L_TP_RET_STATUS ) ;

1276: ,p_msg_count => l_msg_count
1277: ,p_msg_data => l_msg_data);
1278:
1279: IF l_debug_level > 0 THEN
1280: oe_debug_pub.add( 'AFTER CALL TO THE EDI API , RET STATUS: ' ||L_TP_RET_STATUS ) ;
1281: END IF;
1282:
1283: IF l_tp_ret = FALSE then
1284: IF l_debug_level > 0 THEN

Line 1285: oe_debug_pub.add( 'TP SETUP FALSE FOR :'||P_KEY ) ;

1281: END IF;
1282:
1283: IF l_tp_ret = FALSE then
1284: IF l_debug_level > 0 THEN
1285: oe_debug_pub.add( 'TP SETUP FALSE FOR :'||P_KEY ) ;
1286: END IF;
1287: G_END_CUSTOMER_TBL(p_key).tp_setup := FALSE;
1288: ELSE
1289: IF l_debug_level > 0 THEN

Line 1290: oe_debug_pub.add( 'TP SETUP TRUE FOR :'||P_KEY ) ;

1286: END IF;
1287: G_END_CUSTOMER_TBL(p_key).tp_setup := FALSE;
1288: ELSE
1289: IF l_debug_level > 0 THEN
1290: oe_debug_pub.add( 'TP SETUP TRUE FOR :'||P_KEY ) ;
1291: END IF;
1292: G_END_CUSTOMER_TBL(p_key).tp_setup := TRUE;
1293: END IF;
1294:

Line 1303: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

1299: EXCEPTION
1300: WHEN NO_DATA_FOUND THEN
1301: IF G_END_CUSTOMER_TBL.EXISTS(p_key) THEN
1302: IF l_debug_level > 0 THEN
1303: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
1304: END IF;
1305: G_END_CUSTOMER_TBL.DELETE(p_key);
1306: END IF;
1307: RAISE NO_DATA_FOUND;

Line 1311: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

1307: RAISE NO_DATA_FOUND;
1308: WHEN OTHERS THEN
1309: IF G_END_CUSTOMER_TBL.EXISTS(p_key) THEN
1310: IF l_debug_level > 0 THEN
1311: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
1312: END IF;
1313: G_END_CUSTOMER_TBL.DELETE(p_key);
1314: END IF;
1315: OE_BULK_MSG_PUB.Add_Exc_Msg

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

1333: l_region2 VARCHAR2(3200) := NULL;
1334: l_region3 VARCHAR2(3200) := NULL;
1335: l_return_status VARCHAR2(30);
1336: --
1337: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1338: --
1339: Cursor End_customer_site_use (p_site_use_code varchar2) IS
1340: SELECT s.site_use_id
1341: ,a.cust_account_id

Line 1360: oe_debug_pub.add('Entering Load_End_Customer_Site');

1356: WHERE a.cust_acct_site_id = b.cust_acct_site_id
1357: AND b.site_use_id = p_key
1358: AND b.site_use_code=p_site_use_code;
1359: BEGIN
1360: oe_debug_pub.add('Entering Load_End_Customer_Site');
1361: IF G_END_CUSTOMER_SITE_TBL.EXISTS(p_key)
1362: AND ( p_default_attributes = 'N'
1363: OR (p_default_attributes = 'Y'
1364: AND G_END_CUSTOMER_SITE_TBL(p_key).default_attributes = 'Y'))

Line 1379: oe_debug_pub.add('found sold to site use id');

1375: INTO G_END_CUSTOMER_SITE_TBL(p_key).sold_to_site_use_id,
1376: G_END_CUSTOMER_SITE_TBL(p_key).customer_id;
1377: IF End_customer_site_use%FOUND then
1378: CLOSE End_customer_site_use ;
1379: oe_debug_pub.add('found sold to site use id');
1380: goto site_found;
1381: ELSE
1382: CLOSE End_customer_site_use;
1383: END IF;

Line 1390: oe_debug_pub.add('found ship to site use id');

1386: INTO G_END_CUSTOMER_SITE_TBL(p_key).sold_to_site_use_id,
1387: G_END_CUSTOMER_SITE_TBL(p_key).customer_id;
1388: IF End_customer_site_use%FOUND then
1389: CLOSE End_customer_site_use ;
1390: oe_debug_pub.add('found ship to site use id');
1391: goto site_found;
1392: ELSE
1393: CLOSE End_customer_site_use;
1394: END IF;

Line 1401: oe_debug_pub.add('found bill to site use id');

1397: INTO G_END_CUSTOMER_SITE_TBL(p_key).sold_to_site_use_id,
1398: G_END_CUSTOMER_SITE_TBL(p_key).customer_id;
1399: IF End_customer_site_use%FOUND then
1400: CLOSE End_customer_site_use ;
1401: oe_debug_pub.add('found bill to site use id');
1402: goto site_found;
1403: ELSE
1404: CLOSE End_customer_site_use;
1405: END IF;

Line 1412: oe_debug_pub.add('found deliver to site use id');

1408: INTO G_END_CUSTOMER_SITE_TBL(p_key).sold_to_site_use_id,
1409: G_END_CUSTOMER_SITE_TBL(p_key).customer_id;
1410: IF End_customer_site_use%FOUND then
1411: CLOSE End_customer_site_use ;
1412: oe_debug_pub.add('found deliver to site use id');
1413: goto site_found;
1414: ELSE
1415: CLOSE End_customer_site_use;
1416: END IF;

Line 1432: oe_debug_pub.add('found sold to site use id');

1428: ,G_SOLD_TO_SITE_TBL(p_key).location;
1429:
1430: IF End_customer_address%FOUND then
1431: CLOSE End_customer_address;
1432: oe_debug_pub.add('found sold to site use id');
1433: goto address_found;
1434: ELSE
1435: CLOSE End_customer_address;
1436: END IF;

Line 1446: oe_debug_pub.add('found ship to site use id');

1442: ,G_SOLD_TO_SITE_TBL(p_key).location;
1443:
1444: IF End_customer_address%FOUND then
1445: CLOSE End_customer_address;
1446: oe_debug_pub.add('found ship to site use id');
1447: goto address_found;
1448: ELSE
1449: CLOSE End_customer_address;
1450: END IF;

Line 1460: oe_debug_pub.add('found bill to site use id');

1456: ,G_SOLD_TO_SITE_TBL(p_key).location;
1457:
1458: IF End_customer_address%FOUND then
1459: CLOSE End_customer_address;
1460: oe_debug_pub.add('found bill to site use id');
1461: goto address_found;
1462: ELSE
1463: CLOSE End_customer_address;
1464: END IF;

Line 1474: oe_debug_pub.add('found deliver to site use id');

1470: ,G_SOLD_TO_SITE_TBL(p_key).location;
1471:
1472: IF End_customer_address%FOUND then
1473: CLOSE End_customer_address;
1474: oe_debug_pub.add('found deliver to site use id');
1475: goto address_found;
1476: ELSE
1477: CLOSE End_customer_address;
1478: END IF;

Line 1520: oe_debug_pub.add( 'NO DATA FOUND IN LOAD SOLD_TO_SITE:'||TO_CHAR ( P_KEY ) ) ;

1516:
1517: EXCEPTION
1518: WHEN NO_DATA_FOUND THEN
1519: IF l_debug_level > 0 THEN
1520: oe_debug_pub.add( 'NO DATA FOUND IN LOAD SOLD_TO_SITE:'||TO_CHAR ( P_KEY ) ) ;
1521: END IF;
1522: IF G_SOLD_TO_SITE_TBL.EXISTS(p_key) THEN
1523: IF l_debug_level > 0 THEN
1524: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

Line 1524: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

1520: oe_debug_pub.add( 'NO DATA FOUND IN LOAD SOLD_TO_SITE:'||TO_CHAR ( P_KEY ) ) ;
1521: END IF;
1522: IF G_SOLD_TO_SITE_TBL.EXISTS(p_key) THEN
1523: IF l_debug_level > 0 THEN
1524: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
1525: END IF;
1526: G_SOLD_TO_SITE_TBL.DELETE(p_key);
1527: END IF;
1528: RAISE NO_DATA_FOUND;

Line 1532: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

1528: RAISE NO_DATA_FOUND;
1529: WHEN OTHERS THEN
1530: IF G_SOLD_TO_SITE_TBL.EXISTS(p_key) THEN
1531: IF l_debug_level > 0 THEN
1532: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
1533: END IF;
1534: G_SOLD_TO_SITE_TBL.DELETE(p_key);
1535: END IF;
1536: OE_BULK_MSG_PUB.Add_Exc_Msg

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

1554: l_region2 VARCHAR2(3200) := NULL;
1555: l_region3 VARCHAR2(3200) := NULL;
1556: l_return_status VARCHAR2(30);
1557: --
1558: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1559: --
1560: BEGIN
1561:
1562: IF G_INVOICE_TO_TBL.EXISTS(p_key)

Line 1670: oe_debug_pub.add( 'NO DATA FOUND IN LOAD INVOICE TO :'||TO_CHAR ( P_KEY ) ) ;

1666:
1667: EXCEPTION
1668: WHEN NO_DATA_FOUND THEN
1669: IF l_debug_level > 0 THEN
1670: oe_debug_pub.add( 'NO DATA FOUND IN LOAD INVOICE TO :'||TO_CHAR ( P_KEY ) ) ;
1671: END IF;
1672: IF G_INVOICE_TO_TBL.EXISTS(p_key) THEN
1673: IF l_debug_level > 0 THEN
1674: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

Line 1674: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

1670: oe_debug_pub.add( 'NO DATA FOUND IN LOAD INVOICE TO :'||TO_CHAR ( P_KEY ) ) ;
1671: END IF;
1672: IF G_INVOICE_TO_TBL.EXISTS(p_key) THEN
1673: IF l_debug_level > 0 THEN
1674: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
1675: END IF;
1676: G_INVOICE_TO_TBL.DELETE(p_key);
1677: END IF;
1678: RAISE NO_DATA_FOUND;

Line 1682: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

1678: RAISE NO_DATA_FOUND;
1679: WHEN OTHERS THEN
1680: IF G_INVOICE_TO_TBL.EXISTS(p_key) THEN
1681: IF l_debug_level > 0 THEN
1682: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
1683: END IF;
1684: G_INVOICE_TO_TBL.DELETE(p_key);
1685: END IF;
1686: OE_BULK_MSG_PUB.Add_Exc_Msg

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

1702: l_region2 VARCHAR2(3200) := NULL;
1703: l_region3 VARCHAR2(3200) := NULL;
1704: l_return_status VARCHAR2(30);
1705: --
1706: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1707: --
1708: BEGIN
1709:
1710: IF G_SOLD_TO_SITE_TBL.EXISTS(p_key)

Line 1818: oe_debug_pub.add( 'NO DATA FOUND IN LOAD SOLD_TO_SITE:'||TO_CHAR ( P_KEY ) ) ;

1814:
1815: EXCEPTION
1816: WHEN NO_DATA_FOUND THEN
1817: IF l_debug_level > 0 THEN
1818: oe_debug_pub.add( 'NO DATA FOUND IN LOAD SOLD_TO_SITE:'||TO_CHAR ( P_KEY ) ) ;
1819: END IF;
1820: IF G_SOLD_TO_SITE_TBL.EXISTS(p_key) THEN
1821: IF l_debug_level > 0 THEN
1822: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

Line 1822: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

1818: oe_debug_pub.add( 'NO DATA FOUND IN LOAD SOLD_TO_SITE:'||TO_CHAR ( P_KEY ) ) ;
1819: END IF;
1820: IF G_SOLD_TO_SITE_TBL.EXISTS(p_key) THEN
1821: IF l_debug_level > 0 THEN
1822: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
1823: END IF;
1824: G_SOLD_TO_SITE_TBL.DELETE(p_key);
1825: END IF;
1826: RAISE NO_DATA_FOUND;

Line 1830: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

1826: RAISE NO_DATA_FOUND;
1827: WHEN OTHERS THEN
1828: IF G_SOLD_TO_SITE_TBL.EXISTS(p_key) THEN
1829: IF l_debug_level > 0 THEN
1830: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
1831: END IF;
1832: G_SOLD_TO_SITE_TBL.DELETE(p_key);
1833: END IF;
1834: OE_BULK_MSG_PUB.Add_Exc_Msg

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

1843: )
1844: RETURN NUMBER
1845: IS
1846: --
1847: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1848: --
1849: BEGIN
1850:
1851: IF G_SALESREP_TBL.EXISTS(p_key)

Line 1877: oe_debug_pub.add( 'NO DATA FOUND IN LOAD SALESREP :'||TO_CHAR ( P_KEY ) ) ;

1873:
1874: EXCEPTION
1875: WHEN NO_DATA_FOUND THEN
1876: IF l_debug_level > 0 THEN
1877: oe_debug_pub.add( 'NO DATA FOUND IN LOAD SALESREP :'||TO_CHAR ( P_KEY ) ) ;
1878: END IF;
1879: IF G_SALESREP_TBL.EXISTS(p_key) THEN
1880: IF l_debug_level > 0 THEN
1881: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

Line 1881: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

1877: oe_debug_pub.add( 'NO DATA FOUND IN LOAD SALESREP :'||TO_CHAR ( P_KEY ) ) ;
1878: END IF;
1879: IF G_SALESREP_TBL.EXISTS(p_key) THEN
1880: IF l_debug_level > 0 THEN
1881: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
1882: END IF;
1883: G_SALESREP_TBL.DELETE(p_key);
1884: END IF;
1885: RAISE NO_DATA_FOUND;

Line 1889: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

1885: RAISE NO_DATA_FOUND;
1886: WHEN OTHERS THEN
1887: IF G_SALESREP_TBL.EXISTS(p_key) THEN
1888: IF l_debug_level > 0 THEN
1889: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
1890: END IF;
1891: G_SALESREP_TBL.DELETE(p_key);
1892: END IF;
1893: OE_BULK_MSG_PUB.Add_Exc_Msg

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

1920: l_region2 VARCHAR2(3200) := NULL;
1921: l_region3 VARCHAR2(3200) := NULL;
1922: l_return_status VARCHAR2(30);
1923: --
1924: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1925: --
1926: BEGIN
1927:
1928: -- Initially, ship from cache is only for EDI attributes therefore

Line 1952: oe_debug_pub.add( 'UNABLE TO DERIVE SHIP FROM ADDR' ||' KEY :'||P_KEY ) ;

1948: EXCEPTION
1949: WHEN OTHERS THEN
1950: NULL;
1951: IF l_debug_level > 0 THEN
1952: oe_debug_pub.add( 'UNABLE TO DERIVE SHIP FROM ADDR' ||' KEY :'||P_KEY ) ;
1953: END IF;
1954: END;
1955:
1956: Get_Address(

Line 2000: oe_debug_pub.add( 'NO DATA FOUND IN LOAD SHIP FROM :'||TO_CHAR ( P_KEY ) ) ;

1996:
1997: EXCEPTION
1998: WHEN NO_DATA_FOUND THEN
1999: IF l_debug_level > 0 THEN
2000: oe_debug_pub.add( 'NO DATA FOUND IN LOAD SHIP FROM :'||TO_CHAR ( P_KEY ) ) ;
2001: END IF;
2002: IF G_SHIP_FROM_TBL.EXISTS(p_key) THEN
2003: IF l_debug_level > 0 THEN
2004: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

Line 2004: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

2000: oe_debug_pub.add( 'NO DATA FOUND IN LOAD SHIP FROM :'||TO_CHAR ( P_KEY ) ) ;
2001: END IF;
2002: IF G_SHIP_FROM_TBL.EXISTS(p_key) THEN
2003: IF l_debug_level > 0 THEN
2004: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
2005: END IF;
2006: G_SHIP_FROM_TBL.DELETE(p_key);
2007: END IF;
2008: RAISE NO_DATA_FOUND;

Line 2012: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

2008: RAISE NO_DATA_FOUND;
2009: WHEN OTHERS THEN
2010: IF G_SHIP_FROM_TBL.EXISTS(p_key) THEN
2011: IF l_debug_level > 0 THEN
2012: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
2013: END IF;
2014: G_SHIP_FROM_TBL.DELETE(p_key);
2015: END IF;
2016: OE_BULK_MSG_PUB.Add_Exc_Msg

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

2025: )
2026: RETURN NUMBER
2027: IS
2028: --
2029: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2030: --
2031: BEGIN
2032:
2033: IF G_PRICE_LIST_TBL.EXISTS(p_key)

Line 2061: oe_debug_pub.add( 'NO DATA FOUND IN LOAD PRICE LIST :'||TO_CHAR ( P_KEY ) ) ;

2057:
2058: EXCEPTION
2059: WHEN NO_DATA_FOUND THEN
2060: IF l_debug_level > 0 THEN
2061: oe_debug_pub.add( 'NO DATA FOUND IN LOAD PRICE LIST :'||TO_CHAR ( P_KEY ) ) ;
2062: END IF;
2063: IF G_PRICE_LIST_TBL.EXISTS(p_key) THEN
2064: IF l_debug_level > 0 THEN
2065: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

Line 2065: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

2061: oe_debug_pub.add( 'NO DATA FOUND IN LOAD PRICE LIST :'||TO_CHAR ( P_KEY ) ) ;
2062: END IF;
2063: IF G_PRICE_LIST_TBL.EXISTS(p_key) THEN
2064: IF l_debug_level > 0 THEN
2065: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
2066: END IF;
2067: G_PRICE_LIST_TBL.DELETE(p_key);
2068: END IF;
2069: RAISE NO_DATA_FOUND;

Line 2073: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

2069: RAISE NO_DATA_FOUND;
2070: WHEN OTHERS THEN
2071: IF G_PRICE_LIST_TBL.EXISTS(p_key) THEN
2072: IF l_debug_level > 0 THEN
2073: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
2074: END IF;
2075: G_PRICE_LIST_TBL.DELETE(p_key);
2076: END IF;
2077: OE_BULK_MSG_PUB.Add_Exc_Msg

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

2103: RETURN NUMBER
2104: IS
2105: --
2106: l_org_id NUMBER;
2107: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2108: --
2109: BEGIN
2110:
2111: IF G_LOC_INFO_TBL.EXISTS(p_key)

Line 2177: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

2173: EXCEPTION
2174: WHEN NO_DATA_FOUND THEN
2175: IF G_LOC_INFO_TBL.EXISTS(p_key) THEN
2176: IF l_debug_level > 0 THEN
2177: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
2178: END IF;
2179: G_LOC_INFO_TBL.DELETE(p_key);
2180: END IF;
2181: RAISE NO_DATA_FOUND;

Line 2185: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

2181: RAISE NO_DATA_FOUND;
2182: WHEN OTHERS THEN
2183: IF G_LOC_INFO_TBL.EXISTS(p_key) THEN
2184: IF l_debug_level > 0 THEN
2185: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
2186: END IF;
2187: G_LOC_INFO_TBL.DELETE(p_key);
2188: END IF;
2189: OE_BULK_MSG_PUB.Add_Exc_Msg

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

2199: )
2200: RETURN NUMBER
2201: IS
2202: --
2203: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2204: --
2205: BEGIN
2206:
2207: SELECT V.AMOUNT_INCLUDES_TAX_FLAG,

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

2231: )
2232: RETURN NUMBER
2233: IS
2234: --
2235: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2236: --
2237: BEGIN
2238:
2239: IF G_PERSON_TBL.EXISTS(p_key)

Line 2274: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

2270: EXCEPTION
2271: WHEN NO_DATA_FOUND THEN
2272: IF G_PERSON_TBL.EXISTS(p_key) THEN
2273: IF l_debug_level > 0 THEN
2274: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
2275: END IF;
2276: G_PERSON_TBL.DELETE(p_key);
2277: END IF;
2278: RAISE NO_DATA_FOUND;

Line 2282: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;

2278: RAISE NO_DATA_FOUND;
2279: WHEN OTHERS THEN
2280: IF G_PERSON_TBL.EXISTS(p_key) THEN
2281: IF l_debug_level > 0 THEN
2282: oe_debug_pub.add( 'DELETE INVALID RECORD' ) ;
2283: END IF;
2284: G_PERSON_TBL.DELETE(p_key);
2285: END IF;
2286: OE_BULK_MSG_PUB.Add_Exc_Msg