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

Line 45: FND_MSG_PUB.ADD;

41:
42: -- Check whether the person number is null or not.
43: IF p_intermiss_rec.person_number IS NULL THEN
44: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PER_NUM_NULL');
45: FND_MSG_PUB.ADD;
46: l_valid_params := FALSE;
47: END IF;
48:
49: -- Check whether the program code is null or not.

Line 52: FND_MSG_PUB.ADD;

48:
49: -- Check whether the program code is null or not.
50: IF p_intermiss_rec.program_cd IS NULL THEN
51: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRGM_CD_NULL');
52: FND_MSG_PUB.ADD;
53: l_valid_params := FALSE;
54: ELSE
55: BEGIN
56: igs_en_stdnt_ps_intm_pkg.check_constraints ('COURSE_CD', p_intermiss_rec.program_cd);

Line 59: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,

55: BEGIN
56: igs_en_stdnt_ps_intm_pkg.check_constraints ('COURSE_CD', p_intermiss_rec.program_cd);
57: EXCEPTION
58: WHEN OTHERS THEN
59: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,
60: p_data => l_msg_data);
61:
62: -- Delete the message 'IGS_GE_INVALID_VALUE'
63: FND_MSG_PUB.DELETE_MSG (l_msg_count);

Line 63: FND_MSG_PUB.DELETE_MSG (l_msg_count);

59: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,
60: p_data => l_msg_data);
61:
62: -- Delete the message 'IGS_GE_INVALID_VALUE'
63: FND_MSG_PUB.DELETE_MSG (l_msg_count);
64:
65: -- set the customized message
66: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRGM_CD_UCASE');
67: FND_MSG_PUB.ADD;

Line 67: FND_MSG_PUB.ADD;

63: FND_MSG_PUB.DELETE_MSG (l_msg_count);
64:
65: -- set the customized message
66: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRGM_CD_UCASE');
67: FND_MSG_PUB.ADD;
68: l_valid_params := FALSE;
69: END;
70: END IF;
71:

Line 75: FND_MSG_PUB.ADD;

71:
72: -- Check whether start date is null or not
73: IF p_intermiss_rec.start_dt IS NULL THEN
74: FND_MESSAGE.SET_NAME('IGS','IGS_PS_STARDT_NOT_NULL');
75: FND_MSG_PUB.ADD;
76: l_valid_params := FALSE;
77: END IF;
78:
79: -- Check whether end date is null or not

Line 82: FND_MSG_PUB.ADD;

78:
79: -- Check whether end date is null or not
80: IF p_intermiss_rec.end_dt IS NULL THEN
81: FND_MESSAGE.SET_NAME('IGS','IGS_EN_END_DT_CANT_NULL');
82: FND_MSG_PUB.ADD;
83: l_valid_params := FALSE;
84: END IF;
85:
86: -- Check whether voluntary_ind is having any other value other than 'Y'/'N'

Line 92: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,

88: BEGIN
89: igs_en_stdnt_ps_intm_pkg.check_constraints ('VOLUNTARY_IND', p_intermiss_rec.voluntary_ind);
90: EXCEPTION
91: WHEN OTHERS THEN
92: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,
93: p_data => l_msg_data);
94:
95: FND_MSG_PUB.DELETE_MSG (l_msg_count);
96: FND_MESSAGE.SET_NAME('IGS','IGS_EN_VOL_IND_INVALID');

Line 95: FND_MSG_PUB.DELETE_MSG (l_msg_count);

91: WHEN OTHERS THEN
92: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,
93: p_data => l_msg_data);
94:
95: FND_MSG_PUB.DELETE_MSG (l_msg_count);
96: FND_MESSAGE.SET_NAME('IGS','IGS_EN_VOL_IND_INVALID');
97: FND_MSG_PUB.ADD;
98: l_valid_params := FALSE;
99: END;

Line 97: FND_MSG_PUB.ADD;

93: p_data => l_msg_data);
94:
95: FND_MSG_PUB.DELETE_MSG (l_msg_count);
96: FND_MESSAGE.SET_NAME('IGS','IGS_EN_VOL_IND_INVALID');
97: FND_MSG_PUB.ADD;
98: l_valid_params := FALSE;
99: END;
100: END IF;
101:

Line 106: FND_MSG_PUB.ADD;

102: -- Check whether Intermission type is upper case or not.
103: IF p_intermiss_rec.intermission_type IS NOT NULL THEN
104: IF p_intermiss_rec.intermission_type <> UPPER(p_intermiss_rec.intermission_type) then
105: FND_MESSAGE.SET_NAME('IGS','IGS_EN_INTM_TYPE_UCASE');
106: FND_MSG_PUB.ADD;
107: l_valid_params := FALSE;
108: END IF;
109: END IF;
110:

Line 117: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,

113: BEGIN
114: igs_en_stdnt_ps_intm_pkg.check_constraints ('APPROVED', p_intermiss_rec.approved);
115: EXCEPTION
116: WHEN OTHERS THEN
117: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,
118: p_data => l_msg_data);
119:
120: FND_MSG_PUB.DELETE_MSG (l_msg_count);
121: FND_MESSAGE.SET_NAME('IGS','IGS_EN_APPROVED_INVALID');

Line 120: FND_MSG_PUB.DELETE_MSG (l_msg_count);

116: WHEN OTHERS THEN
117: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,
118: p_data => l_msg_data);
119:
120: FND_MSG_PUB.DELETE_MSG (l_msg_count);
121: FND_MESSAGE.SET_NAME('IGS','IGS_EN_APPROVED_INVALID');
122: FND_MSG_PUB.ADD;
123: l_valid_params := FALSE;
124: END;

Line 122: FND_MSG_PUB.ADD;

118: p_data => l_msg_data);
119:
120: FND_MSG_PUB.DELETE_MSG (l_msg_count);
121: FND_MESSAGE.SET_NAME('IGS','IGS_EN_APPROVED_INVALID');
122: FND_MSG_PUB.ADD;
123: l_valid_params := FALSE;
124: END;
125: END IF;
126:

Line 132: FND_MSG_PUB.ADD;

128: -- Check whether institution name is upper case or not.
129: IF p_intermiss_rec.institution_name IS NOT NULL THEN
130: IF p_intermiss_rec.institution_name <> UPPER(p_intermiss_rec.institution_name) then
131: FND_MESSAGE.SET_NAME('IGS','IGS_EN_INSTIT_NAME_UCASE');
132: FND_MSG_PUB.ADD;
133: l_valid_params := FALSE;
134: END IF;
135: END IF;
136:

Line 140: FND_MSG_PUB.ADD;

136:
137: IF p_intermiss_rec.COND_RETURN_FLAG IS NOT NULL THEN
138: IF p_intermiss_rec.COND_RETURN_FLAG NOT IN ('Y','N') THEN
139: FND_MESSAGE.SET_NAME('IGS','IGS_EN_RCOND_INV');
140: FND_MSG_PUB.ADD;
141: l_valid_params := FALSE;
142: END IF;
143: END IF;
144:

Line 182: FND_MSG_PUB.ADD;

178: p_attribute20 => p_intermiss_rec.attribute20,
179: p_desc_flex_name => l_desc_flex_name ) THEN
180:
181: FND_MESSAGE.SET_NAME('IGS','IGS_AD_INVALID_DESC_FLEX');
182: FND_MSG_PUB.ADD;
183: l_valid_params := FALSE;
184: END IF;
185: END IF;
186:

Line 217: FND_MSG_PUB.ADD;

213: -- to the calling procedure.
214: l_logical_delete_date := to_date('31-12-4712','DD-MM-YYYY');
215: IF igs_en_stdnt_ps_intm_pkg.get_pk_for_validation ( p_person_id, p_intermiss_rec.program_cd, p_intermiss_rec.start_dt,l_logical_delete_date) THEN
216: FND_MESSAGE.SET_NAME('IGS','IGS_EN_STU_INTM_EXISTS');
217: FND_MSG_PUB.ADD;
218: RETURN 'W';
219: END IF;
220:
221:

Line 225: FND_MSG_PUB.ADD;

221:
222: -- Check for Student Program Attempt existance
223: IF NOT igs_en_stdnt_ps_att_pkg.get_pk_for_validation ( p_person_id, p_intermiss_rec.program_cd ) THEN
224: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PRGM_ATT_NOT_EXIST');
225: FND_MSG_PUB.ADD;
226: l_valid_db_constr := FALSE;
227: END IF;
228:
229: -- Check for intermission type existance

Line 233: FND_MSG_PUB.ADD;

229: -- Check for intermission type existance
230: IF p_intermiss_rec.intermission_type IS NOT NULL THEN
231: IF NOT igs_en_intm_types_pkg.get_uk_for_validation ( p_intermiss_rec.intermission_type ) THEN
232: FND_MESSAGE.SET_NAME('IGS','IGS_EN_INTM_TYP_NOT_EXIST');
233: FND_MSG_PUB.ADD;
234: l_valid_db_constr := FALSE;
235: END IF;
236: END IF;
237:

Line 242: FND_MSG_PUB.ADD;

238: -- Check for institution existance
239: IF p_intermiss_rec.institution_name IS NOT NULL THEN
240: IF NOT igs_en_gen_legacy.check_institution ( p_intermiss_rec.institution_name ) THEN
241: FND_MESSAGE.SET_NAME('IGS','IGS_EN_INST_NOT_EXIST');
242: FND_MSG_PUB.ADD;
243: l_valid_db_constr := FALSE;
244: END IF;
245: END IF;
246:

Line 282: FND_MSG_PUB.ADD;

278: -- Check whether the Start Date is less than or equal to End Date.
279: IF (p_intermiss_rec.start_dt IS NOT NULL) AND (p_intermiss_rec.end_dt IS NOT NULL) THEN
280: IF NOT igs_ad_val_edtl.genp_val_strt_end_dt ( p_intermiss_rec.start_dt, p_intermiss_rec.end_dt, p_message_name ) THEN
281: FND_MESSAGE.SET_NAME('IGS',p_message_name);
282: FND_MSG_PUB.ADD;
283: l_validation_success := FALSE;
284: END IF;
285: END IF;
286:

Line 291: FND_MSG_PUB.ADD;

287: -- Validate the overlap of student course intermission records
288: IF NOT igs_en_val_sci.enrp_val_sci_ovrlp ( p_person_id, p_intermiss_rec.program_cd, p_intermiss_rec.start_dt,
289: p_intermiss_rec.end_dt, p_message_name ) THEN
290: FND_MESSAGE.SET_NAME('IGS',p_message_name);
291: FND_MSG_PUB.ADD;
292: l_validation_success := FALSE;
293: END IF;
294:
295: -- Validate whether Period of intermission overlaps enrolled/completed

Line 300: FND_MSG_PUB.ADD;

296: -- unit attempt teaching period census dates.
297: IF NOT igs_en_gen_legacy.validate_intm_ua_ovrlp ( p_person_id, p_intermiss_rec.program_cd, p_intermiss_rec.start_dt,
298: p_intermiss_rec.end_dt ) THEN
299: FND_MESSAGE.SET_NAME('IGS','IGS_EN_INTM_CANT_OVRLP_UA');
300: FND_MSG_PUB.ADD;
301: l_validation_success := FALSE;
302: END IF;
303:
304: -- Validate whether approval is required for the intermission type.

Line 311: FND_MSG_PUB.ADD;

307: l_result := igs_en_gen_legacy.check_approv_reqd (p_intermiss_rec.intermission_type);
308:
309: IF (l_result = FALSE) AND (p_intermiss_rec.approver_person_number IS NOT NULL) THEN
310: FND_MESSAGE.SET_NAME('IGS','IGS_EN_NOT_SET_APPROV_DET');
311: FND_MSG_PUB.ADD;
312: l_validation_success := FALSE;
313: END IF;
314:
315: END IF;

Line 322: FND_MSG_PUB.ADD;

318: IF p_intermiss_rec.approver_person_number IS NOT NULL THEN
319:
320: IF NOT igs_ad_val_acai.genp_val_staff_prsn (p_approver_id, p_message_name) THEN
321: FND_MESSAGE.SET_NAME('IGS','IGS_EN_APPROV_PERS_STAFF');
322: FND_MSG_PUB.ADD;
323: l_validation_success := FALSE;
324: END IF;
325:
326: -- Check whether Approving person is same as the student being approved.

Line 329: FND_MSG_PUB.ADD;

325:
326: -- Check whether Approving person is same as the student being approved.
327: IF p_intermiss_rec.approver_person_number = p_intermiss_rec.person_number THEN
328: FND_MESSAGE.SET_NAME('IGS','IGS_EN_APPROV_CANT_STU');
329: FND_MSG_PUB.ADD;
330: l_validation_success := FALSE;
331: END IF;
332:
333: END IF;

Line 343: FND_MSG_PUB.ADD;

339: IF p_intermiss_rec.intermission_type IS NOT NULL THEN
340:
341: IF NOT igs_en_gen_legacy.check_study_antr_instu ( p_intermiss_rec.intermission_type ) THEN
342: FND_MESSAGE.SET_NAME('IGS','IGS_EN_CANT_SET_INSTI_DET');
343: FND_MSG_PUB.ADD;
344: l_validation_success := FALSE;
345: END IF;
346:
347: END IF;

Line 409: FND_MSG_PUB.INITIALIZE;

405: END IF;
406:
407: -- If the calling program has passed the parameter for initializing the message list
408: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
409: FND_MSG_PUB.INITIALIZE;
410: END IF;
411:
412: -- Set the return status to success
413: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 434: FND_MSG_PUB.ADD;

430: -- Get the person id for the passed person number.
431: l_person_id := Igs_Ge_Gen_003.get_person_id (p_intermiss_rec.person_number);
432: IF l_person_id IS NULL THEN
433: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_PERSON_NUMBER');
434: FND_MSG_PUB.ADD;
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: l_insert_flag := FALSE;
437: END IF;
438: END IF;

Line 447: FND_MSG_PUB.ADD;

443: IF p_intermiss_rec.approver_person_number IS NOT NULL THEN
444: l_approver_person_id := Igs_Ge_Gen_003.get_person_id (p_intermiss_rec.approver_person_number);
445: IF l_approver_person_id IS NULL THEN
446: FND_MESSAGE.SET_NAME('IGS','IGS_EN_NO_APPROV_PERSON');
447: FND_MSG_PUB.ADD;
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: l_insert_flag := FALSE;
450: END IF;
451: END IF;

Line 625: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

621: IF (FND_API.TO_BOOLEAN(p_commit) AND l_insert_flag ) THEN
622: COMMIT WORK;
623: END IF;
624:
625: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
626: p_data => x_msg_data);
627:
628:
629: EXCEPTION

Line 633: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

629: EXCEPTION
630: WHEN FND_API.G_EXC_ERROR THEN
631: ROLLBACK TO create_en_spi_pub;
632: x_return_status := FND_API.G_RET_STS_ERROR;
633: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
634: p_data => x_msg_data);
635:
636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
637: ROLLBACK TO create_en_spi_pub;

Line 639: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

635:
636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
637: ROLLBACK TO create_en_spi_pub;
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
640: p_data => x_msg_data);
641:
642: WHEN OTHERS THEN
643: ROLLBACK TO create_en_spi_pub;

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

641:
642: WHEN OTHERS THEN
643: ROLLBACK TO create_en_spi_pub;
644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
645: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
646: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,
647: l_api_name);
648: END IF;
649: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

Line 646: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,

642: WHEN OTHERS THEN
643: ROLLBACK TO create_en_spi_pub;
644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
645: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
646: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,
647: l_api_name);
648: END IF;
649: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
650: p_data => x_msg_data);

Line 649: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,

645: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
646: FND_MSG_PUB.ADD_EXC_MSG(g_pkg_name,
647: l_api_name);
648: END IF;
649: FND_MSG_PUB.COUNT_AND_GET( p_count => x_msg_count,
650: p_data => x_msg_data);
651:
652: END create_student_intm;
653: