[Home] [Help]
293: --or delete a substitute component on it
294:
295: IF
296: nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1 AND
297: l_parent_BIT = Bom_Globals.G_STANDARD AND
298: l_parent_PTO_Flag = 'Y' AND
299: l_rec_ATO_Flag = 'Y' AND
300: l_rec_BIT = Bom_Globals.G_STANDARD
301: THEN
296: nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1 AND
297: l_parent_BIT = Bom_Globals.G_STANDARD AND
298: l_parent_PTO_Flag = 'Y' AND
299: l_rec_ATO_Flag = 'Y' AND
300: l_rec_BIT = Bom_Globals.G_STANDARD
301: THEN
302: Error_Handler.Add_Error_Token
303: ( p_message_name => 'BOM_KIT_COMP_PRF_NOT_SET'
304: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
314: nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1 AND
315: l_parent_BIT = Bom_Globals.G_MODEL AND
316: l_parent_PTO_Flag = 'Y' AND
317: l_rec_ATO_Flag = 'Y' AND
318: l_rec_BIT = Bom_Globals.G_STANDARD AND
319: l_rec_optional = 2
320: THEN
321: Error_Handler.Add_Error_Token
322: ( p_message_name => 'BOM_MODEL_COMP_PRF_NOT_SET'
507:
508: /************************************************************************
509: * If the Transaction Type is CREATE and the ACD_type is ADD then check the
510: * type of item to which a ref. designator is being added. Planning bills
511: * cannot have ref. desgs and also components which are not Standard cannot
512: * have ref. desgs. This OR so even if either exists Ref. Designators cannot
513: * be added.
514: *************************************************************************/
515:
513: * be added.
514: *************************************************************************/
515:
516: BEGIN
517: SELECT 'Non-Standard Comp'
518: INTO l_dummy
519: FROM bom_inventory_Components bic
520: WHERE bic.component_sequence_id =
521: p_Ref_Desg_Unexp_Rec.component_sequence_id
521: p_Ref_Desg_Unexp_Rec.component_sequence_id
522: AND bic.bom_item_type in (1, 2, 3); /*MODEL,OPTION CLASS,PLANNING*/
523:
524: -- If no exception is raised then
525: -- Generate an error saying that the component is non-standard.
526:
527: l_return_status := FND_API.G_RET_STS_ERROR;
528:
529: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
555: );
556:
557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
558:
559: END; /* End Checking for non-standard component */
560:
561: BEGIN
562: SELECT 'Planning Bill'
563: INTO l_dummy
896: END;
897:
898: IF
899: nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1 AND
900: l_parent_BIT = Bom_Globals.G_STANDARD AND
901: l_parent_PTO_Flag = 'Y' AND
902: l_rec_ATO_Flag = 'Y' AND
903: l_rec_BIT = Bom_Globals.G_STANDARD
904: THEN
899: nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1 AND
900: l_parent_BIT = Bom_Globals.G_STANDARD AND
901: l_parent_PTO_Flag = 'Y' AND
902: l_rec_ATO_Flag = 'Y' AND
903: l_rec_BIT = Bom_Globals.G_STANDARD
904: THEN
905: Error_Handler.Add_Error_Token
906: ( p_message_name => 'BOM_KIT_COMP_PRF_NOT_SET'
907: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
919: nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1 AND
920: l_parent_BIT = Bom_Globals.G_MODEL AND
921: l_parent_PTO_Flag = 'Y' AND
922: l_rec_ATO_Flag = 'Y' AND
923: l_rec_BIT = Bom_Globals.G_STANDARD AND
924: l_rec_optional = 2
925: THEN
926: Error_Handler.Add_Error_Token
927: ( p_message_name => 'BOM_MODEL_COMP_PRF_NOT_SET'