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 836: fnd_msg_pub.add;

832: (p_network_object_id is null or p_network_object_type is null) and
833: (p_network_asset_number is null)) OR
834: (p_network_object_type is not null and p_network_object_type <> 1)) THEN
835: fnd_message.set_name('EAM', 'EAM_NETWORK_REC_NOT_FOUND');
836: fnd_msg_pub.add;
837: RAISE FND_API.G_EXC_ERROR;
838: END IF;
839:
840:

Line 846: fnd_msg_pub.add;

842: (p_inventory_item_id is null or p_serial_number is null) and
843: (p_asset_number is null)) OR
844: (p_maintenance_object_type is not null and p_maintenance_object_type <> 1)) THEN
845: fnd_message.set_name('EAM', 'EAM_EZWO_ASSET_BAD');
846: fnd_msg_pub.add;
847: RAISE FND_API.G_EXC_ERROR;
848: END IF;
849:
850: l_network_object_type := p_network_object_type;

Line 921: fnd_msg_pub.add;

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

Line 1029: fnd_msg_pub.add;

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

Line 1035: fnd_msg_pub.add;

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

Line 1073: FND_MSG_PUB.get

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

Line 1081: FND_MSG_PUB.get

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

Line 1088: FND_MSG_PUB.get

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

Line 1095: IF FND_MSG_PUB.Check_Msg_Level

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

Line 1096: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

Line 1098: FND_MSG_PUB.Add_Exc_Msg

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

Line 1103: FND_MSG_PUB.get

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