APPS.IGS_AD_APL_RVPF_RSL_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: 'N'
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: IF (((old_references.rating_type_id = new_references.rating_type_id)) OR
123: ((new_references.rating_type_id IS NULL))) THEN

Line 132: app_exception.raise_exception;

128: 'N'
129: ) THEN
130: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
131: igs_ge_msg_stack.add;
132: app_exception.raise_exception;
133: END IF;
134:
135: IF (((old_references.rating_scale_id = new_references.rating_scale_id)) OR
136: ((new_references.rating_scale_id IS NULL))) THEN

Line 144: app_exception.raise_exception;

140: 'N'
141: ) THEN
142: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
143: igs_ge_msg_stack.add;
144: app_exception.raise_exception;
145: END IF;
146:
147: END check_parent_existance;
148:

Line 178: app_exception.raise_exception;

174: ELSE
175: IF lv_end_date IS NULL OR lv_end_date >= SYSDATE THEN
176: fnd_message.set_name ('IGS', 'IGS_AD_RAT_SCALE_NOT_END');
177: igs_ge_msg_stack.add;
178: app_exception.raise_exception;
179: RETURN;
180: ELSE
181: null;
182: END IF;

Line 288: app_exception.raise_exception;

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

Line 323: app_exception.raise_exception;

319: IF (cur_rowid%FOUND) THEN
320: CLOSE cur_rowid;
321: fnd_message.set_name ('IGS', 'IGS_AD_APRSCL_ADCC_FK');
322: igs_ge_msg_stack.add;
323: app_exception.raise_exception;
324: RETURN;
325: END IF;
326: CLOSE cur_rowid;
327:

Line 358: app_exception.raise_exception;

354: IF (cur_rowid%FOUND) THEN
355: CLOSE cur_rowid;
356: fnd_message.set_name ('IGS', 'IGS_AD_APRSCL_ARS_FK');
357: igs_ge_msg_stack.add;
358: app_exception.raise_exception;
359: RETURN;
360: END IF;
361: CLOSE cur_rowid;
362:

Line 414: app_exception.raise_exception;

410: )
411: ) THEN
412: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
413: igs_ge_msg_stack.add;
414: app_exception.raise_exception;
415: END IF;
416: check_uniqueness;
417: check_parent_existance;
418: beforerowinsertupdate (

Line 436: app_exception.raise_exception;

432: )
433: ) THEN
434: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
435: igs_ge_msg_stack.add;
436: app_exception.raise_exception;
437: END IF;
438: check_uniqueness;
439: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
440: -- Call all the procedures related to Before Update.

Line 491: app_exception.raise_exception;

487: END IF;
488: ELSE
489: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
490: igs_ge_msg_stack.add;
491: app_exception.raise_exception;
492: END IF;
493:
494: x_appl_revprof_rtscale_id := -1;
495: before_dml(

Line 577: app_exception.raise_exception;

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

Line 591: app_exception.raise_exception;

587: NULL;
588: ELSE
589: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
590: igs_ge_msg_stack.add;
591: app_exception.raise_exception;
592: END IF;
593:
594: RETURN;
595:

Line 638: app_exception.raise_exception;

634: END IF;
635: ELSE
636: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
637: igs_ge_msg_stack.add;
638: app_exception.raise_exception;
639: END IF;
640:
641: before_dml(
642: p_action => 'UPDATE',