[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);
1669: please add the attributes here that needs to be loaded based on the
1670: ship_from_org_id */
1671:
1672: IF (p_key2 IS NOT NULL) AND
1673: (p_key2 <> FND_API.G_MISS_NUM) --AND
1674: -- (p_key2 <> l_key2 ) --added for bug 4171642 removed for bug 6666457
1675: THEN
1676:
1677: IF (g_item_rec.organization_id <> p_key2)
1807: 'Load_Item'
1808: );
1809: END IF;
1810:
1811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1812:
1813: END Load_Item;
1814:
1815: FUNCTION Load_Set
1883: , 'Load_set '
1884: );
1885: END IF;
1886:
1887: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1888:
1889: END;
1890: --END IF;
1891:
1913: 'Load_Delivery_Set'
1914: );
1915: END IF;
1916:
1917: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1918:
1919: END;
1920:
1921: -- added for bug 4200055
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
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,
1972: 'Load_Payment_Term'
1973: );
1974: END IF;
1975:
1976: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1977:
1978: END Load_Payment_Term;
1979:
1980: FUNCTION Load_Salesrep_rec
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
1993: g_Salesrep_rec.salesrep_id <> p_key THEN
1994: oe_debug_pub.add('Load Salesrep cache');
1995: SELECT salesrep_id ,
1996: name,
2029: 'Load_Salesrep_rec'
2030: );
2031: END IF;
2032:
2033: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2034:
2035: END Load_Salesrep_rec;
2036:
2037: --end bug 4200055
2327: end if;
2328:
2329: IF p_key IS NOT NULL THEN
2330:
2331: IF g_Modifiers_Rec.list_line_id = FND_API.G_MISS_NUM OR
2332: g_Modifiers_Rec.list_line_id <> p_key THEN
2333:
2334: SELECT arithmetic_operator
2335: ,automatic_flag
2434: 'Load_list_lines'||sqlerrm
2435: );
2436: END IF;
2437:
2438: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2439:
2440: END Load_List_Lines;
2441:
2442: Function Load_Cust_Trx_Type
2480: end if;
2481:
2482: IF p_key IS NOT NULL THEN
2483: /* Modified the If condition for Bug-2113379 */
2484: IF Nvl(g_cust_trx_rec.cust_trx_type_id,FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM OR
2485: g_cust_trx_rec.cust_trx_type_id <> p_key OR
2486: g_cust_trx_rec.org_id <> l_current_org_id THEN --MOAC changes
2487:
2488: SELECT tax_calculation_flag
2515: 'Load_Cust_Trx_Type'
2516: );
2517: END IF;
2518:
2519: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2520: END Load_Cust_Trx_Type;
2521:
2522: FUNCTION get_tax_calculation_flag
2523: ( p_key IN NUMBER,
2618: 'get_tax_calculation_flag'
2619: );
2620: END IF;
2621:
2622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2623: END get_tax_calculation_flag;
2624:
2625: FUNCTION IS_FLEX_ENABLED(p_flex_name IN VARCHAR2)
2626: RETURN VARCHAR2