DBA Data[Home] [Help]

APPS.IGF_AP_EFC_CALC dependencies on IGF_AP_EFC_CALC

Line 1: PACKAGE BODY igf_ap_efc_calc AS

1: PACKAGE BODY igf_ap_efc_calc AS
2: /* $Header: IGFAP25B.pls 120.3 2006/05/31 07:46:46 rajagupt ship $ */
3: /*
4: || Created By : pkpatel
5: || Created On : 10-DEC-2001

Line 134: m_pcont := igf_ap_efc_calc.isir_rec.PARENTS_CONTRIBUTION/9 ;

130: p_month_efc NUMBER;
131:
132: BEGIN
133:
134: m_pcont := igf_ap_efc_calc.isir_rec.PARENTS_CONTRIBUTION/9 ;
135: m_dep_stud_inc := igf_ap_efc_calc.isir_rec.SIC/9 ;
136: p_month_efc := ROUND(m_pcont) + ROUND(m_dep_stud_inc) ;
137: p_month_efc := p_month_efc * p_month ;
138: -- l_m_efc := l_m_efc + isir_rec.SCA;

Line 135: m_dep_stud_inc := igf_ap_efc_calc.isir_rec.SIC/9 ;

131:
132: BEGIN
133:
134: m_pcont := igf_ap_efc_calc.isir_rec.PARENTS_CONTRIBUTION/9 ;
135: m_dep_stud_inc := igf_ap_efc_calc.isir_rec.SIC/9 ;
136: p_month_efc := ROUND(m_pcont) + ROUND(m_dep_stud_inc) ;
137: p_month_efc := p_month_efc * p_month ;
138: -- l_m_efc := l_m_efc + isir_rec.SCA;
139:

Line 235: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_CALC.GET_EFC_NO_OF_MONTHS');

231:
232: EXCEPTION
233: WHEN OTHERS THEN
234: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
235: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_CALC.GET_EFC_NO_OF_MONTHS');
236: IGS_GE_MSG_STACK.ADD;
237: APP_EXCEPTION.RAISE_EXCEPTION;
238: END get_efc_no_of_months;
239:

Line 338: IF ( igf_ap_efc_calc.p_sys_award_year IN ('0607') ) THEN

334: FETCH alt_fact_cur INTO l_alt_fact_rec ;
335: CLOSE alt_fact_cur ;
336:
337: --Simplified Need Test for Dependent Model for 0607
338: IF ( igf_ap_efc_calc.p_sys_award_year IN ('0607') ) THEN
339:
340: --Bug #5201271
341: IF (
342: -- Edit 3001

Line 368: ELSIF ( igf_ap_efc_calc.p_sys_award_year IN ('0506') ) THEN

364: p_isir_rec.simplified_need_test := 'Y' ;
365: END IF ;
366:
367: --Simplified Need Test for Dependent Model for 0506
368: ELSIF ( igf_ap_efc_calc.p_sys_award_year IN ('0506') ) THEN
369:
370: -- for 0506, assumed value are not used, always use the reported values.
371: IF (
372: -- Edit 3001

Line 460: IF ( igf_ap_efc_calc.p_sys_award_year IN ('0607') ) THEN

456: OPEN alt_fact_cur ( l_dep, l_alternative ) ;
457: FETCH alt_fact_cur INTO l_alt_fact_rec ;
458: CLOSE alt_fact_cur ;
459:
460: IF ( igf_ap_efc_calc.p_sys_award_year IN ('0607') ) THEN
461:
462: -- Bug #5201271
463: IF(
464:

Line 489: ELSIF ( igf_ap_efc_calc.p_sys_award_year IN ('0506') ) THEN

485: -- Set Auto Zero EFC to 'Y'
486: p_isir_rec.auto_zero_efc := 'Y' ;
487: END IF;
488:
489: ELSIF ( igf_ap_efc_calc.p_sys_award_year IN ('0506') ) THEN
490:
491: -- for 0506, assumed value are not used, always use the reported values.
492: IF(
493:

Line 599: IF ( igf_ap_efc_calc.p_sys_award_year IN ('0506','0607') ) THEN

595: FETCH alt_fact_cur INTO l_alt_fact_rec ;
596: CLOSE alt_fact_cur ;
597:
598: -- start of 0506
599: IF ( igf_ap_efc_calc.p_sys_award_year IN ('0506','0607') ) THEN
600:
601: -- for 0506, assumed value are not used, always use the reported values.
602: IF (
603:

Line 669: IF ( igf_ap_efc_calc.p_sys_award_year IN ('0506','0607') ) THEN

665: FETCH alt_fact_cur INTO l_alt_fact_rec ;
666: CLOSE alt_fact_cur ;
667:
668: -- start of 0506
669: IF ( igf_ap_efc_calc.p_sys_award_year IN ('0506','0607') ) THEN
670:
671: IF(
672: -- Edit 3010
673: ( NVL( p_isir_rec.a_student_marital_status , p_isir_rec.s_marital_status ) = '2' AND

Line 855: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_CALC.GET_EFC_FRML');

851:
852: EXCEPTION
853: WHEN OTHERS THEN
854: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
855: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_CALC.GET_EFC_FRML');
856: IGS_GE_MSG_STACK.ADD;
857: APP_EXCEPTION.RAISE_EXCEPTION;
858:
859: END get_efc_frml ;

Line 969: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_CALC.EFC_A');

965: WHEN EXCEPTION_IN_SETUP THEN
966: APP_EXCEPTION.RAISE_EXCEPTION;
967: WHEN OTHERS THEN
968: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP'||SQLERRM);
969: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_CALC.EFC_A');
970: IGS_GE_MSG_STACK.ADD;
971: APP_EXCEPTION.RAISE_EXCEPTION;
972: END efc_a;
973:

Line 1039: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_CALC.EFC_B');

1035: WHEN EXCEPTION_IN_SETUP THEN
1036: APP_EXCEPTION.RAISE_EXCEPTION;
1037: WHEN OTHERS THEN
1038: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1039: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_CALC.EFC_B');
1040: IGS_GE_MSG_STACK.ADD;
1041: APP_EXCEPTION.RAISE_EXCEPTION;
1042:
1043: END efc_b;

Line 1111: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_CALC.EFC_C');

1107: WHEN EXCEPTION_IN_SETUP THEN
1108: APP_EXCEPTION.RAISE_EXCEPTION;
1109: WHEN OTHERS THEN
1110: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1111: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_CALC.EFC_C');
1112: IGS_GE_MSG_STACK.ADD;
1113: APP_EXCEPTION.RAISE_EXCEPTION;
1114: END efc_c;
1115:

Line 1554: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_CALC.CALC_EFC_MAIN');

1550: WHEN EXCEPTION_IN_SETUP THEN
1551: APP_EXCEPTION.RAISE_EXCEPTION;
1552: WHEN OTHERS THEN
1553: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP'||SQLERRM);
1554: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_CALC.CALC_EFC_MAIN');
1555: IGS_GE_MSG_STACK.ADD;
1556: APP_EXCEPTION.RAISE_EXCEPTION;
1557:
1558: END calc_efc_main ;

Line 1817: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_CALC.CALCULATE_EFC');

1813: APP_EXCEPTION.RAISE_EXCEPTION;
1814:
1815: WHEN OTHERS THEN
1816: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP'||SQLERRM);
1817: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_CALC.CALCULATE_EFC');
1818: IGS_GE_MSG_STACK.ADD;
1819: APP_EXCEPTION.RAISE_EXCEPTION;
1820:
1821: END calculate_efc ;

Line 1823: END igf_ap_efc_calc;

1819: APP_EXCEPTION.RAISE_EXCEPTION;
1820:
1821: END calculate_efc ;
1822:
1823: END igf_ap_efc_calc;