[Home] [Help]
1453: /* Bug 1741158 chhung modify BEGIN */
1454: IF p_line_category_code ='ORDER' THEN
1455: IF p_source_document_type_id = 10
1456: /* for Internal Orders */
1457: /* Internal Orders only support standard item */
1458: THEN
1459: SELECT null
1460: INTO l_dummy
1461: FROM mtl_system_items_b msi,
1522: AND org.organization_id= p_ship_from_org_id
1523: AND rownum =1;
1524: end if;
1525: --Added for bug 4343544 end
1526: ELSE /* item type is MODEL,STANDARD,SERVICE,KIT in top most level*/
1527: SELECT null
1528: INTO l_dummy
1529: FROM mtl_system_items_b msi,
1530: org_organization_definitions org
1717: /* Bug 1741158 chhung modify BEGIN */
1718: IF p_line_category_code ='ORDER' THEN
1719: IF p_source_document_type_id = 10
1720: /* for Internal Orders */
1721: /* Internal Orders only support standard item */
1722: THEN
1723: SELECT 'valid'
1724: INTO l_dummy
1725: FROM mtl_system_items_b
1738: INTO l_dummy
1739: FROM mtl_system_items_b
1740: WHERE inventory_item_id = p_inventory_item_id
1741: AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
1742: ELSE /* item type is MODEL,STANDARD,SERVICE,KIT in top most level*/
1743:
1744: /* Change for bug 1805985
1745: -------------------------------------------------------
1746: To avoid duplicated item validation for
2849: oe_debug_pub.add('validate line: pack H new logic DS', 1);
2850: END IF;
2851: END IF;
2852: ELSE
2853: IF (p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_STANDARD) THEN
2854: IF l_debug_level > 0 then
2855: oe_debug_pub.add('Cannot dropship non-standard item',2);
2856: END IF;
2857: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ALLOWED');
2851: END IF;
2852: ELSE
2853: IF (p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_STANDARD) THEN
2854: IF l_debug_level > 0 then
2855: oe_debug_pub.add('Cannot dropship non-standard item',2);
2856: END IF;
2857: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ALLOWED');
2858: OE_MSG_PUB.Add;
2859: x_return_status := FND_API.G_RET_STS_ERROR;
3151:
3152:
3153: if oe_code_control.get_code_release_level < '110510' then /* added by Srini FOR Pack J*/
3154: -- Bug 2757773 =>
3155: -- Items that are not standard items and are not top level kit items
3156: -- are not supported for blankets.
3157: IF ((p_line_rec.item_type_code <> 'STANDARD') AND
3158: NOT (p_line_rec.item_type_code = 'KIT' AND p_line_rec.top_model_line_id = p_line_rec.line_id)) THEN
3159:
3153: if oe_code_control.get_code_release_level < '110510' then /* added by Srini FOR Pack J*/
3154: -- Bug 2757773 =>
3155: -- Items that are not standard items and are not top level kit items
3156: -- are not supported for blankets.
3157: IF ((p_line_rec.item_type_code <> 'STANDARD') AND
3158: NOT (p_line_rec.item_type_code = 'KIT' AND p_line_rec.top_model_line_id = p_line_rec.line_id)) THEN
3159:
3160: SELECT meaning
3161: INTO l_temp
3163: WHERE LOOKUP_TYPE = 'ITEM_TYPE'
3164: AND LOOKUP_CODE = p_line_rec.item_type_code;
3165:
3166: if l_debug_level > 0 then
3167: oe_debug_pub.add('Blankets only support standard items', 1);
3168: end if;
3169:
3170: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_NON_STANDARD_ITEM');
3171: OE_MSG_PUB.Add;
3166: if l_debug_level > 0 then
3167: oe_debug_pub.add('Blankets only support standard items', 1);
3168: end if;
3169:
3170: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_NON_STANDARD_ITEM');
3171: OE_MSG_PUB.Add;
3172: x_return_status := FND_API.G_RET_STS_ERROR;
3173:
3174: END IF;
4222:
4223: ---- Start 2691825 ---
4224: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
4225: IF l_debug_level > 0 then
4226: oe_debug_pub.add('Checking that it is a standard item...',1);
4227: END IF;
4228:
4229: IF (p_line_rec.item_type_code IN( 'MODEL','CLASS','KIT','OPTION')
4230: AND p_line_rec.line_category_code = 'ORDER'
4236: END IF;
4237: l_scheduling_level_code := Oe_Schedule_Util.Get_Scheduling_Level(p_line_rec.header_id,
4238: p_line_rec.line_type_id);
4239: l_line_type :=nvl(Oe_Schedule_Util.sch_cached_line_type ,'0');
4240: -- Any item other than Standard can not have level - four or five
4241: IF (l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FOUR
4242: OR l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FIVE) THEN
4243:
4244: -- Standalone
4244: -- Standalone
4245: -- Allow Inactive Demand lines with SCH level as 4 or 5 to a set
4246: -- Active Demand lines with other sch levels will not be allowed to a Inactive Demand set and vice versa.
4247:
4248: IF p_line_rec.item_type_code = 'STANDARD' THEN
4249:
4250: IF OE_SET_UTIL.stand_alone_set_exists(P_SHIP_SET_ID => p_line_rec.ship_set_id ,
4251: p_arrival_set_id => p_line_rec.arrival_set_id,
4252: p_header_id => p_line_rec.header_id,
4801: OR NOT OE_GLOBALS.Equal
4802: (p_line_rec.line_number,p_old_line_rec.line_number) )
4803: THEN
4804:
4805: -- Line number should be unique on all standard and top level
4806: -- model lines on an order
4807:
4808: IF ( p_line_rec.item_type_code = 'STANDARD'
4809: --Bug 6186554
4804:
4805: -- Line number should be unique on all standard and top level
4806: -- model lines on an order
4807:
4808: IF ( p_line_rec.item_type_code = 'STANDARD'
4809: --Bug 6186554
4810: --For Top Models, top_model_line_id and line_id are equal.
4811: --OR (p_line_rec.top_model_line_id <> p_line_rec.line_id
4812: OR (p_line_rec.top_model_line_id = p_line_rec.line_id
4823: FROM oe_order_lines L
4824: WHERE L.line_number = p_line_rec.line_number
4825: AND L.header_id = p_line_rec.header_id
4826: AND L.line_id <> p_line_rec.line_id
4827: AND ( L.item_type_code = 'STANDARD'
4828: OR ( L.top_model_line_id = L.line_id
4829: --bug 16682423
4830: --AND L.item_type_code = 'MODEL'));
4831: AND L.item_type_code IN ('MODEL','KIT')));
5458:
5459: --Added for Item Orderability feature
5460: -- Validate Item Orderability Rules
5461: IF (p_line_rec.inventory_item_id IS NOT NULL
5462: and ( NVL(p_line_rec.item_type_code,OE_GLOBALS.G_ITEM_STANDARD) = OE_GLOBALS.G_ITEM_STANDARD
5463: OR p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL )) then
5464:
5465: IF NOT OE_ITORD_UTIL.Validate_Item_Orderability(p_line_rec) then
5466: l_return_status := FND_API.G_RET_STS_ERROR;
6054: fnd_message.set_name('ONT','OE_NO_TAX_EXEMPTION');
6055: OE_MSG_PUB.Add;
6056: END IF;
6057:
6058: END IF; -- If Tax handling is Standard
6059:
6060:
6061: --bug6441512
6062: IF p_line_rec.tax_exempt_flag = 'E'
6106:
6107: -- Removing the following Tax Exemption Number Validation for bug 6441512
6108:
6109: -- Check for Tax Exempt number/ Tax Exempt reason code depends on
6110: -- following attributes if the Tax_exempt_flag = 'S' (Standard)
6111:
6112: /* IF p_line_rec.tax_exempt_flag IS NOT NULL
6113: AND ( NOT OE_GLOBALS.EQUAL(p_line_rec.tax_exempt_number
6114: ,p_old_line_rec.tax_exempt_number)
6701: oe_debug_pub.add('15 '||l_return_status ,1);
6702: END IF;
6703:
6704: -- Line number validation.
6705: -- Allow line number updates only on Model, Standard, Kit,
6706: -- and stand alone service line.
6707: -- Bug 2382657 : Modified the condition for KIT and added
6708: -- condition for INCLUDED items.
6709:
7957:
7958: --PP Revenue Recognition
7959: --bug 4893057
7960: -- webroot bug 6826344 modified the condition
7961: IF p_line_rec.item_type_code NOT IN ('SERVICE', 'STANDARD') THEN
7962: IF p_line_rec.accounting_rule_id <> FND_API.G_MISS_NUM AND
7963: p_line_rec.accounting_rule_id IS NOT NULL THEN
7964: IF l_debug_level > 0 THEN
7965: oe_debug_pub.add('Getting accounting rule type');