45: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
46: CLOSE cur_old_ref_values;
47: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
48: igs_ge_msg_stack.add;
49: app_exception.raise_exception;
50: RETURN;
51: END IF;
52: CLOSE cur_old_ref_values;
53:
91: )
92: ) THEN
93: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
94: igs_ge_msg_stack.add;
95: app_exception.raise_exception;
96: END IF;
97:
98: END check_uniqueness;
99:
117: new_references.spnsr_stdnt_id
118: ) THEN
119: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
120: igs_ge_msg_stack.add;
121: app_exception.raise_exception;
122: END IF;
123:
124: IF (((old_references.fee_class = new_references.fee_class)) OR
125: ((new_references.fee_class IS NULL))) THEN
129: new_references.fee_class
130: ) THEN
131: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
132: igs_ge_msg_stack.add;
133: app_exception.raise_exception;
134: END IF;
135:
136: END check_parent_existance;
137:
253: IF (cur_rowid%FOUND) THEN
254: CLOSE cur_rowid;
255: fnd_message.set_name ('IGF', 'IGF_SP_STDFC_SPSTD_FK');
256: igs_ge_msg_stack.add;
257: app_exception.raise_exception;
258: RETURN;
259: END IF;
260: CLOSE cur_rowid;
261:
287: IF (cur_rowid%FOUND) THEN
288: CLOSE cur_rowid;
289: fnd_message.set_name ('IGF', 'IGF_SP_STDFC_LKUP_FK');
290: igs_ge_msg_stack.add;
291: app_exception.raise_exception;
292: RETURN;
293: END IF;
294: CLOSE cur_rowid;
295:
345: )
346: ) THEN
347: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
348: igs_ge_msg_stack.add;
349: app_exception.raise_exception;
350: END IF;
351: check_uniqueness;
352: check_parent_existance;
353: ELSIF (p_action = 'UPDATE') THEN
364: )
365: ) THEN
366: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
367: igs_ge_msg_stack.add;
368: app_exception.raise_exception;
369: END IF;
370: check_uniqueness;
371: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
372: check_uniqueness;
421: END IF;
422: ELSE
423: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
424: igs_ge_msg_stack.add;
425: app_exception.raise_exception;
426: END IF;
427:
428: SELECT igf_sp_std_fc_s.NEXTVAL
429: INTO x_fee_cls_id
519: IF (c1%notfound) THEN
520: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
521: igs_ge_msg_stack.add;
522: CLOSE c1;
523: app_exception.raise_exception;
524: RETURN;
525: END IF;
526: CLOSE c1;
527:
534: NULL;
535: ELSE
536: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
537: igs_ge_msg_stack.add;
538: app_exception.raise_exception;
539: END IF;
540:
541: RETURN;
542:
582: END IF;
583: ELSE
584: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
585: igs_ge_msg_stack.add;
586: app_exception.raise_exception;
587: END IF;
588:
589: before_dml(
590: p_action => 'UPDATE',