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_GL

Line 176: l_v_lkp_all CONSTANT VARCHAR2(60) := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'ALL');

172: --
173: X_ROWID VARCHAR2(25);
174: v_fa_sequence_number igs_fi_fee_as_all.transaction_id%TYPE;
175: g_v_person_number hz_parties.party_number%TYPE;
176: l_v_lkp_all CONSTANT VARCHAR2(60) := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'ALL');
177:
178: TYPE inst_prog_details_rec_type IS RECORD (
179: program_cd igs_ps_ver_all.course_cd%TYPE,
180: program_version igs_ps_ver_all.version_number%TYPE,

Line 952: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'RET_LEVEL') || ': ' || igs_fi_gen_gl.get_lkp_meaning('IGS_FI_RET_LEVEL', p_v_retention_level));

948: IF NVL(l_n_retention_amount, 0.0) > 0.0 THEN
949: log_to_fnd( p_v_module => 'finpl_prc_teach_prd_retn_levl',
950: p_v_string => 'Teach Period Retention - Retention Amount > 0, invoking create_retention_charge.');
951: IF (p_trace_on = 'Y') THEN
952: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'RET_LEVEL') || ': ' || igs_fi_gen_gl.get_lkp_meaning('IGS_FI_RET_LEVEL', p_v_retention_level));
953: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'WITHDWR_RET') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_v_cmp_withdr_ret));
954: END IF;
955:
956: create_retention_charge( p_n_person_id => p_person_id,

Line 953: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'WITHDWR_RET') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_v_cmp_withdr_ret));

949: log_to_fnd( p_v_module => 'finpl_prc_teach_prd_retn_levl',
950: p_v_string => 'Teach Period Retention - Retention Amount > 0, invoking create_retention_charge.');
951: IF (p_trace_on = 'Y') THEN
952: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'RET_LEVEL') || ': ' || igs_fi_gen_gl.get_lkp_meaning('IGS_FI_RET_LEVEL', p_v_retention_level));
953: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'WITHDWR_RET') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_v_cmp_withdr_ret));
954: END IF;
955:
956: create_retention_charge( p_n_person_id => p_person_id,
957: p_v_course_cd => p_course_cd,

Line 987: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'RET_LEVEL') || ': ' || igs_fi_gen_gl.get_lkp_meaning('IGS_FI_RET_LEVEL', p_v_retention_level));

983: IF NVL(l_n_retention_amount, 0.0) > 0.0 THEN
984: log_to_fnd( p_v_module => 'finpl_prc_teach_prd_retn_levl',
985: p_v_string => 'Teach Period Retention - Retention Amount > 0, invoking create_retention_charge.');
986: IF (p_trace_on = 'Y') THEN
987: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'RET_LEVEL') || ': ' || igs_fi_gen_gl.get_lkp_meaning('IGS_FI_RET_LEVEL', p_v_retention_level));
988: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'WITHDWR_RET') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_v_cmp_withdr_ret));
989: END IF;
990:
991: create_retention_charge( p_n_person_id => p_person_id,

Line 988: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'WITHDWR_RET') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_v_cmp_withdr_ret));

984: log_to_fnd( p_v_module => 'finpl_prc_teach_prd_retn_levl',
985: p_v_string => 'Teach Period Retention - Retention Amount > 0, invoking create_retention_charge.');
986: IF (p_trace_on = 'Y') THEN
987: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'RET_LEVEL') || ': ' || igs_fi_gen_gl.get_lkp_meaning('IGS_FI_RET_LEVEL', p_v_retention_level));
988: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'WITHDWR_RET') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', p_v_cmp_withdr_ret));
989: END IF;
990:
991: create_retention_charge( p_n_person_id => p_person_id,
992: p_v_course_cd => p_course_cd,

Line 2591: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'UNIT') || ': ' || p_derived_unit_cd);

2587: p_charge_rate := v_ftfarv_rec.chg_rate;
2588: IF (p_trace_on = 'Y') THEN
2589: fnd_file.new_line(fnd_file.log);
2590: IF (p_derived_unit_cd IS NOT NULL) THEN
2591: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'UNIT') || ': ' || p_derived_unit_cd);
2592: END IF;
2593: fnd_message.set_name('IGS', 'IGS_FI_LEV_CHG_RATE_NO');
2594: fnd_message.set_token('LEVEL', v_ftfarv_rec.s_relation_type);
2595: fnd_message.set_token('CH_RT', TO_CHAR(v_ftfarv_rec.chg_rate));

Line 2686: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'UNIT') || ': ' || p_derived_unit_cd);

2682: p_charge_rate := v_ftfarv_rec.chg_rate;
2683: IF (p_trace_on = 'Y') THEN
2684: fnd_file.new_line(fnd_file.log);
2685: IF (p_derived_unit_cd IS NOT NULL) THEN
2686: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'UNIT') || ': ' || p_derived_unit_cd);
2687: END IF;
2688: fnd_message.set_name('IGS', 'IGS_FI_LEV_CHG_RATE_NO');
2689: fnd_message.set_token('LEVEL', v_ftfarv_rec.s_relation_type);
2690: fnd_message.set_token('CH_RT', TO_CHAR(v_ftfarv_rec.chg_rate));

Line 2732: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'UNIT') || ': ' || p_derived_unit_cd);

2728: p_charge_rate := 0;
2729: IF (p_trace_on = 'Y') THEN
2730: fnd_file.new_line(fnd_file.log);
2731: IF (p_derived_unit_cd IS NOT NULL) THEN
2732: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'UNIT') || ': ' || p_derived_unit_cd);
2733: END IF;
2734: fnd_message.set_name ( 'IGS', 'IGS_FI_FEEASS_RATE_FOUND');
2735: fnd_file.put_line (fnd_file.log, fnd_message.get);
2736: fnd_message.set_name('IGS', 'IGS_FI_CHG_RATE');

Line 2752: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'UNIT') || ': ' || p_derived_unit_cd);

2748: -- fee ass rate records existed, but none matched
2749: IF (p_trace_on = 'Y') THEN
2750: fnd_file.new_line(fnd_file.log);
2751: IF (p_derived_unit_cd IS NOT NULL) THEN
2752: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'UNIT') || ': ' || p_derived_unit_cd);
2753: END IF;
2754: fnd_message.set_name('IGS', 'IGS_FI_FEEASS_RATE_EXISTS');
2755: fnd_file.put_line (fnd_file.log, fnd_message.get);
2756: fnd_message.set_name('IGS', 'IGS_FI_CHG_RATE');

Line 2964: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'LOW_RANGE') || ': ' || TO_CHAR(rec_elm_ranges.lower_range));

2960: fnd_file.put_line (fnd_file.log, fnd_message.get);
2961: fnd_message.set_name('IGS', 'IGS_FI_TESTING_ELEMENT_RANGE');
2962: fnd_message.set_token('ELM_RNG_NUM', TO_CHAR(rec_elm_ranges.range_number));
2963: fnd_file.put_line (fnd_file.log, fnd_message.get);
2964: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'LOW_RANGE') || ': ' || TO_CHAR(rec_elm_ranges.lower_range));
2965: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'UPPER_RANGE') || ': ' || TO_CHAR(rec_elm_ranges.upper_range));
2966: IF (rec_elm_ranges.override_chg_method_type IS NOT NULL) THEN
2967: fnd_message.set_name('IGS', 'IGS_FI_OVRRIDE_CHG_METH_TYPE');
2968: fnd_message.set_token('CHG_MTHD', igs_fi_gen_gl.get_lkp_meaning('CHG_METHOD', rec_elm_ranges.override_chg_method_type));

Line 2965: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'UPPER_RANGE') || ': ' || TO_CHAR(rec_elm_ranges.upper_range));

2961: fnd_message.set_name('IGS', 'IGS_FI_TESTING_ELEMENT_RANGE');
2962: fnd_message.set_token('ELM_RNG_NUM', TO_CHAR(rec_elm_ranges.range_number));
2963: fnd_file.put_line (fnd_file.log, fnd_message.get);
2964: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'LOW_RANGE') || ': ' || TO_CHAR(rec_elm_ranges.lower_range));
2965: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'UPPER_RANGE') || ': ' || TO_CHAR(rec_elm_ranges.upper_range));
2966: IF (rec_elm_ranges.override_chg_method_type IS NOT NULL) THEN
2967: fnd_message.set_name('IGS', 'IGS_FI_OVRRIDE_CHG_METH_TYPE');
2968: fnd_message.set_token('CHG_MTHD', igs_fi_gen_gl.get_lkp_meaning('CHG_METHOD', rec_elm_ranges.override_chg_method_type));
2969: fnd_file.put_line (fnd_file.log, fnd_message.get);

Line 2968: fnd_message.set_token('CHG_MTHD', igs_fi_gen_gl.get_lkp_meaning('CHG_METHOD', rec_elm_ranges.override_chg_method_type));

2964: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'LOW_RANGE') || ': ' || TO_CHAR(rec_elm_ranges.lower_range));
2965: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'UPPER_RANGE') || ': ' || TO_CHAR(rec_elm_ranges.upper_range));
2966: IF (rec_elm_ranges.override_chg_method_type IS NOT NULL) THEN
2967: fnd_message.set_name('IGS', 'IGS_FI_OVRRIDE_CHG_METH_TYPE');
2968: fnd_message.set_token('CHG_MTHD', igs_fi_gen_gl.get_lkp_meaning('CHG_METHOD', rec_elm_ranges.override_chg_method_type));
2969: fnd_file.put_line (fnd_file.log, fnd_message.get);
2970: END IF;
2971: END IF;
2972:

Line 3388: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'UNIT') || ': ' || p_t_fee_as_items(i).unit_cd);

3384: p_v_string => 'Global Element Range rate matches');
3385: IF (p_v_trace_on = 'Y') THEN
3386: fnd_file.new_line(fnd_file.log);
3387: IF (p_v_fee_trigger_cat <> gcst_institutn) THEN
3388: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'UNIT') || ': ' || p_t_fee_as_items(i).unit_cd);
3389: END IF;
3390: fnd_message.set_name('IGS', 'IGS_FI_LEV_CHG_RATE_NO');
3391: fnd_message.set_token('LEVEL', l_rec_global_rates.s_relation_type);
3392: fnd_message.set_token('CH_RT', TO_CHAR(l_rec_global_rates.chg_rate));

Line 3434: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'UNIT') || ': ' || p_t_fee_as_items(i).unit_cd);

3430: p_n_charge_rate := 0;
3431: p_t_fee_as_items(i).chg_rate := 0;
3432: IF (p_v_trace_on = 'Y') THEN
3433: fnd_file.new_line(fnd_file.log);
3434: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'UNIT') || ': ' || p_t_fee_as_items(i).unit_cd);
3435: fnd_message.set_name ( 'IGS', 'IGS_FI_NO_ELM_RNG_RATE_MATCH');
3436: fnd_file.put_line (fnd_file.log, fnd_message.get);
3437: fnd_message.set_name('IGS', 'IGS_FI_CHG_RATE');
3438: fnd_message.set_token('RATE', TO_CHAR(p_n_charge_rate) );

Line 3555: fnd_message.set_token('CHG_MTHD', igs_fi_gen_gl.get_lkp_meaning('CHG_METHOD', rec_sub_elm_ranges.sub_chg_method_code));

3551:
3552: IF (rec_sub_elm_ranges.sub_chg_method_code IS NOT NULL) THEN
3553: IF (p_v_trace_on = 'Y') THEN
3554: fnd_message.set_name('IGS', 'IGS_FI_OVRRIDE_CHG_METH_TYPE');
3555: fnd_message.set_token('CHG_MTHD', igs_fi_gen_gl.get_lkp_meaning('CHG_METHOD', rec_sub_elm_ranges.sub_chg_method_code));
3556: fnd_file.put_line (fnd_file.log, fnd_message.get);
3557: END IF;
3558: END IF;
3559:

Line 3651: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'LOW_RANGE') || ': ' || TO_CHAR(rec_sub_elm_ranges.sub_lower_range));

3647: p_derived_unit_level => NULL ) = TRUE ) THEN
3648: log_to_fnd( p_v_module => 'finpl_prc_element_ranges',
3649: p_v_string => 'Sub Element Range rate matches');
3650: IF (p_v_trace_on = 'Y') THEN
3651: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'LOW_RANGE') || ': ' || TO_CHAR(rec_sub_elm_ranges.sub_lower_range));
3652: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'UPPER_RANGE') || ': ' || TO_CHAR(rec_sub_elm_ranges.sub_upper_range));
3653: fnd_message.set_name('IGS', 'IGS_FI_LEV_CHG_RATE_NO');
3654: fnd_message.set_token('LEVEL', l_rec_sub_rates.s_relation_type);
3655: fnd_message.set_token('CH_RT', TO_CHAR(l_rec_sub_rates.chg_rate));

Line 3652: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'UPPER_RANGE') || ': ' || TO_CHAR(rec_sub_elm_ranges.sub_upper_range));

3648: log_to_fnd( p_v_module => 'finpl_prc_element_ranges',
3649: p_v_string => 'Sub Element Range rate matches');
3650: IF (p_v_trace_on = 'Y') THEN
3651: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'LOW_RANGE') || ': ' || TO_CHAR(rec_sub_elm_ranges.sub_lower_range));
3652: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'UPPER_RANGE') || ': ' || TO_CHAR(rec_sub_elm_ranges.sub_upper_range));
3653: fnd_message.set_name('IGS', 'IGS_FI_LEV_CHG_RATE_NO');
3654: fnd_message.set_token('LEVEL', l_rec_sub_rates.s_relation_type);
3655: fnd_message.set_token('CH_RT', TO_CHAR(l_rec_sub_rates.chg_rate));
3656: fnd_message.set_token('RT_NUM', TO_CHAR(l_rec_sub_rates.rate_number));

Line 5135: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'NEW_AMOUNT') || ': ' || TO_CHAR(p_new_ass_amount));

5131: fnd_file.new_line(fnd_file.log);
5132: fnd_message.set_name('IGS', 'IGS_FI_ST_DT_ASS_AMT');
5133: fnd_message.set_token('OLD_AMT', TO_CHAR(p_old_ass_amount));
5134: fnd_file.put_line (fnd_file.log, fnd_message.get);
5135: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'NEW_AMOUNT') || ': ' || TO_CHAR(p_new_ass_amount));
5136: fnd_file.new_line(fnd_file.log);
5137: END IF;
5138: END IF;
5139:

Line 5199: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'RET_LEVEL') || ': ' || igs_fi_gen_gl.get_lkp_meaning('IGS_FI_RET_LEVEL', l_v_retention_level));

5195: log_to_fnd( p_v_module => 'finpl_chk_debt_ret_sched',
5196: p_v_string => 'Complete Withdrawal Retention - Retention Amount > 0, invoking create_retention_charge.');
5197: IF (p_trace_on = 'Y') THEN
5198: fnd_file.new_line(fnd_file.log);
5199: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'RET_LEVEL') || ': ' || igs_fi_gen_gl.get_lkp_meaning('IGS_FI_RET_LEVEL', l_v_retention_level));
5200: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'WITHDWR_RET') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', l_v_cmp_withdr_ret));
5201: END IF;
5202: create_retention_charge( p_n_person_id => p_person_id,
5203: p_v_course_cd => p_course_cd,

Line 5200: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'WITHDWR_RET') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', l_v_cmp_withdr_ret));

5196: p_v_string => 'Complete Withdrawal Retention - Retention Amount > 0, invoking create_retention_charge.');
5197: IF (p_trace_on = 'Y') THEN
5198: fnd_file.new_line(fnd_file.log);
5199: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'RET_LEVEL') || ': ' || igs_fi_gen_gl.get_lkp_meaning('IGS_FI_RET_LEVEL', l_v_retention_level));
5200: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'WITHDWR_RET') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', l_v_cmp_withdr_ret));
5201: END IF;
5202: create_retention_charge( p_n_person_id => p_person_id,
5203: p_v_course_cd => p_course_cd,
5204: p_v_fee_cal_type => p_fee_cal_type,

Line 5241: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'RET_LEVEL') || ': ' || igs_fi_gen_gl.get_lkp_meaning('IGS_FI_RET_LEVEL', l_v_retention_level));

5237: log_to_fnd( p_v_module => 'finpl_chk_debt_ret_sched',
5238: p_v_string => 'Fee Period retention - Retention Amount > 0, invoking create_retention_charge.');
5239: IF (p_trace_on = 'Y') THEN
5240: fnd_file.new_line(fnd_file.log);
5241: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'RET_LEVEL') || ': ' || igs_fi_gen_gl.get_lkp_meaning('IGS_FI_RET_LEVEL', l_v_retention_level));
5242: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'WITHDWR_RET') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', l_v_cmp_withdr_ret));
5243: END IF;
5244:
5245: create_retention_charge( p_n_person_id => p_person_id,

Line 5242: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'WITHDWR_RET') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', l_v_cmp_withdr_ret));

5238: p_v_string => 'Fee Period retention - Retention Amount > 0, invoking create_retention_charge.');
5239: IF (p_trace_on = 'Y') THEN
5240: fnd_file.new_line(fnd_file.log);
5241: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'RET_LEVEL') || ': ' || igs_fi_gen_gl.get_lkp_meaning('IGS_FI_RET_LEVEL', l_v_retention_level));
5242: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'WITHDWR_RET') || ': ' || igs_fi_gen_gl.get_lkp_meaning('YES_NO', l_v_cmp_withdr_ret));
5243: END IF;
5244:
5245: create_retention_charge( p_n_person_id => p_person_id,
5246: p_v_course_cd => p_course_cd,

Line 5967: x_transaction_amount => igs_fi_gen_gl.get_formatted_amount(NVL(lv_sum_diff,0)),

5963: x_fee_ci_sequence_number => p_fee_ci_sequence_number,
5964: x_fee_cat => v_fee_cat,
5965: x_s_transaction_type => cst_assessment,
5966: x_transaction_dt => TRUNC(SYSDATE),
5967: x_transaction_amount => igs_fi_gen_gl.get_formatted_amount(NVL(lv_sum_diff,0)),
5968: x_currency_cd => p_currency,
5969: x_exchange_rate => 1,
5970: x_chg_elements => v_chg_elements,
5971: x_effective_dt => TRUNC(p_effective_dt),

Line 6096: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'CHARGE_NUMBER') || ': ' || l_v_invoice_num);

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;
6100: END IF;

Line 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)));

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;
6100: END IF;
6101:

Line 6126: x_amount => igs_fi_gen_gl.get_formatted_amount(NVL(lv_diff_amount,0)),

6122: x_rul_sequence_number => t_fee_as_items(i).rul_sequence_number,
6123: x_s_chg_method_type => t_fee_as_items(i).chg_method_type,
6124: x_description => t_fee_as_items(i).description,
6125: x_chg_elements => t_fee_as_items(i).chg_elements,
6126: x_amount => igs_fi_gen_gl.get_formatted_amount(NVL(lv_diff_amount,0)),
6127: x_fee_effective_dt => TRUNC(p_effective_dt),
6128: x_course_cd => t_fee_as_items(i).course_cd,
6129: x_crs_version_number => t_fee_as_items(i).crs_version_number,
6130: x_course_attempt_status => l_crs_attempt_status,

Line 6143: x_chg_rate => igs_fi_gen_gl.get_formatted_amount(t_fee_as_items(i).chg_rate),

6139: x_org_unit_cd => t_fee_as_items(i).org_unit_cd,
6140: x_class_standing => t_fee_as_items(i).class_standing,
6141: x_residency_status_cd => t_fee_as_items(i).residency_status_cd,
6142: x_uoo_id => t_fee_as_items(i).uoo_id,
6143: x_chg_rate => igs_fi_gen_gl.get_formatted_amount(t_fee_as_items(i).chg_rate),
6144: x_unit_set_cd => t_fee_as_items(i).unit_set_cd,
6145: x_us_version_number => t_fee_as_items(i).us_version_number,
6146: x_unit_type_id => t_fee_as_items(i).unit_type_id,
6147: x_unit_class => t_fee_as_items(i).unit_class,

Line 6379: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_TRIGGER_GROUP', 'UNIT') || ': ' || p_unit_cd);

6375: IF (p_charge_method = gcst_flatrate) THEN
6376: NULL;
6377: ELSE
6378: fnd_file.new_line(fnd_file.log);
6379: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_TRIGGER_GROUP', 'UNIT') || ': ' || p_unit_cd);
6380: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TEACH_CAL_ALT_CD') || ': ' || p_cal_type ||
6381: ' ' || TO_CHAR(p_effective_start_dt,'DD/MM/YYYY') ||
6382: ' ' || TO_CHAR(p_effective_end_dt,'DD/MM/YYYY'));
6383: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'LOC') || ': ' || p_location_cd);

Line 6380: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TEACH_CAL_ALT_CD') || ': ' || p_cal_type ||

6376: NULL;
6377: ELSE
6378: fnd_file.new_line(fnd_file.log);
6379: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_TRIGGER_GROUP', 'UNIT') || ': ' || p_unit_cd);
6380: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TEACH_CAL_ALT_CD') || ': ' || p_cal_type ||
6381: ' ' || TO_CHAR(p_effective_start_dt,'DD/MM/YYYY') ||
6382: ' ' || TO_CHAR(p_effective_end_dt,'DD/MM/YYYY'));
6383: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'LOC') || ': ' || p_location_cd);
6384: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'UNIT_CLASS') || ': ' || lv_unit_class_att);

Line 6383: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'LOC') || ': ' || p_location_cd);

6379: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_TRIGGER_GROUP', 'UNIT') || ': ' || p_unit_cd);
6380: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TEACH_CAL_ALT_CD') || ': ' || p_cal_type ||
6381: ' ' || TO_CHAR(p_effective_start_dt,'DD/MM/YYYY') ||
6382: ' ' || TO_CHAR(p_effective_end_dt,'DD/MM/YYYY'));
6383: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'LOC') || ': ' || p_location_cd);
6384: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'UNIT_CLASS') || ': ' || lv_unit_class_att);
6385: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'AUDITED') || ': ' || l_v_no_assessment_ind);
6386: IF ((p_unit_cd IS NOT NULL) AND (p_unit_version_number IS NOT NULL)) THEN
6387: fnd_message.set_name('IGS', 'IGS_FI_UNIT_CD_VERSION');

Line 6384: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'UNIT_CLASS') || ': ' || lv_unit_class_att);

6380: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TEACH_CAL_ALT_CD') || ': ' || p_cal_type ||
6381: ' ' || TO_CHAR(p_effective_start_dt,'DD/MM/YYYY') ||
6382: ' ' || TO_CHAR(p_effective_end_dt,'DD/MM/YYYY'));
6383: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'LOC') || ': ' || p_location_cd);
6384: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'UNIT_CLASS') || ': ' || lv_unit_class_att);
6385: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'AUDITED') || ': ' || l_v_no_assessment_ind);
6386: IF ((p_unit_cd IS NOT NULL) AND (p_unit_version_number IS NOT NULL)) THEN
6387: fnd_message.set_name('IGS', 'IGS_FI_UNIT_CD_VERSION');
6388: fnd_message.set_token('UNIT_CD', p_unit_cd);

Line 6385: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'AUDITED') || ': ' || l_v_no_assessment_ind);

6381: ' ' || TO_CHAR(p_effective_start_dt,'DD/MM/YYYY') ||
6382: ' ' || TO_CHAR(p_effective_end_dt,'DD/MM/YYYY'));
6383: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'LOC') || ': ' || p_location_cd);
6384: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'UNIT_CLASS') || ': ' || lv_unit_class_att);
6385: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'AUDITED') || ': ' || l_v_no_assessment_ind);
6386: IF ((p_unit_cd IS NOT NULL) AND (p_unit_version_number IS NOT NULL)) THEN
6387: fnd_message.set_name('IGS', 'IGS_FI_UNIT_CD_VERSION');
6388: fnd_message.set_token('UNIT_CD', p_unit_cd);
6389: fnd_message.set_token('UNIT_VER', TO_CHAR(p_unit_version_number));

Line 6397: igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'UNIT_PROG_TYP') ||

6393: fnd_message.set_name('IGS', 'IGS_FI_NO_UNIT_TYPE');
6394: fnd_file.put_line (fnd_file.log, fnd_message.get);
6395: ELSE
6396: fnd_file.put_line (fnd_file.log,
6397: igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'UNIT_PROG_TYP') ||
6398: ': ' || finpl_get_uptl(p_n_unit_type_id));
6399: END IF;
6400: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'UNIT_LEVEL') || ': ' || p_v_unit_level);
6401: IF (p_v_unit_mode IS NULL) THEN

Line 6400: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'UNIT_LEVEL') || ': ' || p_v_unit_level);

6396: fnd_file.put_line (fnd_file.log,
6397: igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'UNIT_PROG_TYP') ||
6398: ': ' || finpl_get_uptl(p_n_unit_type_id));
6399: END IF;
6400: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'UNIT_LEVEL') || ': ' || p_v_unit_level);
6401: IF (p_v_unit_mode IS NULL) THEN
6402: fnd_message.set_name('IGS', 'IGS_FI_NO_UNIT_MODE');
6403: fnd_file.put_line (fnd_file.log, fnd_message.get);
6404: ELSE

Line 6405: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'UNIT_MODE') || ': ' || p_v_unit_mode);

6401: IF (p_v_unit_mode IS NULL) THEN
6402: fnd_message.set_name('IGS', 'IGS_FI_NO_UNIT_MODE');
6403: fnd_file.put_line (fnd_file.log, fnd_message.get);
6404: ELSE
6405: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'UNIT_MODE') || ': ' || p_v_unit_mode);
6406: END IF;
6407: END IF;
6408: END IF;
6409:

Line 6510: fnd_message.set_token('YES_NO', igs_fi_gen_gl.get_lkp_meaning('YES_NO', 'Y') );

6506: IF (p_trace_on = 'Y') THEN
6507: -- Trace Entry
6508: fnd_file.new_line(fnd_file.log);
6509: fnd_message.set_name ( 'IGS', 'IGS_FI_LOAD_INCURRED');
6510: fnd_message.set_token('YES_NO', igs_fi_gen_gl.get_lkp_meaning('YES_NO', 'Y') );
6511: fnd_file.put_line (fnd_file.log, fnd_message.get);
6512: fnd_message.set_name('IGS', 'IGS_FI_CHG_METH_TYPE');
6513: fnd_message.set_token('CHG_MTHD', igs_fi_gen_gl.get_lkp_meaning('CHG_METHOD', p_charge_method));
6514: fnd_file.put_line (fnd_file.log, fnd_message.get);

Line 6513: fnd_message.set_token('CHG_MTHD', igs_fi_gen_gl.get_lkp_meaning('CHG_METHOD', p_charge_method));

6509: fnd_message.set_name ( 'IGS', 'IGS_FI_LOAD_INCURRED');
6510: fnd_message.set_token('YES_NO', igs_fi_gen_gl.get_lkp_meaning('YES_NO', 'Y') );
6511: fnd_file.put_line (fnd_file.log, fnd_message.get);
6512: fnd_message.set_name('IGS', 'IGS_FI_CHG_METH_TYPE');
6513: fnd_message.set_token('CHG_MTHD', igs_fi_gen_gl.get_lkp_meaning('CHG_METHOD', p_charge_method));
6514: fnd_file.put_line (fnd_file.log, fnd_message.get);
6515: fnd_message.set_name('IGS', 'IGS_FI_CHRG_METHOD_ELEMENTS');
6516: fnd_message.set_token('CHG_ELM', TO_CHAR(p_charge_elements));
6517: fnd_file.put_line (fnd_file.log, fnd_message.get);

Line 6562: fnd_message.set_token('YES_NO', igs_fi_gen_gl.get_lkp_meaning('YES_NO', 'Y') );

6558: END;
6559: IF (p_trace_on = 'Y') THEN
6560: -- Trace Entry
6561: fnd_message.set_name ( 'IGS', 'IGS_FI_LOAD_INCURRED');
6562: fnd_message.set_token('YES_NO', igs_fi_gen_gl.get_lkp_meaning('YES_NO', 'Y') );
6563: fnd_file.put_line (fnd_file.log, fnd_message.get);
6564: fnd_message.set_name('IGS', 'IGS_FI_CHRG_METHOD_ELEMENTS');
6565: fnd_message.set_token('CHG_ELM', TO_CHAR(p_charge_elements));
6566: fnd_file.put_line (fnd_file.log, fnd_message.get);

Line 6615: fnd_message.set_token('YES_NO', igs_fi_gen_gl.get_lkp_meaning('YES_NO', 'Y') );

6611: IF l_v_no_assessment_ind = 'N' THEN
6612: l_n_eftsu := p_eftsu;
6613: END IF;
6614: fnd_message.set_name('IGS', 'IGS_FI_LOAD_INCURRED');
6615: fnd_message.set_token('YES_NO', igs_fi_gen_gl.get_lkp_meaning('YES_NO', 'Y') );
6616: fnd_file.put_line (fnd_file.log, fnd_message.get);
6617: fnd_message.set_name('IGS', 'IGS_FI_CHG_ELE');
6618: fnd_message.set_token('ELEMENTS', TO_CHAR(NVL(p_eftsu, 0)));
6619: fnd_file.put_line (fnd_file.log, fnd_message.get);

Line 6668: fnd_message.set_token('YES_NO', igs_fi_gen_gl.get_lkp_meaning('YES_NO', 'Y') );

6664: IF l_v_no_assessment_ind = 'N' THEN
6665: l_n_credit_points := p_credit_points;
6666: END IF;
6667: fnd_message.set_name('IGS', 'IGS_FI_LOAD_INCURRED');
6668: fnd_message.set_token('YES_NO', igs_fi_gen_gl.get_lkp_meaning('YES_NO', 'Y') );
6669: fnd_file.put_line (fnd_file.log, fnd_message.get);
6670: fnd_message.set_name('IGS', 'IGS_FI_CHG_ELE');
6671: fnd_message.set_token('ELEMENTS', TO_CHAR(NVL(p_credit_points, 0)));
6672: fnd_file.put_line (fnd_file.log, fnd_message.get);

Line 7426: fnd_message.set_token('YES_NO', igs_fi_gen_gl.get_lkp_meaning('YES_NO', 'Y') );

7422: END IF;
7423: IF (p_trace_on = 'Y') THEN
7424: fnd_file.new_line(fnd_file.log);
7425: fnd_message.set_name ( 'IGS', 'IGS_FI_LOAD_INCURRED');
7426: fnd_message.set_token('YES_NO', igs_fi_gen_gl.get_lkp_meaning('YES_NO', 'Y') );
7427: fnd_file.put_line (fnd_file.log, fnd_message.get);
7428: fnd_message.set_name('IGS', 'IGS_FI_CHRG_METHOD_ELEMENTS');
7429: fnd_message.set_token('CHG_ELM', TO_CHAR(p_charge_elements));
7430: fnd_file.put_line (fnd_file.log, fnd_message.get);

Line 7445: fnd_message.set_token('YES_NO', igs_fi_gen_gl.get_lkp_meaning('YES_NO', 'Y') );

7441: END IF;
7442: IF (p_trace_on = 'Y') THEN
7443: fnd_file.new_line(fnd_file.log);
7444: fnd_message.set_name ( 'IGS', 'IGS_FI_LOAD_INCURRED');
7445: fnd_message.set_token('YES_NO', igs_fi_gen_gl.get_lkp_meaning('YES_NO', 'Y') );
7446: fnd_file.put_line (fnd_file.log, fnd_message.get);
7447: fnd_message.set_name('IGS', 'IGS_FI_CHG_ELE');
7448: fnd_message.set_token('ELEMENTS', TO_CHAR(p_charge_elements));
7449: fnd_file.put_line (fnd_file.log, fnd_message.get);

Line 7485: fnd_message.set_token('YES_NO', igs_fi_gen_gl.get_lkp_meaning('YES_NO', 'Y') );

7481: || ', Eftsu:' || v_eftsu || ', Charge Elements: ' || p_charge_elements );
7482: IF (p_trace_on = 'Y') THEN
7483: fnd_file.new_line(fnd_file.log);
7484: fnd_message.set_name('IGS', 'IGS_FI_LOAD_INCURRED');
7485: fnd_message.set_token('YES_NO', igs_fi_gen_gl.get_lkp_meaning('YES_NO', 'Y') );
7486: fnd_file.put_line (fnd_file.log, fnd_message.get);
7487: fnd_message.set_name('IGS', 'IGS_FI_CHG_ELE');
7488: fnd_message.set_token('ELEMENTS', TO_CHAR(NVL(v_eftsu, 0)));
7489: fnd_file.put_line (fnd_file.log, fnd_message.get);

Line 7517: fnd_message.set_token('YES_NO', igs_fi_gen_gl.get_lkp_meaning('YES_NO', 'Y') );

7513: || ', Credit Points:' || v_credit_points || ', Charge Elements: ' || p_charge_elements );
7514: IF (p_trace_on = 'Y') THEN
7515: fnd_file.new_line(fnd_file.log);
7516: fnd_message.set_name('IGS', 'IGS_FI_LOAD_INCURRED');
7517: fnd_message.set_token('YES_NO', igs_fi_gen_gl.get_lkp_meaning('YES_NO', 'Y') );
7518: fnd_file.put_line (fnd_file.log, fnd_message.get);
7519: fnd_message.set_name('IGS', 'IGS_FI_CHG_ELE');
7520: fnd_message.set_token('ELEMENTS', TO_CHAR(NVL(v_credit_points, 0)));
7521: fnd_file.put_line (fnd_file.log, fnd_message.get);

Line 8406: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT') || ': ' || TO_CHAR(v_fcci_fss_rec.start_dt, 'DD/MM/YYYY'));

8402: fnd_file.new_line(fnd_file.log);
8403: fnd_message.set_name('IGS', 'IGS_FI_FEE_CAL');
8404: fnd_message.set_token('CAL_TYPE', v_fcci_fss_rec.fee_cal_type);
8405: fnd_file.put_line (fnd_file.log, fnd_message.get);
8406: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT') || ': ' || TO_CHAR(v_fcci_fss_rec.start_dt, 'DD/MM/YYYY'));
8407: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'END_DT') || ': ' || TO_CHAR(v_fcci_fss_rec.end_dt, 'DD/MM/YYYY'));
8408: END IF;
8409:
8410: log_to_fnd( p_v_module => 'finpl_prc_fee_cat_fee_liab',

Line 8407: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'END_DT') || ': ' || TO_CHAR(v_fcci_fss_rec.end_dt, 'DD/MM/YYYY'));

8403: fnd_message.set_name('IGS', 'IGS_FI_FEE_CAL');
8404: fnd_message.set_token('CAL_TYPE', v_fcci_fss_rec.fee_cal_type);
8405: fnd_file.put_line (fnd_file.log, fnd_message.get);
8406: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT') || ': ' || TO_CHAR(v_fcci_fss_rec.start_dt, 'DD/MM/YYYY'));
8407: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'END_DT') || ': ' || TO_CHAR(v_fcci_fss_rec.end_dt, 'DD/MM/YYYY'));
8408: END IF;
8409:
8410: log_to_fnd( p_v_module => 'finpl_prc_fee_cat_fee_liab',
8411: p_v_string => 'Loop Accross FCFLs..' );

Line 8569: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT') || ': ' || TO_CHAR(v_fcflv_start_dt, 'DD/MM/YYYY'));

8565: CLOSE c_daiv;
8566: fnd_message.set_name('IGS', 'IGS_FI_START_DATE_ALIAS');
8567: fnd_message.set_token('DT_ALIAS', v_fcflv_rec.start_dt_alias ||' ');
8568: fnd_file.put (fnd_file.log, fnd_message.get);
8569: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT') || ': ' || TO_CHAR(v_fcflv_start_dt, 'DD/MM/YYYY'));
8570: END IF;
8571: IF (v_fcflv_rec.end_dt_alias IS NOT NULL) THEN
8572: OPEN c_daiv (
8573: v_fcflv_rec.end_dt_alias,

Line 8582: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'END_DT') || ': ' || TO_CHAR(v_fcflv_end_dt, 'DD/MM/YYYY'));

8578: CLOSE c_daiv;
8579: fnd_message.set_name('IGS', 'IGS_FI_END_DATE_ALIAS');
8580: fnd_message.set_token('DT_ALIAS', v_fcflv_rec.end_dt_alias ||' ');
8581: fnd_file.put (fnd_file.log, fnd_message.get);
8582: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'END_DT') || ': ' || TO_CHAR(v_fcflv_end_dt, 'DD/MM/YYYY'));
8583: END IF;
8584:
8585: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_TYPE') || ': ' || v_fcflv_rec.fee_type);
8586: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'SYSTEM_FEE_TYPE') || ': ' || v_fcflv_rec.s_fee_type);

Line 8585: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_TYPE') || ': ' || v_fcflv_rec.fee_type);

8581: fnd_file.put (fnd_file.log, fnd_message.get);
8582: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'END_DT') || ': ' || TO_CHAR(v_fcflv_end_dt, 'DD/MM/YYYY'));
8583: END IF;
8584:
8585: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_TYPE') || ': ' || v_fcflv_rec.fee_type);
8586: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'SYSTEM_FEE_TYPE') || ': ' || v_fcflv_rec.s_fee_type);
8587: fnd_message.set_name('IGS', 'IGS_FI_FEE_TYPE_TRG_CAT');
8588: fnd_message.set_token('S_FEE_TRIG', v_fcflv_rec.s_fee_trigger_cat);
8589: fnd_file.put_line (fnd_file.log, fnd_message.get);

Line 8586: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'SYSTEM_FEE_TYPE') || ': ' || v_fcflv_rec.s_fee_type);

8582: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'END_DT') || ': ' || TO_CHAR(v_fcflv_end_dt, 'DD/MM/YYYY'));
8583: END IF;
8584:
8585: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_TYPE') || ': ' || v_fcflv_rec.fee_type);
8586: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'SYSTEM_FEE_TYPE') || ': ' || v_fcflv_rec.s_fee_type);
8587: fnd_message.set_name('IGS', 'IGS_FI_FEE_TYPE_TRG_CAT');
8588: fnd_message.set_token('S_FEE_TRIG', v_fcflv_rec.s_fee_trigger_cat);
8589: fnd_file.put_line (fnd_file.log, fnd_message.get);
8590:

Line 8592: fnd_message.set_token('CHG_MTHD', igs_fi_gen_gl.get_lkp_meaning('CHG_METHOD', v_fcflv_rec.s_chg_method_type));

8588: fnd_message.set_token('S_FEE_TRIG', v_fcflv_rec.s_fee_trigger_cat);
8589: fnd_file.put_line (fnd_file.log, fnd_message.get);
8590:
8591: fnd_message.set_name('IGS', 'IGS_FI_CHG_METH_TYPE');
8592: fnd_message.set_token('CHG_MTHD', igs_fi_gen_gl.get_lkp_meaning('CHG_METHOD', v_fcflv_rec.s_chg_method_type));
8593: fnd_file.put_line (fnd_file.log, fnd_message.get);
8594: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'RULE_SEQ') || ': ' || TO_CHAR(v_fcflv_rec.rul_sequence_number));
8595: IF (v_fcflv_rec.scope_rul_sequence_num IS NOT NULL) THEN
8596: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'SEL_CRI_RULE') || ': ' || TO_CHAR(v_fcflv_rec.scope_rul_sequence_num));

Line 8594: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'RULE_SEQ') || ': ' || TO_CHAR(v_fcflv_rec.rul_sequence_number));

8590:
8591: fnd_message.set_name('IGS', 'IGS_FI_CHG_METH_TYPE');
8592: fnd_message.set_token('CHG_MTHD', igs_fi_gen_gl.get_lkp_meaning('CHG_METHOD', v_fcflv_rec.s_chg_method_type));
8593: fnd_file.put_line (fnd_file.log, fnd_message.get);
8594: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'RULE_SEQ') || ': ' || TO_CHAR(v_fcflv_rec.rul_sequence_number));
8595: IF (v_fcflv_rec.scope_rul_sequence_num IS NOT NULL) THEN
8596: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'SEL_CRI_RULE') || ': ' || TO_CHAR(v_fcflv_rec.scope_rul_sequence_num));
8597: END IF;
8598: IF (v_fcflv_rec.elm_rng_order_name IS NOT NULL) THEN

Line 8596: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'SEL_CRI_RULE') || ': ' || TO_CHAR(v_fcflv_rec.scope_rul_sequence_num));

8592: fnd_message.set_token('CHG_MTHD', igs_fi_gen_gl.get_lkp_meaning('CHG_METHOD', v_fcflv_rec.s_chg_method_type));
8593: fnd_file.put_line (fnd_file.log, fnd_message.get);
8594: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'RULE_SEQ') || ': ' || TO_CHAR(v_fcflv_rec.rul_sequence_number));
8595: IF (v_fcflv_rec.scope_rul_sequence_num IS NOT NULL) THEN
8596: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'SEL_CRI_RULE') || ': ' || TO_CHAR(v_fcflv_rec.scope_rul_sequence_num));
8597: END IF;
8598: IF (v_fcflv_rec.elm_rng_order_name IS NOT NULL) THEN
8599: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'ELM_RNG_ORDER') || ': ' || v_fcflv_rec.elm_rng_order_name);
8600: END IF;

Line 8599: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'ELM_RNG_ORDER') || ': ' || v_fcflv_rec.elm_rng_order_name);

8595: IF (v_fcflv_rec.scope_rul_sequence_num IS NOT NULL) THEN
8596: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'SEL_CRI_RULE') || ': ' || TO_CHAR(v_fcflv_rec.scope_rul_sequence_num));
8597: END IF;
8598: IF (v_fcflv_rec.elm_rng_order_name IS NOT NULL) THEN
8599: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'ELM_RNG_ORDER') || ': ' || v_fcflv_rec.elm_rng_order_name);
8600: END IF;
8601: IF (v_fcflv_rec.max_chg_elements IS NOT NULL) THEN
8602: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'MAX_CHG_ELM') || ': ' || TO_CHAR(v_fcflv_rec.max_chg_elements));
8603: END IF;

Line 8602: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'MAX_CHG_ELM') || ': ' || TO_CHAR(v_fcflv_rec.max_chg_elements));

8598: IF (v_fcflv_rec.elm_rng_order_name IS NOT NULL) THEN
8599: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'ELM_RNG_ORDER') || ': ' || v_fcflv_rec.elm_rng_order_name);
8600: END IF;
8601: IF (v_fcflv_rec.max_chg_elements IS NOT NULL) THEN
8602: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'MAX_CHG_ELM') || ': ' || TO_CHAR(v_fcflv_rec.max_chg_elements));
8603: END IF;
8604: END IF;
8605: END IF; /* v_next_fcfl_flag = FALSE */
8606:

Line 9860: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'STATUS') || ': ' || l_predictive_progs_tbl(l_n_cntr).crs_attempt_status);

9856: fnd_message.set_name ( 'IGS', 'IGS_FI_MAJOR_PRGLOC_USED');
9857: fnd_message.set_token('PROG', l_predictive_progs_tbl(l_n_cntr).program_cd);
9858: fnd_message.set_token('VER', TO_CHAR(l_predictive_progs_tbl(l_n_cntr).program_version));
9859: fnd_file.put_line (fnd_file.log, fnd_message.get);
9860: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'STATUS') || ': ' || l_predictive_progs_tbl(l_n_cntr).crs_attempt_status);
9861: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT') || ': ' || TO_CHAR(l_predictive_progs_tbl(l_n_cntr).crs_commence_dt, 'DD/MM/YYYY'));
9862: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAT') || ': ' || l_predictive_progs_tbl(l_n_cntr).fee_cat);
9863: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'LOC') || ': ' || l_predictive_progs_tbl(l_n_cntr).location_cd);
9864: fnd_message.set_name ( 'IGS', 'IGS_FI_DER_ATT_TYPE_GOVT_MODE');

Line 9861: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT') || ': ' || TO_CHAR(l_predictive_progs_tbl(l_n_cntr).crs_commence_dt, 'DD/MM/YYYY'));

9857: fnd_message.set_token('PROG', l_predictive_progs_tbl(l_n_cntr).program_cd);
9858: fnd_message.set_token('VER', TO_CHAR(l_predictive_progs_tbl(l_n_cntr).program_version));
9859: fnd_file.put_line (fnd_file.log, fnd_message.get);
9860: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'STATUS') || ': ' || l_predictive_progs_tbl(l_n_cntr).crs_attempt_status);
9861: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT') || ': ' || TO_CHAR(l_predictive_progs_tbl(l_n_cntr).crs_commence_dt, 'DD/MM/YYYY'));
9862: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAT') || ': ' || l_predictive_progs_tbl(l_n_cntr).fee_cat);
9863: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'LOC') || ': ' || l_predictive_progs_tbl(l_n_cntr).location_cd);
9864: fnd_message.set_name ( 'IGS', 'IGS_FI_DER_ATT_TYPE_GOVT_MODE');
9865: fnd_message.set_token('ATT_MODE', l_predictive_progs_tbl(l_n_cntr).att_mode);

Line 9862: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAT') || ': ' || l_predictive_progs_tbl(l_n_cntr).fee_cat);

9858: fnd_message.set_token('VER', TO_CHAR(l_predictive_progs_tbl(l_n_cntr).program_version));
9859: fnd_file.put_line (fnd_file.log, fnd_message.get);
9860: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'STATUS') || ': ' || l_predictive_progs_tbl(l_n_cntr).crs_attempt_status);
9861: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT') || ': ' || TO_CHAR(l_predictive_progs_tbl(l_n_cntr).crs_commence_dt, 'DD/MM/YYYY'));
9862: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAT') || ': ' || l_predictive_progs_tbl(l_n_cntr).fee_cat);
9863: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'LOC') || ': ' || l_predictive_progs_tbl(l_n_cntr).location_cd);
9864: fnd_message.set_name ( 'IGS', 'IGS_FI_DER_ATT_TYPE_GOVT_MODE');
9865: fnd_message.set_token('ATT_MODE', l_predictive_progs_tbl(l_n_cntr).att_mode);
9866: fnd_file.put_line (fnd_file.log, fnd_message.get);

Line 9863: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'LOC') || ': ' || l_predictive_progs_tbl(l_n_cntr).location_cd);

9859: fnd_file.put_line (fnd_file.log, fnd_message.get);
9860: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'STATUS') || ': ' || l_predictive_progs_tbl(l_n_cntr).crs_attempt_status);
9861: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT') || ': ' || TO_CHAR(l_predictive_progs_tbl(l_n_cntr).crs_commence_dt, 'DD/MM/YYYY'));
9862: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAT') || ': ' || l_predictive_progs_tbl(l_n_cntr).fee_cat);
9863: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'LOC') || ': ' || l_predictive_progs_tbl(l_n_cntr).location_cd);
9864: fnd_message.set_name ( 'IGS', 'IGS_FI_DER_ATT_TYPE_GOVT_MODE');
9865: fnd_message.set_token('ATT_MODE', l_predictive_progs_tbl(l_n_cntr).att_mode);
9866: fnd_file.put_line (fnd_file.log, fnd_message.get);
9867: fnd_message.set_name ( 'IGS', 'IGS_FI_ATTTYPE_GOVT_ATTMODE');

Line 10310: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS', 'PERSON_NAME') || ': ' || l_v_person_name);

10306: fnd_file.put_line( fnd_file.log, RPAD('-', '79', '-') );
10307: fnd_message.set_name('IGS', 'IGS_FI_PERSON_NUM');
10308: fnd_message.set_token('PERSON_NUM', g_v_person_number);
10309: fnd_file.put_line (fnd_file.log, fnd_message.get);
10310: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS', 'PERSON_NAME') || ': ' || l_v_person_name);
10311: END IF;
10312:
10313: tbl_wav_fcfl.DELETE;
10314:

Line 10357: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TITLE') || ': ' || rec_scas.short_title);

10353: fnd_message.set_name ( 'IGS', 'IGS_FI_MAJOR_PRGLOC_USED');
10354: fnd_message.set_token('PROG', rec_scas.program_cd);
10355: fnd_message.set_token('VER', TO_CHAR(rec_scas.program_version));
10356: fnd_file.put_line (fnd_file.log, fnd_message.get);
10357: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TITLE') || ': ' || rec_scas.short_title);
10358: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'STATUS') || ': ' || igs_fi_gen_gl.get_lkp_meaning('VS_EN_COURSE_ATMPT_STATUS', rec_scas.course_attempt_status));
10359: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT') || ': ' || TO_CHAR(rec_scas.commencement_dt, 'DD/MM/YYYY'));
10360: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAT') || ': ' || l_fee_category);
10361: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'LOC') || ': ' || rec_scas.location_cd);

Line 10358: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'STATUS') || ': ' || igs_fi_gen_gl.get_lkp_meaning('VS_EN_COURSE_ATMPT_STATUS', rec_scas.course_attempt_status));

10354: fnd_message.set_token('PROG', rec_scas.program_cd);
10355: fnd_message.set_token('VER', TO_CHAR(rec_scas.program_version));
10356: fnd_file.put_line (fnd_file.log, fnd_message.get);
10357: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TITLE') || ': ' || rec_scas.short_title);
10358: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'STATUS') || ': ' || igs_fi_gen_gl.get_lkp_meaning('VS_EN_COURSE_ATMPT_STATUS', rec_scas.course_attempt_status));
10359: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT') || ': ' || TO_CHAR(rec_scas.commencement_dt, 'DD/MM/YYYY'));
10360: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAT') || ': ' || l_fee_category);
10361: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'LOC') || ': ' || rec_scas.location_cd);
10362: fnd_message.set_name ( 'IGS', 'IGS_FI_DER_ATT_TYPE_GOVT_MODE');

Line 10359: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT') || ': ' || TO_CHAR(rec_scas.commencement_dt, 'DD/MM/YYYY'));

10355: fnd_message.set_token('VER', TO_CHAR(rec_scas.program_version));
10356: fnd_file.put_line (fnd_file.log, fnd_message.get);
10357: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TITLE') || ': ' || rec_scas.short_title);
10358: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'STATUS') || ': ' || igs_fi_gen_gl.get_lkp_meaning('VS_EN_COURSE_ATMPT_STATUS', rec_scas.course_attempt_status));
10359: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT') || ': ' || TO_CHAR(rec_scas.commencement_dt, 'DD/MM/YYYY'));
10360: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAT') || ': ' || l_fee_category);
10361: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'LOC') || ': ' || rec_scas.location_cd);
10362: fnd_message.set_name ( 'IGS', 'IGS_FI_DER_ATT_TYPE_GOVT_MODE');
10363: fnd_message.set_token('ATT_MODE', rec_scas.attendance_mode);

Line 10360: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAT') || ': ' || l_fee_category);

10356: fnd_file.put_line (fnd_file.log, fnd_message.get);
10357: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TITLE') || ': ' || rec_scas.short_title);
10358: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'STATUS') || ': ' || igs_fi_gen_gl.get_lkp_meaning('VS_EN_COURSE_ATMPT_STATUS', rec_scas.course_attempt_status));
10359: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT') || ': ' || TO_CHAR(rec_scas.commencement_dt, 'DD/MM/YYYY'));
10360: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAT') || ': ' || l_fee_category);
10361: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'LOC') || ': ' || rec_scas.location_cd);
10362: fnd_message.set_name ( 'IGS', 'IGS_FI_DER_ATT_TYPE_GOVT_MODE');
10363: fnd_message.set_token('ATT_MODE', rec_scas.attendance_mode);
10364: fnd_file.put_line (fnd_file.log, fnd_message.get);

Line 10361: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'LOC') || ': ' || rec_scas.location_cd);

10357: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TITLE') || ': ' || rec_scas.short_title);
10358: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'STATUS') || ': ' || igs_fi_gen_gl.get_lkp_meaning('VS_EN_COURSE_ATMPT_STATUS', rec_scas.course_attempt_status));
10359: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT') || ': ' || TO_CHAR(rec_scas.commencement_dt, 'DD/MM/YYYY'));
10360: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAT') || ': ' || l_fee_category);
10361: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'LOC') || ': ' || rec_scas.location_cd);
10362: fnd_message.set_name ( 'IGS', 'IGS_FI_DER_ATT_TYPE_GOVT_MODE');
10363: fnd_message.set_token('ATT_MODE', rec_scas.attendance_mode);
10364: fnd_file.put_line (fnd_file.log, fnd_message.get);
10365: fnd_message.set_name ( 'IGS', 'IGS_FI_ATTTYPE_GOVT_ATTMODE');

Line 10461: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TITLE') || ': ' || rec_spa.short_title);

10457: fnd_message.set_name ( 'IGS', 'IGS_FI_MAJOR_PRGLOC_USED');
10458: fnd_message.set_token('PROG', rec_spa.program_cd);
10459: fnd_message.set_token('VER', TO_CHAR(rec_spa.program_version));
10460: fnd_file.put_line (fnd_file.log, fnd_message.get);
10461: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TITLE') || ': ' || rec_spa.short_title);
10462: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'STATUS') || ': ' || igs_fi_gen_gl.get_lkp_meaning('VS_EN_COURSE_ATMPT_STATUS', rec_spa.course_attempt_status));
10463: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT') || ': ' || TO_CHAR(rec_spa.commencement_dt, 'DD/MM/YYYY'));
10464: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAT') || ': ' || rec_spa.fee_cat);
10465: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'LOC') || ': ' || rec_spa.location_cd);

Line 10462: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'STATUS') || ': ' || igs_fi_gen_gl.get_lkp_meaning('VS_EN_COURSE_ATMPT_STATUS', rec_spa.course_attempt_status));

10458: fnd_message.set_token('PROG', rec_spa.program_cd);
10459: fnd_message.set_token('VER', TO_CHAR(rec_spa.program_version));
10460: fnd_file.put_line (fnd_file.log, fnd_message.get);
10461: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TITLE') || ': ' || rec_spa.short_title);
10462: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'STATUS') || ': ' || igs_fi_gen_gl.get_lkp_meaning('VS_EN_COURSE_ATMPT_STATUS', rec_spa.course_attempt_status));
10463: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT') || ': ' || TO_CHAR(rec_spa.commencement_dt, 'DD/MM/YYYY'));
10464: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAT') || ': ' || rec_spa.fee_cat);
10465: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'LOC') || ': ' || rec_spa.location_cd);
10466: fnd_message.set_name ( 'IGS', 'IGS_FI_DER_ATT_TYPE_GOVT_MODE');

Line 10463: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT') || ': ' || TO_CHAR(rec_spa.commencement_dt, 'DD/MM/YYYY'));

10459: fnd_message.set_token('VER', TO_CHAR(rec_spa.program_version));
10460: fnd_file.put_line (fnd_file.log, fnd_message.get);
10461: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TITLE') || ': ' || rec_spa.short_title);
10462: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'STATUS') || ': ' || igs_fi_gen_gl.get_lkp_meaning('VS_EN_COURSE_ATMPT_STATUS', rec_spa.course_attempt_status));
10463: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT') || ': ' || TO_CHAR(rec_spa.commencement_dt, 'DD/MM/YYYY'));
10464: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAT') || ': ' || rec_spa.fee_cat);
10465: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'LOC') || ': ' || rec_spa.location_cd);
10466: fnd_message.set_name ( 'IGS', 'IGS_FI_DER_ATT_TYPE_GOVT_MODE');
10467: fnd_message.set_token('ATT_MODE', rec_spa.attendance_mode);

Line 10464: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAT') || ': ' || rec_spa.fee_cat);

10460: fnd_file.put_line (fnd_file.log, fnd_message.get);
10461: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TITLE') || ': ' || rec_spa.short_title);
10462: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'STATUS') || ': ' || igs_fi_gen_gl.get_lkp_meaning('VS_EN_COURSE_ATMPT_STATUS', rec_spa.course_attempt_status));
10463: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT') || ': ' || TO_CHAR(rec_spa.commencement_dt, 'DD/MM/YYYY'));
10464: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAT') || ': ' || rec_spa.fee_cat);
10465: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'LOC') || ': ' || rec_spa.location_cd);
10466: fnd_message.set_name ( 'IGS', 'IGS_FI_DER_ATT_TYPE_GOVT_MODE');
10467: fnd_message.set_token('ATT_MODE', rec_spa.attendance_mode);
10468: fnd_file.put_line (fnd_file.log, fnd_message.get);

Line 10465: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'LOC') || ': ' || rec_spa.location_cd);

10461: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'TITLE') || ': ' || rec_spa.short_title);
10462: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'STATUS') || ': ' || igs_fi_gen_gl.get_lkp_meaning('VS_EN_COURSE_ATMPT_STATUS', rec_spa.course_attempt_status));
10463: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'START_DT') || ': ' || TO_CHAR(rec_spa.commencement_dt, 'DD/MM/YYYY'));
10464: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX', 'FEE_CAT') || ': ' || rec_spa.fee_cat);
10465: fnd_file.put_line (fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_ACCT_ENTITIES', 'LOC') || ': ' || rec_spa.location_cd);
10466: fnd_message.set_name ( 'IGS', 'IGS_FI_DER_ATT_TYPE_GOVT_MODE');
10467: fnd_message.set_token('ATT_MODE', rec_spa.attendance_mode);
10468: fnd_file.put_line (fnd_file.log, fnd_message.get);
10469: fnd_message.set_name ( 'IGS', 'IGS_FI_ATTTYPE_GOVT_ATTMODE');

Line 10702: fnd_file.put_line(fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WAIVER_AMOUNT')||': '||NVL(l_n_sum_waiver_amount,0));

10698: -- But after the completion of create_waivers this parameter is set 'Y' as create_waivers internally call the Fee Assessment process
10699: g_v_wav_calc_flag := 'N';
10700:
10701: IF (p_trace_on = 'Y') THEN
10702: fnd_file.put_line(fnd_file.log, igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WAIVER_AMOUNT')||': '||NVL(l_n_sum_waiver_amount,0));
10703: fnd_file.new_line(fnd_file.log);
10704: END IF;
10705:
10706: END IF;

Line 11088: x_transaction_amount => igs_fi_gen_gl.get_formatted_amount(p_n_amount),

11084: x_fee_ci_sequence_number => p_n_fee_ci_sequence_number,
11085: x_fee_cat => l_v_fee_cat,
11086: x_s_transaction_type => g_v_retention,
11087: x_transaction_dt => TRUNC(SYSDATE),
11088: x_transaction_amount => igs_fi_gen_gl.get_formatted_amount(p_n_amount),
11089: x_currency_cd => g_v_currency_cd,
11090: x_exchange_rate => 1,
11091: x_chg_elements => NULL,
11092: x_effective_dt => TRUNC(SYSDATE),

Line 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);

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;
11171: -- Call the TBH for inserting record in IGS_FI_FEE_AS_ITEMS if Charges API returned successfully

Line 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));

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;
11171: -- Call the TBH for inserting record in IGS_FI_FEE_AS_ITEMS if Charges API returned successfully
11172: -- Modified fee_effective_dt entry as Trunc(Sysdate) as part of Bug 4240402: Timezone impact

Line 11190: x_amount => igs_fi_gen_gl.get_formatted_amount(p_n_amount),

11186: x_rul_sequence_number => NULL,
11187: x_s_chg_method_type => g_v_chgmthd_flatrate,
11188: x_description => NULL,
11189: x_chg_elements => NULL,
11190: x_amount => igs_fi_gen_gl.get_formatted_amount(p_n_amount),
11191: x_fee_effective_dt => TRUNC(SYSDATE),
11192: x_course_cd => l_v_course_cd,
11193: x_crs_version_number => NULL,
11194: x_course_attempt_status => NULL,