eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_VALIDATE_COMP_OPERATION dependencies on BOM_GLOBALS

Line 322: IF Bom_Globals.Get_Caller_Type <> 'MIGRATION' THEN

318:
319: BEGIN
320:
321: BEGIN
322: IF Bom_Globals.Get_Caller_Type <> 'MIGRATION' THEN
323: SELECT 1
324: INTO p_dummy
325: FROM bom_bill_of_materials
326: WHERE bill_sequence_id = source_bill_sequence_id

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

565: BEGIN
566:
567: x_return_status := FND_API.G_RET_STS_SUCCESS;
568:
569: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Attribute Validation Starts . . . '); END IF;
570:
571: 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;
572:
573: /* Check for the existence of OpSeq in the original routing which is defined for this item */

Line 571: 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;

567: x_return_status := FND_API.G_RET_STS_SUCCESS;
568:
569: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Attribute Validation Starts . . . '); END IF;
570:
571: 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;
572:
573: /* Check for the existence of OpSeq in the original routing which is defined for this item */
574:
575: FOR r1 IN OpSeq_In_Original

Line 684: IF l_return_status = Bom_Globals.G_RECORD_FOUND AND

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

Line 685: p_bom_comp_ops_rec.transaction_type = Bom_Globals.G_OPR_CREATE

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

Line 694: ELSIF l_return_status = Bom_Globals.G_RECORD_NOT_FOUND AND

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

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

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

Line 722: IF l_return_status = Bom_Globals.G_RECORD_FOUND THEN

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

Line 724: Bom_Globals.G_OPR_UPDATE;

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

Line 727: Bom_Globals.G_OPR_CREATE;

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