44: FETCH cur_old_ref_values INTO old_references;
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;
91: ELSIF NOT igf_sl_lender_pkg.get_pk_for_validation (
92: new_references.lender_id
93: ) THEN
94: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
95: igs_ge_msg_stack.add;
96: app_exception.raise_exception;
97: END IF;
98:
99: END check_parent_existance;
138: new_references.party_id
139: )
140: ) THEN
141: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
142: igs_ge_msg_stack.add;
143: app_exception.raise_exception;
144: END IF;
145:
146: END check_uniqueness;
207: FETCH cur_rowid INTO lv_rowid;
208: IF (cur_rowid%FOUND) THEN
209: CLOSE cur_rowid;
210: fnd_message.set_name ('IGF', 'IGF_SL_LNDB_LND_FK');
211: igs_ge_msg_stack.add;
212: app_exception.raise_exception;
213: RETURN;
214: END IF;
215: CLOSE cur_rowid;
298: new_references.lend_non_ed_brc_id
299: )
300: ) THEN
301: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
302: igs_ge_msg_stack.add;
303: app_exception.raise_exception;
304: END IF;
305: check_parent_existance;
306: check_uniqueness;
318: new_references.lend_non_ed_brc_id
319: )
320: ) THEN
321: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
322: igs_ge_msg_stack.add;
323: app_exception.raise_exception;
324: END IF;
325: check_uniqueness;
326: ELSIF (p_action = 'VALIDATE_DELETE') THEN
374: x_last_update_login := -1;
375: END IF;
376: ELSE
377: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
378: igs_ge_msg_stack.add;
379: app_exception.raise_exception;
380: END IF;
381:
382: before_dml(
462: OPEN c1;
463: FETCH c1 INTO tlinfo;
464: IF (c1%notfound) THEN
465: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
466: igs_ge_msg_stack.add;
467: CLOSE c1;
468: app_exception.raise_exception;
469: RETURN;
470: END IF;
477: ) THEN
478: NULL;
479: ELSE
480: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
481: igs_ge_msg_stack.add;
482: app_exception.raise_exception;
483: END IF;
484:
485: RETURN;
525: x_last_update_login := -1;
526: END IF;
527: ELSE
528: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
529: igs_ge_msg_stack.add;
530: app_exception.raise_exception;
531: END IF;
532:
533: before_dml(