[Home] [Help]
832:
833: BEGIN
834: --1 to 7 Validates GRADUAND required details.
835: l_message := NULL;
836: IF NOT IGS_GR_VAL_GR.grdp_val_gr_rqrd(
837: p_course_cd => p_lgcy_grd_rec.program_cd,
838: p_graduand_status => p_lgcy_grd_rec.graduand_status,
839: p_s_graduand_type => p_lgcy_grd_rec.s_graduand_type,
840: p_award_course_cd => p_lgcy_grd_rec.award_program_cd,
881: END IF;
882: --End of Validate that the Graduand cannot be graduated unless the graduand approval status has a system value of "APPROVED
883:
884: --11 Validate that if the program award code and program award version number is the same as the program code and version number then validate
885: IF p_lgcy_grd_rec.program_cd IS NOT NULL AND NOT IGS_GR_VAL_GR.grdp_val_aw_eligible(
886: p_person_id => p_person_id,
887: p_course_cd => p_lgcy_grd_rec.program_cd,
888: p_award_course_cd => p_lgcy_grd_rec.award_program_cd ,
889: p_award_crs_version_number => p_lgcy_grd_rec.award_prog_version_number ,
896: END IF;
897: --11 End of Validate that if the program award code and program award version number is the same as the program code and version number then validate
898:
899: --12 Validate that the students are allowed to graduate from the specified program
900: IF NOT IGS_GR_VAL_GR.grdp_val_gr_sca(p_person_id => p_person_id,
901: p_course_cd => p_lgcy_grd_rec.program_cd,
902: p_message_name => l_message) THEN
903: FND_MESSAGE.SET_NAME ('IGS',l_message);
904: FND_MSG_PUB.ADD;
923: END IF;
924: --End of 13, 14 ,15 Validate that the award must be of system award type PROGRAM, HON
925:
926: --16 Validate that the graduand record program award is an award for the student program attempt or an alternative exit
927: IF NOT IGS_GR_VAL_GR.grdp_val_gr_caw
928: (
929: p_person_id => p_person_id,
930: p_course_cd => p_lgcy_grd_rec.program_cd,
931: p_award_course_cd => p_lgcy_grd_rec.award_program_cd,
939: END IF;
940: --End of 16 Validate that the graduand record program award is an award for the student program attempt or an alternative exit
941:
942: --17,18 Validate that a student cannot articulate or surrender a graduand record for the same program.
943: IF NOT IGS_GR_VAL_GR.GRDP_VAL_GR_SUR_CAW(
944: p_person_id => p_person_id ,
945: p_course_cd => p_lgcy_grd_rec.program_cd ,
946: p_graduand_status => p_lgcy_grd_rec.graduand_status ,
947: p_sur_for_course_cd => p_lgcy_grd_rec.sur_for_program_cd ,
995:
996:
997: BEGIN
998:
999: IF NOT igs_gr_val_gr.grdp_val_gr_unique(
1000: p_person_id => p_person_id,
1001: p_create_dt => p_lgcy_grd_rec.create_dt,
1002: p_grd_cal_type => p_cal_type,
1003: p_grd_ci_sequence_num => p_sequence_number,