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_CNCL_VALIDATE_LINE dependencies on OE_GLOBALS

Line 126: IF p_line_rec.line_category_code <> OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN

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');

Line 149: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN

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');

Line 387: IF p_line_rec.ITEM_TYPE_CODE = OE_GLOBALS.G_ITEM_CONFIG THEN

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;

Line 481: IF p_item_type_code = OE_GLOBALS.G_ITEM_INCLUDED OR

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

Line 482: p_item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR

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)

Line 483: p_item_type_code = OE_GLOBALS.G_ITEM_CLASS OR

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

Line 484: p_item_type_code = OE_GLOBALS.G_ITEM_OPTION OR

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

Line 485: (p_item_type_code = OE_GLOBALS.G_ITEM_KIT AND

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

Line 1035: IF OE_GLOBALS.Equal(p_line_rec.source_type_code,

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

Line 1036: OE_GLOBALS.G_SOURCE_EXTERNAL) 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

Line 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');

Line 1053: IF (p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_STANDARD) THEN

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;

Line 1277: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE

1273: --------------------------------------------------------------
1274:
1275: -- For return lines, Return_Reason_Code is required
1276: oe_debug_pub.add('5 '||l_return_status, 1);
1277: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE
1278: and p_line_rec.return_reason_code is NULL
1279: THEN
1280: l_return_status := FND_API.G_RET_STS_ERROR;
1281:

Line 1503: IF p_line_rec.source_type_code = OE_GLOBALS.G_SOURCE_INTERNAL

1499: THEN */
1500:
1501:
1502:
1503: IF p_line_rec.source_type_code = OE_GLOBALS.G_SOURCE_INTERNAL
1504: or p_line_rec.source_type_code is null
1505: THEN
1506: oe_debug_pub.add('Source Type is Internal',1);
1507:

Line 1646: /* IF NOT OE_GLOBALS.Equal(p_line_rec.reserved_quantity,p_old_line_rec.reserved_quantity)

1642: -- end decimal quantity validation
1643:
1644:
1645: -- Error if reserved quantity > ordered quantity
1646: /* IF NOT OE_GLOBALS.Equal(p_line_rec.reserved_quantity,p_old_line_rec.reserved_quantity)
1647: THEN
1648:
1649: IF (p_line_rec.reserved_quantity > p_line_rec.ordered_quantity) THEN
1650: fnd_message.set_name('ONT','OE_SCH_RES_MORE_ORD_QTY');

Line 1663: IF (NOT OE_GLOBALS.Equal(p_line_rec.schedule_ship_date,

1659: -- and Schedule Arrival Date. This is not allowed. The user can change
1660: -- either one, but not both.
1661:
1662: /*
1663: IF (NOT OE_GLOBALS.Equal(p_line_rec.schedule_ship_date,
1664: p_old_line_rec.schedule_ship_date)) AND
1665: (NOT OE_GLOBALS.Equal(p_line_rec.schedule_arrival_date,
1666: p_old_line_rec.schedule_arrival_date)) AND
1667: (OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING = 'Y') THEN

Line 1665: (NOT OE_GLOBALS.Equal(p_line_rec.schedule_arrival_date,

1661:
1662: /*
1663: IF (NOT OE_GLOBALS.Equal(p_line_rec.schedule_ship_date,
1664: p_old_line_rec.schedule_ship_date)) AND
1665: (NOT OE_GLOBALS.Equal(p_line_rec.schedule_arrival_date,
1666: p_old_line_rec.schedule_arrival_date)) AND
1667: (OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING = 'Y') THEN
1668:
1669: -- Config item is created and passed by the CTO team. So this is

Line 1674: IF p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN

1670: -- is the only item type, which when gets created, already has
1671: -- Schedule_Ship_Date and schedule_Arrival_date. We should not
1672: -- error out for this item.
1673:
1674: IF p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_CONFIG THEN
1675: FND_MESSAGE.SET_NAME('ONT','OE_SCH_INVALID_CHANGE');
1676: OE_MSG_PUB.Add;
1677: l_return_status := FND_API.G_RET_STS_ERROR;
1678: END IF;

Line 1848: /*IF p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

1844: -- Model.
1845:
1846: oe_debug_pub.add('11 '||l_return_status, 1);
1847:
1848: /*IF p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1849:
1850: IF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1851: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS)
1852: --AND p_line_rec.line_id <> p_line_rec.ato_line_id

Line 1850: IF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR

1846: oe_debug_pub.add('11 '||l_return_status, 1);
1847:
1848: /*IF p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1849:
1850: IF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1851: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS)
1852: --AND p_line_rec.line_id <> p_line_rec.ato_line_id
1853: THEN
1854:

Line 1851: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS)

1847:
1848: /*IF p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
1849:
1850: IF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION OR
1851: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS)
1852: --AND p_line_rec.line_id <> p_line_rec.ato_line_id
1853: THEN
1854:
1855: FND_MESSAGE.SET_NAME('ONT', 'OE_VAL_PROJ_UPD');

Line 1885: IF (p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE and

1881: END IF;
1882:
1883: oe_debug_pub.add('12 '||l_return_status, 1);
1884: -- Validate if return item and item on referenced sales order line mismatch
1885: IF (p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE and
1886: p_line_rec.reference_line_id is not null and
1887: p_line_rec.inventory_item_id IS NOT NULL)
1888: THEN
1889: IF NOT Validate_Return_Item_Mismatch

Line 1903: IF (p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE and

1899:
1900: oe_debug_pub.add('13 '||l_return_status, 1);
1901:
1902: -- Validate if returning a fulfilled sales order line
1903: IF (p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE and
1904: p_line_rec.reference_line_id is not null)
1905: THEN
1906: IF NOT Validate_Return_Fulfilled_Line
1907: ( p_line_rec.reference_line_id

Line 1920: IF (p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE and

1916:
1917: oe_debug_pub.add('14 '||l_return_status, 1);
1918:
1919: -- Validate if item on the Return is Returnable
1920: IF (p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE and
1921: p_line_rec.inventory_item_id IS NOT NULL)
1922: THEN
1923: IF NOT Validate_Return_Item(p_line_rec.inventory_item_id,
1924: p_line_rec.ship_from_org_id)

Line 1936: IF (p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE and

1932:
1933: oe_debug_pub.add('14_1 '||l_return_status, 1);
1934:
1935: -- Validate if Reference SO Line is Valid
1936: IF (p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE and
1937: p_line_rec.reference_line_id is not null)
1938: THEN
1939: IF NOT Validate_Return_Reference(p_line_rec.reference_line_id)
1940: THEN

Line 1949: IF (p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE and

1945:
1946: oe_debug_pub.add('14_2 '||l_return_status, 1);
1947:
1948: -- Validate the quantity = 1 on RMA for Serial Number reference
1949: IF (p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE and
1950: p_line_rec.reference_line_id is not null and
1951: p_line_rec.return_context = 'SERIAL' and
1952: NVL(p_line_rec.ordered_quantity,1) <> 1)
1953: THEN

Line 2419: IF ( p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR

2415: IF p_line_rec.order_quantity_uom is not null
2416:
2417: THEN
2418:
2419: IF ( p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
2420: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
2421: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION ) THEN
2422: BEGIN
2423: SELECT primary_uom_code

Line 2420: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR

2416:
2417: THEN
2418:
2419: IF ( p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
2420: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
2421: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION ) THEN
2422: BEGIN
2423: SELECT primary_uom_code
2424: INTO l_uom

Line 2421: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION ) THEN

2417: THEN
2418:
2419: IF ( p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
2420: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
2421: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION ) THEN
2422: BEGIN
2423: SELECT primary_uom_code
2424: INTO l_uom
2425: FROM mtl_system_items

Line 2470: NOT OE_GLOBALS.EQUAL(p_line_rec.agreement_id, fnd_api.g_miss_num) then

2466: END IF;
2467: END IF;
2468:
2469: If p_line_rec.agreement_id is not null and
2470: NOT OE_GLOBALS.EQUAL(p_line_rec.agreement_id, fnd_api.g_miss_num) then
2471: If not oe_globals.equal(p_line_rec.agreement_id,null) then
2472:
2473: -- Check for Agreement +sold_org_id
2474:

Line 2471: If not oe_globals.equal(p_line_rec.agreement_id,null) then

2467: END IF;
2468:
2469: If p_line_rec.agreement_id is not null and
2470: NOT OE_GLOBALS.EQUAL(p_line_rec.agreement_id, fnd_api.g_miss_num) then
2471: If not oe_globals.equal(p_line_rec.agreement_id,null) then
2472:
2473: -- Check for Agreement +sold_org_id
2474:
2475: -- Where cluase added to check start and end date for agreements

Line 2498: IF NOT OE_GLOBALS.EQUAL(l_list_type_code,'PRL') THEN

2494: null;
2495: END;
2496:
2497:
2498: IF NOT OE_GLOBALS.EQUAL(l_list_type_code,'PRL') THEN
2499: -- any price list with 'PRL' type should be allowed to
2500: -- be associated with any agreement according to bug 1386406.
2501: IF NOT OE_GLOBALS.EQUAL(l_price_list_id, p_line_rec.price_list_id) THEN
2502: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');

Line 2501: IF NOT OE_GLOBALS.EQUAL(l_price_list_id, p_line_rec.price_list_id) THEN

2497:
2498: IF NOT OE_GLOBALS.EQUAL(l_list_type_code,'PRL') THEN
2499: -- any price list with 'PRL' type should be allowed to
2500: -- be associated with any agreement according to bug 1386406.
2501: IF NOT OE_GLOBALS.EQUAL(l_price_list_id, p_line_rec.price_list_id) THEN
2502: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT_PLIST');
2503: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);
2504: BEGIN
2505: SELECT name

Line 2534: AND NOT OE_GLOBALS.EQUAL(l_sold_to_org,p_line_rec.sold_to_org_id) THEN

2530:
2531:
2532: -- modified by lkxu, to check for customer relationships.
2533: IF l_sold_to_org IS NOT NULL AND l_sold_to_org <> -1
2534: AND NOT OE_GLOBALS.EQUAL(l_sold_to_org,p_line_rec.sold_to_org_id) THEN
2535: IF nvl(lcustomer_relations,'N') = 'N' THEN
2536: fnd_message.set_name('ONT', 'OE_INVALID_AGREEMENT');
2537: fnd_message.set_Token('AGREEMENT_ID', p_line_rec.agreement_id);
2538: fnd_message.set_Token('AGREEMENT_NAME', l_agreement_name);

Line 2588: /*IF NOT oe_globals.equal(p_line_rec.pricing_date,p_old_line_rec.pricing_date) OR

2584: END IF; -- Agreement has changed
2585:
2586: ELSE
2587:
2588: /*IF NOT oe_globals.equal(p_line_rec.pricing_date,p_old_line_rec.pricing_date) OR
2589: not oe_globals.equal(p_line_rec.price_list_id,p_old_line_rec.price_list_id) THEN*/
2590:
2591:
2592: -- Allow only the non agreement price_lists

Line 2589: not oe_globals.equal(p_line_rec.price_list_id,p_old_line_rec.price_list_id) THEN*/

2585:
2586: ELSE
2587:
2588: /*IF NOT oe_globals.equal(p_line_rec.pricing_date,p_old_line_rec.pricing_date) OR
2589: not oe_globals.equal(p_line_rec.price_list_id,p_old_line_rec.price_list_id) THEN*/
2590:
2591:
2592: -- Allow only the non agreement price_lists
2593: BEGIN

Line 2623: /*IF p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

2619: -- Line number validation.
2620: -- Allow line number updates only on Model, Standard, Kit,
2621: --and stand alone service line.
2622:
2623: /*IF p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2624:
2625: IF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION) OR
2626: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS) OR
2627: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT) OR

Line 2625: IF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION) OR

2621: --and stand alone service line.
2622:
2623: /*IF p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2624:
2625: IF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION) OR
2626: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS) OR
2627: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT) OR
2628: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE AND
2629: p_line_rec.service_reference_line_id IS NOT NULL AND

Line 2626: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS) OR

2622:
2623: /*IF p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2624:
2625: IF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION) OR
2626: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS) OR
2627: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT) OR
2628: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE AND
2629: p_line_rec.service_reference_line_id IS NOT NULL AND
2630: p_line_rec.service_reference_line_id <> FND_API.G_MISS_NUM)

Line 2627: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT) OR

2623: /*IF p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
2624:
2625: IF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION) OR
2626: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS) OR
2627: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT) OR
2628: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE AND
2629: p_line_rec.service_reference_line_id IS NOT NULL AND
2630: p_line_rec.service_reference_line_id <> FND_API.G_MISS_NUM)
2631:

Line 2628: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE AND

2624:
2625: IF (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_OPTION) OR
2626: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS) OR
2627: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT) OR
2628: (p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_SERVICE AND
2629: p_line_rec.service_reference_line_id IS NOT NULL AND
2630: p_line_rec.service_reference_line_id <> FND_API.G_MISS_NUM)
2631:
2632: THEN

Line 2634: IF (NOT OE_GLOBALS.EQUAL(p_line_rec.line_number,null)) THEN

2630: p_line_rec.service_reference_line_id <> FND_API.G_MISS_NUM)
2631:
2632: THEN
2633:
2634: IF (NOT OE_GLOBALS.EQUAL(p_line_rec.line_number,null)) THEN
2635:
2636: l_return_status := FND_API.G_RET_STS_ERROR;
2637: fnd_message.set_name('ONT', 'OE_LINE_NUMBER_UPD');
2638: OE_MSG_PUB.add;

Line 2649: p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND

2645:
2646: oe_debug_pub.add('16 '||l_return_status ,1);
2647:
2648: /*IF p_line_rec.top_model_line_id is not null AND
2649: p_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE AND
2650: p_line_rec.ordered_quantity = 0
2651: THEN
2652: oe_debug_pub.add
2653: ('qty of a configuration related line 0'|| p_line_rec.item_type_code, 1);

Line 2776: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

2772:
2773: IF p_x_line_rec.accounting_rule_id IS NOT NULL
2774: THEN
2775: IF NOT OE_CNCL_Validate.Accounting_Rule(p_x_line_rec.accounting_rule_id) THEN
2776: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2777: p_x_line_rec.accounting_rule_id := NULL;
2778: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2779: p_x_line_rec.accounting_rule_id := FND_API.G_MISS_NUM;
2780: ELSE

Line 2778: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

2774: THEN
2775: IF NOT OE_CNCL_Validate.Accounting_Rule(p_x_line_rec.accounting_rule_id) THEN
2776: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2777: p_x_line_rec.accounting_rule_id := NULL;
2778: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2779: p_x_line_rec.accounting_rule_id := FND_API.G_MISS_NUM;
2780: ELSE
2781: x_return_status := FND_API.G_RET_STS_ERROR;
2782: END IF;

Line 2789: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

2785:
2786: IF p_x_line_rec.agreement_id IS NOT NULL
2787: THEN
2788: IF NOT OE_CNCL_Validate.Agreement(p_x_line_rec.agreement_id) THEN
2789: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2790: p_x_line_rec.agreement_id := NULL;
2791: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2792: p_x_line_rec.agreement_id := FND_API.G_MISS_NUM;
2793: ELSE

Line 2791: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

2787: THEN
2788: IF NOT OE_CNCL_Validate.Agreement(p_x_line_rec.agreement_id) THEN
2789: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2790: p_x_line_rec.agreement_id := NULL;
2791: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2792: p_x_line_rec.agreement_id := FND_API.G_MISS_NUM;
2793: ELSE
2794: x_return_status := FND_API.G_RET_STS_ERROR;
2795: END IF;

Line 2803: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

2799:
2800: IF p_x_line_rec.deliver_to_contact_id IS NOT NULL
2801: THEN
2802: IF NOT OE_CNCL_Validate.Deliver_To_Contact(p_x_line_rec.deliver_to_contact_id) THEN
2803: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2804: p_x_line_rec.deliver_to_contact_id := NULL;
2805: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2806: p_x_line_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
2807: ELSE

Line 2805: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

2801: THEN
2802: IF NOT OE_CNCL_Validate.Deliver_To_Contact(p_x_line_rec.deliver_to_contact_id) THEN
2803: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2804: p_x_line_rec.deliver_to_contact_id := NULL;
2805: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2806: p_x_line_rec.deliver_to_contact_id := FND_API.G_MISS_NUM;
2807: ELSE
2808: x_return_status := FND_API.G_RET_STS_ERROR;
2809: END IF;

Line 2816: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

2812:
2813: IF p_x_line_rec.deliver_to_org_id IS NOT NULL
2814: THEN
2815: IF NOT OE_CNCL_Validate.Deliver_To_Org(p_x_line_rec.deliver_to_org_id) THEN
2816: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2817: p_x_line_rec.deliver_to_org_id := NULL;
2818: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2819: p_x_line_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
2820: ELSE

Line 2818: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

2814: THEN
2815: IF NOT OE_CNCL_Validate.Deliver_To_Org(p_x_line_rec.deliver_to_org_id) THEN
2816: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2817: p_x_line_rec.deliver_to_org_id := NULL;
2818: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2819: p_x_line_rec.deliver_to_org_id := FND_API.G_MISS_NUM;
2820: ELSE
2821: x_return_status := FND_API.G_RET_STS_ERROR;
2822: END IF;

Line 2829: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

2825:
2826: IF p_x_line_rec.demand_class_code IS NOT NULL
2827: THEN
2828: IF NOT OE_CNCL_Validate.Demand_Class(p_x_line_rec.demand_class_code) THEN
2829: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2830: p_x_line_rec.demand_class_code := NULL;
2831: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2832: p_x_line_rec.demand_class_code := FND_API.G_MISS_CHAR;
2833: ELSE

Line 2831: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

2827: THEN
2828: IF NOT OE_CNCL_Validate.Demand_Class(p_x_line_rec.demand_class_code) THEN
2829: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2830: p_x_line_rec.demand_class_code := NULL;
2831: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2832: p_x_line_rec.demand_class_code := FND_API.G_MISS_CHAR;
2833: ELSE
2834: x_return_status := FND_API.G_RET_STS_ERROR;
2835: END IF;

Line 2842: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

2838:
2839: IF p_x_line_rec.dep_plan_required_flag IS NOT NULL
2840: THEN
2841: IF NOT OE_CNCL_Validate.Dep_Plan_Required(p_x_line_rec.dep_plan_required_flag) THEN
2842: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2843: p_x_line_rec.dep_plan_required_flag := NULL;
2844: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2845: p_x_line_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
2846: ELSE

Line 2844: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

2840: THEN
2841: IF NOT OE_CNCL_Validate.Dep_Plan_Required(p_x_line_rec.dep_plan_required_flag) THEN
2842: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2843: p_x_line_rec.dep_plan_required_flag := NULL;
2844: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2845: p_x_line_rec.dep_plan_required_flag := FND_API.G_MISS_CHAR;
2846: ELSE
2847: x_return_status := FND_API.G_RET_STS_ERROR;
2848: END IF;

Line 2855: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

2851:
2852: IF p_x_line_rec.end_item_unit_number IS NOT NULL
2853: THEN
2854: IF NOT OE_CNCL_Validate.End_Item_Unit_Number(p_x_line_rec.end_item_unit_number) THEN
2855: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2856: p_x_line_rec.end_item_unit_number := NULL;
2857: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2858: p_x_line_rec.end_item_unit_number := FND_API.G_MISS_CHAR;
2859: ELSE

Line 2857: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

2853: THEN
2854: IF NOT OE_CNCL_Validate.End_Item_Unit_Number(p_x_line_rec.end_item_unit_number) THEN
2855: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2856: p_x_line_rec.end_item_unit_number := NULL;
2857: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2858: p_x_line_rec.end_item_unit_number := FND_API.G_MISS_CHAR;
2859: ELSE
2860: x_return_status := FND_API.G_RET_STS_ERROR;
2861: END IF;

Line 2868: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

2864:
2865: IF p_x_line_rec.fob_point_code IS NOT NULL
2866: THEN
2867: IF NOT OE_CNCL_Validate.Fob_Point(p_x_line_rec.fob_point_code) THEN
2868: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2869: p_x_line_rec.fob_point_code := NULL;
2870: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2871: p_x_line_rec.fob_point_code := FND_API.G_MISS_CHAR;
2872: ELSE

Line 2870: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

2866: THEN
2867: IF NOT OE_CNCL_Validate.Fob_Point(p_x_line_rec.fob_point_code) THEN
2868: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2869: p_x_line_rec.fob_point_code := NULL;
2870: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2871: p_x_line_rec.fob_point_code := FND_API.G_MISS_CHAR;
2872: ELSE
2873: x_return_status := FND_API.G_RET_STS_ERROR;
2874: END IF;

Line 2881: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

2877:
2878: IF p_x_line_rec.freight_terms_code IS NOT NULL
2879: THEN
2880: IF NOT OE_CNCL_Validate.Freight_Terms(p_x_line_rec.freight_terms_code) THEN
2881: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2882: p_x_line_rec.freight_terms_code := NULL;
2883: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2884: p_x_line_rec.freight_terms_code := FND_API.G_MISS_CHAR;
2885: ELSE

Line 2883: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

2879: THEN
2880: IF NOT OE_CNCL_Validate.Freight_Terms(p_x_line_rec.freight_terms_code) THEN
2881: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2882: p_x_line_rec.freight_terms_code := NULL;
2883: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2884: p_x_line_rec.freight_terms_code := FND_API.G_MISS_CHAR;
2885: ELSE
2886: x_return_status := FND_API.G_RET_STS_ERROR;
2887: END IF;

Line 2894: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

2890:
2891: IF p_x_line_rec.invoice_to_contact_id IS NOT NULL
2892: THEN
2893: IF NOT OE_CNCL_Validate.Invoice_To_Contact(p_x_line_rec.invoice_to_contact_id) THEN
2894: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2895: p_x_line_rec.invoice_to_contact_id := NULL;
2896: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2897: p_x_line_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
2898: ELSE

Line 2896: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

2892: THEN
2893: IF NOT OE_CNCL_Validate.Invoice_To_Contact(p_x_line_rec.invoice_to_contact_id) THEN
2894: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2895: p_x_line_rec.invoice_to_contact_id := NULL;
2896: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2897: p_x_line_rec.invoice_to_contact_id := FND_API.G_MISS_NUM;
2898: ELSE
2899: x_return_status := FND_API.G_RET_STS_ERROR;
2900: END IF;

Line 2907: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

2903:
2904: IF p_x_line_rec.invoice_to_org_id IS NOT NULL
2905: THEN
2906: IF NOT OE_CNCL_Validate.Invoice_To_Org(p_x_line_rec.invoice_to_org_id) THEN
2907: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2908: p_x_line_rec.invoice_to_org_id := NULL;
2909: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2910: p_x_line_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
2911: ELSE

Line 2909: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

2905: THEN
2906: IF NOT OE_CNCL_Validate.Invoice_To_Org(p_x_line_rec.invoice_to_org_id) THEN
2907: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2908: p_x_line_rec.invoice_to_org_id := NULL;
2909: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2910: p_x_line_rec.invoice_to_org_id := FND_API.G_MISS_NUM;
2911: ELSE
2912: x_return_status := FND_API.G_RET_STS_ERROR;
2913: END IF;

Line 2920: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

2916:
2917: IF p_x_line_rec.invoicing_rule_id IS NOT NULL
2918: THEN
2919: IF NOT OE_CNCL_Validate.Invoicing_Rule(p_x_line_rec.invoicing_rule_id) THEN
2920: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2921: p_x_line_rec.invoicing_rule_id := NULL;
2922: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2923: p_x_line_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
2924: ELSE

Line 2922: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

2918: THEN
2919: IF NOT OE_CNCL_Validate.Invoicing_Rule(p_x_line_rec.invoicing_rule_id) THEN
2920: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2921: p_x_line_rec.invoicing_rule_id := NULL;
2922: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
2923: p_x_line_rec.invoicing_rule_id := FND_API.G_MISS_NUM;
2924: ELSE
2925: x_return_status := FND_API.G_RET_STS_ERROR;
2926: END IF;

Line 2935: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

2931: IF p_x_line_rec.Ib_owner IS NOT NULL
2932: THEN
2933: IF NOT OE_CNCL_Validate.IB_OWNER(p_x_line_rec.Ib_owner) THEN
2934:
2935: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2936: p_x_line_rec.Ib_owner := NULL;
2937: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
2938: THEN
2939: p_x_line_rec.Ib_Owner := FND_API.G_MISS_CHAR;

Line 2937: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF

2933: IF NOT OE_CNCL_Validate.IB_OWNER(p_x_line_rec.Ib_owner) THEN
2934:
2935: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
2936: p_x_line_rec.Ib_owner := NULL;
2937: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
2938: THEN
2939: p_x_line_rec.Ib_Owner := FND_API.G_MISS_CHAR;
2940: ELSE
2941: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2949: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL

2945:
2946: IF p_x_line_rec.Ib_installed_at_location IS NOT NULL
2947: THEN
2948: IF NOT OE_CNCL_Validate.IB_INSTALLED_AT_LOCATION(p_x_line_rec.Ib_installed_at_location) THEN
2949: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
2950: THEN
2951: p_x_line_rec.Ib_installed_at_location := NULL;
2952: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
2953: THEN

Line 2952: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF

2948: IF NOT OE_CNCL_Validate.IB_INSTALLED_AT_LOCATION(p_x_line_rec.Ib_installed_at_location) THEN
2949: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
2950: THEN
2951: p_x_line_rec.Ib_installed_at_location := NULL;
2952: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
2953: THEN
2954: p_x_line_rec.Ib_installed_at_location := FND_API.G_MISS_CHAR;
2955: ELSE
2956: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2966: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL

2962: IF p_x_line_rec.Ib_current_location IS NOT NULL
2963: THEN
2964:
2965: IF NOT OE_CNCL_Validate.IB_CURRENT_LOCATION(p_x_line_rec.ib_current_location) THEN
2966: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
2967: THEN
2968: p_x_line_rec.Ib_current_location := NULL;
2969: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
2970: THEN

Line 2969: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF

2965: IF NOT OE_CNCL_Validate.IB_CURRENT_LOCATION(p_x_line_rec.ib_current_location) THEN
2966: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
2967: THEN
2968: p_x_line_rec.Ib_current_location := NULL;
2969: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
2970: THEN
2971: p_x_line_rec.Ib_current_location := FND_API.G_MISS_CHAR;
2972: ELSE
2973: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2982: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL

2978:
2979: IF p_x_line_rec.End_customer_id IS NOT NULL THEN
2980:
2981: IF NOT OE_CNCL_Validate.END_CUSTOMER(p_x_line_rec.End_customer_id) THEN
2982: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
2983: THEN
2984: p_x_line_rec.End_customer_id := NULL;
2985: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
2986: THEN

Line 2985: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF

2981: IF NOT OE_CNCL_Validate.END_CUSTOMER(p_x_line_rec.End_customer_id) THEN
2982: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
2983: THEN
2984: p_x_line_rec.End_customer_id := NULL;
2985: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
2986: THEN
2987: p_x_line_rec.End_customer_id := FND_API.G_MISS_NUM;
2988: ELSE
2989: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3000: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL

2996:
2997: IF p_x_line_rec.End_customer_contact_id IS NOT NULL THEN
2998:
2999: IF NOT OE_CNCL_Validate.END_CUSTOMER_CONTACT(p_x_line_rec.End_customer_contact_id) THEN
3000: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
3001: THEN
3002: p_x_line_rec.End_customer_contact_id := NULL;
3003: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
3004: THEN

Line 3003: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF

2999: IF NOT OE_CNCL_Validate.END_CUSTOMER_CONTACT(p_x_line_rec.End_customer_contact_id) THEN
3000: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
3001: THEN
3002: p_x_line_rec.End_customer_contact_id := NULL;
3003: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
3004: THEN
3005: p_x_line_rec.End_customer_contact_id := FND_API.G_MISS_NUM;
3006: ELSE
3007: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3015: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL

3011:
3012: IF p_x_line_rec.End_customer_site_use_id IS NOT NULL
3013: THEN
3014: IF NOT OE_CNCL_Validate.END_CUSTOMER_SITE_USE(p_x_line_rec.End_customer_site_use_id) THEN
3015: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
3016: THEN
3017: p_x_line_rec.End_customer_site_use_id := NULL;
3018: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
3019: THEN

Line 3018: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF

3014: IF NOT OE_CNCL_Validate.END_CUSTOMER_SITE_USE(p_x_line_rec.End_customer_site_use_id) THEN
3015: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL
3016: THEN
3017: p_x_line_rec.End_customer_site_use_id := NULL;
3018: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF
3019: THEN
3020: p_x_line_rec.End_customer_site_use_id := FND_API.G_MISS_NUM;
3021: ELSE
3022: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3031: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

3027:
3028: IF p_x_line_rec.item_type_code IS NOT NULL
3029: THEN
3030: IF NOT OE_CNCL_Validate.Item_Type(p_x_line_rec.item_type_code) THEN
3031: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3032: p_x_line_rec.item_type_code := NULL;
3033: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3034: p_x_line_rec.item_type_code := FND_API.G_MISS_CHAR;
3035: ELSE

Line 3033: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

3029: THEN
3030: IF NOT OE_CNCL_Validate.Item_Type(p_x_line_rec.item_type_code) THEN
3031: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3032: p_x_line_rec.item_type_code := NULL;
3033: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3034: p_x_line_rec.item_type_code := FND_API.G_MISS_CHAR;
3035: ELSE
3036: x_return_status := FND_API.G_RET_STS_ERROR;
3037: END IF;

Line 3044: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

3040:
3041: IF p_x_line_rec.payment_term_id IS NOT NULL
3042: THEN
3043: IF NOT OE_CNCL_Validate.Payment_Term(p_x_line_rec.payment_term_id) THEN
3044: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3045: p_x_line_rec.payment_term_id := NULL;
3046: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3047: p_x_line_rec.payment_term_id := FND_API.G_MISS_NUM;
3048: ELSE

Line 3046: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

3042: THEN
3043: IF NOT OE_CNCL_Validate.Payment_Term(p_x_line_rec.payment_term_id) THEN
3044: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3045: p_x_line_rec.payment_term_id := NULL;
3046: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3047: p_x_line_rec.payment_term_id := FND_API.G_MISS_NUM;
3048: ELSE
3049: x_return_status := FND_API.G_RET_STS_ERROR;
3050: END IF;

Line 3057: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

3053:
3054: IF p_x_line_rec.price_list_id IS NOT NULL
3055: THEN
3056: IF NOT OE_CNCL_Validate.Price_List(p_x_line_rec.price_list_id) THEN
3057: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3058: p_x_line_rec.price_list_id := NULL;
3059: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3060: p_x_line_rec.price_list_id := FND_API.G_MISS_NUM;
3061: ELSE

Line 3059: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

3055: THEN
3056: IF NOT OE_CNCL_Validate.Price_List(p_x_line_rec.price_list_id) THEN
3057: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3058: p_x_line_rec.price_list_id := NULL;
3059: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3060: p_x_line_rec.price_list_id := FND_API.G_MISS_NUM;
3061: ELSE
3062: x_return_status := FND_API.G_RET_STS_ERROR;
3063: END IF;

Line 3070: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

3066:
3067: IF p_x_line_rec.project_id IS NOT NULL
3068: THEN
3069: IF NOT OE_CNCL_Validate.Project(p_x_line_rec.project_id) THEN
3070: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3071: p_x_line_rec.project_id := NULL;
3072: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3073: p_x_line_rec.project_id := FND_API.G_MISS_NUM;
3074: ELSE

Line 3072: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

3068: THEN
3069: IF NOT OE_CNCL_Validate.Project(p_x_line_rec.project_id) THEN
3070: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3071: p_x_line_rec.project_id := NULL;
3072: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3073: p_x_line_rec.project_id := FND_API.G_MISS_NUM;
3074: ELSE
3075: x_return_status := FND_API.G_RET_STS_ERROR;
3076: END IF;

Line 3083: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

3079:
3080: IF p_x_line_rec.shipment_priority_code IS NOT NULL
3081: THEN
3082: IF NOT OE_CNCL_Validate.Shipment_Priority(p_x_line_rec.shipment_priority_code) THEN
3083: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3084: p_x_line_rec.shipment_priority_code := NULL;
3085: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3086: p_x_line_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
3087: ELSE

Line 3085: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

3081: THEN
3082: IF NOT OE_CNCL_Validate.Shipment_Priority(p_x_line_rec.shipment_priority_code) THEN
3083: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3084: p_x_line_rec.shipment_priority_code := NULL;
3085: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3086: p_x_line_rec.shipment_priority_code := FND_API.G_MISS_CHAR;
3087: ELSE
3088: x_return_status := FND_API.G_RET_STS_ERROR;
3089: END IF;

Line 3096: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

3092:
3093: IF p_x_line_rec.shipping_method_code IS NOT NULL
3094: THEN
3095: IF NOT OE_CNCL_Validate.Shipping_Method(p_x_line_rec.shipping_method_code) THEN
3096: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3097: p_x_line_rec.shipping_method_code := NULL;
3098: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3099: p_x_line_rec.shipping_method_code := FND_API.G_MISS_CHAR;
3100: ELSE

Line 3098: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

3094: THEN
3095: IF NOT OE_CNCL_Validate.Shipping_Method(p_x_line_rec.shipping_method_code) THEN
3096: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3097: p_x_line_rec.shipping_method_code := NULL;
3098: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3099: p_x_line_rec.shipping_method_code := FND_API.G_MISS_CHAR;
3100: ELSE
3101: x_return_status := FND_API.G_RET_STS_ERROR;
3102: END IF;

Line 3109: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

3105:
3106: IF p_x_line_rec.ship_from_org_id IS NOT NULL
3107: THEN
3108: IF NOT OE_CNCL_Validate.Ship_From_Org(p_x_line_rec.ship_from_org_id) THEN
3109: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3110: p_x_line_rec.ship_from_org_id := NULL;
3111: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3112: p_x_line_rec.ship_from_org_id := FND_API.G_MISS_NUM;
3113: ELSE

Line 3111: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

3107: THEN
3108: IF NOT OE_CNCL_Validate.Ship_From_Org(p_x_line_rec.ship_from_org_id) THEN
3109: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3110: p_x_line_rec.ship_from_org_id := NULL;
3111: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3112: p_x_line_rec.ship_from_org_id := FND_API.G_MISS_NUM;
3113: ELSE
3114: x_return_status := FND_API.G_RET_STS_ERROR;
3115: END IF;

Line 3122: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

3118:
3119: IF p_x_line_rec.shipping_interfaced_flag IS NOT NULL
3120: THEN
3121: IF NOT OE_CNCL_Validate.Shipping_Interfaced(p_x_line_rec.shipping_interfaced_flag) THEN
3122: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3123: p_x_line_rec.shipping_interfaced_flag := NULL;
3124: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3125: p_x_line_rec.shipping_interfaced_flag := FND_API.G_MISS_CHAR;
3126: ELSE

Line 3124: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

3120: THEN
3121: IF NOT OE_CNCL_Validate.Shipping_Interfaced(p_x_line_rec.shipping_interfaced_flag) THEN
3122: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3123: p_x_line_rec.shipping_interfaced_flag := NULL;
3124: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3125: p_x_line_rec.shipping_interfaced_flag := FND_API.G_MISS_CHAR;
3126: ELSE
3127: x_return_status := FND_API.G_RET_STS_ERROR;
3128: END IF;

Line 3135: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

3131:
3132: IF p_x_line_rec.shippable_flag IS NOT NULL
3133: THEN
3134: IF NOT OE_CNCL_Validate.shippable(p_x_line_rec.shippable_flag) THEN
3135: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3136: p_x_line_rec.shippable_flag := NULL;
3137: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3138: p_x_line_rec.shippable_flag := FND_API.G_MISS_CHAR;
3139: ELSE

Line 3137: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

3133: THEN
3134: IF NOT OE_CNCL_Validate.shippable(p_x_line_rec.shippable_flag) THEN
3135: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3136: p_x_line_rec.shippable_flag := NULL;
3137: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3138: p_x_line_rec.shippable_flag := FND_API.G_MISS_CHAR;
3139: ELSE
3140: x_return_status := FND_API.G_RET_STS_ERROR;
3141: END IF;

Line 3148: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

3144:
3145: IF p_x_line_rec.ship_to_contact_id IS NOT NULL
3146: THEN
3147: IF NOT OE_CNCL_Validate.Ship_To_Contact(p_x_line_rec.ship_to_contact_id) THEN
3148: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3149: p_x_line_rec.ship_to_contact_id := NULL;
3150: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3151: p_x_line_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
3152: ELSE

Line 3150: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

3146: THEN
3147: IF NOT OE_CNCL_Validate.Ship_To_Contact(p_x_line_rec.ship_to_contact_id) THEN
3148: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3149: p_x_line_rec.ship_to_contact_id := NULL;
3150: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3151: p_x_line_rec.ship_to_contact_id := FND_API.G_MISS_NUM;
3152: ELSE
3153: x_return_status := FND_API.G_RET_STS_ERROR;
3154: END IF;

Line 3161: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

3157:
3158: IF p_x_line_rec.ship_to_org_id IS NOT NULL
3159: THEN
3160: IF NOT OE_CNCL_Validate.Ship_To_Org(p_x_line_rec.ship_to_org_id) THEN
3161: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3162: p_x_line_rec.ship_to_org_id := NULL;
3163: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3164: p_x_line_rec.ship_to_org_id := FND_API.G_MISS_NUM;
3165: ELSE

Line 3163: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

3159: THEN
3160: IF NOT OE_CNCL_Validate.Ship_To_Org(p_x_line_rec.ship_to_org_id) THEN
3161: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3162: p_x_line_rec.ship_to_org_id := NULL;
3163: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3164: p_x_line_rec.ship_to_org_id := FND_API.G_MISS_NUM;
3165: ELSE
3166: x_return_status := FND_API.G_RET_STS_ERROR;
3167: END IF;

Line 3174: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

3170:
3171: IF p_x_line_rec.sold_to_org_id IS NOT NULL
3172: THEN
3173: IF NOT OE_CNCL_Validate.Sold_To_Org(p_x_line_rec.sold_to_org_id) THEN
3174: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3175: p_x_line_rec.sold_to_org_id := NULL;
3176: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3177: p_x_line_rec.sold_to_org_id := FND_API.G_MISS_NUM;
3178: ELSE

Line 3176: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

3172: THEN
3173: IF NOT OE_CNCL_Validate.Sold_To_Org(p_x_line_rec.sold_to_org_id) THEN
3174: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3175: p_x_line_rec.sold_to_org_id := NULL;
3176: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3177: p_x_line_rec.sold_to_org_id := FND_API.G_MISS_NUM;
3178: ELSE
3179: x_return_status := FND_API.G_RET_STS_ERROR;
3180: END IF;

Line 3187: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

3183:
3184: IF p_x_line_rec.source_type_code IS NOT NULL
3185: THEN
3186: IF NOT OE_CNCL_Validate.Source_Type(p_x_line_rec.source_type_code) THEN
3187: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3188: p_x_line_rec.source_type_code := NULL;
3189: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3190: p_x_line_rec.source_type_code := FND_API.G_MISS_CHAR;
3191: ELSE

Line 3189: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

3185: THEN
3186: IF NOT OE_CNCL_Validate.Source_Type(p_x_line_rec.source_type_code) THEN
3187: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3188: p_x_line_rec.source_type_code := NULL;
3189: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3190: p_x_line_rec.source_type_code := FND_API.G_MISS_CHAR;
3191: ELSE
3192: x_return_status := FND_API.G_RET_STS_ERROR;
3193: END IF;

Line 3200: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

3196:
3197: IF p_x_line_rec.tax_exempt_flag IS NOT NULL
3198: THEN
3199: IF NOT OE_CNCL_Validate.Tax_Exempt(p_x_line_rec.tax_exempt_flag) THEN
3200: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3201: p_x_line_rec.tax_exempt_flag := NULL;
3202: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3203: p_x_line_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
3204: ELSE

Line 3202: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

3198: THEN
3199: IF NOT OE_CNCL_Validate.Tax_Exempt(p_x_line_rec.tax_exempt_flag) THEN
3200: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3201: p_x_line_rec.tax_exempt_flag := NULL;
3202: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3203: p_x_line_rec.tax_exempt_flag := FND_API.G_MISS_CHAR;
3204: ELSE
3205: x_return_status := FND_API.G_RET_STS_ERROR;
3206: END IF;

Line 3213: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

3209:
3210: IF p_x_line_rec.tax_exempt_reason_code IS NOT NULL
3211: THEN
3212: IF NOT OE_CNCL_Validate.Tax_Exempt_Reason(p_x_line_rec.tax_exempt_reason_code) THEN
3213: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3214: p_x_line_rec.tax_exempt_reason_code := NULL;
3215: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3216: p_x_line_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
3217: ELSE

Line 3215: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

3211: THEN
3212: IF NOT OE_CNCL_Validate.Tax_Exempt_Reason(p_x_line_rec.tax_exempt_reason_code) THEN
3213: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3214: p_x_line_rec.tax_exempt_reason_code := NULL;
3215: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3216: p_x_line_rec.tax_exempt_reason_code := FND_API.G_MISS_CHAR;
3217: ELSE
3218: x_return_status := FND_API.G_RET_STS_ERROR;
3219: END IF;

Line 3226: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

3222:
3223: IF p_x_line_rec.tax_point_code IS NOT NULL
3224: THEN
3225: IF NOT OE_CNCL_Validate.Tax_Point(p_x_line_rec.tax_point_code) THEN
3226: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3227: p_x_line_rec.tax_point_code := NULL;
3228: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3229: p_x_line_rec.tax_point_code := FND_API.G_MISS_CHAR;
3230: ELSE

Line 3228: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

3224: THEN
3225: IF NOT OE_CNCL_Validate.Tax_Point(p_x_line_rec.tax_point_code) THEN
3226: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3227: p_x_line_rec.tax_point_code := NULL;
3228: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3229: p_x_line_rec.tax_point_code := FND_API.G_MISS_CHAR;
3230: ELSE
3231: x_return_status := FND_API.G_RET_STS_ERROR;
3232: END IF;

Line 3239: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

3235:
3236: IF p_x_line_rec.fulfilled_flag IS NOT NULL
3237: THEN
3238: IF NOT OE_CNCL_Validate.fulfilled(p_x_line_rec.fulfilled_flag) THEN
3239: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3240: p_x_line_rec.fulfilled_flag := NULL;
3241: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3242: p_x_line_rec.fulfilled_flag := FND_API.G_MISS_CHAR;
3243: ELSE

Line 3241: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

3237: THEN
3238: IF NOT OE_CNCL_Validate.fulfilled(p_x_line_rec.fulfilled_flag) THEN
3239: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3240: p_x_line_rec.fulfilled_flag := NULL;
3241: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3242: p_x_line_rec.fulfilled_flag := FND_API.G_MISS_CHAR;
3243: ELSE
3244: x_return_status := FND_API.G_RET_STS_ERROR;
3245: END IF;

Line 3252: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

3248:
3249: IF p_x_line_rec.flow_status_code IS NOT NULL
3250: THEN
3251: IF NOT OE_CNCL_Validate.Line_Flow_Status(p_x_line_rec.flow_status_code) THEN
3252: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3253: p_x_line_rec.flow_status_code := NULL;
3254: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3255: p_x_line_rec.flow_status_code := FND_API.G_MISS_CHAR;
3256: ELSE

Line 3254: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

3250: THEN
3251: IF NOT OE_CNCL_Validate.Line_Flow_Status(p_x_line_rec.flow_status_code) THEN
3252: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3253: p_x_line_rec.flow_status_code := NULL;
3254: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3255: p_x_line_rec.flow_status_code := FND_API.G_MISS_CHAR;
3256: ELSE
3257: x_return_status := FND_API.G_RET_STS_ERROR;
3258: END IF;

Line 3310: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

3306: ,p_attribute18 => p_x_line_rec.attribute18
3307: ,p_attribute19 => p_x_line_rec.attribute19
3308: ,p_attribute20 => p_x_line_rec.attribute20) THEN
3309:
3310: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3311:
3312:
3313: p_x_line_rec.context := null;
3314: p_x_line_rec.attribute1 := null;

Line 3335: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

3331: p_x_line_rec.attribute18 := null;
3332: p_x_line_rec.attribute19 := null;
3333: p_x_line_rec.attribute20 := null;
3334:
3335: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3336: p_x_line_rec.context := FND_API.G_MISS_CHAR;
3337: p_x_line_rec.attribute1 := FND_API.G_MISS_CHAR;
3338: p_x_line_rec.attribute2 := FND_API.G_MISS_CHAR;
3339: p_x_line_rec.attribute3 := FND_API.G_MISS_CHAR;

Line 3419: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

3415: ,p_attribute18 => p_x_line_rec.global_attribute18
3416: ,p_attribute19 => p_x_line_rec.global_attribute19
3417: ,p_attribute20 => p_x_line_rec.global_attribute20) THEN
3418:
3419: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3420:
3421: p_x_line_rec.global_attribute_category := null;
3422: p_x_line_rec.global_attribute1 := null;
3423: p_x_line_rec.global_attribute2 := null;

Line 3442: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

3438: p_x_line_rec.global_attribute18 := null;
3439: p_x_line_rec.global_attribute19 := null;
3440: p_x_line_rec.global_attribute20 := null;
3441:
3442: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3443: p_x_line_rec.global_attribute_category := FND_API.G_MISS_CHAR;
3444: p_x_line_rec.global_attribute1 := FND_API.G_MISS_CHAR;
3445: p_x_line_rec.global_attribute2 := FND_API.G_MISS_CHAR;
3446: p_x_line_rec.global_attribute3 := FND_API.G_MISS_CHAR;

Line 3541: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

3537: ,p_attribute28 => p_x_line_rec.Industry_attribute28
3538: ,p_attribute29 => p_x_line_rec.Industry_attribute29
3539: ,p_attribute30 => p_x_line_rec.Industry_attribute30) THEN
3540:
3541: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3542:
3543:
3544: p_x_line_rec.Industry_context := null;
3545: p_x_line_rec.Industry_attribute1 := null;

Line 3576: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

3572: p_x_line_rec.Industry_attribute28 := null;
3573: p_x_line_rec.Industry_attribute29 := null;
3574: p_x_line_rec.Industry_attribute30 := null;
3575:
3576: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3577:
3578: p_x_line_rec.Industry_context := FND_API.G_MISS_CHAR;
3579: p_x_line_rec.Industry_attribute1 := FND_API.G_MISS_CHAR;
3580: p_x_line_rec.Industry_attribute2 := FND_API.G_MISS_CHAR;

Line 3657: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

3653: ,p_attribute13 => p_x_line_rec.tp_attribute13
3654: ,p_attribute14 => p_x_line_rec.tp_attribute14
3655: ,p_attribute15 => p_x_line_rec.tp_attribute15) THEN
3656:
3657: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3658:
3659:
3660: p_x_line_rec.tp_context := null;
3661: p_x_line_rec.tp_attribute1 := null;

Line 3677: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

3673: p_x_line_rec.tp_attribute13 := null;
3674: p_x_line_rec.tp_attribute14 := null;
3675: p_x_line_rec.tp_attribute15 := null;
3676:
3677: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3678:
3679: p_x_line_rec.tp_context := FND_API.G_MISS_CHAR;
3680: p_x_line_rec.tp_attribute1 := FND_API.G_MISS_CHAR;
3681: p_x_line_rec.tp_attribute2 := FND_API.G_MISS_CHAR;

Line 3745: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

3741: ,p_attribute13 => p_x_line_rec.Return_attribute13
3742: ,p_attribute14 => p_x_line_rec.Return_attribute14
3743: ,p_attribute15 => p_x_line_rec.Return_attribute15) THEN
3744:
3745: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3746:
3747:
3748: p_x_line_rec.Return_context := null;
3749: p_x_line_rec.Return_attribute1 := null;

Line 3765: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

3761: p_x_line_rec.Return_attribute14 := null;
3762: p_x_line_rec.Return_attribute15 := null;
3763: p_x_line_rec.Return_attribute10 := null;
3764:
3765: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3766: p_x_line_rec.Return_context := FND_API.G_MISS_CHAR;
3767: p_x_line_rec.Return_attribute1 := FND_API.G_MISS_CHAR;
3768: p_x_line_rec.Return_attribute2 := FND_API.G_MISS_CHAR;
3769: p_x_line_rec.Return_attribute3 := FND_API.G_MISS_CHAR;

Line 3799: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

3795:
3796: IF p_x_line_rec.salesrep_id IS NOT NULL
3797: THEN
3798: IF NOT OE_CNCL_Validate.salesrep(p_x_line_rec.salesrep_id) THEN
3799: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3800: p_x_line_rec.salesrep_id := NULL;
3801: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3802: p_x_line_rec.salesrep_id := FND_API.G_MISS_NUM;
3803: ELSE

Line 3801: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

3797: THEN
3798: IF NOT OE_CNCL_Validate.salesrep(p_x_line_rec.salesrep_id) THEN
3799: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3800: p_x_line_rec.salesrep_id := NULL;
3801: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3802: p_x_line_rec.salesrep_id := FND_API.G_MISS_NUM;
3803: ELSE
3804: x_return_status := FND_API.G_RET_STS_ERROR;
3805: END IF;

Line 3812: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN

3808:
3809: IF p_x_line_rec.return_reason_code IS NOT NULL
3810: THEN
3811: IF NOT OE_CNCL_Validate.return_reason(p_x_line_rec.return_reason_code) THEN
3812: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3813: p_x_line_rec.return_reason_code := NULL;
3814: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3815: p_x_line_rec.return_reason_code := FND_API.G_MISS_CHAR;
3816: ELSE

Line 3814: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN

3810: THEN
3811: IF NOT OE_CNCL_Validate.return_reason(p_x_line_rec.return_reason_code) THEN
3812: IF p_validation_level = OE_GLOBALS.G_VALID_LEVEL_PARTIAL THEN
3813: p_x_line_rec.return_reason_code := NULL;
3814: ELSIF p_validation_level = OE_GLOBALS.G_VALID_PARTIAL_WITH_DEF THEN
3815: p_x_line_rec.return_reason_code := FND_API.G_MISS_CHAR;
3816: ELSE
3817: x_return_status := FND_API.G_RET_STS_ERROR;
3818: END IF;

Line 3866: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN

3862:
3863: oe_debug_pub.add('In OEXVCLINB: Function Get_Item_Type',1);
3864: oe_debug_pub.add('The INV Item is'||to_char(p_line_rec.inventory_item_id),1);
3865:
3866: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
3867: RETURN OE_GLOBALS.G_ITEM_STANDARD;
3868: ELSIF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
3869: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN
3870: RETURN p_line_rec.item_type_code;

Line 3867: RETURN OE_GLOBALS.G_ITEM_STANDARD;

3863: oe_debug_pub.add('In OEXVCLINB: Function Get_Item_Type',1);
3864: oe_debug_pub.add('The INV Item is'||to_char(p_line_rec.inventory_item_id),1);
3865:
3866: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
3867: RETURN OE_GLOBALS.G_ITEM_STANDARD;
3868: ELSIF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
3869: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN
3870: RETURN p_line_rec.item_type_code;
3871: END IF;

Line 3868: ELSIF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR

3864: oe_debug_pub.add('The INV Item is'||to_char(p_line_rec.inventory_item_id),1);
3865:
3866: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
3867: RETURN OE_GLOBALS.G_ITEM_STANDARD;
3868: ELSIF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
3869: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN
3870: RETURN p_line_rec.item_type_code;
3871: END IF;
3872:

Line 3869: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN

3865:
3866: IF p_line_rec.line_category_code = OE_GLOBALS.G_RETURN_CATEGORY_CODE THEN
3867: RETURN OE_GLOBALS.G_ITEM_STANDARD;
3868: ELSIF p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CONFIG OR
3869: p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_INCLUDED THEN
3870: RETURN p_line_rec.item_type_code;
3871: END IF;
3872:
3873:

Line 3890: RETURN OE_GLOBALS.G_ITEM_CLASS;

3886: THEN
3887: oe_debug_pub.add
3888: ('Returning CLASS as the Item Type for ato subconfig',1);
3889: --Procedure to check change in item_type_code
3890: RETURN OE_GLOBALS.G_ITEM_CLASS;
3891: END IF;
3892:
3893: oe_debug_pub.add('Returning MODEL as the Item Type',1);
3894: --Procedure to check change in item_type_code

Line 3895: RETURN OE_GLOBALS.G_ITEM_MODEL;

3891: END IF;
3892:
3893: oe_debug_pub.add('Returning MODEL as the Item Type',1);
3894: --Procedure to check change in item_type_code
3895: RETURN OE_GLOBALS.G_ITEM_MODEL;
3896:
3897: ELSIF l_item_rec.bom_item_type = 2
3898: THEN
3899: oe_debug_pub.add('Returning CLASS as the Item Type',1);

Line 3902: RETURN OE_GLOBALS.G_ITEM_CLASS;

3898: THEN
3899: oe_debug_pub.add('Returning CLASS as the Item Type',1);
3900: -- Only CLASS items have bom_item_type = 2
3901: --Procedure to check change in item_type_code
3902: RETURN OE_GLOBALS.G_ITEM_CLASS;
3903: ELSIF l_item_rec.bom_item_type = 4 and
3904: l_item_rec.service_item_flag = 'N'
3905: THEN
3906:

Line 3921: SELECT OE_GLOBALS.G_ITEM_KIT

3917: oe_debug_pub.add
3918: ('item Org ' || OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'));
3919: oe_debug_pub.add('inventory_item_id ' || p_line_rec.inventory_item_id);
3920: BEGIN
3921: SELECT OE_GLOBALS.G_ITEM_KIT
3922: INTO l_item_type_code
3923: FROM mtl_system_items
3924: WHERE organization_id
3925: = OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID')

Line 3943: RETURN OE_GLOBALS.G_ITEM_OPTION;

3939: p_line_rec.top_model_line_index <> FND_API.G_MISS_NUM)
3940:
3941: THEN
3942: oe_debug_pub.add(' Before calling check 2');
3943: RETURN OE_GLOBALS.G_ITEM_OPTION;
3944: ELSE
3945: oe_debug_pub.add(' Before calling check 3');
3946: RETURN OE_GLOBALS.G_ITEM_STANDARD;
3947: END IF;

Line 3946: RETURN OE_GLOBALS.G_ITEM_STANDARD;

3942: oe_debug_pub.add(' Before calling check 2');
3943: RETURN OE_GLOBALS.G_ITEM_OPTION;
3944: ELSE
3945: oe_debug_pub.add(' Before calling check 3');
3946: RETURN OE_GLOBALS.G_ITEM_STANDARD;
3947: END IF;
3948: END;
3949:
3950: ELSIF l_item_rec.service_item_flag = 'Y' and

Line 3954: RETURN OE_GLOBALS.G_ITEM_SERVICE;

3950: ELSIF l_item_rec.service_item_flag = 'Y' and
3951: l_item_rec.bom_item_type = 4
3952: THEN
3953: oe_debug_pub.add('Service item flag is: ' || l_item_rec.service_item_flag);
3954: RETURN OE_GLOBALS.G_ITEM_SERVICE;
3955:
3956: END IF;
3957:
3958: RETURN null;

Line 3966: l_item_type_code := OE_GLOBALS.G_ITEM_STANDARD;

3962: EXCEPTION
3963:
3964: WHEN NO_DATA_FOUND THEN
3965: oe_debug_pub.add(' Before calling check 4');
3966: l_item_type_code := OE_GLOBALS.G_ITEM_STANDARD;
3967: RETURN l_item_type_code;
3968:
3969: WHEN OTHERS THEN
3970: