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_ITEM_ACTIVITIES_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 134: RAISE FND_API.G_EXC_ERROR;

130:
131:
132: FND_MESSAGE.SET_NAME ('EAM', ERROR);
133: FND_MSG_PUB.ADD;
134: RAISE FND_API.G_EXC_ERROR;
135: END;
136:
137: --funcation to validate if the provided lookup code is present forthe specified type.
138: PROCEDURE validate_mfg_lookups(P_LOOKUP_TYPE IN VARCHAR2, P_LOOKUP_CODE in varchar2, P_MSG in varchar2)

Line 156: RAISE fnd_api.g_exc_error;

152: if l_count = 0
153: then
154: fnd_message.set_name('EAM', P_MSG);
155: fnd_msg_pub.add;
156: RAISE fnd_api.g_exc_error;
157: end if;
158: END;
159:
160: --funciton to validate the wip entity class CLASS_TYPE = "Maintenance" <6>

Line 181: RAISE fnd_api.g_exc_error;

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

Line 195: RAISE fnd_api.g_exc_error;

191: if not EAM_COMMON_UTILITIES_PVT.validate_boolean_flag(p_flag)
192: then
193: fnd_message.set_name('EAM', p_msg);
194: fnd_msg_pub.add;
195: RAISE fnd_api.g_exc_error;
196: end if;
197: end if;
198: end;
199:

Line 227: RAISE fnd_api.g_exc_error;

223:
224: if l_count = 0 then
225: fnd_message.set_name('EAM', 'EAM_INVALID_MAINT_OBJ_ID');
226: fnd_msg_pub.add;
227: RAISE fnd_api.g_exc_error;
228: end if;
229:
230: END;
231:

Line 258: RAISE fnd_api.g_exc_error;

254:
255: if (l_count = 0) then
256: fnd_message.set_name('EAM', 'EAM_INVALID_INVENTORY_ITEM');
257: fnd_msg_pub.add;
258: RAISE fnd_api.g_exc_error;
259: end if;
260: end validate_inventory_item_id;
261:
262: procedure validate_serial_number(p_serial_number in varchar2 ,p_tmpl_flag in varchar2 , p_organization_id in number )

Line 272: RAISE fnd_api.g_exc_error;

268: if nvl(p_tmpl_flag, 'N') = 'Y' and p_serial_number is not null
269: then
270: fnd_message.set_name('EAM', 'EAM_IAA_SERIAL_NUMBER_NOT_NULL');
271: fnd_msg_pub.add;
272: RAISE fnd_api.g_exc_error;
273: end if;
274:
275: if nvl(p_tmpl_flag, 'N') = 'N' and p_serial_number is null
276: then

Line 279: RAISE fnd_api.g_exc_error;

275: if nvl(p_tmpl_flag, 'N') = 'N' and p_serial_number is null
276: then
277: fnd_message.set_name('EAM', 'EAM_IAA_SERIAL_NUMBER_NULL');
278: fnd_msg_pub.add;
279: RAISE fnd_api.g_exc_error;
280: end if;
281:
282: if nvl(p_tmpl_flag, 'N') = 'N'
283: then

Line 291: RAISE fnd_api.g_exc_error;

287:
288: if (l_count = 0) then
289: fnd_message.set_name('EAM', 'EAM_EZWO_ASSET_BAD');
290: fnd_msg_pub.add;
291: RAISE fnd_api.g_exc_error;
292: end if;
293: end if;
294: END validate_serial_number;
295:

Line 349: RAISE FND_API.G_EXC_ERROR;

345: then
346: FND_MESSAGE.SET_NAME('EAM', 'EAM_INVALID_DESC_FLEX');
347: FND_MESSAGE.SET_TOKEN('ERROR_MSG', l_error_message);
348: FND_MSG_PUB.Add;
349: RAISE FND_API.G_EXC_ERROR;
350: end if;
351:
352: end validate_dff_segments;
353:

Line 381: RAISE fnd_api.g_exc_error;

377: WHEN TOO_MANY_ROWS THEN
378: fnd_message.set_name('EAM', 'EAM_DATA_CORRUPT');
379: fnd_message.set_token('TABLE_NAME', 'MTL_EAM_ASSET_ACTIVITIES');
380: fnd_msg_pub.add;
381: RAISE fnd_api.g_exc_error;
382: END;
383:
384:
385:

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

385:
386: PROCEDURE INSERT_ITEM_ACTIVITIES
387: (
388: p_api_version IN NUMBER ,
389: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE ,
390: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
391: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
392: x_return_status OUT NOCOPY VARCHAR2 ,
393: x_msg_count OUT NOCOPY NUMBER ,

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

386: PROCEDURE INSERT_ITEM_ACTIVITIES
387: (
388: p_api_version IN NUMBER ,
389: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE ,
390: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
391: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
392: x_return_status OUT NOCOPY VARCHAR2 ,
393: x_msg_count OUT NOCOPY NUMBER ,
394: x_msg_data OUT NOCOPY VARCHAR2 ,

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

387: (
388: p_api_version IN NUMBER ,
389: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE ,
390: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
391: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
392: x_return_status OUT NOCOPY VARCHAR2 ,
393: x_msg_count OUT NOCOPY NUMBER ,
394: x_msg_data OUT NOCOPY VARCHAR2 ,
395:

Line 476: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

472: -- Standard Start of API savepoint
473: SAVEPOINT INSERT_ITEM_ACTIVITIES;
474:
475: -- Standard call to check for call compatibility.
476: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
477: p_api_version ,
478: l_api_name ,
479: G_PKG_NAME )
480: THEN

Line 481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

477: p_api_version ,
478: l_api_name ,
479: G_PKG_NAME )
480: THEN
481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
482: END IF;
483: -- Initialize message list if p_init_msg_list is set to TRUE.
484: IF FND_API.to_Boolean( p_init_msg_list ) THEN
485: FND_MSG_PUB.initialize;

Line 484: IF FND_API.to_Boolean( p_init_msg_list ) THEN

480: THEN
481: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
482: END IF;
483: -- Initialize message list if p_init_msg_list is set to TRUE.
484: IF FND_API.to_Boolean( p_init_msg_list ) THEN
485: FND_MSG_PUB.initialize;
486: END IF;
487: -- Initialize API return status to success
488: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 488: x_return_status := FND_API.G_RET_STS_SUCCESS;

484: IF FND_API.to_Boolean( p_init_msg_list ) THEN
485: FND_MSG_PUB.initialize;
486: END IF;
487: -- Initialize API return status to success
488: x_return_status := FND_API.G_RET_STS_SUCCESS;
489:
490: -- API body
491:
492: /* for creation_organization_id = organization_id */

Line 499: RAISE fnd_api.g_exc_error;

495: if (P_CREATION_ORGANIZATION_ID IS NOT NULL) then
496: if P_CREATION_ORGANIZATION_ID <> P_ORGANIZATION_ID then
497: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_CR_ORG_ID');
498: fnd_msg_pub.add;
499: RAISE fnd_api.g_exc_error;
500: else
501: l_creation_organization_id := P_ORGANIZATION_ID;
502: end if;
503: else

Line 521: RAISE fnd_api.g_exc_error;

517: if l_boolean = 0
518: then
519: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_ORG_ID');
520: fnd_msg_pub.add;
521: RAISE fnd_api.g_exc_error;
522: end if;
523: end if;
524:
525:

Line 529: RAISE fnd_api.g_exc_error;

525:
526: IF ((p_class_code IS NOT NULL or p_owningdepartment_id IS NOT NULL) AND p_organization_id IS NULL) THEN
527: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_ORG_ID');
528: fnd_msg_pub.add;
529: RAISE fnd_api.g_exc_error;
530: END IF;
531:
532: -- Bug # 3441956
533: BEGIN

Line 567: RAISE fnd_api.g_exc_error;

563: if p_start_date_active>p_end_date_active
564: then
565: fnd_message.set_name('EAM', 'EAM_IAA_INVALID_ACTIVE_DATE');
566: fnd_msg_pub.add;
567: RAISE fnd_api.g_exc_error;
568: END IF;
569:
570: if p_last_service_start_date > p_last_service_end_date
571: then

Line 574: RAISE fnd_api.g_exc_error;

570: if p_last_service_start_date > p_last_service_end_date
571: then
572: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_START_END_DATE');
573: fnd_msg_pub.add;
574: RAISE fnd_api.g_exc_error;
575: END IF;
576:
577: if p_prev_service_start_date > p_prev_service_end_date
578: then

Line 581: RAISE fnd_api.g_exc_error;

577: if p_prev_service_start_date > p_prev_service_end_date
578: then
579: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_START_END_DATE');
580: fnd_msg_pub.add;
581: RAISE fnd_api.g_exc_error;
582: END IF;
583:
584: if p_last_scheduled_start_date > p_last_scheduled_end_date
585: then

Line 588: RAISE fnd_api.g_exc_error;

584: if p_last_scheduled_start_date > p_last_scheduled_end_date
585: then
586: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_START_END_DATE');
587: fnd_msg_pub.add;
588: RAISE fnd_api.g_exc_error;
589: END IF;
590:
591:
592: if p_prev_scheduled_start_date > p_prev_scheduled_end_date

Line 596: RAISE fnd_api.g_exc_error;

592: if p_prev_scheduled_start_date > p_prev_scheduled_end_date
593: then
594: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_START_END_DATE');
595: fnd_msg_pub.add;
596: RAISE fnd_api.g_exc_error;
597: END IF;
598:
599: validate_boolean_flag(p_tagging_required_flag, 'EAM_ABO_INVALID_TAG_REQ_FLAG');
600:

Line 634: RAISE FND_API.G_EXC_ERROR;

630: IF ((p_maintenance_object_type is null or p_maintenance_object_id is null) and
631: (p_inventory_item_id is null)) THEN
632: fnd_message.set_name('EAM', 'EAM_NOT_ENOUGH_PARAM');
633: fnd_msg_pub.add;
634: RAISE FND_API.G_EXC_ERROR;
635: END IF;
636:
637: IF (p_maintenance_object_type is not null and p_maintenance_object_type NOT in (3,2)) THEN
638: fnd_message.set_name('EAM', 'EAM_INVALID_MAINT_OBJ_TYPE');

Line 640: RAISE FND_API.G_EXC_ERROR;

636:
637: IF (p_maintenance_object_type is not null and p_maintenance_object_type NOT in (3,2)) THEN
638: fnd_message.set_name('EAM', 'EAM_INVALID_MAINT_OBJ_TYPE');
639: fnd_msg_pub.add;
640: RAISE FND_API.G_EXC_ERROR;
641: END IF;
642:
643: l_org_id := p_organization_id;
644: l_asset_group_id := p_inventory_item_id;

Line 890: IF x_return_status <> fnd_api.g_ret_sts_success THEN

886: ,x_msg_count => x_msg_count
887: ,x_msg_data => x_msg_data
888: );
889:
890: IF x_return_status <> fnd_api.g_ret_sts_success THEN
891: RAISE fnd_api.g_exc_error;
892: END IF;
893: END IF;
894:

Line 891: RAISE fnd_api.g_exc_error;

887: ,x_msg_data => x_msg_data
888: );
889:
890: IF x_return_status <> fnd_api.g_ret_sts_success THEN
891: RAISE fnd_api.g_exc_error;
892: END IF;
893: END IF;
894:
895: IF p_pm_last_service_tbl.count >0 THEN

Line 904: p_init_msg_list => FND_API.G_FALSE,--p_init_msg_list,

900:
901: EAM_PM_LAST_SERVICE_PUB.process_pm_last_service
902: (
903: p_api_version => p_api_version,
904: p_init_msg_list => FND_API.G_FALSE,--p_init_msg_list,
905: p_commit => p_commit,
906: p_validation_level => p_validation_level,
907: x_return_status => x_return_status,
908: x_msg_count => x_msg_count,

Line 917: RAISE FND_API.G_EXC_ERROR;

913: );
914:
915: x_msg_count := FND_MSG_PUB.count_msg;
916: IF x_msg_count > 0 THEN
917: RAISE FND_API.G_EXC_ERROR;
918: END IF;
919: END IF;
920:
921: -- End of API body.

Line 923: IF FND_API.To_Boolean( p_commit ) THEN

919: END IF;
920:
921: -- End of API body.
922: -- Standard check of p_commit.
923: IF FND_API.To_Boolean( p_commit ) THEN
924: COMMIT WORK;
925: END IF;
926: -- Standard call to get message count and if count is 1, get message info.
927: FND_MSG_PUB.get

Line 932: WHEN FND_API.G_EXC_ERROR THEN

928: ( p_msg_index_out => x_msg_count ,
929: p_data => x_msg_data
930: );
931: EXCEPTION
932: WHEN FND_API.G_EXC_ERROR THEN
933: ROLLBACK TO INSERT_ITEM_ACTIVITIES;
934: x_return_status := FND_API.G_RET_STS_ERROR ;
935: FND_MSG_PUB.get
936: ( p_msg_index_out => x_msg_count ,

Line 934: x_return_status := FND_API.G_RET_STS_ERROR ;

930: );
931: EXCEPTION
932: WHEN FND_API.G_EXC_ERROR THEN
933: ROLLBACK TO INSERT_ITEM_ACTIVITIES;
934: x_return_status := FND_API.G_RET_STS_ERROR ;
935: FND_MSG_PUB.get
936: ( p_msg_index_out => x_msg_count ,
937: p_data => x_msg_data
938: );

Line 939: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

935: FND_MSG_PUB.get
936: ( p_msg_index_out => x_msg_count ,
937: p_data => x_msg_data
938: );
939: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
940: ROLLBACK TO INSERT_ITEM_ACTIVITIES;
941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
942: FND_MSG_PUB.get
943: ( p_msg_index_out => x_msg_count ,

Line 941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

937: p_data => x_msg_data
938: );
939: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
940: ROLLBACK TO INSERT_ITEM_ACTIVITIES;
941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
942: FND_MSG_PUB.get
943: ( p_msg_index_out => x_msg_count ,
944: p_data => x_msg_data
945: );

Line 948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

944: p_data => x_msg_data
945: );
946: WHEN OTHERS THEN
947: ROLLBACK TO INSERT_ITEM_ACTIVITIES;
948: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
949: IF FND_MSG_PUB.Check_Msg_Level
950: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
951: THEN
952: FND_MSG_PUB.Add_Exc_Msg

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

963:
964: PROCEDURE update_item_activities
965: (
966: p_api_version IN NUMBER ,
967: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE ,
968: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
969: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
970: x_return_status OUT NOCOPY VARCHAR2 ,
971: x_msg_count OUT NOCOPY NUMBER ,

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

964: PROCEDURE update_item_activities
965: (
966: p_api_version IN NUMBER ,
967: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE ,
968: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
969: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
970: x_return_status OUT NOCOPY VARCHAR2 ,
971: x_msg_count OUT NOCOPY NUMBER ,
972: x_msg_data OUT NOCOPY VARCHAR2 ,

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

965: (
966: p_api_version IN NUMBER ,
967: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE ,
968: p_commit IN VARCHAR2:= FND_API.G_FALSE ,
969: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
970: x_return_status OUT NOCOPY VARCHAR2 ,
971: x_msg_count OUT NOCOPY NUMBER ,
972: x_msg_data OUT NOCOPY VARCHAR2 ,
973:

Line 1054: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

1050: -- Standard Start of API savepoint
1051: SAVEPOINT UPDATE_ITEM_ACTIVITIES;
1052:
1053: -- Standard call to check for call compatibility.
1054: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1055: p_api_version ,
1056: l_api_name ,
1057: G_PKG_NAME )
1058: THEN

Line 1059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1055: p_api_version ,
1056: l_api_name ,
1057: G_PKG_NAME )
1058: THEN
1059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1060: END IF;
1061: -- Initialize message list if p_init_msg_list is set to TRUE.
1062:
1063: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1063: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1059: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1060: END IF;
1061: -- Initialize message list if p_init_msg_list is set to TRUE.
1062:
1063: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1064: FND_MSG_PUB.initialize;
1065: END IF;
1066: -- Initialize API return status to success
1067: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1067: x_return_status := FND_API.G_RET_STS_SUCCESS;

1063: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1064: FND_MSG_PUB.initialize;
1065: END IF;
1066: -- Initialize API return status to success
1067: x_return_status := FND_API.G_RET_STS_SUCCESS;
1068: -- API body
1069:
1070: l_cnt := 0;
1071:

Line 1079: RAISE fnd_api.g_exc_error;

1075: if (P_CREATION_ORGANIZATION_ID IS NOT NULL) then
1076: if P_CREATION_ORGANIZATION_ID <> P_ORGANIZATION_ID then
1077: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_CR_ORG_ID');
1078: fnd_msg_pub.add;
1079: RAISE fnd_api.g_exc_error;
1080: else
1081: l_creation_organization_id := P_ORGANIZATION_ID;
1082: end if;
1083: else

Line 1101: RAISE fnd_api.g_exc_error;

1097: if l_boolean = 0
1098: then
1099: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_ORG_ID');
1100: fnd_msg_pub.add;
1101: RAISE fnd_api.g_exc_error;
1102: end if;
1103: end if;
1104:
1105:

Line 1109: RAISE fnd_api.g_exc_error;

1105:
1106: IF ((p_class_code IS NOT NULL or p_owningdepartment_id IS NOT NULL) AND p_organization_id IS NULL) THEN
1107: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_ORG_ID');
1108: fnd_msg_pub.add;
1109: RAISE fnd_api.g_exc_error;
1110: END IF;
1111:
1112: -- Bug # 3441956
1113: BEGIN

Line 1144: RAISE fnd_api.g_exc_error;

1140: if p_start_date_active>p_end_date_active
1141: then
1142: fnd_message.set_name('EAM', 'EAM_IAA_INVALID_ACTIVE_DATE');
1143: fnd_msg_pub.add;
1144: RAISE fnd_api.g_exc_error;
1145: END IF;
1146:
1147: if p_last_service_start_date > p_last_service_end_date
1148: then

Line 1151: RAISE fnd_api.g_exc_error;

1147: if p_last_service_start_date > p_last_service_end_date
1148: then
1149: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_START_END_DATE');
1150: fnd_msg_pub.add;
1151: RAISE fnd_api.g_exc_error;
1152: END IF;
1153:
1154: if p_prev_service_start_date > p_prev_service_end_date
1155: then

Line 1158: RAISE fnd_api.g_exc_error;

1154: if p_prev_service_start_date > p_prev_service_end_date
1155: then
1156: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_START_END_DATE');
1157: fnd_msg_pub.add;
1158: RAISE fnd_api.g_exc_error;
1159: END IF;
1160:
1161: if p_last_scheduled_start_date > p_last_scheduled_end_date
1162: then

Line 1165: RAISE fnd_api.g_exc_error;

1161: if p_last_scheduled_start_date > p_last_scheduled_end_date
1162: then
1163: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_START_END_DATE');
1164: fnd_msg_pub.add;
1165: RAISE fnd_api.g_exc_error;
1166: END IF;
1167:
1168:
1169: if p_prev_scheduled_start_date > p_prev_scheduled_end_date

Line 1173: RAISE fnd_api.g_exc_error;

1169: if p_prev_scheduled_start_date > p_prev_scheduled_end_date
1170: then
1171: fnd_message.set_name('EAM', 'EAM_ABO_INVALID_START_END_DATE');
1172: fnd_msg_pub.add;
1173: RAISE fnd_api.g_exc_error;
1174: END IF;
1175:
1176: validate_boolean_flag(p_tagging_required_flag, 'EAM_ABO_INVALID_TAG_REQ_FLAG');
1177:

Line 1212: RAISE FND_API.G_EXC_ERROR;

1208: IF ((p_maintenance_object_type is null or p_maintenance_object_id is null) and
1209: (p_inventory_item_id is null)) THEN
1210: fnd_message.set_name('EAM', 'EAM_NOT_ENOUGH_PARAM');
1211: fnd_msg_pub.add;
1212: RAISE FND_API.G_EXC_ERROR;
1213: END IF;
1214:
1215: IF (p_maintenance_object_type is not null and p_maintenance_object_type NOT in (3,2)) THEN
1216: fnd_message.set_name('EAM', 'EAM_INVALID_MAINT_OBJ_TYPE');

Line 1218: RAISE FND_API.G_EXC_ERROR;

1214:
1215: IF (p_maintenance_object_type is not null and p_maintenance_object_type NOT in (3,2)) THEN
1216: fnd_message.set_name('EAM', 'EAM_INVALID_MAINT_OBJ_TYPE');
1217: fnd_msg_pub.add;
1218: RAISE FND_API.G_EXC_ERROR;
1219: END IF;
1220:
1221: l_org_id := p_organization_id;
1222: l_asset_group_id := p_inventory_item_id;

Line 1339: RAISE fnd_api.g_exc_error;

1335:
1336: IF (l_id = -1) THEN
1337: fnd_message.set_name('EAM', 'EAM_ITEM_ACT_REC_NOT_FOUND');
1338: fnd_msg_pub.add;
1339: RAISE fnd_api.g_exc_error;
1340: END IF;
1341:
1342:
1343: UPDATE mtl_eam_asset_activities

Line 1406: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1402: ,x_msg_count => x_msg_count
1403: ,x_msg_data => x_msg_data
1404: );
1405:
1406: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1407: RAISE fnd_api.g_exc_error;
1408: END IF;
1409:
1410: END IF;

Line 1407: RAISE fnd_api.g_exc_error;

1403: ,x_msg_data => x_msg_data
1404: );
1405:
1406: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1407: RAISE fnd_api.g_exc_error;
1408: END IF;
1409:
1410: END IF;
1411:

Line 1422: p_init_msg_list => FND_API.G_FALSE,--p_init_msg_list,

1418:
1419: EAM_PM_LAST_SERVICE_PUB.process_pm_last_service
1420: (
1421: p_api_version => p_api_version,
1422: p_init_msg_list => FND_API.G_FALSE,--p_init_msg_list,
1423: p_commit => p_commit,
1424: p_validation_level => p_validation_level,
1425: x_return_status => x_return_status,
1426: x_msg_count => x_msg_count,

Line 1435: RAISE FND_API.G_EXC_ERROR;

1431: );
1432:
1433: x_msg_count := FND_MSG_PUB.count_msg;
1434: IF x_msg_count > 0 THEN
1435: RAISE FND_API.G_EXC_ERROR;
1436: END IF;
1437: END IF;
1438:
1439: -- End of API body.

Line 1441: IF FND_API.To_Boolean( p_commit ) THEN

1437: END IF;
1438:
1439: -- End of API body.
1440: -- Standard check of p_commit.
1441: IF FND_API.To_Boolean( p_commit ) THEN
1442: COMMIT WORK;
1443: END IF;
1444: -- Standard call to get message count and if count is 1, get message info.
1445: FND_MSG_PUB.get

Line 1450: WHEN FND_API.G_EXC_ERROR THEN

1446: ( p_msg_index_out => x_msg_count ,
1447: p_data => x_msg_data
1448: );
1449: EXCEPTION
1450: WHEN FND_API.G_EXC_ERROR THEN
1451: ROLLBACK TO UPDATE_ITEM_ACTIVITIES;
1452: x_return_status := FND_API.G_RET_STS_ERROR ;
1453: FND_MSG_PUB.get
1454: ( p_msg_index_out => x_msg_count ,

Line 1452: x_return_status := FND_API.G_RET_STS_ERROR ;

1448: );
1449: EXCEPTION
1450: WHEN FND_API.G_EXC_ERROR THEN
1451: ROLLBACK TO UPDATE_ITEM_ACTIVITIES;
1452: x_return_status := FND_API.G_RET_STS_ERROR ;
1453: FND_MSG_PUB.get
1454: ( p_msg_index_out => x_msg_count ,
1455: p_data => x_msg_data
1456: );

Line 1457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1453: FND_MSG_PUB.get
1454: ( p_msg_index_out => x_msg_count ,
1455: p_data => x_msg_data
1456: );
1457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1458: ROLLBACK TO UPDATE_ITEM_ACTIVITIES;
1459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1460: FND_MSG_PUB.get
1461: ( p_msg_index_out => x_msg_count ,

Line 1459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1455: p_data => x_msg_data
1456: );
1457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1458: ROLLBACK TO UPDATE_ITEM_ACTIVITIES;
1459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1460: FND_MSG_PUB.get
1461: ( p_msg_index_out => x_msg_count ,
1462: p_data => x_msg_data
1463: );

Line 1466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1462: p_data => x_msg_data
1463: );
1464: WHEN OTHERS THEN
1465: ROLLBACK TO UPDATE_ITEM_ACTIVITIES;
1466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1467: IF FND_MSG_PUB.Check_Msg_Level
1468: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1469: THEN
1470: FND_MSG_PUB.Add_Exc_Msg