eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_FI_CREDITS_PKG dependencies on APP_EXCEPTION

Line 125: app_exception.raise_exception;

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;
128: CLOSE cur_old_ref_values;
129:

Line 230: app_exception.raise_exception;

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;
233: END BeforeRowInsertUpdate;
234:

Line 256: app_exception.raise_exception;

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:
259: END check_uniqueness;
260:

Line 323: app_exception.raise_exception;

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;
326:
327: IF (((old_references.status = new_references.status)) OR

Line 336: App_Exception.Raise_Exception;

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:
339: IF (((old_references.credit_source = new_references.credit_source)) OR
340: ((new_references.credit_source IS NULL))) THEN

Line 351: app_exception.raise_exception;

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;
354:
355: IF (((old_references.credit_instrument = new_references.credit_instrument)) OR

Line 364: App_Exception.Raise_Exception;

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.
367: IF (((old_references.reversal_reason_code = new_references.reversal_reason_code)) OR
368: ((new_references.reversal_reason_code IS NULL))) THEN

Line 375: App_Exception.Raise_Exception;

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:
378: IF (((old_references.credit_type_id = new_references.credit_type_id)) OR
379: ((new_references.credit_type_id IS NULL))) THEN

Line 386: app_exception.raise_exception;

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:
389: --removed call to igs_fi_subaccts_pkg.get_pk_for_validation and related code as part of subaccount
390: --removal build.Enh#2564643.

Line 405: app_exception.raise_exception;

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:
408: IF (
409: ((old_references.fee_cal_type = new_references.fee_cal_type) AND

Line 421: app_exception.raise_exception;

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:
424: -- Following check of foreign key has been added as part of Deposits Build, Bug# 2584741
425: IF (((old_references.source_transaction_type = new_references.source_transaction_type)) OR

Line 434: App_Exception.Raise_Exception;

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:
437: -- Following check of foreign key has been added as part of Lockbox Build, Enh#2831582.
438: IF ((old_references.receipt_lockbox_number = new_references.receipt_lockbox_number) OR

Line 445: app_exception.raise_exception;

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:
448: -- Source Invoice Id as a FK with igs_fi_inv_int_all
449: IF ((old_references.source_invoice_id = new_references.source_invoice_id) OR

Line 456: app_exception.raise_exception;

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:
459: END check_parent_existance;
460:

Line 594: app_exception.raise_exception;

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;
597: CLOSE cur_rowid;
598:

Line 631: app_exception.raise_exception;

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;
634: CLOSE cur_rowid;
635:

Line 667: app_exception.raise_exception;

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;
670: CLOSE cur_rowid;
671:

Line 861: app_exception.raise_exception;

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;
864: check_uniqueness;
865: check_parent_existance;

Line 882: app_exception.raise_exception;

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;
885: check_uniqueness;
886: ELSIF (p_action = 'VALIDATE_UPDATE') THEN

Line 1035: app_exception.raise_exception;

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:
1038: SELECT igs_fi_credits_s.NEXTVAL
1039: INTO x_credit_id

Line 1453: app_exception.raise_exception;

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;
1455: END IF;
1456: CLOSE c1;
1457:

Line 1526: app_exception.raise_exception;

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:
1529: RETURN;
1530:

Line 1655: app_exception.raise_exception;

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:
1658: before_dml(
1659: p_action => 'UPDATE',