[Home] [Help]
23: pathipat 17-Oct-2003 Bug: 3151102 - Modified finp_prc_enr_fee_ass() - Added begin-end block for exception handling
24: pathipat 07-Oct-2003 Bug 3122652: Modified finp_prc_enr_fee_ass() - Added validation for person id group
25: pathipat 23-Sep-2003 Bug: 3151102 - Modified finp_prc_enr_fee_ass()
26: pathipat 09-Sep-2003 Bug 3122652: Modified finp_prc_enr_fee_ass() - Replaced call to igf_ap_ss_pkg.get_pid() with
27: call to igs_pe_dynamic_persid_group.igs_get_dynamic_sql()
28: Removed commented out code
29: knaraset 12-May-2003 Modified cursor c_get_todo_ref_csr to select uoo_id in procedure finp_prc_fa_ref_todo,
30: also added uoo_id in TBH call to todo_ref, as part of MUS build bug 2829262
31: shtatiko 06-MAY-2003 Enh# 2831569, Modified finp_prc_enr_fee_ass and finp_prc_enr_fa_todo.
870: person id group
871: pathipat 23-Sep-2003 Bug: 3151102 - Called finp_ins_enr_fee_ass in a begin-end block
872: with exception handling when called for a Person ID Group.
873: pathipat 09-Sep-2003 Bug 3122652: Replaced call to igf_ap_ss_pkg.get_pid() with
874: call to igs_pe_dynamic_persid_group.igs_get_dynamic_sql()
875: Increased length of l_dynamic_sql to 32767 from 2000
876: shtatiko 28-APR-2003 Enh# 2831569, Added check for Manage Accounts System Option.
877: Implemeted Dynamic Person Group feature for group id parameter.
878: shtatiko 30-JAN-2003 Bug# 2765239, Replaced IGS_GE_INVALID_VALUE message with more meaningful messages
1160: fnd_file.put_line (fnd_file.log, fnd_message.get);
1161:
1162: -- case in which the person id is not provided but the person group id is provided.
1163: IF l_n_person_grp_id is NOT NULL AND l_n_person_id is NULL THEN
1164: -- Get the select query for REF CURSOR by calling igs_pe_dynamic_persid_group.igs_get_dynamic_sql
1165: l_dynamic_sql := igs_pe_dynamic_persid_group.igs_get_dynamic_sql(l_n_person_grp_id,l_v_status );
1166: IF l_v_status <> 'S' THEN
1167: fnd_message.set_name('IGF','IGF_AP_INVALID_QUERY');
1168: igs_ge_msg_stack.add;
1161:
1162: -- case in which the person id is not provided but the person group id is provided.
1163: IF l_n_person_grp_id is NOT NULL AND l_n_person_id is NULL THEN
1164: -- Get the select query for REF CURSOR by calling igs_pe_dynamic_persid_group.igs_get_dynamic_sql
1165: l_dynamic_sql := igs_pe_dynamic_persid_group.igs_get_dynamic_sql(l_n_person_grp_id,l_v_status );
1166: IF l_v_status <> 'S' THEN
1167: fnd_message.set_name('IGF','IGF_AP_INVALID_QUERY');
1168: igs_ge_msg_stack.add;
1169: app_exception.raise_exception(NULL,NULL,fnd_message.get);