[Home] [Help]
47: OPEN cur_old_ref_values;
48: FETCH cur_old_ref_values INTO old_references;
49: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
50: CLOSE cur_old_ref_values;
51: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
52: igs_ge_msg_stack.add;
53: app_exception.raise_exception;
54: RETURN;
55: END IF;
97: new_references.transaction_type,
98: new_references.invoice_creditact_id
99: )
100: ) THEN
101: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
102: igs_ge_msg_stack.add;
103: app_exception.raise_exception;
104: END IF;
105:
124: NULL;
125: ELSIF NOT igs_fi_inv_int_pkg.get_pk_for_validation (
126: new_references.invoice_creditact_id
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: END IF;
135: NULL;
136: ELSIF NOT igs_fi_bill_pkg.get_pk_for_validation (
137: new_references.bill_id
138: ) THEN
139: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
140: igs_ge_msg_stack.add;
141: app_exception.raise_exception;
142: END IF;
143:
147: NULL;
148: ELSIF NOT igs_fi_cr_activities_pkg.get_pk_for_validation (
149: new_references.invoice_creditact_id
150: ) THEN
151: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
152: igs_ge_msg_stack.add;
153: app_exception.raise_exception;
154: END IF;
155: END IF;
253: OPEN cur_rowid;
254: FETCH cur_rowid INTO lv_rowid;
255: IF (cur_rowid%FOUND) THEN
256: CLOSE cur_rowid;
257: fnd_message.set_name ('IGS', 'IGS_FI_BILL_TRANS_INV_INT_FK');
258: igs_ge_msg_stack.add;
259: app_exception.raise_exception;
260: RETURN;
261: END IF;
288: OPEN cur_rowid;
289: FETCH cur_rowid INTO lv_rowid;
290: IF (cur_rowid%FOUND) THEN
291: CLOSE cur_rowid;
292: fnd_message.set_name ('IGS', 'IGS_FI_BILL_TRANS_BILL_FK');
293: igs_ge_msg_stack.add;
294: app_exception.raise_exception;
295: RETURN;
296: END IF;
323: OPEN cur_rowid;
324: FETCH cur_rowid INTO lv_rowid;
325: IF (cur_rowid%FOUND) THEN
326: CLOSE cur_rowid;
327: fnd_message.set_name ('IGS', 'IGS_FI_BILL_TRANS_CR_ACT_FK');
328: igs_ge_msg_stack.add;
329: app_exception.raise_exception;
330: RETURN;
331: END IF;
388: IF ( get_pk_for_validation(
389: new_references.transaction_id
390: )
391: ) THEN
392: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
393: igs_ge_msg_stack.add;
394: app_exception.raise_exception;
395: END IF;
396: check_uniqueness;
404: IF ( get_pk_for_validation (
405: new_references.transaction_id
406: )
407: ) THEN
408: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
409: igs_ge_msg_stack.add;
410: app_exception.raise_exception;
411: END IF;
412: check_uniqueness;
479: ELSE
480: x_program_update_date := SYSDATE;
481: END IF;
482: ELSE
483: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
484: igs_ge_msg_stack.add;
485: app_exception.raise_exception;
486: END IF;
487:
600:
601: OPEN c1;
602: FETCH c1 INTO tlinfo;
603: IF (c1%notfound) THEN
604: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
605: igs_ge_msg_stack.add;
606: CLOSE c1;
607: app_exception.raise_exception;
608: RETURN;
620: AND (tlinfo.transaction_amount = x_transaction_amount)
621: ) THEN
622: NULL;
623: ELSE
624: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
625: igs_ge_msg_stack.add;
626: app_exception.raise_exception;
627: END IF;
628:
676: IF (x_last_update_login IS NULL) THEN
677: x_last_update_login := -1;
678: END IF;
679: ELSE
680: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
681: igs_ge_msg_stack.add;
682: app_exception.raise_exception;
683: END IF;
684: