eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_SUA_LGCY_PUB dependencies on IGS_EN_SU_ATTEMPT_PKG

Line 97: igs_en_su_attempt_pkg.check_constraints(

93:
94: -- If Program Code is specified , it should be in Upper Case.
95: IF p_sua_dtls_rec.program_cd IS NOT NULL THEN
96: BEGIN
97: igs_en_su_attempt_pkg.check_constraints(
98: column_name => 'COURSE_CD' ,
99: column_value => p_sua_dtls_rec.program_cd );
100:
101: EXCEPTION

Line 115: igs_en_su_attempt_pkg.check_constraints(

111:
112: -- If Unit Code is specified , it should be in Upper Case.
113: IF p_sua_dtls_rec.unit_cd IS NOT NULL THEN
114: BEGIN
115: igs_en_su_attempt_pkg.check_constraints(
116: column_name => 'UNIT_CD' ,
117: column_value => p_sua_dtls_rec.unit_cd );
118: EXCEPTION
119: WHEN OTHERS THEN

Line 132: igs_en_su_attempt_pkg.check_constraints(

128:
129: -- If Location Code is specified , it should be in Upper Case.
130: IF p_sua_dtls_rec.location_cd IS NOT NULL THEN
131: BEGIN
132: igs_en_su_attempt_pkg.check_constraints(
133: column_name => 'LOCATION_CD' ,
134: column_value => p_sua_dtls_rec.location_cd );
135: EXCEPTION
136: WHEN OTHERS THEN

Line 149: igs_en_su_attempt_pkg.check_constraints(

145:
146: -- If Unit class is specified , it should be in Upper Case.
147: IF p_sua_dtls_rec.unit_class IS NOT NULL THEN
148: BEGIN
149: igs_en_su_attempt_pkg.check_constraints(
150: column_name => 'UNIT_CLASS' ,
151: column_value => p_sua_dtls_rec.unit_class );
152: EXCEPTION
153: WHEN OTHERS THEN

Line 172: igs_en_su_attempt_pkg.check_constraints(

168:
169: -- If Discontinuation Reason Code is specified , it should be in Upper Case.
170: IF p_sua_dtls_rec.dcnt_reason_cd IS NOT NULL THEN
171: BEGIN
172: igs_en_su_attempt_pkg.check_constraints(
173: column_name => 'DCNT_REASON_CD' ,
174: column_value => p_sua_dtls_rec.dcnt_reason_cd );
175: EXCEPTION
176: WHEN OTHERS THEN

Line 189: igs_en_su_attempt_pkg.check_constraints(

185:
186: -- If Assesment Indicator is specified , Permitted values are 'Y' or 'N'.
187: IF p_sua_dtls_rec.no_assessment_ind IS NOT NULL THEN
188: BEGIN
189: igs_en_su_attempt_pkg.check_constraints(
190: column_name => 'NO_ASSESSMENT_IND' ,
191: column_value => p_sua_dtls_rec.no_assessment_ind );
192: EXCEPTION
193: WHEN OTHERS THEN

Line 207: igs_en_su_attempt_pkg.check_constraints(

203: -- If Override Enrolled Credit Points are specified, it must be between 0 and 999.999.
204: IF p_sua_dtls_rec.override_enrolled_cp IS NOT NULL THEN
205: BEGIN
206:
207: igs_en_su_attempt_pkg.check_constraints(
208: column_name => 'OVERRIDE_ENROLLED_CP' ,
209: column_value => igs_ge_number.to_cann(p_sua_dtls_rec.override_enrolled_cp ));
210: EXCEPTION
211: WHEN OTHERS THEN

Line 224: igs_en_su_attempt_pkg.check_constraints(

220:
221: -- If Override Enrolled Achievable Points are specified, it must be between 0 and 999.999.
222: IF p_sua_dtls_rec.override_achievable_cp IS NOT NULL THEN
223: BEGIN
224: igs_en_su_attempt_pkg.check_constraints(
225: column_name => 'OVERRIDE_ACHIEVABLE_CP' ,
226: column_value => igs_ge_number.to_cann(p_sua_dtls_rec.override_achievable_cp ));
227:
228: EXCEPTION

Line 399: knaraset 19-Jun-2003 Added unique key validation igs_en_su_attempt_pkg.Get_Uk_For_Validation, as part of bug 2956146

395: enhancements,
396: remarks :
397: Change History
398: Who When What
399: knaraset 19-Jun-2003 Added unique key validation igs_en_su_attempt_pkg.Get_Uk_For_Validation, as part of bug 2956146
400: kkillams 29-04-2003 Impacted object, due to change in the signature of the igs_en_su_attempt_pkg.get_pk_for_validation function
401: w.r.t. bug number 2829262
402: rvangala 02-OCT-2003 Added validation to check value of core_indicator, added as part of Prevent Dropping Core Units. Enh Bug# 3052432
403: amuthu 29-JUL-2004 Added validation for Administrative unit status, to call

Line 400: kkillams 29-04-2003 Impacted object, due to change in the signature of the igs_en_su_attempt_pkg.get_pk_for_validation function

396: remarks :
397: Change History
398: Who When What
399: knaraset 19-Jun-2003 Added unique key validation igs_en_su_attempt_pkg.Get_Uk_For_Validation, as part of bug 2956146
400: kkillams 29-04-2003 Impacted object, due to change in the signature of the igs_en_su_attempt_pkg.get_pk_for_validation function
401: w.r.t. bug number 2829262
402: rvangala 02-OCT-2003 Added validation to check value of core_indicator, added as part of Prevent Dropping Core Units. Enh Bug# 3052432
403: amuthu 29-JUL-2004 Added validation for Administrative unit status, to call
404: the IGS_AD_ADM_UNIT_STAT_PKG.Get_PK_For_Validation, to

Line 410: IF igs_en_su_attempt_pkg.get_pk_for_validation (

406: -----------------------------------------------------------------------------*/
407: l_indicator BOOLEAN := false;
408: BEGIN
409: -- Primary Key validation
410: IF igs_en_su_attempt_pkg.get_pk_for_validation (
411: p_person_id ,
412: p_sua_dtls_rec.program_cd,
413: p_uoo_id) THEN
414: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_EN_UNT_ATMPT_EXTS');

Line 420: IF igs_en_su_attempt_pkg.Get_Uk_For_Validation (

416: g_sua_status := 'WARNING';
417: RETURN;
418: END IF ;
419: -- Unique Key validation
420: IF igs_en_su_attempt_pkg.Get_Uk_For_Validation (
421: x_person_id => p_person_id ,
422: x_course_cd => p_sua_dtls_rec.program_cd,
423: x_unit_cd => p_sua_dtls_rec.unit_cd,
424: x_cal_type => p_cal_type,