DBA Data[Home] [Help]

APPS.EAM_ASSET_ROUTES_PUB dependencies on FND_MSG_PUB

Line 104: FND_MSG_PUB.ADD;

100: BEGIN
101:
102:
103: FND_MESSAGE.SET_NAME ('EAM', ERROR);
104: FND_MSG_PUB.ADD;
105: RAISE FND_API.G_EXC_ERROR;
106: END;
107:
108: PROCEDURE validate_object_id(p_organization_id in number,

Line 156: fnd_msg_pub.add;

152: THEN
153: IF P_OBJECT_ID <> L_GEN_OBJ_ID
154: THEN
155: fnd_message.set_name('EAM', 'EAM_ARO_INV_GENOBJ_NOTFOUND');
156: fnd_msg_pub.add;
157: RAISE fnd_api.g_exc_error;
158: END IF;
159: ELSE
160: fnd_message.set_name('EAM', 'EAM_ARO_INV_GENOBJ_NOTFOUND');

Line 161: fnd_msg_pub.add;

157: RAISE fnd_api.g_exc_error;
158: END IF;
159: ELSE
160: fnd_message.set_name('EAM', 'EAM_ARO_INV_GENOBJ_NOTFOUND');
161: fnd_msg_pub.add;
162: RAISE fnd_api.g_exc_error;
163: END IF;
164:
165: elsif p_eam_item_type = 2

Line 168: fnd_msg_pub.add;

164:
165: elsif p_eam_item_type = 2
166: then
167: fnd_message.set_name('EAM', 'EAM_ARO_INV_ASSET_TYPE');
168: fnd_msg_pub.add;
169: RAISE fnd_api.g_exc_error;
170: end if;
171:
172: END;

Line 241: FND_MSG_PUB.Add;

237: )
238: then
239: FND_MESSAGE.SET_NAME('EAM', 'EAM_INVALID_DESC_FLEX');
240: FND_MESSAGE.SET_TOKEN('ERROR_MSG', l_error_message);
241: FND_MSG_PUB.Add;
242: RAISE FND_API.G_EXC_ERROR;
243: end if;
244:
245: end validate_dff_segments;

Line 271: fnd_msg_pub.add;

267: decode(p_create_flag, 0, p_network_association_id,1);
268: if (l_count = 0) then
269: if (p_create_flag = 0) then
270: fnd_message.set_name('EAM', 'EAM_NETWORK_REC_NOT_FOUND');
271: fnd_msg_pub.add;
272: RAISE fnd_api.g_exc_error;
273: END IF;
274: else
275: if (p_create_flag = 1) then

Line 277: fnd_msg_pub.add;

273: END IF;
274: else
275: if (p_create_flag = 1) then
276: fnd_message.set_name('EAM', 'EAM_NETWORK_REC_EXISTS');
277: fnd_msg_pub.add;
278: RAISE fnd_api.g_exc_error;
279: END IF;
280: end if;
281: END;

Line 364: FND_MSG_PUB.initialize;

360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
361: END IF;
362: -- Initialize message list if p_init_msg_list is set to TRUE.
363: IF FND_API.to_Boolean( p_init_msg_list ) THEN
364: FND_MSG_PUB.initialize;
365: END IF;
366: -- Initialize API return status to success
367: x_return_status := FND_API.G_RET_STS_SUCCESS;
368: -- API body

Line 388: fnd_msg_pub.add;

384: x_msg_data => l_msg_data);
385: if l_boolean = 0
386: then
387: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_ORG_ID');
388: fnd_msg_pub.add;
389: RAISE fnd_api.g_exc_error;
390: end if;
391:
392:

Line 399: fnd_msg_pub.add;

395: (p_network_object_id is null or p_network_object_type is null) and
396: (p_network_asset_number is null)) OR
397: (p_network_object_type is not null and p_network_object_type <> 3)) THEN
398: fnd_message.set_name('EAM', 'EAM_NETWORK_REC_NOT_FOUND');
399: fnd_msg_pub.add;
400: RAISE FND_API.G_EXC_ERROR;
401: END IF;
402:
403:

Line 409: fnd_msg_pub.add;

405: (p_inventory_item_id is null or p_serial_number is null) and
406: (p_asset_number is null)) OR
407: (p_maintenance_object_type is not null and p_maintenance_object_type <> 3)) THEN
408: fnd_message.set_name('EAM', 'EAM_EZWO_ASSET_BAD');
409: fnd_msg_pub.add;
410: RAISE FND_API.G_EXC_ERROR;
411: END IF;
412:
413: l_network_object_type := p_network_object_type;

Line 483: fnd_msg_pub.add;

479: --validate start and end dates i.e. start date > end date
480: if p_start_date_active > nvl(p_end_date_active, p_start_date_active + 1)
481: then
482: fnd_message.set_name('EAM', 'EAM_IAA_INVALID_ACTIVE_DATE');
483: fnd_msg_pub.add;
484: RAISE FND_API.G_EXC_ERROR;
485: END IF;
486:
487: validate_dff_segments(

Line 590: fnd_msg_pub.add;

586: and mena.maintenance_object_type = l_maintenance_object_type;
587:
588: if l_count > 0 then
589: fnd_message.set_name('EAM', 'EAM_NETWORK_REC_EXISTS');
590: fnd_msg_pub.add;
591: RAISE fnd_api.g_exc_error;
592: end if;
593:
594: exception when no_data_found then

Line 686: FND_MSG_PUB.get

682: IF FND_API.To_Boolean( p_commit ) THEN
683: COMMIT WORK;
684: END IF;
685: -- Standard call to get message count and if count is 1, get message info.
686: FND_MSG_PUB.get
687: ( p_msg_index_out => x_msg_count ,
688: p_data => x_msg_data
689: );
690: EXCEPTION

Line 694: FND_MSG_PUB.get

690: EXCEPTION
691: WHEN FND_API.G_EXC_ERROR THEN
692: ROLLBACK TO insert_asset_routes;
693: x_return_status := FND_API.G_RET_STS_ERROR ;
694: FND_MSG_PUB.get
695: ( p_msg_index_out => x_msg_count ,
696: p_data => x_msg_data
697: );
698: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 701: FND_MSG_PUB.get

697: );
698: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
699: ROLLBACK TO insert_asset_routes;
700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
701: FND_MSG_PUB.get
702: ( p_msg_index_out => x_msg_count ,
703: p_data => x_msg_data
704: );
705: WHEN OTHERS THEN

Line 708: IF FND_MSG_PUB.Check_Msg_Level

704: );
705: WHEN OTHERS THEN
706: ROLLBACK TO insert_asset_routes;
707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
708: IF FND_MSG_PUB.Check_Msg_Level
709: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
710: THEN
711: FND_MSG_PUB.Add_Exc_Msg
712: ( G_PKG_NAME ,

Line 709: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

705: WHEN OTHERS THEN
706: ROLLBACK TO insert_asset_routes;
707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
708: IF FND_MSG_PUB.Check_Msg_Level
709: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
710: THEN
711: FND_MSG_PUB.Add_Exc_Msg
712: ( G_PKG_NAME ,
713: l_api_name

Line 711: FND_MSG_PUB.Add_Exc_Msg

707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
708: IF FND_MSG_PUB.Check_Msg_Level
709: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
710: THEN
711: FND_MSG_PUB.Add_Exc_Msg
712: ( G_PKG_NAME ,
713: l_api_name
714: );
715: END IF;

Line 716: FND_MSG_PUB.get

712: ( G_PKG_NAME ,
713: l_api_name
714: );
715: END IF;
716: FND_MSG_PUB.get
717: ( p_msg_index_out => x_msg_count ,
718: p_data => x_msg_data
719: );
720: END insert_asset_routes;

Line 802: FND_MSG_PUB.initialize;

798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
799: END IF;
800: -- Initialize message list if p_init_msg_list is set to TRUE.
801: IF FND_API.to_Boolean( p_init_msg_list ) THEN
802: FND_MSG_PUB.initialize;
803: END IF;
804: -- Initialize API return status to success
805: x_return_status := FND_API.G_RET_STS_SUCCESS;
806: -- API body

Line 826: fnd_msg_pub.add;

822:
823: if l_boolean = 0
824: then
825: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_ORG_ID');
826: fnd_msg_pub.add;
827: RAISE fnd_api.g_exc_error;
828: end if;
829:
830: -- Bug # 3441956

Line 837: fnd_msg_pub.add;

833: (p_network_asset_number is null)) OR
834: (p_network_object_type is not null and
835: ((p_network_object_type <> 1) AND (p_network_object_type <> 3)))) THEN -- change for bug # 13324075
836: fnd_message.set_name('EAM', 'EAM_NETWORK_REC_NOT_FOUND');
837: fnd_msg_pub.add;
838: RAISE FND_API.G_EXC_ERROR;
839: END IF;
840:
841:

Line 848: fnd_msg_pub.add;

844: (p_asset_number is null)) OR
845: (p_maintenance_object_type is not null and
846: ((p_network_object_type <> 1) AND (p_network_object_type <> 3)))) THEN -- change for bug # 13324075
847: fnd_message.set_name('EAM', 'EAM_EZWO_ASSET_BAD');
848: fnd_msg_pub.add;
849: RAISE FND_API.G_EXC_ERROR;
850: END IF;
851:
852: l_network_object_type := p_network_object_type;

Line 923: fnd_msg_pub.add;

919: --validate start and end dates i.e. start date > end date
920: if p_start_date_active>p_end_date_active
921: then
922: fnd_message.set_name('EAM', 'EAM_IAA_INVALID_ACTIVE_DATE');
923: fnd_msg_pub.add;
924: RAISE FND_API.G_EXC_ERROR;
925: END IF;
926:
927: validate_dff_segments(

Line 1031: fnd_msg_pub.add;

1027: and mena.network_association_id = p_network_association_id;
1028:
1029: if l_count < 1 then
1030: fnd_message.set_name('EAM', 'EAM_NETWORK_REC_NOT_FOUND');
1031: fnd_msg_pub.add;
1032: RAISE fnd_api.g_exc_error;
1033: end if;
1034:
1035: exception when no_data_found then

Line 1037: fnd_msg_pub.add;

1033: end if;
1034:
1035: exception when no_data_found then
1036: fnd_message.set_name('EAM', 'EAM_NETWORK_REC_NOT_FOUND');
1037: fnd_msg_pub.add;
1038: RAISE fnd_api.g_exc_error;
1039: END;
1040:
1041: UPDATE MTL_EAM_NETWORK_ASSETS

Line 1075: FND_MSG_PUB.get

1071: IF FND_API.To_Boolean( p_commit ) THEN
1072: COMMIT WORK;
1073: END IF;
1074: -- Standard call to get message count and if count is 1, get message info.
1075: FND_MSG_PUB.get
1076: ( p_msg_index_out => x_msg_count ,
1077: p_data => x_msg_data
1078: );
1079: EXCEPTION

Line 1083: FND_MSG_PUB.get

1079: EXCEPTION
1080: WHEN FND_API.G_EXC_ERROR THEN
1081: ROLLBACK TO update_asset_routes;
1082: x_return_status := FND_API.G_RET_STS_ERROR ;
1083: FND_MSG_PUB.get
1084: ( p_msg_index_out => x_msg_count ,
1085: p_data => x_msg_data
1086: );
1087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1090: FND_MSG_PUB.get

1086: );
1087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1088: ROLLBACK TO update_asset_routes;
1089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1090: FND_MSG_PUB.get
1091: ( p_msg_index_out => x_msg_count ,
1092: p_data => x_msg_data
1093: );
1094: WHEN OTHERS THEN

Line 1097: IF FND_MSG_PUB.Check_Msg_Level

1093: );
1094: WHEN OTHERS THEN
1095: ROLLBACK TO update_asset_routes;
1096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1097: IF FND_MSG_PUB.Check_Msg_Level
1098: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1099: THEN
1100: FND_MSG_PUB.Add_Exc_Msg
1101: ( G_PKG_NAME ,

Line 1098: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1094: WHEN OTHERS THEN
1095: ROLLBACK TO update_asset_routes;
1096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1097: IF FND_MSG_PUB.Check_Msg_Level
1098: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1099: THEN
1100: FND_MSG_PUB.Add_Exc_Msg
1101: ( G_PKG_NAME ,
1102: l_api_name

Line 1100: FND_MSG_PUB.Add_Exc_Msg

1096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1097: IF FND_MSG_PUB.Check_Msg_Level
1098: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1099: THEN
1100: FND_MSG_PUB.Add_Exc_Msg
1101: ( G_PKG_NAME ,
1102: l_api_name
1103: );
1104: END IF;

Line 1105: FND_MSG_PUB.get

1101: ( G_PKG_NAME ,
1102: l_api_name
1103: );
1104: END IF;
1105: FND_MSG_PUB.get
1106: ( p_msg_index_out => x_msg_count ,
1107: p_data => x_msg_data
1108: );
1109: END update_asset_routes;