[Home] [Help]
40: vchappid 11-Nov-02 Bug# 2584986, GL- Interface Build New Date parameter.
41: p_d_gl_date is added to the finp_prc_enr_fa_todo, finp_prc_enr_fee_ass
42: procedure specification
43: In the procedure finp_prc_sca_unconf, in the local procedure finpl_prc_reverse_fee_assess
44: a new gl_date parameter is passed as system date to the procedure igs_fi_prc_fee_ass.finp_ins_enr_fee_ass call
45: vchappid 17-Oct-02 Enh bug#2595962.Modified procedures finp_prc_fa_ref_todo,
46: finp_prc_enr_fa_todo,finp_prc_enr_fee_ass and
47: finpl_prc_reverse_fee_assess.
48: jbegum 06-jun-02 As part of bug fix of bug #2318488 the local procedure finp_prc_hecs_pymnt_optn is being
591: -- Bug# 3230754, Removed check for Logical Delete Date as that is added in the cursor itself.
592: -- Call the Fee Assessment routine
593: fnd_msg_pub.initialize; -- Added as part of 2734512
594:
595: IF (igs_fi_prc_fee_ass.finp_ins_enr_fee_ass(
596: p_effective_dt => SYSDATE,
597: p_person_id => p_person_id,
598: p_course_cd => NULL,
599: p_fee_category => NULL,
610: p_v_wav_calc_flag => 'N',
611: p_n_waiver_amount => l_n_waiver_amount) = FALSE) THEN
612: fnd_message.set_name ('IGS', l_message_name);
613: IF l_message_name = 'IGS_FI_NO_CENSUS_DT_SETUP' THEN
614: fnd_message.set_token('ALT_CD', igs_fi_prc_fee_ass.g_v_load_alt_code);
615: END IF;
616: igs_ge_msg_stack.add;
617: x_msg_data := l_message_name;
618: RAISE FND_API.G_EXC_ERROR;
1197:
1198: -- Call fee assessment routine
1199: BEGIN
1200: -- Removed the parameter p_predictive_ass_ind from call to
1201: -- igs_fi_prc_fee_ass.finp_ins_enr_fee_ass
1202: IF(igs_fi_prc_fee_ass.finp_ins_enr_fee_ass( SYSDATE,
1203: rec_person_grp.p_n_person_id,
1204: p_course_cd,
1205: p_fee_category,
1198: -- Call fee assessment routine
1199: BEGIN
1200: -- Removed the parameter p_predictive_ass_ind from call to
1201: -- igs_fi_prc_fee_ass.finp_ins_enr_fee_ass
1202: IF(igs_fi_prc_fee_ass.finp_ins_enr_fee_ass( SYSDATE,
1203: rec_person_grp.p_n_person_id,
1204: p_course_cd,
1205: p_fee_category,
1206: l_v_fee_cal_type,
1216: 'N',
1217: l_n_waiver_amount) = FALSE) THEN
1218: Fnd_Message.Set_Name ('IGS', v_message_name);
1219: IF v_message_name = 'IGS_FI_NO_CENSUS_DT_SETUP' THEN
1220: fnd_message.set_token('ALT_CD', igs_fi_prc_fee_ass.g_v_load_alt_code);
1221: END IF;
1222: IGS_GE_MSG_STACK.ADD;
1223: App_Exception.Raise_Exception(Null, Null, fnd_message.get );
1224: END IF;
1238: ELSIF l_n_person_grp_id is NULL AND l_n_person_id is NOT NULL THEN
1239: -- case in which the person id is might be provided or be null
1240:
1241: -- Call fee assessment routine
1242: IF(igs_fi_prc_fee_ass.finp_ins_enr_fee_ass(
1243: SYSDATE,
1244: l_n_person_id,
1245: p_course_cd,
1246: p_fee_category,
1257: 'N',
1258: l_n_waiver_amount) = FALSE) THEN
1259: Fnd_Message.Set_Name ('IGS', v_message_name);
1260: IF v_message_name = 'IGS_FI_NO_CENSUS_DT_SETUP' THEN
1261: fnd_message.set_token('ALT_CD', igs_fi_prc_fee_ass.g_v_load_alt_code);
1262: END IF;
1263: IGS_GE_MSG_STACK.ADD;
1264: App_Exception.Raise_Exception(Null, Null, fnd_message.get );
1265: END IF;
1382: BEGIN -- finp_prc_sca_unconf
1383: -- Process finance details for unconfirmed student IGS_PS_COURSE attempts. This
1384: -- routine is called from ADMP_DEL_SCA_UNCONF when deleting unconfirmed
1385: -- student IGS_PS_COURSE attempts.
1386: -- IGS_GE_NOTE: The call to IGS_FI_PRC_FEE_ASS.finp_ins_enr_fee performs a commit,
1387: -- this means that all outstanding transactions will be committed.
1388: DECLARE
1389: cst_unconfirm CONSTANT VARCHAR2(10) := 'UNCONFIRM';
1390: e_resource_busy EXCEPTION;
1550:
1551:
1552:
1553: -- IGS_GE_NOTE: Must perform a commit before calling
1554: -- IGS_FI_PRC_FEE_ASS.finp_ins_enr_fee_ass because the first statement of
1555: -- IGS_FI_PRC_FEE_ASS.finp_ins_enr_fee_ass is to alter the rollback segment,
1556: -- which requires all the outstanding transactions to be committed or rolled back
1557: COMMIT;
1558:
1551:
1552:
1553: -- IGS_GE_NOTE: Must perform a commit before calling
1554: -- IGS_FI_PRC_FEE_ASS.finp_ins_enr_fee_ass because the first statement of
1555: -- IGS_FI_PRC_FEE_ASS.finp_ins_enr_fee_ass is to alter the rollback segment,
1556: -- which requires all the outstanding transactions to be committed or rolled back
1557: COMMIT;
1558:
1559: -- Enh# 3167098, Removed call to igs_en_gen_002.enrp_get_acad_comm which was used to derive the commencement date.
1559: -- Enh# 3167098, Removed call to igs_en_gen_002.enrp_get_acad_comm which was used to derive the commencement date.
1560: -- This is removed as SYSDATE is passed to effective date.
1561:
1562: -- Removed the parameter p_predictive_ass_ind from call to
1563: -- igs_fi_prc_fee_ass.finp_ins_enr_fee_ass
1564: IF NOT igs_fi_prc_fee_ass.finp_ins_enr_fee_ass (
1565: TRUNC(SYSDATE), -- effective date
1566: p_person_id,
1567: l_course_cd,
1560: -- This is removed as SYSDATE is passed to effective date.
1561:
1562: -- Removed the parameter p_predictive_ass_ind from call to
1563: -- igs_fi_prc_fee_ass.finp_ins_enr_fee_ass
1564: IF NOT igs_fi_prc_fee_ass.finp_ins_enr_fee_ass (
1565: TRUNC(SYSDATE), -- effective date
1566: p_person_id,
1567: l_course_cd,
1568: p_fee_cat,