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_EN_SPAT_LGCY_PUB dependencies on FND_MESSAGE

Line 31: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PER_NUM_NULL');

27:
28: BEGIN
29: IF p_spat_rec.person_number IS NULL THEN
30: l_ret_status := FALSE;
31: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PER_NUM_NULL');
32: FND_MSG_PUB.ADD;
33: END IF;
34:
35: IF p_spat_rec.program_cd IS NULL THEN

Line 37: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRGM_CD_NULL');

33: END IF;
34:
35: IF p_spat_rec.program_cd IS NULL THEN
36: l_ret_status := FALSE;
37: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRGM_CD_NULL');
38: FND_MSG_PUB.ADD;
39: END IF;
40:
41: IF p_spat_rec.program_version IS NULL THEN

Line 43: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRG_VER_NULL');

39: END IF;
40:
41: IF p_spat_rec.program_version IS NULL THEN
42: l_ret_status := FALSE;
43: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRG_VER_NULL');
44: FND_MSG_PUB.ADD;
45: END IF;
46:
47: IF p_spat_rec.location_cd IS NULL THEN

Line 49: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRG_LOC_NULL');

45: END IF;
46:
47: IF p_spat_rec.location_cd IS NULL THEN
48: l_ret_status := FALSE;
49: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRG_LOC_NULL');
50: FND_MSG_PUB.ADD;
51: END IF;
52:
53: IF p_spat_rec.attendance_mode IS NULL THEN

Line 55: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRG_ATT_MOD_NULL');

51: END IF;
52:
53: IF p_spat_rec.attendance_mode IS NULL THEN
54: l_ret_status := FALSE;
55: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRG_ATT_MOD_NULL');
56: FND_MSG_PUB.ADD;
57: END IF;
58:
59: IF p_spat_rec.attendance_type IS NULL THEN

Line 61: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRG_ATT_TYPE_NULL');

57: END IF;
58:
59: IF p_spat_rec.attendance_type IS NULL THEN
60: l_ret_status := FALSE;
61: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRG_ATT_TYPE_NULL');
62: FND_MSG_PUB.ADD;
63: END IF;
64:
65: IF p_spat_rec.key_program_flag IS NULL THEN

Line 67: FND_MESSAGE.SET_NAME('IGS','IGS_EN_KEY_PROG_NULL');

63: END IF;
64:
65: IF p_spat_rec.key_program_flag IS NULL THEN
66: l_ret_status := FALSE;
67: FND_MESSAGE.SET_NAME('IGS','IGS_EN_KEY_PROG_NULL');
68: FND_MSG_PUB.ADD;
69: END IF;
70:
71: IF p_spat_rec.acad_cal_type IS NULL THEN

Line 73: FND_MESSAGE.SET_NAME('IGS','IGS_EN_ACAD_CAL_NULL');

69: END IF;
70:
71: IF p_spat_rec.acad_cal_type IS NULL THEN
72: l_ret_status := FALSE;
73: FND_MESSAGE.SET_NAME('IGS','IGS_EN_ACAD_CAL_NULL');
74: FND_MSG_PUB.ADD;
75: END IF;
76:
77: IF p_spat_rec.term_cal_alternate_cd IS NULL THEN

Line 79: FND_MESSAGE.SET_NAME('IGS','IGS_EN_TERM_CAL_NULL');

75: END IF;
76:
77: IF p_spat_rec.term_cal_alternate_cd IS NULL THEN
78: l_ret_status := FALSE;
79: FND_MESSAGE.SET_NAME('IGS','IGS_EN_TERM_CAL_NULL');
80: FND_MSG_PUB.ADD;
81: END IF;
82:
83: IF (p_spat_rec.attribute_category IS NOT NULL OR

Line 129: FND_MESSAGE.SET_NAME('IGS','IGS_AD_INVALID_DESC_FLEX');

125: p_attribute19 => p_spat_rec.attribute19,
126: p_attribute20 => p_spat_rec.attribute20,
127: p_desc_flex_name => 'IGS_EN_SPA_TERMS_FLEX') THEN
128: l_ret_status := FALSE;
129: FND_MESSAGE.SET_NAME('IGS','IGS_AD_INVALID_DESC_FLEX');
130: FND_MSG_PUB.ADD;
131: END IF;
132: END IF;
133:

Line 144: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRG_CD_UPPCASE');

140: WHEN OTHERS THEN
141: l_ret_status := FALSE;
142: l_message_count := FND_MSG_PUB.COUNT_MSG;
143: FND_MSG_PUB.DELETE_MSG(l_message_count);
144: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRG_CD_UPPCASE');
145: FND_MSG_PUB.ADD;
146: END;
147: END IF;
148:

Line 159: FND_MESSAGE.SET_NAME('IGS','IGS_EN_ACAD_CAL_UPPCASE');

155: WHEN OTHERS THEN
156: l_ret_status := FALSE;
157: l_message_count := FND_MSG_PUB.COUNT_MSG;
158: FND_MSG_PUB.DELETE_MSG(l_message_count);
159: FND_MESSAGE.SET_NAME('IGS','IGS_EN_ACAD_CAL_UPPCASE');
160: FND_MSG_PUB.ADD;
161: END;
162: END IF;
163:

Line 174: FND_MESSAGE.SET_NAME('IGS','IGS_EN_LOC_CD_UCASE');

170: WHEN OTHERS THEN
171: l_ret_status := FALSE;
172: l_message_count := FND_MSG_PUB.COUNT_MSG;
173: FND_MSG_PUB.DELETE_MSG(l_message_count);
174: FND_MESSAGE.SET_NAME('IGS','IGS_EN_LOC_CD_UCASE');
175: FND_MSG_PUB.ADD;
176: END;
177: END IF;
178:

Line 189: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRG_ATT_MODE_UCASE');

185: WHEN OTHERS THEN
186: l_ret_status := FALSE;
187: l_message_count := FND_MSG_PUB.COUNT_MSG;
188: FND_MSG_PUB.DELETE_MSG(l_message_count);
189: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRG_ATT_MODE_UCASE');
190: FND_MSG_PUB.ADD;
191: END;
192: END IF;
193:

Line 204: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRG_ATT_TYPE_UCASE');

200: WHEN OTHERS THEN
201: l_ret_status := FALSE;
202: l_message_count := FND_MSG_PUB.COUNT_MSG;
203: FND_MSG_PUB.DELETE_MSG(l_message_count);
204: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRG_ATT_TYPE_UCASE');
205: FND_MSG_PUB.ADD;
206: END;
207: END IF;
208:

Line 219: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRG_KEY_INVALID');

215: WHEN OTHERS THEN
216: l_ret_status := FALSE;
217: l_message_count := FND_MSG_PUB.COUNT_MSG;
218: FND_MSG_PUB.DELETE_MSG(l_message_count);
219: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRG_KEY_INVALID');
220: FND_MSG_PUB.ADD;
221: END;
222: END IF;
223: RETURN l_ret_status;

Line 253: FND_MESSAGE.SET_NAME('IGS','IGS_EN_SPAT_EXISTS');

249: p_spat_rec.program_cd,
250: p_term_cal_type,
251: p_term_sequence_number);
252: IF l_get_uk_for_validation_return = TRUE THEN
253: FND_MESSAGE.SET_NAME('IGS','IGS_EN_SPAT_EXISTS');
254: FND_MSG_PUB.ADD;
255: RETURN 'W';
256: END IF;
257:

Line 262: FND_MESSAGE.SET_NAME('IGS','IGS_FI_PRSNID_PRGCD_NOT_MATCH');

258: l_get_pk_for_validation_return := igs_en_stdnt_ps_att_pkg.get_pk_for_validation(
259: p_person_id,
260: p_spat_rec.program_cd);
261: IF l_get_pk_for_validation_return = FALSE THEN
262: FND_MESSAGE.SET_NAME('IGS','IGS_FI_PRSNID_PRGCD_NOT_MATCH');
263: FND_MSG_PUB.ADD;
264: l_ret_status := 'E';
265: END IF;
266:

Line 271: FND_MESSAGE.SET_NAME('IGS','IGS_EN_FEE_CAT_NOT_FOUND');

267: IF p_spat_rec.fee_cat IS NOT NULL THEN
268: l_get_pk_for_validation_return := igs_fi_fee_cat_pkg.get_pk_for_validation(
269: p_spat_rec.fee_cat);
270: IF l_get_pk_for_validation_return = FALSE THEN
271: FND_MESSAGE.SET_NAME('IGS','IGS_EN_FEE_CAT_NOT_FOUND');
272: FND_MSG_PUB.ADD;
273: l_ret_status := 'E';
274: END IF;
275: END IF;

Line 357: FND_MESSAGE.SET_NAME('IGS','IGS_EN_SPAT_EXISTS_CAREER');

353: p_term_sequence_number,
354: p_spat_rec.program_cd);
355: FETCH c_igs_en_spa_terms_career INTO l_igs_en_spa_terms_career;
356: IF c_igs_en_spa_terms_career%FOUND THEN
357: FND_MESSAGE.SET_NAME('IGS','IGS_EN_SPAT_EXISTS_CAREER');
358: FND_MSG_PUB.ADD;
359: l_return_value := FALSE;
360: END IF;
361: CLOSE c_igs_en_spa_terms_career;

Line 374: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MORE_KEY_IN_TERM');

370: p_term_sequence_number,
371: p_spat_rec.program_cd);
372: FETCH c_igs_en_spa_terms_normal INTO l_igs_en_spa_terms_normal;
373: IF c_igs_en_spa_terms_normal%FOUND THEN
374: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MORE_KEY_IN_TERM');
375: FND_MSG_PUB.ADD;
376: l_return_value := FALSE;
377: END IF;
378: CLOSE c_igs_en_spa_terms_normal;

Line 496: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_PERSON_NUMBER');

492: -- class_standing_id, coo_id
493: IF NOT l_validation_failed THEN
494: l_person_id := igs_ge_gen_003.get_person_id(p_spat_rec.person_number);
495: IF l_person_id IS NULL THEN
496: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_PERSON_NUMBER');
497: FND_MSG_PUB.ADD;
498: x_return_status := FND_API.G_RET_STS_ERROR;
499: l_validation_failed := TRUE;
500: END IF;

Line 511: FND_MESSAGE.SET_NAME('IGS','IGS_EN_ALT_CD_NO_TRM_FND');

507: l_ci_start_dt,
508: l_ci_end_dt,
509: l_get_calendar_instance_return);
510: IF l_get_calendar_instance_return = 'INVALID' THEN
511: FND_MESSAGE.SET_NAME('IGS','IGS_EN_ALT_CD_NO_TRM_FND');
512: FND_MSG_PUB.ADD;
513: x_return_status := FND_API.G_RET_STS_ERROR;
514: l_validation_failed := TRUE;
515: ELSE

Line 517: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MULTI_TRM_CAL_FND');

513: x_return_status := FND_API.G_RET_STS_ERROR;
514: l_validation_failed := TRUE;
515: ELSE
516: IF l_get_calendar_instance_return = 'MULTIPLE' THEN
517: FND_MESSAGE.SET_NAME('IGS','IGS_EN_MULTI_TRM_CAL_FND');
518: FND_MSG_PUB.ADD;
519: x_return_status := FND_API.G_RET_STS_ERROR;
520: l_validation_failed := TRUE;
521: END IF;

Line 527: FND_MESSAGE.SET_NAME('IGS','IGS_EN_CLASS_STD_ID_NOT_FOUND');

523:
524: IF p_spat_rec.class_standing IS NOT NULL THEN
525: l_class_standing_id := igs_en_gen_legacy.get_class_std_id(p_spat_rec.class_standing);
526: IF l_class_standing_id IS NULL THEN
527: FND_MESSAGE.SET_NAME('IGS','IGS_EN_CLASS_STD_ID_NOT_FOUND');
528: FND_MSG_PUB.ADD;
529: x_return_status := FND_API.G_RET_STS_ERROR;
530: l_validation_failed := TRUE;
531: END IF;

Line 542: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PS_OFR_OPT_NOT_FOUND');

538: p_spat_rec.location_cd,
539: p_spat_rec.attendance_mode,
540: p_spat_rec.attendance_type);
541: IF l_coo_id IS NULL THEN
542: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PS_OFR_OPT_NOT_FOUND');
543: FND_MSG_PUB.ADD;
544: x_return_status := FND_API.G_RET_STS_ERROR;
545: l_validation_failed := TRUE;
546: END IF;