[Home] [Help]
261: l_ret_value VARCHAR2(1) := 'S';
262: BEGIN
263:
264: -- Check for duplicate student unit set attempt
265: IF igs_en_gen_legacy.check_dup_susa (p_person_id => p_person_id,
266: p_program_cd => p_susa_rec.program_cd,
267: p_unit_set_cd => p_susa_rec.unit_set_cd,
268: p_us_version_number => p_susa_rec.us_version_number,
269: p_selection_dt => p_susa_rec.selection_dt) THEN
329: || Known limitations, enhancements or remarks :
330: || Change History :
331: || Who When What
332: || bdeviset 29-JUL-2004 Added parameters p_end_dt,p_sequence_number
333: || for call to Function igs_en_gen_legacy.check_usa_overlap
334: || as it is modified for bug 3149133
335: ------------------------------------------------------------------------------*/
336:
337: l_validation_success BOOLEAN := TRUE;
543: END IF;
544:
545: -- Check the condition that unit sets with category of 'pre-enrollment year' cannot be
546: -- inserted unless profile option is set
547: IF NOT igs_en_gen_legacy.check_pre_enroll_prof (p_unit_set_cd => p_susa_rec.unit_set_cd,
548: p_us_version_number => p_susa_rec.us_version_number) THEN
549:
550: -- Add excep to stack
551: FND_MESSAGE.SET_NAME('IGS','IGS_EN_CANT_ADD_PRENRL_US');
558:
559: -- Check the condition that unit sets with category of 'pre-enrollment year' cannot
560: -- overlap selection/completion dates
561: l_message_name := NULL;
562: IF NOT igs_en_gen_legacy.check_usa_overlap (p_person_id => p_person_id,
563: p_program_cd => p_susa_rec.program_cd,
564: p_selection_dt => p_susa_rec.selection_dt,
565: p_rqrmnts_complete_dt => p_susa_rec.rqrmnts_complete_dt,
566: p_end_dt => p_susa_rec.end_dt,