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.12010000.1 2008/07/25 07:54:59 appldev 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.12010000.1 2008/07/25 07:54:59 appldev 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 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 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 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 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 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 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 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 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 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 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 2236: g_hdr_discount_rec := oe_order_cache.g_miss_discount_rec;

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

Line 2237: g_line_discount_rec := oe_order_cache.g_miss_discount_rec;

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

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

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

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

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

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

2743:
2744:
2745:
2746:
2747: END OE_Order_Cache;