45: OPEN cur_old_ref_values;
46: FETCH cur_old_ref_values INTO old_references;
47: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
48: CLOSE cur_old_ref_values;
49: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
50: igs_ge_msg_stack.add;
51: app_exception.raise_exception;
52: RETURN;
53: END IF;
94: NULL;
95: ELSIF NOT igf_gr_report_pell_pkg.get_pk_for_validation (
96: new_references.rcampus_id
97: ) THEN
98: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
99: igs_ge_msg_stack.add;
100: app_exception.raise_exception;
101: END IF;
102:
163: FETCH cur_attend INTO attend_rec;
164: IF (cur_attend%FOUND) THEN
165: CLOSE cur_attend;
166: IF attend_rec.atd_entity_id_txt IS NULL THEN
167: fnd_message.set_name ('IGF', 'IGF_GR_CANT_DEL_REP_PELL');
168: igs_ge_msg_stack.add;
169: app_exception.raise_exception;
170: ELSE
171: fnd_message.set_name ('IGF', 'IGF_GR_CANT_DEL_REP_ENT');
167: fnd_message.set_name ('IGF', 'IGF_GR_CANT_DEL_REP_PELL');
168: igs_ge_msg_stack.add;
169: app_exception.raise_exception;
170: ELSE
171: fnd_message.set_name ('IGF', 'IGF_GR_CANT_DEL_REP_ENT');
172: igs_ge_msg_stack.add;
173: app_exception.raise_exception;
174: END IF;
175: RETURN;
229: IF ( get_pk_for_validation(
230: new_references.acampus_id
231: )
232: ) THEN
233: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
234: igs_ge_msg_stack.add;
235: app_exception.raise_exception;
236: END IF;
237: check_parent_existance;
245: IF ( get_pk_for_validation (
246: new_references.acampus_id
247: )
248: ) THEN
249: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
250: igs_ge_msg_stack.add;
251: app_exception.raise_exception;
252: END IF;
253: check_uniqueness;
296: IF (x_last_update_login IS NULL) THEN
297: x_last_update_login := -1;
298: END IF;
299: ELSE
300: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
301: fnd_message.set_token ('ROUTINE', 'IGF_GR_ATTEND_PELL_PKG.INSERT_ROW');
302: igs_ge_msg_stack.add;
303: app_exception.raise_exception;
304: END IF;
297: x_last_update_login := -1;
298: END IF;
299: ELSE
300: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
301: fnd_message.set_token ('ROUTINE', 'IGF_GR_ATTEND_PELL_PKG.INSERT_ROW');
302: igs_ge_msg_stack.add;
303: app_exception.raise_exception;
304: END IF;
305:
390:
391: OPEN c1;
392: FETCH c1 INTO tlinfo;
393: IF (c1%notfound) THEN
394: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
395: igs_ge_msg_stack.add;
396: CLOSE c1;
397: app_exception.raise_exception;
398: RETURN;
408: AND ((tlinfo.atd_entity_id_txt = x_atd_entity_id_txt) OR ((tlinfo.atd_entity_id_txt IS NULL) AND (x_atd_entity_id_txt IS NULL)))
409: ) THEN
410: NULL;
411: ELSE
412: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
413: igs_ge_msg_stack.add;
414: app_exception.raise_exception;
415: END IF;
416:
458: IF (x_last_update_login IS NULL) THEN
459: x_last_update_login := -1;
460: END IF;
461: ELSE
462: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
463: fnd_message.set_token ('ROUTINE', 'IGF_GR_ATTEND_PELL_PKG.UPDATE_ROW');
464: igs_ge_msg_stack.add;
465: app_exception.raise_exception;
466: END IF;
459: x_last_update_login := -1;
460: END IF;
461: ELSE
462: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
463: fnd_message.set_token ('ROUTINE', 'IGF_GR_ATTEND_PELL_PKG.UPDATE_ROW');
464: igs_ge_msg_stack.add;
465: app_exception.raise_exception;
466: END IF;
467:
602: new_references.ci_sequence_number,
603: new_references.attending_pell_cd
604: )
605: ) THEN
606: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
607: igs_ge_msg_stack.add;
608: app_exception.raise_exception;
609: END IF;
610:
617: new_references.ci_sequence_number,
618: new_references.atd_entity_id_txt
619: )
620: ) THEN
621: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
622: igs_ge_msg_stack.add;
623: app_exception.raise_exception;
624: END IF;
625: END IF;