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 142: IF P_LOOKUP_CODE IS NULL OR P_LOOKUP_CODE = FND_API.G_MISS_CHAR

138: PROCEDURE validate_mfg_lookups(P_LOOKUP_TYPE IN VARCHAR2, P_LOOKUP_CODE in varchar2, P_MSG in varchar2)
139: is
140: l_count number;
141: BEGIN
142: IF P_LOOKUP_CODE IS NULL OR P_LOOKUP_CODE = FND_API.G_MISS_CHAR
143: THEN
144: RETURN ;
145: END IF ;
146:

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 166: IF P_WIP_ACNT_CLASS IS NULL OR P_WIP_ACNT_CLASS = FND_API.G_MISS_CHAR OR P_ORGANIZATION_ID IS NULL

162: is
163: l_count number;
164: BEGIN
165:
166: IF P_WIP_ACNT_CLASS IS NULL OR P_WIP_ACNT_CLASS = FND_API.G_MISS_CHAR OR P_ORGANIZATION_ID IS NULL
167: THEN
168: RETURN ;
169: END IF ;
170:

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 189: if(p_flag is not null and p_flag <> FND_API.G_MISS_CHAR)

185:
186: PROCEDURE validate_boolean_flag(p_flag IN VARCHAR2, p_msg IN VARCHAR2)
187: is
188: begin
189: if(p_flag is not null and p_flag <> FND_API.G_MISS_CHAR)
190: then
191: if not EAM_COMMON_UTILITIES_PVT.validate_boolean_flag(p_flag)
192: then
193: fnd_message.set_name('EAM', p_msg);

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 891: IF x_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 892: RAISE fnd_api.g_exc_error;

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

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

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

Line 918: RAISE FND_API.G_EXC_ERROR;

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

Line 924: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 933: WHEN FND_API.G_EXC_ERROR THEN

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

Line 935: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 942: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

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

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

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

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

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

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

Line 1055: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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

Line 1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1064: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 1068: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 1080: RAISE fnd_api.g_exc_error;

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

Line 1102: RAISE fnd_api.g_exc_error;

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

Line 1110: RAISE fnd_api.g_exc_error;

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

Line 1145: RAISE fnd_api.g_exc_error;

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

Line 1152: RAISE fnd_api.g_exc_error;

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

Line 1159: RAISE fnd_api.g_exc_error;

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

Line 1166: RAISE fnd_api.g_exc_error;

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

Line 1174: RAISE fnd_api.g_exc_error;

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

Line 1181: IF (p_owningdepartment_id is not null AND p_owningdepartment_id <> FND_API.G_MISS_NUM) THEN

1177: validate_boolean_flag(p_tagging_required_flag, 'EAM_ABO_INVALID_TAG_REQ_FLAG');
1178:
1179: validate_boolean_flag(p_tmpl_flag, 'EAM_IAA_INV_TEML_FLAG');
1180:
1181: IF (p_owningdepartment_id is not null AND p_owningdepartment_id <> FND_API.G_MISS_NUM) THEN
1182: l_validated := EAM_COMMON_UTILITIES_PVT.validate_department_id(p_owningdepartment_id, l_org_id);
1183: IF NOT l_validated THEN
1184: raise_error ('EAM_ABO_INVALID_OWN_DEPT_ID');
1185: END IF;

Line 1213: RAISE FND_API.G_EXC_ERROR;

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

Line 1219: RAISE FND_API.G_EXC_ERROR;

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

Line 1340: RAISE fnd_api.g_exc_error;

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

Line 1407: IF x_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 1408: RAISE fnd_api.g_exc_error;

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

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

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

Line 1436: RAISE FND_API.G_EXC_ERROR;

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

Line 1442: IF FND_API.To_Boolean( p_commit ) THEN

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

Line 1451: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1453: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 1458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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