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_PRC_REFUNDS dependencies on IGS_FI_REFUNDS

Line 13: removed the obsoleted columns from the IGS_FI_REFUNDS_PKG

9: Known limitations,enhancements,remarks:
10: Change History
11: Who When What
12: skharida 26-Jun-2006 Bug# 5208136 - Modified pocess_plus and process_batch procedure,
13: removed the obsoleted columns from the IGS_FI_REFUNDS_PKG
14: abshriva 9-JUN-2006 Bug 5076169 Modified procedure process_batch
15: sapanigr 03-May-2006 Enh#3924836 Precision Issue. Modified process_batch and process_plus.
16: sapanigr 24-Feb-2006 Bug 5018036 - Removed cur_pnum in process_batch for R12 repository performance tuning
17: sapanigr 14-Feb-2006 Bug 5018036. Cursors modified in procedure process_batch for R12 repository performance tuning

Line 162: FUNCTION val_rfnd_lim(p_refund_amnt igs_fi_refunds.refund_amount%TYPE) RETURN BOOLEAN AS

158: fnd_file.put_line(fnd_file.log,
159: l_message);
160: END log_message;
161:
162: FUNCTION val_rfnd_lim(p_refund_amnt igs_fi_refunds.refund_amount%TYPE) RETURN BOOLEAN AS
163: /***********************************************************************************************
164:
165: Created By : Amit Gairola
166: Date Created By: 11-Mar-2002

Line 227: skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_REFUNDS

223: This procedure processes the refunds for the PLUS loan.
224: Known limitations,enhancements,remarks:
225: Change History
226: Who When What
227: skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_REFUNDS
228: sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted into igs_fi_refunds
229: is now rounded off to currency precision
230: pathipat 24-Apr-2003 Enh 2831569 - Commercial Receivables build
231: Added check for manage_accounts - call to chk_manage_account()

Line 228: sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted into igs_fi_refunds

224: Known limitations,enhancements,remarks:
225: Change History
226: Who When What
227: skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_REFUNDS
228: sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted into igs_fi_refunds
229: is now rounded off to currency precision
230: pathipat 24-Apr-2003 Enh 2831569 - Commercial Receivables build
231: Added check for manage_accounts - call to chk_manage_account()
232: smadathi 21-Feb-2002 Enh. Bug 2747329. Added validation for refund_cr_gl_ccid

Line 238: ii)igs_fi_refunds_pkg.insert_row iii)igs_fi_gen_007.create_application.

234: smadathi 15-Jan-2003 Bug 2722096. Incorporated logging of error message raised by the mass_apply
235: process call.
236: vvutukur 19-Nov-2002 Enh#2584986.Code added to validate the mandatory newly added IN parameter p_d_gl_date.
237: Passed this p_d_gl_date parameter to the calls to i)igs_fi_prc_appl.mass_apply,
238: ii)igs_fi_refunds_pkg.insert_row iii)igs_fi_gen_007.create_application.
239: shtatiko 24-Sep-2002 Bug No: 2564643 Removed references to Subaccount_id.
240: agairola 13-Jun-2002 Bug No: 2408221 For the Application Hierarchy, added the check for effective
241: start and end date
242: agairola 11-Jun-2002 Bug No: 2408221 added the validation for Application Hierarchy

Line 284: l_dr_gl_ccid igs_fi_refunds.dr_gl_ccid%TYPE;

280: -- Variables of data type as the column of a table
281: l_fee_type igs_fi_fee_type.fee_type%TYPE;
282: l_fee_cal_type igs_ca_inst.cal_type%TYPE;
283: l_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
284: l_dr_gl_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
285: l_cr_gl_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
286: l_dr_account_cd igs_fi_refunds.dr_account_cd%TYPE;
287: l_cr_account_cd igs_fi_refunds.cr_account_cd%TYPE;
288: l_rowid igs_fi_refunds_v.row_id%TYPE;

Line 285: l_cr_gl_ccid igs_fi_refunds.cr_gl_ccid%TYPE;

281: l_fee_type igs_fi_fee_type.fee_type%TYPE;
282: l_fee_cal_type igs_ca_inst.cal_type%TYPE;
283: l_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
284: l_dr_gl_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
285: l_cr_gl_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
286: l_dr_account_cd igs_fi_refunds.dr_account_cd%TYPE;
287: l_cr_account_cd igs_fi_refunds.cr_account_cd%TYPE;
288: l_rowid igs_fi_refunds_v.row_id%TYPE;
289: l_refund_id igs_fi_refunds.refund_id%TYPE;

Line 286: l_dr_account_cd igs_fi_refunds.dr_account_cd%TYPE;

282: l_fee_cal_type igs_ca_inst.cal_type%TYPE;
283: l_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
284: l_dr_gl_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
285: l_cr_gl_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
286: l_dr_account_cd igs_fi_refunds.dr_account_cd%TYPE;
287: l_cr_account_cd igs_fi_refunds.cr_account_cd%TYPE;
288: l_rowid igs_fi_refunds_v.row_id%TYPE;
289: l_refund_id igs_fi_refunds.refund_id%TYPE;
290: l_invoice_id igs_fi_inv_int.invoice_id%TYPE;

Line 287: l_cr_account_cd igs_fi_refunds.cr_account_cd%TYPE;

283: l_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
284: l_dr_gl_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
285: l_cr_gl_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
286: l_dr_account_cd igs_fi_refunds.dr_account_cd%TYPE;
287: l_cr_account_cd igs_fi_refunds.cr_account_cd%TYPE;
288: l_rowid igs_fi_refunds_v.row_id%TYPE;
289: l_refund_id igs_fi_refunds.refund_id%TYPE;
290: l_invoice_id igs_fi_inv_int.invoice_id%TYPE;
291: l_dr_ccid igs_fi_refunds.dr_gl_ccid%TYPE;

Line 288: l_rowid igs_fi_refunds_v.row_id%TYPE;

284: l_dr_gl_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
285: l_cr_gl_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
286: l_dr_account_cd igs_fi_refunds.dr_account_cd%TYPE;
287: l_cr_account_cd igs_fi_refunds.cr_account_cd%TYPE;
288: l_rowid igs_fi_refunds_v.row_id%TYPE;
289: l_refund_id igs_fi_refunds.refund_id%TYPE;
290: l_invoice_id igs_fi_inv_int.invoice_id%TYPE;
291: l_dr_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
292: l_cr_ccid igs_fi_refunds.cr_gl_ccid%TYPE;

Line 289: l_refund_id igs_fi_refunds.refund_id%TYPE;

285: l_cr_gl_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
286: l_dr_account_cd igs_fi_refunds.dr_account_cd%TYPE;
287: l_cr_account_cd igs_fi_refunds.cr_account_cd%TYPE;
288: l_rowid igs_fi_refunds_v.row_id%TYPE;
289: l_refund_id igs_fi_refunds.refund_id%TYPE;
290: l_invoice_id igs_fi_inv_int.invoice_id%TYPE;
291: l_dr_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
292: l_cr_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
293: l_dr_acc_cd igs_fi_refunds.dr_account_cd%TYPE;

Line 291: l_dr_ccid igs_fi_refunds.dr_gl_ccid%TYPE;

287: l_cr_account_cd igs_fi_refunds.cr_account_cd%TYPE;
288: l_rowid igs_fi_refunds_v.row_id%TYPE;
289: l_refund_id igs_fi_refunds.refund_id%TYPE;
290: l_invoice_id igs_fi_inv_int.invoice_id%TYPE;
291: l_dr_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
292: l_cr_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
293: l_dr_acc_cd igs_fi_refunds.dr_account_cd%TYPE;
294: l_cr_acc_cd igs_fi_refunds.cr_account_cd%TYPE;
295: l_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;

Line 292: l_cr_ccid igs_fi_refunds.cr_gl_ccid%TYPE;

288: l_rowid igs_fi_refunds_v.row_id%TYPE;
289: l_refund_id igs_fi_refunds.refund_id%TYPE;
290: l_invoice_id igs_fi_inv_int.invoice_id%TYPE;
291: l_dr_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
292: l_cr_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
293: l_dr_acc_cd igs_fi_refunds.dr_account_cd%TYPE;
294: l_cr_acc_cd igs_fi_refunds.cr_account_cd%TYPE;
295: l_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;
296: l_unapp_amount igs_fi_credits.unapplied_amount%TYPE;

Line 293: l_dr_acc_cd igs_fi_refunds.dr_account_cd%TYPE;

289: l_refund_id igs_fi_refunds.refund_id%TYPE;
290: l_invoice_id igs_fi_inv_int.invoice_id%TYPE;
291: l_dr_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
292: l_cr_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
293: l_dr_acc_cd igs_fi_refunds.dr_account_cd%TYPE;
294: l_cr_acc_cd igs_fi_refunds.cr_account_cd%TYPE;
295: l_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;
296: l_unapp_amount igs_fi_credits.unapplied_amount%TYPE;
297: l_application_id igs_fi_applications.application_id%TYPE;

Line 294: l_cr_acc_cd igs_fi_refunds.cr_account_cd%TYPE;

290: l_invoice_id igs_fi_inv_int.invoice_id%TYPE;
291: l_dr_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
292: l_cr_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
293: l_dr_acc_cd igs_fi_refunds.dr_account_cd%TYPE;
294: l_cr_acc_cd igs_fi_refunds.cr_account_cd%TYPE;
295: l_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;
296: l_unapp_amount igs_fi_credits.unapplied_amount%TYPE;
297: l_application_id igs_fi_applications.application_id%TYPE;
298: l_payee_id igs_fi_parties_v.person_id%TYPE;

Line 544: igs_fi_refunds_pkg.insert_row(X_ROWID => l_rowid,

540:
541: -- Call the Refunds table TBH for creating a record in the
542: -- refunds table
543: -- Call to igs_fi_gen_gl.get_formatted_amount formats refund_amount by rounding off to currency precision
544: igs_fi_refunds_pkg.insert_row(X_ROWID => l_rowid,
545: X_REFUND_ID => l_refund_id,
546: X_VOUCHER_DATE => TRUNC(sysdate),
547: X_PERSON_ID => l_crd_rec.party_id,
548: X_PAY_PERSON_ID => l_payee_id,

Line 646: skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_REFUNDS

642: Purpose : This procedure is used for batch processing.
643: Known limitations,enhancements,remarks:
644: Change History
645: Who When What
646: skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_REFUNDS
647: abshriva 9-Jun-2006 Bug:5076169 Modified code to log message in log file in case student is not having Refund Allowed checked Credits.
648: sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted into igs_fi_refunds
649: is now rounded off to currency precision
650: pmarada 19-jul-04 Bug 3775620, Logging credit number in log file, if there is no fee period for the refund fee type.

Line 648: sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted into igs_fi_refunds

644: Change History
645: Who When What
646: skharida 26-Jun-2006 Bug# 5208136 - Removed the obsoleted columns from the table IGS_FI_REFUNDS
647: abshriva 9-Jun-2006 Bug:5076169 Modified code to log message in log file in case student is not having Refund Allowed checked Credits.
648: sapanigr 03-May-2006 Enh#3924836 Precision Issue. Amount values being inserted into igs_fi_refunds
649: is now rounded off to currency precision
650: pmarada 19-jul-04 Bug 3775620, Logging credit number in log file, if there is no fee period for the refund fee type.
651: smadathi 25-AUG-2003 Enh. Bug 3045007. Added business logic to check if the Person for which the Refunds is being processed
652: is on an Active Payment Plan

Line 661: Modified the calls to igs_fi_refunds_pkg.insert_row and igs_fi_gen_007.create_application to include new parameter p_d_gl_date also. Modified IGS_GE_UNHANDLED_EXCEP message to

657: agairola 23-Dec-02 Bug 2718029: Modified the code in Process_batch to remove the app_exception
658: .raise_exception for parameter validation and replaced it by setting retcode=2
659: and RETURN
660: vvutukur 19-Nov-2002 Enh#2584986.Added mandatory IN parameter p_d_gl_date.Code added to validate GL Date.
661: Modified the calls to igs_fi_refunds_pkg.insert_row and igs_fi_gen_007.create_application to include new parameter p_d_gl_date also. Modified IGS_GE_UNHANDLED_EXCEP message to
662: IGS_GE_UNHANDLED_EXCEPTION.
663: vvutukur 28-Jun-2002 modified IGS_FI_TOL_LIM_DEFIED message token from REF_AMNT to
664: REF_AMOUNT.bug#2427999.
665: sarakshi 14-Jun-02 bug#2400617,the check of refunds not be processed if student is studying

Line 776: l_dr_gl_ccid igs_fi_refunds.dr_gl_ccid%TYPE;

772: WHERE invoice_id = cp_invoice_id;
773:
774:
775: -- Variables of the database column type
776: l_dr_gl_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
777: l_cr_gl_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
778: l_dr_account_cd igs_fi_refunds.dr_account_cd%TYPE;
779: l_cr_account_cd igs_fi_refunds.cr_account_cd%TYPE;
780: l_rowid igs_fi_refunds_v.row_id%TYPE;

Line 777: l_cr_gl_ccid igs_fi_refunds.cr_gl_ccid%TYPE;

773:
774:
775: -- Variables of the database column type
776: l_dr_gl_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
777: l_cr_gl_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
778: l_dr_account_cd igs_fi_refunds.dr_account_cd%TYPE;
779: l_cr_account_cd igs_fi_refunds.cr_account_cd%TYPE;
780: l_rowid igs_fi_refunds_v.row_id%TYPE;
781: l_refund_id igs_fi_refunds.refund_id%TYPE;

Line 778: l_dr_account_cd igs_fi_refunds.dr_account_cd%TYPE;

774:
775: -- Variables of the database column type
776: l_dr_gl_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
777: l_cr_gl_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
778: l_dr_account_cd igs_fi_refunds.dr_account_cd%TYPE;
779: l_cr_account_cd igs_fi_refunds.cr_account_cd%TYPE;
780: l_rowid igs_fi_refunds_v.row_id%TYPE;
781: l_refund_id igs_fi_refunds.refund_id%TYPE;
782: l_invoice_id igs_fi_inv_int.invoice_id%TYPE;

Line 779: l_cr_account_cd igs_fi_refunds.cr_account_cd%TYPE;

775: -- Variables of the database column type
776: l_dr_gl_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
777: l_cr_gl_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
778: l_dr_account_cd igs_fi_refunds.dr_account_cd%TYPE;
779: l_cr_account_cd igs_fi_refunds.cr_account_cd%TYPE;
780: l_rowid igs_fi_refunds_v.row_id%TYPE;
781: l_refund_id igs_fi_refunds.refund_id%TYPE;
782: l_invoice_id igs_fi_inv_int.invoice_id%TYPE;
783: l_dr_ccid igs_fi_refunds.dr_gl_ccid%TYPE;

Line 780: l_rowid igs_fi_refunds_v.row_id%TYPE;

776: l_dr_gl_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
777: l_cr_gl_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
778: l_dr_account_cd igs_fi_refunds.dr_account_cd%TYPE;
779: l_cr_account_cd igs_fi_refunds.cr_account_cd%TYPE;
780: l_rowid igs_fi_refunds_v.row_id%TYPE;
781: l_refund_id igs_fi_refunds.refund_id%TYPE;
782: l_invoice_id igs_fi_inv_int.invoice_id%TYPE;
783: l_dr_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
784: l_cr_ccid igs_fi_refunds.cr_gl_ccid%TYPE;

Line 781: l_refund_id igs_fi_refunds.refund_id%TYPE;

777: l_cr_gl_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
778: l_dr_account_cd igs_fi_refunds.dr_account_cd%TYPE;
779: l_cr_account_cd igs_fi_refunds.cr_account_cd%TYPE;
780: l_rowid igs_fi_refunds_v.row_id%TYPE;
781: l_refund_id igs_fi_refunds.refund_id%TYPE;
782: l_invoice_id igs_fi_inv_int.invoice_id%TYPE;
783: l_dr_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
784: l_cr_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
785: l_dr_acc_cd igs_fi_refunds.dr_account_cd%TYPE;

Line 783: l_dr_ccid igs_fi_refunds.dr_gl_ccid%TYPE;

779: l_cr_account_cd igs_fi_refunds.cr_account_cd%TYPE;
780: l_rowid igs_fi_refunds_v.row_id%TYPE;
781: l_refund_id igs_fi_refunds.refund_id%TYPE;
782: l_invoice_id igs_fi_inv_int.invoice_id%TYPE;
783: l_dr_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
784: l_cr_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
785: l_dr_acc_cd igs_fi_refunds.dr_account_cd%TYPE;
786: l_cr_acc_cd igs_fi_refunds.cr_account_cd%TYPE;
787: l_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;

Line 784: l_cr_ccid igs_fi_refunds.cr_gl_ccid%TYPE;

780: l_rowid igs_fi_refunds_v.row_id%TYPE;
781: l_refund_id igs_fi_refunds.refund_id%TYPE;
782: l_invoice_id igs_fi_inv_int.invoice_id%TYPE;
783: l_dr_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
784: l_cr_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
785: l_dr_acc_cd igs_fi_refunds.dr_account_cd%TYPE;
786: l_cr_acc_cd igs_fi_refunds.cr_account_cd%TYPE;
787: l_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;
788: l_unapp_amount igs_fi_credits.unapplied_amount%TYPE;

Line 785: l_dr_acc_cd igs_fi_refunds.dr_account_cd%TYPE;

781: l_refund_id igs_fi_refunds.refund_id%TYPE;
782: l_invoice_id igs_fi_inv_int.invoice_id%TYPE;
783: l_dr_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
784: l_cr_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
785: l_dr_acc_cd igs_fi_refunds.dr_account_cd%TYPE;
786: l_cr_acc_cd igs_fi_refunds.cr_account_cd%TYPE;
787: l_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;
788: l_unapp_amount igs_fi_credits.unapplied_amount%TYPE;
789: l_application_id igs_fi_applications.application_id%TYPE;

Line 786: l_cr_acc_cd igs_fi_refunds.cr_account_cd%TYPE;

782: l_invoice_id igs_fi_inv_int.invoice_id%TYPE;
783: l_dr_ccid igs_fi_refunds.dr_gl_ccid%TYPE;
784: l_cr_ccid igs_fi_refunds.cr_gl_ccid%TYPE;
785: l_dr_acc_cd igs_fi_refunds.dr_account_cd%TYPE;
786: l_cr_acc_cd igs_fi_refunds.cr_account_cd%TYPE;
787: l_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;
788: l_unapp_amount igs_fi_credits.unapplied_amount%TYPE;
789: l_application_id igs_fi_applications.application_id%TYPE;
790: l_payee_id igs_fi_parties_v.person_id%TYPE;

Line 797: l_rfnd_amnt igs_fi_refunds.refund_amount%TYPE;

793: l_determination igs_lookups_view.lookup_code%TYPE;
794: l_fee_type igs_fi_fee_type.fee_type%TYPE;
795: l_fee_cal_type igs_ca_inst.cal_type%TYPE;
796: l_fee_ci_sequence_number igs_ca_inst.sequence_number%TYPE;
797: l_rfnd_amnt igs_fi_refunds.refund_amount%TYPE;
798: l_party_number igs_fi_parties_v.person_number%TYPE;
799: l_invoice_number igs_fi_inv_int.invoice_number%TYPE;
800: l_group_cd igs_pe_all_persid_group_v.group_cd%TYPE;
801: l_v_message_name fnd_new_messages.message_name%TYPE;

Line 1429: igs_fi_refunds_pkg.insert_row(X_ROWID => l_rowid,

1425:
1426: -- Call to igs_fi_gen_gl.get_formatted_amount formats refund_amount by rounding off to currency precision
1427: l_rfnd_amnt := igs_fi_gen_gl.get_formatted_amount(l_rfnd_amnt);
1428:
1429: igs_fi_refunds_pkg.insert_row(X_ROWID => l_rowid,
1430: X_REFUND_ID => l_refund_id,
1431: X_VOUCHER_DATE => TRUNC(sysdate),
1432: X_PERSON_ID => l_n_party_id,
1433: X_PAY_PERSON_ID => l_n_party_id,