54: OPEN cur_old_ref_values;
55: FETCH cur_old_ref_values INTO old_references;
56: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
57: CLOSE cur_old_ref_values;
58: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
59: igs_ge_msg_stack.add;
60: app_exception.raise_exception;
61: RETURN;
62: END IF;
104: NULL;
105: ELSIF NOT igf_aw_award_pkg.get_pk_for_validation (
106: new_references.award_id
107: ) THEN
108: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
109: igs_ge_msg_stack.add;
110: app_exception.raise_exception;
111: END IF;
112: END check_parent_existance;
174: OPEN cur_rowid;
175: FETCH cur_rowid INTO lv_rowid;
176: IF (cur_rowid%FOUND) THEN
177: CLOSE cur_rowid;
178: fnd_message.set_name ('IGF', 'IGF_AW_AWD_DBCOD_FK');
179: igs_ge_msg_stack.add;
180: app_exception.raise_exception;
181: RETURN;
182: END IF;
211: OPEN cur_rowid;
212: FETCH cur_rowid INTO lv_rowid;
213: IF (cur_rowid%FOUND) THEN
214: CLOSE cur_rowid;
215: fnd_message.set_name ('IGF', 'IGF_DB_DISB_DBCOD_FK');
216: igs_ge_msg_stack.add;
217: app_exception.raise_exception;
218: RETURN;
219: END IF;
291: new_references.disb_num,
292: new_references.disb_seq_num
293: )
294: ) THEN
295: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
296: igs_ge_msg_stack.add;
297: app_exception.raise_exception;
298: END IF;
299: check_parent_existance;
309: new_references.disb_num,
310: new_references.disb_seq_num
311: )
312: ) THEN
313: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
314: igs_ge_msg_stack.add;
315: app_exception.raise_exception;
316: END IF;
317: END IF;
391: ELSE
392: x_program_update_date := SYSDATE;
393: END IF;
394: ELSE
395: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
396: fnd_message.set_token ('ROUTINE', 'IGF_AW_DB_COD_DTLS_PKG.INSERT_ROW');
397: igs_ge_msg_stack.add;
398: app_exception.raise_exception;
399: END IF;
392: x_program_update_date := SYSDATE;
393: END IF;
394: ELSE
395: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
396: fnd_message.set_token ('ROUTINE', 'IGF_AW_DB_COD_DTLS_PKG.INSERT_ROW');
397: igs_ge_msg_stack.add;
398: app_exception.raise_exception;
399: END IF;
400:
543:
544: OPEN c1;
545: FETCH c1 INTO tlinfo;
546: IF (c1%notfound) THEN
547: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
548: igs_ge_msg_stack.add;
549: CLOSE c1;
550: app_exception.raise_exception;
551: RETURN;
568: 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)))
569: ) THEN
570: NULL;
571: ELSE
572: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
573: igs_ge_msg_stack.add;
574: app_exception.raise_exception;
575: END IF;
576:
631: IF (x_last_update_login IS NULL) THEN
632: x_last_update_login := -1;
633: END IF;
634: ELSE
635: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
636: fnd_message.set_token ('ROUTINE', 'IGF_AW_DB_COD_DTLS_PKG.UPDATE_ROW');
637: igs_ge_msg_stack.add;
638: app_exception.raise_exception;
639: END IF;
632: x_last_update_login := -1;
633: END IF;
634: ELSE
635: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
636: fnd_message.set_token ('ROUTINE', 'IGF_AW_DB_COD_DTLS_PKG.UPDATE_ROW');
637: igs_ge_msg_stack.add;
638: app_exception.raise_exception;
639: END IF;
640: