APPS.IGS_PR_STDNT_PR_AWD_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 94: app_exception.raise_exception;

90: new_references.award_cd
91: ) THEN
92: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
93: igs_ge_msg_stack.add;
94: app_exception.raise_exception;
95: END IF;
96:
97: IF (((old_references.person_id = new_references.person_id) AND
98: (old_references.course_cd = new_references.course_cd) AND

Line 111: app_exception.raise_exception;

107: new_references.spo_sequence_number
108: ) THEN
109: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
110: igs_ge_msg_stack.add;
111: app_exception.raise_exception;
112: END IF;
113:
114: END check_parent_existance;
115:

Line 189: app_exception.raise_exception;

185: IF (cur_rowid%FOUND) THEN
186: CLOSE cur_rowid;
187: fnd_message.set_name ('IGS', 'IGS_PR_SPOA_SPO_FK');
188: igs_ge_msg_stack.add;
189: app_exception.raise_exception;
190: RETURN;
191: END IF;
192: CLOSE cur_rowid;
193:

Line 247: app_exception.raise_exception;

243: )
244: ) THEN
245: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
246: igs_ge_msg_stack.add;
247: app_exception.raise_exception;
248: END IF;
249: check_parent_existance;
250: ELSIF (p_action = 'UPDATE') THEN
251: -- Call all the procedures related to Before Update.

Line 264: app_exception.raise_exception;

260: )
261: ) THEN
262: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
263: igs_ge_msg_stack.add;
264: app_exception.raise_exception;
265: END IF;
266: END IF;
267:
268: END before_dml;

Line 318: app_exception.raise_exception;

314: END IF;
315: ELSE
316: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
317: igs_ge_msg_stack.add;
318: app_exception.raise_exception;
319: END IF;
320:
321: before_dml(
322: p_action => 'INSERT',

Line 380: app_exception.raise_exception;

376: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
377: fnd_message.set_token ('ERR_CD', SQLCODE);
378: igs_ge_msg_stack.add;
379: igs_sc_gen_001.unset_ctx('R');
380: app_exception.raise_exception;
381: ELSE
382: igs_sc_gen_001.unset_ctx('R');
383: RAISE;
384: END IF;

Line 421: app_exception.raise_exception;

417: IF (c1%notfound) THEN
418: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
419: igs_ge_msg_stack.add;
420: CLOSE c1;
421: app_exception.raise_exception;
422: RETURN;
423: END IF;
424: CLOSE c1;
425:

Line 462: app_exception.raise_exception;

458: IF (SQL%NOTFOUND) THEN
459: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
460: igs_ge_msg_stack.add;
461: igs_sc_gen_001.unset_ctx('R');
462: app_exception.raise_exception;
463: END IF;
464: IF (x_mode = 'S') THEN
465: igs_sc_gen_001.unset_ctx('R');
466: END IF;