[Home] [Help]
21: end if;
22:
23: IF p_Line_Type_id IS NOT NULL THEN
24:
25: IF g_Enforce_list_price_rec.Line_Type_id = FND_API.G_MISS_NUM OR
26: g_Enforce_list_price_rec.Line_Type_id <> p_Line_Type_id THEN
27:
28: SELECT
29: p_Line_Type_id
40:
41: IF p_header_id IS NOT NULL and
42: g_Enforce_list_price_rec.enforce_line_prices_flag <> 'Y' THEN
43:
44: IF g_Enforce_list_price_rec.header_id = FND_API.G_MISS_NUM OR
45: g_Enforce_list_price_rec.header_id <> p_header_id
46: THEN
47:
48: SELECT /*MOAC_SQL_CHANGES*/
77: 'Enforce_List_price'
78: );
79: END IF;
80:
81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
82:
83: END Enforce_List_price;
84:
85: FUNCTION Load_Order_Type
103: end if;
104:
105: IF p_key IS NOT NULL THEN
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
182: 'Load_Order_Type'
183: );
184: END IF;
185:
186: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
187:
188: END Load_Order_Type;
189:
190: ------------------------------------------------------------
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:
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);
317: 'Load_Line_Type'
318: );
319: END IF;
320:
321: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
322: END Load_Line_Type;
323:
324:
325: FUNCTION Load_Agreement
334: end if;
335:
336: IF p_key IS NOT NULL THEN
337:
338: IF g_agreement_rec.agreement_id = FND_API.G_MISS_NUM OR
339: g_agreement_rec.agreement_id <> p_key THEN
340:
341: SELECT AGREEMENT_ID
342: , INVOICING_RULE_ID
383: 'Load_Agreement'
384: );
385: END IF;
386:
387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388:
389: END Load_Agreement;
390:
391: FUNCTION Load_Ship_To_Org
401: end if;
402:
403: IF p_key IS NOT NULL THEN
404:
405: IF g_ship_to_rec.org_id = FND_API.G_MISS_NUM OR
406: g_ship_to_rec.org_id <> p_key THEN
407:
408: SELECT ORGANIZATION_ID
409: , PRICE_LIST_ID
455: , 'Load_Ship_To_Org - Fetch Bill to Site'
456: );
457: END IF;
458:
459: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
460:
461: END; -- Fetching Bill To Site
462:
463: END IF;
487: , 'Load_Ship_To_Org - Fetch Payment Terms'
488: );
489: END IF;
490:
491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
492:
493: END; -- Begin fetching payment terms.
494:
495: END IF;
503: RETURN g_ship_to_rec;
504:
505: EXCEPTION
506:
507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
508:
509: RAISE;
510:
511: WHEN OTHERS THEN
517: 'Load_Ship_To_Org'
518: );
519: END IF;
520:
521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
522:
523: END Load_Ship_To_Org;
524:
525: FUNCTION Load_Invoice_To_Org
534: end if;
535:
536: IF p_key IS NOT NULL THEN
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
591: , 'Load_Invoice_To_Org - Fetch Payment Terms'
592: );
593: END IF;
594:
595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
596:
597: END; -- Begin fetching payment terms.
598:
599: END IF;
611:
612: RAISE NO_DATA_FOUND ;
613:
614:
615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
616:
617: RAISE;
618:
619: WHEN OTHERS THEN
625: 'Load_Invoice_To_Org'
626: );
627: END IF;
628:
629: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
630:
631: END Load_Invoice_To_Org;
632:
633: FUNCTION Load_Deliver_To_Org
643: end if;
644:
645: IF p_key IS NOT NULL THEN
646:
647: IF g_deliver_to_rec.org_id = FND_API.G_MISS_NUM OR
648: g_deliver_to_rec.org_id <> p_key THEN
649:
650: SELECT ORGANIZATION_ID
651: , PRICE_LIST_ID
702: 'Load_Deliver_To_Org'
703: );
704: END IF;
705:
706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
707:
708: END Load_Deliver_To_Org;
709:
710: FUNCTION Load_Sold_To_Org
727: l_current_org_id := MO_Global.Get_Current_Org_Id() ;
728:
729: IF p_key IS NOT NULL THEN
730:
731: IF g_sold_to_rec.sold_to_org_id = FND_API.G_MISS_NUM OR
732: g_sold_to_rec.sold_to_org_id <> p_key OR
733: g_sold_to_rec.org_id <> l_current_org_id THEN
734:
735: SELECT ORGANIZATION_ID
783: , 'Load_Sold_To_Org - Fetch Invoice To'
784: );
785: END IF;
786:
787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
788:
789: END; -- Begin fetching Invoice to.
790:
791: -- Fetch Ship to org.
820: , 'Load_Sold_To_Org - Fetch Ship To'
821: );
822: END IF;
823:
824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
825:
826: END; -- Begin fetching Ship to.
827:
828: -- Fetch Deliver to org
857: , 'Load_Sold_To_Org - Fetch Deliver To'
858: );
859: END IF;
860:
861: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
862:
863: END; -- Begin fetching Deliver to.
864:
865: -- Fetch payment term
888: , 'Load_Sold_To_Org - Fetch Payment Term'
889: );
890: END IF;
891:
892: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
893:
894: END; -- Begin fetching Payment Term.
895:
896: END IF;
904: RETURN g_sold_to_rec;
905:
906: EXCEPTION
907:
908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
909:
910: RAISE;
911:
912: WHEN OTHERS THEN
918: 'Load_Sold_To_Org'
919: );
920: END IF;
921:
922: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
923:
924: END Load_Sold_To_Org;
925:
926: FUNCTION Load_Price_List
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
939: g_price_list_rec.price_list_id <> p_key THEN
940:
941: SELECT list_header_id
942: -- , PAYMENT_TERM_ID
990: 'Load_Price_List'
991: );
992: END IF;
993:
994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
995:
996: END Load_Price_List;
997:
998: FUNCTION Load_Set_Of_Books
1016:
1017: -- Fix Bug 1910409: if operating unit changes, l_set_of_books
1018: -- would change therefore compare cached set of books to
1019: -- l_set_of_books and re-set the cache if changed.
1020: IF g_set_of_books_rec.set_of_books_id = FND_API.G_MISS_NUM
1021: OR (l_set_of_books_id <> g_set_of_books_rec.set_of_books_id)
1022: THEN
1023:
1024: SELECT SET_OF_BOOKS_ID
1049: 'Load_Set_Of_Books'
1050: );
1051: END IF;
1052:
1053: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1054:
1055: END Load_Set_Of_Books;
1056:
1057:
1068: end if;
1069:
1070: IF p_key1 IS NOT NULL THEN
1071:
1072: IF g_item_cost_rec.inventory_item_id = FND_API.G_MISS_NUM OR
1073: g_item_cost_rec.inventory_item_id <> p_key1 THEN
1074:
1075: SELECT INVENTORY_ITEM_ID
1076: , ORGANIZATION_ID
1114: 'Load_Item_Cost'
1115: );
1116: END IF;
1117:
1118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1119:
1120: END Load_Item_Cost;
1121:
1122:
1147: end if;
1148:
1149: IF p_key IS NOT NULL THEN
1150:
1151: IF g_header_rec.header_id = FND_API.G_MISS_NUM OR
1152: nvl(g_header_rec.header_id,0) <> p_key THEN
1153:
1154: OE_HEADER_UTIL.Query_Row(p_header_id => p_key,
1155: x_header_rec => g_header_rec);
1178: , 'Load_Order_Header'
1179: );
1180: END IF;
1181:
1182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1183:
1184: END Load_Order_Header;
1185:
1186:
1274: 'Load_header_discount'
1275: );
1276: END IF;
1277:
1278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1279:
1280: END load_header_discount;
1281:
1282:
1400: 'Load_Line_Discount'
1401: );
1402: END IF;
1403:
1404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1405:
1406: END load_line_discount;
1407:
1408: ------------------------------------------------------------
1471: , 'Load_Top_Model_Line'
1472: );
1473: END IF;
1474:
1475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1476:
1477: END Load_Top_Model_Line;
1478:
1479: ------------------------------------------------------------
1481: -- both as a function and as a procedure
1482: ------------------------------------------------------------
1483: FUNCTION Load_Item
1484: ( p_key1 IN NUMBER
1485: , p_key2 IN NUMBER := FND_API.G_MISS_NUM
1486: , p_key3 IN NUMBER DEFAULT NULL
1487: )
1488: RETURN Item_Rec_Type
1489: IS
1496: END Load_Item;
1497:
1498: PROCEDURE Load_Item
1499: ( p_key1 IN NUMBER
1500: , p_key2 IN NUMBER := FND_API.G_MISS_NUM
1501: , p_key3 IN NUMBER DEFAULT NULL
1502: )
1503: IS
1504: l_key2 NUMBER;
1542: end if;
1543:
1544: IF p_key1 IS NOT NULL THEN
1545:
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);
1671: please add the attributes here that needs to be loaded based on the
1672: ship_from_org_id */
1673:
1674: IF (p_key2 IS NOT NULL) AND
1675: (p_key2 <> FND_API.G_MISS_NUM) --AND
1676: -- (p_key2 <> l_key2 ) --added for bug 4171642 removed for bug 6666457
1677: THEN
1678:
1679: IF (g_item_rec.organization_id <> p_key2)
1809: 'Load_Item'
1810: );
1811: END IF;
1812:
1813: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1814:
1815: END Load_Item;
1816:
1817: FUNCTION Load_Set
1885: , 'Load_set '
1886: );
1887: END IF;
1888:
1889: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1890:
1891: END;
1892: --END IF;
1893:
1915: 'Load_Delivery_Set'
1916: );
1917: END IF;
1918:
1919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1920:
1921: END;
1922:
1923: -- added for bug 4200055
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
1938: g_Payment_Term_rec.term_id <> p_key THEN
1939: oe_debug_pub.add('querying oe_ra_terms_v');
1940: SELECT term_id ,
1941: name,
1974: 'Load_Payment_Term'
1975: );
1976: END IF;
1977:
1978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1979:
1980: END Load_Payment_Term;
1981:
1982: FUNCTION Load_Salesrep_rec
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
1995: g_Salesrep_rec.salesrep_id <> p_key THEN
1996: oe_debug_pub.add('Load Salesrep cache');
1997: SELECT salesrep_id ,
1998: name,
2031: 'Load_Salesrep_rec'
2032: );
2033: END IF;
2034:
2035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2036:
2037: END Load_Salesrep_rec;
2038:
2039: --end bug 4200055
2329: end if;
2330:
2331: IF p_key IS NOT NULL THEN
2332:
2333: IF g_Modifiers_Rec.list_line_id = FND_API.G_MISS_NUM OR
2334: g_Modifiers_Rec.list_line_id <> p_key THEN
2335:
2336: SELECT arithmetic_operator
2337: ,automatic_flag
2436: 'Load_list_lines'||sqlerrm
2437: );
2438: END IF;
2439:
2440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2441:
2442: END Load_List_Lines;
2443:
2444: Function Load_Cust_Trx_Type
2482: end if;
2483:
2484: IF p_key IS NOT NULL THEN
2485: /* Modified the If condition for Bug-2113379 */
2486: IF Nvl(g_cust_trx_rec.cust_trx_type_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM OR
2487: g_cust_trx_rec.cust_trx_type_id <> p_key OR
2488: g_cust_trx_rec.org_id <> l_current_org_id THEN --MOAC changes
2489:
2490: SELECT tax_calculation_flag
2517: 'Load_Cust_Trx_Type'
2518: );
2519: END IF;
2520:
2521: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2522: END Load_Cust_Trx_Type;
2523:
2524: FUNCTION get_tax_calculation_flag
2525: ( p_key IN NUMBER,
2620: 'get_tax_calculation_flag'
2621: );
2622: END IF;
2623:
2624: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2625: END get_tax_calculation_flag;
2626:
2627: FUNCTION IS_FLEX_ENABLED(p_flex_name IN VARCHAR2)
2628: RETURN VARCHAR2