APPS.IGS_HE_SPA_LGCY_PUB dependencies on IGS_EN_HESA_PKG

Line 233: IF NOT igs_en_hesa_pkg.validate_program_aim (p_award_cd => p_hesa_spa_stats_rec.student_qual_aim) THEN

229: END IF;
230: END IF;
231: -- Check whether the Student Qualification Aim exists
232: IF p_hesa_spa_stats_rec.student_qual_aim IS NOT NULL THEN
233: IF NOT igs_en_hesa_pkg.validate_program_aim (p_award_cd => p_hesa_spa_stats_rec.student_qual_aim) THEN
234: FND_MESSAGE.SET_NAME('IGS','IGS_HE_STD_PRG_AIM_NEX');
235: FND_MSG_PUB.ADD;
236: l_db_val_failed := TRUE;
237: END IF;

Line 241: IF NOT igs_en_hesa_pkg.validate_program_aim (p_award_cd => p_hesa_spa_stats_rec.student_fe_qual_aim) THEN

237: END IF;
238: END IF;
239: -- Check whether the Student FE Qualification Aim exists
240: IF p_hesa_spa_stats_rec.student_fe_qual_aim IS NOT NULL THEN
241: IF NOT igs_en_hesa_pkg.validate_program_aim (p_award_cd => p_hesa_spa_stats_rec.student_fe_qual_aim) THEN
242: FND_MESSAGE.SET_NAME('IGS','IGS_HE_STD_FE_PRG_AIM_NEX');
243: FND_MSG_PUB.ADD;
244: l_db_val_failed := TRUE;
245: END IF;

Line 503: IF NOT igs_en_hesa_pkg.val_sub_qual_proportion (

499:
500: l_br_val_failed BOOLEAN := FALSE;
501: BEGIN
502: -- validate whether the specified combination of subj_qualaim's and qualaim_proportion is valid
503: IF NOT igs_en_hesa_pkg.val_sub_qual_proportion (
504: p_subj_qualaim1 => p_hesa_spa_stats_rec.subj_qualaim1,
505: p_subj_qualaim2 => p_hesa_spa_stats_rec.subj_qualaim2,
506: p_subj_qualaim3 => p_hesa_spa_stats_rec.subj_qualaim3,
507: p_qualaim_proportion => p_hesa_spa_stats_rec.qualaim_proportion) THEN

Line 514: IF NOT igs_en_hesa_pkg.val_highest_qual_entry (p_highest_qual_on_entry => p_hesa_spa_stats_rec.highest_qual_on_entry) THEN

510: END IF;
511:
512: -- Validate whether the given highest qual on entry is exists against the
513: -- grading schema defined for HESA code HESA_HIGH_QUAL_ON_ENT.
514: IF NOT igs_en_hesa_pkg.val_highest_qual_entry (p_highest_qual_on_entry => p_hesa_spa_stats_rec.highest_qual_on_entry) THEN
515: FND_MESSAGE.SET_NAME('IGS','IGS_HE_QUAL_ENTRY_NEX');
516: FND_MSG_PUB.ADD;
517: l_br_val_failed := TRUE;
518: END IF;