APPS.IGS_PR_COHORT_INST_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 97: app_exception.raise_exception;

93: new_references.cohort_name
94: ) THEN
95: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
96: igs_ge_msg_stack.add;
97: app_exception.raise_exception;
98: END IF;
99:
100: IF (((old_references.load_cal_type = new_references.load_cal_type) AND
101: (old_references.load_ci_sequence_number = new_references.load_ci_sequence_number)) OR

Line 111: app_exception.raise_exception;

107: new_references.load_ci_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 203: app_exception.raise_exception;

199: IF (cur_rowid%FOUND) THEN
200: CLOSE cur_rowid;
201: fnd_message.set_name ('IGS', 'IGS_PR_COH_COHI_FK');
202: igs_ge_msg_stack.add;
203: app_exception.raise_exception;
204: RETURN;
205: END IF;
206: CLOSE cur_rowid;
207:

Line 240: app_exception.raise_exception;

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

Line 301: app_exception.raise_exception;

297: )
298: ) THEN
299: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
300: igs_ge_msg_stack.add;
301: app_exception.raise_exception;
302: END IF;
303: check_parent_existance;
304: ELSIF (p_action = 'UPDATE') THEN
305: -- Call all the procedures related to Before Update.

Line 320: app_exception.raise_exception;

316: )
317: ) THEN
318: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
319: igs_ge_msg_stack.add;
320: app_exception.raise_exception;
321: END IF;
322: ELSIF (p_action = 'VALIDATE_DELETE') THEN
323: check_child_existance;
324: END IF;

Line 387: app_exception.raise_exception;

383: END IF;
384: ELSE
385: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
386: igs_ge_msg_stack.add;
387: app_exception.raise_exception;
388: END IF;
389:
390: before_dml(
391: p_action => 'INSERT',

Line 480: app_exception.raise_exception;

476: IF (c1%notfound) THEN
477: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
478: igs_ge_msg_stack.add;
479: CLOSE c1;
480: app_exception.raise_exception;
481: RETURN;
482: END IF;
483: CLOSE c1;
484:

Line 494: app_exception.raise_exception;

490: NULL;
491: ELSE
492: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
493: igs_ge_msg_stack.add;
494: app_exception.raise_exception;
495: END IF;
496:
497: RETURN;
498:

Line 547: app_exception.raise_exception;

543: END IF;
544: ELSE
545: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
546: igs_ge_msg_stack.add;
547: app_exception.raise_exception;
548: END IF;
549:
550: before_dml(
551: p_action => 'UPDATE',