[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;
2284: END IF;
2285: END IF;
2286: END IF; -- If Tax handling is exempt
2287:
2288: -- If the TAX handling is STANDARD THEN we can not validate for
2289: -- exemption number because it can be a NULL value.
2290:
2291:
2292: -- If the Tax handling is "Required" then Tax Exempt Number and
2305:
2306: END IF; -- If Tax handling is Required
2307:
2308: -- Check for Tax Exempt number/ Tax Exempt reason code depends on
2309: -- following attributes if the Tax_exempt_flag = 'S' (Standard)
2310:
2311: IF p_line_rec.tax_exempt_flag IS NOT NULL
2312:
2313: THEN
2616:
2617: oe_debug_pub.add('15 '||l_return_status ,1);
2618:
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:
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;
3905: THEN
3906:
3907: oe_debug_pub.add('Bom 4 and flag = N');
3908: -- Following 3 items can have bom_item_type = 4 :
3909: -- STANDARD item, OPTION item and a KIT
3910: -- We will distinguish an item to be a kit by seeing if
3911: -- it has a record in bom_bill_of_materials.
3912: -- All options MUST have the top_model_line_ref populated
3913: -- before they come to defaulting. Thus we use it to distinguish
3910: -- We will distinguish an item to be a kit by seeing if
3911: -- it has a record in bom_bill_of_materials.
3912: -- All options MUST have the top_model_line_ref populated
3913: -- before they come to defaulting. Thus we use it to distinguish
3914: -- between a standard and an option item.
3915: -- ato_item's item_type_code will be standard
3916:
3917: oe_debug_pub.add
3918: ('item Org ' || OE_SYS_PARAMETERS.VALUE('MASTER_ORGANIZATION_ID'));
3911: -- it has a record in bom_bill_of_materials.
3912: -- All options MUST have the top_model_line_ref populated
3913: -- before they come to defaulting. Thus we use it to distinguish
3914: -- between a standard and an option item.
3915: -- ato_item's item_type_code will be standard
3916:
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);
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
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: