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.IGS_DA_UTILS_PKG dependencies on FND_API

Line 219: IF l_status <> FND_API.G_RET_STS_SUCCESS THEN

215: );
216: ELSE
217: IF l_is_filename_null = 'N' THEN
218: l_dyn_stud_grp_mem := IGS_PE_DYNAMIC_PERSID_GROUP.IGS_GET_DYNAMIC_SQL (rec_igs_da_rqst.person_id_group_id,l_status);
219: IF l_status <> FND_API.G_RET_STS_SUCCESS THEN
220: FND_MESSAGE.SET_NAME('IGS','IGS_AZ_DYN_PERS_ID_GRP_ERR');
221: FND_MSG_PUB.ADD;
222: RAISE FND_API.G_EXC_ERROR;
223: END IF;

Line 222: RAISE FND_API.G_EXC_ERROR;

218: l_dyn_stud_grp_mem := IGS_PE_DYNAMIC_PERSID_GROUP.IGS_GET_DYNAMIC_SQL (rec_igs_da_rqst.person_id_group_id,l_status);
219: IF l_status <> FND_API.G_RET_STS_SUCCESS THEN
220: FND_MESSAGE.SET_NAME('IGS','IGS_AZ_DYN_PERS_ID_GRP_ERR');
221: FND_MSG_PUB.ADD;
222: RAISE FND_API.G_EXC_ERROR;
223: END IF;
224: OPEN c_stud_grp_mem FOR l_dyn_stud_grp_mem;
225: ELSE
226: OPEN c_stud_grp_mem FOR l_stc_stud_grp_mem USING rec_igs_da_rqst.person_id_group_id;

Line 274: IF l_status <> FND_API.G_RET_STS_SUCCESS THEN

270: );
271: ELSE
272: IF l_is_filename_null = 'N' THEN
273: l_dyn_stud_grp_mem := IGS_PE_DYNAMIC_PERSID_GROUP.IGS_GET_DYNAMIC_SQL (rec_igs_da_rqst.person_id_group_id,l_status);
274: IF l_status <> FND_API.G_RET_STS_SUCCESS THEN
275: FND_MESSAGE.SET_NAME('IGS','IGS_AZ_DYN_PERS_ID_GRP_ERR');
276: FND_MSG_PUB.ADD;
277: RAISE FND_API.G_EXC_ERROR;
278: END IF;

Line 277: RAISE FND_API.G_EXC_ERROR;

273: l_dyn_stud_grp_mem := IGS_PE_DYNAMIC_PERSID_GROUP.IGS_GET_DYNAMIC_SQL (rec_igs_da_rqst.person_id_group_id,l_status);
274: IF l_status <> FND_API.G_RET_STS_SUCCESS THEN
275: FND_MESSAGE.SET_NAME('IGS','IGS_AZ_DYN_PERS_ID_GRP_ERR');
276: FND_MSG_PUB.ADD;
277: RAISE FND_API.G_EXC_ERROR;
278: END IF;
279: OPEN c_stud_grp_mem FOR l_dyn_stud_grp_mem;
280: ELSE
281: OPEN c_stud_grp_mem FOR l_stc_stud_grp_mem USING rec_igs_da_rqst.person_id_group_id;

Line 333: IF l_status <> FND_API.G_RET_STS_SUCCESS THEN

329: END LOOP;
330: ELSE
331: IF l_is_filename_null = 'N' THEN
332: l_dyn_stud_grp_mem := IGS_PE_DYNAMIC_PERSID_GROUP.IGS_GET_DYNAMIC_SQL (rec_igs_da_rqst.person_id_group_id,l_status);
333: IF l_status <> FND_API.G_RET_STS_SUCCESS THEN
334: FND_MESSAGE.SET_NAME('IGS','IGS_AZ_DYN_PERS_ID_GRP_ERR');
335: FND_MSG_PUB.ADD;
336: RAISE FND_API.G_EXC_ERROR;
337: END IF;

Line 336: RAISE FND_API.G_EXC_ERROR;

332: l_dyn_stud_grp_mem := IGS_PE_DYNAMIC_PERSID_GROUP.IGS_GET_DYNAMIC_SQL (rec_igs_da_rqst.person_id_group_id,l_status);
333: IF l_status <> FND_API.G_RET_STS_SUCCESS THEN
334: FND_MESSAGE.SET_NAME('IGS','IGS_AZ_DYN_PERS_ID_GRP_ERR');
335: FND_MSG_PUB.ADD;
336: RAISE FND_API.G_EXC_ERROR;
337: END IF;
338: OPEN c_stud_grp_mem FOR l_dyn_stud_grp_mem;
339: ELSE
340: OPEN c_stud_grp_mem FOR l_stc_stud_grp_mem USING rec_igs_da_rqst.person_id_group_id;

Line 417: RAISE FND_API.G_EXC_ERROR;

413: );
414: IF l_return_status <>'S' THEN
415: FND_MESSAGE.SET_NAME('IGS','IGS_DA_CR_PLS_ERROR');
416: FND_MSG_PUB.ADD;
417: RAISE FND_API.G_EXC_ERROR;
418: END IF;
419:
420: END LOOP;
421: CLOSE c_igs_da_rqst;

Line 450: RAISE FND_API.G_EXC_ERROR;

446: EXCEPTION
447: WHEN OTHERS THEN
448: FND_MESSAGE.SET_NAME('IGS','IGS_DA_XML_ERROR');
449: FND_MSG_PUB.ADD;
450: RAISE FND_API.G_EXC_ERROR;
451: END;
452:
453: -- Initialize API return status to success.
454: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 454: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

450: RAISE FND_API.G_EXC_ERROR;
451: END;
452:
453: -- Initialize API return status to success.
454: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
455: -- Standard call to get message count and if count is 1, get message
456: -- info.
457: FND_MSG_PUB.Count_And_Get(
458: p_encoded => FND_API.G_TRUE,

Line 458: p_encoded => FND_API.G_TRUE,

454: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
455: -- Standard call to get message count and if count is 1, get message
456: -- info.
457: FND_MSG_PUB.Count_And_Get(
458: p_encoded => FND_API.G_TRUE,
459: p_count => x_MSG_COUNT,
460: p_data => X_MSG_DATA);
461:
462: EXCEPTION

Line 463: WHEN FND_API.G_EXC_ERROR THEN

459: p_count => x_MSG_COUNT,
460: p_data => X_MSG_DATA);
461:
462: EXCEPTION
463: WHEN FND_API.G_EXC_ERROR THEN
464: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
465: FND_MSG_PUB.Count_And_Get(
466: p_encoded => FND_API.G_TRUE,
467: p_count => x_MSG_COUNT,

Line 464: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

460: p_data => X_MSG_DATA);
461:
462: EXCEPTION
463: WHEN FND_API.G_EXC_ERROR THEN
464: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
465: FND_MSG_PUB.Count_And_Get(
466: p_encoded => FND_API.G_TRUE,
467: p_count => x_MSG_COUNT,
468: p_data => X_MSG_DATA);

Line 466: p_encoded => FND_API.G_TRUE,

462: EXCEPTION
463: WHEN FND_API.G_EXC_ERROR THEN
464: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
465: FND_MSG_PUB.Count_And_Get(
466: p_encoded => FND_API.G_TRUE,
467: p_count => x_MSG_COUNT,
468: p_data => X_MSG_DATA);
469: RETURN;
470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

466: p_encoded => FND_API.G_TRUE,
467: p_count => x_MSG_COUNT,
468: p_data => X_MSG_DATA);
469: RETURN;
470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
471: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
472: FND_MSG_PUB.Count_And_Get(
473: p_encoded => FND_API.G_TRUE,
474: p_count => x_MSG_COUNT,

Line 471: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

467: p_count => x_MSG_COUNT,
468: p_data => X_MSG_DATA);
469: RETURN;
470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
471: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
472: FND_MSG_PUB.Count_And_Get(
473: p_encoded => FND_API.G_TRUE,
474: p_count => x_MSG_COUNT,
475: p_data => X_MSG_DATA);

Line 473: p_encoded => FND_API.G_TRUE,

469: RETURN;
470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
471: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
472: FND_MSG_PUB.Count_And_Get(
473: p_encoded => FND_API.G_TRUE,
474: p_count => x_MSG_COUNT,
475: p_data => X_MSG_DATA);
476: RETURN;
477: WHEN OTHERS THEN

Line 478: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

474: p_count => x_MSG_COUNT,
475: p_data => X_MSG_DATA);
476: RETURN;
477: WHEN OTHERS THEN
478: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
479: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
480: FND_MESSAGE.SET_TOKEN('NAME','create_req_stdnts_rec : '||SQLERRM);
481: FND_MSG_PUB.ADD;
482: FND_MSG_PUB.Count_And_Get(

Line 483: p_encoded => FND_API.G_TRUE,

479: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_UNHANDLED_EXCEPTION');
480: FND_MESSAGE.SET_TOKEN('NAME','create_req_stdnts_rec : '||SQLERRM);
481: FND_MSG_PUB.ADD;
482: FND_MSG_PUB.Count_And_Get(
483: p_encoded => FND_API.G_TRUE,
484: p_count => x_MSG_COUNT,
485: p_data => X_MSG_DATA);
486: RETURN;
487: END create_req_stdnts_rec;