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.

[Home] [Help]

APPS.IGS_FI_SS_ACCT_PAYMENT dependencies on IGS_PE_STD_TODO_REF

Line 835: p_person_id IN igs_pe_std_todo_ref.person_id%TYPE,

831:
832:
833: PROCEDURE finp_calc_fees_todo
834: (
835: p_person_id IN igs_pe_std_todo_ref.person_id%TYPE,
836: p_init_msg_list IN VARCHAR2,
837: p_return_status OUT NOCOPY VARCHAR2,
838: p_message_count OUT NOCOPY NUMBER,
839: p_message_data OUT NOCOPY VARCHAR2

Line 850: -- needs to be checked from IGS_PE_STD_TODO_REF table.

846: -- Invoked : From Student Acoount History and Payment Page.
847: -- Function : Procedure checks for any pending todo records of type fee_recalc.
848: -- If any entry is found, process calls the fee assessment routine for the FCI
849: -- Parameters : p_person_id : IN parameter. Required. Identifies the person for which ToDo Enteries
850: -- needs to be checked from IGS_PE_STD_TODO_REF table.
851: --
852: -- p_return_status : OUT parmeter.
853: --
854: -- p_message_count : OUT parameter

Line 866: -- within the loop across the records in the IGS_PE_STD_TODO_REF table.

862: --gurprsin 6-Dec-2005 Bug 4735807, Modified the finp_calc_fees_todo method, Added a condition to skip the addition of message onto the stack as it is already added in
863: -- finp_ins_enr_fee_ass method for the case ' if no fee category is attached to the SPA.'. Otherwise a null message
864: -- will be added and shown on the SS page.
865: --schodava 21-Jan-2004 Bug # 3062706 - Removed the initialization of the variable l_d_creation_dt
866: -- within the loop across the records in the IGS_PE_STD_TODO_REF table.
867: --shtatiko 15-DEC_2003 Bug# 3230754, Replaced AND with OR when checking for uniqueness of FTCI.
868: --pathipat 06-Nov-2003 Enh 3117341 - Audit and Special Fees TD
869: -- Added logic for processing Special Fees after Fee Assessment
870: --smadathi 28-MAY-2003 Bug 2849142. Modified the exceptional handling. Used p_message_data to return message_name

Line 872: --knaraset 12-May-2003 Modified cursor c_igs_pe_std_todo_ref to select uoo_id

868: --pathipat 06-Nov-2003 Enh 3117341 - Audit and Special Fees TD
869: -- Added logic for processing Special Fees after Fee Assessment
870: --smadathi 28-MAY-2003 Bug 2849142. Modified the exceptional handling. Used p_message_data to return message_name
871: -- instead.
872: --knaraset 12-May-2003 Modified cursor c_igs_pe_std_todo_ref to select uoo_id
873: -- also added uoo_id in TBH call to todo_ref, as part of MUS build bug 2829262
874: --vchappid 14-Mar-2003 Bug#2849142, Only one error message has to be shown to the user when any error occurs.
875: --smadathi 13-nov-2002 Added p_d_gl_date parameter to the call igs_fi_prc_fee_ass.finp_ins_enr_fee_ass
876: --vvutukur 17-Sep-2002 Enh#2564643.Removed DEFAULT clause from parameter list to avoid

Line 879: l_c_rpt_ld_cal_type igs_pe_std_todo_ref.cal_type%TYPE;

875: --smadathi 13-nov-2002 Added p_d_gl_date parameter to the call igs_fi_prc_fee_ass.finp_ins_enr_fee_ass
876: --vvutukur 17-Sep-2002 Enh#2564643.Removed DEFAULT clause from parameter list to avoid
877: -- gscc warning in order to comply with 9i standards.
878: ------------------------------------------------------------------
879: l_c_rpt_ld_cal_type igs_pe_std_todo_ref.cal_type%TYPE;
880: l_n_rpt_ld_ci_sequence_number igs_pe_std_todo_ref.ci_sequence_number%TYPE;
881: l_c_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE;
882: l_n_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE;
883: l_c_message_name fnd_new_messages.message_name%TYPE DEFAULT NULL;

Line 880: l_n_rpt_ld_ci_sequence_number igs_pe_std_todo_ref.ci_sequence_number%TYPE;

876: --vvutukur 17-Sep-2002 Enh#2564643.Removed DEFAULT clause from parameter list to avoid
877: -- gscc warning in order to comply with 9i standards.
878: ------------------------------------------------------------------
879: l_c_rpt_ld_cal_type igs_pe_std_todo_ref.cal_type%TYPE;
880: l_n_rpt_ld_ci_sequence_number igs_pe_std_todo_ref.ci_sequence_number%TYPE;
881: l_c_fee_cal_type igs_fi_f_typ_ca_inst.fee_cal_type%TYPE;
882: l_n_fee_ci_sequence_number igs_fi_f_typ_ca_inst.fee_ci_sequence_number%TYPE;
883: l_c_message_name fnd_new_messages.message_name%TYPE DEFAULT NULL;
884: l_c_message VARCHAR2(32767) DEFAULT NULL;

Line 891: -- Cursor to fetch all the open todo records from the igs_pe_std_todo_ref table for the person that are

887:
888: l_c_msg VARCHAR2(2000);
889: l_c_appln VARCHAR2(10);
890:
891: -- Cursor to fetch all the open todo records from the igs_pe_std_todo_ref table for the person that are
892: -- of type 'FEE_RECALC'
893:
894: CURSOR c_igs_pe_std_todo_ref( cp_n_person_id igs_pe_std_todo_ref.person_id%TYPE) IS
895: SELECT person_id , s_student_todo_type , sequence_number ,

Line 894: CURSOR c_igs_pe_std_todo_ref( cp_n_person_id igs_pe_std_todo_ref.person_id%TYPE) IS

890:
891: -- Cursor to fetch all the open todo records from the igs_pe_std_todo_ref table for the person that are
892: -- of type 'FEE_RECALC'
893:
894: CURSOR c_igs_pe_std_todo_ref( cp_n_person_id igs_pe_std_todo_ref.person_id%TYPE) IS
895: SELECT person_id , s_student_todo_type , sequence_number ,
896: reference_number , cal_type , ci_sequence_number ,
897: course_cd , unit_cd , other_reference ,
898: logical_delete_dt , Created_by , creation_date ,

Line 902: FROM igs_pe_std_todo_ref

898: logical_delete_dt , Created_by , creation_date ,
899: last_updated_by , last_update_date , last_update_login ,
900: request_id , program_application_id , program_id ,
901: program_update_date , rowid,uoo_id
902: FROM igs_pe_std_todo_ref
903: WHERE person_id = cp_n_person_id
904: AND s_student_todo_type = cst_fee_recalc
905: AND logical_delete_dt IS NULL
906: ORDER BY cal_type , ci_sequence_number;

Line 908: rec_c_igs_pe_std_todo_ref c_igs_pe_std_todo_ref%ROWTYPE;

904: AND s_student_todo_type = cst_fee_recalc
905: AND logical_delete_dt IS NULL
906: ORDER BY cal_type , ci_sequence_number;
907: -- cursor % rowtype variable
908: rec_c_igs_pe_std_todo_ref c_igs_pe_std_todo_ref%ROWTYPE;
909: -- user defined exception
910: e_resource_busy EXCEPTION;
911: --associating the oracle error number and user defined exception using compiler directive
912: PRAGMA EXCEPTION_INIT(e_resource_busy,-00054);

Line 947: FOR rec_c_igs_pe_std_todo_ref IN c_igs_pe_std_todo_ref (cp_n_person_id => p_person_id) LOOP

943: RAISE FND_API.G_EXC_ERROR;
944: END IF;
945:
946: l_b_fees_assessed := TRUE;
947: FOR rec_c_igs_pe_std_todo_ref IN c_igs_pe_std_todo_ref (cp_n_person_id => p_person_id) LOOP
948:
949: -- compare the fetched LCI with the last processed LCI
950: IF ((l_c_rpt_ld_cal_type <> rec_c_igs_pe_std_todo_ref.cal_type ) OR
951: (l_n_rpt_ld_ci_sequence_number <> rec_c_igs_pe_std_todo_ref.ci_sequence_number))

Line 950: IF ((l_c_rpt_ld_cal_type <> rec_c_igs_pe_std_todo_ref.cal_type ) OR

946: l_b_fees_assessed := TRUE;
947: FOR rec_c_igs_pe_std_todo_ref IN c_igs_pe_std_todo_ref (cp_n_person_id => p_person_id) LOOP
948:
949: -- compare the fetched LCI with the last processed LCI
950: IF ((l_c_rpt_ld_cal_type <> rec_c_igs_pe_std_todo_ref.cal_type ) OR
951: (l_n_rpt_ld_ci_sequence_number <> rec_c_igs_pe_std_todo_ref.ci_sequence_number))
952: THEN
953: l_c_message_name := NULL;
954: -- call to function which converts the LCI to FCI

Line 951: (l_n_rpt_ld_ci_sequence_number <> rec_c_igs_pe_std_todo_ref.ci_sequence_number))

947: FOR rec_c_igs_pe_std_todo_ref IN c_igs_pe_std_todo_ref (cp_n_person_id => p_person_id) LOOP
948:
949: -- compare the fetched LCI with the last processed LCI
950: IF ((l_c_rpt_ld_cal_type <> rec_c_igs_pe_std_todo_ref.cal_type ) OR
951: (l_n_rpt_ld_ci_sequence_number <> rec_c_igs_pe_std_todo_ref.ci_sequence_number))
952: THEN
953: l_c_message_name := NULL;
954: -- call to function which converts the LCI to FCI
955: IF igs_fi_gen_001.finp_get_lfci_reln

Line 957: p_cal_type => rec_c_igs_pe_std_todo_ref.cal_type ,

953: l_c_message_name := NULL;
954: -- call to function which converts the LCI to FCI
955: IF igs_fi_gen_001.finp_get_lfci_reln
956: (
957: p_cal_type => rec_c_igs_pe_std_todo_ref.cal_type ,
958: p_ci_sequence_number => rec_c_igs_pe_std_todo_ref.ci_sequence_number ,
959: p_cal_category => 'LOAD',
960: p_ret_cal_type => l_c_fee_cal_type,
961: p_ret_ci_sequence_number => l_n_fee_ci_sequence_number,

Line 958: p_ci_sequence_number => rec_c_igs_pe_std_todo_ref.ci_sequence_number ,

954: -- call to function which converts the LCI to FCI
955: IF igs_fi_gen_001.finp_get_lfci_reln
956: (
957: p_cal_type => rec_c_igs_pe_std_todo_ref.cal_type ,
958: p_ci_sequence_number => rec_c_igs_pe_std_todo_ref.ci_sequence_number ,
959: p_cal_category => 'LOAD',
960: p_ret_cal_type => l_c_fee_cal_type,
961: p_ret_ci_sequence_number => l_n_fee_ci_sequence_number,
962: p_message_name => l_c_message_name

Line 981: p_person_id => rec_c_igs_pe_std_todo_ref.person_id,

977: -- This routine will commit internally as we are calling with Test Run parameter as N.
978: IF igs_fi_prc_fee_ass.finp_ins_enr_fee_ass
979: (
980: p_effective_dt => SYSDATE,
981: p_person_id => rec_c_igs_pe_std_todo_ref.person_id,
982: p_course_cd => NULL,
983: p_fee_category => NULL,
984: p_fee_cal_type => l_c_fee_cal_type,
985: p_fee_ci_sequence_num => l_n_fee_ci_sequence_number,

Line 1020: l_c_rpt_ld_cal_type := rec_c_igs_pe_std_todo_ref.cal_type;

1016: END ;
1017: END IF; -- condition check for LCI to FCI ends here
1018:
1019: -- assign the fetched values to repeat values
1020: l_c_rpt_ld_cal_type := rec_c_igs_pe_std_todo_ref.cal_type;
1021: l_n_rpt_ld_ci_sequence_number := rec_c_igs_pe_std_todo_ref.ci_sequence_number;
1022: END IF; -- check condition for comparing the fetched LCI with the last processed LCI
1023:
1024: -- update the logical delete date so that this record would no longer be an open todo

Line 1021: l_n_rpt_ld_ci_sequence_number := rec_c_igs_pe_std_todo_ref.ci_sequence_number;

1017: END IF; -- condition check for LCI to FCI ends here
1018:
1019: -- assign the fetched values to repeat values
1020: l_c_rpt_ld_cal_type := rec_c_igs_pe_std_todo_ref.cal_type;
1021: l_n_rpt_ld_ci_sequence_number := rec_c_igs_pe_std_todo_ref.ci_sequence_number;
1022: END IF; -- check condition for comparing the fetched LCI with the last processed LCI
1023:
1024: -- update the logical delete date so that this record would no longer be an open todo
1025: -- Update the TODO record only if Fee Assessment was successful.

Line 1027: igs_pe_std_todo_ref_pkg.update_row ( x_rowid => rec_c_igs_pe_std_todo_ref.rowid,

1023:
1024: -- update the logical delete date so that this record would no longer be an open todo
1025: -- Update the TODO record only if Fee Assessment was successful.
1026: IF l_b_fees_assessed THEN
1027: igs_pe_std_todo_ref_pkg.update_row ( x_rowid => rec_c_igs_pe_std_todo_ref.rowid,
1028: x_person_id => rec_c_igs_pe_std_todo_ref.person_id,
1029: x_s_student_todo_type => rec_c_igs_pe_std_todo_ref.s_student_todo_type,
1030: x_sequence_number => rec_c_igs_pe_std_todo_ref.sequence_number,
1031: x_reference_number => rec_c_igs_pe_std_todo_ref.reference_number,

Line 1028: x_person_id => rec_c_igs_pe_std_todo_ref.person_id,

1024: -- update the logical delete date so that this record would no longer be an open todo
1025: -- Update the TODO record only if Fee Assessment was successful.
1026: IF l_b_fees_assessed THEN
1027: igs_pe_std_todo_ref_pkg.update_row ( x_rowid => rec_c_igs_pe_std_todo_ref.rowid,
1028: x_person_id => rec_c_igs_pe_std_todo_ref.person_id,
1029: x_s_student_todo_type => rec_c_igs_pe_std_todo_ref.s_student_todo_type,
1030: x_sequence_number => rec_c_igs_pe_std_todo_ref.sequence_number,
1031: x_reference_number => rec_c_igs_pe_std_todo_ref.reference_number,
1032: x_cal_type => rec_c_igs_pe_std_todo_ref.cal_type,

Line 1029: x_s_student_todo_type => rec_c_igs_pe_std_todo_ref.s_student_todo_type,

1025: -- Update the TODO record only if Fee Assessment was successful.
1026: IF l_b_fees_assessed THEN
1027: igs_pe_std_todo_ref_pkg.update_row ( x_rowid => rec_c_igs_pe_std_todo_ref.rowid,
1028: x_person_id => rec_c_igs_pe_std_todo_ref.person_id,
1029: x_s_student_todo_type => rec_c_igs_pe_std_todo_ref.s_student_todo_type,
1030: x_sequence_number => rec_c_igs_pe_std_todo_ref.sequence_number,
1031: x_reference_number => rec_c_igs_pe_std_todo_ref.reference_number,
1032: x_cal_type => rec_c_igs_pe_std_todo_ref.cal_type,
1033: x_ci_sequence_number => rec_c_igs_pe_std_todo_ref.ci_sequence_number,

Line 1030: x_sequence_number => rec_c_igs_pe_std_todo_ref.sequence_number,

1026: IF l_b_fees_assessed THEN
1027: igs_pe_std_todo_ref_pkg.update_row ( x_rowid => rec_c_igs_pe_std_todo_ref.rowid,
1028: x_person_id => rec_c_igs_pe_std_todo_ref.person_id,
1029: x_s_student_todo_type => rec_c_igs_pe_std_todo_ref.s_student_todo_type,
1030: x_sequence_number => rec_c_igs_pe_std_todo_ref.sequence_number,
1031: x_reference_number => rec_c_igs_pe_std_todo_ref.reference_number,
1032: x_cal_type => rec_c_igs_pe_std_todo_ref.cal_type,
1033: x_ci_sequence_number => rec_c_igs_pe_std_todo_ref.ci_sequence_number,
1034: x_course_cd => rec_c_igs_pe_std_todo_ref.course_cd,

Line 1031: x_reference_number => rec_c_igs_pe_std_todo_ref.reference_number,

1027: igs_pe_std_todo_ref_pkg.update_row ( x_rowid => rec_c_igs_pe_std_todo_ref.rowid,
1028: x_person_id => rec_c_igs_pe_std_todo_ref.person_id,
1029: x_s_student_todo_type => rec_c_igs_pe_std_todo_ref.s_student_todo_type,
1030: x_sequence_number => rec_c_igs_pe_std_todo_ref.sequence_number,
1031: x_reference_number => rec_c_igs_pe_std_todo_ref.reference_number,
1032: x_cal_type => rec_c_igs_pe_std_todo_ref.cal_type,
1033: x_ci_sequence_number => rec_c_igs_pe_std_todo_ref.ci_sequence_number,
1034: x_course_cd => rec_c_igs_pe_std_todo_ref.course_cd,
1035: x_unit_cd => rec_c_igs_pe_std_todo_ref.unit_cd,

Line 1032: x_cal_type => rec_c_igs_pe_std_todo_ref.cal_type,

1028: x_person_id => rec_c_igs_pe_std_todo_ref.person_id,
1029: x_s_student_todo_type => rec_c_igs_pe_std_todo_ref.s_student_todo_type,
1030: x_sequence_number => rec_c_igs_pe_std_todo_ref.sequence_number,
1031: x_reference_number => rec_c_igs_pe_std_todo_ref.reference_number,
1032: x_cal_type => rec_c_igs_pe_std_todo_ref.cal_type,
1033: x_ci_sequence_number => rec_c_igs_pe_std_todo_ref.ci_sequence_number,
1034: x_course_cd => rec_c_igs_pe_std_todo_ref.course_cd,
1035: x_unit_cd => rec_c_igs_pe_std_todo_ref.unit_cd,
1036: x_other_reference => rec_c_igs_pe_std_todo_ref.other_reference,

Line 1033: x_ci_sequence_number => rec_c_igs_pe_std_todo_ref.ci_sequence_number,

1029: x_s_student_todo_type => rec_c_igs_pe_std_todo_ref.s_student_todo_type,
1030: x_sequence_number => rec_c_igs_pe_std_todo_ref.sequence_number,
1031: x_reference_number => rec_c_igs_pe_std_todo_ref.reference_number,
1032: x_cal_type => rec_c_igs_pe_std_todo_ref.cal_type,
1033: x_ci_sequence_number => rec_c_igs_pe_std_todo_ref.ci_sequence_number,
1034: x_course_cd => rec_c_igs_pe_std_todo_ref.course_cd,
1035: x_unit_cd => rec_c_igs_pe_std_todo_ref.unit_cd,
1036: x_other_reference => rec_c_igs_pe_std_todo_ref.other_reference,
1037: x_logical_delete_dt => SYSDATE,

Line 1034: x_course_cd => rec_c_igs_pe_std_todo_ref.course_cd,

1030: x_sequence_number => rec_c_igs_pe_std_todo_ref.sequence_number,
1031: x_reference_number => rec_c_igs_pe_std_todo_ref.reference_number,
1032: x_cal_type => rec_c_igs_pe_std_todo_ref.cal_type,
1033: x_ci_sequence_number => rec_c_igs_pe_std_todo_ref.ci_sequence_number,
1034: x_course_cd => rec_c_igs_pe_std_todo_ref.course_cd,
1035: x_unit_cd => rec_c_igs_pe_std_todo_ref.unit_cd,
1036: x_other_reference => rec_c_igs_pe_std_todo_ref.other_reference,
1037: x_logical_delete_dt => SYSDATE,
1038: x_mode => 'R',

Line 1035: x_unit_cd => rec_c_igs_pe_std_todo_ref.unit_cd,

1031: x_reference_number => rec_c_igs_pe_std_todo_ref.reference_number,
1032: x_cal_type => rec_c_igs_pe_std_todo_ref.cal_type,
1033: x_ci_sequence_number => rec_c_igs_pe_std_todo_ref.ci_sequence_number,
1034: x_course_cd => rec_c_igs_pe_std_todo_ref.course_cd,
1035: x_unit_cd => rec_c_igs_pe_std_todo_ref.unit_cd,
1036: x_other_reference => rec_c_igs_pe_std_todo_ref.other_reference,
1037: x_logical_delete_dt => SYSDATE,
1038: x_mode => 'R',
1039: x_uoo_id => rec_c_igs_pe_std_todo_ref.uoo_id);

Line 1036: x_other_reference => rec_c_igs_pe_std_todo_ref.other_reference,

1032: x_cal_type => rec_c_igs_pe_std_todo_ref.cal_type,
1033: x_ci_sequence_number => rec_c_igs_pe_std_todo_ref.ci_sequence_number,
1034: x_course_cd => rec_c_igs_pe_std_todo_ref.course_cd,
1035: x_unit_cd => rec_c_igs_pe_std_todo_ref.unit_cd,
1036: x_other_reference => rec_c_igs_pe_std_todo_ref.other_reference,
1037: x_logical_delete_dt => SYSDATE,
1038: x_mode => 'R',
1039: x_uoo_id => rec_c_igs_pe_std_todo_ref.uoo_id);
1040: ELSE

Line 1039: x_uoo_id => rec_c_igs_pe_std_todo_ref.uoo_id);

1035: x_unit_cd => rec_c_igs_pe_std_todo_ref.unit_cd,
1036: x_other_reference => rec_c_igs_pe_std_todo_ref.other_reference,
1037: x_logical_delete_dt => SYSDATE,
1038: x_mode => 'R',
1039: x_uoo_id => rec_c_igs_pe_std_todo_ref.uoo_id);
1040: ELSE
1041: -- i.e., l_b_fees_assessed == FALSE which means there is an error in deriving the Fee/Load period relation OR in fee assessment.
1042: -- So, Stop processing TODO REF records and exit out of loop
1043: EXIT;