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_PS_STDNT_APV_ALT_PKG dependencies on APP_EXCEPTION

Line 48: App_Exception.Raise_Exception;

44: IF (cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT','VALIDATE_INSERT')) THEN
45: Close cur_old_ref_values;
46: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
47: IGS_GE_MSG_STACK.ADD;
48: App_Exception.Raise_Exception;
49: Return;
50: END IF;
51: Close cur_old_ref_values;
52:

Line 97: App_Exception.Raise_Exception;

93: new_references.course_cd,
94: v_message_name) = FALSE THEN
95: Fnd_Message.Set_Name('IGS', v_message_name);
96: IGS_GE_MSG_STACK.ADD;
97: App_Exception.Raise_Exception;
98: END IF;
99: -- Validate that no IGS_PS_UNIT sets are incomplete or un-ended.
100: IF IGS_PR_VAL_SCA.prgp_val_susa_cmplt (
101: new_references.person_id,

Line 106: App_Exception.Raise_Exception;

102: new_references.course_cd,
103: v_message_name) = FALSE THEN
104: Fnd_Message.Set_Name('IGS', v_message_name);
105: IGS_GE_MSG_STACK.ADD;
106: App_Exception.Raise_Exception;
107: END IF;
108: -- Validate that SCA status is not DISCONTIN, INTERMIT or LAPSED.
109: IF IGS_PR_VAL_SCAAE.prgp_val_sca_cmplt (
110: new_references.person_id,

Line 115: App_Exception.Raise_Exception;

111: new_references.course_cd,
112: v_message_name) = FALSE THEN
113: Fnd_Message.Set_Name('IGS', v_message_name);
114: IGS_GE_MSG_STACK.ADD;
115: App_Exception.Raise_Exception;
116: END IF;
117: ELSE
118: -- Check that associated IGS_GR_GRADUAND record does not have a status
119: -- of 'GRADUATED' or 'SURRENDER'.

Line 129: App_Exception.Raise_Exception;

125: new_references.exit_version_number,
126: v_message_name) = FALSE THEN
127: Fnd_Message.Set_Name('IGS', v_message_name);
128: IGS_GE_MSG_STACK.ADD;
129: App_Exception.Raise_Exception;
130: END IF;
131: END IF;
132: END IF;
133: -- Validate completion details

Line 148: App_Exception.Raise_Exception;

144: new_references.rqrmnts_complete_dt,
145: v_message_name) = FALSE THEN
146: Fnd_Message.Set_Name('IGS', v_message_name);
147: IGS_GE_MSG_STACK.ADD;
148: App_Exception.Raise_Exception;
149: END IF;
150: END IF;
151: END IF;
152: END IF;

Line 181: App_Exception.Raise_Exception;

177: column_name is null Then
178: IF new_references.course_cd <> UPPER(new_references.course_cd) Then
179: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
180: IGS_GE_MSG_STACK.ADD;
181: App_Exception.Raise_Exception;
182: END IF;
183: END IF;
184:
185: IF upper(column_name) = 'EXIT_COURSE_CD' OR

Line 190: App_Exception.Raise_Exception;

186: column_name is null Then
187: IF new_references.exit_course_cd <> UPPER(new_references.exit_course_cd) Then
188: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
189: IGS_GE_MSG_STACK.ADD;
190: App_Exception.Raise_Exception;
191: END IF;
192: END IF;
193:
194: IF upper(column_name) = 'S_COMPLETED_SOURCE_TYPE' OR

Line 199: App_Exception.Raise_Exception;

195: column_name is null Then
196: IF new_references.s_completed_source_type NOT IN ( 'SYSTEM' , 'MANUAL' ) Then
197: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
198: IGS_GE_MSG_STACK.ADD;
199: App_Exception.Raise_Exception;
200: END IF;
201: END IF;
202:
203: IF upper(column_name) = 'RQRMNTS_COMPLETE_IND' OR

Line 208: App_Exception.Raise_Exception;

204: column_name is null Then
205: IF new_references.rqrmnts_complete_ind NOT IN ( 'Y' , 'N' ) Then
206: Fnd_Message.Set_Name ('IGS', 'IGS_GE_INVALID_VALUE');
207: IGS_GE_MSG_STACK.ADD;
208: App_Exception.Raise_Exception;
209: END IF;
210: END IF;
211:
212: END check_constraints;

Line 233: App_Exception.Raise_Exception;

229: new_references.exit_course_cd
230: ) THEN
231: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
232: IGS_GE_MSG_STACK.ADD;
233: App_Exception.Raise_Exception;
234: END IF;
235: END IF;
236:
237: IF (((old_references.exit_course_cd = new_references.exit_course_cd) AND

Line 249: App_Exception.Raise_Exception;

245: new_references.exit_version_number
246: ) THEN
247: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
248: IGS_GE_MSG_STACK.ADD;
249: App_Exception.Raise_Exception;
250: END IF;
251: END IF;
252:
253: IF (((old_references.course_cd = new_references.course_cd) AND

Line 265: App_Exception.Raise_Exception;

261: new_references.version_number
262: ) THEN
263: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
264: IGS_GE_MSG_STACK.ADD;
265: App_Exception.Raise_Exception;
266: END IF;
267: END IF;
268:
269: IF (((old_references.person_id = new_references.person_id) AND

Line 281: App_Exception.Raise_Exception;

277: new_references.course_cd
278: ) THEN
279: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
280: IGS_GE_MSG_STACK.ADD;
281: App_Exception.Raise_Exception;
282: END IF;
283: END IF;
284: END Check_Parent_Existance;
285:

Line 340: App_Exception.Raise_Exception;

336: IF (cur_rowid%FOUND) THEN
337: Close cur_rowid;
338: Fnd_Message.Set_Name ('IGS', 'IGS_PS_SCAAE_AE_FK');
339: IGS_GE_MSG_STACK.ADD;
340: App_Exception.Raise_Exception;
341: Return;
342: END IF;
343: Close cur_rowid;
344:

Line 370: App_Exception.Raise_Exception;

366: IF (cur_rowid%FOUND) THEN
367: Close cur_rowid;
368: Fnd_Message.Set_Name ('IGS', 'IGS_PS_SCAAE_CRV_EXIT_FK');
369: IGS_GE_MSG_STACK.ADD;
370: App_Exception.Raise_Exception;
371: Return;
372: END IF;
373: Close cur_rowid;
374:

Line 399: App_Exception.Raise_Exception;

395: IF (cur_rowid%FOUND) THEN
396: Close cur_rowid;
397: Fnd_Message.Set_Name ('IGS', 'IGS_PS_SCAAE_SCA_FK');
398: IGS_GE_MSG_STACK.ADD;
399: App_Exception.Raise_Exception;
400: Return;
401: END IF;
402: Close cur_rowid;
403:

Line 454: App_Exception.Raise_Exception;

450: new_references.exit_version_number
451: ) THEN
452: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
453: IGS_GE_MSG_STACK.ADD;
454: App_Exception.Raise_Exception;
455: END IF;
456: Check_Constraints;
457: Check_Parent_Existance;
458: ELSIF (p_action = 'UPDATE') THEN

Line 472: App_Exception.Raise_Exception;

468: new_references.exit_version_number
469: ) THEN
470: Fnd_Message.Set_Name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
471: IGS_GE_MSG_STACK.ADD;
472: App_Exception.Raise_Exception;
473: END IF;
474: Check_Constraints;
475: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
476: Check_Constraints;

Line 531: app_exception.raise_exception;

527: end if;
528: else
529: FND_MESSAGE.SET_NAME( 'FND', 'SYSTEM-INVALID ARGS');
530: IGS_GE_MSG_STACK.ADD;
531: app_exception.raise_exception;
532: end if;
533:
534: Before_DML( p_action => 'INSERT',
535: x_rowid => X_ROWID,

Line 606: app_exception.raise_exception;

602: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
603: fnd_message.set_token ('ERR_CD', SQLCODE);
604: igs_ge_msg_stack.add;
605: igs_sc_gen_001.unset_ctx('R');
606: app_exception.raise_exception;
607: ELSE
608: igs_sc_gen_001.unset_ctx('R');
609: RAISE;
610: END IF;

Line 641: app_exception.raise_exception;

637: if (c1%notfound) then
638: close c1;
639: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
640: IGS_GE_MSG_STACK.ADD;
641: app_exception.raise_exception;
642: return;
643: end if;
644: close c1;
645:

Line 659: app_exception.raise_exception;

655: null;
656: else
657: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
658: IGS_GE_MSG_STACK.ADD;
659: app_exception.raise_exception;
660: end if;
661: return;
662: end LOCK_ROW;
663:

Line 696: app_exception.raise_exception;

692: end if;
693: else
694: FND_MESSAGE.SET_NAME('FND', 'SYSTEM-INVALID ARGS');
695: IGS_GE_MSG_STACK.ADD;
696: app_exception.raise_exception;
697: end if;
698:
699: Before_DML( p_action => 'UPDATE',
700: x_rowid => X_ROWID,

Line 732: app_exception.raise_exception;

728: if (sql%notfound) then
729: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
730: igs_ge_msg_stack.add;
731: igs_sc_gen_001.unset_ctx('R');
732: app_exception.raise_exception;
733: end if;
734: IF (x_mode = 'S') THEN
735: igs_sc_gen_001.unset_ctx('R');
736: END IF;

Line 750: app_exception.raise_exception;

746: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
747: fnd_message.set_token ('ERR_CD', SQLCODE);
748: igs_ge_msg_stack.add;
749: igs_sc_gen_001.unset_ctx('R');
750: app_exception.raise_exception;
751: ELSE
752: igs_sc_gen_001.unset_ctx('R');
753: RAISE;
754: END IF;

Line 825: app_exception.raise_exception;

821: if (sql%notfound) then
822: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
823: igs_ge_msg_stack.add;
824: igs_sc_gen_001.unset_ctx('R');
825: app_exception.raise_exception;
826: end if;
827: IF (x_mode = 'S') THEN
828: igs_sc_gen_001.unset_ctx('R');
829: END IF;