DBA Data[Home] [Help]

APPS.BOM_VALIDATE_COMP_OPERATION dependencies on BOM_GLOBALS

Line 338: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Entity Validation for Comp. Operation begins . . .'); END IF;

334: );
335: x_Return_Status := FND_API.G_RET_STS_ERROR;
336: END;
337:
338: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Entity Validation for Comp. Operation begins . . .'); END IF;
339:
340:
341: SELECT msi.bom_enabled_flag
342: INTO l_assy_bom_enabled

Line 349: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Assy Bom Enabled flag : ' || l_assy_bom_enabled); END IF;

345: WHERE bbom.bill_sequence_id = p_bom_comp_ops_Unexp_Rec.bill_sequence_id
346: AND bbom.assembly_item_id = msi.inventory_item_id
347: AND bbom.organization_id = msi.organization_id;
348:
349: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Assy Bom Enabled flag : ' || l_assy_bom_enabled); END IF;
350:
351: IF l_assy_bom_enabled <> 'Y'
352: THEN
353: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 381: If( p_bom_comp_ops_rec.transaction_type = BOM_globals.G_OPR_UPDATE and

377: should be checked for Overlapping entries */
378:
379: l_Additional_Op_Seq_Number := p_bom_comp_ops_rec.additional_operation_seq_num;
380:
381: If( p_bom_comp_ops_rec.transaction_type = BOM_globals.G_OPR_UPDATE and
382: p_bom_comp_ops_rec.new_additional_op_seq_num is not null
383: and p_bom_comp_ops_rec.new_additional_op_seq_num <> FND_API.G_MISS_NUM) then
384: l_Additional_Op_Seq_Number := p_bom_comp_ops_rec.new_additional_op_seq_num;
385: End if;

Line 446: and p_bom_comp_ops_rec.transaction_type = Bom_Globals.G_OPR_UPDATE) THEN

442: the New Component operation does not exists already */
443:
444: IF ( p_bom_comp_ops_rec.new_additional_op_seq_num is not null
445: and p_bom_comp_ops_rec.new_additional_op_seq_num <> FND_API.G_MISS_NUM
446: and p_bom_comp_ops_rec.transaction_type = Bom_Globals.G_OPR_UPDATE) THEN
447:
448: select count(*) into l_temp_var
449: FROM BOM_COMPONENT_OPERATIONS
450: WHERE OPERATION_SEQ_NUM = p_bom_comp_ops_rec.new_additional_op_seq_num

Line 471: IF BOm_GlobalS.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Verified New addtional Component operation ... '); END IF;

467: RAISE FND_API.G_EXC_ERROR;
468: END IF;
469: END IF;
470:
471: IF BOm_GlobalS.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Verified New addtional Component operation ... '); END IF;
472:
473: IF Bom_GlobalS.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Verifying Operation Seq Num in Editable common Bills ... '); END IF;
474: --The op seq num being used must be valid for the editable common bills commoning this bill.
475: IF NOT BOMPCMBM.Check_Op_Seq_In_Ref_Boms(p_src_bill_seq_id => p_bom_comp_ops_unexp_rec.bill_sequence_id,

Line 473: IF Bom_GlobalS.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Verifying Operation Seq Num in Editable common Bills ... '); END IF;

469: END IF;
470:
471: IF BOm_GlobalS.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Verified New addtional Component operation ... '); END IF;
472:
473: IF Bom_GlobalS.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Verifying Operation Seq Num in Editable common Bills ... '); END IF;
474: --The op seq num being used must be valid for the editable common bills commoning this bill.
475: IF NOT BOMPCMBM.Check_Op_Seq_In_Ref_Boms(p_src_bill_seq_id => p_bom_comp_ops_unexp_rec.bill_sequence_id,
476: p_op_seq => nvl(p_bom_comp_ops_rec.new_additional_op_seq_num,
477: p_bom_comp_ops_rec.additional_operation_seq_num)

Line 496: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Expected Error in Comp Operations. Entity Validation '); END IF;

492: EXCEPTION
493:
494: WHEN FND_API.G_EXC_ERROR THEN
495:
496: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Expected Error in Comp Operations. Entity Validation '); END IF;
497:
498: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
499: x_return_status := FND_API.G_RET_STS_ERROR;
500:

Line 503: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('UNExpected Error in Comp. Operations Entity Validation '); END IF;

499: x_return_status := FND_API.G_RET_STS_ERROR;
500:
501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
502:
503: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('UNExpected Error in Comp. Operations Entity Validation '); END IF;
504: x_Mesg_Token_Tbl := l_Mesg_Token_Tbl;
505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
506:
507: WHEN OTHERS THEN

Line 567: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Attribute Validation Starts . . . '); END IF;

563: BEGIN
564:
565: x_return_status := FND_API.G_RET_STS_SUCCESS;
566:
567: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Attribute Validation Starts . . . '); END IF;
568:
569: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Additional Operation Sequence Number is '||to_char(p_bom_comp_ops_rec.additional_operation_seq_num)); END IF;
570:
571: /* Check for the existence of OpSeq in the original routing which is defined for this item */

Line 569: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Additional Operation Sequence Number is '||to_char(p_bom_comp_ops_rec.additional_operation_seq_num)); END IF;

565: x_return_status := FND_API.G_RET_STS_SUCCESS;
566:
567: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Attribute Validation Starts . . . '); END IF;
568:
569: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Additional Operation Sequence Number is '||to_char(p_bom_comp_ops_rec.additional_operation_seq_num)); END IF;
570:
571: /* Check for the existence of OpSeq in the original routing which is defined for this item */
572:
573: FOR r1 IN OpSeq_In_Original

Line 682: IF l_return_status = Bom_Globals.G_RECORD_FOUND AND

678: , x_bom_comp_ops_unexp_rec => x_old_bom_comp_ops_unexp_rec
679: , x_Return_Status => l_return_status
680: );
681:
682: IF l_return_status = Bom_Globals.G_RECORD_FOUND AND
683: p_bom_comp_ops_rec.transaction_type = Bom_Globals.G_OPR_CREATE
684: THEN
685: Error_Handler.Add_Error_Token
686: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl

Line 683: p_bom_comp_ops_rec.transaction_type = Bom_Globals.G_OPR_CREATE

679: , x_Return_Status => l_return_status
680: );
681:
682: IF l_return_status = Bom_Globals.G_RECORD_FOUND AND
683: p_bom_comp_ops_rec.transaction_type = Bom_Globals.G_OPR_CREATE
684: THEN
685: Error_Handler.Add_Error_Token
686: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
687: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 692: ELSIF l_return_status = Bom_Globals.G_RECORD_NOT_FOUND AND

688: , p_message_name => 'BOM_COMP_OPS_ALREADY_EXISTS'
689: , p_token_tbl => l_token_tbl
690: );
691: l_return_status := FND_API.G_RET_STS_ERROR;
692: ELSIF l_return_status = Bom_Globals.G_RECORD_NOT_FOUND AND
693: p_bom_comp_ops_rec.transaction_type IN
694: (Bom_Globals.G_OPR_UPDATE, Bom_Globals.G_OPR_DELETE)
695: THEN
696: Error_Handler.Add_Error_Token

Line 694: (Bom_Globals.G_OPR_UPDATE, Bom_Globals.G_OPR_DELETE)

690: );
691: l_return_status := FND_API.G_RET_STS_ERROR;
692: ELSIF l_return_status = Bom_Globals.G_RECORD_NOT_FOUND AND
693: p_bom_comp_ops_rec.transaction_type IN
694: (Bom_Globals.G_OPR_UPDATE, Bom_Globals.G_OPR_DELETE)
695: THEN
696: Error_Handler.Add_Error_Token
697: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
698: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 720: IF l_return_status = Bom_Globals.G_RECORD_FOUND THEN

716:
717: /* Assign the relevant transaction type for SYNC operations */
718:
719: IF p_bom_comp_ops_rec.transaction_type = 'SYNC' THEN
720: IF l_return_status = Bom_Globals.G_RECORD_FOUND THEN
721: x_old_bom_comp_ops_rec.transaction_type :=
722: Bom_Globals.G_OPR_UPDATE;
723: ELSE
724: x_old_bom_comp_ops_rec.transaction_type :=

Line 722: Bom_Globals.G_OPR_UPDATE;

718:
719: IF p_bom_comp_ops_rec.transaction_type = 'SYNC' THEN
720: IF l_return_status = Bom_Globals.G_RECORD_FOUND THEN
721: x_old_bom_comp_ops_rec.transaction_type :=
722: Bom_Globals.G_OPR_UPDATE;
723: ELSE
724: x_old_bom_comp_ops_rec.transaction_type :=
725: Bom_Globals.G_OPR_CREATE;
726: END IF;

Line 725: Bom_Globals.G_OPR_CREATE;

721: x_old_bom_comp_ops_rec.transaction_type :=
722: Bom_Globals.G_OPR_UPDATE;
723: ELSE
724: x_old_bom_comp_ops_rec.transaction_type :=
725: Bom_Globals.G_OPR_CREATE;
726: END IF;
727: END IF;
728: l_return_status := FND_API.G_RET_STS_SUCCESS;
729: