DBA Data[Home] [Help]

APPS.IGS_OR_INST_STATS_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 91: app_exception.raise_exception;

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

Line 118: app_exception.raise_exception;

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

Line 260: app_exception.raise_exception;

256: )
257: ) THEN
258: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
259: igs_ge_msg_stack.add;
260: app_exception.raise_exception;
261: END IF;
262: check_uniqueness;
263: check_parent_existance;
264: ELSIF (p_action = 'UPDATE') THEN

Line 279: app_exception.raise_exception;

275: )
276: ) THEN
277: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
278: igs_ge_msg_stack.add;
279: app_exception.raise_exception;
280: END IF;
281: check_uniqueness;
282: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
283: check_uniqueness;

Line 350: app_exception.raise_exception;

346: END IF;
347: ELSE
348: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
349: igs_ge_msg_stack.add;
350: app_exception.raise_exception;
351: END IF;
352:
353: SELECT igs_or_inst_stats_s.NEXTVAL
354: INTO x_inst_stat_id

Line 442: app_exception.raise_exception;

438: IF (c1%notfound) THEN
439: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
440: igs_ge_msg_stack.add;
441: CLOSE c1;
442: app_exception.raise_exception;
443: RETURN;
444: END IF;
445: CLOSE c1;
446:

Line 455: app_exception.raise_exception;

451: NULL;
452: ELSE
453: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
454: igs_ge_msg_stack.add;
455: app_exception.raise_exception;
456: END IF;
457:
458: RETURN;
459:

Line 505: app_exception.raise_exception;

501: END IF;
502: ELSE
503: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
504: igs_ge_msg_stack.add;
505: app_exception.raise_exception;
506: END IF;
507:
508: before_dml(
509: p_action => 'UPDATE',