49: FETCH cur_old_ref_values INTO old_references;
50: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
51: CLOSE cur_old_ref_values;
52: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
53: igs_ge_msg_stack.add;
54: app_exception.raise_exception;
55: RETURN;
56: END IF;
57: CLOSE cur_old_ref_values;
100: new_references.installment_line_num
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:
108: IF ( get_uk2_for_validation (
110: new_references.due_date
111: )
112: ) THEN
113: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
114: igs_ge_msg_stack.add;
115: app_exception.raise_exception;
116: END IF;
117:
118: END check_uniqueness;
136: ELSIF NOT igs_fi_pp_std_attrs_pkg.get_pk_for_validation (
137: new_references.student_plan_id
138: ) THEN
139: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
140: igs_ge_msg_stack.add;
141: app_exception.raise_exception;
142: END IF;
143:
144: END check_parent_existance;
278: FETCH cur_rowid INTO lv_rowid;
279: IF (cur_rowid%FOUND) THEN
280: CLOSE cur_rowid;
281: fnd_message.set_name ('IGS', 'IGS_FI_PPIN_PPSA_FK');
282: igs_ge_msg_stack.add;
283: app_exception.raise_exception;
284: RETURN;
285: END IF;
286: CLOSE cur_rowid;
345: new_references.installment_id
346: )
347: ) THEN
348: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
349: igs_ge_msg_stack.add;
350: app_exception.raise_exception;
351: END IF;
352: check_uniqueness;
353: check_parent_existance;
361: new_references.installment_id
362: )
363: ) THEN
364: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
365: igs_ge_msg_stack.add;
366: app_exception.raise_exception;
367: END IF;
368: check_uniqueness;
369: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
436: END IF;
437: ELSE
438: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
439: fnd_message.set_token ('ROUTINE', 'IGS_FI_PP_INSTLMNTS_PKG.INSERT_ROW');
440: igs_ge_msg_stack.add;
441: app_exception.raise_exception;
442: END IF;
443:
444: x_installment_id := NULL;
552: OPEN c1;
553: FETCH c1 INTO tlinfo;
554: IF (c1%notfound) THEN
555: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
556: igs_ge_msg_stack.add;
557: CLOSE c1;
558: app_exception.raise_exception;
559: RETURN;
560: END IF;
573: ) THEN
574: NULL;
575: ELSE
576: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
577: igs_ge_msg_stack.add;
578: app_exception.raise_exception;
579: END IF;
580:
581: RETURN;
631: END IF;
632: ELSE
633: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
634: fnd_message.set_token ('ROUTINE', 'IGS_FI_PP_INSTLMNTS_PKG.UPDATE_ROW');
635: igs_ge_msg_stack.add;
636: app_exception.raise_exception;
637: END IF;
638:
639: before_dml(