119: -- The ECO can be updated but a warning needs to be generated and
120: -- scheduled revised items need to be update to Open
121: -- and the ECO status need to be changed to Not Submitted for Approval
122:
123: BOM_GLOBALS.Check_Approved_For_Process
124: ( p_change_notice => p_ref_designator_rec.Eco_Name,
125: p_organization_id => p_ref_desg_Unexp_rec.organization_id,
126: x_processed => l_processed,
127: x_err_text => l_err_text
130: IF l_processed = TRUE THEN
131: -- If the above process returns true then set the ECO approval.
132:
133: BEGIN
134: BOM_GLOBALS.Set_Request_For_Approval
135: ( p_change_notice => p_ref_designator_rec.Eco_Name,
136: p_organization_id => p_ref_desg_Unexp_rec.organization_id,
137: x_err_text => l_err_text
138: );
338: * If a ref. designator is being added or deleted, and if the Quantity
339: * Related is 1 then their must be a check that the number of designators
340: * is equal to the component_quantity.
341: *************************************************************************/
342: IF (p_ref_designator_rec.Transaction_Type = BOM_GLOBALS.G_OPR_CREATE) THEN
343: BEGIN
344:
345: OPEN c_QuantityRelated;
346: FETCH c_QuantityRelated INTO l_Quantity;
613: , x_Ref_Desg_Unexp_Rec => x_old_ref_desg_unexp_rec
614: , x_Return_Status => l_return_status
615: );
616:
617: IF l_return_status = BOM_Globals.G_RECORD_FOUND AND
618: p_ref_designator_rec.transaction_type = BOM_Globals.G_OPR_CREATE
619: THEN
620: Error_Handler.Add_Error_Token
621: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
614: , x_Return_Status => l_return_status
615: );
616:
617: IF l_return_status = BOM_Globals.G_RECORD_FOUND AND
618: p_ref_designator_rec.transaction_type = BOM_Globals.G_OPR_CREATE
619: THEN
620: Error_Handler.Add_Error_Token
621: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
622: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
623: , p_message_name => 'ENG_REF_DESG_ALREADY_EXISTS'
624: , p_token_tbl => l_token_tbl
625: );
626: l_return_status := FND_API.G_RET_STS_ERROR;
627: ELSIF l_return_status = BOM_Globals.G_RECORD_NOT_FOUND AND
628: p_ref_designator_rec.transaction_type IN
629: (BOM_Globals.G_OPR_UPDATE, BOM_Globals.G_OPR_DELETE)
630: THEN
631: Error_Handler.Add_Error_Token
625: );
626: l_return_status := FND_API.G_RET_STS_ERROR;
627: ELSIF l_return_status = BOM_Globals.G_RECORD_NOT_FOUND AND
628: p_ref_designator_rec.transaction_type IN
629: (BOM_Globals.G_OPR_UPDATE, BOM_Globals.G_OPR_DELETE)
630: THEN
631: Error_Handler.Add_Error_Token
632: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
633: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl