[Home] [Help]
1429: /* Bug 1741158 chhung modify BEGIN */
1430: IF p_line_category_code ='ORDER' THEN
1431: IF p_source_document_type_id = 10
1432: /* for Internal Orders */
1433: /* Internal Orders only support standard item */
1434: THEN
1435: SELECT null
1436: INTO l_dummy
1437: FROM mtl_system_items_b msi,
1498: AND org.organization_id= p_ship_from_org_id
1499: AND rownum =1;
1500: end if;
1501: --Added for bug 4343544 end
1502: ELSE /* item type is MODEL,STANDARD,SERVICE,KIT in top most level*/
1503: SELECT null
1504: INTO l_dummy
1505: FROM mtl_system_items_b msi,
1506: org_organization_definitions org
1693: /* Bug 1741158 chhung modify BEGIN */
1694: IF p_line_category_code ='ORDER' THEN
1695: IF p_source_document_type_id = 10
1696: /* for Internal Orders */
1697: /* Internal Orders only support standard item */
1698: THEN
1699: SELECT 'valid'
1700: INTO l_dummy
1701: FROM mtl_system_items_b
1714: INTO l_dummy
1715: FROM mtl_system_items_b
1716: WHERE inventory_item_id = p_inventory_item_id
1717: AND organization_id = OE_Sys_Parameters.VALUE_WNPS('MASTER_ORGANIZATION_ID');
1718: ELSE /* item type is MODEL,STANDARD,SERVICE,KIT in top most level*/
1719:
1720: /* Change for bug 1805985
1721: -------------------------------------------------------
1722: To avoid duplicated item validation for
2724: oe_debug_pub.add('validate line: pack H new logic DS', 1);
2725: END IF;
2726: END IF;
2727: ELSE
2728: IF (p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_STANDARD) THEN
2729: IF l_debug_level > 0 then
2730: oe_debug_pub.add('Cannot dropship non-standard item',2);
2731: END IF;
2732: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ALLOWED');
2726: END IF;
2727: ELSE
2728: IF (p_line_rec.item_type_code <> OE_GLOBALS.G_ITEM_STANDARD) THEN
2729: IF l_debug_level > 0 then
2730: oe_debug_pub.add('Cannot dropship non-standard item',2);
2731: END IF;
2732: FND_MESSAGE.SET_NAME('ONT', 'OE_DS_NOT_ALLOWED');
2733: OE_MSG_PUB.Add;
2734: x_return_status := FND_API.G_RET_STS_ERROR;
3026:
3027:
3028: if oe_code_control.get_code_release_level < '110510' then /* added by Srini FOR Pack J*/
3029: -- Bug 2757773 =>
3030: -- Items that are not standard items and are not top level kit items
3031: -- are not supported for blankets.
3032: IF ((p_line_rec.item_type_code <> 'STANDARD') AND
3033: NOT (p_line_rec.item_type_code = 'KIT' AND p_line_rec.top_model_line_id = p_line_rec.line_id)) THEN
3034:
3028: if oe_code_control.get_code_release_level < '110510' then /* added by Srini FOR Pack J*/
3029: -- Bug 2757773 =>
3030: -- Items that are not standard items and are not top level kit items
3031: -- are not supported for blankets.
3032: IF ((p_line_rec.item_type_code <> 'STANDARD') AND
3033: NOT (p_line_rec.item_type_code = 'KIT' AND p_line_rec.top_model_line_id = p_line_rec.line_id)) THEN
3034:
3035: SELECT meaning
3036: INTO l_temp
3038: WHERE LOOKUP_TYPE = 'ITEM_TYPE'
3039: AND LOOKUP_CODE = p_line_rec.item_type_code;
3040:
3041: if l_debug_level > 0 then
3042: oe_debug_pub.add('Blankets only support standard items', 1);
3043: end if;
3044:
3045: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_NON_STANDARD_ITEM');
3046: OE_MSG_PUB.Add;
3041: if l_debug_level > 0 then
3042: oe_debug_pub.add('Blankets only support standard items', 1);
3043: end if;
3044:
3045: FND_MESSAGE.SET_NAME('ONT', 'OE_BLKT_NON_STANDARD_ITEM');
3046: OE_MSG_PUB.Add;
3047: x_return_status := FND_API.G_RET_STS_ERROR;
3048:
3049: END IF;
3959:
3960: ---- Start 2691825 ---
3961: IF OE_CODE_CONTROL.Get_Code_Release_Level >= '110509' THEN
3962: IF l_debug_level > 0 then
3963: oe_debug_pub.add('Checking that it is a standard item...',1);
3964: END IF;
3965:
3966: IF (p_line_rec.item_type_code IN( 'MODEL','CLASS','KIT','OPTION')
3967: AND p_line_rec.line_category_code = 'ORDER'
3972: oe_debug_pub.add('Checking the level...',1);
3973: END IF;
3974: l_scheduling_level_code := Oe_Schedule_Util.Get_Scheduling_Level(p_line_rec.header_id,
3975: p_line_rec.line_type_id);
3976: -- Any item other than Standard can not have level - four or five
3977: IF (l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FOUR
3978: OR l_scheduling_level_code = OE_SCHEDULE_UTIL.SCH_LEVEL_FIVE) THEN
3979:
3980: FND_MESSAGE.SET_NAME('ONT', 'OE_SCH_INACTIVE_STD_ONLY');
4491: OR NOT OE_GLOBALS.Equal
4492: (p_line_rec.line_number,p_old_line_rec.line_number) )
4493: THEN
4494:
4495: -- Line number should be unique on all standard and top level
4496: -- model lines on an order
4497:
4498: IF ( p_line_rec.item_type_code = 'STANDARD'
4499: --Bug 6186554
4494:
4495: -- Line number should be unique on all standard and top level
4496: -- model lines on an order
4497:
4498: IF ( p_line_rec.item_type_code = 'STANDARD'
4499: --Bug 6186554
4500: --For Top Models, top_model_line_id and line_id are equal.
4501: --OR (p_line_rec.top_model_line_id <> p_line_rec.line_id
4502: OR (p_line_rec.top_model_line_id = p_line_rec.line_id
4510: FROM oe_order_lines L
4511: WHERE L.line_number = p_line_rec.line_number
4512: AND L.header_id = p_line_rec.header_id
4513: AND L.line_id <> p_line_rec.line_id
4514: AND ( L.item_type_code = 'STANDARD'
4515: OR ( L.top_model_line_id = L.line_id
4516: AND L.item_type_code = 'MODEL'));
4517:
4518: EXCEPTION
5142:
5143: --Added for Item Orderability feature
5144: -- Validate Item Orderability Rules
5145: IF (p_line_rec.inventory_item_id IS NOT NULL
5146: and ( NVL(p_line_rec.item_type_code,OE_GLOBALS.G_ITEM_STANDARD) = OE_GLOBALS.G_ITEM_STANDARD
5147: OR p_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL )) then
5148:
5149: IF NOT OE_ITORD_UTIL.Validate_Item_Orderability(p_line_rec) then
5150: l_return_status := FND_API.G_RET_STS_ERROR;
5713: fnd_message.set_name('ONT','OE_NO_TAX_EXEMPTION');
5714: OE_MSG_PUB.Add;
5715: END IF;
5716:
5717: END IF; -- If Tax handling is Standard
5718:
5719:
5720: --bug6441512
5721: IF p_line_rec.tax_exempt_flag = 'E'
5765:
5766: -- Removing the following Tax Exemption Number Validation for bug 6441512
5767:
5768: -- Check for Tax Exempt number/ Tax Exempt reason code depends on
5769: -- following attributes if the Tax_exempt_flag = 'S' (Standard)
5770:
5771: /* IF p_line_rec.tax_exempt_flag IS NOT NULL
5772: AND ( NOT OE_GLOBALS.EQUAL(p_line_rec.tax_exempt_number
5773: ,p_old_line_rec.tax_exempt_number)
6329: oe_debug_pub.add('15 '||l_return_status ,1);
6330: END IF;
6331:
6332: -- Line number validation.
6333: -- Allow line number updates only on Model, Standard, Kit,
6334: -- and stand alone service line.
6335: -- Bug 2382657 : Modified the condition for KIT and added
6336: -- condition for INCLUDED items.
6337:
7548:
7549: --PP Revenue Recognition
7550: --bug 4893057
7551: -- webroot bug 6826344 modified the condition
7552: IF p_line_rec.item_type_code NOT IN ('SERVICE', 'STANDARD') THEN
7553: IF p_line_rec.accounting_rule_id <> FND_API.G_MISS_NUM AND
7554: p_line_rec.accounting_rule_id IS NOT NULL THEN
7555: IF l_debug_level > 0 THEN
7556: oe_debug_pub.add('Getting accounting rule type');