APPS.IGS_OR_INST_STAT_DTL_PKG dependencies on APP_EXCEPTION

Line 48: app_exception.raise_exception;

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

Line 93: app_exception.raise_exception;

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

Line 119: app_exception.raise_exception;

115: new_references.inst_stat_id
116: ) THEN
117: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
118: igs_ge_msg_stack.add;
119: app_exception.raise_exception;
120: END IF;
121:
122: END check_parent_existance;
123:

Line 224: app_exception.raise_exception;

220: IF (cur_rowid%FOUND) THEN
221: CLOSE cur_rowid;
222: fnd_message.set_name ('IGS', 'IGS_OR_OISD_OINS');
223: igs_ge_msg_stack.add;
224: app_exception.raise_exception;
225: RETURN;
226: END IF;
227: CLOSE cur_rowid;
228:

Line 282: app_exception.raise_exception;

278: )
279: ) THEN
280: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
281: igs_ge_msg_stack.add;
282: app_exception.raise_exception;
283: END IF;
284: check_uniqueness;
285: check_parent_existance;
286: ELSIF (p_action = 'UPDATE') THEN

Line 298: app_exception.raise_exception;

294: )
295: ) THEN
296: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
297: igs_ge_msg_stack.add;
298: app_exception.raise_exception;
299: END IF;
300: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
301:
302: NULL;

Line 369: app_exception.raise_exception;

365: END IF;
366: ELSE
367: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
368: igs_ge_msg_stack.add;
369: app_exception.raise_exception;
370: END IF;
371:
372: SELECT igs_or_inst_stat_dtl_s.NEXTVAL
373: INTO x_inst_stat_dtl_id

Line 466: app_exception.raise_exception;

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

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

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