[Home] [Help]
76: OPEN cur_old_ref_values;
77: FETCH cur_old_ref_values INTO old_references;
78: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
79: CLOSE cur_old_ref_values;
80: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
81: igs_ge_msg_stack.add;
82: app_exception.raise_exception;
83: RETURN;
84: END IF;
162: NULL;
163: ELSIF NOT igs_fi_refunds_pkg.get_pk_for_validation (
164: new_references.refund_id
165: ) THEN
166: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
167: igs_ge_msg_stack.add;
168: app_exception.raise_exception;
169: END IF;
170:
175: OPEN cur_hzp(new_references.person_id);
176: FETCH cur_hzp INTO l_var;
177: IF cur_hzp%NOTFOUND THEN
178: CLOSE cur_hzp;
179: fnd_message.set_name('FND','FORM_RECORD_DELETED');
180: igs_ge_msg_stack.add;
181: app_exception.raise_exception;
182: END IF;
183: CLOSE cur_hzp;
190: OPEN cur_hzp(new_references.pay_person_id);
191: FETCH cur_hzp INTO l_var;
192: IF cur_hzp%NOTFOUND THEN
193: CLOSE cur_hzp;
194: fnd_message.set_name('FND','FORM_RECORD_DELETED');
195: igs_ge_msg_stack.add;
196: app_exception.raise_exception;
197: END IF;
198: CLOSE cur_hzp;
209: new_references.fee_type,
210: new_references.fee_cal_type,
211: new_references.fee_ci_sequence_number
212: ) THEN
213: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
214: igs_ge_msg_stack.add;
215: app_exception.raise_exception;
216: END IF;
217:
220: NULL;
221: ELSIF NOT igs_fi_acc_pkg.get_pk_for_validation (
222: new_references.dr_account_cd
223: ) THEN
224: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
225: igs_ge_msg_stack.add;
226: app_exception.raise_exception;
227: END IF;
228:
231: NULL;
232: ELSIF NOT igs_fi_acc_pkg.get_pk_for_validation (
233: new_references.cr_account_cd
234: ) THEN
235: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
236: igs_ge_msg_stack.add;
237: app_exception.raise_exception;
238: END IF;
239:
242: NULL;
243: ELSIF NOT igs_fi_inv_int_pkg.get_pk_for_validation (
244: new_references.invoice_id
245: ) THEN
246: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
247: igs_ge_msg_stack.add;
248: app_exception.raise_exception;
249: END IF;
250:
253: NULL;
254: ELSIF NOT igs_fi_refund_int_pkg.get_pk_for_validation (
255: new_references.source_refund_id
256: ) THEN
257: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
258: igs_ge_msg_stack.add;
259: app_exception.raise_exception;
260: END IF;
261:
340: OPEN cur_rowid;
341: FETCH cur_rowid INTO lv_rowid;
342: IF (cur_rowid%FOUND) THEN
343: CLOSE cur_rowid;
344: fnd_message.set_name ('IGS', 'IGS_FI_RFND_RINT_FK');
345: igs_ge_msg_stack.add;
346: app_exception.raise_exception;
347: RETURN;
348: END IF;
375: OPEN cur_rowid;
376: FETCH cur_rowid INTO lv_rowid;
377: IF (cur_rowid%FOUND) THEN
378: CLOSE cur_rowid;
379: fnd_message.set_name ('IGS', 'IGS_FI_INV_RINT_FK');
380: igs_ge_msg_stack.add;
381: app_exception.raise_exception;
382: RETURN;
383: END IF;
410: OPEN cur_rowid;
411: FETCH cur_rowid INTO lv_rowid;
412: IF (cur_rowid%FOUND) THEN
413: CLOSE cur_rowid;
414: fnd_message.set_name ('IGS', 'IGS_FI_RINT_RINT_FK');
415: igs_ge_msg_stack.add;
416: app_exception.raise_exception;
417: RETURN;
418: END IF;
532: IF ( get_pk_for_validation(
533: new_references.refund_id
534: )
535: ) THEN
536: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
537: igs_ge_msg_stack.add;
538: app_exception.raise_exception;
539: END IF;
540: check_parent_existance;
549: IF ( get_pk_for_validation (
550: new_references.refund_id
551: )
552: ) THEN
553: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
554: igs_ge_msg_stack.add;
555: app_exception.raise_exception;
556: END IF;
557: ELSIF (p_action = 'VALIDATE_DELETE') THEN
654: ELSE
655: x_program_update_date := SYSDATE;
656: END IF;
657: ELSE
658: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
659: igs_ge_msg_stack.add;
660: app_exception.raise_exception;
661: END IF;
662:
918:
919: OPEN c1;
920: FETCH c1 INTO tlinfo;
921: IF (c1%notfound) THEN
922: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
923: igs_ge_msg_stack.add;
924: CLOSE c1;
925: app_exception.raise_exception;
926: RETURN;
966: AND ((TRUNC(tlinfo.gl_date) = TRUNC(x_gl_date)) OR ((tlinfo.gl_date IS NULL) AND (X_gl_date IS NULL)))
967: ) THEN
968: NULL;
969: ELSE
970: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
971: igs_ge_msg_stack.add;
972: app_exception.raise_exception;
973: END IF;
974:
1051: IF (x_last_update_login IS NULL) THEN
1052: x_last_update_login := -1;
1053: END IF;
1054: ELSE
1055: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1056: igs_ge_msg_stack.add;
1057: app_exception.raise_exception;
1058: END IF;
1059: