[Home] [Help]
47: OPEN cur_old_ref_values;
48: FETCH cur_old_ref_values INTO old_references;
49: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
50: CLOSE cur_old_ref_values;
51: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
52: igs_ge_msg_stack.add;
53: app_exception.raise_exception;
54: RETURN;
55: END IF;
99: new_references.ld_cal_type,
100: new_references.ld_sequence_number
101: )
102: ) THEN
103: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
104: igs_ge_msg_stack.add;
105: app_exception.raise_exception;
106: END IF;
107:
129: ELSIF NOT igs_ca_inst_pkg.get_pk_for_validation (
130: new_references.ld_cal_type,
131: new_references.ld_sequence_number
132: ) THEN
133: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
134: igs_ge_msg_stack.add;
135: app_exception.raise_exception;
136: END IF;
137:
140: NULL;
141: ELSIF NOT igf_ap_fa_base_rec_pkg.get_pk_for_validation (
142: new_references.base_id
143: ) THEN
144: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
145: igs_ge_msg_stack.add;
146: app_exception.raise_exception;
147: END IF;
148:
151: NULL;
152: ELSIF NOT igf_aw_fund_mast_pkg.get_pk_for_validation (
153: new_references.fund_id
154: ) THEN
155: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
156: igs_ge_msg_stack.add;
157: app_exception.raise_exception;
158: END IF;
159:
279: OPEN cur_rowid;
280: FETCH cur_rowid INTO lv_rowid;
281: IF (cur_rowid%FOUND) THEN
282: CLOSE cur_rowid;
283: fnd_message.set_name ('IGF', 'IGF_SP_SPSTD_HZ_FK');
284: igs_ge_msg_stack.add;
285: app_exception.raise_exception;
286: RETURN;
287: END IF;
316: OPEN cur_rowid;
317: FETCH cur_rowid INTO lv_rowid;
318: IF (cur_rowid%FOUND) THEN
319: CLOSE cur_rowid;
320: fnd_message.set_name ('IGF', 'IGF_SP_SPSTD_CA_FK');
321: igs_ge_msg_stack.add;
322: app_exception.raise_exception;
323: RETURN;
324: END IF;
351: OPEN cur_rowid;
352: FETCH cur_rowid INTO lv_rowid;
353: IF (cur_rowid%FOUND) THEN
354: CLOSE cur_rowid;
355: fnd_message.set_name ('IGF', 'IGF_SP_SPSTD_FA_DETAIL_FK');
356: igs_ge_msg_stack.add;
357: app_exception.raise_exception;
358: RETURN;
359: END IF;
386: OPEN cur_rowid;
387: FETCH cur_rowid INTO lv_rowid;
388: IF (cur_rowid%FOUND) THEN
389: CLOSE cur_rowid;
390: fnd_message.set_name ('IGF', 'IGF_SP_SPSTD_FMAST_FK');
391: igs_ge_msg_stack.add;
392: app_exception.raise_exception;
393: RETURN;
394: END IF;
452: IF ( get_pk_for_validation(
453: new_references.spnsr_stdnt_id
454: )
455: ) THEN
456: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
457: igs_ge_msg_stack.add;
458: app_exception.raise_exception;
459: END IF;
460: check_uniqueness;
471: IF ( get_pk_for_validation (
472: new_references.spnsr_stdnt_id
473: )
474: ) THEN
475: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
476: igs_ge_msg_stack.add;
477: app_exception.raise_exception;
478: END IF;
479: check_uniqueness;
532: IF (x_last_update_login IS NULL) THEN
533: x_last_update_login := -1;
534: END IF;
535: ELSE
536: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
537: igs_ge_msg_stack.add;
538: app_exception.raise_exception;
539: END IF;
540:
649:
650: OPEN c1;
651: FETCH c1 INTO tlinfo;
652: IF (c1%notfound) THEN
653: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
654: igs_ge_msg_stack.add;
655: CLOSE c1;
656: app_exception.raise_exception;
657: RETURN;
669: AND ((tlinfo.min_attendance_type = x_min_attendance_type) OR ((tlinfo.min_attendance_type IS NULL) AND (X_min_attendance_type IS NULL)))
670: ) THEN
671: NULL;
672: ELSE
673: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
674: igs_ge_msg_stack.add;
675: app_exception.raise_exception;
676: END IF;
677:
721: IF (x_last_update_login IS NULL) THEN
722: x_last_update_login := -1;
723: END IF;
724: ELSE
725: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
726: igs_ge_msg_stack.add;
727: app_exception.raise_exception;
728: END IF;
729: