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_MSG_PUB

Line 85: FND_MSG_PUB.initialize;

81: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
82: END IF;
83: -- Initialize message list if p_init_msg_list is set to TRUE.
84: IF FND_API.to_Boolean( p_init_msg_list ) THEN
85: FND_MSG_PUB.initialize;
86: END IF;
87: -- Initialize API return status to success
88: x_return_status := FND_API.G_RET_STS_SUCCESS;
89:

Line 118: FND_MSG_PUB.Add;

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:
122: -- set assembly item id

Line 133: FND_MSG_PUB.Add;

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
137:

Line 165: FND_MSG_PUB.Add;

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
169:

Line 181: FND_MSG_PUB.Add;

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
185:

Line 207: FND_MSG_PUB.Add;

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 <>
211: l_routing_rec.common_routing_sequence_id and

Line 231: FND_MSG_PUB.Add;

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
235: -- noncommon

Line 253: FND_MSG_PUB.Add;

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
257:

Line 271: FND_MSG_PUB.Count_And_Get

267: -- End of API body.
268:
269: -- Standard call to get message count and if count is 1,
270: -- get message info.
271: FND_MSG_PUB.Count_And_Get
272: (p_count => x_msg_count,
273: p_data => x_msg_data
274: );
275: EXCEPTION

Line 278: FND_MSG_PUB.Count_And_Get

274: );
275: EXCEPTION
276: WHEN FND_API.G_EXC_ERROR THEN
277: x_return_status := FND_API.G_RET_STS_ERROR;
278: FND_MSG_PUB.Count_And_Get
279: (p_count => x_msg_count,
280: p_data => x_msg_data
281: );
282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 284: FND_MSG_PUB.Count_And_Get

280: p_data => x_msg_data
281: );
282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: FND_MSG_PUB.Count_And_Get
285: (p_count => x_msg_count,
286: p_data => x_msg_data
287: );
288: WHEN OTHERS THEN

Line 290: IF FND_MSG_PUB.Check_Msg_Level

286: p_data => x_msg_data
287: );
288: WHEN OTHERS THEN
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: IF FND_MSG_PUB.Check_Msg_Level
291: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
292: THEN
293: FND_MSG_PUB.Add_Exc_Msg
294: ( G_PKG_NAME,

Line 291: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

287: );
288: WHEN OTHERS THEN
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: IF FND_MSG_PUB.Check_Msg_Level
291: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
292: THEN
293: FND_MSG_PUB.Add_Exc_Msg
294: ( G_PKG_NAME,
295: l_api_name

Line 293: FND_MSG_PUB.Add_Exc_Msg

289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: IF FND_MSG_PUB.Check_Msg_Level
291: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
292: THEN
293: FND_MSG_PUB.Add_Exc_Msg
294: ( G_PKG_NAME,
295: l_api_name
296: );
297: END IF;

Line 298: FND_MSG_PUB.Count_And_Get

294: ( G_PKG_NAME,
295: l_api_name
296: );
297: END IF;
298: FND_MSG_PUB.Count_And_Get
299: (p_count => x_msg_count,
300: p_data => x_msg_data
301: );
302: END AssignRouting;

Line 552: FND_MSG_PUB.initialize;

548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
549: END IF;
550: -- Initialize message list if p_init_msg_list is set to TRUE.
551: IF FND_API.to_Boolean( p_init_msg_list ) THEN
552: FND_MSG_PUB.initialize;
553: END IF;
554: -- Initialize API return status to success
555: x_return_status := FND_API.G_RET_STS_SUCCESS;
556:

Line 581: FND_MSG_PUB.Add;

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:
585: -- Check for valid alternate

Line 592: FND_MSG_PUB.Add;

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
596:

Line 603: FND_MSG_PUB.Add;

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:
607: -- routing_type must be 1 or 2

Line 611: FND_MSG_PUB.Add;

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:
615: -- Check for unique routing

Line 623: FND_MSG_PUB.Add;

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:
627: -- Check alternate routing has a primary

Line 636: FND_MSG_PUB.Add;

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
640:

Line 648: FND_MSG_PUB.Add;

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:
652: If l_routing_rec.routing_sequence_id <>

Line 660: FND_MSG_PUB.Add;

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:
664: -- Verify common routing attributes

Line 673: FND_MSG_PUB.Add;

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
677:

Line 683: FND_MSG_PUB.Add;

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:
687: If l_routing_rec.completion_subinventory is not null then

Line 729: FND_MSG_PUB.Add;

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:
733: -- Validate locator

Line 738: FND_MSG_PUB.Add;

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:
742: If l_Flags_rec.stock_locator_control_code in (2, 3) and

Line 745: FND_MSG_PUB.Add;

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:
749: If l_Flags_rec.stock_locator_control_code in (2, 3)

Line 758: FND_MSG_PUB.Add;

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
762: For l_Locator_rec in l_RestrictedLocators_csr (

Line 768: FND_MSG_PUB.Add;

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
772: End If; -- check if item location exists

Line 777: FND_MSG_PUB.Add;

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:
781: -- Subinventory level

Line 786: FND_MSG_PUB.Add;

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:
790: If l_Flags_rec.stock_locator_control_code = 4 then

Line 794: FND_MSG_PUB.Add;

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)
798: and l_routing_rec.completion_locator_id is not null then

Line 806: FND_MSG_PUB.Add;

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
810: For l_Location_rec in l_RestrictedLocators_csr (

Line 816: FND_MSG_PUB.Add;

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?
820: End if; -- subinventory required locator

Line 825: FND_MSG_PUB.Add;

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
829:

Line 835: FND_MSG_PUB.Add;

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:
839: If l_Flags_rec.location_control_code in (2, 3)

Line 848: FND_MSG_PUB.Add;

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
852: For l_Location_rec in l_RestrictedLocators_csr (

Line 858: FND_MSG_PUB.Add;

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?
862: End If; -- locator control in (2, 3)

Line 867: FND_MSG_PUB.Add;

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
871: End If; -- Completion SubInventory specified

Line 885: FND_MSG_PUB.Add;

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:
889: If l_routing_rec.line_id is not null then

Line 893: FND_MSG_PUB.Add;

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;
897:

Line 905: FND_MSG_PUB.Add;

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
909:

Line 918: FND_MSG_PUB.Add;

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:
922: If l_routing_rec.ctp_flag = g_yes then

Line 928: FND_MSG_PUB.Add;

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
932:

Line 938: FND_MSG_PUB.Add;

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
942: End if; -- cfm routing

Line 949: FND_MSG_PUB.Count_And_Get

945:
946: -- End of API body.
947: -- Standard call to get message count and if count is 1,
948: -- get message info.
949: FND_MSG_PUB.Count_And_Get
950: (p_count => x_msg_count,
951: p_data => x_msg_data
952: );
953: EXCEPTION

Line 956: FND_MSG_PUB.Count_And_Get

952: );
953: EXCEPTION
954: WHEN FND_API.G_EXC_ERROR THEN
955: x_return_status := FND_API.G_RET_STS_ERROR;
956: FND_MSG_PUB.Count_And_Get
957: (p_count => x_msg_count,
958: p_data => x_msg_data
959: );
960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 962: FND_MSG_PUB.Count_And_Get

958: p_data => x_msg_data
959: );
960: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
961: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
962: FND_MSG_PUB.Count_And_Get
963: (p_count => x_msg_count,
964: p_data => x_msg_data
965: );
966: WHEN OTHERS THEN

Line 968: IF FND_MSG_PUB.Check_Msg_Level

964: p_data => x_msg_data
965: );
966: WHEN OTHERS THEN
967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
968: IF FND_MSG_PUB.Check_Msg_Level
969: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
970: THEN
971: FND_MSG_PUB.Add_Exc_Msg
972: (G_PKG_NAME,

Line 969: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

965: );
966: WHEN OTHERS THEN
967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
968: IF FND_MSG_PUB.Check_Msg_Level
969: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
970: THEN
971: FND_MSG_PUB.Add_Exc_Msg
972: (G_PKG_NAME,
973: l_api_name

Line 971: FND_MSG_PUB.Add_Exc_Msg

967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
968: IF FND_MSG_PUB.Check_Msg_Level
969: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
970: THEN
971: FND_MSG_PUB.Add_Exc_Msg
972: (G_PKG_NAME,
973: l_api_name
974: );
975: END IF;

Line 976: FND_MSG_PUB.Count_And_Get

972: (G_PKG_NAME,
973: l_api_name
974: );
975: END IF;
976: FND_MSG_PUB.Count_And_Get
977: (p_count => x_msg_count,
978: p_data => x_msg_data
979: );
980: END ValidateRouting;

Line 1021: FND_MSG_PUB.initialize;

1017: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1018: END IF;
1019: -- Initialize message list if p_init_msg_list is set to TRUE.
1020: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1021: FND_MSG_PUB.initialize;
1022: END IF;
1023: -- Initialize API return status to success
1024: x_return_status := FND_API.G_RET_STS_SUCCESS;
1025:

Line 1310: FND_MSG_PUB.Count_And_Get

1306: COMMIT WORK;
1307: END IF;
1308: -- Standard call to get message count and if count is 1,
1309: -- get message info.
1310: FND_MSG_PUB.Count_And_Get
1311: (p_count => x_msg_count,
1312: p_data => x_msg_data
1313: );
1314: EXCEPTION

Line 1318: FND_MSG_PUB.Count_And_Get

1314: EXCEPTION
1315: WHEN FND_API.G_EXC_ERROR THEN
1316: ROLLBACK TO CreateRouting_Pvt;
1317: x_return_status := FND_API.G_RET_STS_ERROR;
1318: FND_MSG_PUB.Count_And_Get
1319: (p_count => x_msg_count,
1320: p_data => x_msg_data
1321: );
1322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1325: FND_MSG_PUB.Count_And_Get

1321: );
1322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1323: ROLLBACK TO CreateRouting_Pvt;
1324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1325: FND_MSG_PUB.Count_And_Get
1326: (p_count => x_msg_count,
1327: p_data => x_msg_data
1328: );
1329: WHEN OTHERS THEN

Line 1332: IF FND_MSG_PUB.Check_Msg_Level

1328: );
1329: WHEN OTHERS THEN
1330: ROLLBACK TO CreateRouting_Pvt;
1331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1332: IF FND_MSG_PUB.Check_Msg_Level
1333: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1334: THEN
1335: FND_MSG_PUB.Add_Exc_Msg
1336: (G_PKG_NAME,

Line 1333: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1329: WHEN OTHERS THEN
1330: ROLLBACK TO CreateRouting_Pvt;
1331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1332: IF FND_MSG_PUB.Check_Msg_Level
1333: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1334: THEN
1335: FND_MSG_PUB.Add_Exc_Msg
1336: (G_PKG_NAME,
1337: l_api_name

Line 1335: FND_MSG_PUB.Add_Exc_Msg

1331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1332: IF FND_MSG_PUB.Check_Msg_Level
1333: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1334: THEN
1335: FND_MSG_PUB.Add_Exc_Msg
1336: (G_PKG_NAME,
1337: l_api_name
1338: );
1339: END IF;

Line 1340: FND_MSG_PUB.Count_And_Get

1336: (G_PKG_NAME,
1337: l_api_name
1338: );
1339: END IF;
1340: FND_MSG_PUB.Count_And_Get
1341: (p_count => x_msg_count,
1342: p_data => x_msg_data
1343: );
1344: END CreateRouting;

Line 1396: FND_MSG_PUB.initialize;

1392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1393: END IF;
1394: -- Initialize message list if p_init_msg_list is set to TRUE.
1395: IF FND_API.to_Boolean(p_init_msg_list) THEN
1396: FND_MSG_PUB.initialize;
1397: END IF;
1398: -- Initialize API return status to success
1399: x_return_status := FND_API.G_RET_STS_SUCCESS;
1400:

Line 1540: FND_MSG_PUB.Add;

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:
1544: If p_validation_level > FND_API.G_VALID_LEVEL_NONE then

Line 1628: FND_MSG_PUB.Count_And_Get(

1624: IF FND_API.To_Boolean(p_commit) THEN
1625: COMMIT WORK;
1626: END IF;
1627: -- Standard call to get message count and if count is 1, get message info.
1628: FND_MSG_PUB.Count_And_Get(
1629: p_count => x_msg_count,
1630: p_data => x_msg_data);
1631: EXCEPTION
1632: WHEN FND_API.G_EXC_ERROR THEN

Line 1635: FND_MSG_PUB.Count_And_Get(

1631: EXCEPTION
1632: WHEN FND_API.G_EXC_ERROR THEN
1633: ROLLBACK TO UpdateRouting_Pvt;
1634: x_return_status := FND_API.G_RET_STS_ERROR;
1635: FND_MSG_PUB.Count_And_Get(
1636: p_count => x_msg_count,
1637: p_data => x_msg_data);
1638: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1639: ROLLBACK TO UpdateRouting_Pvt;

Line 1641: FND_MSG_PUB.Count_And_Get(

1637: p_data => x_msg_data);
1638: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1639: ROLLBACK TO UpdateRouting_Pvt;
1640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1641: FND_MSG_PUB.Count_And_Get(
1642: p_count => x_msg_count,
1643: p_data => x_msg_data);
1644: WHEN OTHERS THEN
1645: ROLLBACK TO UpdateRouting_Pvt;

Line 1647: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1643: p_data => x_msg_data);
1644: WHEN OTHERS THEN
1645: ROLLBACK TO UpdateRouting_Pvt;
1646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1647: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1648: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1649: END IF;
1650: FND_MSG_PUB.Count_And_Get(
1651: p_count => x_msg_count,

Line 1648: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1644: WHEN OTHERS THEN
1645: ROLLBACK TO UpdateRouting_Pvt;
1646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1647: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1648: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1649: END IF;
1650: FND_MSG_PUB.Count_And_Get(
1651: p_count => x_msg_count,
1652: p_data => x_msg_data);

Line 1650: FND_MSG_PUB.Count_And_Get(

1646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1647: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1648: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1649: END IF;
1650: FND_MSG_PUB.Count_And_Get(
1651: p_count => x_msg_count,
1652: p_data => x_msg_data);
1653: End UpdateRouting;
1654: PROCEDURE DeleteRouting

Line 1709: FND_MSG_PUB.initialize;

1705: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1706: END IF;
1707: -- Initialize message list if p_init_msg_list is set to TRUE.
1708: IF FND_API.to_Boolean(p_init_msg_list) THEN
1709: FND_MSG_PUB.initialize;
1710: END IF;
1711: -- Initialize API return status to success
1712: x_return_status := FND_API.G_RET_STS_SUCCESS;
1713:

Line 1766: Fnd_Msg_Pub.Add_Exc_Msg (

1762: user_id => l_UserId,
1763: err_text => l_msg_data
1764: );
1765: If l_ReturnCode <> 0 then
1766: Fnd_Msg_Pub.Add_Exc_Msg (
1767: p_pkg_name => 'MODAL_DELETE',
1768: p_procedure_name => 'DELETE_MANAGER_OI',
1769: p_error_text => l_msg_data
1770: );

Line 1777: FND_MSG_PUB.Add;

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:
1781: x_routing_rec := l_routing_rec;

Line 1789: FND_MSG_PUB.Count_And_Get(

1785: IF FND_API.To_Boolean(p_commit) THEN
1786: COMMIT WORK;
1787: END IF;
1788: -- Standard call to get message count and if count is 1, get message info.
1789: FND_MSG_PUB.Count_And_Get(
1790: p_count => x_msg_count,
1791: p_data => x_msg_data
1792: );
1793: EXCEPTION

Line 1797: FND_MSG_PUB.Count_And_Get(

1793: EXCEPTION
1794: WHEN FND_API.G_EXC_ERROR THEN
1795: ROLLBACK TO DeleteRouting_Pvt;
1796: x_return_status := FND_API.G_RET_STS_ERROR;
1797: FND_MSG_PUB.Count_And_Get(
1798: p_count => x_msg_count,
1799: p_data => x_msg_data
1800: );
1801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1804: FND_MSG_PUB.Count_And_Get(

1800: );
1801: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1802: ROLLBACK TO DeleteRouting_Pvt;
1803: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1804: FND_MSG_PUB.Count_And_Get(
1805: p_count => x_msg_count,
1806: p_data => x_msg_data
1807: );
1808: WHEN OTHERS THEN

Line 1811: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1807: );
1808: WHEN OTHERS THEN
1809: ROLLBACK TO DeleteRouting_Pvt;
1810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1811: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1812: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1813: END IF;
1814: FND_MSG_PUB.Count_And_Get(
1815: p_count => x_msg_count,

Line 1812: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

1808: WHEN OTHERS THEN
1809: ROLLBACK TO DeleteRouting_Pvt;
1810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1811: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1812: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1813: END IF;
1814: FND_MSG_PUB.Count_And_Get(
1815: p_count => x_msg_count,
1816: p_data => x_msg_data

Line 1814: FND_MSG_PUB.Count_And_Get(

1810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1811: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1812: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1813: END IF;
1814: FND_MSG_PUB.Count_And_Get(
1815: p_count => x_msg_count,
1816: p_data => x_msg_data
1817: );
1818: END DeleteRouting;