[Home] [Help]
1707: l_rowid VARCHAR2(25);
1708: BEGIN
1709:
1710: IF p_sys_ltr_code = 'FAAWARD' THEN
1711: igf_aw_gen_004.award_letter_update(
1712: p_person_id => p_person_id,
1713: p_award_year => p_award_year,
1714: p_award_prd_cd => p_award_prd_cd);
1715: ELSIF P_SYS_LTR_CODE = 'FAMISTM' THEN
1712: p_person_id => p_person_id,
1713: p_award_year => p_award_year,
1714: p_award_prd_cd => p_award_prd_cd);
1715: ELSIF P_SYS_LTR_CODE = 'FAMISTM' THEN
1716: igf_aw_gen_004.missing_items_update(
1717: p_person_id => p_person_id,
1718: p_award_year => p_award_year);
1719: --Commented by Prajeesh as the Disbursement Update was happening before the CRM process it
1720: --pick up the record. As the record is getting updated first when CRM tries to pick, It is
1719: --Commented by Prajeesh as the Disbursement Update was happening before the CRM process it
1720: --pick up the record. As the record is getting updated first when CRM tries to pick, It is
1721: --Unable to pick up the record hence raises an Unhandled Exception.
1722: /*ELSIF P_SYS_LTR_CODE = 'FADISBT' THEN
1723: igf_aw_gen_004.loan_disbursement_update(
1724: p_person_id => p_person_id,
1725: p_award_year => p_award_year);*/
1726: END IF;
1727:
2317: --letter is actually picked up the fulfilment server of CRM. Thus it will always fail to
2318: -- pick up the record and hence gives an error. This is solved by initially not updating the status
2319: -- and next time when run update the status at the intiaial if it successfully sent by CRM Server.
2320: IF l_cur_int_hist.sys_ltr_code='FADISBT' AND l_c_crm_id.outcome_code='SUCCESS' THEN
2321: igf_aw_gen_004.loan_disbursement_update(
2322: p_person_id => l_cur_int_hist.student_id,
2323: p_award_year => RPAD(l_cur_int_hist.cal_type,10)||to_char(l_cur_int_hist.ci_sequence_number,'999999')
2324: );
2325: END IF;