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_ORDER_CACHE

Line 1: PACKAGE BODY OE_Order_Cache AS

1: PACKAGE BODY OE_Order_Cache AS
2: /* $Header: OEXUCCHB.pls 120.13.12020000.2 2013/01/07 09:16:27 sujithku ship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_Order_Cache';

2: /* $Header: OEXUCCHB.pls 120.13.12020000.2 2013/01/07 09:16:27 sujithku ship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30):='OE_Order_Cache';
7:
8:
9: -- Procedures that load cached entities.
10:

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 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 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 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 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 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 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 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 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 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 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 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 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 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 1135: RETURN OE_ORDER_CACHE.g_header_rec;

1131: BEGIN
1132:
1133: Load_Order_Header(p_key);
1134:
1135: RETURN OE_ORDER_CACHE.g_header_rec;
1136:
1137: END Load_Order_Header;
1138:
1139: PROCEDURE Load_Order_Header

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 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 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 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 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 1420: RETURN OE_ORDER_CACHE.g_top_model_line_rec;

1416: BEGIN
1417:
1418: Load_Top_Model_Line(p_key);
1419:
1420: RETURN OE_ORDER_CACHE.g_top_model_line_rec;
1421:
1422: END Load_Top_Model_Line;
1423:
1424: PROCEDURE Load_Top_Model_Line

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 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 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 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 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 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 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 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 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 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 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 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 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 2238: g_hdr_discount_rec := oe_order_cache.g_miss_discount_rec;

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:
2241: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_DISCOUNT', 1);
2242:

Line 2239: g_line_discount_rec := oe_order_cache.g_miss_discount_rec;

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:
2241: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_DISCOUNT', 1);
2242:
2243: END clear_discount;

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 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 2255: g_salesrep_rec := oe_order_cache.g_miss_salesrep_rec;

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:
2257: IF l_debug_level > 0 THEN
2258: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_SALESREP', 1);
2259: END IF;

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 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 2273: g_payment_term_rec := oe_order_cache.g_miss_payment_term_rec;

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:
2275: IF l_debug_level > 0 THEN
2276: oe_debug_pub.add('Exiting OE_ORDER_CACHE.CLEAR_payment_term', 1);
2277: END IF;

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 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 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 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 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 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 2749: END OE_Order_Cache;

2745:
2746:
2747:
2748:
2749: END OE_Order_Cache;