APPS.IGS_EN_NSTD_USEC_DL_PKG dependencies on APP_EXCEPTION

Line 57: app_exception.raise_exception;

53: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
54: CLOSE cur_old_ref_values;
55: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
56: igs_ge_msg_stack.add;
57: app_exception.raise_exception;
58: RETURN;
59: END IF;
60: CLOSE cur_old_ref_values;
61:

Line 111: app_exception.raise_exception;

107: )
108: ) THEN
109: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
110: igs_ge_msg_stack.add;
111: app_exception.raise_exception;
112: END IF;
113:
114: END check_uniqueness;
115:

Line 137: app_exception.raise_exception;

133: new_references.uoo_id
134: ) THEN
135: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
136: igs_ge_msg_stack.add;
137: app_exception.raise_exception;
138: END IF;
139:
140: IF (((old_references.non_std_usec_dls_id = new_references.non_std_usec_dls_id)) OR
141: ((new_references.non_std_usec_dls_id IS NULL))) THEN

Line 148: app_exception.raise_exception;

144: new_references.non_std_usec_dls_id
145: ) THEN
146: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
147: igs_ge_msg_stack.add;
148: app_exception.raise_exception;
149: END IF;
150:
151: END check_parent_existance;
152:

Line 253: app_exception.raise_exception;

249: IF (cur_rowid%FOUND) THEN
250: CLOSE cur_rowid;
251: fnd_message.set_name ('IGS', 'IGS_EN_NSDL_UOO_UFK');
252: igs_ge_msg_stack.add;
253: app_exception.raise_exception;
254: RETURN;
255: END IF;
256: CLOSE cur_rowid;
257:

Line 288: app_exception.raise_exception;

284: IF (cur_rowid%FOUND) THEN
285: CLOSE cur_rowid;
286: fnd_message.set_name ('IGS', 'IGS_EN_NSDL_NSUD_FK');
287: igs_ge_msg_stack.add;
288: app_exception.raise_exception;
289: RETURN;
290: END IF;
291: CLOSE cur_rowid;
292:

Line 361: app_exception.raise_exception;

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

Line 377: app_exception.raise_exception;

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

Line 440: app_exception.raise_exception;

436: END IF;
437: ELSE
438: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
439: igs_ge_msg_stack.add;
440: app_exception.raise_exception;
441: END IF;
442:
443: SELECT igs_en_nstd_usec_dl_s.NEXTVAL
444: INTO x_nstd_usec_dl_id

Line 574: app_exception.raise_exception;

570: IF (c1%notfound) THEN
571: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
572: igs_ge_msg_stack.add;
573: CLOSE c1;
574: app_exception.raise_exception;
575: RETURN;
576: END IF;
577: CLOSE c1;
578:

Line 597: app_exception.raise_exception;

593: NULL;
594: ELSE
595: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
596: igs_ge_msg_stack.add;
597: app_exception.raise_exception;
598: END IF;
599:
600: RETURN;
601:

Line 653: app_exception.raise_exception;

649: END IF;
650: ELSE
651: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
652: igs_ge_msg_stack.add;
653: app_exception.raise_exception;
654: END IF;
655:
656: before_dml(
657: p_action => 'UPDATE',