APPS.BOM_VALIDATE_REF_DESIGNATOR dependencies on STANDARD

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

420:
421: /************************************************************************
422: * If the Transaction Type is CREATE and the ACD_type is ADD then check the
423: * type of item to which a ref. designator is being added. Planning bills
424: * cannot have ref. desgs and also components which are not Standard cannot
425: * have ref. desgs. This OR so even if either exists Ref. Designators cannot
426: * be added.
427: *************************************************************************/
428:

Line 430: SELECT 'Non-Standard Comp'

426: * be added.
427: *************************************************************************/
428:
429: BEGIN
430: SELECT 'Non-Standard Comp'
431: INTO l_dummy
432: FROM bom_inventory_Components bic
433: WHERE bic.component_sequence_id =
434: p_Ref_Desg_Unexp_Rec.component_sequence_id

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

434: p_Ref_Desg_Unexp_Rec.component_sequence_id
435: AND bic.bom_item_type in (1, 2, 3); /*MODEL,OPTION CLASS,PLANNING*/
436:
437: -- If no exception is raised then
438: -- Generate an error saying that the component is non-standard.
439:
440: l_return_status := FND_API.G_RET_STS_ERROR;
441:
442: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

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

468: );
469:
470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
471:
472: END; /* End Checking for non-standard component */
473:
474: BEGIN
475: SELECT 'Planning Bill'
476: INTO l_dummy