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_PR_CLSRNK_LGCY_PUB dependencies on FND_MSG_PUB

Line 130: FND_MSG_PUB.initialize;

126: END IF;
127:
128: --Initialize message list if p_init_msg_list is set to TRUE.
129: IF FND_API.to_Boolean(p_init_msg_list) THEN
130: FND_MSG_PUB.initialize;
131: END IF;
132:
133: --Initialize API return status to success.
134: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 222: FND_MSG_PUB.Count_And_Get(

218: commit;
219: END IF;
220:
221: --Standard call to get message count and if count is 1, get message info.
222: FND_MSG_PUB.Count_And_Get(
223: p_count => x_msg_count,
224: p_data => x_msg_data);
225:
226: EXCEPTION

Line 230: FND_MSG_PUB.Count_And_Get(

226: EXCEPTION
227: WHEN FND_API.G_EXC_ERROR THEN
228: ROLLBACK TO create_class_rank;
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: FND_MSG_PUB.Count_And_Get(
231: p_count => x_msg_count,
232: p_data => x_msg_data);
233:
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 237: FND_MSG_PUB.Count_And_Get(

233:
234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
235: ROLLBACK TO create_class_rank;
236: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
237: FND_MSG_PUB.Count_And_Get(
238: p_count => x_msg_count,
239: p_data => x_msg_data);
240: WHEN OTHERS THEN
241: ROLLBACK TO create_class_rank;

Line 245: FND_MSG_PUB.ADD;

241: ROLLBACK TO create_class_rank;
242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
243: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
244: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
245: FND_MSG_PUB.ADD;
246: FND_MSG_PUB.Count_And_Get(
247: p_count => x_msg_count,
248: p_data => x_msg_data);
249:

Line 246: FND_MSG_PUB.Count_And_Get(

242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
243: FND_MESSAGE.SET_NAME('IGS', 'IGS_AV_UNHANDLED_ERROR');
244: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
245: FND_MSG_PUB.ADD;
246: FND_MSG_PUB.Count_And_Get(
247: p_count => x_msg_count,
248: p_data => x_msg_data);
249:
250: END create_class_rank;

Line 275: FND_MSG_PUB.ADD;

271: x_return_status := TRUE;
272:
273: IF p_lgcy_clsrnk_rec.person_number IS NULL THEN
274: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_PER_NUM_NULL');
275: FND_MSG_PUB.ADD;
276: x_return_status := FALSE;
277: END IF;
278: IF p_lgcy_clsrnk_rec.program_cd IS NULL THEN
279: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_PRGM_CD_NULL');

Line 280: FND_MSG_PUB.ADD;

276: x_return_status := FALSE;
277: END IF;
278: IF p_lgcy_clsrnk_rec.program_cd IS NULL THEN
279: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_PRGM_CD_NULL');
280: FND_MSG_PUB.ADD;
281: x_return_status := FALSE;
282: END IF;
283: IF p_lgcy_clsrnk_rec.calendar_alternate_code IS NULL THEN
284: FND_MESSAGE.SET_NAME('IGS', 'IGS_PR_CAL_ALT_CD_NULL');

Line 285: FND_MSG_PUB.ADD;

281: x_return_status := FALSE;
282: END IF;
283: IF p_lgcy_clsrnk_rec.calendar_alternate_code IS NULL THEN
284: FND_MESSAGE.SET_NAME('IGS', 'IGS_PR_CAL_ALT_CD_NULL');
285: FND_MSG_PUB.ADD;
286: x_return_status := FALSE;
287: END IF;
288: IF p_lgcy_clsrnk_rec.cohort_rank IS NULL OR p_lgcy_clsrnk_rec.cohort_rank <=0 THEN
289: FND_MESSAGE.SET_NAME('IGS', 'IGS_PR_RANK_NULL');

Line 290: FND_MSG_PUB.ADD;

286: x_return_status := FALSE;
287: END IF;
288: IF p_lgcy_clsrnk_rec.cohort_rank IS NULL OR p_lgcy_clsrnk_rec.cohort_rank <=0 THEN
289: FND_MESSAGE.SET_NAME('IGS', 'IGS_PR_RANK_NULL');
290: FND_MSG_PUB.ADD;
291: x_return_status := FALSE;
292: END IF;
293: IF p_lgcy_clsrnk_rec.cohort_name IS NULL THEN
294: FND_MESSAGE.SET_NAME('IGS', 'IGS_PR_CHRT_NAME_NULL');

Line 295: FND_MSG_PUB.ADD;

291: x_return_status := FALSE;
292: END IF;
293: IF p_lgcy_clsrnk_rec.cohort_name IS NULL THEN
294: FND_MESSAGE.SET_NAME('IGS', 'IGS_PR_CHRT_NAME_NULL');
295: FND_MSG_PUB.ADD;
296: x_return_status := FALSE;
297: END IF;
298: IF p_lgcy_clsrnk_rec.as_of_rank_gpa IS NULL OR p_lgcy_clsrnk_rec.as_of_rank_gpa < 0 THEN
299: FND_MESSAGE.SET_NAME('IGS', 'IGS_PR_GPA_NULL');

Line 300: FND_MSG_PUB.ADD;

296: x_return_status := FALSE;
297: END IF;
298: IF p_lgcy_clsrnk_rec.as_of_rank_gpa IS NULL OR p_lgcy_clsrnk_rec.as_of_rank_gpa < 0 THEN
299: FND_MESSAGE.SET_NAME('IGS', 'IGS_PR_GPA_NULL');
300: FND_MSG_PUB.ADD;
301: x_return_status := FALSE;
302: END IF;
303: IF p_lgcy_clsrnk_rec.cohort_override_rank IS NOT NULL AND
304: p_lgcy_clsrnk_rec.cohort_override_rank <= 0 THEN

Line 306: FND_MSG_PUB.ADD;

302: END IF;
303: IF p_lgcy_clsrnk_rec.cohort_override_rank IS NOT NULL AND
304: p_lgcy_clsrnk_rec.cohort_override_rank <= 0 THEN
305: FND_MESSAGE.SET_NAME('IGS', 'IGS_PR_RANK_NULL');
306: FND_MSG_PUB.ADD;
307: x_return_status := FALSE;
308: END IF;
309:
310: /*

Line 346: FND_MSG_PUB.ADD;

342: */
343: p_person_id := IGS_GE_GEN_003.GET_PERSON_ID(p_lgcy_clsrnk_rec.person_number);
344: IF p_person_id IS NULL THEN
345: FND_MESSAGE.SET_NAME('IGS', 'IGS_GE_INVALID_PERSON_NUMBER');
346: FND_MSG_PUB.ADD;
347: x_return_status := FALSE;
348: END IF;
349: /*
350: get cal_type and sequence_number

Line 369: FND_MSG_PUB.ADD;

365: P_RETURN_STATUS => l_return_status
366: );
367: IF l_return_status = 'INVALID' THEN
368: FND_MESSAGE.SET_NAME('IGS', 'IGS_PR_NO_ALT_CODE');
369: FND_MSG_PUB.ADD;
370: x_return_status := FALSE;
371: ELSIF l_return_status = 'MULTIPLE' THEN
372: FND_MESSAGE.SET_NAME('IGS', 'IGS_PR_MULTI_ALT_CODE');
373: FND_MSG_PUB.ADD;

Line 373: FND_MSG_PUB.ADD;

369: FND_MSG_PUB.ADD;
370: x_return_status := FALSE;
371: ELSIF l_return_status = 'MULTIPLE' THEN
372: FND_MESSAGE.SET_NAME('IGS', 'IGS_PR_MULTI_ALT_CODE');
373: FND_MSG_PUB.ADD;
374: x_return_status := FALSE;
375: END IF;
376: END;
377:

Line 416: FND_MSG_PUB.ADD;

412: x_load_cal_type => p_cal_type,
413: x_load_ci_sequence_number => p_sequence_number
414: ) THEN
415: FND_MESSAGE.SET_NAME('IGS', 'IGS_PR_COHINST_NOT_EXIST');
416: FND_MSG_PUB.ADD;
417: x_return_status := 'E';
418: END IF;
419: /*
420: check whether program attempt exists or not

Line 428: FND_MSG_PUB.ADD;

424: x_person_id => p_person_id,
425: x_course_cd => p_lgcy_clsrnk_rec.program_cd
426: ) THEN
427: FND_MESSAGE.SET_NAME('IGS', 'IGS_EN_PRGM_ATT_NOT_EXIST');
428: FND_MSG_PUB.ADD;
429: x_return_status := 'E';
430: END IF;
431: /*
432: Check if the student already has already been ranked for the cohort instance.

Line 446: FND_MSG_PUB.ADD;

442: x_load_cal_type => p_cal_type,
443: x_load_ci_sequence_number => p_sequence_number
444: ) THEN
445: FND_MESSAGE.SET_NAME('IGS', 'IGS_PR_RANK_EXIST');
446: FND_MSG_PUB.ADD;
447: x_return_status := 'W';
448: END IF;
449:
450: return x_return_status;