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.

APPS.IGF_AP_EFC_SUBF dependencies on IGS_GE_MSG_STACK

Line 86: IGS_GE_MSG_STACK.ADD;

82: EXCEPTION
83: WHEN OTHERS THEN
84: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
85: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.A_P_INC');
86: IGS_GE_MSG_STACK.ADD;
87: APP_EXCEPTION.RAISE_EXCEPTION;
88: END a_p_inc;
89:
90:

Line 237: IGS_GE_MSG_STACK.ADD;

233: IF state_allow_cur%NOTFOUND THEN
234: CLOSE state_allow_cur;
235: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_TAX_SETUP');
236: FND_MESSAGE.SET_TOKEN('TABLE_NAME','A1');
237: IGS_GE_MSG_STACK.ADD;
238: RAISE exception_in_setup;
239: END IF;
240: END IF;
241: CLOSE state_allow_cur;

Line 269: IGS_GE_MSG_STACK.ADD;

265: IF sst_cur%NOTFOUND THEN
266: CLOSE sst_cur;
267: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_GEN_TAX_SETUP');
268: FND_MESSAGE.SET_TOKEN('TABLE_NAME','A2');
269: IGS_GE_MSG_STACK.ADD;
270: RAISE exception_in_setup;
271: END IF;
272: CLOSE sst_cur;
273:

Line 299: IGS_GE_MSG_STACK.ADD;

295: IF sst_cur%NOTFOUND THEN
296: CLOSE sst_cur;
297: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_GEN_TAX_SETUP');
298: FND_MESSAGE.SET_TOKEN('TABLE_NAME','A2');
299: IGS_GE_MSG_STACK.ADD;
300: RAISE exception_in_setup;
301: END IF;
302: CLOSE sst_cur;
303:

Line 333: IGS_GE_MSG_STACK.ADD;

329: CLOSE ipa_cur;
330: IF( p_n_fam IS NULL) OR (p_n_col IS NULL ) THEN
331: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_INC_PRT_ALW_SETUP');
332: FND_MESSAGE.SET_TOKEN('TABLE_NAME','A3');
333: IGS_GE_MSG_STACK.ADD;
334: RAISE exception_in_setup;
335: END IF;
336:
337: p_n_fam1 := 0;

Line 374: IGS_GE_MSG_STACK.ADD;

370: FETCH eea_cur INTO eea_rec;
371: IF eea_cur%NOTFOUND THEN
372: CLOSE eea_cur;
373: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_EFCA_SETUP');
374: IGS_GE_MSG_STACK.ADD;
375: RAISE exception_in_setup;
376: END IF;
377: CLOSE eea_cur;
378:

Line 438: IGS_GE_MSG_STACK.ADD;

434: RAISE igf_ap_efc_calc.exception_in_setup; -- Exception to be handled in the Calling Procedures
435: WHEN OTHERS THEN
436: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
437: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.A_ALLOW_AG_P_INC');
438: IGS_GE_MSG_STACK.ADD;
439: APP_EXCEPTION.RAISE_EXCEPTION;
440: END a_allow_ag_p_inc;
441:
442:

Line 523: IGS_GE_MSG_STACK.ADD;

519: EXCEPTION
520: WHEN OTHERS THEN
521: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
522: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.GET_AGE_OLDER_PARENT');
523: IGS_GE_MSG_STACK.ADD;
524: APP_EXCEPTION.RAISE_EXCEPTION;
525: END get_age_older_parent ;
526:
527:

Line 599: IGS_GE_MSG_STACK.ADD;

595: IF business_networth_cur%NOTFOUND THEN
596: CLOSE business_networth_cur;
597: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_GEN_TAX_SETUP');
598: FND_MESSAGE.SET_TOKEN('TABLE_NAME','A4');
599: IGS_GE_MSG_STACK.ADD;
600: RAISE exception_in_setup;
601: END IF;
602: CLOSE business_networth_cur;
603:

Line 653: IGS_GE_MSG_STACK.ADD;

649: IF asset_cur%NOTFOUND THEN
650: CLOSE asset_cur;
651: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_ASSET_SETUP');
652: FND_MESSAGE.SET_TOKEN('TABLE_NAME','A5');
653: IGS_GE_MSG_STACK.ADD;
654: RAISE exception_in_setup;
655: END IF;
656: CLOSE asset_cur;
657:

Line 678: IGS_GE_MSG_STACK.ADD;

674: FETCH efca_cur INTO efca_rec;
675: IF efca_cur%NOTFOUND THEN
676: CLOSE efca_cur;
677: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_EFCA_SETUP');
678: IGS_GE_MSG_STACK.ADD;
679: RAISE exception_in_setup;
680: END IF;
681: CLOSE efca_cur;
682:

Line 702: IGS_GE_MSG_STACK.ADD;

698: RAISE igf_ap_efc_calc.exception_in_setup; -- Exception to be handled in the Calling Procedures
699: WHEN OTHERS THEN
700: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
701: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.A_P_CONT_ASSETS');
702: IGS_GE_MSG_STACK.ADD;
703: APP_EXCEPTION.RAISE_EXCEPTION;
704: END a_p_cont_assets;
705:
706:

Line 751: IGS_GE_MSG_STACK.ADD;

747: IF p_cont_aai_cur%NOTFOUND THEN
748: CLOSE p_cont_aai_cur;
749: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_GEN_TAX_SETUP');
750: FND_MESSAGE.SET_TOKEN('TABLE_NAME','A6');
751: IGS_GE_MSG_STACK.ADD;
752: RAISE exception_in_setup;
753: END IF;
754: CLOSE p_cont_aai_cur;
755:

Line 794: IGS_GE_MSG_STACK.ADD;

790: RAISE igf_ap_efc_calc.exception_in_setup; -- Exception to be handled in the Calling Procedures
791: WHEN OTHERS THEN
792: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
793: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.A_P_CONT');
794: IGS_GE_MSG_STACK.ADD;
795: APP_EXCEPTION.RAISE_EXCEPTION;
796: END a_p_cont;
797:
798:

Line 860: IGS_GE_MSG_STACK.ADD;

856: EXCEPTION
857: WHEN OTHERS THEN
858: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
859: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.A_S_INC');
860: IGS_GE_MSG_STACK.ADD;
861: APP_EXCEPTION.RAISE_EXCEPTION;
862: END a_s_inc;
863:
864:

Line 992: IGS_GE_MSG_STACK.ADD;

988: IF state_allow_cur%NOTFOUND THEN
989: CLOSE state_allow_cur;
990: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_TAX_SETUP');
991: FND_MESSAGE.SET_TOKEN('TABLE_NAME','A7');
992: IGS_GE_MSG_STACK.ADD;
993: RAISE exception_in_setup;
994: END IF;
995: END IF;
996: CLOSE state_allow_cur;

Line 1020: IGS_GE_MSG_STACK.ADD;

1016: IF sst_cur%NOTFOUND THEN
1017: CLOSE sst_cur;
1018: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_GEN_TAX_SETUP');
1019: FND_MESSAGE.SET_TOKEN('TABLE_NAME','A2');
1020: IGS_GE_MSG_STACK.ADD;
1021: RAISE exception_in_setup;
1022: END IF;
1023: CLOSE sst_cur;
1024:

Line 1049: IGS_GE_MSG_STACK.ADD;

1045: FETCH ipa_cur INTO ipa_rec;
1046: IF ipa_cur%NOTFOUND THEN
1047: CLOSE ipa_cur;
1048: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_EFCA_SETUP');
1049: IGS_GE_MSG_STACK.ADD;
1050: RAISE exception_in_setup;
1051: END IF;
1052:
1053: l_ipa := NVL(ipa_rec.stud_inc_prot_allowance,0);

Line 1077: IGS_GE_MSG_STACK.ADD;

1073: RAISE igf_ap_efc_calc.exception_in_setup; -- Exception to be handled in the Calling Procedures
1074: WHEN OTHERS THEN
1075: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1076: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.A_ALLOW_AG_S_INC');
1077: IGS_GE_MSG_STACK.ADD;
1078: APP_EXCEPTION.RAISE_EXCEPTION;
1079: END a_allow_ag_s_inc;
1080:
1081:

Line 1111: IGS_GE_MSG_STACK.ADD;

1107: FETCH efcA_cur INTO efcA_rec;
1108: IF efcA_cur%NOTFOUND THEN
1109: CLOSE efcA_cur;
1110: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_EFCA_SETUP');
1111: IGS_GE_MSG_STACK.ADD;
1112: RAISE exception_in_setup;
1113: END IF;
1114: CLOSE efcA_cur;
1115:

Line 1133: IGS_GE_MSG_STACK.ADD;

1129: RAISE igf_ap_efc_calc.exception_in_setup; -- Exception to be handled in the Calling Procedures
1130: WHEN OTHERS THEN
1131: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1132: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.A_S_CONT');
1133: IGS_GE_MSG_STACK.ADD;
1134: APP_EXCEPTION.RAISE_EXCEPTION;
1135:
1136: END a_s_cont;
1137:

Line 1186: IGS_GE_MSG_STACK.ADD;

1182: FETCH efcA_cur INTO efcA_rec;
1183: IF efcA_cur%NOTFOUND THEN
1184: CLOSE efcA_cur;
1185: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_EFCA_SETUP');
1186: IGS_GE_MSG_STACK.ADD;
1187: RAISE exception_in_setup;
1188: END IF;
1189: CLOSE efcA_cur;
1190:

Line 1210: IGS_GE_MSG_STACK.ADD;

1206: RAISE igf_ap_efc_calc.exception_in_setup; -- Exception to be handled in the Calling Procedures
1207: WHEN OTHERS THEN
1208: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1209: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.A_S_CONT_ASSETS');
1210: IGS_GE_MSG_STACK.ADD;
1211: APP_EXCEPTION.RAISE_EXCEPTION;
1212: END a_s_cont_assets;
1213:
1214:

Line 1361: IGS_GE_MSG_STACK.ADD;

1357: FETCH efcA_cur INTO efcA_rec;
1358: IF efcA_cur%NOTFOUND THEN
1359: CLOSE efcA_cur;
1360: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_EFCA_SETUP');
1361: IGS_GE_MSG_STACK.ADD;
1362: RAISE exception_in_setup;
1363: END IF;
1364: CLOSE efcA_cur;
1365:

Line 1378: IGS_GE_MSG_STACK.ADD;

1374: IF p_cont_aai_cur%NOTFOUND THEN
1375: CLOSE p_cont_aai_cur;
1376: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_GEN_TAX_SETUP');
1377: FND_MESSAGE.SET_TOKEN('TABLE_NAME','A6');
1378: IGS_GE_MSG_STACK.ADD;
1379: RAISE exception_in_setup;
1380: END IF;
1381: CLOSE p_cont_aai_cur;
1382:

Line 1421: IGS_GE_MSG_STACK.ADD;

1417: RAISE igf_ap_efc_calc.exception_in_setup; -- Exception to be handled in the Calling Procedures
1418: WHEN OTHERS THEN
1419: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1420: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.A_P_CONT_MORE_9');
1421: IGS_GE_MSG_STACK.ADD;
1422: APP_EXCEPTION.RAISE_EXCEPTION;
1423: END a_p_cont_more_9;
1424:
1425:

Line 1496: IGS_GE_MSG_STACK.ADD;

1492:
1493: WHEN OTHERS THEN
1494: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1495: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.B_S_INC');
1496: IGS_GE_MSG_STACK.ADD;
1497: APP_EXCEPTION.RAISE_EXCEPTION;
1498:
1499: END b_s_inc;
1500:

Line 1612: IGS_GE_MSG_STACK.ADD;

1608: IF state_allow_cur%NOTFOUND THEN
1609: CLOSE state_allow_cur;
1610: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_TAX_SETUP');
1611: FND_MESSAGE.SET_TOKEN('TABLE_NAME','B1');
1612: IGS_GE_MSG_STACK.ADD;
1613: RAISE exception_in_setup;
1614: END IF;
1615: END IF;
1616: CLOSE state_allow_cur;

Line 1640: IGS_GE_MSG_STACK.ADD;

1636: IF sst_cur%NOTFOUND THEN
1637: CLOSE sst_cur;
1638: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_GEN_TAX_SETUP');
1639: FND_MESSAGE.SET_TOKEN('TABLE_NAME','A2');
1640: IGS_GE_MSG_STACK.ADD;
1641: RAISE exception_in_setup;
1642: END IF;
1643: CLOSE sst_cur;
1644:

Line 1671: IGS_GE_MSG_STACK.ADD;

1667: IF sst_cur%NOTFOUND THEN
1668: CLOSE sst_cur;
1669: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_GEN_TAX_SETUP');
1670: FND_MESSAGE.SET_TOKEN('TABLE_NAME','B2');
1671: IGS_GE_MSG_STACK.ADD;
1672: RAISE exception_in_setup;
1673: END IF;
1674: CLOSE sst_cur;
1675:

Line 1704: IGS_GE_MSG_STACK.ADD;

1700: FETCH efcB_cur INTO efcB_rec;
1701: IF efcB_cur%NOTFOUND THEN
1702: CLOSE efcB_cur;
1703: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_EFCB_SETUP');
1704: IGS_GE_MSG_STACK.ADD;
1705: RAISE exception_in_setup;
1706: END IF;
1707: CLOSE efcB_cur;
1708: -- Calculate the Income Protection Allowance

Line 1787: IGS_GE_MSG_STACK.ADD;

1783: RAISE igf_ap_efc_calc.exception_in_setup; -- Exception to be handled in the Calling Procedures
1784: WHEN OTHERS THEN
1785: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1786: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.B_ALLOW_AG_S_INC');
1787: IGS_GE_MSG_STACK.ADD;
1788: APP_EXCEPTION.RAISE_EXCEPTION;
1789: END b_allow_ag_s_inc;
1790:
1791:

Line 1822: IGS_GE_MSG_STACK.ADD;

1818: FETCH efcB_cur INTO efcB_rec;
1819: IF efcB_cur%NOTFOUND THEN
1820: CLOSE efcB_cur;
1821: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_EFCB_SETUP');
1822: IGS_GE_MSG_STACK.ADD;
1823: RAISE exception_in_setup;
1824: END IF;
1825: CLOSE efcB_cur;
1826:

Line 1846: IGS_GE_MSG_STACK.ADD;

1842: RAISE igf_ap_efc_calc.exception_in_setup; -- Exception to be handled in the Calling Procedures
1843: WHEN OTHERS THEN
1844: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1845: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.B_S_CONT');
1846: IGS_GE_MSG_STACK.ADD;
1847: APP_EXCEPTION.RAISE_EXCEPTION;
1848:
1849: END b_s_cont;
1850:

Line 1935: IGS_GE_MSG_STACK.ADD;

1931: IF business_networth_cur%NOTFOUND THEN
1932: CLOSE business_networth_cur;
1933: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_GEN_TAX_SETUP');
1934: FND_MESSAGE.SET_TOKEN('TABLE_NAME','B3'); --made B3 from A4 by gmuralid
1935: IGS_GE_MSG_STACK.ADD;
1936: RAISE exception_in_setup;
1937: END IF;
1938: CLOSE business_networth_cur;
1939:

Line 1968: IGS_GE_MSG_STACK.ADD;

1964: l_age_student := FLOOR((TO_NUMBER(TO_CHAR(l_base_date,'YYYY')) - TO_NUMBER(TO_CHAR(igf_ap_efc_calc.isir_rec.date_of_birth,'YYYY'))));
1965:
1966: ELSE
1967: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_DOB_SPECIFIED');
1968: IGS_GE_MSG_STACK.ADD;
1969: RAISE exception_in_setup;
1970: END IF;
1971:
1972: IF l_age_student < 25 THEN

Line 1985: IGS_GE_MSG_STACK.ADD;

1981: IF asset_cur%NOTFOUND THEN
1982: CLOSE asset_cur;
1983: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_ASSET_SETUP');
1984: FND_MESSAGE.SET_TOKEN('TABLE_NAME','B4');
1985: IGS_GE_MSG_STACK.ADD;
1986: RAISE exception_in_setup;
1987: END IF;
1988: CLOSE asset_cur;
1989:

Line 2012: IGS_GE_MSG_STACK.ADD;

2008: FETCH efcB_cur INTO efcB_rec;
2009: IF efcB_cur%NOTFOUND THEN
2010: CLOSE efcB_cur;
2011: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_EFCB_SETUP');
2012: IGS_GE_MSG_STACK.ADD;
2013: RAISE exception_in_setup;
2014: END IF;
2015: CLOSE efcB_cur;
2016:

Line 2035: IGS_GE_MSG_STACK.ADD;

2031: RAISE igf_ap_efc_calc.exception_in_setup; -- Exception to be handled in the Calling Procedures
2032: WHEN OTHERS THEN
2033: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2034: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.B_S_CONT_ASSETS');
2035: IGS_GE_MSG_STACK.ADD;
2036: APP_EXCEPTION.RAISE_EXCEPTION;
2037:
2038: END b_s_cont_assets;
2039:

Line 2157: IGS_GE_MSG_STACK.ADD;

2153:
2154: WHEN OTHERS THEN
2155: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2156: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.C_S_INC');
2157: IGS_GE_MSG_STACK.ADD;
2158: APP_EXCEPTION.RAISE_EXCEPTION;
2159: END c_s_inc;
2160:
2161:

Line 2292: IGS_GE_MSG_STACK.ADD;

2288: IF state_allow_cur%NOTFOUND THEN
2289: CLOSE state_allow_cur;
2290: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_TAX_SETUP');
2291: FND_MESSAGE.SET_TOKEN('TABLE_NAME','C1');
2292: IGS_GE_MSG_STACK.ADD;
2293: RAISE exception_in_setup;
2294: END IF;
2295: END IF;
2296: CLOSE state_allow_cur;

Line 2322: IGS_GE_MSG_STACK.ADD;

2318: IF sst_cur%NOTFOUND THEN
2319: CLOSE sst_cur;
2320: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_GEN_TAX_SETUP');
2321: FND_MESSAGE.SET_TOKEN('TABLE_NAME','C2');
2322: IGS_GE_MSG_STACK.ADD;
2323: RAISE exception_in_setup;
2324: END IF;
2325: CLOSE sst_cur;
2326:

Line 2350: IGS_GE_MSG_STACK.ADD;

2346: IF sst_cur%NOTFOUND THEN
2347: CLOSE sst_cur;
2348: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_GEN_TAX_SETUP');
2349: FND_MESSAGE.SET_TOKEN('TABLE_NAME','C2');
2350: IGS_GE_MSG_STACK.ADD;
2351: RAISE exception_in_setup;
2352: END IF;
2353: CLOSE sst_cur;
2354:

Line 2383: IGS_GE_MSG_STACK.ADD;

2379: CLOSE ipa_cur;
2380: IF( s_n_fam IS NULL) OR (s_n_col IS NULL ) THEN
2381: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_INC_PRT_ALW_SETUP');
2382: FND_MESSAGE.SET_TOKEN('TABLE_NAME','C3');
2383: IGS_GE_MSG_STACK.ADD;
2384: RAISE exception_in_setup;
2385: END IF;
2386:
2387: s_n_fam1 := 0;

Line 2424: IGS_GE_MSG_STACK.ADD;

2420: FETCH efcC_cur INTO efcC_rec;
2421: IF efcC_cur%NOTFOUND THEN
2422: CLOSE efcC_cur;
2423: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_EFCC_SETUP');
2424: IGS_GE_MSG_STACK.ADD;
2425: RAISE exception_in_setup;
2426: END IF;
2427: CLOSE efcC_cur;
2428:

Line 2474: IGS_GE_MSG_STACK.ADD;

2470: WHEN exception_in_setup THEN
2471: RAISE igf_ap_efc_calc.exception_in_setup; -- Exception to be handled in the Calling Procedures
2472: WHEN OTHERS THEN FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2473: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.C_ALLOW_AG_S_INC');
2474: IGS_GE_MSG_STACK.ADD;
2475: APP_EXCEPTION.RAISE_EXCEPTION;
2476:
2477: END c_allow_ag_s_inc;
2478:

Line 2588: IGS_GE_MSG_STACK.ADD;

2584: IF business_networth_cur%NOTFOUND THEN
2585: CLOSE business_networth_cur;
2586: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_GEN_TAX_SETUP');
2587: FND_MESSAGE.SET_TOKEN('TABLE_NAME','C4');
2588: IGS_GE_MSG_STACK.ADD;
2589: RAISE exception_in_setup;
2590: END IF;
2591: CLOSE business_networth_cur;
2592:

Line 2616: IGS_GE_MSG_STACK.ADD;

2612: -- l_age_student := FLOOR(MONTHS_BETWEEN(l_base_date,igf_ap_efc_calc.isir_rec.date_of_birth)/12);
2613: l_age_student := FLOOR((TO_NUMBER(TO_CHAR(l_base_date,'YYYY')) - TO_NUMBER(TO_CHAR(igf_ap_efc_calc.isir_rec.date_of_birth,'YYYY'))));
2614: ELSE
2615: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_DOB_SPECIFIED');
2616: IGS_GE_MSG_STACK.ADD;
2617: RAISE exception_in_setup;
2618: END IF;
2619:
2620: IF l_age_student < 25 THEN

Line 2633: IGS_GE_MSG_STACK.ADD;

2629: IF asset_cur%NOTFOUND THEN
2630: CLOSE asset_cur;
2631: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_ASSET_SETUP');
2632: FND_MESSAGE.SET_TOKEN('TABLE_NAME','C5');
2633: IGS_GE_MSG_STACK.ADD;
2634: RAISE exception_in_setup;
2635: END IF;
2636: CLOSE asset_cur;
2637:

Line 2660: IGS_GE_MSG_STACK.ADD;

2656: FETCH efcC_cur INTO efcC_rec;
2657: IF efcC_cur%NOTFOUND THEN
2658: CLOSE efcC_cur;
2659: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_EFCC_SETUP');
2660: IGS_GE_MSG_STACK.ADD;
2661: RAISE exception_in_setup;
2662: END IF;
2663: CLOSE efcC_cur;
2664:

Line 2683: IGS_GE_MSG_STACK.ADD;

2679: RAISE igf_ap_efc_calc.exception_in_setup; -- Exception to be handled in the Calling Procedures
2680: WHEN OTHERS THEN
2681: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2682: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.C_S_CONT_ASSETS');
2683: IGS_GE_MSG_STACK.ADD;
2684: APP_EXCEPTION.RAISE_EXCEPTION;
2685:
2686: END c_s_cont_assets;
2687:

Line 2735: IGS_GE_MSG_STACK.ADD;

2731: IF cont_aai_cur%NOTFOUND THEN
2732: CLOSE cont_aai_cur;
2733: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_GEN_TAX_SETUP');
2734: FND_MESSAGE.SET_TOKEN('TABLE_NAME','C6');
2735: IGS_GE_MSG_STACK.ADD;
2736: RAISE exception_in_setup;
2737: END IF;
2738: CLOSE cont_aai_cur;
2739:

Line 2778: IGS_GE_MSG_STACK.ADD;

2774: RAISE igf_ap_efc_calc.exception_in_setup; -- Exception to be handled in the Calling Procedures
2775: WHEN OTHERS THEN
2776: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2777: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.C_EFC');
2778: IGS_GE_MSG_STACK.ADD;
2779: APP_EXCEPTION.RAISE_EXCEPTION;
2780:
2781: END c_efc;
2782:

Line 2845: IGS_GE_MSG_STACK.ADD;

2841: EXCEPTION
2842: WHEN OTHERS THEN
2843: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2844: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.EFC_CUTOFF_DATE');
2845: IGS_GE_MSG_STACK.ADD;
2846: APP_EXCEPTION.RAISE_EXCEPTION;
2847:
2848: END efc_cutoff_date;
2849:

Line 2881: IGS_GE_MSG_STACK.ADD;

2877: EXCEPTION
2878: WHEN OTHERS THEN
2879: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2880: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.GET_PAR_STUD_CONT');
2881: IGS_GE_MSG_STACK.ADD;
2882: APP_EXCEPTION.RAISE_EXCEPTION;
2883:
2884: END get_par_stud_cont ;
2885: