APPS.IGS_EN_SPI_LGCY_PUB dependencies on IGS_EN_STDNT_PS_INTM_PKG

Line 56: igs_en_stdnt_ps_intm_pkg.check_constraints ('COURSE_CD', p_intermiss_rec.program_cd);

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);
57: EXCEPTION
58: WHEN OTHERS THEN
59: FND_MSG_PUB.COUNT_AND_GET( p_count => l_msg_count,
60: p_data => l_msg_data);

Line 89: igs_en_stdnt_ps_intm_pkg.check_constraints ('VOLUNTARY_IND', p_intermiss_rec.voluntary_ind);

85:
86: -- Check whether voluntary_ind is having any other value other than 'Y'/'N'
87: IF p_intermiss_rec.voluntary_ind IS NOT NULL THEN
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);

Line 114: igs_en_stdnt_ps_intm_pkg.check_constraints ('APPROVED', p_intermiss_rec.approved);

110:
111: -- Check whether approved field is having any other value other than 'Y'/'N'
112: IF p_intermiss_rec.approved IS NOT NULL THEN
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);

Line 204: igs_en_stdnt_ps_intm_pkg.get_pk_for_validation.

200: Known limitations,enhancements,remarks:
201: Change History
202: Who When What
203: bdeviset 13-SEP-2004 Bug no 3885804.Added parameter logical_delete_date in the call
204: igs_en_stdnt_ps_intm_pkg.get_pk_for_validation.
205: ***********************************************************************************************/
206:
207: l_valid_db_constr BOOLEAN := TRUE;
208: l_logical_delete_date igs_en_stdnt_ps_intm.logical_delete_date%TYPE;

Line 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

211:
212: -- Check for primary Key validation. If validation fails, stop the processing and return back
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;