APPS.IGS_PS_US_FLD_STUDY_PKG dependencies on APP_EXCEPTION

Line 47: app_exception.raise_exception;

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

Line 95: app_exception.raise_exception;

91: new_references.version_number
92: ) THEN
93: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
94: igs_ge_msg_stack.add;
95: app_exception.raise_exception;
96: END IF;
97:
98: END check_parent_existance;
99:

Line 169: app_exception.raise_exception;

165: IF (cur_rowid%FOUND) THEN
166: CLOSE cur_rowid;
167: fnd_message.set_name ('IGS', 'IGS_PS_UFS_US_FK');
168: igs_ge_msg_stack.add;
169: app_exception.raise_exception;
170: RETURN;
171: END IF;
172: CLOSE cur_rowid;
173:

Line 203: app_exception.raise_exception;

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

Line 258: app_exception.raise_exception;

254: )
255: ) THEN
256: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
257: igs_ge_msg_stack.add;
258: app_exception.raise_exception;
259: END IF;
260: check_parent_existance;
261: ELSIF (p_action = 'UPDATE') THEN
262: -- Call all the procedures related to Before Update.

Line 274: app_exception.raise_exception;

270: )
271: ) THEN
272: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
273: igs_ge_msg_stack.add;
274: app_exception.raise_exception;
275: END IF;
276: END IF;
277:
278: END before_dml;

Line 321: app_exception.raise_exception;

317: ELSE
318: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
319: fnd_message.set_token ('ROUTINE', 'IGS_PS_US_FLD_STUDY_PKG.INSERT_ROW');
320: igs_ge_msg_stack.add;
321: app_exception.raise_exception;
322: END IF;
323:
324: before_dml(
325: p_action => 'INSERT',

Line 392: app_exception.raise_exception;

388: IF (c1%notfound) THEN
389: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
390: igs_ge_msg_stack.add;
391: CLOSE c1;
392: app_exception.raise_exception;
393: RETURN;
394: END IF;
395: CLOSE c1;
396: