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_HOLDS dependencies on IGS_FI_GEN_GL

Line 94: g_v_person_number CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','PERSON_NUMBER');

90: -- g_b_hold_skipped = TRUE even if one hold for a person is skipped
91: g_b_hold_skipped BOOLEAN := FALSE;
92:
93: --added following 6 global variables as part of bug#2824994.
94: g_v_person_number CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','PERSON_NUMBER');
95: g_v_person_name CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','PERSON_NAME');
96: g_v_hold_plan CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','HOLD_PLAN');
97: g_n_holds_bal CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','HOLDS_BALANCE');
98: g_n_overdue_bal CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','HOLDS_OVERDUE_BALANCE');

Line 95: g_v_person_name CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','PERSON_NAME');

91: g_b_hold_skipped BOOLEAN := FALSE;
92:
93: --added following 6 global variables as part of bug#2824994.
94: g_v_person_number CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','PERSON_NUMBER');
95: g_v_person_name CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','PERSON_NAME');
96: g_v_hold_plan CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','HOLD_PLAN');
97: g_n_holds_bal CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','HOLDS_BALANCE');
98: g_n_overdue_bal CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','HOLDS_OVERDUE_BALANCE');
99: g_v_hold_type CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','HOLD_TYPE');

Line 96: g_v_hold_plan CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','HOLD_PLAN');

92:
93: --added following 6 global variables as part of bug#2824994.
94: g_v_person_number CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','PERSON_NUMBER');
95: g_v_person_name CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','PERSON_NAME');
96: g_v_hold_plan CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','HOLD_PLAN');
97: g_n_holds_bal CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','HOLDS_BALANCE');
98: g_n_overdue_bal CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','HOLDS_OVERDUE_BALANCE');
99: g_v_hold_type CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','HOLD_TYPE');
100: g_n_person_id hz_parties.party_id%TYPE;

Line 97: g_n_holds_bal CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','HOLDS_BALANCE');

93: --added following 6 global variables as part of bug#2824994.
94: g_v_person_number CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','PERSON_NUMBER');
95: g_v_person_name CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','PERSON_NAME');
96: g_v_hold_plan CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','HOLD_PLAN');
97: g_n_holds_bal CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','HOLDS_BALANCE');
98: g_n_overdue_bal CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','HOLDS_OVERDUE_BALANCE');
99: g_v_hold_type CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','HOLD_TYPE');
100: g_n_person_id hz_parties.party_id%TYPE;
101: g_n_resp_id fnd_responsibility.responsibility_id%TYPE;

Line 98: g_n_overdue_bal CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','HOLDS_OVERDUE_BALANCE');

94: g_v_person_number CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','PERSON_NUMBER');
95: g_v_person_name CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','PERSON_NAME');
96: g_v_hold_plan CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','HOLD_PLAN');
97: g_n_holds_bal CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','HOLDS_BALANCE');
98: g_n_overdue_bal CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','HOLDS_OVERDUE_BALANCE');
99: g_v_hold_type CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','HOLD_TYPE');
100: g_n_person_id hz_parties.party_id%TYPE;
101: g_n_resp_id fnd_responsibility.responsibility_id%TYPE;
102:

Line 99: g_v_hold_type CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','HOLD_TYPE');

95: g_v_person_name CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','PERSON_NAME');
96: g_v_hold_plan CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','HOLD_PLAN');
97: g_n_holds_bal CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','HOLDS_BALANCE');
98: g_n_overdue_bal CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','HOLDS_OVERDUE_BALANCE');
99: g_v_hold_type CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','HOLD_TYPE');
100: g_n_person_id hz_parties.party_id%TYPE;
101: g_n_resp_id fnd_responsibility.responsibility_id%TYPE;
102:
103: -- Changes due to SFCR018

Line 729: --Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision

725: END IF;
726: IF p_hold_plan_level ='S' THEN
727: l_rowid := NULL;
728: --To insert the required data elements as shown below to the intermediate table IGS_FI_PERSON_HOLDS
729: --Call to igs_fi_gen_gl.get_formatted_amount formats amount by rounding off to currency precision
730: igs_fi_person_holds_pkg.insert_row(
731: x_Mode => 'R',
732: x_RowId => l_rowid,
733: x_person_id => p_person_id,

Line 740: x_past_due_amount => igs_fi_gen_gl.get_formatted_amount(P_holds_final_balance),

736: x_hold_start_dt => p_hold_start_date,
737: x_process_start_dt => p_process_start_dt,
738: x_process_end_dt => p_process_end_dt,
739: x_offset_days => p_offset_days,
740: x_past_due_amount => igs_fi_gen_gl.get_formatted_amount(P_holds_final_balance),
741: x_fee_cal_type => NULL,
742: x_fee_ci_sequence_number => NULL,
743: x_fee_type_invoice_amount => NULL,
744: x_release_credit_id => NULL,

Line 752: -- Call to igs_fi_gen_gl.get_formatted_amount formats amounts by rounding off to currency precision

748:
749:
750: ELSIF p_hold_plan_level ='F' THEN
751: l_rowid := NULL;
752: -- Call to igs_fi_gen_gl.get_formatted_amount formats amounts by rounding off to currency precision
753: igs_fi_person_holds_pkg.insert_row(
754: x_Mode => 'R',
755: x_Rowid => l_rowid,
756: x_person_id => p_person_id,

Line 763: x_past_due_amount => igs_fi_gen_gl.get_formatted_amount(P_holds_final_balance),

759: x_hold_start_dt => p_hold_start_date,
760: x_process_start_dt => p_process_start_dt,
761: x_process_end_dt => p_process_start_dt,
762: x_offset_days => NULL,
763: x_past_due_amount => igs_fi_gen_gl.get_formatted_amount(P_holds_final_balance),
764: x_fee_cal_type => P_fee_cal_type ,
765: x_fee_ci_sequence_number => P_fee_ci_sequence_number ,
766: x_fee_type_invoice_amount => igs_fi_gen_gl.get_formatted_amount(p_holds_charges),
767: x_release_credit_id => NULL,

Line 766: x_fee_type_invoice_amount => igs_fi_gen_gl.get_formatted_amount(p_holds_charges),

762: x_offset_days => NULL,
763: x_past_due_amount => igs_fi_gen_gl.get_formatted_amount(P_holds_final_balance),
764: x_fee_cal_type => P_fee_cal_type ,
765: x_fee_ci_sequence_number => P_fee_ci_sequence_number ,
766: x_fee_type_invoice_amount => igs_fi_gen_gl.get_formatted_amount(p_holds_charges),
767: x_release_credit_id => NULL,
768: x_student_plan_id => p_n_student_plan_id,
769: x_last_instlmnt_due_date => p_d_last_inst_due_date
770: );

Line 2371: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','PERSON_NUMBER')||': '|| l_person_number);

2367: l_message_name := NULL;
2368: --Code added for Bug 3049184
2369: fnd_file.put_line(fnd_file.log,l_v_line_sepr);
2370: fnd_message.set_name('IGS','IGS_FI_END_DATE');
2371: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','PERSON_NUMBER')||': '|| l_person_number);
2372: fnd_file.put_line(fnd_file.log,fnd_message.get);
2373:
2374: --Function to check whether holds has to be released
2375: IF NOT validate_holds(p_person_id,

Line 2432: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','PERSON_NUMBER')||': '|| l_person_number);

2428: l_person_number := l_person_rec.person_number;
2429: CLOSE c_person;
2430: --Code added for Bug 3049184
2431: fnd_message.set_name('IGS','IGS_FI_END_DATE');
2432: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','PERSON_NUMBER')||': '|| l_person_number);
2433: fnd_file.put_line(fnd_file.log,fnd_message.get);
2434:
2435: IF NOT validate_holds(l_person_group_rec.person_id,
2436: l_hold_plan_name,

Line 2482: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','PERSON_NUMBER')||': '|| l_person_hold_rec.person_number);

2478: l_n_total_count := c_person_hold%ROWCOUNT;
2479: BEGIN
2480: EXIT WHEN c_person_hold%NOTFOUND;
2481: fnd_message.set_name('IGS','IGS_FI_END_DATE');
2482: fnd_message.set_token('END_DATE',igs_fi_gen_gl.get_lkp_meaning('IGS_FI_HOLDS','PERSON_NUMBER')||': '|| l_person_hold_rec.person_number);
2483: fnd_file.put_line(fnd_file.log,fnd_message.get);
2484: IF NOT validate_holds(l_person_hold_rec.person_id,
2485: l_hold_plan_name,
2486: p_test_run,