DBA Data[Home] [Help]

APPS.IGF_AW_CAL_REL_PKG dependencies on APP_EXCEPTION

Line 49: app_exception.raise_exception;

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

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 125: app_exception.raise_exception;

121: new_references.cr_sequence_number
122: ) THEN
123: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
124: igs_ge_msg_stack.add;
125: app_exception.raise_exception;
126: END IF;
127:
128: END check_parent_existance;
129:

Line 239: app_exception.raise_exception;

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

Line 296: app_exception.raise_exception;

292: )
293: ) THEN
294: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
295: igs_ge_msg_stack.add;
296: app_exception.raise_exception;
297: END IF;
298: check_uniqueness;
299: check_parent_existance;
300: ELSIF (p_action = 'UPDATE') THEN

Line 312: app_exception.raise_exception;

308: )
309: ) THEN
310: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
311: igs_ge_msg_stack.add;
312: app_exception.raise_exception;
313: END IF;
314: check_uniqueness;
315: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
316: check_uniqueness;

Line 367: app_exception.raise_exception;

363: END IF;
364: ELSE
365: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
366: igs_ge_msg_stack.add;
367: app_exception.raise_exception;
368: END IF;
369:
370: SELECT igf_aw_cal_rel_s.NEXTVAL
371: INTO x_crel_id

Line 465: app_exception.raise_exception;

461: IF (c1%notfound) THEN
462: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
463: igs_ge_msg_stack.add;
464: CLOSE c1;
465: app_exception.raise_exception;
466: RETURN;
467: END IF;
468: CLOSE c1;
469:

Line 480: app_exception.raise_exception;

476: NULL;
477: ELSE
478: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
479: igs_ge_msg_stack.add;
480: app_exception.raise_exception;
481: END IF;
482:
483: RETURN;
484:

Line 528: app_exception.raise_exception;

524: END IF;
525: ELSE
526: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
527: igs_ge_msg_stack.add;
528: app_exception.raise_exception;
529: END IF;
530:
531: before_dml(
532: p_action => 'UPDATE',