APPS.IGS_AS_SUARC_LGCY_PUB dependencies on IGS_EN_SU_ATTEMPT_PKG

Line 92: igs_en_su_attempt_pkg.check_constraints(

88: END IF;
89: -- If Program Code is specified , it should be in Upper Case.
90: IF p_suarc_dtls_rec.program_cd IS NOT NULL THEN
91: BEGIN
92: igs_en_su_attempt_pkg.check_constraints(
93: column_name => 'COURSE_CD' ,
94: column_value => p_suarc_dtls_rec.program_cd );
95: EXCEPTION
96: WHEN OTHERS THEN

Line 108: igs_en_su_attempt_pkg.check_constraints(

104: END IF;
105: -- If Applied Program Code is specified , it should be in Upper Case.
106: IF p_suarc_dtls_rec.program_cd IS NOT NULL THEN
107: BEGIN
108: igs_en_su_attempt_pkg.check_constraints(
109: column_name => 'COURSE_CD' ,
110: column_value => p_suarc_dtls_rec.applied_program_cd );
111: EXCEPTION
112: WHEN OTHERS THEN

Line 124: igs_en_su_attempt_pkg.check_constraints(

120: END IF;
121: -- If Unit Code is specified , it should be in Upper Case.
122: IF p_suarc_dtls_rec.unit_cd IS NOT NULL THEN
123: BEGIN
124: igs_en_su_attempt_pkg.check_constraints(
125: column_name => 'UNIT_CD' ,
126: column_value => p_suarc_dtls_rec.unit_cd );
127: EXCEPTION
128: WHEN OTHERS THEN

Line 140: igs_en_su_attempt_pkg.check_constraints(

136: END IF;
137: -- If Location Code is specified , it should be in Upper Case.
138: IF p_suarc_dtls_rec.location_cd IS NOT NULL THEN
139: BEGIN
140: igs_en_su_attempt_pkg.check_constraints(
141: column_name => 'LOCATION_CD' ,
142: column_value => p_suarc_dtls_rec.location_cd );
143: EXCEPTION
144: WHEN OTHERS THEN

Line 156: igs_en_su_attempt_pkg.check_constraints(

152: END IF;
153: -- If Unit class is specified , it should be in Upper Case.
154: IF p_suarc_dtls_rec.unit_class IS NOT NULL THEN
155: BEGIN
156: igs_en_su_attempt_pkg.check_constraints(
157: column_name => 'UNIT_CLASS' ,
158: column_value => p_suarc_dtls_rec.unit_class );
159: EXCEPTION
160: WHEN OTHERS THEN

Line 240: IF NOT igs_en_su_attempt_pkg.get_pk_for_validation (

236: g_suarc_status := 'INVALID';
237: END IF;
238:
239: -- Foreign Key Validation - Check if Student Unit Attempt exists.
240: IF NOT igs_en_su_attempt_pkg.get_pk_for_validation (
241: x_person_id => p_person_id,
242: x_course_cd => p_suarc_dtls_rec.program_cd,
243: x_uoo_id => p_uoo_id) THEN
244: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_FI_PRSNID_PRGCD_NOT_MATCH');