[Home] [Help]
122: -- Fix bug 1262790
123: -- Ship To and Payment Term required on ORDER lines,
124: -- NOT on RETURN lines
125:
126: IF p_line_rec.line_category_code <> OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
127:
128: IF p_line_rec.ship_to_org_id IS NULL THEN
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_LINE_ATTRIBUTE');
145:
146:
147: -- Warehouse and schedule date required on RETURN lines
148:
149: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
150:
151: IF p_line_rec.ship_from_org_id IS NULL THEN
152: x_return_status := FND_API.G_RET_STS_ERROR;
153: FND_MESSAGE.SET_NAME('ONT','OE_BOOK_REQD_RETURN_ATTRIBUTE');
383: BEGIN
384:
385: OE_DEBUG_PUB.Add('Entering OE_CNCL_VALIDATE_LINE.Validate_Line_Type',1);
386:
387: IF p_line_rec.ITEM_TYPE_CODE = OE_GLOBALS.G_ITEM_CONFIG THEN
388:
389: l_new_wf_item_type := OE_Order_WF_Util.get_wf_item_type(p_line_rec);
390:
391: OPEN Get_Order_Type;
477: oe_debug_pub.add('Entering Validate_Item_Warehouse',1);
478: -- The customer_order_enabled_flag for config item
479: -- is set to 'N'
480:
481: IF p_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR
482: p_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
483: p_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
484: p_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
485: (p_item_type_code = OE_GLOBALS.G_ITEM_KIT AND
478: -- The customer_order_enabled_flag for config item
479: -- is set to 'N'
480:
481: IF p_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR
482: p_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
483: p_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
484: p_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
485: (p_item_type_code = OE_GLOBALS.G_ITEM_KIT AND
486: nvl(p_top_model_line_id, -1) <> p_line_id)
479: -- is set to 'N'
480:
481: IF p_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR
482: p_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
483: p_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
484: p_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
485: (p_item_type_code = OE_GLOBALS.G_ITEM_KIT AND
486: nvl(p_top_model_line_id, -1) <> p_line_id)
487: THEN
480:
481: IF p_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR
482: p_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
483: p_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
484: p_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
485: (p_item_type_code = OE_GLOBALS.G_ITEM_KIT AND
486: nvl(p_top_model_line_id, -1) <> p_line_id)
487: THEN
488: SELECT null
481: IF p_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR
482: p_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
483: p_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
484: p_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
485: (p_item_type_code = OE_GLOBALS.G_ITEM_KIT AND
486: nvl(p_top_model_line_id, -1) <> p_line_id)
487: THEN
488: SELECT null
489: INTO l_dummy
1031: BEGIN
1032:
1033: oe_debug_pub.add('entering validate_source_type', 3);
1034:
1035: IF OE_GLOBALS.Equal(p_line_rec.source_type_code,
1036: OE_GLOBALS.G_SOURCE_EXTERNAL) THEN
1037:
1038: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110508'
1039: THEN
1032:
1033: oe_debug_pub.add('entering validate_source_type', 3);
1034:
1035: IF OE_GLOBALS.Equal(p_line_rec.source_type_code,
1036: OE_GLOBALS.G_SOURCE_EXTERNAL) THEN
1037:
1038: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110508'
1039: THEN
1040: IF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
1036: OE_GLOBALS.G_SOURCE_EXTERNAL) THEN
1037:
1038: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110508'
1039: THEN
1040: IF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE OR
1041: p_line_rec.ship_model_complete_flag = 'Y'
1042: THEN
1043: oe_debug_pub.add('servie / part of smc model', 4);
1044: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_VALID_ITEM');
1049: ELSE
1050: oe_debug_pub.add('validate line: pack H new logic DS', 1);
1051: END IF;
1052: ELSE
1053: IF (p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_STANDARD) THEN
1054: oe_debug_pub.add('Cannot dropship non-standard item',2);
1055: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ALLOWED');
1056: OE_MSG_PUB.Add;
1057: x_return_status := FND_API.G_RET_STS_ERROR;
1274: --------------------------------------------------------------
1275:
1276: -- For return lines, Return_Reason_Code is required
1277: oe_debug_pub.add('5 '||l_return_status, 1);
1278: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE
1279: and p_line_rec.return_reason_code is NULL
1280: THEN
1281: l_return_status := FND_API.G_RET_STS_ERROR;
1282:
1500: THEN */
1501:
1502:
1503:
1504: IF p_line_rec.source_type_code = OE_GLOBALS.G_SOURCE_INTERNAL
1505: or p_line_rec.source_type_code is null
1506: THEN
1507: oe_debug_pub.add('Source Type is Internal',1);
1508:
1643: -- end decimal quantity validation
1644:
1645:
1646: -- Error if reserved quantity > ordered quantity
1647: /* IF NOT OE_GLOBALS.Equal(p_line_rec.reserved_quantity,p_old_line_rec.reserved_quantity)
1648: THEN
1649:
1650: IF (p_line_rec.reserved_quantity > p_line_rec.ordered_quantity) THEN
1651: fnd_message.set_name('ONT','OE_SCH_RES_MORE_ORD_QTY');
1660: -- and Schedule Arrival Date. This is not allowed. The user can change
1661: -- either one, but not both.
1662:
1663: /*
1664: IF (NOT OE_GLOBALS.Equal(p_line_rec.schedule_ship_date,
1665: p_old_line_rec.schedule_ship_date)) AND
1666: (NOT OE_GLOBALS.Equal(p_line_rec.schedule_arrival_date,
1667: p_old_line_rec.schedule_arrival_date)) AND
1668: (OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING = 'Y') THEN
1662:
1663: /*
1664: IF (NOT OE_GLOBALS.Equal(p_line_rec.schedule_ship_date,
1665: p_old_line_rec.schedule_ship_date)) AND
1666: (NOT OE_GLOBALS.Equal(p_line_rec.schedule_arrival_date,
1667: p_old_line_rec.schedule_arrival_date)) AND
1668: (OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING = 'Y') THEN
1669:
1670: -- Config item is created and passed by the CTO team. So this is
1671: -- is the only item type, which when gets created, already has
1672: -- Schedule_Ship_Date and schedule_Arrival_date. We should not
1673: -- error out for this item.
1674:
1675: IF p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN
1676: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INVALID_CHANGE');
1677: OE_MSG_PUB.Add;
1678: l_return_status := FND_API.G_RET_STS_ERROR;
1679: END IF;
1845: -- Model.
1846:
1847: oe_debug_pub.add('11 '||l_return_status, 1);
1848:
1849: /*IF p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1850:
1851: IF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1852: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS)
1853: --AND p_line_rec.line_id <> p_line_rec.ato_line_id
1847: oe_debug_pub.add('11 '||l_return_status, 1);
1848:
1849: /*IF p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1850:
1851: IF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1852: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS)
1853: --AND p_line_rec.line_id <> p_line_rec.ato_line_id
1854: THEN
1855:
1848:
1849: /*IF p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1850:
1851: IF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1852: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS)
1853: --AND p_line_rec.line_id <> p_line_rec.ato_line_id
1854: THEN
1855:
1856: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_PROJ_UPD');
1882: END IF;
1883:
1884: oe_debug_pub.add('12 '||l_return_status, 1);
1885: -- Validate if return item and item on referenced sales order line mismatch
1886: IF (p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE and
1887: p_line_rec.reference_line_id is not null and
1888: p_line_rec.inventory_item_id IS NOT NULL)
1889: THEN
1890: IF NOT Validate_Return_Item_Mismatch
1900:
1901: oe_debug_pub.add('13 '||l_return_status, 1);
1902:
1903: -- Validate if returning a fulfilled sales order line
1904: IF (p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE and
1905: p_line_rec.reference_line_id is not null)
1906: THEN
1907: IF NOT Validate_Return_Fulfilled_Line
1908: ( p_line_rec.reference_line_id
1917:
1918: oe_debug_pub.add('14 '||l_return_status, 1);
1919:
1920: -- Validate if item on the Return is Returnable
1921: IF (p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE and
1922: p_line_rec.inventory_item_id IS NOT NULL)
1923: THEN
1924: IF NOT Validate_Return_Item(p_line_rec.inventory_item_id,
1925: p_line_rec.ship_from_org_id)
1933:
1934: oe_debug_pub.add('14_1 '||l_return_status, 1);
1935:
1936: -- Validate if Reference SO Line is Valid
1937: IF (p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE and
1938: p_line_rec.reference_line_id is not null)
1939: THEN
1940: IF NOT Validate_Return_Reference(p_line_rec.reference_line_id)
1941: THEN
1946:
1947: oe_debug_pub.add('14_2 '||l_return_status, 1);
1948:
1949: -- Validate the quantity = 1 on RMA for Serial Number reference
1950: IF (p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE and
1951: p_line_rec.reference_line_id is not null and
1952: p_line_rec.return_context = 'SERIAL' and
1953: NVL(p_line_rec.ordered_quantity,1) <> 1)
1954: THEN
2416: IF p_line_rec.order_quantity_uom is not null
2417:
2418: THEN
2419:
2420: IF ( p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
2421: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
2422: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION ) THEN
2423: BEGIN
2424: SELECT primary_uom_code
2417:
2418: THEN
2419:
2420: IF ( p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
2421: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
2422: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION ) THEN
2423: BEGIN
2424: SELECT primary_uom_code
2425: INTO l_uom
2418: THEN
2419:
2420: IF ( p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
2421: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
2422: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION ) THEN
2423: BEGIN
2424: SELECT primary_uom_code
2425: INTO l_uom
2426: FROM mtl_system_items
2486: END IF;
2487: END IF;
2488:
2489: If p_line_rec.agreement_id is not null and
2490: NOT OE_GLOBALS.EQUAL(p_line_rec.agreement_id, fnd_api.g_miss_num) then
2491: If not oe_globals.equal(p_line_rec.agreement_id,null) then
2492:
2493: -- Check for Agreement +sold_org_id
2494:
2487: END IF;
2488:
2489: If p_line_rec.agreement_id is not null and
2490: NOT OE_GLOBALS.EQUAL(p_line_rec.agreement_id, fnd_api.g_miss_num) then
2491: If not oe_globals.equal(p_line_rec.agreement_id,null) then
2492:
2493: -- Check for Agreement +sold_org_id
2494:
2495: -- Where cluase added to check start and end date for agreements
2514: null;
2515: END;
2516:
2517:
2518: IF NOT OE_GLOBALS.EQUAL(l_list_type_code,'PRL') THEN
2519: -- any price list with 'PRL' type should be allowed to
2520: -- be associated with any agreement according to bug 1386406.
2521: IF NOT OE_GLOBALS.EQUAL(l_price_list_id, p_line_rec.price_list_id) THEN
2522: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
2517:
2518: IF NOT OE_GLOBALS.EQUAL(l_list_type_code,'PRL') THEN
2519: -- any price list with 'PRL' type should be allowed to
2520: -- be associated with any agreement according to bug 1386406.
2521: IF NOT OE_GLOBALS.EQUAL(l_price_list_id, p_line_rec.price_list_id) THEN
2522: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
2523: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
2524: BEGIN
2525: SELECT name
2550:
2551:
2552: -- modified by lkxu, to check for customer relationships.
2553: IF l_sold_to_org IS NOT NULL AND l_sold_to_org <> -1
2554: AND NOT OE_GLOBALS.EQUAL(l_sold_to_org,p_line_rec.sold_to_org_id) THEN
2555: IF nvl(lcustomer_relations,'N') = 'N' THEN
2556: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
2557: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
2558: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
2604: END IF; -- Agreement has changed
2605:
2606: ELSE
2607:
2608: /*IF NOT oe_globals.equal(p_line_rec.pricing_date,p_old_line_rec.pricing_date) OR
2609: not oe_globals.equal(p_line_rec.price_list_id,p_old_line_rec.price_list_id) THEN*/
2610:
2611:
2612: -- Allow only the non agreement price_lists
2605:
2606: ELSE
2607:
2608: /*IF NOT oe_globals.equal(p_line_rec.pricing_date,p_old_line_rec.pricing_date) OR
2609: not oe_globals.equal(p_line_rec.price_list_id,p_old_line_rec.price_list_id) THEN*/
2610:
2611:
2612: -- Allow only the non agreement price_lists
2613: BEGIN
2639: -- Line number validation.
2640: -- Allow line number updates only on Model, Standard, Kit,
2641: --and stand alone service line.
2642:
2643: /*IF p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2644:
2645: IF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION) OR
2646: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS) OR
2647: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT) OR
2641: --and stand alone service line.
2642:
2643: /*IF p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2644:
2645: IF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION) OR
2646: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS) OR
2647: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT) OR
2648: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE AND
2649: p_line_rec.service_reference_line_id IS NOT NULL AND
2642:
2643: /*IF p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2644:
2645: IF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION) OR
2646: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS) OR
2647: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT) OR
2648: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE AND
2649: p_line_rec.service_reference_line_id IS NOT NULL AND
2650: p_line_rec.service_reference_line_id <> FND_API.G_MISS_NUM)
2643: /*IF p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2644:
2645: IF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION) OR
2646: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS) OR
2647: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT) OR
2648: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE AND
2649: p_line_rec.service_reference_line_id IS NOT NULL AND
2650: p_line_rec.service_reference_line_id <> FND_API.G_MISS_NUM)
2651:
2644:
2645: IF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION) OR
2646: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS) OR
2647: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT) OR
2648: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE AND
2649: p_line_rec.service_reference_line_id IS NOT NULL AND
2650: p_line_rec.service_reference_line_id <> FND_API.G_MISS_NUM)
2651:
2652: THEN
2650: p_line_rec.service_reference_line_id <> FND_API.G_MISS_NUM)
2651:
2652: THEN
2653:
2654: IF (NOT OE_GLOBALS.EQUAL(p_line_rec.line_number,null)) THEN
2655:
2656: l_return_status := FND_API.G_RET_STS_ERROR;
2657: fnd_message.set_name('ONT', 'OE_LINE_NUMBER_UPD');
2658: OE_MSG_PUB.add;
2665:
2666: oe_debug_pub.add('16 '||l_return_status ,1);
2667:
2668: /*IF p_line_rec.top_model_line_id is not null AND
2669: p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
2670: p_line_rec.ordered_quantity = 0
2671: THEN
2672: oe_debug_pub.add
2673: ('qty of a configuration related line 0'|| p_line_rec.item_type_code, 1);
2792:
2793: IF p_x_line_rec.accounting_rule_id IS NOT NULL
2794: THEN
2795: IF NOT OE_CNCL_Validate.Accounting_Rule(p_x_line_rec.accounting_rule_id) THEN
2796: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2797: p_x_line_rec.accounting_rule_id := NULL;
2798: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2799: p_x_line_rec.accounting_rule_id := FND_API.G_MISS_NUM;
2800: ELSE
2794: THEN
2795: IF NOT OE_CNCL_Validate.Accounting_Rule(p_x_line_rec.accounting_rule_id) THEN
2796: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2797: p_x_line_rec.accounting_rule_id := NULL;
2798: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2799: p_x_line_rec.accounting_rule_id := FND_API.G_MISS_NUM;
2800: ELSE
2801: x_return_status := FND_API.G_RET_STS_ERROR;
2802: END IF;
2805:
2806: IF p_x_line_rec.agreement_id IS NOT NULL
2807: THEN
2808: IF NOT OE_CNCL_Validate.Agreement(p_x_line_rec.agreement_id) THEN
2809: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2810: p_x_line_rec.agreement_id := NULL;
2811: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2812: p_x_line_rec.agreement_id := FND_API.G_MISS_NUM;
2813: ELSE
2807: THEN
2808: IF NOT OE_CNCL_Validate.Agreement(p_x_line_rec.agreement_id) THEN
2809: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2810: p_x_line_rec.agreement_id := NULL;
2811: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2812: p_x_line_rec.agreement_id := FND_API.G_MISS_NUM;
2813: ELSE
2814: x_return_status := FND_API.G_RET_STS_ERROR;
2815: END IF;
2819:
2820: IF p_x_line_rec.deliver_to_contact_id IS NOT NULL
2821: THEN
2822: IF NOT OE_CNCL_Validate.Deliver_To_Contact(p_x_line_rec.deliver_to_contact_id) THEN
2823: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2824: p_x_line_rec.deliver_to_contact_id := NULL;
2825: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2826: p_x_line_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
2827: ELSE
2821: THEN
2822: IF NOT OE_CNCL_Validate.Deliver_To_Contact(p_x_line_rec.deliver_to_contact_id) THEN
2823: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2824: p_x_line_rec.deliver_to_contact_id := NULL;
2825: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2826: p_x_line_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
2827: ELSE
2828: x_return_status := FND_API.G_RET_STS_ERROR;
2829: END IF;
2832:
2833: IF p_x_line_rec.deliver_to_org_id IS NOT NULL
2834: THEN
2835: IF NOT OE_CNCL_Validate.Deliver_To_Org(p_x_line_rec.deliver_to_org_id) THEN
2836: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2837: p_x_line_rec.deliver_to_org_id := NULL;
2838: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2839: p_x_line_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
2840: ELSE
2834: THEN
2835: IF NOT OE_CNCL_Validate.Deliver_To_Org(p_x_line_rec.deliver_to_org_id) THEN
2836: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2837: p_x_line_rec.deliver_to_org_id := NULL;
2838: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2839: p_x_line_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
2840: ELSE
2841: x_return_status := FND_API.G_RET_STS_ERROR;
2842: END IF;
2845:
2846: IF p_x_line_rec.demand_class_code IS NOT NULL
2847: THEN
2848: IF NOT OE_CNCL_Validate.Demand_Class(p_x_line_rec.demand_class_code) THEN
2849: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2850: p_x_line_rec.demand_class_code := NULL;
2851: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2852: p_x_line_rec.demand_class_code := FND_API.G_MISS_CHAR;
2853: ELSE
2847: THEN
2848: IF NOT OE_CNCL_Validate.Demand_Class(p_x_line_rec.demand_class_code) THEN
2849: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2850: p_x_line_rec.demand_class_code := NULL;
2851: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2852: p_x_line_rec.demand_class_code := FND_API.G_MISS_CHAR;
2853: ELSE
2854: x_return_status := FND_API.G_RET_STS_ERROR;
2855: END IF;
2858:
2859: IF p_x_line_rec.dep_plan_required_flag IS NOT NULL
2860: THEN
2861: IF NOT OE_CNCL_Validate.Dep_Plan_Required(p_x_line_rec.dep_plan_required_flag) THEN
2862: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2863: p_x_line_rec.dep_plan_required_flag := NULL;
2864: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2865: p_x_line_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
2866: ELSE
2860: THEN
2861: IF NOT OE_CNCL_Validate.Dep_Plan_Required(p_x_line_rec.dep_plan_required_flag) THEN
2862: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2863: p_x_line_rec.dep_plan_required_flag := NULL;
2864: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2865: p_x_line_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
2866: ELSE
2867: x_return_status := FND_API.G_RET_STS_ERROR;
2868: END IF;
2871:
2872: IF p_x_line_rec.end_item_unit_number IS NOT NULL
2873: THEN
2874: IF NOT OE_CNCL_Validate.End_Item_Unit_Number(p_x_line_rec.end_item_unit_number) THEN
2875: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2876: p_x_line_rec.end_item_unit_number := NULL;
2877: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2878: p_x_line_rec.end_item_unit_number := FND_API.G_MISS_CHAR;
2879: ELSE
2873: THEN
2874: IF NOT OE_CNCL_Validate.End_Item_Unit_Number(p_x_line_rec.end_item_unit_number) THEN
2875: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2876: p_x_line_rec.end_item_unit_number := NULL;
2877: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2878: p_x_line_rec.end_item_unit_number := FND_API.G_MISS_CHAR;
2879: ELSE
2880: x_return_status := FND_API.G_RET_STS_ERROR;
2881: END IF;
2884:
2885: IF p_x_line_rec.fob_point_code IS NOT NULL
2886: THEN
2887: IF NOT OE_CNCL_Validate.Fob_Point(p_x_line_rec.fob_point_code) THEN
2888: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2889: p_x_line_rec.fob_point_code := NULL;
2890: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2891: p_x_line_rec.fob_point_code := FND_API.G_MISS_CHAR;
2892: ELSE
2886: THEN
2887: IF NOT OE_CNCL_Validate.Fob_Point(p_x_line_rec.fob_point_code) THEN
2888: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2889: p_x_line_rec.fob_point_code := NULL;
2890: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2891: p_x_line_rec.fob_point_code := FND_API.G_MISS_CHAR;
2892: ELSE
2893: x_return_status := FND_API.G_RET_STS_ERROR;
2894: END IF;
2897:
2898: IF p_x_line_rec.freight_terms_code IS NOT NULL
2899: THEN
2900: IF NOT OE_CNCL_Validate.Freight_Terms(p_x_line_rec.freight_terms_code) THEN
2901: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2902: p_x_line_rec.freight_terms_code := NULL;
2903: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2904: p_x_line_rec.freight_terms_code := FND_API.G_MISS_CHAR;
2905: ELSE
2899: THEN
2900: IF NOT OE_CNCL_Validate.Freight_Terms(p_x_line_rec.freight_terms_code) THEN
2901: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2902: p_x_line_rec.freight_terms_code := NULL;
2903: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2904: p_x_line_rec.freight_terms_code := FND_API.G_MISS_CHAR;
2905: ELSE
2906: x_return_status := FND_API.G_RET_STS_ERROR;
2907: END IF;
2910:
2911: IF p_x_line_rec.invoice_to_contact_id IS NOT NULL
2912: THEN
2913: IF NOT OE_CNCL_Validate.Invoice_To_Contact(p_x_line_rec.invoice_to_contact_id) THEN
2914: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2915: p_x_line_rec.invoice_to_contact_id := NULL;
2916: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2917: p_x_line_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
2918: ELSE
2912: THEN
2913: IF NOT OE_CNCL_Validate.Invoice_To_Contact(p_x_line_rec.invoice_to_contact_id) THEN
2914: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2915: p_x_line_rec.invoice_to_contact_id := NULL;
2916: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2917: p_x_line_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
2918: ELSE
2919: x_return_status := FND_API.G_RET_STS_ERROR;
2920: END IF;
2923:
2924: IF p_x_line_rec.invoice_to_org_id IS NOT NULL
2925: THEN
2926: IF NOT OE_CNCL_Validate.Invoice_To_Org(p_x_line_rec.invoice_to_org_id) THEN
2927: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2928: p_x_line_rec.invoice_to_org_id := NULL;
2929: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2930: p_x_line_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
2931: ELSE
2925: THEN
2926: IF NOT OE_CNCL_Validate.Invoice_To_Org(p_x_line_rec.invoice_to_org_id) THEN
2927: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2928: p_x_line_rec.invoice_to_org_id := NULL;
2929: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2930: p_x_line_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
2931: ELSE
2932: x_return_status := FND_API.G_RET_STS_ERROR;
2933: END IF;
2936:
2937: IF p_x_line_rec.invoicing_rule_id IS NOT NULL
2938: THEN
2939: IF NOT OE_CNCL_Validate.Invoicing_Rule(p_x_line_rec.invoicing_rule_id) THEN
2940: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2941: p_x_line_rec.invoicing_rule_id := NULL;
2942: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2943: p_x_line_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
2944: ELSE
2938: THEN
2939: IF NOT OE_CNCL_Validate.Invoicing_Rule(p_x_line_rec.invoicing_rule_id) THEN
2940: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2941: p_x_line_rec.invoicing_rule_id := NULL;
2942: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2943: p_x_line_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
2944: ELSE
2945: x_return_status := FND_API.G_RET_STS_ERROR;
2946: END IF;
2951: IF p_x_line_rec.Ib_owner IS NOT NULL
2952: THEN
2953: IF NOT OE_CNCL_Validate.IB_OWNER(p_x_line_rec.Ib_owner) THEN
2954:
2955: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2956: p_x_line_rec.Ib_owner := NULL;
2957: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
2958: THEN
2959: p_x_line_rec.Ib_Owner := FND_API.G_MISS_CHAR;
2953: IF NOT OE_CNCL_Validate.IB_OWNER(p_x_line_rec.Ib_owner) THEN
2954:
2955: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2956: p_x_line_rec.Ib_owner := NULL;
2957: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
2958: THEN
2959: p_x_line_rec.Ib_Owner := FND_API.G_MISS_CHAR;
2960: ELSE
2961: x_return_status := FND_API.G_RET_STS_ERROR;
2965:
2966: IF p_x_line_rec.Ib_installed_at_location IS NOT NULL
2967: THEN
2968: IF NOT OE_CNCL_Validate.IB_INSTALLED_AT_LOCATION(p_x_line_rec.Ib_installed_at_location) THEN
2969: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
2970: THEN
2971: p_x_line_rec.Ib_installed_at_location := NULL;
2972: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
2973: THEN
2968: IF NOT OE_CNCL_Validate.IB_INSTALLED_AT_LOCATION(p_x_line_rec.Ib_installed_at_location) THEN
2969: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
2970: THEN
2971: p_x_line_rec.Ib_installed_at_location := NULL;
2972: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
2973: THEN
2974: p_x_line_rec.Ib_installed_at_location := FND_API.G_MISS_CHAR;
2975: ELSE
2976: x_return_status := FND_API.G_RET_STS_ERROR;
2982: IF p_x_line_rec.Ib_current_location IS NOT NULL
2983: THEN
2984:
2985: IF NOT OE_CNCL_Validate.IB_CURRENT_LOCATION(p_x_line_rec.ib_current_location) THEN
2986: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
2987: THEN
2988: p_x_line_rec.Ib_current_location := NULL;
2989: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
2990: THEN
2985: IF NOT OE_CNCL_Validate.IB_CURRENT_LOCATION(p_x_line_rec.ib_current_location) THEN
2986: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
2987: THEN
2988: p_x_line_rec.Ib_current_location := NULL;
2989: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
2990: THEN
2991: p_x_line_rec.Ib_current_location := FND_API.G_MISS_CHAR;
2992: ELSE
2993: x_return_status := FND_API.G_RET_STS_ERROR;
2998:
2999: IF p_x_line_rec.End_customer_id IS NOT NULL THEN
3000:
3001: IF NOT OE_CNCL_Validate.END_CUSTOMER(p_x_line_rec.End_customer_id) THEN
3002: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
3003: THEN
3004: p_x_line_rec.End_customer_id := NULL;
3005: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
3006: THEN
3001: IF NOT OE_CNCL_Validate.END_CUSTOMER(p_x_line_rec.End_customer_id) THEN
3002: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
3003: THEN
3004: p_x_line_rec.End_customer_id := NULL;
3005: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
3006: THEN
3007: p_x_line_rec.End_customer_id := FND_API.G_MISS_NUM;
3008: ELSE
3009: x_return_status := FND_API.G_RET_STS_ERROR;
3016:
3017: IF p_x_line_rec.End_customer_contact_id IS NOT NULL THEN
3018:
3019: IF NOT OE_CNCL_Validate.END_CUSTOMER_CONTACT(p_x_line_rec.End_customer_contact_id) THEN
3020: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
3021: THEN
3022: p_x_line_rec.End_customer_contact_id := NULL;
3023: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
3024: THEN
3019: IF NOT OE_CNCL_Validate.END_CUSTOMER_CONTACT(p_x_line_rec.End_customer_contact_id) THEN
3020: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
3021: THEN
3022: p_x_line_rec.End_customer_contact_id := NULL;
3023: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
3024: THEN
3025: p_x_line_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
3026: ELSE
3027: x_return_status := FND_API.G_RET_STS_ERROR;
3031:
3032: IF p_x_line_rec.End_customer_site_use_id IS NOT NULL
3033: THEN
3034: IF NOT OE_CNCL_Validate.END_CUSTOMER_SITE_USE(p_x_line_rec.End_customer_site_use_id) THEN
3035: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
3036: THEN
3037: p_x_line_rec.End_customer_site_use_id := NULL;
3038: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
3039: THEN
3034: IF NOT OE_CNCL_Validate.END_CUSTOMER_SITE_USE(p_x_line_rec.End_customer_site_use_id) THEN
3035: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
3036: THEN
3037: p_x_line_rec.End_customer_site_use_id := NULL;
3038: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
3039: THEN
3040: p_x_line_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
3041: ELSE
3042: x_return_status := FND_API.G_RET_STS_ERROR;
3047:
3048: IF p_x_line_rec.item_type_code IS NOT NULL
3049: THEN
3050: IF NOT OE_CNCL_Validate.Item_Type(p_x_line_rec.item_type_code) THEN
3051: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3052: p_x_line_rec.item_type_code := NULL;
3053: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3054: p_x_line_rec.item_type_code := FND_API.G_MISS_CHAR;
3055: ELSE
3049: THEN
3050: IF NOT OE_CNCL_Validate.Item_Type(p_x_line_rec.item_type_code) THEN
3051: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3052: p_x_line_rec.item_type_code := NULL;
3053: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3054: p_x_line_rec.item_type_code := FND_API.G_MISS_CHAR;
3055: ELSE
3056: x_return_status := FND_API.G_RET_STS_ERROR;
3057: END IF;
3060:
3061: IF p_x_line_rec.payment_term_id IS NOT NULL
3062: THEN
3063: IF NOT OE_CNCL_Validate.Payment_Term(p_x_line_rec.payment_term_id) THEN
3064: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3065: p_x_line_rec.payment_term_id := NULL;
3066: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3067: p_x_line_rec.payment_term_id := FND_API.G_MISS_NUM;
3068: ELSE
3062: THEN
3063: IF NOT OE_CNCL_Validate.Payment_Term(p_x_line_rec.payment_term_id) THEN
3064: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3065: p_x_line_rec.payment_term_id := NULL;
3066: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3067: p_x_line_rec.payment_term_id := FND_API.G_MISS_NUM;
3068: ELSE
3069: x_return_status := FND_API.G_RET_STS_ERROR;
3070: END IF;
3073:
3074: IF p_x_line_rec.price_list_id IS NOT NULL
3075: THEN
3076: IF NOT OE_CNCL_Validate.Price_List(p_x_line_rec.price_list_id) THEN
3077: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3078: p_x_line_rec.price_list_id := NULL;
3079: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3080: p_x_line_rec.price_list_id := FND_API.G_MISS_NUM;
3081: ELSE
3075: THEN
3076: IF NOT OE_CNCL_Validate.Price_List(p_x_line_rec.price_list_id) THEN
3077: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3078: p_x_line_rec.price_list_id := NULL;
3079: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3080: p_x_line_rec.price_list_id := FND_API.G_MISS_NUM;
3081: ELSE
3082: x_return_status := FND_API.G_RET_STS_ERROR;
3083: END IF;
3086:
3087: IF p_x_line_rec.project_id IS NOT NULL
3088: THEN
3089: IF NOT OE_CNCL_Validate.Project(p_x_line_rec.project_id) THEN
3090: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3091: p_x_line_rec.project_id := NULL;
3092: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3093: p_x_line_rec.project_id := FND_API.G_MISS_NUM;
3094: ELSE
3088: THEN
3089: IF NOT OE_CNCL_Validate.Project(p_x_line_rec.project_id) THEN
3090: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3091: p_x_line_rec.project_id := NULL;
3092: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3093: p_x_line_rec.project_id := FND_API.G_MISS_NUM;
3094: ELSE
3095: x_return_status := FND_API.G_RET_STS_ERROR;
3096: END IF;
3099:
3100: IF p_x_line_rec.shipment_priority_code IS NOT NULL
3101: THEN
3102: IF NOT OE_CNCL_Validate.Shipment_Priority(p_x_line_rec.shipment_priority_code) THEN
3103: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3104: p_x_line_rec.shipment_priority_code := NULL;
3105: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3106: p_x_line_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
3107: ELSE
3101: THEN
3102: IF NOT OE_CNCL_Validate.Shipment_Priority(p_x_line_rec.shipment_priority_code) THEN
3103: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3104: p_x_line_rec.shipment_priority_code := NULL;
3105: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3106: p_x_line_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
3107: ELSE
3108: x_return_status := FND_API.G_RET_STS_ERROR;
3109: END IF;
3112:
3113: IF p_x_line_rec.shipping_method_code IS NOT NULL
3114: THEN
3115: IF NOT OE_CNCL_Validate.Shipping_Method(p_x_line_rec.shipping_method_code) THEN
3116: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3117: p_x_line_rec.shipping_method_code := NULL;
3118: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3119: p_x_line_rec.shipping_method_code := FND_API.G_MISS_CHAR;
3120: ELSE
3114: THEN
3115: IF NOT OE_CNCL_Validate.Shipping_Method(p_x_line_rec.shipping_method_code) THEN
3116: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3117: p_x_line_rec.shipping_method_code := NULL;
3118: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3119: p_x_line_rec.shipping_method_code := FND_API.G_MISS_CHAR;
3120: ELSE
3121: x_return_status := FND_API.G_RET_STS_ERROR;
3122: END IF;
3125:
3126: IF p_x_line_rec.ship_from_org_id IS NOT NULL
3127: THEN
3128: IF NOT OE_CNCL_Validate.Ship_From_Org(p_x_line_rec.ship_from_org_id) THEN
3129: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3130: p_x_line_rec.ship_from_org_id := NULL;
3131: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3132: p_x_line_rec.ship_from_org_id := FND_API.G_MISS_NUM;
3133: ELSE
3127: THEN
3128: IF NOT OE_CNCL_Validate.Ship_From_Org(p_x_line_rec.ship_from_org_id) THEN
3129: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3130: p_x_line_rec.ship_from_org_id := NULL;
3131: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3132: p_x_line_rec.ship_from_org_id := FND_API.G_MISS_NUM;
3133: ELSE
3134: x_return_status := FND_API.G_RET_STS_ERROR;
3135: END IF;
3138:
3139: IF p_x_line_rec.shipping_interfaced_flag IS NOT NULL
3140: THEN
3141: IF NOT OE_CNCL_Validate.Shipping_Interfaced(p_x_line_rec.shipping_interfaced_flag) THEN
3142: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3143: p_x_line_rec.shipping_interfaced_flag := NULL;
3144: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3145: p_x_line_rec.shipping_interfaced_flag := FND_API.G_MISS_CHAR;
3146: ELSE
3140: THEN
3141: IF NOT OE_CNCL_Validate.Shipping_Interfaced(p_x_line_rec.shipping_interfaced_flag) THEN
3142: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3143: p_x_line_rec.shipping_interfaced_flag := NULL;
3144: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3145: p_x_line_rec.shipping_interfaced_flag := FND_API.G_MISS_CHAR;
3146: ELSE
3147: x_return_status := FND_API.G_RET_STS_ERROR;
3148: END IF;
3151:
3152: IF p_x_line_rec.shippable_flag IS NOT NULL
3153: THEN
3154: IF NOT OE_CNCL_Validate.shippable(p_x_line_rec.shippable_flag) THEN
3155: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3156: p_x_line_rec.shippable_flag := NULL;
3157: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3158: p_x_line_rec.shippable_flag := FND_API.G_MISS_CHAR;
3159: ELSE
3153: THEN
3154: IF NOT OE_CNCL_Validate.shippable(p_x_line_rec.shippable_flag) THEN
3155: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3156: p_x_line_rec.shippable_flag := NULL;
3157: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3158: p_x_line_rec.shippable_flag := FND_API.G_MISS_CHAR;
3159: ELSE
3160: x_return_status := FND_API.G_RET_STS_ERROR;
3161: END IF;
3164:
3165: IF p_x_line_rec.ship_to_contact_id IS NOT NULL
3166: THEN
3167: IF NOT OE_CNCL_Validate.Ship_To_Contact(p_x_line_rec.ship_to_contact_id) THEN
3168: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3169: p_x_line_rec.ship_to_contact_id := NULL;
3170: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3171: p_x_line_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
3172: ELSE
3166: THEN
3167: IF NOT OE_CNCL_Validate.Ship_To_Contact(p_x_line_rec.ship_to_contact_id) THEN
3168: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3169: p_x_line_rec.ship_to_contact_id := NULL;
3170: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3171: p_x_line_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
3172: ELSE
3173: x_return_status := FND_API.G_RET_STS_ERROR;
3174: END IF;
3177:
3178: IF p_x_line_rec.ship_to_org_id IS NOT NULL
3179: THEN
3180: IF NOT OE_CNCL_Validate.Ship_To_Org(p_x_line_rec.ship_to_org_id) THEN
3181: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3182: p_x_line_rec.ship_to_org_id := NULL;
3183: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3184: p_x_line_rec.ship_to_org_id := FND_API.G_MISS_NUM;
3185: ELSE
3179: THEN
3180: IF NOT OE_CNCL_Validate.Ship_To_Org(p_x_line_rec.ship_to_org_id) THEN
3181: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3182: p_x_line_rec.ship_to_org_id := NULL;
3183: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3184: p_x_line_rec.ship_to_org_id := FND_API.G_MISS_NUM;
3185: ELSE
3186: x_return_status := FND_API.G_RET_STS_ERROR;
3187: END IF;
3190:
3191: IF p_x_line_rec.sold_to_org_id IS NOT NULL
3192: THEN
3193: IF NOT OE_CNCL_Validate.Sold_To_Org(p_x_line_rec.sold_to_org_id) THEN
3194: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3195: p_x_line_rec.sold_to_org_id := NULL;
3196: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3197: p_x_line_rec.sold_to_org_id := FND_API.G_MISS_NUM;
3198: ELSE
3192: THEN
3193: IF NOT OE_CNCL_Validate.Sold_To_Org(p_x_line_rec.sold_to_org_id) THEN
3194: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3195: p_x_line_rec.sold_to_org_id := NULL;
3196: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3197: p_x_line_rec.sold_to_org_id := FND_API.G_MISS_NUM;
3198: ELSE
3199: x_return_status := FND_API.G_RET_STS_ERROR;
3200: END IF;
3203:
3204: IF p_x_line_rec.source_type_code IS NOT NULL
3205: THEN
3206: IF NOT OE_CNCL_Validate.Source_Type(p_x_line_rec.source_type_code) THEN
3207: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3208: p_x_line_rec.source_type_code := NULL;
3209: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3210: p_x_line_rec.source_type_code := FND_API.G_MISS_CHAR;
3211: ELSE
3205: THEN
3206: IF NOT OE_CNCL_Validate.Source_Type(p_x_line_rec.source_type_code) THEN
3207: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3208: p_x_line_rec.source_type_code := NULL;
3209: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3210: p_x_line_rec.source_type_code := FND_API.G_MISS_CHAR;
3211: ELSE
3212: x_return_status := FND_API.G_RET_STS_ERROR;
3213: END IF;
3216:
3217: IF p_x_line_rec.tax_exempt_flag IS NOT NULL
3218: THEN
3219: IF NOT OE_CNCL_Validate.Tax_Exempt(p_x_line_rec.tax_exempt_flag) THEN
3220: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3221: p_x_line_rec.tax_exempt_flag := NULL;
3222: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3223: p_x_line_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
3224: ELSE
3218: THEN
3219: IF NOT OE_CNCL_Validate.Tax_Exempt(p_x_line_rec.tax_exempt_flag) THEN
3220: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3221: p_x_line_rec.tax_exempt_flag := NULL;
3222: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3223: p_x_line_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
3224: ELSE
3225: x_return_status := FND_API.G_RET_STS_ERROR;
3226: END IF;
3229:
3230: IF p_x_line_rec.tax_exempt_reason_code IS NOT NULL
3231: THEN
3232: IF NOT OE_CNCL_Validate.Tax_Exempt_Reason(p_x_line_rec.tax_exempt_reason_code) THEN
3233: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3234: p_x_line_rec.tax_exempt_reason_code := NULL;
3235: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3236: p_x_line_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
3237: ELSE
3231: THEN
3232: IF NOT OE_CNCL_Validate.Tax_Exempt_Reason(p_x_line_rec.tax_exempt_reason_code) THEN
3233: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3234: p_x_line_rec.tax_exempt_reason_code := NULL;
3235: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3236: p_x_line_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
3237: ELSE
3238: x_return_status := FND_API.G_RET_STS_ERROR;
3239: END IF;
3242:
3243: IF p_x_line_rec.tax_point_code IS NOT NULL
3244: THEN
3245: IF NOT OE_CNCL_Validate.Tax_Point(p_x_line_rec.tax_point_code) THEN
3246: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3247: p_x_line_rec.tax_point_code := NULL;
3248: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3249: p_x_line_rec.tax_point_code := FND_API.G_MISS_CHAR;
3250: ELSE
3244: THEN
3245: IF NOT OE_CNCL_Validate.Tax_Point(p_x_line_rec.tax_point_code) THEN
3246: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3247: p_x_line_rec.tax_point_code := NULL;
3248: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3249: p_x_line_rec.tax_point_code := FND_API.G_MISS_CHAR;
3250: ELSE
3251: x_return_status := FND_API.G_RET_STS_ERROR;
3252: END IF;
3255:
3256: IF p_x_line_rec.fulfilled_flag IS NOT NULL
3257: THEN
3258: IF NOT OE_CNCL_Validate.fulfilled(p_x_line_rec.fulfilled_flag) THEN
3259: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3260: p_x_line_rec.fulfilled_flag := NULL;
3261: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3262: p_x_line_rec.fulfilled_flag := FND_API.G_MISS_CHAR;
3263: ELSE
3257: THEN
3258: IF NOT OE_CNCL_Validate.fulfilled(p_x_line_rec.fulfilled_flag) THEN
3259: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3260: p_x_line_rec.fulfilled_flag := NULL;
3261: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3262: p_x_line_rec.fulfilled_flag := FND_API.G_MISS_CHAR;
3263: ELSE
3264: x_return_status := FND_API.G_RET_STS_ERROR;
3265: END IF;
3268:
3269: IF p_x_line_rec.flow_status_code IS NOT NULL
3270: THEN
3271: IF NOT OE_CNCL_Validate.Line_Flow_Status(p_x_line_rec.flow_status_code) THEN
3272: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3273: p_x_line_rec.flow_status_code := NULL;
3274: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3275: p_x_line_rec.flow_status_code := FND_API.G_MISS_CHAR;
3276: ELSE
3270: THEN
3271: IF NOT OE_CNCL_Validate.Line_Flow_Status(p_x_line_rec.flow_status_code) THEN
3272: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3273: p_x_line_rec.flow_status_code := NULL;
3274: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3275: p_x_line_rec.flow_status_code := FND_API.G_MISS_CHAR;
3276: ELSE
3277: x_return_status := FND_API.G_RET_STS_ERROR;
3278: END IF;
3326: ,p_attribute18 => p_x_line_rec.attribute18
3327: ,p_attribute19 => p_x_line_rec.attribute19
3328: ,p_attribute20 => p_x_line_rec.attribute20) THEN
3329:
3330: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3331:
3332:
3333: p_x_line_rec.context := null;
3334: p_x_line_rec.attribute1 := null;
3351: p_x_line_rec.attribute18 := null;
3352: p_x_line_rec.attribute19 := null;
3353: p_x_line_rec.attribute20 := null;
3354:
3355: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3356: p_x_line_rec.context := FND_API.G_MISS_CHAR;
3357: p_x_line_rec.attribute1 := FND_API.G_MISS_CHAR;
3358: p_x_line_rec.attribute2 := FND_API.G_MISS_CHAR;
3359: p_x_line_rec.attribute3 := FND_API.G_MISS_CHAR;
3435: ,p_attribute18 => p_x_line_rec.global_attribute18
3436: ,p_attribute19 => p_x_line_rec.global_attribute19
3437: ,p_attribute20 => p_x_line_rec.global_attribute20) THEN
3438:
3439: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3440:
3441: p_x_line_rec.global_attribute_category := null;
3442: p_x_line_rec.global_attribute1 := null;
3443: p_x_line_rec.global_attribute2 := null;
3458: p_x_line_rec.global_attribute18 := null;
3459: p_x_line_rec.global_attribute19 := null;
3460: p_x_line_rec.global_attribute20 := null;
3461:
3462: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3463: p_x_line_rec.global_attribute_category := FND_API.G_MISS_CHAR;
3464: p_x_line_rec.global_attribute1 := FND_API.G_MISS_CHAR;
3465: p_x_line_rec.global_attribute2 := FND_API.G_MISS_CHAR;
3466: p_x_line_rec.global_attribute3 := FND_API.G_MISS_CHAR;
3557: ,p_attribute28 => p_x_line_rec.Industry_attribute28
3558: ,p_attribute29 => p_x_line_rec.Industry_attribute29
3559: ,p_attribute30 => p_x_line_rec.Industry_attribute30) THEN
3560:
3561: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3562:
3563:
3564: p_x_line_rec.Industry_context := null;
3565: p_x_line_rec.Industry_attribute1 := null;
3592: p_x_line_rec.Industry_attribute28 := null;
3593: p_x_line_rec.Industry_attribute29 := null;
3594: p_x_line_rec.Industry_attribute30 := null;
3595:
3596: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3597:
3598: p_x_line_rec.Industry_context := FND_API.G_MISS_CHAR;
3599: p_x_line_rec.Industry_attribute1 := FND_API.G_MISS_CHAR;
3600: p_x_line_rec.Industry_attribute2 := FND_API.G_MISS_CHAR;
3673: ,p_attribute13 => p_x_line_rec.tp_attribute13
3674: ,p_attribute14 => p_x_line_rec.tp_attribute14
3675: ,p_attribute15 => p_x_line_rec.tp_attribute15) THEN
3676:
3677: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3678:
3679:
3680: p_x_line_rec.tp_context := null;
3681: p_x_line_rec.tp_attribute1 := null;
3693: p_x_line_rec.tp_attribute13 := null;
3694: p_x_line_rec.tp_attribute14 := null;
3695: p_x_line_rec.tp_attribute15 := null;
3696:
3697: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3698:
3699: p_x_line_rec.tp_context := FND_API.G_MISS_CHAR;
3700: p_x_line_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
3701: p_x_line_rec.tp_attribute2 := FND_API.G_MISS_CHAR;
3761: ,p_attribute13 => p_x_line_rec.Return_attribute13
3762: ,p_attribute14 => p_x_line_rec.Return_attribute14
3763: ,p_attribute15 => p_x_line_rec.Return_attribute15) THEN
3764:
3765: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3766:
3767:
3768: p_x_line_rec.Return_context := null;
3769: p_x_line_rec.Return_attribute1 := null;
3781: p_x_line_rec.Return_attribute14 := null;
3782: p_x_line_rec.Return_attribute15 := null;
3783: p_x_line_rec.Return_attribute10 := null;
3784:
3785: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3786: p_x_line_rec.Return_context := FND_API.G_MISS_CHAR;
3787: p_x_line_rec.Return_attribute1 := FND_API.G_MISS_CHAR;
3788: p_x_line_rec.Return_attribute2 := FND_API.G_MISS_CHAR;
3789: p_x_line_rec.Return_attribute3 := FND_API.G_MISS_CHAR;
3815:
3816: IF p_x_line_rec.salesrep_id IS NOT NULL
3817: THEN
3818: IF NOT OE_CNCL_Validate.salesrep(p_x_line_rec.salesrep_id) THEN
3819: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3820: p_x_line_rec.salesrep_id := NULL;
3821: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3822: p_x_line_rec.salesrep_id := FND_API.G_MISS_NUM;
3823: ELSE
3817: THEN
3818: IF NOT OE_CNCL_Validate.salesrep(p_x_line_rec.salesrep_id) THEN
3819: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3820: p_x_line_rec.salesrep_id := NULL;
3821: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3822: p_x_line_rec.salesrep_id := FND_API.G_MISS_NUM;
3823: ELSE
3824: x_return_status := FND_API.G_RET_STS_ERROR;
3825: END IF;
3828:
3829: IF p_x_line_rec.return_reason_code IS NOT NULL
3830: THEN
3831: IF NOT OE_CNCL_Validate.return_reason(p_x_line_rec.return_reason_code) THEN
3832: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3833: p_x_line_rec.return_reason_code := NULL;
3834: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3835: p_x_line_rec.return_reason_code := FND_API.G_MISS_CHAR;
3836: ELSE
3830: THEN
3831: IF NOT OE_CNCL_Validate.return_reason(p_x_line_rec.return_reason_code) THEN
3832: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3833: p_x_line_rec.return_reason_code := NULL;
3834: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3835: p_x_line_rec.return_reason_code := FND_API.G_MISS_CHAR;
3836: ELSE
3837: x_return_status := FND_API.G_RET_STS_ERROR;
3838: END IF;
3882:
3883: oe_debug_pub.add('In OEXVCLINB: Function Get_Item_Type',1);
3884: oe_debug_pub.add('The INV Item is'||to_char(p_line_rec.inventory_item_id),1);
3885:
3886: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
3887: RETURN OE_GLOBALS.G_ITEM_STANDARD;
3888: ELSIF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
3889: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN
3890: RETURN p_line_rec.item_type_code;
3883: oe_debug_pub.add('In OEXVCLINB: Function Get_Item_Type',1);
3884: oe_debug_pub.add('The INV Item is'||to_char(p_line_rec.inventory_item_id),1);
3885:
3886: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
3887: RETURN OE_GLOBALS.G_ITEM_STANDARD;
3888: ELSIF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
3889: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN
3890: RETURN p_line_rec.item_type_code;
3891: END IF;
3884: oe_debug_pub.add('The INV Item is'||to_char(p_line_rec.inventory_item_id),1);
3885:
3886: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
3887: RETURN OE_GLOBALS.G_ITEM_STANDARD;
3888: ELSIF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
3889: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN
3890: RETURN p_line_rec.item_type_code;
3891: END IF;
3892:
3885:
3886: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
3887: RETURN OE_GLOBALS.G_ITEM_STANDARD;
3888: ELSIF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
3889: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN
3890: RETURN p_line_rec.item_type_code;
3891: END IF;
3892:
3893:
3906: THEN
3907: oe_debug_pub.add
3908: ('Returning CLASS as the Item Type for ato subconfig',1);
3909: --Procedure to check change in item_type_code
3910: RETURN OE_GLOBALS.G_ITEM_CLASS;
3911: END IF;
3912:
3913: oe_debug_pub.add('Returning MODEL as the Item Type',1);
3914: --Procedure to check change in item_type_code
3911: END IF;
3912:
3913: oe_debug_pub.add('Returning MODEL as the Item Type',1);
3914: --Procedure to check change in item_type_code
3915: RETURN OE_GLOBALS.G_ITEM_MODEL;
3916:
3917: ELSIF l_item_rec.bom_item_type = 2
3918: THEN
3919: oe_debug_pub.add('Returning CLASS as the Item Type',1);
3918: THEN
3919: oe_debug_pub.add('Returning CLASS as the Item Type',1);
3920: -- Only CLASS items have bom_item_type = 2
3921: --Procedure to check change in item_type_code
3922: RETURN OE_GLOBALS.G_ITEM_CLASS;
3923: ELSIF l_item_rec.bom_item_type = 4 and
3924: l_item_rec.service_item_flag = 'N'
3925: THEN
3926:
3937: oe_debug_pub.add
3938: ('item Org ' || OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'));
3939: oe_debug_pub.add('inventory_item_id ' || p_line_rec.inventory_item_id);
3940: BEGIN
3941: SELECT OE_GLOBALS.G_ITEM_KIT
3942: INTO l_item_type_code
3943: FROM mtl_system_items
3944: WHERE organization_id
3945: = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID')
3959: p_line_rec.top_model_line_index <> FND_API.G_MISS_NUM)
3960:
3961: THEN
3962: oe_debug_pub.add(' Before calling check 2');
3963: RETURN OE_GLOBALS.G_ITEM_OPTION;
3964: ELSE
3965: oe_debug_pub.add(' Before calling check 3');
3966: RETURN OE_GLOBALS.G_ITEM_STANDARD;
3967: END IF;
3962: oe_debug_pub.add(' Before calling check 2');
3963: RETURN OE_GLOBALS.G_ITEM_OPTION;
3964: ELSE
3965: oe_debug_pub.add(' Before calling check 3');
3966: RETURN OE_GLOBALS.G_ITEM_STANDARD;
3967: END IF;
3968: END;
3969:
3970: ELSIF l_item_rec.service_item_flag = 'Y' and
3970: ELSIF l_item_rec.service_item_flag = 'Y' and
3971: l_item_rec.bom_item_type = 4
3972: THEN
3973: oe_debug_pub.add('Service item flag is: ' || l_item_rec.service_item_flag);
3974: RETURN OE_GLOBALS.G_ITEM_SERVICE;
3975:
3976: END IF;
3977:
3978: RETURN null;
3982: EXCEPTION
3983:
3984: WHEN NO_DATA_FOUND THEN
3985: oe_debug_pub.add(' Before calling check 4');
3986: l_item_type_code := OE_GLOBALS.G_ITEM_STANDARD;
3987: RETURN l_item_type_code;
3988:
3989: WHEN OTHERS THEN
3990: