DBA Data[Home] [Help]

APPS.IGS_UC_APP_STATS_PKG dependencies on APP_EXCEPTION

Line 71: app_exception.raise_exception;

67: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
68: CLOSE cur_old_ref_values;
69: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
70: igs_ge_msg_stack.add;
71: app_exception.raise_exception;
72: RETURN;
73: END IF;
74: CLOSE cur_old_ref_values;
75:

Line 136: app_exception.raise_exception;

132: )
133: ) THEN
134: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
135: igs_ge_msg_stack.add;
136: app_exception.raise_exception;
137: END IF;
138:
139: END check_uniqueness;
140:

Line 162: app_exception.raise_exception;

158: new_references.app_id
159: ) THEN
160: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
161: igs_ge_msg_stack.add;
162: app_exception.raise_exception;
163: END IF;
164:
165: END check_parent_existance;
166:

Line 264: app_exception.raise_exception;

260: IF (cur_rowid%FOUND) THEN
261: CLOSE cur_rowid;
262: fnd_message.set_name ('IGS', 'IGS_UC_UCAPST_UCAP_FK');
263: igs_ge_msg_stack.add;
264: app_exception.raise_exception;
265: RETURN;
266: END IF;
267: CLOSE cur_rowid;
268:

Line 362: app_exception.raise_exception;

358: )
359: ) THEN
360: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
361: igs_ge_msg_stack.add;
362: app_exception.raise_exception;
363: END IF;
364: check_uniqueness;
365: check_parent_existance;
366: ELSIF (p_action = 'UPDATE') THEN

Line 378: app_exception.raise_exception;

374: )
375: ) THEN
376: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
377: igs_ge_msg_stack.add;
378: app_exception.raise_exception;
379: END IF;
380: check_uniqueness;
381: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
382: check_uniqueness;

Line 455: app_exception.raise_exception;

451: END IF;
452: ELSE
453: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
454: igs_ge_msg_stack.add;
455: app_exception.raise_exception;
456: END IF;
457:
458: SELECT igs_uc_app_stats_s.NEXTVAL
459: INTO x_app_stat_id

Line 647: app_exception.raise_exception;

643: IF (c1%notfound) THEN
644: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
645: igs_ge_msg_stack.add;
646: CLOSE c1;
647: app_exception.raise_exception;
648: RETURN;
649: END IF;
650: CLOSE c1;
651:

Line 681: app_exception.raise_exception;

677: NULL;
678: ELSE
679: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
680: igs_ge_msg_stack.add;
681: app_exception.raise_exception;
682: END IF;
683:
684: RETURN;
685:

Line 751: app_exception.raise_exception;

747: END IF;
748: ELSE
749: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
750: igs_ge_msg_stack.add;
751: app_exception.raise_exception;
752: END IF;
753:
754: before_dml(
755: p_action => 'UPDATE',