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

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

12: ( p_header_id number
13: , p_Line_Type_id Number
14: )
15: IS
16: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
17: BEGIN
18:
19: if l_debug_level > 0 then
20: oe_debug_pub.add('Entering OE_ORDER_CACHE.Enforce_List_price', 1);

Line 20: oe_debug_pub.add('Entering OE_ORDER_CACHE.Enforce_List_price', 1);

16: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
17: BEGIN
18:
19: if l_debug_level > 0 then
20: oe_debug_pub.add('Entering OE_ORDER_CACHE.Enforce_List_price', 1);
21: end if;
22:
23: IF p_Line_Type_id IS NOT NULL THEN
24:

Line 63: oe_debug_pub.add('Exiting OE_ORDER_CACHE.Enforce_List_price', 1);

59:
60: END IF;
61:
62: if l_debug_level > 0 then
63: oe_debug_pub.add('Exiting OE_ORDER_CACHE.Enforce_List_price', 1);
64: end if;
65:
66: EXCEPTION
67:

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

94:
95: PROCEDURE Load_Order_Type
96: ( p_key IN NUMBER )
97: IS
98: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
99: BEGIN
100:
101: if l_debug_level > 0 then
102: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_ORDER_TYPE', 1);

Line 102: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_ORDER_TYPE', 1);

98: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
99: BEGIN
100:
101: if l_debug_level > 0 then
102: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_ORDER_TYPE', 1);
103: end if;
104:
105: IF p_key IS NOT NULL THEN
106:

Line 110: oe_debug_pub.add('Loading order Type');

106:
107: IF g_order_type_rec.order_type_id = FND_API.G_MISS_NUM OR
108: g_order_type_rec.order_type_id <> p_key THEN
109:
110: oe_debug_pub.add('Loading order Type');
111: SELECT ORDER_TYPE_ID
112: , NAME
113: , INVOICING_RULE_ID
114: , ACCOUNTING_RULE_ID

Line 167: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_ORDER_TYPE', 1);

163:
164: END IF;
165:
166: if l_debug_level > 0 then
167: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_ORDER_TYPE', 1);
168: end if;
169:
170: EXCEPTION
171:

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

206: PROCEDURE Load_Line_Type
207: ( p_key IN NUMBER )
208: IS
209: l_calculate_tax_flag varchar2(1) := NULL;
210: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
211: BEGIN
212:
213: if l_debug_level > 0 then
214: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_LINE_TYPE', 1);

Line 214: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_LINE_TYPE', 1);

210: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
211: BEGIN
212:
213: if l_debug_level > 0 then
214: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_LINE_TYPE', 1);
215: end if;
216:
217: IF p_key IS NOT NULL THEN
218:

Line 220: oe_debug_pub.add('p_key is not null', 1);

216:
217: IF p_key IS NOT NULL THEN
218:
219: if l_debug_level > 0 then
220: oe_debug_pub.add('p_key is not null', 1);
221: end if;
222: IF g_line_type_rec.line_type_id = FND_API.G_MISS_NUM OR
223: g_line_type_rec.line_type_id <> p_key THEN
224:

Line 226: oe_debug_pub.add('before selecting line_type info : ' || g_line_type_rec.calculate_tax_flag, 1);

222: IF g_line_type_rec.line_type_id = FND_API.G_MISS_NUM OR
223: g_line_type_rec.line_type_id <> p_key THEN
224:
225: if l_debug_level > 0 then
226: oe_debug_pub.add('before selecting line_type info : ' || g_line_type_rec.calculate_tax_flag, 1);
227: end if;
228: SELECT LINE_TYPE_ID
229: , NAME
230: , CUST_TRX_TYPE_ID

Line 276: oe_debug_pub.add('after selecting line_type info : ' || g_line_type_rec.calculate_tax_flag, 1);

272: FROM OE_LINE_TYPES_V
273: WHERE LINE_TYPE_ID = p_key;
274:
275: if l_debug_level > 0 then
276: oe_debug_pub.add('after selecting line_type info : ' || g_line_type_rec.calculate_tax_flag, 1);
277: end if;
278: IF g_line_type_rec.cust_trx_type_id IS NOT NULL
279: THEN
280:

Line 287: oe_debug_pub.add('after selecting tax_flag info : ' || l_calculate_tax_flag, 1);

283: FROM RA_CUST_TRX_TYPES
284: WHERE CUST_TRX_TYPE_ID = g_line_type_rec.cust_trx_type_id;
285:
286: if l_debug_level > 0 then
287: oe_debug_pub.add('after selecting tax_flag info : ' || l_calculate_tax_flag, 1);
288: end if;
289: END IF;
290:
291: g_line_type_rec.calculate_tax_flag := l_calculate_tax_flag;

Line 294: oe_debug_pub.add('tax_flag : ' || g_line_type_rec.calculate_tax_flag, 1);

290:
291: g_line_type_rec.calculate_tax_flag := l_calculate_tax_flag;
292:
293: if l_debug_level > 0 then
294: oe_debug_pub.add('tax_flag : ' || g_line_type_rec.calculate_tax_flag, 1);
295: end if;
296:
297: END IF;
298:

Line 302: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_LINE_TYPE', 1);

298:
299: END IF;
300:
301: if l_debug_level > 0 then
302: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_LINE_TYPE', 1);
303: end if;
304:
305: EXCEPTION
306:

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

325: FUNCTION Load_Agreement
326: ( p_key IN NUMBER )
327: RETURN Agreement_Rec_Type
328: IS
329: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
330: BEGIN
331:
332: if l_debug_level > 0 then
333: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_AGREEMENT', 1);

Line 333: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_AGREEMENT', 1);

329: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
330: BEGIN
331:
332: if l_debug_level > 0 then
333: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_AGREEMENT', 1);
334: end if;
335:
336: IF p_key IS NOT NULL THEN
337:

Line 370: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_AGREEMENT', 1);

366:
367: END IF;
368:
369: if l_debug_level > 0 then
370: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_AGREEMENT', 1);
371: end if;
372:
373: RETURN g_agreement_rec;
374:

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

392: ( p_key IN NUMBER )
393: RETURN Ship_To_Org_Rec_Type
394: IS
395: l_bill_to_site_use_id NUMBER := NULL;
396: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
397: BEGIN
398:
399: if l_debug_level > 0 then
400: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_SHIP_TO_ORG', 1);

Line 400: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_SHIP_TO_ORG', 1);

396: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
397: BEGIN
398:
399: if l_debug_level > 0 then
400: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_SHIP_TO_ORG', 1);
401: end if;
402:
403: IF p_key IS NOT NULL THEN
404:

Line 500: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_SHIP_TO_ORG', 1);

496:
497: END IF;
498:
499: if l_debug_level > 0 then
500: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_SHIP_TO_ORG', 1);
501: end if;
502:
503: RETURN g_ship_to_rec;
504:

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

525: FUNCTION Load_Invoice_To_Org
526: ( p_key IN NUMBER )
527: RETURN Invoice_to_Org_Rec_Type
528: IS
529: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
530: BEGIN
531:
532: if l_debug_level > 0 then
533: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_INVOICE_TO_ORG', 1);

Line 533: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_INVOICE_TO_ORG', 1);

529: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
530: BEGIN
531:
532: if l_debug_level > 0 then
533: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_INVOICE_TO_ORG', 1);
534: end if;
535:
536: IF p_key IS NOT NULL THEN
537:

Line 541: oe_debug_pub.add('Loading Invoice to Org Cache');

537:
538: IF g_invoice_to_rec.org_id = FND_API.G_MISS_NUM OR
539: g_invoice_to_rec.org_id <> p_key THEN
540:
541: oe_debug_pub.add('Loading Invoice to Org Cache');
542: SELECT ORGANIZATION_ID
543: , PRICE_LIST_ID
544: , FOB_POINT_CODE
545: , FREIGHT_TERMS_CODE

Line 604: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_INVOICE_TO_ORG', 1);

600:
601: END IF;
602:
603: if l_debug_level > 0 then
604: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_INVOICE_TO_ORG', 1);
605: end if;
606:
607: RETURN g_invoice_to_rec;
608:

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

634: ( p_key IN NUMBER )
635: RETURN Deliver_To_Org_Rec_Type
636: IS
637: l_bill_to_site_use_id NUMBER := NULL;
638: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
639: BEGIN
640:
641: if l_debug_level > 0 then
642: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_DELIVER_TO_ORG', 1);

Line 642: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_DELIVER_TO_ORG', 1);

638: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
639: BEGIN
640:
641: if l_debug_level > 0 then
642: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_DELIVER_TO_ORG', 1);
643: end if;
644:
645: IF p_key IS NOT NULL THEN
646:

Line 689: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_DELIVER_TO_ORG', 1);

685:
686: END IF;
687:
688: if l_debug_level > 0 then
689: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_DELIVER_TO_ORG', 1);
690: end if;
691:
692: RETURN g_deliver_to_rec;
693:

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

710: FUNCTION Load_Sold_To_Org
711: ( p_key IN NUMBER )
712: RETURN Sold_To_Org_Rec_Type
713: IS
714: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
715: l_current_org_id NUMBER ; -- MOAC Changes
716: BEGIN
717:
718: if l_debug_level > 0 then

Line 719: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_SOLD_TO_ORG', 1);

715: l_current_org_id NUMBER ; -- MOAC Changes
716: BEGIN
717:
718: if l_debug_level > 0 then
719: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_SOLD_TO_ORG', 1);
720: end if;
721: --MOAC Changes
722: --The Sold_To_Org_Cache was selecting oe_sold_to_orgs_v.organization_id into g_sold_to_rec.org_id.
723: --To have a code consistency added a new column "sold_to_org_id" in "Sold_To_Org_Rec_Type".

Line 901: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_SOLD_TO_ORG', 1);

897:
898: END IF;
899:
900: if l_debug_level > 0 then
901: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_SOLD_TO_ORG', 1);
902: end if;
903:
904: RETURN g_sold_to_rec;
905:

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

926: FUNCTION Load_Price_List
927: ( p_key IN NUMBER )
928: RETURN Price_List_Rec_Type
929: IS
930: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
931: BEGIN
932:
933: if l_debug_level > 0 then
934: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_PRICE_LIST', 1);

Line 934: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_PRICE_LIST', 1);

930: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
931: BEGIN
932:
933: if l_debug_level > 0 then
934: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_PRICE_LIST', 1);
935: end if;
936: IF p_key IS NOT NULL THEN
937:
938: IF g_price_list_rec.price_list_id = FND_API.G_MISS_NUM OR

Line 974: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_PRICE_LIST', 1);

970:
971: END IF;
972:
973: if l_debug_level > 0 then
974: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_PRICE_LIST', 1);
975: end if;
976:
977: RETURN g_price_list_rec;
978:

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

998: FUNCTION Load_Set_Of_Books
999: RETURN Set_Of_Books_Rec_Type
1000: IS
1001: l_set_of_books_id NUMBER := NULL;
1002: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1003: BEGIN
1004:
1005: if l_debug_level > 0 then
1006: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_SET_OF_BOOKS', 1);

Line 1006: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_SET_OF_BOOKS', 1);

1002: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1003: BEGIN
1004:
1005: if l_debug_level > 0 then
1006: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_SET_OF_BOOKS', 1);
1007: end if;
1008:
1009: -- Get set_of_books_id from profile option.
1010:

Line 1036: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_SET_OF_BOOKS', 1);

1032:
1033: END IF;
1034:
1035: if l_debug_level > 0 then
1036: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_SET_OF_BOOKS', 1);
1037: end if;
1038:
1039: RETURN g_set_of_books_rec;
1040:

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

1059: ( p_key1 IN NUMBER
1060: , p_key2 IN NUMBER )
1061: RETURN Item_Cost_Rec_Type
1062: IS
1063: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1064: BEGIN
1065:
1066: if l_debug_level > 0 then
1067: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_ITEM_COST', 1);

Line 1067: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_ITEM_COST', 1);

1063: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1064: BEGIN
1065:
1066: if l_debug_level > 0 then
1067: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_ITEM_COST', 1);
1068: end if;
1069:
1070: IF p_key1 IS NOT NULL THEN
1071:

Line 1098: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_ITEM_COST', 1);

1094:
1095: END IF;
1096:
1097: if l_debug_level > 0 then
1098: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_ITEM_COST', 1);
1099: end if;
1100:
1101: RETURN g_item_cost_rec;
1102:

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

1138:
1139: PROCEDURE Load_Order_Header
1140: ( p_key IN NUMBER )
1141: IS
1142: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1143: BEGIN
1144:
1145: if l_debug_level > 0 then
1146: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_ORDER_HEADER', 1);

Line 1146: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_ORDER_HEADER', 1);

1142: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1143: BEGIN
1144:
1145: if l_debug_level > 0 then
1146: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_ORDER_HEADER', 1);
1147: end if;
1148:
1149: IF p_key IS NOT NULL THEN
1150:

Line 1162: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_ORDER_HEADER', 1);

1158:
1159: END IF;
1160:
1161: if l_debug_level > 0 then
1162: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_ORDER_HEADER', 1);
1163: end if;
1164:
1165: --add bug 4200055
1166: EXCEPTION

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

1191: l_header_adj_rec OE_ORDER_PUB.header_adj_rec_type;
1192: l_discount_id NUMBER := p_hdr_adj_rec.discount_id;
1193: l_discount_line_id NUMBER := p_hdr_adj_rec.discount_line_id;
1194: l_adj_id NUMBER := p_hdr_adj_rec.price_adjustment_id;
1195: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1196: BEGIN
1197:
1198: if l_debug_level > 0 then
1199: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_HEADER_DISCOUNT', 1);

Line 1199: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_HEADER_DISCOUNT', 1);

1195: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1196: BEGIN
1197:
1198: if l_debug_level > 0 then
1199: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_HEADER_DISCOUNT', 1);
1200: end if;
1201:
1202: IF (l_adj_id IS NOT NULL) THEN
1203:

Line 1209: --oe_debug_pub.add('Load_header_discount. Discount_id = ' ||

1205: OR g_hdr_discount_rec.discount_id <> l_discount_id
1206: OR g_hdr_discount_rec.discount_line_id <> l_discount_line_id)
1207: THEN
1208:
1209: --oe_debug_pub.add('Load_header_discount. Discount_id = ' ||
1210: -- To_char(l_discount_id) ||
1211: -- ' discount_line_id = ' ||
1212: -- To_char(l_discount_line_id), 2);
1213:

Line 1261: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_HEADER_DISCOUNT', 1);

1257: l_header_adj_rec.discount_line_id := g_hdr_discount_rec.discount_line_id;
1258: END IF;
1259:
1260: if l_debug_level > 0 then
1261: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_HEADER_DISCOUNT', 1);
1262: end if;
1263:
1264: RETURN l_header_adj_rec;
1265:

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

1289: l_discount_id NUMBER := p_line_adj_rec.discount_id;
1290: l_discount_line_id NUMBER := p_line_adj_rec.discount_line_id;
1291: l_line_id NUMBER := p_line_adj_rec.line_id;
1292: l_adj_id NUMBER := p_line_adj_rec.price_adjustment_id;
1293: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1294: BEGIN
1295:
1296: if l_debug_level > 0 then
1297: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_LINE_DISCOUNT', 1);

Line 1297: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_LINE_DISCOUNT', 1);

1293: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1294: BEGIN
1295:
1296: if l_debug_level > 0 then
1297: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_LINE_DISCOUNT', 1);
1298: end if;
1299:
1300: IF (l_adj_id IS NOT NULL) THEN
1301:

Line 1307: -- oe_debug_pub.add('OEXUCCHB Before Load_line. Discount_id = ' ||

1303: OR g_line_discount_rec.discount_line_id <> l_discount_line_id
1304: OR g_line_discount_rec.discount_id <> l_discount_id)
1305: THEN
1306:
1307: -- oe_debug_pub.add('OEXUCCHB Before Load_line. Discount_id = ' ||
1308: -- To_char(l_discount_id) ||
1309: -- ' discount_line_id = ' ||
1310: -- To_char(l_discount_line_id) ||
1311: -- ' line_id = ' ||

Line 1376: -- oe_debug_pub.add('OEXUCCHB After load_line. Discount_id = ' ||

1372: l_line_adj_rec.discount_id := g_line_discount_rec.discount_id;
1373: l_line_adj_rec.discount_line_id := g_line_discount_rec.discount_line_id;
1374: l_line_adj_rec.percent := g_line_discount_rec.percent;
1375:
1376: -- oe_debug_pub.add('OEXUCCHB After load_line. Discount_id = ' ||
1377: -- To_char(l_line_adj_rec.discount_id) ||
1378: -- ' discount_line_id = ' ||
1379: -- To_char(l_discount_line_id) ||
1380: -- ' line_id = ' ||

Line 1388: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_LINE_DISCOUNT', 1);

1384:
1385: END IF;
1386:
1387: if l_debug_level > 0 then
1388: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_LINE_DISCOUNT', 1);
1389: end if;
1390: RETURN l_line_adj_rec;
1391:
1392: EXCEPTION

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

1423:
1424: PROCEDURE Load_Top_Model_Line
1425: ( p_key IN NUMBER )
1426: IS
1427: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1428: BEGIN
1429:
1430: if l_debug_level > 0 then
1431: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_TOP_MODEL_LINE', 1);

Line 1431: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_TOP_MODEL_LINE', 1);

1427: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1428: BEGIN
1429:
1430: if l_debug_level > 0 then
1431: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_TOP_MODEL_LINE', 1);
1432: end if;
1433: IF p_key IS NOT NULL THEN
1434:
1435: IF nvl(g_top_model_line_rec.line_id,0) <> p_key

Line 1438: oe_debug_pub.add('no cached model record', 3);

1434:
1435: IF nvl(g_top_model_line_rec.line_id,0) <> p_key
1436: THEN
1437: if l_debug_level > 0 then
1438: oe_debug_pub.add('no cached model record', 3);
1439: end if;
1440: OE_Line_Util.Query_Row(p_line_id => p_key,
1441: x_line_rec => g_top_model_line_rec);
1442: ELSE

Line 1444: oe_debug_pub.add('returning cached model record: '|| p_key, 3);

1440: OE_Line_Util.Query_Row(p_line_id => p_key,
1441: x_line_rec => g_top_model_line_rec);
1442: ELSE
1443: if l_debug_level > 0 then
1444: oe_debug_pub.add('returning cached model record: '|| p_key, 3);
1445: end if;
1446: END IF;
1447:
1448: if l_debug_level > 0 then

Line 1449: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_TOP_MODEL_LINE', 3);

1445: end if;
1446: END IF;
1447:
1448: if l_debug_level > 0 then
1449: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_TOP_MODEL_LINE', 3);
1450: end if;
1451:
1452: END IF;
1453:

Line 1455: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_TOP_MODEL_LINE', 1);

1451:
1452: END IF;
1453:
1454: if l_debug_level > 0 then
1455: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_TOP_MODEL_LINE', 1);
1456: end if;
1457:
1458: -- add bug 4200055
1459: EXCEPTION

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

1523: --INVCONV end
1524:
1525:
1526: l_inventory_changed VARCHAR2(1) := 'N';
1527: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1528: BEGIN
1529:
1530: if l_debug_level > 0 then
1531: oe_debug_pub.add('Entering OE_ORDER_CACHE.Load_Item'||p_key3, 1);

Line 1531: oe_debug_pub.add('Entering OE_ORDER_CACHE.Load_Item'||p_key3, 1);

1527: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1528: BEGIN
1529:
1530: if l_debug_level > 0 then
1531: oe_debug_pub.add('Entering OE_ORDER_CACHE.Load_Item'||p_key3, 1);
1532: end if;
1533:
1534: -- Always store validation_org in l_key2.
1535: l_key2 := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',p_key3);

Line 1538: OE_DEBUG_PUB.ADD('p_key1 is' || p_key1, 3);

1534: -- Always store validation_org in l_key2.
1535: l_key2 := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',p_key3);
1536:
1537: if l_debug_level > 0 then
1538: OE_DEBUG_PUB.ADD('p_key1 is' || p_key1, 3);
1539: OE_DEBUG_PUB.ADD('prev item: ' || g_item_rec.inventory_item_id, 3);
1540: OE_DEBUG_PUB.ADD('l_key2 (Master organizion_id) is' || l_key2, 3);
1541: OE_DEBUG_PUB.ADD('p_key2 (ship_from_org_id) is' || p_key2, 3);
1542: end if;

Line 1539: OE_DEBUG_PUB.ADD('prev item: ' || g_item_rec.inventory_item_id, 3);

1535: l_key2 := OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',p_key3);
1536:
1537: if l_debug_level > 0 then
1538: OE_DEBUG_PUB.ADD('p_key1 is' || p_key1, 3);
1539: OE_DEBUG_PUB.ADD('prev item: ' || g_item_rec.inventory_item_id, 3);
1540: OE_DEBUG_PUB.ADD('l_key2 (Master organizion_id) is' || l_key2, 3);
1541: OE_DEBUG_PUB.ADD('p_key2 (ship_from_org_id) is' || p_key2, 3);
1542: end if;
1543:

Line 1540: OE_DEBUG_PUB.ADD('l_key2 (Master organizion_id) is' || l_key2, 3);

1536:
1537: if l_debug_level > 0 then
1538: OE_DEBUG_PUB.ADD('p_key1 is' || p_key1, 3);
1539: OE_DEBUG_PUB.ADD('prev item: ' || g_item_rec.inventory_item_id, 3);
1540: OE_DEBUG_PUB.ADD('l_key2 (Master organizion_id) is' || l_key2, 3);
1541: OE_DEBUG_PUB.ADD('p_key2 (ship_from_org_id) is' || p_key2, 3);
1542: end if;
1543:
1544: IF p_key1 IS NOT NULL THEN

Line 1541: OE_DEBUG_PUB.ADD('p_key2 (ship_from_org_id) is' || p_key2, 3);

1537: if l_debug_level > 0 then
1538: OE_DEBUG_PUB.ADD('p_key1 is' || p_key1, 3);
1539: OE_DEBUG_PUB.ADD('prev item: ' || g_item_rec.inventory_item_id, 3);
1540: OE_DEBUG_PUB.ADD('l_key2 (Master organizion_id) is' || l_key2, 3);
1541: OE_DEBUG_PUB.ADD('p_key2 (ship_from_org_id) is' || p_key2, 3);
1542: end if;
1543:
1544: IF p_key1 IS NOT NULL THEN
1545:

Line 1550: OE_DEBUG_PUB.ADD('querying item from mtl_system_items', 3);

1546: IF g_item_rec.inventory_item_id = FND_API.G_MISS_NUM OR
1547: g_item_rec.inventory_item_id <> p_key1 THEN
1548:
1549: if l_debug_level > 0 then
1550: OE_DEBUG_PUB.ADD('querying item from mtl_system_items', 3);
1551: end if;
1552:
1553: /* Always load values based on the validation org
1554: for the below attributes. In future please add here for the columns

Line 1654: -- OE_DEBUG_PUB.ADD('OPM ont_pricing_qty_source after read ic_item_mst_b = ' || g_item_rec.ont_pricing_qty_source, 5);

1650:
1651: -- Moved this code from here inside the if INV_GMI_RSV_BRANCH.Is_Org_Process_Org(p_key2) THEN, because it was overriding the
1652: -- value of ont_pricing_qty_source for catchweight item
1653: -- g_item_rec.ont_pricing_qty_source := GML_READ_IC_B.read_price_qty_source(p_key1, l_key2); -- 2044240
1654: -- OE_DEBUG_PUB.ADD('OPM ont_pricing_qty_source after read ic_item_mst_b = ' || g_item_rec.ont_pricing_qty_source, 5);
1655:
1656:
1657: END IF; -- end of IF NVL(FND_PROFILE.VALUE('ONT_PROCESS_INSTALLED_FLAG'),'Y')
1658: END IF; -- IF INV_GMI_RSV_BRANCH.G_PROCESS_INV_INSTALLED = 'I

Line 1685: OE_DEBUG_PUB.ADD('querying based on ship_from_org', 3);

1681:
1682: l_inventory_changed := 'N';
1683:
1684: if l_debug_level > 0 then
1685: OE_DEBUG_PUB.ADD('querying based on ship_from_org', 3);
1686: end if;
1687: SELECT shippable_item_flag
1688: ,organization_id
1689: , restrict_subinventories_code -- bug 4171642

Line 1736: --OE_DEBUG_PUB.ADD('OPM ont_pricing_qty_source after read ic_item_mst_b = ' || g_item_rec.ont_pricing_qty_source, 5);

1732: IF INV_GMI_RSV_BRANCH.Is_Org_Process_Org(p_key2) THEN
1733: g_item_rec.process_warehouse_flag := 'Y';
1734: --g_item_rec.ont_pricing_qty_source := GML_READ_IC_B.read_price_qty_source(p_key1, l_key2); -- INVCONV 2044240
1735: --if l_debug_level > 0 then
1736: --OE_DEBUG_PUB.ADD('OPM ont_pricing_qty_source after read ic_item_mst_b = ' || g_item_rec.ont_pricing_qty_source, 5);
1737: --end if;
1738: ELSE
1739: g_item_rec.process_warehouse_flag := NULL;
1740: END IF;

Line 1743: oe_debug_pub.add('in OE_ORDER_CACHE.LOAD_ITEM process warehouse flag is ' || g_item_rec.process_warehouse_flag );

1739: g_item_rec.process_warehouse_flag := NULL;
1740: END IF;
1741:
1742: if l_debug_level > 0 then
1743: oe_debug_pub.add('in OE_ORDER_CACHE.LOAD_ITEM process warehouse flag is ' || g_item_rec.process_warehouse_flag );
1744: /* OPM END */
1745:
1746: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_ITEM', 1);
1747: end if;

Line 1746: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_ITEM', 1);

1742: if l_debug_level > 0 then
1743: oe_debug_pub.add('in OE_ORDER_CACHE.LOAD_ITEM process warehouse flag is ' || g_item_rec.process_warehouse_flag );
1744: /* OPM END */
1745:
1746: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_ITEM', 1);
1747: end if;
1748: EXCEPTION
1749: -- this is temporary workaround
1750:

Line 1798: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_ITEM - item doesnt exist in ship_from', 2);

1794: WHERE INVENTORY_ITEM_ID = p_key1
1795: AND ORGANIZATION_ID = OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID',p_key3);
1796:
1797: if l_debug_level > 0 then
1798: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_ITEM - item doesnt exist in ship_from', 2);
1799: end if;
1800: WHEN OTHERS THEN
1801:
1802: if l_debug_level > 0 then

Line 1803: oe_debug_pub.add('exception in load item', 1);

1799: end if;
1800: WHEN OTHERS THEN
1801:
1802: if l_debug_level > 0 then
1803: oe_debug_pub.add('exception in load item', 1);
1804: end if;
1805: IF OE_MSG_PUB.Check_Msg_Level (OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1806: THEN
1807: OE_MSG_PUB.Add_Exc_Msg

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

1817: FUNCTION Load_Set
1818: ( p_set_id IN NUMBER)
1819: RETURN set_rec_type
1820: IS
1821: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1822: BEGIN
1823:
1824: if l_debug_level > 0 then
1825: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_SET', 1);

Line 1825: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_SET', 1);

1821: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1822: BEGIN
1823:
1824: if l_debug_level > 0 then
1825: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_SET', 1);
1826: end if;
1827:
1828: IF (p_set_id IS NOT NULL)
1829: THEN

Line 1895: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_SET', 1);

1891: END;
1892: --END IF;
1893:
1894: if l_debug_level > 0 then
1895: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_SET', 1);
1896: end if;
1897:
1898: RETURN g_set_rec;
1899: END IF;

Line 1902: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_SET', 1);

1898: RETURN g_set_rec;
1899: END IF;
1900:
1901: if l_debug_level > 0 then
1902: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_SET', 1);
1903: end if;
1904:
1905: RETURN g_set_rec;
1906:

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

1925: FUNCTION Load_Payment_Term
1926: ( p_key IN NUMBER )
1927: RETURN Payment_Term_Rec_Type
1928: IS
1929: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1930: BEGIN
1931:
1932: if l_debug_level > 0 then
1933: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_Payment_Term', 1);

Line 1933: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_Payment_Term', 1);

1929: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1930: BEGIN
1931:
1932: if l_debug_level > 0 then
1933: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_Payment_Term', 1);
1934: end if;
1935:
1936: IF p_key IS NOT NULL THEN
1937: IF g_Payment_Term_rec.term_id = FND_API.G_MISS_NUM OR

Line 1939: oe_debug_pub.add('querying oe_ra_terms_v');

1935:
1936: IF p_key IS NOT NULL THEN
1937: IF g_Payment_Term_rec.term_id = FND_API.G_MISS_NUM OR
1938: g_Payment_Term_rec.term_id <> p_key THEN
1939: oe_debug_pub.add('querying oe_ra_terms_v');
1940: SELECT term_id ,
1941: name,
1942: start_date_active,
1943: end_date_active

Line 1956: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_Payment_Term', 1);

1952: END IF ;
1953: END IF ;
1954:
1955: if l_debug_level > 0 then
1956: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_Payment_Term', 1);
1957: end if;
1958: RETURN g_Payment_term_rec;
1959: EXCEPTION
1960: WHEN NO_DATA_FOUND THEN

Line 1961: oe_debug_pub.add('No Data Found in OE_Order_Cache.Load_Payment_Term');

1957: end if;
1958: RETURN g_Payment_term_rec;
1959: EXCEPTION
1960: WHEN NO_DATA_FOUND THEN
1961: oe_debug_pub.add('No Data Found in OE_Order_Cache.Load_Payment_Term');
1962: RAISE NO_DATA_FOUND ;
1963:
1964: -- Returning g_payment_rec could potentially pass the wrong result and
1965: -- if processed could result to data corruption

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

1982: FUNCTION Load_Salesrep_rec
1983: ( p_key IN NUMBER )
1984: RETURN Salesrep_Rec_Type
1985: IS
1986: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1987: BEGIN
1988:
1989: if l_debug_level > 0 then
1990: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_Salesrep_rec', 1);

Line 1990: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_Salesrep_rec', 1);

1986: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1987: BEGIN
1988:
1989: if l_debug_level > 0 then
1990: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_Salesrep_rec', 1);
1991: end if;
1992:
1993: IF p_key IS NOT NULL THEN
1994: IF g_Salesrep_rec.salesrep_id = FND_API.G_MISS_NUM OR

Line 1996: oe_debug_pub.add('Load Salesrep cache');

1992:
1993: IF p_key IS NOT NULL THEN
1994: IF g_Salesrep_rec.salesrep_id = FND_API.G_MISS_NUM OR
1995: g_Salesrep_rec.salesrep_id <> p_key THEN
1996: oe_debug_pub.add('Load Salesrep cache');
1997: SELECT salesrep_id ,
1998: name,
1999: status,
2000: start_date_active,

Line 2015: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_Salesrep', 1);

2011: END IF ;
2012: END IF ;
2013:
2014: if l_debug_level > 0 then
2015: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_Salesrep', 1);
2016: end if;
2017: RETURN g_Salesrep_rec;
2018: EXCEPTION
2019: WHEN NO_DATA_FOUND THEN

Line 2020: oe_debug_pub.add('No Data Found in OE_Order_Cache.Load_Salesrep_rec');

2016: end if;
2017: RETURN g_Salesrep_rec;
2018: EXCEPTION
2019: WHEN NO_DATA_FOUND THEN
2020: oe_debug_pub.add('No Data Found in OE_Order_Cache.Load_Salesrep_rec');
2021: RAISE NO_DATA_FOUND ;
2022: -- Returing g_salesrep_rec could potentially pass the old information and if processed can result into corruption issue.
2023:
2024: -- return g_salesrep_rec ;

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

2043: PROCEDURE Set_Order_Header
2044: (
2045: p_header_rec IN OE_ORDER_PUB.Header_Rec_Type
2046: ) IS
2047: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2048: BEGIN
2049:
2050: if l_debug_level > 0 then
2051: oe_debug_pub.add('Entering OE_ORDER_CACHE.Set_Order_Header', 1);

Line 2051: oe_debug_pub.add('Entering OE_ORDER_CACHE.Set_Order_Header', 1);

2047: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2048: BEGIN
2049:
2050: if l_debug_level > 0 then
2051: oe_debug_pub.add('Entering OE_ORDER_CACHE.Set_Order_Header', 1);
2052: end if;
2053:
2054: IF (p_header_rec.header_id IS NOT NULL) THEN
2055:

Line 2065: oe_debug_pub.add('Exiting OE_ORDER_CACHE.Set_Order_Header', 1);

2061:
2062: END IF;
2063:
2064: if l_debug_level > 0 then
2065: oe_debug_pub.add('Exiting OE_ORDER_CACHE.Set_Order_Header', 1);
2066: end if;
2067:
2068: END Set_Order_Header;
2069:

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

2071: -- procedures that clear cached entities.
2072:
2073: PROCEDURE Clear_Top_Model_Line(p_key IN NUMBER)
2074: IS
2075: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2076: BEGIN
2077:
2078: if l_debug_level > 0 then
2079: oe_debug_pub.add('Entering OE_ORDER_CACHE.Top_Model_Line', 1);

Line 2079: oe_debug_pub.add('Entering OE_ORDER_CACHE.Top_Model_Line', 1);

2075: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2076: BEGIN
2077:
2078: if l_debug_level > 0 then
2079: oe_debug_pub.add('Entering OE_ORDER_CACHE.Top_Model_Line', 1);
2080: end if;
2081:
2082: IF nvl(g_top_model_line_rec.line_id,0) = p_key THEN
2083: if l_debug_level > 0 then

Line 2084: oe_debug_pub.add('in ucchb, clearing top model cache: '|| p_key, 3);

2080: end if;
2081:
2082: IF nvl(g_top_model_line_rec.line_id,0) = p_key THEN
2083: if l_debug_level > 0 then
2084: oe_debug_pub.add('in ucchb, clearing top model cache: '|| p_key, 3);
2085: end if;
2086: g_top_model_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
2087: END IF;
2088:

Line 2090: oe_debug_pub.add('Exiting OE_ORDER_CACHE.Top_Model_Line', 1);

2086: g_top_model_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
2087: END IF;
2088:
2089: if l_debug_level > 0 then
2090: oe_debug_pub.add('Exiting OE_ORDER_CACHE.Top_Model_Line', 1);
2091: end if;
2092:
2093: END Clear_Top_Model_Line;
2094:

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

2094:
2095:
2096: PROCEDURE Clear_Order_Type
2097: IS
2098: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2099: BEGIN
2100:
2101: if l_debug_level > 0 then
2102: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_ORDER_TYPE', 1);

Line 2102: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_ORDER_TYPE', 1);

2098: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2099: BEGIN
2100:
2101: if l_debug_level > 0 then
2102: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_ORDER_TYPE', 1);
2103: end if;
2104: g_order_type_rec := G_MISS_ORDER_TYPE_REC;
2105:
2106: if l_debug_level > 0 then

Line 2107: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_ORDER_TYPE', 1);

2103: end if;
2104: g_order_type_rec := G_MISS_ORDER_TYPE_REC;
2105:
2106: if l_debug_level > 0 then
2107: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_ORDER_TYPE', 1);
2108: end if;
2109: END Clear_Order_Type;
2110:
2111: PROCEDURE Clear_Agreement

Line 2115: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_AGREEMENT', 1);

2111: PROCEDURE Clear_Agreement
2112: IS
2113: BEGIN
2114:
2115: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_AGREEMENT', 1);
2116:
2117: g_agreement_rec := G_MISS_AGREEMENT_REC;
2118:
2119: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_AGREEMENT', 1);

Line 2119: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_AGREEMENT', 1);

2115: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_AGREEMENT', 1);
2116:
2117: g_agreement_rec := G_MISS_AGREEMENT_REC;
2118:
2119: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_AGREEMENT', 1);
2120:
2121: END Clear_Agreement;
2122:
2123: PROCEDURE Clear_Ship_To_Org

Line 2127: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_SHIP_TO_ORG', 1);

2123: PROCEDURE Clear_Ship_To_Org
2124: IS
2125: BEGIN
2126:
2127: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_SHIP_TO_ORG', 1);
2128:
2129: g_ship_to_rec := G_MISS_SHIP_TO_REC;
2130:
2131: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_SHIP_TO_ORG', 1);

Line 2131: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_SHIP_TO_ORG', 1);

2127: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_SHIP_TO_ORG', 1);
2128:
2129: g_ship_to_rec := G_MISS_SHIP_TO_REC;
2130:
2131: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_SHIP_TO_ORG', 1);
2132:
2133: END Clear_Ship_To_Org;
2134:
2135: PROCEDURE Clear_Invoice_To_Org

Line 2139: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_INVOICE_TO_ORG', 1);

2135: PROCEDURE Clear_Invoice_To_Org
2136: IS
2137: BEGIN
2138:
2139: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_INVOICE_TO_ORG', 1);
2140:
2141: g_invoice_to_rec := G_MISS_INVOICE_TO_REC;
2142:
2143: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_INVOICE_TO_ORG', 1);

Line 2143: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_INVOICE_TO_ORG', 1);

2139: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_INVOICE_TO_ORG', 1);
2140:
2141: g_invoice_to_rec := G_MISS_INVOICE_TO_REC;
2142:
2143: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_INVOICE_TO_ORG', 1);
2144:
2145: END Clear_Invoice_To_Org;
2146:
2147: PROCEDURE Clear_Deliver_To_Org

Line 2151: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_DELIVER_TO_ORG', 1);

2147: PROCEDURE Clear_Deliver_To_Org
2148: IS
2149: BEGIN
2150:
2151: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_DELIVER_TO_ORG', 1);
2152:
2153: g_deliver_to_rec := G_MISS_DELIVER_TO_REC;
2154:
2155: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_DELIVER_TO_ORG', 1);

Line 2155: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_DELIVER_TO_ORG', 1);

2151: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_DELIVER_TO_ORG', 1);
2152:
2153: g_deliver_to_rec := G_MISS_DELIVER_TO_REC;
2154:
2155: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_DELIVER_TO_ORG', 1);
2156:
2157: END Clear_Deliver_To_Org;
2158:
2159: PROCEDURE Clear_Sold_To_Org

Line 2163: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_SOLD_TO_ORG', 1);

2159: PROCEDURE Clear_Sold_To_Org
2160: IS
2161: BEGIN
2162:
2163: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_SOLD_TO_ORG', 1);
2164:
2165: g_sold_to_rec := G_MISS_SOLD_TO_REC;
2166:
2167: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_SOLD_TO_ORG', 1);

Line 2167: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_SOLD_TO_ORG', 1);

2163: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_SOLD_TO_ORG', 1);
2164:
2165: g_sold_to_rec := G_MISS_SOLD_TO_REC;
2166:
2167: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_SOLD_TO_ORG', 1);
2168:
2169: END Clear_Sold_To_Org;
2170:
2171: PROCEDURE Clear_Price_List

Line 2175: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_PRICE_LIST', 1);

2171: PROCEDURE Clear_Price_List
2172: IS
2173: BEGIN
2174:
2175: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_PRICE_LIST', 1);
2176:
2177: g_price_list_rec := G_MISS_PRICE_LIST_REC;
2178:
2179: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_PRICE_LIST', 1);

Line 2179: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_PRICE_LIST', 1);

2175: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_PRICE_LIST', 1);
2176:
2177: g_price_list_rec := G_MISS_PRICE_LIST_REC;
2178:
2179: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_PRICE_LIST', 1);
2180:
2181: END Clear_Price_List;
2182:
2183: PROCEDURE Clear_Set_Of_Books

Line 2187: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_SET_OF_BOOKS', 1);

2183: PROCEDURE Clear_Set_Of_Books
2184: IS
2185: BEGIN
2186:
2187: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_SET_OF_BOOKS', 1);
2188:
2189: g_set_of_books_rec := G_MISS_SET_OF_BOOKS_REC;
2190:
2191: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_SET_OF_BOOKS', 1);

Line 2191: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_SET_OF_BOOKS', 1);

2187: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_SET_OF_BOOKS', 1);
2188:
2189: g_set_of_books_rec := G_MISS_SET_OF_BOOKS_REC;
2190:
2191: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_SET_OF_BOOKS', 1);
2192:
2193: END Clear_Set_Of_Books;
2194:
2195: PROCEDURE Clear_item

Line 2199: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_ITEM', 1);

2195: PROCEDURE Clear_item
2196: IS
2197: BEGIN
2198:
2199: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_ITEM', 1);
2200:
2201: g_item_rec := G_MISS_ITEM_REC;
2202:
2203: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_ITEM', 1);

Line 2203: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_ITEM', 1);

2199: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_ITEM', 1);
2200:
2201: g_item_rec := G_MISS_ITEM_REC;
2202:
2203: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_ITEM', 1);
2204:
2205: END Clear_item;
2206:
2207: PROCEDURE Clear_item_Cost

Line 2211: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_ITEM_COST', 1);

2207: PROCEDURE Clear_item_Cost
2208: IS
2209: BEGIN
2210:
2211: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_ITEM_COST', 1);
2212:
2213: g_item_cost_rec := G_MISS_ITEM_COST_REC;
2214:
2215: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_ITEM_COST', 1);

Line 2215: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_ITEM_COST', 1);

2211: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_ITEM_COST', 1);
2212:
2213: g_item_cost_rec := G_MISS_ITEM_COST_REC;
2214:
2215: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_ITEM_COST', 1);
2216:
2217: END Clear_item_Cost;
2218:
2219: PROCEDURE Clear_Order_Header

Line 2223: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_ORDER_HEADER', 1);

2219: PROCEDURE Clear_Order_Header
2220: IS
2221: BEGIN
2222:
2223: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_ORDER_HEADER', 1);
2224:
2225: g_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
2226:
2227: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_ORDER_HEADER', 1);

Line 2227: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_ORDER_HEADER', 1);

2223: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_ORDER_HEADER', 1);
2224:
2225: g_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
2226:
2227: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_ORDER_HEADER', 1);
2228:
2229: END Clear_Order_Header;
2230:
2231:

Line 2236: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_DISCOUNT', 1);

2232: PROCEDURE Clear_Discount
2233: IS
2234: BEGIN
2235:
2236: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_DISCOUNT', 1);
2237:
2238: g_hdr_discount_rec := oe_order_cache.g_miss_discount_rec;
2239: g_line_discount_rec := oe_order_cache.g_miss_discount_rec;
2240:

Line 2241: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_DISCOUNT', 1);

2237:
2238: g_hdr_discount_rec := oe_order_cache.g_miss_discount_rec;
2239: g_line_discount_rec := oe_order_cache.g_miss_discount_rec;
2240:
2241: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_DISCOUNT', 1);
2242:
2243: END clear_discount;
2244:
2245: --added for bug 4200055

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

2244:
2245: --added for bug 4200055
2246: PROCEDURE Clear_Salesrep
2247: IS
2248: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2249:
2250: BEGIN
2251: IF l_debug_level > 0 THEN
2252: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_SALESREP', 1);

Line 2252: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_SALESREP', 1);

2248: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2249:
2250: BEGIN
2251: IF l_debug_level > 0 THEN
2252: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_SALESREP', 1);
2253: END IF;
2254:
2255: g_salesrep_rec := oe_order_cache.g_miss_salesrep_rec;
2256:

Line 2258: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_SALESREP', 1);

2254:
2255: g_salesrep_rec := oe_order_cache.g_miss_salesrep_rec;
2256:
2257: IF l_debug_level > 0 THEN
2258: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_SALESREP', 1);
2259: END IF;
2260:
2261: END clear_salesrep;
2262:

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

2262:
2263:
2264: PROCEDURE Clear_Payment_Term
2265: IS
2266: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2267:
2268: BEGIN
2269: IF l_debug_level > 0 THEN
2270: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_payment_term', 1);

Line 2270: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_payment_term', 1);

2266: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2267:
2268: BEGIN
2269: IF l_debug_level > 0 THEN
2270: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_payment_term', 1);
2271: END IF;
2272:
2273: g_payment_term_rec := oe_order_cache.g_miss_payment_term_rec;
2274:

Line 2276: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_payment_term', 1);

2272:
2273: g_payment_term_rec := oe_order_cache.g_miss_payment_term_rec;
2274:
2275: IF l_debug_level > 0 THEN
2276: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_payment_term', 1);
2277: END IF;
2278:
2279: END clear_payment_term;
2280: -- end bug 4200055

Line 2286: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_ALL', 1);

2282: PROCEDURE Clear_All
2283: IS
2284: BEGIN
2285:
2286: oe_debug_pub.add('Entering OE_ORDER_CACHE.CLEAR_ALL', 1);
2287:
2288: Clear_Order_Type;
2289: Clear_Agreement;
2290: Clear_Ship_To_Org;

Line 2305: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_ALL', 1);

2301: Clear_Payment_Term ;
2302: Clear_Salesrep ;
2303: --end
2304:
2305: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_ALL', 1);
2306:
2307: END Clear_All;
2308:
2309: FUNCTION Get_Set_Of_Books

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

2320: FUNCTION Load_List_Lines
2321: ( p_key IN NUMBER )
2322: RETURN Modifiers_Rec_Type
2323: IS
2324: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2325: BEGIN
2326:
2327: if l_debug_level > 0 then
2328: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_list_lines', 1);

Line 2328: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_list_lines', 1);

2324: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2325: BEGIN
2326:
2327: if l_debug_level > 0 then
2328: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_list_lines', 1);
2329: end if;
2330:
2331: IF p_key IS NOT NULL THEN
2332:

Line 2423: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_list_lines', 1);

2419:
2420: END IF;
2421:
2422: if l_debug_level > 0 then
2423: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_list_lines', 1);
2424: end if;
2425:
2426: RETURN g_Modifiers_Rec;
2427:

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

2456: Procedure Load_Cust_Trx_Type
2457: ( p_key IN NUMBER )
2458: IS
2459: l_calculate_tax_flag varchar2(1) := NULL;
2460: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2461: l_current_org_id NUMBER ; -- MOAC Changes
2462: BEGIN
2463:
2464: if l_debug_level > 0 then

Line 2465: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_CUST_TRX_TYPE', 1);

2461: l_current_org_id NUMBER ; -- MOAC Changes
2462: BEGIN
2463:
2464: if l_debug_level > 0 then
2465: oe_debug_pub.add('Entering OE_ORDER_CACHE.LOAD_CUST_TRX_TYPE', 1);
2466: end if;
2467:
2468: l_current_org_id := MO_Global.Get_Current_Org_Id() ; --MOAC changes
2469:

Line 2473: oe_debug_pub.add('No Receivable Transaction Type assigned at any of the levels');

2469:
2470: -- New condition added for bug 2281054
2471: If p_key = 0 then
2472: if l_debug_level > 0 then
2473: oe_debug_pub.add('No Receivable Transaction Type assigned at any of the levels');
2474: end if;
2475: -- bug 2604421, need to initialize this value, otherwise the
2476: -- tax_calculation_flag cached from previous order will remain.
2477: g_cust_trx_rec.tax_calculation_flag := null;

Line 2506: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_CUST_TRX_TYPE', 1);

2502: END IF;
2503: <>
2504:
2505: if l_debug_level > 0 then
2506: oe_debug_pub.add('Exiting OE_ORDER_CACHE.LOAD_CUST_TRX_TYPE', 1);
2507: end if;
2508:
2509: EXCEPTION
2510:

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

2530: l_tax_rec Tax_Calc_Rec_Type;
2531: l_cust_trx_type_id number;
2532: v_start number;
2533: v_end number;
2534: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2535: BEGIN
2536:
2537: --v_start := DBMS_UTILITY.GET_TIME;
2538:

Line 2540: oe_debug_pub.add('Entering OE_ORDER_CACHE.GET_TAX_CALCULATION_FLAG', 1);

2536:
2537: --v_start := DBMS_UTILITY.GET_TIME;
2538:
2539: if l_debug_level > 0 then
2540: oe_debug_pub.add('Entering OE_ORDER_CACHE.GET_TAX_CALCULATION_FLAG', 1);
2541: end if;
2542:
2543: IF p_key IS NOT NULL THEN
2544:

Line 2554: oe_debug_pub.add('ren: flag: cust_trx_type_id: line_type_id: ' || l_tax_rec.tax_calculation_flag ||': ' || l_tax_rec.cust_trx_type_id || ': ' || l_tax_rec.line_type_id || ' .' , 4);

2550:
2551: l_tax_rec.line_type_id := g_tax_calc_tbl(p_key).line_type_id;
2552:
2553: if l_debug_level > 0 then
2554: oe_debug_pub.add('ren: flag: cust_trx_type_id: line_type_id: ' || l_tax_rec.tax_calculation_flag ||': ' || l_tax_rec.cust_trx_type_id || ': ' || l_tax_rec.line_type_id || ' .' , 4);
2555: end if;
2556:
2557: ELSE
2558:

Line 2589: oe_debug_pub.add('g_tax_calc_tbl flag: cust_trx_type_id: line_type_id: ' || g_tax_calc_tbl(p_key).tax_calculation_flag ||': ' || g_tax_calc_tbl(p_key).cust_trx_type_id || ': ' || g_tax_calc_tbl(p_key).line_type_id || ' .' , 4);

2585: l_tax_rec.cust_trx_type_id := l_cust_trx_type_id;
2586:
2587: g_tax_calc_tbl(p_key) := l_tax_rec;
2588: if l_debug_level > 0 then
2589: oe_debug_pub.add('g_tax_calc_tbl flag: cust_trx_type_id: line_type_id: ' || g_tax_calc_tbl(p_key).tax_calculation_flag ||': ' || g_tax_calc_tbl(p_key).cust_trx_type_id || ': ' || g_tax_calc_tbl(p_key).line_type_id || ' .' , 4);
2590: end if;
2591:
2592: END IF; /* if cust_trx_type_id is null and
2593: calculate_tax_flag is null */

Line 2601: -- oe_debug_pub.add('ren: Time Of execution for get_tax_calculation_flag '||

2597: END IF; /* IF p_key is not null */
2598:
2599: --v_end := DBMS_UTILITY.GET_TIME;
2600:
2601: -- oe_debug_pub.add('ren: Time Of execution for get_tax_calculation_flag '||
2602: -- to_char((v_end-v_start)/100),1);
2603:
2604: if l_debug_level > 0 then
2605: oe_debug_pub.add('Exiting OE_ORDER_CACHE.GET_TAX_CALCULATION_FLAG', 1);

Line 2605: oe_debug_pub.add('Exiting OE_ORDER_CACHE.GET_TAX_CALCULATION_FLAG', 1);

2601: -- oe_debug_pub.add('ren: Time Of execution for get_tax_calculation_flag '||
2602: -- to_char((v_end-v_start)/100),1);
2603:
2604: if l_debug_level > 0 then
2605: oe_debug_pub.add('Exiting OE_ORDER_CACHE.GET_TAX_CALCULATION_FLAG', 1);
2606: end if;
2607:
2608: RETURN l_tax_rec;
2609:

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

2627: FUNCTION IS_FLEX_ENABLED(p_flex_name IN VARCHAR2)
2628: RETURN VARCHAR2
2629: IS
2630: l_flex_name varchar2(240);
2631: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2632: BEGIN
2633: if l_debug_level > 0 then
2634: oe_debug_pub.add('Enter Is Flex Enabled' ,1);
2635: end if;

Line 2634: oe_debug_pub.add('Enter Is Flex Enabled' ,1);

2630: l_flex_name varchar2(240);
2631: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2632: BEGIN
2633: if l_debug_level > 0 then
2634: oe_debug_pub.add('Enter Is Flex Enabled' ,1);
2635: end if;
2636: IF p_flex_name = 'OE_HEADER_ATTRIBUTES' THEN
2637: IF g_hdr_desc_flex is null THEN
2638: g_hdr_desc_flex := Load_flex_enabled_flag(p_flex_name);

Line 2700: oe_debug_pub.add('Exit Is Flex Enabled' ,1);

2696: RETURN g_line_blkt_desc_flex;
2697: END IF;
2698: NULL;
2699: if l_debug_level > 0 then
2700: oe_debug_pub.add('Exit Is Flex Enabled' ,1);
2701: end if;
2702:
2703: END IS_FLEX_ENABLED;
2704:

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

2707: RETURN VARCHAR2
2708: IS
2709: l_count number;
2710: l_application_id number; --For bug 2684403
2711: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2712: BEGIN
2713: if l_debug_level > 0 then
2714: oe_debug_pub.add('Enter Load Flex Enabled Flag ' ,1);
2715: end if;

Line 2714: oe_debug_pub.add('Enter Load Flex Enabled Flag ' ,1);

2710: l_application_id number; --For bug 2684403
2711: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2712: BEGIN
2713: if l_debug_level > 0 then
2714: oe_debug_pub.add('Enter Load Flex Enabled Flag ' ,1);
2715: end if;
2716:
2717: l_application_id := 660;
2718:

Line 2737: oe_debug_pub.add('Exit Load Flex Enabled Flag ' ,1);

2733: ELSE
2734: RETURN 'N';
2735: END IF;
2736: if l_debug_level > 0 then
2737: oe_debug_pub.add('Exit Load Flex Enabled Flag ' ,1);
2738: end if;
2739:
2740: EXCEPTION
2741: WHEN OTHERS THEN