DBA Data[Home] [Help]

APPS.IGF_SL_DL_PDET_RESP_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 92: app_exception.raise_exception;

88: new_references.dlpnr_id
89: ) THEN
90: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
91: igs_ge_msg_stack.add;
92: app_exception.raise_exception;
93: END IF;
94:
95: END check_parent_existance;
96:

Line 162: app_exception.raise_exception;

158: IF (cur_rowid%FOUND) THEN
159: CLOSE cur_rowid;
160: fnd_message.set_name ('IGF', 'IGF_SL_DLPDR_DLPNR_FK');
161: igs_ge_msg_stack.add;
162: app_exception.raise_exception;
163: RETURN;
164: END IF;
165: CLOSE cur_rowid;
166:

Line 216: app_exception.raise_exception;

212: )
213: ) THEN
214: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
215: igs_ge_msg_stack.add;
216: app_exception.raise_exception;
217: END IF;
218: check_parent_existance;
219: ELSIF (p_action = 'UPDATE') THEN
220: -- Call all the procedures related to Before Update.

Line 231: app_exception.raise_exception;

227: )
228: ) THEN
229: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
230: igs_ge_msg_stack.add;
231: app_exception.raise_exception;
232: END IF;
233: END IF;
234:
235: END before_dml;

Line 298: app_exception.raise_exception;

294: END IF;
295: ELSE
296: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
297: igs_ge_msg_stack.add;
298: app_exception.raise_exception;
299: END IF;
300:
301: before_dml(
302: p_action => 'INSERT',

Line 385: app_exception.raise_exception;

381: IF (c1%notfound) THEN
382: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
383: igs_ge_msg_stack.add;
384: CLOSE c1;
385: app_exception.raise_exception;
386: RETURN;
387: END IF;
388: CLOSE c1;
389:

Line 397: app_exception.raise_exception;

393: NULL;
394: ELSE
395: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
396: igs_ge_msg_stack.add;
397: app_exception.raise_exception;
398: END IF;
399:
400: RETURN;
401:

Line 447: app_exception.raise_exception;

443: END IF;
444: ELSE
445: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
446: igs_ge_msg_stack.add;
447: app_exception.raise_exception;
448: END IF;
449:
450: before_dml(
451: p_action => 'UPDATE',