DBA Data[Home] [Help]

APPS.ENG_VALIDATE_REF_DESIGNATOR dependencies on STANDARD

Line 234: * cannot have ref. desgs and also components which are not Standard cannot

230:
231: /************************************************************************
232: * If the Transaction Type is CREATE and the ACD_type is ADD then check the
233: * type of item to which a ref. designator is being added. Planning bills
234: * cannot have ref. desgs and also components which are not Standard cannot
235: * have ref. desgs. This OR so even if either exists Ref. Designators cannot
236: * be added.
237: *************************************************************************/
238:

Line 240: SELECT 'Non-Standard Comp'

236: * be added.
237: *************************************************************************/
238:
239: BEGIN
240: SELECT 'Non-Standard Comp'
241: INTO l_dummy
242: FROM bom_inventory_Components bic
243: WHERE bic.component_sequence_id =
244: p_Ref_Desg_Unexp_Rec.component_sequence_id

Line 248: -- Generate an error saying that the component is non-standard.

244: p_Ref_Desg_Unexp_Rec.component_sequence_id
245: AND bic.bom_item_type in (1, 2, 3); /*MODEL,OPTION CLASS,PLANNING*/
246:
247: -- If no exception is raised then
248: -- Generate an error saying that the component is non-standard.
249:
250: l_return_status := FND_API.G_RET_STS_ERROR;
251:
252: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 282: END; /* End Checking for non-standard component */

278: );
279:
280: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
281:
282: END; /* End Checking for non-standard component */
283:
284: BEGIN
285: SELECT 'Planning Bill'
286: INTO l_dummy