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 1652: -- OE_DEBUG_PUB.ADD('OPM ont_pricing_qty_source after read ic_item_mst_b = ' || g_item_rec.ont_pricing_qty_source, 5);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2552: 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);

2548:
2549: l_tax_rec.line_type_id := g_tax_calc_tbl(p_key).line_type_id;
2550:
2551: if l_debug_level > 0 then
2552: 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);
2553: end if;
2554:
2555: ELSE
2556:

Line 2587: 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);

2583: l_tax_rec.cust_trx_type_id := l_cust_trx_type_id;
2584:
2585: g_tax_calc_tbl(p_key) := l_tax_rec;
2586: if l_debug_level > 0 then
2587: 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);
2588: end if;
2589:
2590: END IF; /* if cust_trx_type_id is null and
2591: calculate_tax_flag is null */

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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