[Home] [Help]
91: OPEN cur_old_ref_values;
92: FETCH cur_old_ref_values INTO old_references;
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;
187: NULL;
188: ELSIF NOT igf_gr_rfms_batch_pkg.get_pk_for_validation (
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:
201: ELSIF NOT igs_ca_inst_pkg.get_pk_for_validation (
202: new_references.ci_cal_type,
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:
213: NULL;
214: ELSIF NOT igf_aw_award_pkg.get_pk_for_validation (
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:
225: NULL;
226: ELSIF NOT igf_ap_fa_base_rec_pkg.get_pk_for_validation (
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:
312: OPEN cur_rowid;
313: FETCH cur_rowid INTO lv_rowid;
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;
349: OPEN cur_rowid;
350: FETCH cur_rowid INTO lv_rowid;
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;
384: OPEN cur_rowid;
385: FETCH cur_rowid INTO lv_rowid;
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;
419: OPEN cur_rowid;
420: FETCH cur_rowid INTO lv_rowid;
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;
574: IF ( get_pk_for_validation(
575: new_references.origination_id
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;
591: IF ( get_pk_for_validation (
592: new_references.origination_id
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
713: ELSE
714: x_program_update_date := SYSDATE;
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:
1055:
1056: OPEN c1;
1057: FETCH c1 INTO tlinfo;
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;
1119:
1120: ) THEN
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:
1220: IF (x_last_update_login IS NULL) THEN
1221: x_last_update_login := -1;
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: