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.EAM_ASSETATTR_VALUE_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 139: RAISE FND_API.G_EXC_ERROR;

135:
136:
137: FND_MESSAGE.SET_NAME ('EAM', ERROR);
138: FND_MSG_PUB.ADD;
139: RAISE FND_API.G_EXC_ERROR;
140: END;
141:
142:
143: /*

Line 154: RAISE fnd_api.g_exc_error;

150: if p_application_id is null or p_application_id <> 401
151: then
152: fnd_message.set_name('EAM', 'EAM_INVALID_APPLICATION_ID');
153: fnd_msg_pub.add;
154: RAISE fnd_api.g_exc_error;
155: end if;
156: END;
157:
158: procedure validate_maintenance_object_id(p_organization_id in number, p_object_id in number, p_eam_item_type in varchar2)

Line 180: RAISE fnd_api.g_exc_error;

176:
177: if l_count = 0 then
178: fnd_message.set_name('EAM', 'EAM_INVALID_MAINT_OBJ_ID');
179: fnd_msg_pub.add;
180: RAISE fnd_api.g_exc_error;
181: end if;
182:
183: END;
184:

Line 204: RAISE fnd_api.g_exc_error;

200:
201: if l_count = 0 then
202: fnd_message.set_name('EAM', 'EAM_INVALID_ASSOCIATION_GROUP');
203: fnd_msg_pub.add;
204: RAISE fnd_api.g_exc_error;
205: end if;
206: END;
207:
208:

Line 238: RAISE fnd_api.g_exc_error;

234: if l_count = 0
235: then
236: fnd_message.set_name('EAM', 'EAM_AAV_INVALID_DFF_CONTEXT');
237: fnd_msg_pub.add;
238: RAISE fnd_api.g_exc_error;
239: end if;
240:
241: END ;
242:

Line 350: RAISE FND_API.G_EXC_ERROR;

346: l_error_message:= substr(fnd_flex_descval.error_message,1,4000);
347: FND_MESSAGE.SET_NAME('EAM', 'EAM_INVALID_DESC_FLEX');
348: FND_MESSAGE.SET_TOKEN('ERROR_MSG', l_error_message);
349: FND_MSG_PUB.Add;
350: RAISE FND_API.G_EXC_ERROR;
351: end if;
352:
353: end validate_dff_segments;
354:

Line 380: RAISE fnd_api.g_exc_error;

376: if NOT p_create_flag
377: then
378: fnd_message.set_name('EAM', 'EAM_ATTR_VALUES_REC_NOT_FOUND');
379: fnd_msg_pub.add;
380: RAISE fnd_api.g_exc_error;
381: END IF;
382: else
383: if p_create_flag
384: then

Line 387: RAISE fnd_api.g_exc_error;

383: if p_create_flag
384: then
385: fnd_message.set_name('EAM', 'EAM_ATTR_VALUES_REC_EXISTS');
386: fnd_msg_pub.add;
387: RAISE fnd_api.g_exc_error;
388: END IF;
389: end if;
390: END;
391:

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

393:
394: procedure insert_assetattr_value
395: (
396: p_api_version IN NUMBER ,
397: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE ,
398: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
399: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
400: x_return_status OUT NOCOPY VARCHAR2 ,
401: x_msg_count OUT NOCOPY NUMBER ,

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

394: procedure insert_assetattr_value
395: (
396: p_api_version IN NUMBER ,
397: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE ,
398: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
399: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
400: x_return_status OUT NOCOPY VARCHAR2 ,
401: x_msg_count OUT NOCOPY NUMBER ,
402: x_msg_data OUT NOCOPY VARCHAR2 ,

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

395: (
396: p_api_version IN NUMBER ,
397: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE ,
398: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
399: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
400: x_return_status OUT NOCOPY VARCHAR2 ,
401: x_msg_count OUT NOCOPY NUMBER ,
402: x_msg_data OUT NOCOPY VARCHAR2 ,
403: P_ASSOCIATION_ID IN NUMBER ,

Line 484: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

480: BEGIN
481: -- Standard Start of API savepoint
482: SAVEPOINT INSERT_ASSETATTR_VALUE;
483: -- Standard call to check for call compatibility.
484: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
485: p_api_version ,
486: l_api_name ,
487: G_PKG_NAME )
488: THEN

Line 489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

485: p_api_version ,
486: l_api_name ,
487: G_PKG_NAME )
488: THEN
489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
490: END IF;
491: -- Initialize message list if p_init_msg_list is set to TRUE.
492: IF FND_API.to_Boolean( p_init_msg_list ) THEN
493: FND_MSG_PUB.initialize;

Line 492: IF FND_API.to_Boolean( p_init_msg_list ) THEN

488: THEN
489: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
490: END IF;
491: -- Initialize message list if p_init_msg_list is set to TRUE.
492: IF FND_API.to_Boolean( p_init_msg_list ) THEN
493: FND_MSG_PUB.initialize;
494: END IF;
495: -- Initialize API return status to success
496: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 496: x_return_status := FND_API.G_RET_STS_SUCCESS;

492: IF FND_API.to_Boolean( p_init_msg_list ) THEN
493: FND_MSG_PUB.initialize;
494: END IF;
495: -- Initialize API return status to success
496: x_return_status := FND_API.G_RET_STS_SUCCESS;
497: -- API body
498:
499: /* Anand- for creation_organization_id = organization_id */
500: l_org_id := P_ORGANIZATION_ID;

Line 505: RAISE fnd_api.g_exc_error;

501: if (P_CREATION_ORGANIZATION_ID IS NOT NULL) then
502: if P_CREATION_ORGANIZATION_ID <> P_ORGANIZATION_ID then
503: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_CR_ORG_ID');
504: fnd_msg_pub.add;
505: RAISE fnd_api.g_exc_error;
506: else
507:
508: l_creation_organization_id := P_ORGANIZATION_ID;
509: end if;

Line 527: RAISE fnd_api.g_exc_error;

523: if l_boolean = 0
524: then
525: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_ORG_ID');
526: fnd_msg_pub.add;
527: RAISE fnd_api.g_exc_error;
528: end if;
529: end if;
530:
531: /* validate / populate inventory_item_id, serial_number, maintenance_object_id, maintenance_object_type */

Line 537: RAISE FND_API.G_EXC_ERROR;

533: IF ((p_maintenance_object_type is null or p_maintenance_object_id is null) and
534: (p_inventory_item_id is null or p_serial_number is null)) THEN
535: fnd_message.set_name('EAM', 'EAM_NOT_ENOUGH_PARAM');
536: fnd_msg_pub.add;
537: RAISE FND_API.G_EXC_ERROR;
538: END IF;
539:
540: IF (p_maintenance_object_type is not null and p_maintenance_object_type <> 3) THEN
541: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_MAINT_OBJ_TYPE');

Line 543: RAISE FND_API.G_EXC_ERROR;

539:
540: IF (p_maintenance_object_type is not null and p_maintenance_object_type <> 3) THEN
541: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_MAINT_OBJ_TYPE');
542: fnd_msg_pub.add;
543: RAISE FND_API.G_EXC_ERROR;
544: END IF;
545:
546: l_maintenance_object_type := p_maintenance_object_type;
547: l_maintenance_object_id := p_maintenance_object_id;

Line 742: RAISE fnd_api.g_exc_error;

738: )
739: THEN
740: fnd_message.set_name('EAM', 'EAM_EZWO_ASSET_BAD');
741: fnd_msg_pub.add;
742: RAISE fnd_api.g_exc_error;
743: END IF;
744: */
745:
746: /*validate_maintenance_object_id(p_creation_organization_id , P_MAINTENANCE_OBJECT_ID, p_MAINTENANCE_OBJECT_TYPE );*/

Line 892: IF FND_API.To_Boolean( p_commit ) THEN

888: );
889:
890: -- End of API body.
891: -- Standard check of p_commit.
892: IF FND_API.To_Boolean( p_commit ) THEN
893: COMMIT WORK;
894: END IF;
895: -- Standard call to get message count and if count is 1, get message info.
896: FND_MSG_PUB.get

Line 901: WHEN FND_API.G_EXC_ERROR THEN

897: ( p_msg_index_out => x_msg_count ,
898: p_data => x_msg_data
899: );
900: EXCEPTION
901: WHEN FND_API.G_EXC_ERROR THEN
902: ROLLBACK TO insert_assetattr_value;
903: x_return_status := FND_API.G_RET_STS_ERROR ;
904: FND_MSG_PUB.get
905: ( p_msg_index_out => x_msg_count ,

Line 903: x_return_status := FND_API.G_RET_STS_ERROR ;

899: );
900: EXCEPTION
901: WHEN FND_API.G_EXC_ERROR THEN
902: ROLLBACK TO insert_assetattr_value;
903: x_return_status := FND_API.G_RET_STS_ERROR ;
904: FND_MSG_PUB.get
905: ( p_msg_index_out => x_msg_count ,
906: p_data => x_msg_data
907: );

Line 908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

904: FND_MSG_PUB.get
905: ( p_msg_index_out => x_msg_count ,
906: p_data => x_msg_data
907: );
908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
909: ROLLBACK TO insert_assetattr_value;
910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
911: FND_MSG_PUB.get
912: ( p_msg_index_out => x_msg_count ,

Line 910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

906: p_data => x_msg_data
907: );
908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
909: ROLLBACK TO insert_assetattr_value;
910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
911: FND_MSG_PUB.get
912: ( p_msg_index_out => x_msg_count ,
913: p_data => x_msg_data
914: );

Line 917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

913: p_data => x_msg_data
914: );
915: WHEN OTHERS THEN
916: ROLLBACK TO insert_assetattr_value;
917: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
918: IF FND_MSG_PUB.Check_Msg_Level
919: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
920: THEN
921: FND_MSG_PUB.Add_Exc_Msg

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

932:
933: procedure update_assetattr_value
934: (
935: p_api_version IN NUMBER ,
936: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE ,
937: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
938: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
939: x_return_status OUT NOCOPY VARCHAR2 ,
940: x_msg_count OUT NOCOPY NUMBER ,

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

933: procedure update_assetattr_value
934: (
935: p_api_version IN NUMBER ,
936: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE ,
937: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
938: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
939: x_return_status OUT NOCOPY VARCHAR2 ,
940: x_msg_count OUT NOCOPY NUMBER ,
941: x_msg_data OUT NOCOPY VARCHAR2 ,

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

934: (
935: p_api_version IN NUMBER ,
936: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE ,
937: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
938: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
939: x_return_status OUT NOCOPY VARCHAR2 ,
940: x_msg_count OUT NOCOPY NUMBER ,
941: x_msg_data OUT NOCOPY VARCHAR2 ,
942: P_ASSOCIATION_ID IN NUMBER ,

Line 1019: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

1015: BEGIN
1016: -- Standard Start of API savepoint
1017: SAVEPOINT update_assetattr_value;
1018: -- Standard call to check for call compatibility.
1019: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1020: p_api_version ,
1021: l_api_name ,
1022: G_PKG_NAME )
1023: THEN

Line 1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1020: p_api_version ,
1021: l_api_name ,
1022: G_PKG_NAME )
1023: THEN
1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1025: END IF;
1026: -- Initialize message list if p_init_msg_list is set to TRUE.
1027: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1028: FND_MSG_PUB.initialize;

Line 1027: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1023: THEN
1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1025: END IF;
1026: -- Initialize message list if p_init_msg_list is set to TRUE.
1027: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1028: FND_MSG_PUB.initialize;
1029: END IF;
1030: -- Initialize API return status to success
1031: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1031: x_return_status := FND_API.G_RET_STS_SUCCESS;

1027: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1028: FND_MSG_PUB.initialize;
1029: END IF;
1030: -- Initialize API return status to success
1031: x_return_status := FND_API.G_RET_STS_SUCCESS;
1032: -- API body
1033:
1034: l_org_id := P_ORGANIZATION_ID;
1035: if (P_CREATION_ORGANIZATION_ID IS NOT NULL) then

Line 1039: RAISE fnd_api.g_exc_error;

1035: if (P_CREATION_ORGANIZATION_ID IS NOT NULL) then
1036: if P_CREATION_ORGANIZATION_ID <> P_ORGANIZATION_ID then
1037: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_CR_ORG_ID');
1038: fnd_msg_pub.add;
1039: RAISE fnd_api.g_exc_error;
1040: else
1041:
1042: l_creation_organization_id := P_ORGANIZATION_ID;
1043: end if;

Line 1061: RAISE fnd_api.g_exc_error;

1057: if l_boolean = 0
1058: then
1059: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_ORG_ID');
1060: fnd_msg_pub.add;
1061: RAISE fnd_api.g_exc_error;
1062: end if;
1063: end if;
1064:
1065:

Line 1072: RAISE FND_API.G_EXC_ERROR;

1068: IF ((p_maintenance_object_type is null or p_maintenance_object_id is null) and
1069: (p_inventory_item_id is null or p_serial_number is null)) THEN
1070: fnd_message.set_name('EAM', 'EAM_NOT_ENOUGH_PARAM');
1071: fnd_msg_pub.add;
1072: RAISE FND_API.G_EXC_ERROR;
1073: END IF;
1074:
1075: IF (p_maintenance_object_type is not null and p_maintenance_object_type <> 3) THEN
1076: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_MAINT_OBJ_TYPE');

Line 1078: RAISE FND_API.G_EXC_ERROR;

1074:
1075: IF (p_maintenance_object_type is not null and p_maintenance_object_type <> 3) THEN
1076: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_MAINT_OBJ_TYPE');
1077: fnd_msg_pub.add;
1078: RAISE FND_API.G_EXC_ERROR;
1079: END IF;
1080:
1081: l_maintenance_object_type := p_maintenance_object_type;
1082: l_maintenance_object_id := p_maintenance_object_id;

Line 1349: IF FND_API.To_Boolean( p_commit ) THEN

1345:
1346:
1347: -- End of API body.
1348: -- Standard check of p_commit.
1349: IF FND_API.To_Boolean( p_commit ) THEN
1350: COMMIT WORK;
1351: END IF;
1352: -- Standard call to get message count and if count is 1, get message info.
1353: FND_MSG_PUB.get

Line 1358: WHEN FND_API.G_EXC_ERROR THEN

1354: ( p_msg_index_out => x_msg_count ,
1355: p_data => x_msg_data
1356: );
1357: EXCEPTION
1358: WHEN FND_API.G_EXC_ERROR THEN
1359: ROLLBACK TO update_assetattr_value;
1360: x_return_status := FND_API.G_RET_STS_ERROR ;
1361: FND_MSG_PUB.get
1362: ( p_msg_index_out => x_msg_count ,

Line 1360: x_return_status := FND_API.G_RET_STS_ERROR ;

1356: );
1357: EXCEPTION
1358: WHEN FND_API.G_EXC_ERROR THEN
1359: ROLLBACK TO update_assetattr_value;
1360: x_return_status := FND_API.G_RET_STS_ERROR ;
1361: FND_MSG_PUB.get
1362: ( p_msg_index_out => x_msg_count ,
1363: p_data => x_msg_data
1364: );

Line 1365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1361: FND_MSG_PUB.get
1362: ( p_msg_index_out => x_msg_count ,
1363: p_data => x_msg_data
1364: );
1365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1366: ROLLBACK TO update_assetattr_value;
1367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1368: FND_MSG_PUB.get
1369: ( p_msg_index_out => x_msg_count ,

Line 1367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1363: p_data => x_msg_data
1364: );
1365: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1366: ROLLBACK TO update_assetattr_value;
1367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1368: FND_MSG_PUB.get
1369: ( p_msg_index_out => x_msg_count ,
1370: p_data => x_msg_data
1371: );

Line 1374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1370: p_data => x_msg_data
1371: );
1372: WHEN OTHERS THEN
1373: ROLLBACK TO update_assetattr_value;
1374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1375: IF FND_MSG_PUB.Check_Msg_Level
1376: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1377: THEN
1378: FND_MSG_PUB.Add_Exc_Msg