APPS.IGF_GR_RFMS_PKG dependencies on APP_EXCEPTION

Line 97: app_exception.raise_exception;

93: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
94: CLOSE cur_old_ref_values;
95: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
96: igs_ge_msg_stack.add;
97: app_exception.raise_exception;
98: RETURN;
99: END IF;
100: CLOSE cur_old_ref_values;
101:

Line 193: app_exception.raise_exception;

189: new_references.rfmb_id
190: ) THEN
191: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
192: igs_ge_msg_stack.add;
193: app_exception.raise_exception;
194: END IF;
195:
196: IF (((old_references.ci_cal_type = new_references.ci_cal_type) AND
197: (old_references.ci_sequence_number = new_references.ci_sequence_number)) OR

Line 207: app_exception.raise_exception;

203: new_references.ci_sequence_number
204: ) THEN
205: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
206: igs_ge_msg_stack.add;
207: app_exception.raise_exception;
208: END IF;
209:
210: -- check for parent key existance for Awards table
211: IF (((old_references.award_id = new_references.award_id)) OR

Line 219: app_exception.raise_exception;

215: new_references.award_id
216: ) THEN
217: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
218: igs_ge_msg_stack.add;
219: app_exception.raise_exception;
220: END IF;
221:
222: -- check for parent key existance for FA Base Rec table
223: IF (((old_references.base_id = new_references.base_id)) OR

Line 231: app_exception.raise_exception;

227: new_references.base_id
228: ) THEN
229: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
230: igs_ge_msg_stack.add;
231: app_exception.raise_exception;
232: END IF;
233:
234: END check_parent_existance;
235:

Line 318: app_exception.raise_exception;

314: IF (cur_rowid%FOUND) THEN
315: CLOSE cur_rowid;
316: fnd_message.set_name ('IGF', 'IGF_GR_RFMS_RFMB_FK');
317: igs_ge_msg_stack.add;
318: app_exception.raise_exception;
319: RETURN;
320: END IF;
321: CLOSE cur_rowid;
322:

Line 355: app_exception.raise_exception;

351: IF (cur_rowid%FOUND) THEN
352: CLOSE cur_rowid;
353: fnd_message.set_name ('IGF', 'IGF_GR_RFMS_CI_FK');
354: igs_ge_msg_stack.add;
355: app_exception.raise_exception;
356: RETURN;
357: END IF;
358: CLOSE cur_rowid;
359:

Line 390: app_exception.raise_exception;

386: IF (cur_rowid%FOUND) THEN
387: CLOSE cur_rowid;
388: fnd_message.set_name ('IGF', 'IGF_GR_RFMS_AWD_FK');
389: igs_ge_msg_stack.add;
390: app_exception.raise_exception;
391: RETURN;
392: END IF;
393: CLOSE cur_rowid;
394:

Line 425: app_exception.raise_exception;

421: IF (cur_rowid%FOUND) THEN
422: CLOSE cur_rowid;
423: fnd_message.set_name ('IGF', 'IGF_GR_RFMS_FA_DETAIL_FK');
424: igs_ge_msg_stack.add;
425: app_exception.raise_exception;
426: RETURN;
427: END IF;
428: CLOSE cur_rowid;
429:

Line 580: app_exception.raise_exception;

576: )
577: ) THEN
578: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
579: igs_ge_msg_stack.add;
580: app_exception.raise_exception;
581: END IF;
582: check_parent_existance;
583: ELSIF (p_action = 'UPDATE') THEN
584: -- Call all the procedures related to Before Update.

Line 597: app_exception.raise_exception;

593: )
594: ) THEN
595: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
596: igs_ge_msg_stack.add;
597: app_exception.raise_exception;
598: END IF;
599: ELSIF (p_action = 'VALIDATE_DELETE') THEN
600: check_child_existance;
601: END IF;

Line 719: app_exception.raise_exception;

715: END IF;
716: ELSE
717: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
718: igs_ge_msg_stack.add;
719: app_exception.raise_exception;
720: END IF;
721:
722: before_dml(
723: p_action => 'INSERT',

Line 1062: app_exception.raise_exception;

1058: IF (c1%notfound) THEN
1059: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1060: igs_ge_msg_stack.add;
1061: CLOSE c1;
1062: app_exception.raise_exception;
1063: RETURN;
1064: END IF;
1065: CLOSE c1;
1066:

Line 1125: app_exception.raise_exception;

1121: NULL;
1122: ELSE
1123: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1124: igs_ge_msg_stack.add;
1125: app_exception.raise_exception;
1126: END IF;
1127:
1128: RETURN;
1129:

Line 1226: app_exception.raise_exception;

1222: END IF;
1223: ELSE
1224: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1225: igs_ge_msg_stack.add;
1226: app_exception.raise_exception;
1227: END IF;
1228:
1229: before_dml(
1230: p_action => 'UPDATE',