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_FEE_ASS dependencies on IGS_FI_GEN_008

Line 14: abshriva 17-May-2006 Bug 5113295 - Modifies finpl_chk_debt_ret_sched - Added call to igs_fi_gen_008.chk_unit_prg_transfer

10: Who When What
11: abshriva 19-Jun-2006 Bug 5104329 -Introduced new function finpl_get_derived_am_at and involed in finpl_prc_fee_cat_fee_liab
12: akandreg 31-May-2006 Bug 5134636 - Modified finpl_lock_records and finpl_insert_record
13: abshriva 24-May-2006 Bug:5204728 - Added Order by clause in both cursor of finpl_find_far.Introduced p_trace_on in create_retention_charge
14: abshriva 17-May-2006 Bug 5113295 - Modifies finpl_chk_debt_ret_sched - Added call to igs_fi_gen_008.chk_unit_prg_transfer
15: abshriva 12-May-2006 Bug 5217319: Amount Precision change in create_retention_charge,finpl_ins_fee_ass
16: gurprsin 06-Dec-2005 Bug 4735807, Modified function 'finp_ins_enr_fee_ass', Modified the logic to return and log the message
17: if No Fee category is attached to the SPA.
18: abshriva 05-Dec-2005 Bug 4701695 Modified function 'finp_ins_enr_fee_ass'

Line 35: Replaced usage of igs_fi_gen_008.get_party_number with finpl_get_org_unit_cd for Org derivation

31: pathipat 14-Oct-2005 Bug 4634543 - Waiver amt not getting computed from fee assessment process
32: Modified finp_ins_enr_fee_ass
33: pathipat 10-Oct-2005 Bug 4375258 - Change party_number FK to TCA parties impact -
34: Added new local function finpl_get_org_unit_cd to fetch the org_unit_cd\
35: Replaced usage of igs_fi_gen_008.get_party_number with finpl_get_org_unit_cd for Org derivation
36: pathipat 04-Oct-2005 Bug 3781716 - Improper output message when fee category missing
37: Modified finp_ins_enr_fee_ass - added code to log message and error out if Fee Cat is
38: not specified for the SPA.
39: pathipat 21-Sep-2005 Bug 4383148 - Fees not assessed if attendance type cannot be derived

Line 52: Also modified finpl_chk_debt_ret_sched. modified the call to igs_fi_gen_008.get_complete_withdr_ret_amt

48: bannamal 27-May-2005 Bug#4077763 Fee Calculation Performance Enhancement. Changes done as per TD.
49: bannamal 14-Apr-2005 Bug#4297359 ER Registration Fee issue
50: Modified finpl_clc_chg_mthd_elements. Added code to check whether the credit points for the unit
51: attempt is non zero in case the non zero billable cp flag is set to 'Y'.
52: Also modified finpl_chk_debt_ret_sched. modified the call to igs_fi_gen_008.get_complete_withdr_ret_amt
53: to add one more parameter.
54: bannamal 31-MAR-2005 Bug 4224364 STUDENT FINANCE UPTAKE OF PROGRAM TRANSFER FUTURE DATED FLAG VALUE CHANGES
55: Modified the cursors c_get_term_recs, c_get_scas_recs to ignore the program attempts
56: with Future-Dated Transfer flag set to 'C'

Line 71: shtatiko 27-JUL-2004 Enh# 3787816, Removed function finpl_charge_is_declined. This call has been replaced with igs_fi_gen_008.chk_chg_adj

67: pathipat 07-Sep-2004 Enh 3880438 - Retention Enhancements
68: Modified finpl_chk_debt_ret_sched, finpl_ins_fee_ass, finp_ins_enr_fee_ass
69: Added proc create_retention_charge.
70: Removed duplicate function finpl_chk_debt_ret_sched
71: shtatiko 27-JUL-2004 Enh# 3787816, Removed function finpl_charge_is_declined. This call has been replaced with igs_fi_gen_008.chk_chg_adj
72: shtatiko 23-JUL-2004 Enh# 3741400, Added finpl_clc_sua_cp and modified c_sua_load, finpl_clc_chg_mthd_elements.
73: pathipat 01-Jul-2004 Bug 3734842 - Modified finpl_prc_fee_cat_fee_liab() to lock records before processing.
74: Modified finpl_ins_fee_ass() to check if header and line records were created correctly
75: Added functions finpl_lock_records(), finpl_insert_record() and finpl_check_header_lines()

Line 940: p_v_string => 'Non Standard USEC - Invoking igs_fi_gen_008.get_ns_usec_retention');

936:
937: IF (l_v_non_std_usec = 'Y') THEN
938: -- If the Unit Section is Non-Standard, invoked function to determine Retention Amount
939: log_to_fnd( p_v_module => 'finpl_prc_teach_prd_retn_levl',
940: p_v_string => 'Non Standard USEC - Invoking igs_fi_gen_008.get_ns_usec_retention');
941: l_n_retention_amount := igs_fi_gen_008.get_ns_usec_retention(p_n_uoo_id => p_n_uoo_id,
942: p_v_fee_type => p_fee_type,
943: p_d_effective_date => rec_usec_dtls.discontinued_dt,
944: p_n_diff_amount => p_n_diff_amount);

Line 941: l_n_retention_amount := igs_fi_gen_008.get_ns_usec_retention(p_n_uoo_id => p_n_uoo_id,

937: IF (l_v_non_std_usec = 'Y') THEN
938: -- If the Unit Section is Non-Standard, invoked function to determine Retention Amount
939: log_to_fnd( p_v_module => 'finpl_prc_teach_prd_retn_levl',
940: p_v_string => 'Non Standard USEC - Invoking igs_fi_gen_008.get_ns_usec_retention');
941: l_n_retention_amount := igs_fi_gen_008.get_ns_usec_retention(p_n_uoo_id => p_n_uoo_id,
942: p_v_fee_type => p_fee_type,
943: p_d_effective_date => rec_usec_dtls.discontinued_dt,
944: p_n_diff_amount => p_n_diff_amount);
945: log_to_fnd( p_v_module => 'finpl_prc_teach_prd_retn_levl',

Line 972: p_v_string => 'Not NS - Apply Teaching Period Retention - Invoking igs_fi_gen_008.get_teach_retention');

968: END IF; -- End if for l_n_retention_amount > 0.0
969: ELSE
970: -- If Unit Section is NOT Non-Standard, then invoke Teaching Period level retention
971: log_to_fnd( p_v_module => 'finpl_prc_teach_prd_retn_levl',
972: p_v_string => 'Not NS - Apply Teaching Period Retention - Invoking igs_fi_gen_008.get_teach_retention');
973: l_n_retention_amount := igs_fi_gen_008.get_teach_retention(p_v_fee_cal_type => p_fee_cal_type,
974: p_n_fee_ci_sequence_number => p_fee_ci_sequence_number,
975: p_v_fee_type => p_fee_type,
976: p_v_teach_cal_type => rec_usec_dtls.cal_type,

Line 973: l_n_retention_amount := igs_fi_gen_008.get_teach_retention(p_v_fee_cal_type => p_fee_cal_type,

969: ELSE
970: -- If Unit Section is NOT Non-Standard, then invoke Teaching Period level retention
971: log_to_fnd( p_v_module => 'finpl_prc_teach_prd_retn_levl',
972: p_v_string => 'Not NS - Apply Teaching Period Retention - Invoking igs_fi_gen_008.get_teach_retention');
973: l_n_retention_amount := igs_fi_gen_008.get_teach_retention(p_v_fee_cal_type => p_fee_cal_type,
974: p_n_fee_ci_sequence_number => p_fee_ci_sequence_number,
975: p_v_fee_type => p_fee_type,
976: p_v_teach_cal_type => rec_usec_dtls.cal_type,
977: p_n_teach_ci_sequence_number => rec_usec_dtls.ci_sequence_number,

Line 2407: Replaced usage of igs_fi_gen_008.get_party_number with finpl_get_org_unit_cd

2403: Change History:
2404: Who When What
2405: abshriva 23-May-2006 Bug 5204728: Added ORDER BY order_of_precedence in cursor c_ftfarv1 and c_ftfarv2
2406: pathipat 10-Oct-2005 Bug 4375258 - Change party_number FK to TCA parties impact
2407: Replaced usage of igs_fi_gen_008.get_party_number with finpl_get_org_unit_cd
2408: for Org derivation
2409: bannamal 03-JUN-2005 Bug#3442712 Unit Level Fee Assessment Build.
2410: Added new parameters for this build.
2411: shtatiko 27-JUL-2004 Enh# 3795849, Added p_derived_prog_att_mode.

Line 2814: Replaced usage of igs_fi_gen_008.get_party_number with finpl_get_org_unit_cd

2810:
2811: Change History
2812: Who When What
2813: pathipat 10-Oct-2005 Bug 4375258 - Change party_number FK to TCA parties impact
2814: Replaced usage of igs_fi_gen_008.get_party_number with finpl_get_org_unit_cd
2815: for Org derivation
2816: ***************************************************************/
2817:
2818:

Line 4991: abshriva 17-May-2006 Bug 5113295 - Added check (igs_fi_gen_008.chk_unit_prg_transfer) for units that were

4987: ) AS
4988: /********************************************************************************************************
4989: CHANGE HISTORY:
4990: WHO WHEN WHAT
4991: abshriva 17-May-2006 Bug 5113295 - Added check (igs_fi_gen_008.chk_unit_prg_transfer) for units that were
4992: part of Program Transfer.Added cur_disc_dt to select only dcnt_reason_cd.
4993: pathipat 22-Nov-2005 Bug 4718712 - Added code to log Old and New Amts only if atleast one is non-zero
4994: bannamal 08-Jul-2005 Enh#3392088 Campus Privilege Fee. Changes done as per TD.
4995: bannamal 14-Apr-2005 Bug#4297359 ER Registration Fee issue

Line 4996: Modified the call to igs_fi_gen_008.get_complete_withdr_ret_amt to add

4992: part of Program Transfer.Added cur_disc_dt to select only dcnt_reason_cd.
4993: pathipat 22-Nov-2005 Bug 4718712 - Added code to log Old and New Amts only if atleast one is non-zero
4994: bannamal 08-Jul-2005 Enh#3392088 Campus Privilege Fee. Changes done as per TD.
4995: bannamal 14-Apr-2005 Bug#4297359 ER Registration Fee issue
4996: Modified the call to igs_fi_gen_008.get_complete_withdr_ret_amt to add
4997: a new parameter p_v_nonzero_billable_cp_flag.
4998: pathipat 07-Sep-2004 Enh 3880438 - Retention Enhancements
4999: Completely revamped retention logic to include Teaching Period retention.
5000: pathipat 05-Nov-2003 Enh 3117341 - Audit and Special Fees TD

Line 5070: AND (igs_fi_gen_008.chk_unit_prg_transfer(sua.dcnt_reason_cd) = 'N')

5066: g_v_load_cal_type,
5067: g_n_load_seq_num,
5068: sua.no_assessment_ind ) = cp_v_enrp_get_load_apply )
5069: AND sua.uoo_id = cp_n_uoo_id
5070: AND (igs_fi_gen_008.chk_unit_prg_transfer(sua.dcnt_reason_cd) = 'N')
5071: ORDER BY sua.discontinued_dt;
5072:
5073: CURSOR cur_enr_date (cp_person_id hz_parties.party_id%TYPE,
5074: cp_course_cd igs_en_su_attempt_all.course_cd%TYPE,

Line 5153: igs_fi_gen_008.get_retention_params(p_v_fee_cal_type => p_fee_cal_type,

5149: RETURN;
5150: END IF;
5151:
5152: -- Obtain values of Retention Level and Complete Withdrawal Retention checkbox from FTCI
5153: igs_fi_gen_008.get_retention_params(p_v_fee_cal_type => p_fee_cal_type,
5154: p_n_fee_ci_sequence_number => p_fee_ci_sequence_number,
5155: p_v_fee_type => p_fee_type,
5156: p_v_ret_level => l_v_retention_level,
5157: p_v_complete_withdr_ret => l_v_cmp_withdr_ret);

Line 5179: p_v_string => 'Complete Withdrawal Retention : Invoking igs_fi_gen_008.get_complete_withdr_ret_amt');

5175: RETURN;
5176: END IF;
5177: -- If downward adjustment has happened, then determine the Retention Amount applicable
5178: log_to_fnd( p_v_module => 'finpl_chk_debt_ret_sched',
5179: p_v_string => 'Complete Withdrawal Retention : Invoking igs_fi_gen_008.get_complete_withdr_ret_amt');
5180: OPEN cur_nz_bill_cp_flag( p_fee_type, p_fee_cal_type, p_fee_ci_sequence_number );
5181: FETCH cur_nz_bill_cp_flag INTO l_v_nz_bill_cp_flag;
5182: CLOSE cur_nz_bill_cp_flag;
5183: -- Included the parameter p_v_nonzero_billable_cp_flag in the call to get_complete_withdr_ret_amt

Line 5184: l_n_retention_amount := igs_fi_gen_008.get_complete_withdr_ret_amt(p_n_person_id => p_person_id,

5180: OPEN cur_nz_bill_cp_flag( p_fee_type, p_fee_cal_type, p_fee_ci_sequence_number );
5181: FETCH cur_nz_bill_cp_flag INTO l_v_nz_bill_cp_flag;
5182: CLOSE cur_nz_bill_cp_flag;
5183: -- Included the parameter p_v_nonzero_billable_cp_flag in the call to get_complete_withdr_ret_amt
5184: l_n_retention_amount := igs_fi_gen_008.get_complete_withdr_ret_amt(p_n_person_id => p_person_id,
5185: p_v_course_cd => p_course_cd,
5186: p_v_load_cal_type => g_v_load_cal_type,
5187: p_n_load_ci_sequence_number => g_n_load_seq_num,
5188: p_n_diff_amount => l_n_diff_amount,

Line 5227: p_v_string => 'Fee Period retention : Invoking igs_fi_gen_008.get_fee_retention_amount');

5223: RETURN;
5224: END IF;
5225: -- If downward adjustment has happened, then determine the Retention Amount applicable
5226: log_to_fnd( p_v_module => 'finpl_chk_debt_ret_sched',
5227: p_v_string => 'Fee Period retention : Invoking igs_fi_gen_008.get_fee_retention_amount');
5228: l_n_retention_amount := igs_fi_gen_008.get_fee_retention_amount(p_v_fee_cat => p_fee_cat,
5229: p_v_fee_cal_type => p_fee_cal_type,
5230: p_n_fee_ci_sequence_number => p_fee_ci_sequence_number,
5231: p_v_fee_type => p_fee_type,

Line 5228: l_n_retention_amount := igs_fi_gen_008.get_fee_retention_amount(p_v_fee_cat => p_fee_cat,

5224: END IF;
5225: -- If downward adjustment has happened, then determine the Retention Amount applicable
5226: log_to_fnd( p_v_module => 'finpl_chk_debt_ret_sched',
5227: p_v_string => 'Fee Period retention : Invoking igs_fi_gen_008.get_fee_retention_amount');
5228: l_n_retention_amount := igs_fi_gen_008.get_fee_retention_amount(p_v_fee_cat => p_fee_cat,
5229: p_v_fee_cal_type => p_fee_cal_type,
5230: p_n_fee_ci_sequence_number => p_fee_ci_sequence_number,
5231: p_v_fee_type => p_fee_type,
5232: p_n_diff_amount => l_n_diff_amount);

Line 5596: IF (igs_fi_gen_008.chk_unit_prg_transfer(l_v_dcnt_reason_cd) = 'Y') THEN

5592: -- Check if the unit has been dropped due to a Program Transfer. If yes, then do not invoke retention
5593: OPEN cur_disc_dt(p_person_id, t_fee_as_items(i).course_cd, t_fee_as_items(i).uoo_id);
5594: FETCH cur_disc_dt INTO l_v_dcnt_reason_cd;
5595: CLOSE cur_disc_dt;
5596: IF (igs_fi_gen_008.chk_unit_prg_transfer(l_v_dcnt_reason_cd) = 'Y') THEN
5597: log_to_fnd( p_v_module => 'finpl_chk_debt_ret_sched',
5598: p_v_string => 'Teach Period level Retention: Unit Transferred, UOO_ID: '||t_fee_as_items(i).uoo_id
5599: ||' Course Cd: '||t_fee_as_items(i).course_cd||' and Disc Reason: '||l_v_dcnt_reason_cd);
5600: RAISE SKIP;

Line 5691: shtatiko 27-JUL-2004 Enh# 3787816, Replaced the call to finpl_charge_is_declined with igs_fi_gen_008.chk_chg_adj.

5687: bannamal 03-Jun-2005 Bug#3442712 Unit Level Fee Assessment Build. Modified the call to igs_fi_fee_as_items_pkg.insert_row
5688: added new parameters unit_type_id, unit_class, unit_mode and unit_level.
5689: pathipat 07-Sep-2004 Enh 3880438 - Retention Enhancements build
5690: Removed condition checking if new amount < old amount before invoking finpl_chk_debt_ret_sched
5691: shtatiko 27-JUL-2004 Enh# 3787816, Replaced the call to finpl_charge_is_declined with igs_fi_gen_008.chk_chg_adj.
5692: pathipat 06-Jul-2004 Bug 3734842 - Added logic to check if records have been created correctly
5693: in IGS_FI_FEE_AS and IGS_FI_FEE_AS_ITEMS tables - added call to finpl_check_header_lines
5694: UUDAYAPR 17-DEC-2003 BUG#3080983 Modified V_assessment_amount,V_transaction_amount,p_fee_assessment
5695: To Number From Igs_fi_fee_ass_debt_v.Assessment_amount%Type,

Line 5825: igs_fi_gen_008.chk_chg_adj(

5821: IF t_fee_as_items(i).fee_type = p_fee_type THEN
5822:
5823: -- A declined charge should not be considered for re-assessment
5824: l_b_charge_declined := FALSE;
5825: igs_fi_gen_008.chk_chg_adj(
5826: p_n_person_id => p_person_id,
5827: p_v_location_cd => t_fee_as_items(i).location_cd,
5828: p_v_course_cd => t_fee_as_items(i).course_cd,
5829: p_v_fee_cal_type => t_fee_as_items(i).fee_cal_type,

Line 6095: l_v_invoice_num := igs_fi_gen_008.get_invoice_number(l_invoice_id);

6091:
6092: IF (p_trace_on = 'Y') THEN
6093: -- Trace Entry
6094: IF lv_diff_amount > 0 THEN
6095: l_v_invoice_num := igs_fi_gen_008.get_invoice_number(l_invoice_id);
6096: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CHARGE_NUMBER') || ': ' || l_v_invoice_num);
6097: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CHG_AMOUNT') || ': ' || TO_CHAR(NVL(lv_diff_amount, 0)));
6098: fnd_file.new_line(fnd_file.log);
6099: END IF;

Line 10124: g_v_person_number := igs_fi_gen_008.get_party_number(p_person_id);

10120: RETURN FALSE;
10121: END IF;
10122: END IF;
10123:
10124: g_v_person_number := igs_fi_gen_008.get_party_number(p_person_id);
10125:
10126: -- Check for existence of incomplete Primary Program Transfers. If there are any, Fee Assessment cannot be carried out.
10127: -- This check needs to be done only in ACTUAL mode.
10128: IF g_c_fee_calc_mthd IN (g_v_career, g_v_primary_career)

Line 11166: l_v_invoice_num := igs_fi_gen_008.get_invoice_number(l_n_invoice_id);

11162: END IF;
11163: app_exception.raise_exception;
11164: END IF;
11165: IF (p_trace_on = 'Y') THEN
11166: l_v_invoice_num := igs_fi_gen_008.get_invoice_number(l_n_invoice_id);
11167: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'RET_CHG_NUM') || ': ' || l_v_invoice_num);
11168: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'RET_CHG_AMT') || ': ' || TO_CHAR(p_n_amount));
11169: fnd_file.new_line(fnd_file.log);
11170: END IF;