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_CHARGES_API_PVT dependencies on IGS_FI_CONTROL

Line 38: --jbegum 20-Jun-2003 Bug# 2998266, NEXT_INVOICE_NUMBER in the IGS_FI_CONTROL table will not be used for

34: --pathipat 30-Sep-2004 Bug 3908040 - Modified proc_neg_chg() - Removed check on Manage Accounts = Other before application/unapplication
35: --uudayapr 10-mar-2004 Bug#3478599,modified create_charge procedure
36: --shtatiko 10-DEC-2003 Bug# 3288973, modified call_build_process.
37: --vvutukur 27-Jun-2003 Bug#2849185.Modified create_charge procedure.
38: --jbegum 20-Jun-2003 Bug# 2998266, NEXT_INVOICE_NUMBER in the IGS_FI_CONTROL table will not be used for
39: -- generating unique charge numbers. Next Value from a DB sequence will be used for
40: -- for generating unique charges numbers.
41: --vvutukur 16-Jun-2003 Enh#2831582.Lockbox Build. Modified proc_neg_chg,create_charge.
42: --vvutukur 26-May-2003 Enh#2831572.Financial Accounting Build. Modified procedure validate_course,

Line 45: -- Modified call to igs_fi_control_pkg.update_row in proc create_charge()

41: --vvutukur 16-Jun-2003 Enh#2831582.Lockbox Build. Modified proc_neg_chg,create_charge.
42: --vvutukur 26-May-2003 Enh#2831572.Financial Accounting Build. Modified procedure validate_course,
43: --shtatiko 05-MAY-2003 Enh# 2831569, Modified proc_neg_chg and create_charge
44: --pathipat 14-Apr-2003 Enh 2831569 - Commercial Receivables Interface build
45: -- Modified call to igs_fi_control_pkg.update_row in proc create_charge()
46: --vvutukur 05-Apr-2003 Enh#2831554.Internal Credits API Build.Removed procedure validate_lkup,modified proc_neg_chg,create_charge.
47: --agairola 11-Mar-2003 Bug 2762740: Modified validate_neg_amnt and create_charge
48: --vchappid 03-Mar-2003 Bug: 2820197, In functions validate_ftci, validate_fcfl,Fee Structure Status validation
49: -- should be bypassed when the transaction type is either Assessment or Retention

Line 69: --SYkrishn 15/APR/2002 Included column planned_credits_ind in the update_row call of IGS_FI_CONTROL_PKG

65: --agairola 17-May-2002 Modified the Call_Build_Accounts procedure and Create Charge procedure for
66: -- bug 2323555
67: -- agairola 30-Apr-2002 Added the fee structure status to the query and equated the s_fee_structure_status to ACTIVE
68: -- for bug fix 2348883 in validate_ftci and validate_fcfl
69: --SYkrishn 15/APR/2002 Included column planned_credits_ind in the update_row call of IGS_FI_CONTROL_PKG
70: -- as part of ENh SFCR018 Build 2293676
71: --smvk 08-Mar-2002 Updated the call to igs_fi_control_pkg as per the Bug No 2144600
72: --vvutukur 27-02-2002 removed local function validate_person and placed call to igs_fi_gen_007.validate_person
73: -- in create_charge procedure.for bug:2238362

Line 71: --smvk 08-Mar-2002 Updated the call to igs_fi_control_pkg as per the Bug No 2144600

67: -- agairola 30-Apr-2002 Added the fee structure status to the query and equated the s_fee_structure_status to ACTIVE
68: -- for bug fix 2348883 in validate_ftci and validate_fcfl
69: --SYkrishn 15/APR/2002 Included column planned_credits_ind in the update_row call of IGS_FI_CONTROL_PKG
70: -- as part of ENh SFCR018 Build 2293676
71: --smvk 08-Mar-2002 Updated the call to igs_fi_control_pkg as per the Bug No 2144600
72: --vvutukur 27-02-2002 removed local function validate_person and placed call to igs_fi_gen_007.validate_person
73: -- in create_charge procedure.for bug:2238362
74: --jbegum 20-Feb-02 As part Enh bug#2228910
75: -- Removed source_transaction_id column from calls to

Line 77: --vvutukur 18-feb-2002 added ar_int_org_id column in call to igs_fi_control_pkg

73: -- in create_charge procedure.for bug:2238362
74: --jbegum 20-Feb-02 As part Enh bug#2228910
75: -- Removed source_transaction_id column from calls to
76: -- IGS_FI_INV_INT_PKG.insert_row and IGS_FI_INVLN_INT_PKG.insert_row
77: --vvutukur 18-feb-2002 added ar_int_org_id column in call to igs_fi_control_pkg
78: -- for bug:2222272.
79: --jbegum 14-Feb-2001 As part of Enh bug # 2201081
80: -- Added call to IGS_FI_GEN_005.validate_psa and IGS_FI_PARTY_SA_PKG.insert_row
81: -- Removed Cursor cur_psa

Line 83: --vchappid 20-Jan-2002 Enh # 2162747, Modified igs_fi_control table, introduced two columns

79: --jbegum 14-Feb-2001 As part of Enh bug # 2201081
80: -- Added call to IGS_FI_GEN_005.validate_psa and IGS_FI_PARTY_SA_PKG.insert_row
81: -- Removed Cursor cur_psa
82: --sykrishn 14feb2002 SFCR020 Build - 2191470 - Added the 4 new params to Credits API call.
83: --vchappid 20-Jan-2002 Enh # 2162747, Modified igs_fi_control table, introduced two columns
84: --masehgal 15-Jan-2002 Enh # 2170429
85: -- Obsoletion of SPONSOR_CD
86: --sarakshi 18-dec-2001 removed the parameters p_source_date,p_fee_type,p_credit_type_id from
87: -- the call to procedure Update_Balances and added parameter p_source_id

Line 116: g_curr_cd igs_fi_control.currency_cd%TYPE;

112: g_c_assessment CONSTANT VARCHAR2(30) := 'ASSESSMENT';
113: g_c_retention CONSTANT VARCHAR2(30) := 'RETENTION';
114:
115: g_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;
116: g_curr_cd igs_fi_control.currency_cd%TYPE;
117: g_v_manage_accounts igs_fi_control_all.manage_accounts%TYPE;
118:
119: FUNCTION chk_charge_adjusted(p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
120: p_n_inv_amt IN igs_fi_inv_int_all.invoice_amount%TYPE) RETURN BOOLEAN;

Line 117: g_v_manage_accounts igs_fi_control_all.manage_accounts%TYPE;

113: g_c_retention CONSTANT VARCHAR2(30) := 'RETENTION';
114:
115: g_inv_amt_due igs_fi_inv_int.invoice_amount_due%TYPE;
116: g_curr_cd igs_fi_control.currency_cd%TYPE;
117: g_v_manage_accounts igs_fi_control_all.manage_accounts%TYPE;
118:
119: FUNCTION chk_charge_adjusted(p_n_invoice_id IN igs_fi_inv_int_all.invoice_id%TYPE,
120: p_n_inv_amt IN igs_fi_inv_int_all.invoice_amount%TYPE) RETURN BOOLEAN;
121:

Line 296: FUNCTION validate_cur(p_currency_cd IN igs_fi_control.currency_cd%TYPE) RETURN BOOLEAN AS

292: --removed function validate_subaccount as part of subaccount removal build. enh#2564643.
293: --removed function validate_lkup as part of Internal Credits API build. enh#2831554.
294:
295:
296: FUNCTION validate_cur(p_currency_cd IN igs_fi_control.currency_cd%TYPE) RETURN BOOLEAN AS
297:
298: /***********************************************************************************************
299:
300: Created By: Amit Gairola

Line 312: function to get the currency_cd set in igs_fi_control

308: Change History
309:
310: Who When What
311: pathipat 16-Nov-2002 Enh Bug: 2584986: Replaced cursor selecting from igs_fi_cur with generic
312: function to get the currency_cd set in igs_fi_control
313: ********************************************************************************************** */
314: l_bool BOOLEAN;
315: l_v_message_name fnd_new_messages.message_name%TYPE;
316: l_v_curr_desc fnd_currencies_tl.name%TYPE;

Line 320: -- Call generic function to get the currency_cd setup in igs_fi_control

316: l_v_curr_desc fnd_currencies_tl.name%TYPE;
317:
318: BEGIN
319:
320: -- Call generic function to get the currency_cd setup in igs_fi_control
321: igs_fi_gen_gl.finp_get_cur( p_v_currency_cd => g_curr_cd,
322: p_v_curr_desc => l_v_curr_desc,
323: p_v_message_name => l_v_message_name
324: );

Line 1228: jbegum 20-Jun-2003 Bug# 2998266, NEXT_INVOICE_NUMBER in the IGS_FI_CONTROL table will not be used for

1224: uudayapr 08-Mar-2004 Bug#3478599.Added the code to prevent charge creation with
1225: error account as Y for Transaction Type as
1226: Document when Revenue Account Derivation fails.
1227: vvutukur 27-Jun-2003 Bug#2849185.Bypassed unncessary validations in case of negative charge.
1228: jbegum 20-Jun-2003 Bug# 2998266, NEXT_INVOICE_NUMBER in the IGS_FI_CONTROL table will not be used for
1229: generating unique charge numbers. Next Value from a DB sequence will be used for
1230: for generating unique charges numbers.
1231: Removed the call to IGS_FI_CONTROL_PKG.update_row
1232: vvutukur 16-Jun-2003 Enh#2831582.Lockbox Build. Removed 3 columns(lockbox_context,lockbox_number,attribute,ar_int_org_id)

Line 1231: Removed the call to IGS_FI_CONTROL_PKG.update_row

1227: vvutukur 27-Jun-2003 Bug#2849185.Bypassed unncessary validations in case of negative charge.
1228: jbegum 20-Jun-2003 Bug# 2998266, NEXT_INVOICE_NUMBER in the IGS_FI_CONTROL table will not be used for
1229: generating unique charge numbers. Next Value from a DB sequence will be used for
1230: for generating unique charges numbers.
1231: Removed the call to IGS_FI_CONTROL_PKG.update_row
1232: vvutukur 16-Jun-2003 Enh#2831582.Lockbox Build. Removed 3 columns(lockbox_context,lockbox_number,attribute,ar_int_org_id)
1233: from igs_fi_control_pkg.update_row.
1234: vvutukur 26-May-2003 Enh#2831572.Financial Accounting Build. Changes as specified in TD.
1235: shtatiko 05-MAY-2003 Enh# 2831569, Added check Manage Accounts System Option before creating a charge.

Line 1233: from igs_fi_control_pkg.update_row.

1229: generating unique charge numbers. Next Value from a DB sequence will be used for
1230: for generating unique charges numbers.
1231: Removed the call to IGS_FI_CONTROL_PKG.update_row
1232: vvutukur 16-Jun-2003 Enh#2831582.Lockbox Build. Removed 3 columns(lockbox_context,lockbox_number,attribute,ar_int_org_id)
1233: from igs_fi_control_pkg.update_row.
1234: vvutukur 26-May-2003 Enh#2831572.Financial Accounting Build. Changes as specified in TD.
1235: shtatiko 05-MAY-2003 Enh# 2831569, Added check Manage Accounts System Option before creating a charge.
1236: And updation of Holds or Standard balances is done only if its value is STUDENT_FINANCE.
1237: pathipat 14-Apr-2003 Enh 2831569 - Commercial Receivables Interface build

Line 1238: Modified call to igs_fi_control_pkg.update_row

1234: vvutukur 26-May-2003 Enh#2831572.Financial Accounting Build. Changes as specified in TD.
1235: shtatiko 05-MAY-2003 Enh# 2831569, Added check Manage Accounts System Option before creating a charge.
1236: And updation of Holds or Standard balances is done only if its value is STUDENT_FINANCE.
1237: pathipat 14-Apr-2003 Enh 2831569 - Commercial Receivables Interface build
1238: Modified call to igs_fi_control_pkg.update_row
1239: vvutukur 11-Apr-2003 Enh#2831554.Internal Credits API Build. Added checks to validate ADJ credit instrument,charge method and transaction type.
1240: agairola 11-Mar-2003 Bug 2762740: 1. Modified the call to the validate_neg_amnt.
1241: 2. Added a new variable l_val_neg_amnt and this variable
1242: gets the value from validate_neg_amnt

Line 1245: smadathi 18-Feb-2002 Enh. Bug 2747329.Modified the TBH call to IGS_FI_CONTROL to Add new columns

1241: 2. Added a new variable l_val_neg_amnt and this variable
1242: gets the value from validate_neg_amnt
1243: 3. Added the code to check for l_val_neg_amnt = 1
1244: 4. Modified the code for the amount validation(l_val_neg_amnt=2)
1245: smadathi 18-Feb-2002 Enh. Bug 2747329.Modified the TBH call to IGS_FI_CONTROL to Add new columns
1246: rfnd_destination, ap_org_id, dflt_supplier_site_name
1247: pathipat 14-Nov-2002 Enh Bug: 2584986 -
1248: 1. Added parameters gl_date, gl_posted_date and posting_control_id
1249: in the call to igs_fi_invln_int_pkg.insert_row()

Line 1253: vvutukur 20-sep-2002 Enh#2562745.1)Added conv_process_run_ind parameter to call to igs_fi_control_pkg.

1249: in the call to igs_fi_invln_int_pkg.insert_row()
1250: 2. Added parameter p_gl_date in call to proc_neg_chg() for negative charges
1251: 3. Removed calls to get_local_amount, passed the invoice_amount and currency_cd
1252: directly from p_header_rec, instead of conversion to local currency
1253: vvutukur 20-sep-2002 Enh#2562745.1)Added conv_process_run_ind parameter to call to igs_fi_control_pkg.
1254: update_row.2)Added call to igs_fi_prc_balance.update_balances to update the Holds
1255: Balance real time whenever a charge gets created.3)Added two new validations to
1256: error out of charges api in the following scenarios.a)if holds conversion process
1257: is running b)if no active balance rule exist for HOLDS.

Line 1265: Also added 7 new parameters to the call to igs_fi_control_pkg.update_row.

1261: reference to subaccount_id from the calls to IGS_FI_INV_INT_PKG.Insert_Row and
1262: igs_fi_prc_balances.update_balances.Removed call to igs_fi_gen_005.validate_psa
1263: since the function igs_fi_gen_005.validate_psa is being removed.Removed call to
1264: igs_fi_party_sa_pkg.insert_row as the table igs_fi_party_sa is being obsoleted.
1265: Also added 7 new parameters to the call to igs_fi_control_pkg.update_row.
1266: smadathi 03-Jul-2002 Bug 2443082. Modified update_balances procedure call. Modified to pass transaction date
1267: instead of system date.
1268: agairola 10-Jun-2002 Bug Number: 2407624 Modified the call to the Get_Local_Amount
1269: agairola 17-May-2002 Following modifications were done for the bug 2323555 - Call Build Accounts

Line 1273: SYkrishn 15-APR-2002 Added planned_credits_ind to the IGS_FI_CONTROL_PKG.update_row call as part of Enh 2293676

1269: agairola 17-May-2002 Following modifications were done for the bug 2323555 - Call Build Accounts
1270: procedure is called in all cases even if the accounts are passed.
1271: Also assigned the value of the accounts passed as input to the Charges API
1272: to the local variables used in the call to Call Build Accounts procedure
1273: SYkrishn 15-APR-2002 Added planned_credits_ind to the IGS_FI_CONTROL_PKG.update_row call as part of Enh 2293676
1274: smvk 08-Mar-2002 Added four attributes refund_dr_gl_ccid,refund_cr_gl_ccid,refund_dr_account_cd,
1275: refund_cr_account_cd and removed three attributes last_account_trans,last_payment_trans,
1276: last_pay_term_trans to the call to IGS_FI_CONTROL_PKG.Update_row as per Bug #2144600
1277: vvutukur 27-02-2002 added call to igs_fi_gen_007.validate_person instead of calling local function

Line 1276: last_pay_term_trans to the call to IGS_FI_CONTROL_PKG.Update_row as per Bug #2144600

1272: to the local variables used in the call to Call Build Accounts procedure
1273: SYkrishn 15-APR-2002 Added planned_credits_ind to the IGS_FI_CONTROL_PKG.update_row call as part of Enh 2293676
1274: smvk 08-Mar-2002 Added four attributes refund_dr_gl_ccid,refund_cr_gl_ccid,refund_dr_account_cd,
1275: refund_cr_account_cd and removed three attributes last_account_trans,last_payment_trans,
1276: last_pay_term_trans to the call to IGS_FI_CONTROL_PKG.Update_row as per Bug #2144600
1277: vvutukur 27-02-2002 added call to igs_fi_gen_007.validate_person instead of calling local function
1278: validate_person for bug:2238362
1279: vvutukur 18-feb-2002 added ar_int_org_id column to igs_fi_control_pkg.update_row call. bug:2222272
1280: jbegum 14-Feb-2001 As part of Enh bug # 2201081

Line 1279: vvutukur 18-feb-2002 added ar_int_org_id column to igs_fi_control_pkg.update_row call. bug:2222272

1275: refund_cr_account_cd and removed three attributes last_account_trans,last_payment_trans,
1276: last_pay_term_trans to the call to IGS_FI_CONTROL_PKG.Update_row as per Bug #2144600
1277: vvutukur 27-02-2002 added call to igs_fi_gen_007.validate_person instead of calling local function
1278: validate_person for bug:2238362
1279: vvutukur 18-feb-2002 added ar_int_org_id column to igs_fi_control_pkg.update_row call. bug:2222272
1280: jbegum 14-Feb-2001 As part of Enh bug # 2201081
1281: Added call to IGS_FI_GEN_005.validate_psa and IGS_FI_PARTY_SA_PKG.insert_row
1282: Removed cursor cur_psa
1283: kkillams 01-08-2001 Modification done w.r.t student finance dld bug id :1882122

Line 1316: l_acnt_mthd IGS_FI_CONTROL.Accounting_Method%TYPE;

1312: l_bool BOOLEAN;
1313: l_valid BOOLEAN := TRUE;
1314: l_line_cnt NUMBER := 1;
1315: l_var NUMBER;
1316: l_acnt_mthd IGS_FI_CONTROL.Accounting_Method%TYPE;
1317: l_rowid VARCHAR2(25);
1318: l_application_id igs_fi_applications.application_id%TYPE;
1319: l_unapplied_amount igs_fi_credits.unapplied_amount%TYPE;
1320: l_invoice_lines_id igs_fi_invln_int.invoice_lines_id%TYPE;

Line 1369: -- Cursor for getting the record from the IGS_FI_CONTROL table

1365: igs_fi_credits.*
1366: FROM igs_fi_credits
1367: WHERE credit_id = cp_credit_id;
1368:
1369: -- Cursor for getting the record from the IGS_FI_CONTROL table
1370: CURSOR cur_ctrl IS
1371: SELECT rowid,
1372: igs_fi_control.*
1373: FROM igs_fi_control;

Line 1372: igs_fi_control.*

1368:
1369: -- Cursor for getting the record from the IGS_FI_CONTROL table
1370: CURSOR cur_ctrl IS
1371: SELECT rowid,
1372: igs_fi_control.*
1373: FROM igs_fi_control;
1374:
1375: -- Cursor for selecting all the charges based on the Person Id, Fee Type, Fee Cal Type,
1376: -- Fee Calendar Instance, Fee Category, Course Cd, Transaction type, Unit Section Id

Line 1373: FROM igs_fi_control;

1369: -- Cursor for getting the record from the IGS_FI_CONTROL table
1370: CURSOR cur_ctrl IS
1371: SELECT rowid,
1372: igs_fi_control.*
1373: FROM igs_fi_control;
1374:
1375: -- Cursor for selecting all the charges based on the Person Id, Fee Type, Fee Cal Type,
1376: -- Fee Calendar Instance, Fee Category, Course Cd, Transaction type, Unit Section Id
1377: -- and the location code. If the invoice id is passed as input to the cursor then this is

Line 1450: l_cnv_prc igs_fi_control.conv_process_run_ind%TYPE := NULL;

1446:
1447: l_validate_flag BOOLEAN;
1448: l_valid_person VARCHAR2(1); --bug:2238362
1449:
1450: l_cnv_prc igs_fi_control.conv_process_run_ind%TYPE := NULL;
1451: l_hold_bal_type CONSTANT igs_fi_balance_rules.balance_name%TYPE := 'HOLDS';
1452: l_action_active CONSTANT VARCHAR2(10) := 'ACTIVE';
1453: l_version_number igs_fi_balance_rules.version_number%TYPE;
1454: l_last_conversion_date DATE;

Line 1458: l_v_manage_accounts igs_fi_control_all.manage_accounts%TYPE;

1454: l_last_conversion_date DATE;
1455: l_balance_rule_id igs_fi_balance_rules.balance_rule_id%TYPE;
1456:
1457: l_val_neg_amnt NUMBER(2);
1458: l_v_manage_accounts igs_fi_control_all.manage_accounts%TYPE;
1459: l_v_message_name fnd_new_messages.message_name%TYPE;
1460:
1461:
1462: -- Bug #2998266 Added the following cursor