APPS.IGS_PS_PRG_UNIT_REL_PKG dependencies on APP_EXCEPTION

Line 50: app_exception.raise_exception;

46: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
47: CLOSE cur_old_ref_values;
48: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
49: igs_ge_msg_stack.add;
50: app_exception.raise_exception;
51: RETURN;
52: END IF;
53: CLOSE cur_old_ref_values;
54:

Line 96: app_exception.raise_exception;

92: )
93: ) THEN
94: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
95: igs_ge_msg_stack.add;
96: app_exception.raise_exception;
97: END IF;
98:
99: END check_uniqueness;
100:

Line 122: app_exception.raise_exception;

118: new_references.unit_type_id
119: ) THEN
120: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
121: igs_ge_msg_stack.add;
122: app_exception.raise_exception;
123: END IF;
124:
125: IF (((old_references.student_career_level = new_references.student_career_level)) OR
126: ((new_references.student_career_level IS NULL))) THEN

Line 133: app_exception.raise_exception;

129: new_references.student_career_level
130: ) THEN
131: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
132: igs_ge_msg_stack.add;
133: app_exception.raise_exception;
134: END IF;
135:
136: END check_parent_existance;
137:

Line 238: app_exception.raise_exception;

234: IF (cur_rowid%FOUND) THEN
235: CLOSE cur_rowid;
236: fnd_message.set_name ('IGS', 'IGS_PS_UTL_PUR_FK');
237: igs_ge_msg_stack.add;
238: app_exception.raise_exception;
239: RETURN;
240: END IF;
241: CLOSE cur_rowid;
242:

Line 273: app_exception.raise_exception;

269: IF (cur_rowid%FOUND) THEN
270: CLOSE cur_rowid;
271: fnd_message.set_name ('IGS', 'IGS_PS_PST_PUR_FK');
272: igs_ge_msg_stack.add;
273: app_exception.raise_exception;
274: RETURN;
275: END IF;
276: CLOSE cur_rowid;
277:

Line 330: app_exception.raise_exception;

326: )
327: ) THEN
328: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
329: igs_ge_msg_stack.add;
330: app_exception.raise_exception;
331: END IF;
332: check_uniqueness;
333: check_parent_existance;
334: ELSIF (p_action = 'UPDATE') THEN

Line 346: app_exception.raise_exception;

342: )
343: ) THEN
344: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
345: igs_ge_msg_stack.add;
346: app_exception.raise_exception;
347: END IF;
348: check_uniqueness;
349: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
350: check_uniqueness;

Line 401: app_exception.raise_exception;

397: END IF;
398: ELSE
399: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
400: igs_ge_msg_stack.add;
401: app_exception.raise_exception;
402: END IF;
403:
404: SELECT igs_ps_prg_unit_rel_s.NEXTVAL
405: INTO x_ps_prun_rel_id

Line 495: app_exception.raise_exception;

491: IF (c1%notfound) THEN
492: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
493: igs_ge_msg_stack.add;
494: CLOSE c1;
495: app_exception.raise_exception;
496: RETURN;
497: END IF;
498: CLOSE c1;
499:

Line 510: app_exception.raise_exception;

506: NULL;
507: ELSE
508: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
509: igs_ge_msg_stack.add;
510: app_exception.raise_exception;
511: END IF;
512:
513: RETURN;
514:

Line 558: app_exception.raise_exception;

554: END IF;
555: ELSE
556: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
557: igs_ge_msg_stack.add;
558: app_exception.raise_exception;
559: END IF;
560:
561: before_dml(
562: p_action => 'UPDATE',