[Home] [Help]
119: OPEN cur_old_ref_values;
120: FETCH cur_old_ref_values INTO old_references;
121: IF ((cur_old_ref_values%NOTFOUND) AND (p_action NOT IN ('INSERT', 'VALIDATE_INSERT'))) THEN
122: CLOSE cur_old_ref_values;
123: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
124: igs_ge_msg_stack.add;
125: app_exception.raise_exception;
126: RETURN;
127: END IF;
221: --If reversal date specified in reversal form is less than payment date of a credit,
222: IF TRUNC(new_references.reversal_date) IS NOT NULL THEN
223: IF (TRUNC(new_references.reversal_date) < TRUNC(new_references.transaction_date)) THEN
224: --Throw error message
225: fnd_message.set_name('IGS','IGS_FI_REV_DT_LESS_RECT_DT');
226: fnd_message.set_token('REVDATE',TRUNC(new_references.reversal_date));
227: fnd_message.set_token('PMTDATE',TRUNC(new_references.transaction_date));
228: fnd_message.set_token('CREDIT',new_references.credit_number);
229: igs_ge_msg_stack.add;
222: IF TRUNC(new_references.reversal_date) IS NOT NULL THEN
223: IF (TRUNC(new_references.reversal_date) < TRUNC(new_references.transaction_date)) THEN
224: --Throw error message
225: fnd_message.set_name('IGS','IGS_FI_REV_DT_LESS_RECT_DT');
226: fnd_message.set_token('REVDATE',TRUNC(new_references.reversal_date));
227: fnd_message.set_token('PMTDATE',TRUNC(new_references.transaction_date));
228: fnd_message.set_token('CREDIT',new_references.credit_number);
229: igs_ge_msg_stack.add;
230: app_exception.raise_exception;
223: IF (TRUNC(new_references.reversal_date) < TRUNC(new_references.transaction_date)) THEN
224: --Throw error message
225: fnd_message.set_name('IGS','IGS_FI_REV_DT_LESS_RECT_DT');
226: fnd_message.set_token('REVDATE',TRUNC(new_references.reversal_date));
227: fnd_message.set_token('PMTDATE',TRUNC(new_references.transaction_date));
228: fnd_message.set_token('CREDIT',new_references.credit_number);
229: igs_ge_msg_stack.add;
230: app_exception.raise_exception;
231: END IF;
224: --Throw error message
225: fnd_message.set_name('IGS','IGS_FI_REV_DT_LESS_RECT_DT');
226: fnd_message.set_token('REVDATE',TRUNC(new_references.reversal_date));
227: fnd_message.set_token('PMTDATE',TRUNC(new_references.transaction_date));
228: fnd_message.set_token('CREDIT',new_references.credit_number);
229: igs_ge_msg_stack.add;
230: app_exception.raise_exception;
231: END IF;
232: END IF;
250: new_references.credit_number,
251: new_references.party_id
252: )
253: ) THEN
254: fnd_message.set_name ('IGS', 'IGS_FI_CREDIT_DUPLICATE');
255: igs_ge_msg_stack.add;
256: app_exception.raise_exception;
257: END IF;
258:
317: IF (cur_rowid%FOUND) THEN
318: CLOSE cur_rowid;
319: ELSE
320: CLOSE cur_rowid;
321: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
322: igs_ge_msg_stack.add;
323: app_exception.raise_exception;
324: END IF;
325: END IF;
330: ELSIF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation(
331: 'IGS_FI_CREDIT_STATUS',
332: new_references.status
333: )THEN
334: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
335: IGS_GE_MSG_STACK.ADD;
336: App_Exception.Raise_Exception;
337: END IF;
338:
345: IF (cur_igf_lookup%FOUND) THEN
346: CLOSE cur_igf_lookup;
347: ELSE
348: CLOSE cur_igf_lookup;
349: fnd_message.set_name ('FND','FORM_RECORD_DELETED');
350: igs_ge_msg_stack.add;
351: app_exception.raise_exception;
352: END IF;
353: END IF;
358: ELSIF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation(
359: 'IGS_FI_CREDIT_INSTRUMENT',
360: new_references.credit_instrument
361: )THEN
362: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
363: IGS_GE_MSG_STACK.ADD;
364: App_Exception.Raise_Exception;
365: END IF;
366: --Added the IGS_FI_WAV_REVERSAL_REASON lookup code validation as a part of Tution Waiver Build.
369: NULL;
370: ELSIF NOT ( IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation('IGS_FI_REVERSAL_REASON',new_references.reversal_reason_code)
371: OR IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation('IGS_FI_WAV_REVERSAL_REASON',new_references.reversal_reason_code)
372: )THEN
373: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
374: IGS_GE_MSG_STACK.ADD;
375: App_Exception.Raise_Exception;
376: END IF;
377:
380: NULL;
381: ELSIF NOT igs_fi_cr_types_pkg.get_pk_for_validation (
382: new_references.credit_type_id
383: ) THEN
384: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
385: igs_ge_msg_stack.add;
386: app_exception.raise_exception;
387: END IF;
388:
399: NULL;
400: ELSIF NOT igs_ca_inst_pkg.get_pk_for_validation (
401: new_references.awd_yr_cal_type , new_references.awd_yr_ci_sequence_number
402: ) THEN
403: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
404: igs_ge_msg_stack.add;
405: app_exception.raise_exception;
406: END IF;
407:
415: NULL;
416: ELSIF NOT igs_ca_inst_pkg.get_pk_for_validation (
417: new_references.fee_cal_type , new_references.fee_ci_sequence_number
418: ) THEN
419: fnd_message.set_name ('FND', 'FORM_RECORD_DELETED');
420: igs_ge_msg_stack.add;
421: app_exception.raise_exception;
422: END IF;
423:
428: ELSIF NOT IGS_LOOKUPS_VIEW_PKG.Get_PK_For_Validation(
429: 'IGS_FI_SOURCE_TRANSACTION_REF',
430: new_references.source_transaction_type
431: )THEN
432: Fnd_Message.Set_Name ('FND', 'FORM_RECORD_DELETED');
433: IGS_GE_MSG_STACK.ADD;
434: App_Exception.Raise_Exception;
435: END IF;
436:
439: (new_references.receipt_lockbox_number IS NULL)
440: ) THEN
441: NULL;
442: ELSIF NOT igs_fi_lockboxes_pkg.get_pk_for_validation(new_references.receipt_lockbox_number)THEN
443: fnd_message.set_name('FND','FORM_RECORD_DELETED');
444: igs_ge_msg_stack.add;
445: app_exception.raise_exception;
446: END IF;
447:
450: (new_references.source_invoice_id IS NULL)
451: ) THEN
452: NULL;
453: ELSIF NOT igs_fi_inv_int_pkg.get_pk_for_validation(new_references.source_invoice_id) THEN
454: fnd_message.set_name('FND','FORM_RECORD_DELETED');
455: igs_ge_msg_stack.add;
456: app_exception.raise_exception;
457: END IF;
458:
588: OPEN cur_rowid;
589: FETCH cur_rowid INTO lv_rowid;
590: IF (cur_rowid%FOUND) THEN
591: CLOSE cur_rowid;
592: fnd_message.set_name ('IGS', 'IGS_FI_CRDT_CRTY_FK');
593: igs_ge_msg_stack.add;
594: app_exception.raise_exception;
595: RETURN;
596: END IF;
625: OPEN cur_rowid;
626: FETCH cur_rowid INTO lv_rowid;
627: IF (cur_rowid%FOUND) THEN
628: CLOSE cur_rowid;
629: fnd_message.set_name ('IGS', 'IGS_FI_CRD_CI_FK');
630: igs_ge_msg_stack.add;
631: app_exception.raise_exception;
632: RETURN;
633: END IF;
661: OPEN cur_rowid;
662: FETCH cur_rowid INTO lv_rowid;
663: IF (cur_rowid%FOUND) THEN
664: CLOSE cur_rowid;
665: fnd_message.set_name ('IGS', 'IGS_FI_FTCI_CI_FK');
666: igs_ge_msg_stack.add;
667: app_exception.raise_exception;
668: RETURN;
669: END IF;
855: IF ( get_pk_for_validation(
856: new_references.credit_id
857: )
858: ) THEN
859: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
860: igs_ge_msg_stack.add;
861: app_exception.raise_exception;
862: END IF;
863: BeforeRowInsertUpdate;
876: IF ( get_pk_for_validation (
877: new_references.credit_id
878: )
879: ) THEN
880: fnd_message.set_name('IGS','IGS_GE_RECORD_ALREADY_EXISTS');
881: igs_ge_msg_stack.add;
882: app_exception.raise_exception;
883: END IF;
884: BeforeRowInsertUpdate;
1029: ELSE
1030: x_program_update_date := SYSDATE;
1031: END IF;
1032: ELSE
1033: fnd_message.set_name ('FND', 'SYSTEM-INVALID ARGS');
1034: igs_ge_msg_stack.add;
1035: app_exception.raise_exception;
1036: END IF;
1037:
1446:
1447: OPEN c1;
1448: FETCH c1 INTO tlinfo;
1449: IF (c1%notfound) THEN
1450: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
1451: igs_ge_msg_stack.add;
1452: CLOSE c1;
1453: app_exception.raise_exception;
1454: RETURN;
1520: AND ((tlinfo.waiver_name = x_waiver_name) OR ((tlinfo.waiver_name IS NULL) AND (x_waiver_name IS NULL)))
1521: ) THEN
1522: NULL;
1523: ELSE
1524: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
1525: igs_ge_msg_stack.add;
1526: app_exception.raise_exception;
1527: END IF;
1528:
1649: IF (x_last_update_login IS NULL) THEN
1650: x_last_update_login := -1;
1651: END IF;
1652: ELSE
1653: fnd_message.set_name( 'FND', 'SYSTEM-INVALID ARGS');
1654: igs_ge_msg_stack.add;
1655: app_exception.raise_exception;
1656: END IF;
1657: