APPS.IGS_EN_SPAT_LGCY_PUB dependencies on IGS_EN_STDNT_PS_ATT_PKG

Line 136: igs_en_stdnt_ps_att_pkg.check_constraints(

132: END IF;
133:
134: IF p_spat_rec.program_cd IS NOT NULL THEN
135: BEGIN
136: igs_en_stdnt_ps_att_pkg.check_constraints(
137: column_name => 'COURSE_CD',
138: column_value => p_spat_rec.program_cd);
139: EXCEPTION
140: WHEN OTHERS THEN

Line 151: igs_en_stdnt_ps_att_pkg.check_constraints(

147: END IF;
148:
149: IF p_spat_rec.acad_cal_type IS NOT NULL THEN
150: BEGIN
151: igs_en_stdnt_ps_att_pkg.check_constraints(
152: column_name => 'CAL_TYPE',
153: column_value => p_spat_rec.acad_cal_type);
154: EXCEPTION
155: WHEN OTHERS THEN

Line 166: igs_en_stdnt_ps_att_pkg.check_constraints(

162: END IF;
163:
164: IF p_spat_rec.location_cd IS NOT NULL THEN
165: BEGIN
166: igs_en_stdnt_ps_att_pkg.check_constraints(
167: column_name => 'LOCATION_CD',
168: column_value => p_spat_rec.location_cd);
169: EXCEPTION
170: WHEN OTHERS THEN

Line 181: igs_en_stdnt_ps_att_pkg.check_constraints (

177: END IF;
178:
179: IF p_spat_rec.attendance_mode IS NOT NULL THEN
180: BEGIN
181: igs_en_stdnt_ps_att_pkg.check_constraints (
182: column_name => 'ATTENDANCE_MODE',
183: column_value => p_spat_rec.attendance_mode);
184: EXCEPTION
185: WHEN OTHERS THEN

Line 196: igs_en_stdnt_ps_att_pkg.check_constraints(

192: END IF;
193:
194: IF p_spat_rec.attendance_type IS NOT NULL THEN
195: BEGIN
196: igs_en_stdnt_ps_att_pkg.check_constraints(
197: column_name => 'ATTENDANCE_TYPE',
198: column_value => p_spat_rec.attendance_type);
199: EXCEPTION
200: WHEN OTHERS THEN

Line 211: igs_en_stdnt_ps_att_pkg.check_constraints(

207: END IF;
208:
209: IF p_spat_rec.key_program_flag IS NOT NULL THEN
210: BEGIN
211: igs_en_stdnt_ps_att_pkg.check_constraints(
212: column_name => 'KEY_PROGRAM',
213: column_value => p_spat_rec.key_program_flag);
214: EXCEPTION
215: WHEN OTHERS THEN

Line 258: l_get_pk_for_validation_return := igs_en_stdnt_ps_att_pkg.get_pk_for_validation(

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(
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');