[Home] [Help]
48: OPEN cur_old_ref_values;
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;
99: NULL;
100: ELSIF NOT igs_fi_bill_pkg.get_pk_for_validation (
101: new_references.bill_id
102: ) THEN
103: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
104: igs_ge_msg_stack.add;
105: app_exception.raise_exception;
106: END IF;
107:
110: NULL;
111: ELSIF NOT igf_aw_fund_mast_pkg.get_pk_for_validation (
112: new_references.fund_id
113: ) THEN
114: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
115: igs_ge_msg_stack.add;
116: app_exception.raise_exception;
117: END IF;
118:
124: ELSIF NOT igs_ca_inst_pkg.get_pk_for_validation (
125: new_references.fee_cal_type,
126: new_references.fee_ci_sequence_number
127: ) THEN
128: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
129: igs_ge_msg_stack.add;
130: app_exception.raise_exception;
131: END IF;
132:
138: ELSIF NOT igf_aw_awd_disb_pkg.get_pk_for_validation (
139: new_references.award_id,
140: new_references.disb_num
141: ) THEN
142: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
143: igs_ge_msg_stack.add;
144: app_exception.raise_exception;
145: END IF;
146:
210: OPEN cur_rowid;
211: FETCH cur_rowid INTO lv_rowid;
212: IF (cur_rowid%FOUND) THEN
213: CLOSE cur_rowid;
214: fnd_message.set_name ('IGS', 'IGS_FI_FIPC_FBLLA_FK');
215: igs_ge_msg_stack.add;
216: app_exception.raise_exception;
217: RETURN;
218: END IF;
245: OPEN cur_rowid;
246: FETCH cur_rowid INTO lv_rowid;
247: IF (cur_rowid%FOUND) THEN
248: CLOSE cur_rowid;
249: fnd_message.set_name ('IGS', 'IGS_FI_FIPC_FMAST_FK');
250: igs_ge_msg_stack.add;
251: app_exception.raise_exception;
252: RETURN;
253: END IF;
282: OPEN cur_rowid;
283: FETCH cur_rowid INTO lv_rowid;
284: IF (cur_rowid%FOUND) THEN
285: CLOSE cur_rowid;
286: fnd_message.set_name ('IGS', 'IGS_FI_FIPC_CI_FK');
287: igs_ge_msg_stack.add;
288: app_exception.raise_exception;
289: RETURN;
290: END IF;
319: OPEN cur_rowid;
320: FETCH cur_rowid INTO lv_rowid;
321: IF (cur_rowid%FOUND) THEN
322: CLOSE cur_rowid;
323: fnd_message.set_name ('IGS', 'IGS_FI_FIPC_ADISB_FK');
324: igs_ge_msg_stack.add;
325: app_exception.raise_exception;
326: RETURN;
327: END IF;
387: new_references.award_id,
388: new_references.disb_num
389: )
390: ) THEN
391: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
392: igs_ge_msg_stack.add;
393: app_exception.raise_exception;
394: END IF;
395: check_parent_existance;
403: new_references.award_id,
404: new_references.disb_num
405: )
406: ) THEN
407: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
408: igs_ge_msg_stack.add;
409: app_exception.raise_exception;
410: END IF;
411: END IF;
478: ELSE
479: x_program_update_date := SYSDATE;
480: END IF;
481: ELSE
482: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
483: igs_ge_msg_stack.add;
484: app_exception.raise_exception;
485: END IF;
486:
594:
595: OPEN c1;
596: FETCH c1 INTO tlinfo;
597: IF (c1%notfound) THEN
598: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
599: igs_ge_msg_stack.add;
600: CLOSE c1;
601: app_exception.raise_exception;
602: RETURN;
612: AND ((tlinfo.bill_desc = x_bill_desc) OR ((tlinfo.bill_desc IS NULL) AND (x_bill_desc IS NULL)))
613: ) THEN
614: NULL;
615: ELSE
616: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
617: igs_ge_msg_stack.add;
618: app_exception.raise_exception;
619: END IF;
620:
669: IF (x_last_update_login IS NULL) THEN
670: x_last_update_login := -1;
671: END IF;
672: ELSE
673: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
674: igs_ge_msg_stack.add;
675: app_exception.raise_exception;
676: END IF;
677: