[Home] [Help]
180: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
181: CLOSE cur_old_ref_values;
182: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
183: igs_ge_msg_stack.add;
184: app_exception.raise_exception;
185: RETURN;
186: END IF;
187: CLOSE cur_old_ref_values;
188:
266: )
267: ) THEN
268: fnd_message.set_name ('IGS', 'IGS_GE_RECORD_ALREADY_EXISTS');
269: igs_ge_msg_stack.add;
270: app_exception.raise_exception;
271: END IF;
272:
273: END check_uniqueness;
274:
304: ELSE
305: CLOSE cur_rowid;
306: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
307: igs_ge_msg_stack.add;
308: app_exception.raise_exception;
309: END IF;
310: END IF;
311:
312: IF (((old_references.pay_person_id = new_references.pay_person_id)) OR
320: ELSE
321: CLOSE cur_rowid;
322: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
323: igs_ge_msg_stack.add;
324: app_exception.raise_exception;
325: END IF;
326: END IF;
327:
328: IF (((old_references.transfer_status = new_references.transfer_status)) OR
331: ELSIF NOT igs_lookups_view_pkg.get_pk_for_validation('REFUND_TRANSFER_STATUS',
332: new_references.transfer_status)THEN
333: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
334: IGS_GE_MSG_STACK.ADD;
335: App_Exception.Raise_Exception;
336: END IF;
337:
338: IF (((old_references.dr_account_cd = new_references.dr_account_cd)) OR
339: ((new_references.dr_account_cd IS NULL))) THEN
342: new_references.dr_account_cd
343: ) THEN
344: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
345: igs_ge_msg_stack.add;
346: app_exception.raise_exception;
347: END IF;
348:
349: IF (((old_references.cr_account_cd = new_references.cr_account_cd)) OR
350: ((new_references.cr_account_cd IS NULL))) THEN
353: new_references.cr_account_cd
354: ) THEN
355: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
356: igs_ge_msg_stack.add;
357: app_exception.raise_exception;
358: END IF;
359:
360: IF (((old_references.fee_cal_type = new_references.fee_cal_type) AND
361: (old_references.fee_ci_sequence_number = new_references.fee_ci_sequence_number) AND
368: new_references.fee_cal_type,
369: new_references.fee_ci_sequence_number ) THEN
370: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
371: igs_ge_msg_stack.add;
372: app_exception.raise_exception;
373: END IF;
374:
375: IF (((old_references.source_refund_id = new_references.source_refund_id)) OR
376: ((new_references.source_refund_id IS NULL))) THEN
379: new_references.source_refund_id
380: ) THEN
381: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
382: igs_ge_msg_stack.add;
383: app_exception.raise_exception;
384: END IF;
385:
386: IF (((old_references.invoice_id = new_references.invoice_id)) OR
387: ((new_references.invoice_id IS NULL))) THEN
390: new_references.invoice_id
391: ) THEN
392: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
393: igs_ge_msg_stack.add;
394: app_exception.raise_exception;
395: END IF;
396:
397: END check_parent_existance;
398:
528: IF (cur_rowid%FOUND) THEN
529: CLOSE cur_rowid;
530: fnd_message.set_name ('IGS', 'IGS_FI_RFND_RFND_FK');
531: igs_ge_msg_stack.add;
532: app_exception.raise_exception;
533: RETURN;
534: END IF;
535: CLOSE cur_rowid;
536:
564: IF (cur_rowid%FOUND) THEN
565: CLOSE cur_rowid;
566: fnd_message.set_name ('IGS', 'IGS_FI_INV_RFND_FK');
567: igs_ge_msg_stack.add;
568: app_exception.raise_exception;
569: RETURN;
570: END IF;
571: CLOSE cur_rowid;
572:
693: )
694: ) THEN
695: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
696: igs_ge_msg_stack.add;
697: app_exception.raise_exception;
698: END IF;
699: check_uniqueness;
700: check_parent_existance;
701: beforerowinsert;
713: )
714: ) THEN
715: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
716: igs_ge_msg_stack.add;
717: app_exception.raise_exception;
718: END IF;
719: check_uniqueness;
720: ELSIF (p_action = 'VALIDATE_UPDATE') THEN
721: check_uniqueness;
824: END IF;
825: ELSE
826: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
827: igs_ge_msg_stack.add;
828: app_exception.raise_exception;
829: END IF;
830:
831: SELECT igs_fi_refunds_s.NEXTVAL
832: INTO x_refund_id
1103: IF (c1%notfound) THEN
1104: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1105: igs_ge_msg_stack.add;
1106: CLOSE c1;
1107: app_exception.raise_exception;
1108: RETURN;
1109: END IF;
1110: CLOSE c1;
1111:
1153: NULL;
1154: ELSE
1155: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1156: igs_ge_msg_stack.add;
1157: app_exception.raise_exception;
1158: END IF;
1159:
1160: RETURN;
1161:
1243: END IF;
1244: ELSE
1245: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1246: igs_ge_msg_stack.add;
1247: app_exception.raise_exception;
1248: END IF;
1249:
1250: before_dml(
1251: p_action => 'UPDATE',
1646: IF l_currency_cd IS NULL AND l_message_name IS NOT NULL
1647: THEN
1648: fnd_message.set_name('IGS',l_message_name);
1649: igs_ge_msg_stack.add;
1650: app_exception.raise_exception;
1651: END IF;
1652:
1653: -- Fetch the Fee Type description
1654: OPEN cur_ft_desc(new_references.fee_type);
1749: 'IGS_FI_ERR_TXT');
1750: FND_MESSAGE.Set_Token('TEXT',
1751: l_msg);
1752: IGS_GE_MSG_STACK.Add;
1753: APP_EXCEPTION.RAISE_EXCEPTION;
1754: ELSE
1755: FOR l_count IN 1 .. l_msg_count LOOP
1756: l_msg := l_msg||FND_MSG_PUB.GET (p_msg_index => l_count, p_encoded => 'T');
1757: END LOOP;
1758: FND_MESSAGE.Set_Name('IGS',
1759: 'IGS_FI_ERR_TXT');
1760: FND_MESSAGE.Set_Token('TEXT',
1761: l_msg);
1762: APP_EXCEPTION.RAISE_EXCEPTION;
1763: END IF;
1764: ELSE
1765: new_references.invoice_id := NVL(l_invoice_id,new_references.invoice_id);
1766: