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_ROUTINGHEADER_PVT dependencies on FND_MESSAGE

Line 117: Fnd_Message.Set_Name('BOM', 'BOM_ORG_ID_MISSING');

113: End if; -- organization code
114:
115: if nvl(l_routing_rec.organization_id, FND_API.G_MISS_NUM) =
116: FND_API.G_MISS_NUM then
117: Fnd_Message.Set_Name('BOM', 'BOM_ORG_ID_MISSING');
118: FND_MSG_PUB.Add;
119: raise FND_API.G_EXC_ERROR;
120: end if; -- organization_id
121:

Line 132: Fnd_Message.Set_Name('BOM', 'BOM_ASSY_ITEM_MISSING');

128: item_number_in => l_routing_rec.assembly_item_number,
129: item_id_out => l_routing_rec.assembly_item_id,
130: err_text => l_err_text);
131: if l_ret_code <> 0 then
132: Fnd_Message.Set_Name('BOM', 'BOM_ASSY_ITEM_MISSING');
133: FND_MSG_PUB.Add;
134: raise FND_API.G_EXC_ERROR;
135: end if; -- parse failed
136: end if; -- assembly item number

Line 164: Fnd_Message.Set_Name('BOM', 'BOM_LOCATION_NAME_INVALID');

160: flex_id => l_routing_rec.completion_locator_id,
161: set_id => -1,
162: err_text => l_err_text);
163: if l_ret_code <> 0 then
164: Fnd_Message.Set_Name('BOM', 'BOM_LOCATION_NAME_INVALID');
165: FND_MSG_PUB.Add;
166: raise FND_API.G_EXC_ERROR;
167: end if; -- invalid locator
168: end if; -- parse completion locator

Line 180: Fnd_Message.Set_Name('BOM', 'BOM_CMN_ASSY_ITEM_INVALID');

176: item_number_in => l_routing_rec.common_item_number,
177: item_id_out => l_routing_rec.common_assembly_item_id,
178: err_text => l_err_text);
179: if l_ret_code <> 0 then
180: Fnd_Message.Set_Name('BOM', 'BOM_CMN_ASSY_ITEM_INVALID');
181: FND_MSG_PUB.Add;
182: raise FND_API.G_EXC_ERROR;
183: end if; -- invalid item id
184: end if; -- common assembly

Line 206: Fnd_Message.Set_Name('BOM', 'BOM_CMN_RTG_SEQ_INVALID');

202: l_routing_rec.completion_locator_id :=
203: nvl(l_routing_rec.completion_locator_id,l_CommonRtg_rec.completion_locator_id);
204: End loop; -- common routing
205: If l_routing_rec.common_routing_sequence_id is null then
206: Fnd_Message.Set_Name('BOM', 'BOM_CMN_RTG_SEQ_INVALID');
207: FND_MSG_PUB.Add;
208: raise FND_API.G_EXC_ERROR;
209: End if; -- could not find routing
210: Elsif l_routing_rec.routing_sequence_id <>

Line 230: Fnd_Message.Set_Name('BOM', 'BOM_CMN_RTG_SEQ_INVALID');

226: l_routing_rec.completion_locator_id :=
227: nvl(l_routing_rec.completion_locator_id,l_CommonAssy_rec.completion_locator_id);
228: end loop; -- common assembly
229: If l_routing_rec.common_assembly_item_id is null then
230: Fnd_Message.Set_Name('BOM', 'BOM_CMN_RTG_SEQ_INVALID');
231: FND_MSG_PUB.Add;
232: raise FND_API.G_EXC_ERROR;
233: End if; -- could not find common assembly
234: Elsif l_routing_rec.routing_sequence_id <> FND_API.G_MISS_NUM then

Line 252: Fnd_Message.Set_Name('BOM', 'BOM_INVALID_LINE');

248: P_Code => l_routing_rec.line_code) loop
249: l_routing_rec.line_id := l_line_rec.line_id;
250: End loop;
251: If l_routing_rec.line_id = FND_API.G_MISS_NUM then
252: Fnd_Message.Set_Name('BOM', 'BOM_INVALID_LINE');
253: FND_MSG_PUB.Add;
254: raise FND_API.G_EXC_ERROR;
255: End if; -- line is missing
256: End if; -- line code

Line 580: Fnd_Message.Set_Name('BOM', 'BOM_INVALID_ORG_ID');

576: -- Check for valid org id
577:
578: For l_org_rec in l_org_csr (
579: P_OrgId => l_routing_rec.organization_id) loop
580: Fnd_Message.Set_Name('BOM', 'BOM_INVALID_ORG_ID');
581: FND_MSG_PUB.Add;
582: Raise FND_API.G_EXC_ERROR;
583: End loop; -- Invalid Organization
584:

Line 591: Fnd_Message.Set_Name('BOM', 'BOM_INVALID_RTG_ALTERNATE');

587: if l_routing_rec.alternate_routing_designator is not null then
588: For l_alternate_rec in l_alternate_csr (
589: P_OrgId => l_routing_rec.organization_id,
590: P_Alt => l_routing_rec.alternate_routing_designator) loop
591: Fnd_Message.Set_Name('BOM', 'BOM_INVALID_RTG_ALTERNATE');
592: FND_MSG_PUB.Add;
593: Raise FND_API.G_EXC_ERROR;
594: End loop; -- invalid alternate
595: End if; -- Check for valid alternate

Line 602: Fnd_Message.Set_Name ('BOM', 'BOM_ASSEMBLY_ITEM_INVALID');

598:
599: For l_item_rec in l_item_csr (
600: P_Org => l_routing_rec.organization_id,
601: P_Item => l_routing_rec.assembly_item_id) loop
602: Fnd_Message.Set_Name ('BOM', 'BOM_ASSEMBLY_ITEM_INVALID');
603: FND_MSG_PUB.Add;
604: Raise FND_API.G_EXC_ERROR;
605: End loop; -- Invalid item id
606:

Line 610: Fnd_Message.Set_Name('BOM', 'BOM_ROUTING_TYPE_INVALID');

606:
607: -- routing_type must be 1 or 2
608:
609: If l_routing_rec.routing_type not in (g_mfg, g_eng) then
610: Fnd_Message.Set_Name('BOM', 'BOM_ROUTING_TYPE_INVALID');
611: FND_MSG_PUB.Add;
612: Raise FND_API.G_EXC_ERROR;
613: End if; -- invalid routing type
614:

Line 622: Fnd_Message.Set_Name('BOM', 'BOM_DUPLICATE_RTG');

618: P_RtgSeqId => l_routing_rec.routing_sequence_id,
619: P_AssyId => l_routing_rec.assembly_item_id,
620: P_OrgId => l_routing_rec.organization_id,
621: P_Alternate => l_routing_rec.alternate_routing_designator) loop
622: Fnd_Message.Set_Name('BOM', 'BOM_DUPLICATE_RTG');
623: FND_MSG_PUB.Add;
624: Raise FND_API.G_EXC_ERROR;
625: End loop; -- duplicate routing
626:

Line 635: Fnd_Message.Set_Name('BOM', 'BOM_INVALID_PRIMARY');

631: For l_primary_rec in l_CheckPrimary_csr (
632: P_OrgId => l_routing_rec.organization_id,
633: P_AssyId => l_routing_rec.assembly_item_id,
634: P_RtgType => l_routing_rec.routing_type) loop
635: Fnd_Message.Set_Name('BOM', 'BOM_INVALID_PRIMARY');
636: FND_MSG_PUB.Add;
637: Raise FND_API.G_EXC_ERROR;
638: End loop; -- invalid primary
639: End if; -- alternate is not null

Line 647: Fnd_Message.Set_Name('BOM', 'BOM_ROUTING_TYPE_ERR');

643: For l_item_rec in l_CheckAttributes_csr (
644: P_OrgId => l_routing_rec.organization_id,
645: P_AssyId => l_routing_rec.assembly_item_id,
646: P_RtgType => l_routing_rec.routing_type) loop
647: Fnd_Message.Set_Name('BOM', 'BOM_ROUTING_TYPE_ERR');
648: FND_MSG_PUB.Add;
649: Raise FND_API.G_EXC_ERROR;
650: End loop; -- invalid item
651:

Line 659: Fnd_Message.Set_Name('BOM', 'BOM_COMMON_RTG_NOT_EXIST');

655: -- Check cmn rtg seq id existence
656:
657: For l_Common_rec in l_CommonRtg_csr(P_RtgSeqId =>
658: l_routing_rec.common_routing_sequence_id) loop
659: Fnd_Message.Set_Name('BOM', 'BOM_COMMON_RTG_NOT_EXIST');
660: FND_MSG_PUB.Add;
661: Raise FND_API.G_EXC_ERROR;
662: End loop; -- nonexistent common
663:

Line 672: Fnd_Message.Set_Name('BOM', 'BOM_COMMON_RTG_ERROR');

668: P_rtg_type => l_routing_rec.routing_type,
669: P_item_id => l_routing_rec.assembly_item_id,
670: P_org_id => l_routing_rec.organization_id,
671: P_alt_desg => l_routing_rec.alternate_routing_designator) loop
672: Fnd_Message.Set_Name('BOM', 'BOM_COMMON_RTG_ERROR');
673: FND_MSG_PUB.Add;
674: Raise FND_API.G_EXC_ERROR;
675: End loop; -- validate common
676: End if; -- common specified

Line 682: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');

678: -- Validate subinventory
679:
680: If l_routing_rec.completion_locator_id is not null
681: and l_routing_rec.completion_subinventory is null then
682: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');
683: FND_MSG_PUB.Add;
684: Raise FND_API.G_EXC_ERROR;
685: End if; -- locator without subinventory
686:

Line 728: Fnd_Message.Set_Name('BOM', 'BOM_SUBINV_INVALID');

724: l_sub_loc_code := l_SubInv_rec.locator_type;
725: End loop; -- get sublocator code
726: End if; -- restricted or nonrestricted subinventory
727: If l_sub_loc_code is null then
728: Fnd_Message.Set_Name('BOM', 'BOM_SUBINV_INVALID');
729: FND_MSG_PUB.Add;
730: Raise FND_API.G_EXC_ERROR;
731: End if;
732:

Line 737: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');

733: -- Validate locator
734: -- Org level
735: If l_Flags_rec.stock_locator_control_code = 1
736: and l_routing_rec.completion_locator_id is not null then
737: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');
738: FND_MSG_PUB.Add;
739: Raise FND_API.G_EXC_ERROR;
740: end if;
741:

Line 744: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');

740: end if;
741:
742: If l_Flags_rec.stock_locator_control_code in (2, 3) and
743: l_routing_rec.completion_locator_id is null then
744: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');
745: FND_MSG_PUB.Add;
746: Raise FND_API.G_EXC_ERROR;
747: end if;
748:

Line 757: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');

753: For l_Locator_rec in l_NonRestrictedLocators_csr (
754: P_Location => l_routing_rec.completion_locator_id,
755: P_OrgId => l_routing_rec.organization_id,
756: P_SubInventory => l_routing_rec.completion_subinventory) loop
757: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');
758: FND_MSG_PUB.Add;
759: Raise FND_API.G_EXC_ERROR;
760: End loop;
761: Else -- restricted locator

Line 767: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');

763: P_Location => l_routing_rec.completion_locator_id,
764: P_OrgId => l_routing_rec.organization_id,
765: P_SubInventory => l_routing_rec.completion_subinventory,
766: P_ItemId => l_routing_rec.assembly_item_id) loop
767: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');
768: FND_MSG_PUB.Add;
769: Raise FND_API.G_EXC_ERROR;
770: End loop;
771: End If; -- restricted or non-restricted locator

Line 776: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');

772: End If; -- check if item location exists
773:
774: If l_Flags_rec.stock_locator_control_code not in (1,2,3,4)
775: and l_routing_rec.completion_locator_id is not null then
776: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');
777: FND_MSG_PUB.Add;
778: Raise FND_API.G_EXC_ERROR;
779: End if;
780:

Line 785: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');

781: -- Subinventory level
782: If l_Flags_rec.stock_locator_control_code = 4
783: and l_sub_loc_code = 1
784: and l_routing_rec.completion_locator_id is not null then
785: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');
786: FND_MSG_PUB.Add;
787: Raise FND_API.G_EXC_ERROR;
788: End if;
789:

Line 793: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');

789:
790: If l_Flags_rec.stock_locator_control_code = 4 then
791: If l_sub_loc_code in (2, 3) and
792: l_routing_rec.completion_locator_id is null then
793: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');
794: FND_MSG_PUB.Add;
795: Raise FND_API.G_EXC_ERROR;
796: End if;
797: If l_sub_loc_code in (2, 3)

Line 805: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');

801: For X_Location in l_NonRestrictedLocators_csr (
802: P_Location => l_routing_rec.completion_locator_id,
803: P_OrgId => l_routing_rec.organization_id,
804: P_SubInventory => l_routing_rec.completion_subinventory) loop
805: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');
806: FND_MSG_PUB.Add;
807: Raise FND_API.G_EXC_ERROR;
808: End loop;
809: Else -- restricted locator

Line 815: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');

811: P_Location => l_routing_rec.completion_locator_id,
812: P_OrgId => l_routing_rec.organization_id,
813: P_SubInventory => l_routing_rec.completion_subinventory,
814: P_ItemId => l_routing_rec.assembly_item_id) loop
815: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');
816: FND_MSG_PUB.Add;
817: Raise FND_API.G_EXC_ERROR;
818: End loop;
819: End If; -- locator exists?

Line 824: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');

820: End if; -- subinventory required locator
821:
822: If l_sub_loc_code not in (1,2,3,5)
823: and l_routing_rec.completion_locator_id is not null then
824: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');
825: FND_MSG_PUB.Add;
826: Raise FND_API.G_EXC_ERROR;
827: End if;
828: End If; -- org locator = 4

Line 834: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');

830: -- Item level
831: If l_Flags_rec.stock_locator_control_code = 4
832: and l_sub_loc_code = 5 and l_Flags_rec.location_control_code = 1
833: and l_routing_rec.completion_locator_id is not null then
834: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');
835: FND_MSG_PUB.Add;
836: Raise FND_API.G_EXC_ERROR;
837: end if;
838:

Line 847: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');

843: For l_Location_rec in l_NonRestrictedLocators_csr (
844: P_Location => l_routing_rec.completion_locator_id,
845: P_OrgId => l_routing_rec.organization_id,
846: P_SubInventory => l_routing_rec.completion_subinventory) loop
847: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');
848: FND_MSG_PUB.Add;
849: Raise FND_API.G_EXC_ERROR;
850: End loop;
851: Else -- restricted locator

Line 857: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');

853: P_Location => l_routing_rec.completion_locator_id,
854: P_OrgId => l_routing_rec.organization_id,
855: P_SubInventory => l_routing_rec.completion_subinventory,
856: P_ItemId => l_routing_rec.assembly_item_id) loop
857: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');
858: FND_MSG_PUB.Add;
859: Raise FND_API.G_EXC_ERROR;
860: End loop;
861: End If; -- locator exists?

Line 866: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');

862: End If; -- locator control in (2, 3)
863:
864: If l_Flags_rec.location_control_code not in (1,2,3)
865: and l_routing_rec.completion_locator_id is not null then
866: Fnd_Message.Set_Name('BOM', 'BOM_LOCATOR_INVALID');
867: FND_MSG_PUB.Add;
868: Raise FND_API.G_EXC_ERROR;
869: End if;
870: End loop; -- SubInvFlags

Line 884: Fnd_Message.Set_Name('BOM', 'BOM_LINE_REQUIRED');

880: End if; -- non-cfm
881:
882: If l_routing_rec.cfm_routing_flag = g_yes
883: and l_routing_rec.line_id is null then
884: Fnd_Message.Set_Name('BOM', 'BOM_LINE_REQUIRED');
885: FND_MSG_PUB.Add;
886: Raise FND_API.G_EXC_ERROR;
887: End if;
888:

Line 892: Fnd_Message.Set_Name('BOM', 'BOM_INVALID_LINE');

888:
889: If l_routing_rec.line_id is not null then
890: For l_line_rec in l_line_csr(
891: p_line_id => l_routing_rec.line_id) loop
892: Fnd_Message.Set_Name('BOM', 'BOM_INVALID_LINE');
893: FND_MSG_PUB.Add;
894: Raise FND_API.G_EXC_ERROR;
895: End loop;
896: End if;

Line 904: Fnd_Message.Set_Name('BOM', 'BOM_MIXED_MODEL_UNIQUE');

900: p_item_id => l_routing_rec.assembly_item_id,
901: p_org_id => l_routing_rec.organization_id,
902: p_alternate => l_routing_rec.alternate_routing_designator,
903: p_line_id => l_routing_rec.line_id) loop
904: Fnd_Message.Set_Name('BOM', 'BOM_MIXED_MODEL_UNIQUE');
905: FND_MSG_PUB.Add;
906: Raise FND_API.G_EXC_ERROR;
907: End loop;
908: End if; -- use in mixed model map

Line 915: Fnd_Message.Set_Name('BOM', 'BOM_UNIQUE_PRIORITY');

911: p_item_id => l_routing_rec.assembly_item_id,
912: p_org_id => l_routing_rec.organization_id,
913: p_alternate => l_routing_rec.alternate_routing_designator,
914: p_priority => l_routing_rec.priority) loop
915: Fnd_Message.Set_Name('BOM', 'BOM_UNIQUE_PRIORITY');
916: Fnd_Message.Set_Token('ENTITY2', null);
917: Fnd_Message.Set_Token('ENTITY', to_char(l_routing_rec.priority));
918: FND_MSG_PUB.Add;
919: Raise FND_API.G_EXC_ERROR;

Line 916: Fnd_Message.Set_Token('ENTITY2', null);

912: p_org_id => l_routing_rec.organization_id,
913: p_alternate => l_routing_rec.alternate_routing_designator,
914: p_priority => l_routing_rec.priority) loop
915: Fnd_Message.Set_Name('BOM', 'BOM_UNIQUE_PRIORITY');
916: Fnd_Message.Set_Token('ENTITY2', null);
917: Fnd_Message.Set_Token('ENTITY', to_char(l_routing_rec.priority));
918: FND_MSG_PUB.Add;
919: Raise FND_API.G_EXC_ERROR;
920: End loop;

Line 917: Fnd_Message.Set_Token('ENTITY', to_char(l_routing_rec.priority));

913: p_alternate => l_routing_rec.alternate_routing_designator,
914: p_priority => l_routing_rec.priority) loop
915: Fnd_Message.Set_Name('BOM', 'BOM_UNIQUE_PRIORITY');
916: Fnd_Message.Set_Token('ENTITY2', null);
917: Fnd_Message.Set_Token('ENTITY', to_char(l_routing_rec.priority));
918: FND_MSG_PUB.Add;
919: Raise FND_API.G_EXC_ERROR;
920: End loop;
921:

Line 927: Fnd_Message.Set_Name('BOM', 'BOM_CTP_UNIQUE');

923: For l_ctp_rec in l_ctp_csr(
924: p_item_id => l_routing_rec.assembly_item_id,
925: p_org_id => l_routing_rec.organization_id,
926: p_alternate => l_routing_rec.alternate_routing_designator) loop
927: Fnd_Message.Set_Name('BOM', 'BOM_CTP_UNIQUE');
928: FND_MSG_PUB.Add;
929: Raise FND_API.G_EXC_ERROR;
930: End loop;
931: End If; -- ctp_flag = yes

Line 937: Fnd_Message.Set_Name('BOM', 'BOM_CANNOT_UPDATE_OI');

933: If l_routing_rec.cfm_routing_flag = g_yes then
934: For l_OldLine_rec in l_OldLine_csr(
935: P_RtgSeqId => l_routing_rec.routing_sequence_id) loop
936: If l_OldLine_rec.line_id <> l_routing_rec.line_id then
937: Fnd_Message.Set_Name('BOM', 'BOM_CANNOT_UPDATE_OI');
938: FND_MSG_PUB.Add;
939: Raise FND_API.G_EXC_ERROR;
940: End if; -- line changed
941: End loop; -- old routing

Line 1539: Fnd_Message.Set_Name('BOM', 'BOM_ROUTING_MISSING');

1535: End if;
1536: End loop; -- get old values
1537:
1538: If not l_RowFound then -- old routing not found
1539: Fnd_Message.Set_Name('BOM', 'BOM_ROUTING_MISSING');
1540: FND_MSG_PUB.Add;
1541: Raise FND_API.G_EXC_ERROR;
1542: End if; -- missing routing
1543:

Line 1776: Fnd_Message.Set_Name('BOM', 'BOM_ROUTING_MISSING');

1772: End if; -- SQL error in modal delete
1773: End loop; -- Add to delete group
1774:
1775: If not l_RowFound then -- old routing not found
1776: Fnd_Message.Set_Name('BOM', 'BOM_ROUTING_MISSING');
1777: FND_MSG_PUB.Add;
1778: Raise FND_API.G_EXC_ERROR;
1779: End if; -- missing routing
1780: