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 FND_MESSAGE

Line 84: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

80: igf_ap_efc_calc.isir_rec.secti := p_p_inc; --Assignment of intermediate values
81:
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;

Line 85: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.A_P_INC');

81:
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:

Line 235: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_TAX_SETUP');

231: OPEN state_allow_cur('OT');
232: FETCH state_allow_cur INTO state_allow_rec;
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;

Line 236: FND_MESSAGE.SET_TOKEN('TABLE_NAME','A1');

232: FETCH state_allow_cur INTO state_allow_rec;
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;

Line 267: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_GEN_TAX_SETUP');

263: OPEN sst_cur(greatest(NVL(igf_ap_efc_calc.isir_rec.a_f_work_income,igf_ap_efc_calc.isir_rec.f_income_work),0));
264: FETCH sst_cur INTO sst_rec;
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;

Line 268: FND_MESSAGE.SET_TOKEN('TABLE_NAME','A2');

264: FETCH sst_cur INTO sst_rec;
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;

Line 297: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_GEN_TAX_SETUP');

293: OPEN sst_cur(greatest(NVL(igf_ap_efc_calc.isir_rec.a_m_work_income,igf_ap_efc_calc.isir_rec.m_income_work),0));
294: FETCH sst_cur INTO sst_rec;
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;

Line 298: FND_MESSAGE.SET_TOKEN('TABLE_NAME','A2');

294: FETCH sst_cur INTO sst_rec;
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;

Line 331: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_INC_PRT_ALW_SETUP');

327:
328: IF ipa_cur%NOTFOUND THEN
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;

Line 332: FND_MESSAGE.SET_TOKEN('TABLE_NAME','A3');

328: IF ipa_cur%NOTFOUND THEN
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:

Line 373: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_EFCA_SETUP');

369: OPEN eea_cur;
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;

Line 436: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

432: EXCEPTION
433: WHEN exception_in_setup THEN
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;

Line 437: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.A_ALLOW_AG_P_INC');

433: WHEN exception_in_setup THEN
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:

Line 521: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

517: END IF;
518:
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 ;

Line 522: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.GET_AGE_OLDER_PARENT');

518:
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:

Line 597: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_GEN_TAX_SETUP');

593: OPEN business_networth_cur(l_business_networth);
594: FETCH business_networth_cur INTO business_networth_rec;
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;

Line 598: FND_MESSAGE.SET_TOKEN('TABLE_NAME','A4');

594: FETCH business_networth_cur INTO business_networth_rec;
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;

Line 651: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_ASSET_SETUP');

647: OPEN asset_cur(l_age_parent);
648: FETCH asset_cur INTO asset_rec;
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;

Line 652: FND_MESSAGE.SET_TOKEN('TABLE_NAME','A5');

648: FETCH asset_cur INTO asset_rec;
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;

Line 677: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_EFCA_SETUP');

673: OPEN efca_cur;
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;

Line 700: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

696: EXCEPTION
697: WHEN exception_in_setup THEN
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;

Line 701: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.A_P_CONT_ASSETS');

697: WHEN exception_in_setup THEN
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:

Line 749: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_GEN_TAX_SETUP');

745: OPEN p_cont_aai_cur(p_p_aai);
746: FETCH p_cont_aai_cur INTO p_cont_aai_rec;
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;

Line 750: FND_MESSAGE.SET_TOKEN('TABLE_NAME','A6');

746: FETCH p_cont_aai_cur INTO p_cont_aai_rec;
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;

Line 792: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

788: EXCEPTION
789: WHEN EXCEPTION_IN_SETUP THEN
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;

Line 793: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.A_P_CONT');

789: WHEN EXCEPTION_IN_SETUP THEN
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:

Line 858: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

854:
855:
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;

Line 859: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.A_S_INC');

855:
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:

Line 990: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_TAX_SETUP');

986: OPEN state_allow_cur('OT');
987: FETCH state_allow_cur INTO state_allow_rec;
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;

Line 991: FND_MESSAGE.SET_TOKEN('TABLE_NAME','A7');

987: FETCH state_allow_cur INTO state_allow_rec;
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;

Line 1018: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_GEN_TAX_SETUP');

1014: OPEN sst_cur(greatest(NVL(igf_ap_efc_calc.isir_rec.a_s_income_work,igf_ap_efc_calc.isir_rec.s_income_from_work),0));
1015: FETCH sst_cur INTO sst_rec;
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;

Line 1019: FND_MESSAGE.SET_TOKEN('TABLE_NAME','A2');

1015: FETCH sst_cur INTO sst_rec;
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;

Line 1048: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_EFCA_SETUP');

1044: OPEN ipa_cur;
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:

Line 1075: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1071: EXCEPTION
1072: WHEN exception_in_setup THEN
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;

Line 1076: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.A_ALLOW_AG_S_INC');

1072: WHEN exception_in_setup THEN
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:

Line 1110: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_EFCA_SETUP');

1106: OPEN efcA_cur;
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;

Line 1131: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1127: EXCEPTION
1128: WHEN exception_in_setup THEN
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:

Line 1132: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.A_S_CONT');

1128: WHEN exception_in_setup THEN
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;

Line 1185: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_EFCA_SETUP');

1181: OPEN efcA_cur;
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;

Line 1208: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1204: EXCEPTION
1205: WHEN exception_in_setup THEN
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;

Line 1209: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.A_S_CONT_ASSETS');

1205: WHEN exception_in_setup THEN
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:

Line 1360: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_EFCA_SETUP');

1356: OPEN efcA_cur;
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;

Line 1376: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_GEN_TAX_SETUP');

1372: OPEN p_cont_aai_cur(l_aai_more_9);
1373: FETCH p_cont_aai_cur INTO p_cont_aai_rec;
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;

Line 1377: FND_MESSAGE.SET_TOKEN('TABLE_NAME','A6');

1373: FETCH p_cont_aai_cur INTO p_cont_aai_rec;
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;

Line 1419: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1415: EXCEPTION
1416: WHEN exception_in_setup THEN
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;

Line 1420: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.A_P_CONT_MORE_9');

1416: WHEN exception_in_setup THEN
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:

Line 1494: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1490:
1491: EXCEPTION
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:

Line 1495: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.B_S_INC');

1491: EXCEPTION
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;

Line 1610: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_TAX_SETUP');

1606: OPEN state_allow_cur('OT');
1607: FETCH state_allow_cur INTO state_allow_rec;
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;

Line 1611: FND_MESSAGE.SET_TOKEN('TABLE_NAME','B1');

1607: FETCH state_allow_cur INTO state_allow_rec;
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;

Line 1638: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_GEN_TAX_SETUP');

1634: OPEN sst_cur(greatest(NVL(igf_ap_efc_calc.isir_rec.a_s_income_work,igf_ap_efc_calc.isir_rec.s_income_from_work),0));
1635: FETCH sst_cur INTO sst_rec;
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;

Line 1639: FND_MESSAGE.SET_TOKEN('TABLE_NAME','A2');

1635: FETCH sst_cur INTO sst_rec;
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;

Line 1669: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_GEN_TAX_SETUP');

1665: OPEN sst_cur(greatest(NVL(igf_ap_efc_calc.isir_rec.a_spouse_income_work,igf_ap_efc_calc.isir_rec.spouse_income_from_work),0));
1666: FETCH sst_cur INTO sst_rec;
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;

Line 1670: FND_MESSAGE.SET_TOKEN('TABLE_NAME','B2');

1666: FETCH sst_cur INTO sst_rec;
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;

Line 1703: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_EFCB_SETUP');

1699: OPEN efcB_cur;
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;

Line 1785: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1781: EXCEPTION
1782: WHEN exception_in_setup THEN
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;

Line 1786: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.B_ALLOW_AG_S_INC');

1782: WHEN exception_in_setup THEN
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:

Line 1821: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_EFCB_SETUP');

1817: OPEN efcB_cur;
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;

Line 1844: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

1840: EXCEPTION
1841: WHEN exception_in_setup THEN
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:

Line 1845: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.B_S_CONT');

1841: WHEN exception_in_setup THEN
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;

Line 1933: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_GEN_TAX_SETUP');

1929: OPEN business_networth_cur(l_business_networth);
1930: FETCH business_networth_cur INTO business_networth_rec;
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;

Line 1934: FND_MESSAGE.SET_TOKEN('TABLE_NAME','B3'); --made B3 from A4 by gmuralid

1930: FETCH business_networth_cur INTO business_networth_rec;
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;

Line 1967: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_DOB_SPECIFIED');

1963: -- l_age_student := FLOOR(MONTHS_BETWEEN(l_base_date,igf_ap_efc_calc.isir_rec.date_of_birth)/12); -- confirmed with ches and pdf , made 31/12/2003
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:

Line 1983: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_ASSET_SETUP');

1979: OPEN asset_cur(l_age_student);
1980: FETCH asset_cur INTO asset_rec;
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;

Line 1984: FND_MESSAGE.SET_TOKEN('TABLE_NAME','B4');

1980: FETCH asset_cur INTO asset_rec;
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;

Line 2011: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_EFCB_SETUP');

2007: OPEN efcB_cur;
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;

Line 2033: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

2029: EXCEPTION
2030: WHEN exception_in_setup THEN
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:

Line 2034: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.B_S_CONT_ASSETS');

2030: WHEN exception_in_setup THEN
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;

Line 2155: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

2151:
2152: EXCEPTION
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;

Line 2156: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.C_S_INC');

2152: EXCEPTION
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:

Line 2290: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_TAX_SETUP');

2286: OPEN state_allow_cur('OT');
2287: FETCH state_allow_cur INTO state_allow_rec;
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;

Line 2291: FND_MESSAGE.SET_TOKEN('TABLE_NAME','C1');

2287: FETCH state_allow_cur INTO state_allow_rec;
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;

Line 2320: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_GEN_TAX_SETUP');

2316: OPEN sst_cur(greatest(NVL(igf_ap_efc_calc.isir_rec.a_s_income_work,igf_ap_efc_calc.isir_rec.s_income_from_work),0));
2317: FETCH sst_cur INTO sst_rec;
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;

Line 2321: FND_MESSAGE.SET_TOKEN('TABLE_NAME','C2');

2317: FETCH sst_cur INTO sst_rec;
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;

Line 2348: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_GEN_TAX_SETUP');

2344: OPEN sst_cur(greatest(NVL(igf_ap_efc_calc.isir_rec.a_spouse_income_work,igf_ap_efc_calc.isir_rec.spouse_income_from_work),0));
2345: FETCH sst_cur INTO sst_rec;
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;

Line 2349: FND_MESSAGE.SET_TOKEN('TABLE_NAME','C2');

2345: FETCH sst_cur INTO sst_rec;
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;

Line 2381: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_INC_PRT_ALW_SETUP');

2377: FETCH ipa_cur INTO ipa_rec;
2378: IF ipa_cur%NOTFOUND THEN
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;

Line 2382: FND_MESSAGE.SET_TOKEN('TABLE_NAME','C3');

2378: IF ipa_cur%NOTFOUND THEN
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:

Line 2423: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_EFCC_SETUP');

2419: OPEN efcC_cur;
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;

Line 2472: WHEN OTHERS THEN FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

2468:
2469: EXCEPTION
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:

Line 2473: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.C_ALLOW_AG_S_INC');

2469: EXCEPTION
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;

Line 2586: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_GEN_TAX_SETUP');

2582: OPEN business_networth_cur(l_business_networth);
2583: FETCH business_networth_cur INTO business_networth_rec;
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;

Line 2587: FND_MESSAGE.SET_TOKEN('TABLE_NAME','C4');

2583: FETCH business_networth_cur INTO business_networth_rec;
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;

Line 2615: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_DOB_SPECIFIED');

2611: IF igf_ap_efc_calc.isir_rec.date_of_birth IS NOT NULL THEN
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:

Line 2631: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_ASSET_SETUP');

2627: OPEN asset_cur(l_age_student);
2628: FETCH asset_cur INTO asset_rec;
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;

Line 2632: FND_MESSAGE.SET_TOKEN('TABLE_NAME','C5');

2628: FETCH asset_cur INTO asset_rec;
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;

Line 2659: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_EFCC_SETUP');

2655: OPEN efcC_cur;
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;

Line 2681: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

2677: EXCEPTION
2678: WHEN exception_in_setup THEN
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:

Line 2682: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.C_S_CONT_ASSETS');

2678: WHEN exception_in_setup THEN
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;

Line 2733: FND_MESSAGE.SET_NAME('IGF','IGF_AP_NO_GEN_TAX_SETUP');

2729: OPEN cont_aai_cur(l_aai);
2730: FETCH cont_aai_cur INTO cont_aai_rec;
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;

Line 2734: FND_MESSAGE.SET_TOKEN('TABLE_NAME','C6');

2730: FETCH cont_aai_cur INTO cont_aai_rec;
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;

Line 2776: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

2772: EXCEPTION
2773: WHEN exception_in_setup THEN
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:

Line 2777: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.C_EFC');

2773: WHEN exception_in_setup THEN
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;

Line 2843: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

2839: RETURN (l_date);
2840:
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:

Line 2844: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.EFC_CUTOFF_DATE');

2840:
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;

Line 2879: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');

2875: END IF;
2876:
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:

Line 2880: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_EFC_SUBF.GET_PAR_STUD_CONT');

2876:
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 ;