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.

[Home] [Help]

APPS.EAM_ASSET_ROUTES_PUB dependencies on FND_API

Line 11: -- Default = FND_API.G_FALSE

7: -- Pre-reqs : None.
8: -- Parameters :
9: -- IN : p_api_version IN NUMBER Required
10: -- p_init_msg_list IN VARCHAR2 Optional
11: -- Default = FND_API.G_FALSE
12: -- p_commit IN VARCHAR2 Optional
13: -- Default = FND_API.G_FALSE
14: -- p_validation_level IN NUMBER Optional
15: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 13: -- Default = FND_API.G_FALSE

9: -- IN : p_api_version IN NUMBER Required
10: -- p_init_msg_list IN VARCHAR2 Optional
11: -- Default = FND_API.G_FALSE
12: -- p_commit IN VARCHAR2 Optional
13: -- Default = FND_API.G_FALSE
14: -- p_validation_level IN NUMBER Optional
15: -- Default = FND_API.G_VALID_LEVEL_FULL
16: -- parameter1
17: -- parameter2

Line 15: -- Default = FND_API.G_VALID_LEVEL_FULL

11: -- Default = FND_API.G_FALSE
12: -- p_commit IN VARCHAR2 Optional
13: -- Default = FND_API.G_FALSE
14: -- p_validation_level IN NUMBER Optional
15: -- Default = FND_API.G_VALID_LEVEL_FULL
16: -- parameter1
17: -- parameter2
18: -- .
19: -- .

Line 105: RAISE FND_API.G_EXC_ERROR;

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,
109: p_object_id in number,

Line 157: RAISE fnd_api.g_exc_error;

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');
161: fnd_msg_pub.add;

Line 162: 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
166: then

Line 169: RAISE fnd_api.g_exc_error;

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

Line 242: RAISE FND_API.G_EXC_ERROR;

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

Line 272: RAISE fnd_api.g_exc_error;

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
276: fnd_message.set_name('EAM', 'EAM_NETWORK_REC_EXISTS');

Line 278: RAISE fnd_api.g_exc_error;

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

Line 288: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE ,

284:
285: PROCEDURE insert_asset_routes
286: (
287: p_api_version IN NUMBER ,
288: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE ,
289: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
290: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
291: x_return_status OUT NOCOPY VARCHAR2 ,
292: x_msg_count OUT NOCOPY NUMBER ,

Line 289: p_commit IN VARCHAR2:= FND_API.G_FALSE ,

285: PROCEDURE insert_asset_routes
286: (
287: p_api_version IN NUMBER ,
288: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE ,
289: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
290: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
291: x_return_status OUT NOCOPY VARCHAR2 ,
292: x_msg_count OUT NOCOPY NUMBER ,
293: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 290: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

286: (
287: p_api_version IN NUMBER ,
288: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE ,
289: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
290: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
291: x_return_status OUT NOCOPY VARCHAR2 ,
292: x_msg_count OUT NOCOPY NUMBER ,
293: x_msg_data OUT NOCOPY VARCHAR2 ,
294:

Line 355: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

351: BEGIN
352: -- Standard Start of API savepoint
353: SAVEPOINT insert_asset_routes;
354: -- Standard call to check for call compatibility.
355: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
356: p_api_version ,
357: l_api_name ,
358: G_PKG_NAME )
359: THEN

Line 360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

356: p_api_version ,
357: l_api_name ,
358: G_PKG_NAME )
359: THEN
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;

Line 363: IF FND_API.to_Boolean( p_init_msg_list ) THEN

359: THEN
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;

Line 367: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
369:
370: /* Anand- for creation_organization_id = organization_id */
371:

Line 389: RAISE fnd_api.g_exc_error;

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:
393: -- Bug # 3441956

Line 400: RAISE FND_API.G_EXC_ERROR;

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:
404: IF (((p_maintenance_object_type is null or p_maintenance_object_id is null) and

Line 410: RAISE FND_API.G_EXC_ERROR;

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;
414: l_network_object_id := p_network_object_id;

Line 484: RAISE FND_API.G_EXC_ERROR;

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(
488: p_ATTRIBUTE_CATEGORY ,

Line 591: RAISE fnd_api.g_exc_error;

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
595: null;

Line 682: IF FND_API.To_Boolean( p_commit ) THEN

678:
679:
680: -- End of API body.
681: -- Standard check of p_commit.
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

Line 691: WHEN FND_API.G_EXC_ERROR THEN

687: ( p_msg_index_out => x_msg_count ,
688: p_data => x_msg_data
689: );
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 ,

Line 693: x_return_status := FND_API.G_RET_STS_ERROR ;

689: );
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: );

Line 698: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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 ,

Line 700: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

696: p_data => x_msg_data
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: );

Line 707: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

703: p_data => x_msg_data
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

Line 726: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE ,

722:
723: PROCEDURE update_asset_routes
724: (
725: p_api_version IN NUMBER ,
726: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE ,
727: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
728: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
729: x_return_status OUT NOCOPY VARCHAR2 ,
730: x_msg_count OUT NOCOPY NUMBER ,

Line 727: p_commit IN VARCHAR2:= FND_API.G_FALSE ,

723: PROCEDURE update_asset_routes
724: (
725: p_api_version IN NUMBER ,
726: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE ,
727: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
728: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
729: x_return_status OUT NOCOPY VARCHAR2 ,
730: x_msg_count OUT NOCOPY NUMBER ,
731: x_msg_data OUT NOCOPY VARCHAR2 ,

Line 728: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

724: (
725: p_api_version IN NUMBER ,
726: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE ,
727: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
728: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
729: x_return_status OUT NOCOPY VARCHAR2 ,
730: x_msg_count OUT NOCOPY NUMBER ,
731: x_msg_data OUT NOCOPY VARCHAR2 ,
732:

Line 793: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

789: BEGIN
790: -- Standard Start of API savepoint
791: SAVEPOINT update_asset_routes;
792: -- Standard call to check for call compatibility.
793: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
794: p_api_version ,
795: l_api_name ,
796: G_PKG_NAME )
797: THEN

Line 798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

794: p_api_version ,
795: l_api_name ,
796: G_PKG_NAME )
797: THEN
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;

Line 801: IF FND_API.to_Boolean( p_init_msg_list ) THEN

797: THEN
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;

Line 805: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
807:
808: /* Anand- for creation_organization_id = organization_id */
809:

Line 827: RAISE fnd_api.g_exc_error;

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
831: IF (((p_network_item_id is null or p_network_serial_number is null) and

Line 837: RAISE FND_API.G_EXC_ERROR;

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:
841: IF (((p_maintenance_object_type is null or p_maintenance_object_id is null) and

Line 847: RAISE FND_API.G_EXC_ERROR;

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;
851: l_network_object_id := p_network_object_id;

Line 922: RAISE FND_API.G_EXC_ERROR;

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(
926: p_ATTRIBUTE_CATEGORY ,

Line 1030: RAISE fnd_api.g_exc_error;

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
1034: fnd_message.set_name('EAM', 'EAM_NETWORK_REC_NOT_FOUND');

Line 1036: RAISE fnd_api.g_exc_error;

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
1040: SET

Line 1069: IF FND_API.To_Boolean( p_commit ) THEN

1065:
1066:
1067: -- End of API body.
1068: -- Standard check of p_commit.
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

Line 1078: WHEN FND_API.G_EXC_ERROR THEN

1074: ( p_msg_index_out => x_msg_count ,
1075: p_data => x_msg_data
1076: );
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 ,

Line 1080: x_return_status := FND_API.G_RET_STS_ERROR ;

1076: );
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: );

Line 1085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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 ,

Line 1087: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1083: p_data => x_msg_data
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: );

Line 1094: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1090: p_data => x_msg_data
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