DBA Data[Home] [Help]

APPS.BOM_ROUTINGREVISION_PVT dependencies on FND_MESSAGE

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

48: l_RtgRevision_rec.organization_id := l_parameter_rec.organization_id;
49: End loop;
50: End if; -- organization code
51: If l_RtgRevision_rec.organization_id is null then
52: Fnd_Message.Set_Name('BOM', 'BOM_ORG_ID_MISSING');
53: FND_MSG_PUB.Add;
54: raise FND_API.G_EXC_ERROR;
55: End if; -- invalid org
56:

Line 66: Fnd_Message.Set_Name('BOM', 'BOM_INV_ITEM_ID_MISSING');

62: item_number_in => l_RtgRevision_rec.inventory_item_number,
63: item_id_out => l_RtgRevision_rec.inventory_item_id,
64: err_text => l_err_text);
65: If l_ret_code <> 0 then
66: Fnd_Message.Set_Name('BOM', 'BOM_INV_ITEM_ID_MISSING');
67: FND_MSG_PUB.Add;
68: Raise FND_API.G_EXC_ERROR;
69: End if;
70: End if;

Line 195: Fnd_Message.Set_Name('BOM', 'BOM_NULL_RTG_REV');

191: End if; -- assign values
192:
193: -- Check if process revision is null
194: If l_RtgRevision_rec.process_revision is null then
195: Fnd_Message.Set_Name('BOM', 'BOM_NULL_RTG_REV');
196: FND_MSG_PUB.Add;
197: Raise FND_API.G_EXC_ERROR;
198: End if;
199:

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

198: End if;
199:
200: -- Check for valid org id
201: For l_org_rec in l_org_csr(P_OrgId => l_RtgRevision_rec.organization_id) loop
202: Fnd_Message.Set_Name('BOM', 'BOM_INVALID_ORG_ID');
203: FND_MSG_PUB.Add;
204: Raise FND_API.G_EXC_ERROR;
205: End loop;
206:

Line 211: Fnd_Message.Set_Name('BOM', 'BOM_INV_ITEM_INVALID');

207: -- Check if assembly item exists
208: For l_item_rec in l_item_csr(
209: P_ItemId => l_RtgRevision_rec.inventory_item_id,
210: P_OrgId => l_RtgRevision_rec.organization_id) loop
211: Fnd_Message.Set_Name('BOM', 'BOM_INV_ITEM_INVALID');
212: FND_MSG_PUB.Add;
213: Raise FND_API.G_EXC_ERROR;
214: End loop;
215:

Line 220: Fnd_Message.Set_Name('BOM', 'BOM_RTG_DOES_NOT_EXIST');

216: -- check if a valid routing exists for this revision
217: For l_routing_rec in l_routing_csr(
218: P_ItemId => l_RtgRevision_rec.inventory_item_id,
219: P_OrgId => l_RtgRevision_rec.organization_id) loop
220: Fnd_Message.Set_Name('BOM', 'BOM_RTG_DOES_NOT_EXIST');
221: FND_MSG_PUB.Add;
222: Raise FND_API.G_EXC_ERROR;
223: End loop;
224:

Line 231: Fnd_Message.Set_Name('BOM', 'BOM_REV_INVALID');

227: P_ItemId => l_RtgRevision_rec.inventory_item_id,
228: P_OrgId => l_RtgRevision_rec.organization_id,
229: P_Revision => l_RtgRevision_rec.process_revision,
230: P_EffDate => l_RtgRevision_rec.effectivity_date) loop
231: Fnd_Message.Set_Name('BOM', 'BOM_REV_INVALID');
232: FND_MSG_PUB.Add;
233: Raise FND_API.G_EXC_ERROR;
234: End loop;
235:

Line 541: Fnd_Message.Set_Name('BOM', 'BOM_REV_INVALID');

537: );
538: WHEN DUP_VAL_ON_INDEX then
539: ROLLBACK TO CreateRtgRevision_Pvt;
540: x_return_status := FND_API.G_RET_STS_ERROR;
541: Fnd_Message.Set_Name('BOM', 'BOM_REV_INVALID');
542: FND_MSG_PUB.Add;
543: FND_MSG_PUB.Count_And_Get(
544: p_count => x_msg_count,
545: p_data => x_msg_data

Line 721: Fnd_Message.Set_Name('BOM', 'BOM_SQL_ERR');

717: l_RtgRevision_rec.attribute15 := l_ExistingRev_rec.attribute15;
718: End if;
719: End loop; -- get old values
720: If not l_RowsFound then
721: Fnd_Message.Set_Name('BOM', 'BOM_SQL_ERR');
722: Fnd_Message.Set_Token('ENTITY', sqlerrm(100));
723: FND_MSG_PUB.Add;
724: Raise FND_API.G_EXC_ERROR;
725: End if;

Line 722: Fnd_Message.Set_Token('ENTITY', sqlerrm(100));

718: End if;
719: End loop; -- get old values
720: If not l_RowsFound then
721: Fnd_Message.Set_Name('BOM', 'BOM_SQL_ERR');
722: Fnd_Message.Set_Token('ENTITY', sqlerrm(100));
723: FND_MSG_PUB.Add;
724: Raise FND_API.G_EXC_ERROR;
725: End if;
726:

Line 901: Fnd_Message.Set_Name('BOM', 'BOM_CANNOT_DELETE_REVISION');

897: For l_date_rec in l_date_csr(
898: P_ItemId => l_RtgRevision_rec.inventory_item_id,
899: P_OrgId => l_RtgRevision_rec.organization_id,
900: P_Rev => l_RtgRevision_rec.process_revision) loop
901: Fnd_Message.Set_Name('BOM', 'BOM_CANNOT_DELETE_REVISION');
902: FND_MSG_PUB.Add;
903: Raise FND_API.G_EXC_ERROR;
904: End loop;
905:

Line 911: Fnd_Message.Set_Name('BOM', 'BOM_SQL_ERR');

907: where inventory_item_id = l_RtgRevision_rec.inventory_item_id
908: and organization_id = l_RtgRevision_rec.organization_id
909: and process_revision = l_RtgRevision_rec.process_revision;
910: If sql%NotFound then
911: Fnd_Message.Set_Name('BOM', 'BOM_SQL_ERR');
912: Fnd_Message.Set_Token('ENTITY', sqlerrm(100));
913: FND_MSG_PUB.Add;
914: Raise FND_API.G_EXC_ERROR;
915: End if;

Line 912: Fnd_Message.Set_Token('ENTITY', sqlerrm(100));

908: and organization_id = l_RtgRevision_rec.organization_id
909: and process_revision = l_RtgRevision_rec.process_revision;
910: If sql%NotFound then
911: Fnd_Message.Set_Name('BOM', 'BOM_SQL_ERR');
912: Fnd_Message.Set_Token('ENTITY', sqlerrm(100));
913: FND_MSG_PUB.Add;
914: Raise FND_API.G_EXC_ERROR;
915: End if;
916: