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_SUB_COMPONENT dependencies on BOM_GLOBALS

Line 58: Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_ECO_BO

54: p_sub_component_rec.New_Revised_Item_Revision IS NULL OR
55: p_sub_component_rec.New_Revised_Item_Revision =
56: FND_API.G_MISS_CHAR
57: ) AND
58: Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_ECO_BO
59: )
60: THEN
61: x_return_status := FND_API.G_RET_STS_ERROR;
62: Error_Handler.Add_Error_Token

Line 170: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Bill SequenceId : ' || to_char(l_rec_BSI)); END IF;

166: EXCEPTION
167: WHEN OTHERS THEN
168: NULL;
169: END;
170: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Bill SequenceId : ' || to_char(l_rec_BSI)); END IF;
171: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Assembly Type : ' || to_char(l_rec_AST)); END IF;
172: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Comp SequenceId : ' || to_char(p_Sub_Comp_Unexp_Rec.component_sequence_id)); END IF;
173:
174: if bom_globals.get_debug = 'Y' then Error_Handler.write_debug('Sub Comp: Checking for editable common bill...'); END IF;

Line 171: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Assembly Type : ' || to_char(l_rec_AST)); END IF;

167: WHEN OTHERS THEN
168: NULL;
169: END;
170: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Bill SequenceId : ' || to_char(l_rec_BSI)); END IF;
171: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Assembly Type : ' || to_char(l_rec_AST)); END IF;
172: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Comp SequenceId : ' || to_char(p_Sub_Comp_Unexp_Rec.component_sequence_id)); END IF;
173:
174: if bom_globals.get_debug = 'Y' then Error_Handler.write_debug('Sub Comp: Checking for editable common bill...'); END IF;
175:

Line 172: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Comp SequenceId : ' || to_char(p_Sub_Comp_Unexp_Rec.component_sequence_id)); END IF;

168: NULL;
169: END;
170: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Bill SequenceId : ' || to_char(l_rec_BSI)); END IF;
171: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Assembly Type : ' || to_char(l_rec_AST)); END IF;
172: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Comp SequenceId : ' || to_char(p_Sub_Comp_Unexp_Rec.component_sequence_id)); END IF;
173:
174: if bom_globals.get_debug = 'Y' then Error_Handler.write_debug('Sub Comp: Checking for editable common bill...'); END IF;
175:
176: --validation for BOM ER #9946990

Line 174: if bom_globals.get_debug = 'Y' then Error_Handler.write_debug('Sub Comp: Checking for editable common bill...'); END IF;

170: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Bill SequenceId : ' || to_char(l_rec_BSI)); END IF;
171: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Assembly Type : ' || to_char(l_rec_AST)); END IF;
172: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Comp SequenceId : ' || to_char(p_Sub_Comp_Unexp_Rec.component_sequence_id)); END IF;
173:
174: if bom_globals.get_debug = 'Y' then Error_Handler.write_debug('Sub Comp: Checking for editable common bill...'); END IF;
175:
176: --validation for BOM ER #9946990
177: --if an ATO item was added in a kit when the related profile was set, you cannot
178: --update the component once the profile is unset (meaning you cannot insert, update or delete

Line 184: l_parent_BIT = Bom_Globals.G_STANDARD AND

180: --BOM ER #9946990 changes (begin)
181:
182: IF
183: nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1 AND
184: l_parent_BIT = Bom_Globals.G_STANDARD AND
185: l_parent_PTO_Flag = 'Y' AND
186: l_rec_ATO_Flag = 'Y' AND
187: l_rec_BIT = Bom_Globals.G_STANDARD
188: THEN

Line 187: l_rec_BIT = Bom_Globals.G_STANDARD

183: nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1 AND
184: l_parent_BIT = Bom_Globals.G_STANDARD AND
185: l_parent_PTO_Flag = 'Y' AND
186: l_rec_ATO_Flag = 'Y' AND
187: l_rec_BIT = Bom_Globals.G_STANDARD
188: THEN
189: Error_Handler.Add_Error_Token
190: ( p_message_name => 'BOM_KIT_COMP_PRF_NOT_SET'
191: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 205: l_parent_BIT = Bom_Globals.G_MODEL AND

201: --or delete a substitute component on it
202:
203: IF
204: nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1 AND
205: l_parent_BIT = Bom_Globals.G_MODEL AND
206: l_parent_PTO_Flag = 'Y' AND
207: l_rec_ATO_Flag = 'Y' AND
208: l_rec_BIT = Bom_Globals.G_STANDARD AND
209: l_rec_optional = 2

Line 208: l_rec_BIT = Bom_Globals.G_STANDARD AND

204: nvl(fnd_profile.value('BOM:MANDATORY_ATO_IN_PTO'), 2) <> 1 AND
205: l_parent_BIT = Bom_Globals.G_MODEL AND
206: l_parent_PTO_Flag = 'Y' AND
207: l_rec_ATO_Flag = 'Y' AND
208: l_rec_BIT = Bom_Globals.G_STANDARD AND
209: l_rec_optional = 2
210: THEN
211: Error_Handler.Add_Error_Token
212: ( p_message_name => 'BOM_MODEL_COMP_PRF_NOT_SET'

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

218: END IF;
219: --BOM ER #9946990 changes (end)
220:
221: BEGIN
222: IF Bom_Globals.Get_Caller_Type <> 'MIGRATION' THEN
223: SELECT 1
224: INTO l_dummy
225: FROM bom_bill_of_materials
226: WHERE bill_sequence_id = source_bill_sequence_id

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

244: WHERE bbom.bill_sequence_id = l_rec_BSI
245: AND bbom.assembly_item_id = msi.inventory_item_id
246: AND bbom.organization_id = msi.organization_id;
247:
248: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Assy Bom Enabled flag : ' || l_assy_bom_enabled); END IF;
249:
250: IF l_assy_bom_enabled <> 'Y'
251: THEN
252: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 276: IF p_sub_component_rec.Transaction_Type = Bom_Globals.G_OPR_CREATE THEN

272: -- added. Planning bills cannot have sub comps esgs and also |
273: -- components which are not Standard cannot have sub comps. This |
274: -- OR so even if either exists sub comp cannot be added. |
275: ---------------------------------------------------------------------
276: IF p_sub_component_rec.Transaction_Type = Bom_Globals.G_OPR_CREATE THEN
277:
278: BEGIN
279: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Checking for planning bill or non-std. component . . . '); END IF;
280:

Line 279: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Checking for planning bill or non-std. component . . . '); END IF;

275: ---------------------------------------------------------------------
276: IF p_sub_component_rec.Transaction_Type = Bom_Globals.G_OPR_CREATE THEN
277:
278: BEGIN
279: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Checking for planning bill or non-std. component . . . '); END IF;
280:
281: IF l_rec_bit IN (1, 2, 3, 5)
282: THEN
283: l_err_text := 'BOM_SBC_NON_STD_PARENT';

Line 344: IF (p_sub_component_rec.Transaction_Type = Bom_Globals.G_OPR_UPDATE OR

340: -- 'Approval approved') we should change status to not submitted |
341: -- for Approval |
342: ------------------------------------------------------------------
343: stmt_num := 2;
344: IF (p_sub_component_rec.Transaction_Type = Bom_Globals.G_OPR_UPDATE OR
345: p_sub_component_rec.Transaction_Type = Bom_Globals.G_OPR_CREATE)
346: AND
347: Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_ECO_BO
348: THEN

Line 345: p_sub_component_rec.Transaction_Type = Bom_Globals.G_OPR_CREATE)

341: -- for Approval |
342: ------------------------------------------------------------------
343: stmt_num := 2;
344: IF (p_sub_component_rec.Transaction_Type = Bom_Globals.G_OPR_UPDATE OR
345: p_sub_component_rec.Transaction_Type = Bom_Globals.G_OPR_CREATE)
346: AND
347: Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_ECO_BO
348: THEN
349: Bom_Globals.Check_Approved_For_Process

Line 347: Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_ECO_BO

343: stmt_num := 2;
344: IF (p_sub_component_rec.Transaction_Type = Bom_Globals.G_OPR_UPDATE OR
345: p_sub_component_rec.Transaction_Type = Bom_Globals.G_OPR_CREATE)
346: AND
347: Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_ECO_BO
348: THEN
349: Bom_Globals.Check_Approved_For_Process
350: ( p_change_notice => p_sub_component_rec.Eco_Name
351: , p_organization_id => p_Sub_Comp_Unexp_Rec.Organization_Id

Line 349: Bom_Globals.Check_Approved_For_Process

345: p_sub_component_rec.Transaction_Type = Bom_Globals.G_OPR_CREATE)
346: AND
347: Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_ECO_BO
348: THEN
349: Bom_Globals.Check_Approved_For_Process
350: ( p_change_notice => p_sub_component_rec.Eco_Name
351: , p_organization_id => p_Sub_Comp_Unexp_Rec.Organization_Id
352: , x_processed =>l_processed
353: , x_err_text =>l_err_text

Line 356: Bom_Globals.Set_Request_For_Approval(

352: , x_processed =>l_processed
353: , x_err_text =>l_err_text
354: );
355: IF (l_processed) THEN
356: Bom_Globals.Set_Request_For_Approval(
357: p_change_notice => p_sub_component_rec.Eco_Name
358: ,p_organization_id => p_Sub_Comp_Unexp_Rec.Organization_Id
359: ,x_err_text => l_err_text);
360: END IF;

Line 370: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Verify sub. comp. exists in MTL_System_Item with correct attributes . . .'); END IF;

366: -----------------------------------------------------------------------
367:
368: stmt_num := 7;
369: BEGIN
370: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Verify sub. comp. exists in MTL_System_Item with correct attributes . . .'); END IF;
371:
372: SELECT bom_item_type, bom_enabled_flag, eng_item_flag ,tracking_quantity_ind
373: INTO l_sbc_item_type, l_sbc_bom_enabled_flag, l_sbc_eng_item_flag,l_sbc_tracking_qty_ind
374: FROM mtl_system_items

Line 449: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Verfying component for other common orgs . . . '); END IF;

445: -- Component Item exists in those orgs |
446: -------------------------------------------------------------------
447: stmt_num := 8;
448: BEGIN
449: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Verfying component for other common orgs . . . '); END IF;
450:
451: SELECT 1
452: INTO l_dummy
453: FROM bom_bill_of_materials bbom

Line 499: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Verifying sub. comp not same as parent . . . '); END IF;

495: ---------------------------------------------------------
496: -- Verify sub comp is not the same as bill or component |
497: ---------------------------------------------------------
498: stmt_num := 9;
499: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Verifying sub. comp not same as parent . . . '); END IF;
500:
501: IF (p_Sub_Component_Rec.Transaction_Type = Bom_Globals.G_OPR_UPDATE AND
502: p_Sub_Comp_Unexp_Rec.New_Substitute_Component_Id IN
503: (l_rec_AII, l_rec_CII))

Line 501: IF (p_Sub_Component_Rec.Transaction_Type = Bom_Globals.G_OPR_UPDATE AND

497: ---------------------------------------------------------
498: stmt_num := 9;
499: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Verifying sub. comp not same as parent . . . '); END IF;
500:
501: IF (p_Sub_Component_Rec.Transaction_Type = Bom_Globals.G_OPR_UPDATE AND
502: p_Sub_Comp_Unexp_Rec.New_Substitute_Component_Id IN
503: (l_rec_AII, l_rec_CII))
504: OR
505: (p_Sub_Component_Rec.Transaction_Type = Bom_Globals.G_OPR_CREATE AND

Line 505: (p_Sub_Component_Rec.Transaction_Type = Bom_Globals.G_OPR_CREATE AND

501: IF (p_Sub_Component_Rec.Transaction_Type = Bom_Globals.G_OPR_UPDATE AND
502: p_Sub_Comp_Unexp_Rec.New_Substitute_Component_Id IN
503: (l_rec_AII, l_rec_CII))
504: OR
505: (p_Sub_Component_Rec.Transaction_Type = Bom_Globals.G_OPR_CREATE AND
506: p_Sub_Comp_Unexp_Rec.Substitute_Component_Id IN
507: (l_rec_AII,l_rec_CII))
508: THEN
509: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 537: IF Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_ECO_BO

533: --
534: -- Peform this set of validations only if the ECO BO is calling the
535: -- validation package
536: --
537: IF Bom_Globals.Get_Bo_Identifier = Bom_Globals.G_ECO_BO
538: THEN
539: IF l_parent_acd_type = 3 THEN
540: l_return_status := FND_API.G_RET_STS_ERROR;
541: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 575: AND ( p_Sub_Component_Rec.Transaction_Type = Bom_Globals.G_OPR_CREATE OR

571: ------------------------------------------------------------------------
572: stmt_num := 13;
573: /*
574: IF p_sub_component_rec.acd_type <> 3
575: AND ( p_Sub_Component_Rec.Transaction_Type = Bom_Globals.G_OPR_CREATE OR
576: p_Sub_Component_Rec.Transaction_Type = Bom_Globals.G_OPR_UPDATE
577: )
578: THEN
579:

Line 576: p_Sub_Component_Rec.Transaction_Type = Bom_Globals.G_OPR_UPDATE

572: stmt_num := 13;
573: /*
574: IF p_sub_component_rec.acd_type <> 3
575: AND ( p_Sub_Component_Rec.Transaction_Type = Bom_Globals.G_OPR_CREATE OR
576: p_Sub_Component_Rec.Transaction_Type = Bom_Globals.G_OPR_UPDATE
577: )
578: THEN
579:
580:

Line 596: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Verifying if component is not disable type . . . '); END IF;

592: -------------------------------------------------------------------------
593:
594: IF p_sub_component_rec.acd_type = 3 THEN
595: BEGIN
596: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Verifying if component is not disable type . . . '); END IF;
597:
598: SELECT count(*)
599: INTO l_dummy
600: FROM bom_substitute_components sub_comp,

Line 609: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug

605: rev_comp.old_component_Sequence_id
606: AND sub_comp.Substitute_Component_Id =
607: p_Sub_Comp_Unexp_Rec.Substitute_Component_Id;
608:
609: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug
610: ( 'Sub Components found: ' || l_dummy);
611: END IF;
612:
613: IF (l_dummy = 0)

Line 653: and p_sub_component_rec.transaction_type = Bom_Globals.G_OPR_UPDATE) THEN

649: New Substitute Component does not exists already */
650:
651: IF ( p_Sub_Comp_Unexp_Rec.new_substitute_component_id is not null
652: and p_Sub_Comp_Unexp_Rec.new_substitute_component_id <> FND_API.G_MISS_NUM
653: and p_sub_component_rec.transaction_type = Bom_Globals.G_OPR_UPDATE) THEN
654:
655: select count(*) into l_temp_var
656: FROM BOM_SUBSTITUTE_COMPONENTS
657: WHERE substitute_component_id = p_Sub_Comp_Unexp_Rec.new_substitute_component_id

Line 680: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Verified New Substitute Component ...'); END IF;

676: RAISE FND_API.G_EXC_ERROR;
677: END IF;
678: END IF;
679:
680: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('Verified New Substitute Component ...'); END IF;
681:
682:
683:
684: EXCEPTION

Line 892: IF l_return_status = Bom_Globals.G_RECORD_FOUND AND

888: ELSE
889: Error_Handler.Write_Debug('In SCOMP Check Exist...'||p_sub_component_rec.transaction_type);
890: END IF;
891:
892: IF l_return_status = Bom_Globals.G_RECORD_FOUND AND
893: p_sub_component_rec.transaction_type = Bom_Globals.G_OPR_CREATE
894: THEN
895: Error_Handler.Add_Error_Token
896: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl

Line 893: p_sub_component_rec.transaction_type = Bom_Globals.G_OPR_CREATE

889: Error_Handler.Write_Debug('In SCOMP Check Exist...'||p_sub_component_rec.transaction_type);
890: END IF;
891:
892: IF l_return_status = Bom_Globals.G_RECORD_FOUND AND
893: p_sub_component_rec.transaction_type = Bom_Globals.G_OPR_CREATE
894: THEN
895: Error_Handler.Add_Error_Token
896: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
897: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 902: ELSIF l_return_status = Bom_Globals.G_RECORD_NOT_FOUND AND

898: , p_message_name => 'BOM_SUB_COMP_ALREADY_EXISTS'
899: , p_token_tbl => l_token_tbl
900: );
901: l_return_status := FND_API.G_RET_STS_ERROR;
902: ELSIF l_return_status = Bom_Globals.G_RECORD_NOT_FOUND AND
903: p_sub_component_rec.transaction_type IN
904: (Bom_Globals.G_OPR_UPDATE, Bom_Globals.G_OPR_DELETE)
905: THEN
906: Error_Handler.Add_Error_Token

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

900: );
901: l_return_status := FND_API.G_RET_STS_ERROR;
902: ELSIF l_return_status = Bom_Globals.G_RECORD_NOT_FOUND AND
903: p_sub_component_rec.transaction_type IN
904: (Bom_Globals.G_OPR_UPDATE, Bom_Globals.G_OPR_DELETE)
905: THEN
906: Error_Handler.Add_Error_Token
907: ( x_Mesg_token_tbl => l_Mesg_Token_Tbl
908: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 930: IF l_return_status = Bom_Globals.G_RECORD_FOUND THEN

926:
927: /* Assign the relevant transaction type for SYNC operations */
928:
929: IF p_sub_component_rec.transaction_type = 'SYNC' THEN
930: IF l_return_status = Bom_Globals.G_RECORD_FOUND THEN
931: x_old_sub_component_rec.transaction_type :=
932: Bom_Globals.G_OPR_UPDATE;
933: ELSE
934: x_old_sub_component_rec.transaction_type :=

Line 932: Bom_Globals.G_OPR_UPDATE;

928:
929: IF p_sub_component_rec.transaction_type = 'SYNC' THEN
930: IF l_return_status = Bom_Globals.G_RECORD_FOUND THEN
931: x_old_sub_component_rec.transaction_type :=
932: Bom_Globals.G_OPR_UPDATE;
933: ELSE
934: x_old_sub_component_rec.transaction_type :=
935: Bom_Globals.G_OPR_CREATE;
936: END IF;

Line 935: Bom_Globals.G_OPR_CREATE;

931: x_old_sub_component_rec.transaction_type :=
932: Bom_Globals.G_OPR_UPDATE;
933: ELSE
934: x_old_sub_component_rec.transaction_type :=
935: Bom_Globals.G_OPR_CREATE;
936: END IF;
937: END IF;
938: l_return_status := FND_API.G_RET_STS_SUCCESS;
939: END IF;

Line 1052: IF (l_OPM_org='Y' and SubCompType.bom_item_type in ( Bom_Globals.G_MODEL, Bom_Globals.G_OPTION_CLASS))THEN

1048:
1049: /* Validations for OPM Convergence Project
1050: Model/Option class items are not allowed in OPM organizations*/
1051:
1052: IF (l_OPM_org='Y' and SubCompType.bom_item_type in ( Bom_Globals.G_MODEL, Bom_Globals.G_OPTION_CLASS))THEN
1053: Error_Handler.Add_Error_Token
1054: ( p_Message_name => 'BOM_OPM_ORG_MODEL_OC'
1055: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1056: , x_mesg_token_tbl => l_mesg_token_tbl

Line 1059: ELSIF SubCompType.bom_item_type = Bom_Globals.G_PRODUCT_FAMILY

1055: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1056: , x_mesg_token_tbl => l_mesg_token_tbl
1057: );
1058: l_return_status := FND_API.G_RET_STS_ERROR;
1059: ELSIF SubCompType.bom_item_type = Bom_Globals.G_PRODUCT_FAMILY
1060: THEN
1061: Error_Handler.Add_Error_Token
1062: ( p_Message_Name => 'BOM_SUB_COMP_PF'
1063: , p_mesg_token_tbl => l_mesg_token_tbl

Line 1069: (NVL(Bom_Globals.Get_MDL_Item_Access,0),

1065: , p_token_tbl => l_token_tbl
1066: );
1067: l_return_status := FND_API.G_RET_STS_ERROR;
1068: ELSIF SubCompType.bom_item_type NOT IN
1069: (NVL(Bom_Globals.Get_MDL_Item_Access,0),
1070: NVL(Bom_Globals.Get_OC_Item_Access,0),
1071: NVL(Bom_Globals.Get_PLN_Item_Access,0),
1072: NVL(Bom_Globals.Get_STD_Item_Access,0)
1073: )

Line 1070: NVL(Bom_Globals.Get_OC_Item_Access,0),

1066: );
1067: l_return_status := FND_API.G_RET_STS_ERROR;
1068: ELSIF SubCompType.bom_item_type NOT IN
1069: (NVL(Bom_Globals.Get_MDL_Item_Access,0),
1070: NVL(Bom_Globals.Get_OC_Item_Access,0),
1071: NVL(Bom_Globals.Get_PLN_Item_Access,0),
1072: NVL(Bom_Globals.Get_STD_Item_Access,0)
1073: )
1074: THEN

Line 1071: NVL(Bom_Globals.Get_PLN_Item_Access,0),

1067: l_return_status := FND_API.G_RET_STS_ERROR;
1068: ELSIF SubCompType.bom_item_type NOT IN
1069: (NVL(Bom_Globals.Get_MDL_Item_Access,0),
1070: NVL(Bom_Globals.Get_OC_Item_Access,0),
1071: NVL(Bom_Globals.Get_PLN_Item_Access,0),
1072: NVL(Bom_Globals.Get_STD_Item_Access,0)
1073: )
1074: THEN
1075: l_token_tbl(1).token_name := 'REV_COMP';

Line 1072: NVL(Bom_Globals.Get_STD_Item_Access,0)

1068: ELSIF SubCompType.bom_item_type NOT IN
1069: (NVL(Bom_Globals.Get_MDL_Item_Access,0),
1070: NVL(Bom_Globals.Get_OC_Item_Access,0),
1071: NVL(Bom_Globals.Get_PLN_Item_Access,0),
1072: NVL(Bom_Globals.Get_STD_Item_Access,0)
1073: )
1074: THEN
1075: l_token_tbl(1).token_name := 'REV_COMP';
1076: l_token_tbl(1).token_value :=