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_SPA_LGCY_PUB dependencies on IGS_EN_STDNT_PS_ATT_PKG

Line 112: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'COURSE_CD',

108:
109: --Do check constraints validation.
110: IF p_sca_re_rec.program_cd IS NOT NULL THEN
111: BEGIN
112: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'COURSE_CD',
113: column_value => p_sca_re_rec.program_cd);
114: EXCEPTION
115: WHEN OTHERS THEN
116: l_message_count := FND_MSG_PUB.COUNT_MSG;

Line 126: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'CAL_TYPE',

122: END IF;
123:
124: IF p_sca_re_rec.cal_type IS NOT NULL THEN
125: BEGIN
126: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'CAL_TYPE',
127: column_value => p_sca_re_rec.cal_type);
128: EXCEPTION
129: WHEN OTHERS THEN
130: l_message_count := FND_MSG_PUB.COUNT_MSG;

Line 140: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'LOCATION_CD',

136: END IF;
137:
138: IF p_sca_re_rec.location_cd IS NOT NULL THEN
139: BEGIN
140: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'LOCATION_CD',
141: column_value => p_sca_re_rec.location_cd);
142: EXCEPTION
143: WHEN OTHERS THEN
144: l_message_count := FND_MSG_PUB.COUNT_MSG;

Line 154: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'ATTENDANCE_MODE',

150: END IF;
151:
152: IF p_sca_re_rec.attendance_mode IS NOT NULL THEN
153: BEGIN
154: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'ATTENDANCE_MODE',
155: column_value => p_sca_re_rec.attendance_mode);
156: EXCEPTION
157: WHEN OTHERS THEN
158: l_message_count := FND_MSG_PUB.COUNT_MSG;

Line 168: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'ATTENDANCE_TYPE',

164: END IF;
165:
166: IF p_sca_re_rec.attendance_type IS NOT NULL THEN
167: BEGIN
168: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'ATTENDANCE_TYPE',
169: column_value => p_sca_re_rec.attendance_type);
170: EXCEPTION
171: WHEN OTHERS THEN
172: l_message_count := FND_MSG_PUB.COUNT_MSG;

Line 182: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'STUDENT_CONFIRMED_IND',

178: END IF;
179:
180: IF p_sca_re_rec.student_confirmed_ind IS NOT NULL THEN
181: BEGIN
182: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'STUDENT_CONFIRMED_IND',
183: column_value => p_sca_re_rec.student_confirmed_ind);
184: EXCEPTION
185: WHEN OTHERS THEN
186: l_message_count := FND_MSG_PUB.COUNT_MSG;

Line 197: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'PRIMARY_PROGRAM_TYPE',

193:
194: IF p_career_flag = 'Y' THEN
195: IF p_sca_re_rec.primary_program_type IS NOT NULL THEN
196: BEGIN
197: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'PRIMARY_PROGRAM_TYPE',
198: column_value => p_sca_re_rec.primary_program_type);
199: EXCEPTION
200: WHEN OTHERS THEN
201: l_message_count := FND_MSG_PUB.COUNT_MSG;

Line 210: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'PRIMARY_PROG_TYPE_SOURCE',

206: END;
207: END IF;
208: IF p_sca_re_rec.primary_prog_type_source IS NOT NULL THEN
209: BEGIN
210: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'PRIMARY_PROG_TYPE_SOURCE',
211: column_value => p_sca_re_rec.primary_prog_type_source);
212: EXCEPTION
213: WHEN OTHERS THEN
214: l_message_count := FND_MSG_PUB.COUNT_MSG;

Line 224: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'KEY_PROGRAM',

220: END IF;
221: END IF; --p_career_flag
222: IF p_sca_re_rec.key_program IS NOT NULL THEN
223: BEGIN
224: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'KEY_PROGRAM',
225: column_value => p_sca_re_rec.key_program);
226: EXCEPTION
227: WHEN OTHERS THEN
228: l_message_count := FND_MSG_PUB.COUNT_MSG;

Line 238: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'PROVISIONAL_IND',

234: END IF;
235:
236: IF p_sca_re_rec.provisional_ind IS NOT NULL THEN
237: BEGIN
238: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'PROVISIONAL_IND',
239: column_value => p_sca_re_rec.provisional_ind);
240: EXCEPTION
241: WHEN OTHERS THEN
242: l_message_count := FND_MSG_PUB.COUNT_MSG;

Line 252: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'DISCONTINUATION_REASON_CD',

248: END IF;
249:
250: IF p_sca_re_rec.discontinuation_reason_cd IS NOT NULL THEN
251: BEGIN
252: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'DISCONTINUATION_REASON_CD',
253: column_value => p_sca_re_rec.discontinuation_reason_cd);
254: EXCEPTION
255: WHEN OTHERS THEN
256: l_message_count := FND_MSG_PUB.COUNT_MSG;

Line 266: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'FUNDING_SOURCE',

262: END IF;
263:
264: IF p_sca_re_rec.funding_source IS NOT NULL THEN
265: BEGIN
266: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'FUNDING_SOURCE',
267: column_value => p_sca_re_rec.funding_source);
268: EXCEPTION
269: WHEN OTHERS THEN
270: l_message_count := FND_MSG_PUB.COUNT_MSG;

Line 280: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'EXAM_LOCATION_CD',

276: END IF;
277:
278: IF p_sca_re_rec.exam_location_cd IS NOT NULL THEN
279: BEGIN
280: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'EXAM_LOCATION_CD',
281: column_value => p_sca_re_rec.exam_location_cd);
282: EXCEPTION
283: WHEN OTHERS THEN
284: l_message_count := FND_MSG_PUB.COUNT_MSG;

Line 294: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'NOMINATED_COMPLETION_YR',

290: END IF;
291:
292: IF p_sca_re_rec.nominated_completion_yr IS NOT NULL THEN
293: BEGIN
294: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'NOMINATED_COMPLETION_YR',
295: column_value => igs_ge_number.to_cann(p_sca_re_rec.nominated_completion_yr));
296: EXCEPTION
297: WHEN OTHERS THEN
298: l_message_count := FND_MSG_PUB.COUNT_MSG;

Line 308: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'NOMINATED_COMPLETION_PERD',

304: END IF;
305:
306: IF p_sca_re_rec.nominated_completion_perd IS NOT NULL THEN
307: BEGIN
308: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'NOMINATED_COMPLETION_PERD',
309: column_value => p_sca_re_rec.nominated_completion_perd);
310: EXCEPTION
311: WHEN OTHERS THEN
312: l_message_count := FND_MSG_PUB.COUNT_MSG;

Line 322: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'RULE_CHECK_IND',

318: END IF;
319:
320: IF p_sca_re_rec.rule_check_ind IS NOT NULL THEN
321: BEGIN
322: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'RULE_CHECK_IND',
323: column_value => p_sca_re_rec.rule_check_ind);
324: EXCEPTION
325: WHEN OTHERS THEN
326: l_message_count := FND_MSG_PUB.COUNT_MSG;

Line 336: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'WAIVE_OPTION_CHECK_IND',

332: END IF;
333:
334: IF p_sca_re_rec.waive_option_check_ind IS NOT NULL THEN
335: BEGIN
336: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'WAIVE_OPTION_CHECK_IND',
337: column_value => p_sca_re_rec.waive_option_check_ind);
338: EXCEPTION
339: WHEN OTHERS THEN
340: l_message_count := FND_MSG_PUB.COUNT_MSG;

Line 350: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'PUBLISH_OUTCOMES_IND',

346: END IF;
347:
348: IF p_sca_re_rec.publish_outcomes_ind IS NOT NULL THEN
349: BEGIN
350: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'PUBLISH_OUTCOMES_IND',
351: column_value => p_sca_re_rec.publish_outcomes_ind);
352: EXCEPTION
353: WHEN OTHERS THEN
354: l_message_count := FND_MSG_PUB.COUNT_MSG;

Line 364: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'COURSE_RQRMNT_COMPLETE_IND',

360: END IF;
361:
362: IF p_sca_re_rec.course_rqrmnt_complete_ind IS NOT NULL THEN
363: BEGIN
364: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'COURSE_RQRMNT_COMPLETE_IND',
365: column_value => p_sca_re_rec.course_rqrmnt_complete_ind);
366: EXCEPTION
367: WHEN OTHERS THEN
368: l_message_count := FND_MSG_PUB.COUNT_MSG;

Line 378: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'S_COMPLETED_SOURCE_TYPE',

374: END IF;
375:
376: IF p_sca_re_rec.s_completed_source_type IS NOT NULL THEN
377: BEGIN
378: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'S_COMPLETED_SOURCE_TYPE',
379: column_value => p_sca_re_rec.s_completed_source_type);
380: EXCEPTION
381: WHEN OTHERS THEN
382: l_message_count := FND_MSG_PUB.COUNT_MSG;

Line 392: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'CORRESPONDENCE_CAT',

388: END IF;
389:
390: IF p_sca_re_rec.correspondence_cat IS NOT NULL THEN
391: BEGIN
392: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'CORRESPONDENCE_CAT',
393: column_value => p_sca_re_rec.correspondence_cat);
394: EXCEPTION
395: WHEN OTHERS THEN
396: l_message_count := FND_MSG_PUB.COUNT_MSG;

Line 406: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'SELF_HELP_GROUP_IND',

402: END IF;
403:
404: IF p_sca_re_rec.self_help_group_ind IS NOT NULL THEN
405: BEGIN
406: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'SELF_HELP_GROUP_IND',
407: column_value => p_sca_re_rec.self_help_group_ind);
408: EXCEPTION
409: WHEN OTHERS THEN
410: l_message_count := FND_MSG_PUB.COUNT_MSG;

Line 420: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'ADM_NOMINATED_COURSE_CD',

416: END IF;
417:
418: IF p_sca_re_rec.adm_nominated_course_cd IS NOT NULL THEN
419: BEGIN
420: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'ADM_NOMINATED_COURSE_CD',
421: column_value => p_sca_re_rec.adm_nominated_course_cd);
422: EXCEPTION
423: WHEN OTHERS THEN
424: l_message_count := FND_MSG_PUB.COUNT_MSG;

Line 434: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'MANUAL_OVR_CMPL_DT_IND',

430: END IF;
431:
432: IF p_sca_re_rec.manual_ovr_cmpl_dt_ind IS NOT NULL THEN
433: BEGIN
434: igs_en_stdnt_ps_att_pkg.check_constraints(column_name => 'MANUAL_OVR_CMPL_DT_IND',
435: column_value => p_sca_re_rec.manual_ovr_cmpl_dt_ind);
436: EXCEPTION
437: WHEN OTHERS THEN
438: l_message_count := FND_MSG_PUB.COUNT_MSG;

Line 502: IF igs_en_stdnt_ps_att_pkg.get_pk_for_validation(x_person_id =>p_person_id,

498: l_result_flag := 'S';
499:
500: --Check whether student program attemt record is already exist in the database or not.
501: --If exist set the warning message and terminate the function
502: IF igs_en_stdnt_ps_att_pkg.get_pk_for_validation(x_person_id =>p_person_id,
503: x_course_cd =>p_sca_re_rec.program_cd) THEN
504: FND_MESSAGE.SET_NAME('IGS','IGS_EN_PS_ATT_EXISTS');
505: FND_MSG_PUB.ADD;
506: RETURN 'P';