DBA Data[Home] [Help]

APPS.IGF_AP_ASSUMPTION_REJECT_EDITS dependencies on FND_MESSAGE

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

1664: a_stud_total_wsc ;
1665:
1666: EXCEPTION
1667: WHEN OTHERS THEN
1668: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1669: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_ASSUMPTION_REJECT_EDITS.ASSUME_VALUES' );
1670: IGS_GE_MSG_STACK.ADD;
1671: APP_EXCEPTION.RAISE_EXCEPTION;
1672: END assume_values ;

Line 1669: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_ASSUMPTION_REJECT_EDITS.ASSUME_VALUES' );

1665:
1666: EXCEPTION
1667: WHEN OTHERS THEN
1668: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
1669: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_ASSUMPTION_REJECT_EDITS.ASSUME_VALUES' );
1670: IGS_GE_MSG_STACK.ADD;
1671: APP_EXCEPTION.RAISE_EXCEPTION;
1672: END assume_values ;
1673:

Line 1710: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4001');

1706: AND p_isir_rec.p_income_wsa IS NULL AND p_isir_rec.p_income_wsb IS NULL
1707: ) THEN
1708: -- append reject code ; stack reject message ;
1709: p_reject_codes := p_reject_codes || '02' ;
1710: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4001');
1711: IGS_GE_MSG_STACK.ADD;
1712: END IF ;
1713: END reject_edit_4001 ;
1714:

Line 1739: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4002');

1735: AND p_isir_rec.s_toa_amt_from_wsa IS NULL AND p_isir_rec.s_toa_amt_from_wsb IS NULL
1736: ) THEN
1737: -- append reject code ; stack reject message ;
1738: p_reject_codes := p_reject_codes || '02' ;
1739: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4002');
1740: IGS_GE_MSG_STACK.ADD;
1741: END IF ;
1742: END reject_edit_4002 ;
1743:

Line 1770: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4003');

1766: AND p_isir_rec.s_cash_savings IS NULL
1767: ) THEN
1768: -- append reject code ; stack reject message ;
1769: p_reject_codes := p_reject_codes || '01' ;
1770: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4003');
1771: IGS_GE_MSG_STACK.ADD;
1772: END IF ;
1773: END reject_edit_4003 ;
1774:

Line 1799: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4004');

1795: AND p_isir_rec.s_busi_farm_networth IS NULL AND p_isir_rec.s_cash_savings IS NULL
1796: ) THEN
1797: -- append reject code ;stack reject message ;
1798: p_reject_codes := p_reject_codes || '01' ;
1799: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4004');
1800: IGS_GE_MSG_STACK.ADD;
1801: END IF ;
1802: END reject_edit_4004 ;
1803:

Line 1823: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4005');

1819: OR NVL ( p_isir_rec.a_citizenship , p_isir_rec.citizenship_status ) = '3'
1820: ) THEN
1821: -- append reject code ;stack reject message ;
1822: p_reject_codes := p_reject_codes || '17' ;
1823: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4005');
1824: IGS_GE_MSG_STACK.ADD;
1825: END IF ;
1826: END reject_edit_4005 ;
1827:

Line 1848: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4006');

1844: AND p_isir_rec.last_name IS NULL
1845: ) THEN
1846: -- append reject code ;stack reject message ;
1847: p_reject_codes := p_reject_codes || '13' ;
1848: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4006');
1849: IGS_GE_MSG_STACK.ADD;
1850: END IF ;
1851: END reject_edit_4006 ;
1852:

Line 1880: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4007');

1876: */
1877: IF ( p_isir_rec.first_name IS NULL OR p_isir_rec.last_name IS NULL ) THEN
1878: -- append reject code ; stack reject message ;
1879: p_reject_codes := p_reject_codes || 'N ' ;
1880: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4007');
1881: IGS_GE_MSG_STACK.ADD;
1882: -- END IF ;
1883: END IF ;
1884: END reject_edit_4007_4008 ;

Line 1906: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4013');

1902:
1903: IF p_isir_rec.date_of_birth IS NULL THEN
1904: -- append reject code ;stack reject message
1905: p_reject_codes := p_reject_codes || '05' ;
1906: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4013');
1907: IGS_GE_MSG_STACK.ADD;
1908: END IF ;
1909: END reject_edit_4015_4013 ;
1910:

Line 1952: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4014');

1948: AND NVL ( p_isir_rec.ssn_match_flag, '3' ) <> '4'
1949: ) THEN
1950: -- append reject code ; stack reject message ;
1951: p_reject_codes := p_reject_codes || 'A ' ;
1952: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4014');
1953: FND_MESSAGE.SET_TOKEN ('MAX_YR', TO_CHAR ((max_date - 1), 'YYYY'));
1954: IGS_GE_MSG_STACK.ADD;
1955: END IF ;
1956: END reject_edit_4016_4014_4015 ;

Line 1953: FND_MESSAGE.SET_TOKEN ('MAX_YR', TO_CHAR ((max_date - 1), 'YYYY'));

1949: ) THEN
1950: -- append reject code ; stack reject message ;
1951: p_reject_codes := p_reject_codes || 'A ' ;
1952: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4014');
1953: FND_MESSAGE.SET_TOKEN ('MAX_YR', TO_CHAR ((max_date - 1), 'YYYY'));
1954: IGS_GE_MSG_STACK.ADD;
1955: END IF ;
1956: END reject_edit_4016_4014_4015 ;
1957:

Line 1999: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4016');

1995: AND NVL( p_isir_rec.ssn_match_flag,'3') <> '4'
1996: ) THEN
1997: --append reject code ; stack reject message ;
1998: p_reject_codes := p_reject_codes || 'B ' ;
1999: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4016');
2000: IGS_GE_MSG_STACK.ADD;
2001: END IF ;
2002:
2003: END reject_edit_4018_4016_4017 ;

Line 2029: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4018');

2025: AND NVL ( p_isir_rec.a_p_us_tax_paid , p_isir_rec.p_taxes_paid ) >= NVL ( p_isir_rec.a_parents_agi , p_isir_rec.p_adjusted_gross_income )
2026: ) THEN
2027: -- append reject code ;stack reject message ;
2028: p_reject_codes := p_reject_codes || '12' ;
2029: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4018');
2030: IGS_GE_MSG_STACK.ADD;
2031: END IF ;
2032: END reject_edit_4020_4018 ;
2033:

Line 2058: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4019');

2054: AND NVL ( p_isir_rec.a_s_us_tax_paid , p_isir_rec.s_fed_taxes_paid ) >= NVL ( p_isir_rec.a_student_agi , p_isir_rec.s_adjusted_gross_income )
2055: ) THEN
2056: -- append reject code ;stack reject message ;
2057: p_reject_codes := p_reject_codes || '12' ;
2058: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4019');
2059: IGS_GE_MSG_STACK.ADD;
2060: END IF ;
2061: END reject_edit_4019 ;
2062:

Line 2088: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4021');

2084: NVL ( p_isir_rec.a_student_agi , p_isir_rec.s_adjusted_gross_income )
2085: ) THEN
2086: -- append reject code ;stack reject message ;
2087: p_reject_codes := p_reject_codes || '03' ;
2088: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4021');
2089: IGS_GE_MSG_STACK.ADD;
2090: END IF ;
2091: END reject_edit_4021 ;
2092:

Line 2114: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4045');

2110: AND p_isir_rec.mother_ssn_match_type <> '4')
2111: THEN
2112:
2113: p_reject_codes := p_reject_codes || 'E' ;
2114: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4045');
2115: IGS_GE_MSG_STACK.ADD;
2116: END IF ;
2117:
2118: --edit 4047

Line 2125: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4047');

2121: AND p_isir_rec.father_ssn_match_type <> '4')
2122: THEN
2123:
2124: p_reject_codes := p_reject_codes || 'F' ;
2125: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4047');
2126: IGS_GE_MSG_STACK.ADD;
2127: END IF ;
2128: END reject_edit_4045_4047 ;
2129:

Line 2157: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4049');

2153: AND NVL ( p_isir_rec.P_TYPE_TAX_RETURN,'0') <> '3' )
2154: THEN
2155:
2156: p_reject_codes := p_reject_codes || 'J' ;
2157: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4049');
2158: IGS_GE_MSG_STACK.ADD;
2159: END IF ;
2160: END reject_edit_4049 ;
2161:

Line 2188: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4051');

2184: AND NVL ( p_isir_rec.P_TYPE_TAX_RETURN,'0') <> '3' )
2185: THEN
2186:
2187: p_reject_codes := p_reject_codes || 'K' ;
2188: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4051');
2189: IGS_GE_MSG_STACK.ADD;
2190: END IF ;
2191: END reject_edit_4051 ;
2192:

Line 2232: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4020');

2228: IF NOT ( NVL ( corr_rec.a_p_us_tax_paid , corr_rec.p_taxes_paid ) <> NVL ( p_isir_rec.a_p_us_tax_paid , p_isir_rec.p_taxes_paid ) ) THEN
2229: */
2230: -- append reject code ; stack reject message ;
2231: p_reject_codes := p_reject_codes || 'C ' ;
2232: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4020');
2233: IGS_GE_MSG_STACK.ADD;
2234: -- END IF ;
2235: END IF ;
2236: END reject_edit_4022_4020_4021 ;

Line 2278: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4022');

2274: IF NOT ( NVL( corr_rec.a_s_us_tax_paid , corr_rec.s_fed_taxes_paid ) <> NVL ( p_isir_rec.a_s_us_tax_paid , p_isir_rec.s_fed_taxes_paid ) ) THEN
2275: */
2276: -- append reject code ; stack reject message ;
2277: p_reject_codes := p_reject_codes || 'C ' ;
2278: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4022');
2279: IGS_GE_MSG_STACK.ADD;
2280: -- END IF ;
2281: END IF ;
2282: END reject_edit_4024_4022_4023 ;

Line 2311: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4024');

2307: OR NVL ( p_isir_rec.a_parents_num_family , p_isir_rec.p_num_family_member ) = 1 )
2308: ) THEN
2309: -- append reject code ;stack reject message ;
2310: p_reject_codes := p_reject_codes || '10' ;
2311: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4024');
2312: IGS_GE_MSG_STACK.ADD;
2313: END IF ;
2314: END reject_edit_4028_4024 ;
2315:

Line 2343: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4025');

2339: OR NVL ( p_isir_rec.a_s_num_in_family , p_isir_rec.s_num_family_members ) = 1 )
2340: ) THEN
2341: -- append reject code ;stack reject message
2342: p_reject_codes := p_reject_codes || '10' ;
2343: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4025');
2344: IGS_GE_MSG_STACK.ADD;
2345: END IF ;
2346: END reject_edit_4029_4025 ;
2347:

Line 2371: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4024_25_NEW');

2367: (NVL (p_isir_rec.a_s_us_tax_paid, p_isir_rec.s_fed_taxes_paid) >= 0.4* NVL (p_isir_rec.a_student_agi, p_isir_rec.s_adjusted_gross_income)) AND
2368: (NVL(p_isir_rec.faa_adjustment, '2' ) <> '1'))
2369: THEN
2370: p_reject_codes := p_reject_codes || 'G' ;
2371: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4024_25_NEW');
2372: IGS_GE_MSG_STACK.ADD;
2373: END IF ;
2374: END reject_edit_4026_4024_4025_new ;
2375:

Line 2413: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4026');

2409: IF NOT ( NVL ( corr_rec.a_parents_num_family , corr_rec.p_num_family_member ) <> NVL ( p_isir_rec.a_parents_num_family , p_isir_rec.p_num_family_member ) ) THEN
2410: */
2411: -- append reject code ; stack reject message ;
2412: p_reject_codes := p_reject_codes || 'W ' ;
2413: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4026');
2414: IGS_GE_MSG_STACK.ADD;
2415: -- END IF ;
2416: END IF ;
2417: END reject_edit_4030_4026_4027 ;

Line 2457: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4028');

2453: IF NOT ( NVL (corr_rec.a_s_num_in_family ,corr_rec.s_num_family_members ) <> NVL ( p_isir_rec.a_s_num_in_family , p_isir_rec.s_num_family_members ) ) THEN
2454: */
2455: -- append reject code ; stack reject message ;
2456: p_reject_codes := p_reject_codes || 'W ' ;
2457: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4028');
2458: IGS_GE_MSG_STACK.ADD;
2459: -- END IF ;
2460: END IF ;
2461: END reject_edit_4032_4028_4029 ;

Line 2495: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4030');

2491: AND NVL( p_isir_rec.faa_adjustment,'2') <> '1'
2492: ) THEN
2493: -- append reject code ;stack reject message
2494: p_reject_codes := p_reject_codes || '11' ;
2495: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4030');
2496: IGS_GE_MSG_STACK.ADD;
2497: END IF ;
2498: END reject_edit_4034_4030 ;
2499:

Line 2528: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4031');

2524: AND NVL ( p_isir_rec.faa_adjustment,'2') <> '1'
2525: ) THEN
2526: -- append reject code ;stack reject message ;
2527: p_reject_codes := p_reject_codes || '11' ;
2528: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4031');
2529: IGS_GE_MSG_STACK.ADD;
2530: END IF ;
2531: END reject_edit_4035_4031 ;
2532:

Line 2554: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4032');

2550: AND (p_isir_rec.signed_by IS NULL OR p_isir_rec.signed_by = 'A' )
2551: ) THEN
2552: -- append reject code ;stack reject message ;
2553: p_reject_codes := p_reject_codes || '15' ;
2554: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4032');
2555: IGS_GE_MSG_STACK.ADD;
2556: END IF ;
2557: END reject_edit_4036_4032 ;
2558:

Line 2580: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4033');

2576: AND (p_isir_rec.signed_by IS NULL OR p_isir_rec.signed_by = 'P' )
2577: ) THEN
2578: -- append reject code ;stack reject message ;
2579: p_reject_codes := p_reject_codes || '14' ;
2580: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4033');
2581: IGS_GE_MSG_STACK.ADD;
2582: END IF ;
2583: END reject_edit_4037_4033 ;
2584:

Line 2609: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4034');

2605: p_isir_rec.mother_ssn IS NULL )
2606: THEN
2607: -- append reject code ;stack reject message ;
2608: p_reject_codes := p_reject_codes || '09' ;
2609: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4034');
2610: IGS_GE_MSG_STACK.ADD;
2611: END IF ;
2612: ELSIF p_sys_batch_yr = '0405' THEN
2613: IF (p_isir_rec.dependency_status = 'D' AND

Line 2618: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4034_NEW');

2614: (p_isir_rec.father_ssn IS NULL OR p_isir_rec.f_last_name IS NULL OR p_isir_rec. FATHER_STEP_FATHER_BIRTH_DATE IS NULL) AND
2615: (p_isir_rec.mother_ssn IS NULL OR p_isir_rec.m_last_name IS NULL OR p_isir_rec. MOTHER_STEP_MOTHER_BIRTH_DATE IS NULL))
2616: THEN
2617: p_reject_codes := p_reject_codes || '09' ;
2618: FND_MESSAGE.SET_NAME('IGF','IGF_AP_REJECT_EDIT_4034_NEW');
2619: IGS_GE_MSG_STACK.ADD;
2620: END IF ;
2621: END IF;
2622: END reject_edit_4038_4034 ;

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

2690:
2691:
2692: EXCEPTION
2693: WHEN OTHERS THEN
2694: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2695: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_ASSUMPTION_REJECT_EDITS.REJECT_EDITS' );
2696: IGS_GE_MSG_STACK.ADD;
2697: APP_EXCEPTION.RAISE_EXCEPTION;
2698:

Line 2695: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_ASSUMPTION_REJECT_EDITS.REJECT_EDITS' );

2691:
2692: EXCEPTION
2693: WHEN OTHERS THEN
2694: FND_MESSAGE.SET_NAME('IGS','IGS_GE_UNHANDLED_EXP');
2695: FND_MESSAGE.SET_TOKEN('NAME','IGF_AP_ASSUMPTION_REJECT_EDITS.REJECT_EDITS' );
2696: IGS_GE_MSG_STACK.ADD;
2697: APP_EXCEPTION.RAISE_EXCEPTION;
2698:
2699: END reject_edits ;