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

Line 38: g_v_offset_days CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','OFFSET_DAYS');

34: g_v_bi_monthly CONSTANT igs_fi_pp_templates.installment_period_code%TYPE := 'BI_MONTHLY';
35: g_v_quarterly CONSTANT igs_fi_pp_templates.installment_period_code%TYPE := 'QUARTERLY';
36: g_v_line CONSTANT VARCHAR2(100) := '+'||RPAD('-',75,'-')||'+';
37:
38: g_v_offset_days CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','OFFSET_DAYS');
39: g_v_person_group CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP');
40: g_v_fee_period CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD');
41: g_v_pp_status CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','STATUS');
42: g_v_warning CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WARNING');

Line 39: g_v_person_group CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP');

35: g_v_quarterly CONSTANT igs_fi_pp_templates.installment_period_code%TYPE := 'QUARTERLY';
36: g_v_line CONSTANT VARCHAR2(100) := '+'||RPAD('-',75,'-')||'+';
37:
38: g_v_offset_days CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','OFFSET_DAYS');
39: g_v_person_group CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP');
40: g_v_fee_period CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD');
41: g_v_pp_status CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','STATUS');
42: g_v_warning CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WARNING');
43: g_v_success CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','SUCCESS');

Line 40: g_v_fee_period CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD');

36: g_v_line CONSTANT VARCHAR2(100) := '+'||RPAD('-',75,'-')||'+';
37:
38: g_v_offset_days CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','OFFSET_DAYS');
39: g_v_person_group CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP');
40: g_v_fee_period CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD');
41: g_v_pp_status CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','STATUS');
42: g_v_warning CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WARNING');
43: g_v_success CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','SUCCESS');
44: g_v_error CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','ERROR');

Line 41: g_v_pp_status CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','STATUS');

37:
38: g_v_offset_days CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','OFFSET_DAYS');
39: g_v_person_group CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP');
40: g_v_fee_period CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD');
41: g_v_pp_status CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','STATUS');
42: g_v_warning CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WARNING');
43: g_v_success CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','SUCCESS');
44: g_v_error CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','ERROR');
45: g_v_person CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON');

Line 42: g_v_warning CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WARNING');

38: g_v_offset_days CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','OFFSET_DAYS');
39: g_v_person_group CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP');
40: g_v_fee_period CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD');
41: g_v_pp_status CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','STATUS');
42: g_v_warning CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WARNING');
43: g_v_success CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','SUCCESS');
44: g_v_error CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','ERROR');
45: g_v_person CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON');
46: g_d_sysdate CONSTANT DATE := TRUNC(SYSDATE);

Line 43: g_v_success CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','SUCCESS');

39: g_v_person_group CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON_GROUP');
40: g_v_fee_period CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD');
41: g_v_pp_status CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','STATUS');
42: g_v_warning CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WARNING');
43: g_v_success CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','SUCCESS');
44: g_v_error CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','ERROR');
45: g_v_person CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON');
46: g_d_sysdate CONSTANT DATE := TRUNC(SYSDATE);
47:

Line 44: g_v_error CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','ERROR');

40: g_v_fee_period CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','FEE_PERIOD');
41: g_v_pp_status CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','STATUS');
42: g_v_warning CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WARNING');
43: g_v_success CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','SUCCESS');
44: g_v_error CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','ERROR');
45: g_v_person CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON');
46: g_d_sysdate CONSTANT DATE := TRUNC(SYSDATE);
47:
48: --Cursor for validating person group.

Line 45: g_v_person CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON');

41: g_v_pp_status CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','STATUS');
42: g_v_warning CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','WARNING');
43: g_v_success CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','SUCCESS');
44: g_v_error CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','ERROR');
45: g_v_person CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PERSON');
46: g_d_sysdate CONSTANT DATE := TRUNC(SYSDATE);
47:
48: --Cursor for validating person group.
49: CURSOR cur_pers_grp(cp_n_pers_grp_id igs_pe_persid_group_all.group_id%TYPE) IS

Line 603: l_v_pmt_plan_template CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PAYPLAN_TEMPLATE');

599: l_n_count PLS_INTEGER;
600: l_n_cnt PLS_INTEGER;
601: l_n_months PLS_INTEGER;
602:
603: l_v_pmt_plan_template CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PAYPLAN_TEMPLATE');
604: l_v_start_date CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','START_DT');
605:
606: TYPE dff_seg_values IS RECORD (
607: attribute1 igs_fi_pp_std_attrs.attribute1%TYPE,

Line 604: l_v_start_date CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','START_DT');

600: l_n_cnt PLS_INTEGER;
601: l_n_months PLS_INTEGER;
602:
603: l_v_pmt_plan_template CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PAYPLAN_TEMPLATE');
604: l_v_start_date CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','START_DT');
605:
606: TYPE dff_seg_values IS RECORD (
607: attribute1 igs_fi_pp_std_attrs.attribute1%TYPE,
608: attribute2 igs_fi_pp_std_attrs.attribute2%TYPE,

Line 910: rec_cur_pmt_plan.processing_fee_amt:=igs_fi_gen_gl.get_formatted_amount(rec_cur_pmt_plan.processing_fee_amt);

906: --Nullify the IN/OUT variables l_rowid and l_n_installment_id before inserting a row in
907: --Student Payment Plans Table.
908: l_rowid := NULL;
909: l_n_student_plan_id := NULL;
910: rec_cur_pmt_plan.processing_fee_amt:=igs_fi_gen_gl.get_formatted_amount(rec_cur_pmt_plan.processing_fee_amt);
911: --For the Person being processed, create a record in the IGS_FI_PP_STD_ATTRS table.
912: igs_fi_pp_std_attrs_pkg.insert_row(x_rowid => l_rowid,
913: x_student_plan_id => l_n_student_plan_id,
914: x_person_id => l_n_person_id,

Line 964: l_temp_plsql_tbl(l_n_cnt).plan_amount :=igs_fi_gen_gl.get_formatted_amount(l_temp_plsql_tbl(l_n_cnt).plan_amount);

960: --a record in igs_fi_pp_instlmnts table.
961: l_rowid := NULL;
962: l_n_installment_id := NULL;
963:
964: l_temp_plsql_tbl(l_n_cnt).plan_amount :=igs_fi_gen_gl.get_formatted_amount(l_temp_plsql_tbl(l_n_cnt).plan_amount);
965: igs_fi_pp_instlmnts_pkg.insert_row(
966: x_rowid => l_rowid,
967: x_installment_id => l_n_installment_id,
968: x_student_plan_id => l_n_student_plan_id,

Line 1068: l_v_plan_name CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PLAN_NAME');

1064: l_v_closed CONSTANT igs_fi_pp_std_attrs.plan_status_code%TYPE := 'CLOSED';
1065: l_n_inst_bal igs_fi_pp_instlmnts.installment_amt%TYPE;
1066: l_v_end_dt_msg VARCHAR2(2000);
1067: l_n_count NUMBER :=0;
1068: l_v_plan_name CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PLAN_NAME');
1069: l_v_plan_bal CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PLAN_BAL');
1070: l_v_end_dt CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','END_DT');
1071:
1072: BEGIN

Line 1069: l_v_plan_bal CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PLAN_BAL');

1065: l_n_inst_bal igs_fi_pp_instlmnts.installment_amt%TYPE;
1066: l_v_end_dt_msg VARCHAR2(2000);
1067: l_n_count NUMBER :=0;
1068: l_v_plan_name CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PLAN_NAME');
1069: l_v_plan_bal CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PLAN_BAL');
1070: l_v_end_dt CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','END_DT');
1071:
1072: BEGIN
1073:

Line 1070: l_v_end_dt CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','END_DT');

1066: l_v_end_dt_msg VARCHAR2(2000);
1067: l_n_count NUMBER :=0;
1068: l_v_plan_name CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PLAN_NAME');
1069: l_v_plan_bal CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','PLAN_BAL');
1070: l_v_end_dt CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','END_DT');
1071:
1072: BEGIN
1073:
1074: --Loop through all the persons.

Line 1142: l_n_inst_bal :=igs_fi_gen_gl.get_formatted_amount(l_n_inst_bal);

1138:
1139: --Calculate the value to be updated in the column installment_amt.
1140: l_n_inst_bal := NVL(rec_cur_pp_insts.installment_amt,0) - NVL(rec_cur_pp_insts.due_amt,0);
1141:
1142: l_n_inst_bal :=igs_fi_gen_gl.get_formatted_amount(l_n_inst_bal);
1143: igs_fi_pp_instlmnts_pkg.update_row(
1144: x_rowid => rec_cur_pp_insts.rowid,
1145: x_installment_id => rec_cur_pp_insts.installment_id,
1146: x_student_plan_id => rec_cur_pp_insts.student_plan_id,

Line 1211: l_v_tol_thr CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TOLERANCE_THRESHOLD');

1207: l_v_manage_acc igs_fi_control.manage_accounts%TYPE := NULL;
1208: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
1209: l_n_person_id igs_fi_parties_v.person_id%TYPE;
1210:
1211: l_v_tol_thr CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TOLERANCE_THRESHOLD');
1212: l_v_test_mode CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TEST_MODE');
1213: l_n_count PLS_INTEGER := 0;
1214: l_n_cnt PLS_INTEGER;
1215: l_org_id VARCHAR2(15);

Line 1212: l_v_test_mode CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TEST_MODE');

1208: l_v_message_name fnd_new_messages.message_name%TYPE := NULL;
1209: l_n_person_id igs_fi_parties_v.person_id%TYPE;
1210:
1211: l_v_tol_thr CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TOLERANCE_THRESHOLD');
1212: l_v_test_mode CONSTANT igs_lookup_values.meaning%TYPE := igs_fi_gen_gl.get_lkp_meaning('IGS_FI_LOCKBOX','TEST_MODE');
1213: l_n_count PLS_INTEGER := 0;
1214: l_n_cnt PLS_INTEGER;
1215: l_org_id VARCHAR2(15);
1216: BEGIN

Line 1290: l_v_meaning := igs_fi_gen_gl.get_lkp_meaning('VS_AS_YN',p_v_test_mode);

1286:
1287: --Validate the Test Mode parameter is passed as not null.
1288: IF p_v_test_mode IS NOT NULL THEN
1289: --Validate whether the passed p_v_test_mode parameter is a valid lookup.
1290: l_v_meaning := igs_fi_gen_gl.get_lkp_meaning('VS_AS_YN',p_v_test_mode);
1291: --If it is not a valid lookup, then log the error message in the log file and error out the process.
1292: IF l_v_meaning IS NULL THEN
1293: fnd_message.set_name('IGS','IGS_FI_INVALID_PARAMETER');
1294: fnd_message.set_token('PARAMETER',l_v_test_mode);