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_MSG_PUB

Line 32: FND_MSG_PUB.ADD;

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
36: l_ret_status := FALSE;

Line 38: FND_MSG_PUB.ADD;

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
42: l_ret_status := FALSE;

Line 44: FND_MSG_PUB.ADD;

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
48: l_ret_status := FALSE;

Line 50: FND_MSG_PUB.ADD;

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
54: l_ret_status := FALSE;

Line 56: FND_MSG_PUB.ADD;

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
60: l_ret_status := FALSE;

Line 62: FND_MSG_PUB.ADD;

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
66: l_ret_status := FALSE;

Line 68: FND_MSG_PUB.ADD;

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
72: l_ret_status := FALSE;

Line 74: FND_MSG_PUB.ADD;

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
78: l_ret_status := FALSE;

Line 80: FND_MSG_PUB.ADD;

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
84: p_spat_rec.attribute1 IS NOT NULL OR

Line 130: FND_MSG_PUB.ADD;

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:
134: IF p_spat_rec.program_cd IS NOT NULL THEN

Line 142: l_message_count := FND_MSG_PUB.COUNT_MSG;

138: column_value => p_spat_rec.program_cd);
139: EXCEPTION
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;

Line 143: FND_MSG_PUB.DELETE_MSG(l_message_count);

139: EXCEPTION
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;

Line 145: FND_MSG_PUB.ADD;

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:
149: IF p_spat_rec.acad_cal_type IS NOT NULL THEN

Line 157: l_message_count := FND_MSG_PUB.COUNT_MSG;

153: column_value => p_spat_rec.acad_cal_type);
154: EXCEPTION
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;

Line 158: FND_MSG_PUB.DELETE_MSG(l_message_count);

154: EXCEPTION
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;

Line 160: FND_MSG_PUB.ADD;

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:
164: IF p_spat_rec.location_cd IS NOT NULL THEN

Line 172: l_message_count := FND_MSG_PUB.COUNT_MSG;

168: column_value => p_spat_rec.location_cd);
169: EXCEPTION
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;

Line 173: FND_MSG_PUB.DELETE_MSG(l_message_count);

169: EXCEPTION
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;

Line 175: FND_MSG_PUB.ADD;

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:
179: IF p_spat_rec.attendance_mode IS NOT NULL THEN

Line 187: l_message_count := FND_MSG_PUB.COUNT_MSG;

183: column_value => p_spat_rec.attendance_mode);
184: EXCEPTION
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;

Line 188: FND_MSG_PUB.DELETE_MSG(l_message_count);

184: EXCEPTION
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;

Line 190: FND_MSG_PUB.ADD;

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:
194: IF p_spat_rec.attendance_type IS NOT NULL THEN

Line 202: l_message_count := FND_MSG_PUB.COUNT_MSG;

198: column_value => p_spat_rec.attendance_type);
199: EXCEPTION
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;

Line 203: FND_MSG_PUB.DELETE_MSG(l_message_count);

199: EXCEPTION
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;

Line 205: FND_MSG_PUB.ADD;

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:
209: IF p_spat_rec.key_program_flag IS NOT NULL THEN

Line 217: l_message_count := FND_MSG_PUB.COUNT_MSG;

213: column_value => p_spat_rec.key_program_flag);
214: EXCEPTION
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;

Line 218: FND_MSG_PUB.DELETE_MSG(l_message_count);

214: EXCEPTION
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;

Line 220: FND_MSG_PUB.ADD;

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;
224: END validate_parameters;

Line 254: FND_MSG_PUB.ADD;

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:
258: l_get_pk_for_validation_return := igs_en_stdnt_ps_att_pkg.get_pk_for_validation(

Line 263: FND_MSG_PUB.ADD;

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:
267: IF p_spat_rec.fee_cat IS NOT NULL THEN

Line 272: FND_MSG_PUB.ADD;

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;
276: RETURN l_ret_status;

Line 358: FND_MSG_PUB.ADD;

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;
362: END IF;

Line 375: FND_MSG_PUB.ADD;

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;
379: END IF;

Line 478: FND_MSG_PUB.INITIALIZE;

474: END IF;
475:
476: -- If the calling program has passed the parameter for initializing the message list
477: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
478: FND_MSG_PUB.INITIALIZE;
479: END IF;
480:
481: -- Set the return status to success
482: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 497: FND_MSG_PUB.ADD;

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;
501:

Line 512: FND_MSG_PUB.ADD;

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
516: IF l_get_calendar_instance_return = 'MULTIPLE' THEN

Line 518: FND_MSG_PUB.ADD;

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;
522: END IF;

Line 528: FND_MSG_PUB.ADD;

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;
532: END IF;

Line 543: FND_MSG_PUB.ADD;

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;
547: END IF;

Line 713: FND_MSG_PUB.COUNT_AND_GET (

709: IF NOT l_validation_failed AND FND_API.TO_BOOLEAN(p_commit) THEN
710: COMMIT;
711: END IF;
712:
713: FND_MSG_PUB.COUNT_AND_GET (
714: p_count => x_msg_count,
715: p_data => x_msg_data);
716:
717: RETURN;

Line 724: FND_MSG_PUB.COUNT_AND_GET (

720:
721: WHEN FND_API.G_EXC_ERROR THEN
722: ROLLBACK TO create_spa_t_svpt;
723: x_return_status := FND_API.G_RET_STS_ERROR;
724: FND_MSG_PUB.COUNT_AND_GET (
725: p_count => x_msg_count,
726: p_data => x_msg_data);
727:
728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 731: FND_MSG_PUB.COUNT_AND_GET (

727:
728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
729: ROLLBACK TO create_spa_t_svpt;
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
731: FND_MSG_PUB.COUNT_AND_GET (
732: p_count => x_msg_count,
733: p_data => x_msg_data);
734:
735: WHEN OTHERS THEN

Line 738: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

734:
735: WHEN OTHERS THEN
736: ROLLBACK TO create_spa_t_svpt;
737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
738: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
739: FND_MSG_PUB.ADD_EXC_MSG(
740: g_pkg_name,
741: l_api_name);
742: END IF;

Line 739: FND_MSG_PUB.ADD_EXC_MSG(

735: WHEN OTHERS THEN
736: ROLLBACK TO create_spa_t_svpt;
737: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
738: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
739: FND_MSG_PUB.ADD_EXC_MSG(
740: g_pkg_name,
741: l_api_name);
742: END IF;
743: FND_MSG_PUB.COUNT_AND_GET (

Line 743: FND_MSG_PUB.COUNT_AND_GET (

739: FND_MSG_PUB.ADD_EXC_MSG(
740: g_pkg_name,
741: l_api_name);
742: END IF;
743: FND_MSG_PUB.COUNT_AND_GET (
744: p_count => x_msg_count,
745: p_data => x_msg_data);
746:
747: END create_spa_t;