[Home] [Help]
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;
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;
1058: RETURN;
2285: END IF;
2286: END IF;
2287: END IF; -- If Tax handling is exempt
2288:
2289: -- If the TAX handling is STANDARD THEN we can not validate for
2290: -- exemption number because it can be a NULL value.
2291:
2292:
2293: -- If the Tax handling is "Required" then Tax Exempt Number and
2306:
2307: END IF; -- If Tax handling is Required
2308:
2309: -- Check for Tax Exempt number/ Tax Exempt reason code depends on
2310: -- following attributes if the Tax_exempt_flag = 'S' (Standard)
2311:
2312: IF p_line_rec.tax_exempt_flag IS NOT NULL
2313:
2314: THEN
2636:
2637: oe_debug_pub.add('15 '||l_return_status ,1);
2638:
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:
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;
3925: THEN
3926:
3927: oe_debug_pub.add('Bom 4 and flag = N');
3928: -- Following 3 items can have bom_item_type = 4 :
3929: -- STANDARD item, OPTION item and a KIT
3930: -- We will distinguish an item to be a kit by seeing if
3931: -- it has a record in bom_bill_of_materials.
3932: -- All options MUST have the top_model_line_ref populated
3933: -- before they come to defaulting. Thus we use it to distinguish
3930: -- We will distinguish an item to be a kit by seeing if
3931: -- it has a record in bom_bill_of_materials.
3932: -- All options MUST have the top_model_line_ref populated
3933: -- before they come to defaulting. Thus we use it to distinguish
3934: -- between a standard and an option item.
3935: -- ato_item's item_type_code will be standard
3936:
3937: oe_debug_pub.add
3938: ('item Org ' || OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'));
3931: -- it has a record in bom_bill_of_materials.
3932: -- All options MUST have the top_model_line_ref populated
3933: -- before they come to defaulting. Thus we use it to distinguish
3934: -- between a standard and an option item.
3935: -- ato_item's item_type_code will be standard
3936:
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);
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
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: