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_SL_CL_LI_IMP_PKG dependencies on IGF_AP_GEN

Line 46: -- veramach 11-Dec-2003 Bug # 3184891 Removed calls to igf_ap_gen.write_log

42: -- sjadhav 18-Feb-2004 Bug 3451140
43: -- Check for Non ED Branch ID setup only iff it is not
44: -- '0000'
45: ----------------------------------------------------------------------------------
46: -- veramach 11-Dec-2003 Bug # 3184891 Removed calls to igf_ap_gen.write_log
47: -- and added common logging
48: ----------------------------------------------------------------------------------
49: -- bkkumar 04-DEC-2003 Bug 3252382 FA 131 . TBH impact for the igf_aw_awd_disb_all
50: -- Added two columns ATTENDANCE_TYPE_CODE,BASE_ATTENDANCE_TYPE_CODE

Line 1650: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.b_stu_indicator_flag) IS NULL THEN

1646: p_status := FALSE;
1647: END IF;
1648:
1649: IF p_fed_fund_cd = 'ALT' AND p_interface.b_stu_indicator_flag IS NOT NULL THEN
1650: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.b_stu_indicator_flag) IS NULL THEN
1651: g_tab_index := g_tab_index + 1;
1652: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
1653: fnd_message.set_token('FIELD','B_STU_INDICATOR_FLAG');
1654: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 1678: igf_ap_gen.check_person(p_interface.borr_person_number,NULL,NULL,lv_person_id,lv_base_id);

1674: fnd_message.set_name('IGF','IGF_SL_CL_STU_BOR_DIFFER');
1675: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
1676: p_status := FALSE;
1677: ELSE
1678: igf_ap_gen.check_person(p_interface.borr_person_number,NULL,NULL,lv_person_id,lv_base_id);
1679: IF lv_person_id IS NULL THEN
1680: fnd_message.set_name('IGF','IGF_SL_LI_INVALID_BORR');
1681: fnd_message.set_token('PERS_NUM', p_interface.borr_person_number);
1682: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);

Line 1696: igf_ap_gen.check_person(p_interface.borr_person_number,NULL,NULL,lv_person_id,lv_base_id);

1692: AND p_interface.borr_person_number IS NOT NULL
1693: AND NVL(p_interface.b_stu_indicator_flag,'X') <> 'Y'
1694: THEN
1695:
1696: igf_ap_gen.check_person(p_interface.borr_person_number,NULL,NULL,lv_person_id,lv_base_id);
1697:
1698: IF lv_person_id IS NULL THEN
1699: fnd_message.set_name('IGF','IGF_SL_LI_INVALID_BORR');
1700: fnd_message.set_token('PERS_NUM', p_interface.borr_person_number);

Line 1740: OR (igf_ap_gen.get_aw_lookup_meaning('IGF_SL_LOAN_STATUS',p_interface.loan_status_code,g_sys_award_year)) IS NULL THEN

1736: p_status := FALSE;
1737: END IF;
1738:
1739: IF (p_interface.loan_status_code IN ('B','C','R','S','T'))
1740: OR (igf_ap_gen.get_aw_lookup_meaning('IGF_SL_LOAN_STATUS',p_interface.loan_status_code,g_sys_award_year)) IS NULL THEN
1741: g_tab_index := g_tab_index + 1;
1742: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
1743: fnd_message.set_token('FIELD','LOAN_STATUS_CODE');
1744: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 1748: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.active_flag) IS NULL THEN

1744: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;
1745: p_status := FALSE;
1746: END IF;
1747:
1748: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.active_flag) IS NULL THEN
1749: g_tab_index := g_tab_index + 1;
1750: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
1751: fnd_message.set_token('FIELD','ACTIVE_FLAG');
1752: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 1757: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.defer_req_flag) IS NULL THEN

1753: p_status := FALSE;
1754: END IF;
1755:
1756: IF p_interface.defer_req_flag IS NOT NULL THEN
1757: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.defer_req_flag) IS NULL THEN
1758: g_tab_index := g_tab_index + 1;
1759: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
1760: fnd_message.set_token('FIELD','DEFER_REQ_FLAG');
1761: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 1767: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_REC_TYPE_IND',p_interface.record_code,g_sys_award_year) IS NULL THEN

1763: END IF;
1764:
1765: END IF;
1766:
1767: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_REC_TYPE_IND',p_interface.record_code,g_sys_award_year) IS NULL THEN
1768: g_tab_index := g_tab_index + 1;
1769: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
1770: fnd_message.set_token('FIELD','RECORD_CODE');
1771: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 1794: IF (igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.borw_interest_flag) IS NULL) THEN

1790: END IF;
1791: END IF;
1792:
1793: IF (p_interface.borw_interest_flag IS NOT NULL) THEN
1794: IF (igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.borw_interest_flag) IS NULL) THEN
1795: g_tab_index := g_tab_index + 1;
1796: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
1797: fnd_message.set_token('FIELD','BORW_INTEREST_FLAG');
1798: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 1804: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.b_signature_flag) IS NULL THEN

1800: END IF;
1801: END IF;
1802:
1803: IF p_interface.b_signature_flag IS NOT NULL THEN
1804: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.b_signature_flag) IS NULL THEN
1805: g_tab_index := g_tab_index + 1;
1806: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
1807: fnd_message.set_token('FIELD','B_SIGNATURE_FLAG');
1808: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 1820: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.b_default_status_flag) IS NULL THEN

1816: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11) || fnd_message.get;
1817: p_status := FALSE;
1818:
1819: ELSIF (p_fed_fund_cd IN ('FLP','ALT','GPLUSFL')) AND (p_interface.b_default_status_flag IS NOT NULL) THEN
1820: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.b_default_status_flag) IS NULL THEN
1821: g_tab_index := g_tab_index + 1;
1822: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
1823: fnd_message.set_token('FIELD','B_DEFAULT_STATUS_FLAG');
1824: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 1836: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.borw_outstd_loan_flag) IS NULL THEN

1832: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11) || fnd_message.get;
1833: p_status := FALSE;
1834:
1835: ELSIF (p_fed_fund_cd IN ('FLP','ALT','GPLUSFL')) AND (p_interface.borw_outstd_loan_flag IS NOT NULL) THEN
1836: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.borw_outstd_loan_flag) IS NULL THEN
1837: g_tab_index := g_tab_index + 1;
1838: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
1839: fnd_message.set_token('FIELD','BORW_OUTSTD_LOAN_FLAG');
1840: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 1852: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.s_default_status_flag) IS NULL THEN

1848: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11) || fnd_message.get;
1849: p_status := FALSE;
1850:
1851: ELSIF (p_fed_fund_cd IN ('FLP','ALT','GPLUSFL')) AND (p_interface.s_default_status_flag IS NOT NULL) THEN
1852: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.s_default_status_flag) IS NULL THEN
1853: g_tab_index := g_tab_index + 1;
1854: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
1855: fnd_message.set_token('FIELD','S_DEFAULT_STATUS_FLAG');
1856: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 1868: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.s_signature_flag) IS NULL THEN

1864: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11) || fnd_message.get;
1865: p_status := FALSE;
1866:
1867: ELSIF (p_fed_fund_cd IN ('FLP','ALT','GPLUSFL')) AND (p_interface.s_signature_flag IS NOT NULL) THEN
1868: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.s_signature_flag) IS NULL THEN
1869: g_tab_index := g_tab_index + 1;
1870: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
1871: fnd_message.set_token('FIELD','S_SIGNATURE_FLAG');
1872: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 1882: ELSIF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_GRADE_LEVEL',p_interface.grade_level_code,g_sys_award_year) IS NULL THEN

1878: fnd_message.set_name('IGF','IGF_SL_CL_GRADE_LVL_REQD');
1879: g_tab_index := g_tab_index + 1;
1880: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11) || fnd_message.get;
1881: p_status := FALSE;
1882: ELSIF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_GRADE_LEVEL',p_interface.grade_level_code,g_sys_award_year) IS NULL THEN
1883: g_tab_index := g_tab_index + 1;
1884: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
1885: fnd_message.set_token('FIELD','GRADE_LEVEL_CODE');
1886: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 1905: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.borr_sign_flag) IS NULL THEN

1901: END IF;
1902: END IF;
1903:
1904: IF p_interface.borr_sign_flag IS NOT NULL THEN
1905: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.borr_sign_flag) IS NULL THEN
1906: g_tab_index := g_tab_index + 1;
1907: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
1908: fnd_message.set_token('FIELD','BORR_SIGN_FLAG');
1909: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 1915: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.eft_auth_flag) IS NULL THEN

1911: END IF;
1912: END IF;
1913:
1914: IF p_interface.eft_auth_flag IS NOT NULL THEN
1915: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.eft_auth_flag) IS NULL THEN
1916: g_tab_index := g_tab_index + 1;
1917: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
1918: fnd_message.set_token('FIELD','EFT_AUTH_FLAG');
1919: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 1939: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_ENROL_STATUS',p_interface.enrollment_code,g_sys_award_year) IS NULL THEN

1935: p_status := FALSE;
1936:
1937: ELSIF p_interface.enrollment_code IS NOT NULL THEN
1938:
1939: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_ENROL_STATUS',p_interface.enrollment_code,g_sys_award_year) IS NULL THEN
1940: g_tab_index := g_tab_index + 1;
1941: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
1942: fnd_message.set_token('FIELD','ENROLLMENT_CODE');
1943: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 1972: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_SERIAL_LOAN_CODE',p_interface.req_serial_loan_code,g_sys_award_year) IS NULL THEN

1968: p_status := FALSE;
1969: END IF;
1970:
1971: IF p_interface.req_serial_loan_code IS NOT NULL THEN
1972: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_SERIAL_LOAN_CODE',p_interface.req_serial_loan_code,g_sys_award_year) IS NULL THEN
1973: g_tab_index := g_tab_index + 1;
1974: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
1975: fnd_message.set_token('FIELD','REQ_SERIAL_LOAN_CODE');
1976: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 1982: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.borr_credit_auth_flag) IS NULL THEN

1978: END IF;
1979: END IF;
1980:
1981: IF p_interface.borr_credit_auth_flag IS NOT NULL THEN
1982: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.borr_credit_auth_flag) IS NULL THEN
1983: g_tab_index := g_tab_index + 1;
1984: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
1985: fnd_message.set_token('FIELD','BORR_CREDIT_AUTH_FLAG');
1986: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 2000: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.stud_sign_flag) IS NULL THEN

1996: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11) || fnd_message.get;
1997: p_status := FALSE;
1998:
1999: ELSIF (p_fed_fund_cd IN ('FLP','ALT','GPLUSFL')) AND (p_interface.stud_sign_flag IS NOT NULL) THEN
2000: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.stud_sign_flag) IS NULL THEN
2001: g_tab_index := g_tab_index + 1;
2002: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
2003: fnd_message.set_token('FIELD','STUD_SIGN_FLAG');
2004: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 2017: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_PRC_TYPE_CODE',p_interface.prc_type_code,g_sys_award_year) IS NULL THEN

2013: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11) || fnd_message.get;
2014: p_status := FALSE;
2015:
2016: ELSIF p_interface.prc_type_code NOT IN ('GP', 'GO') THEN
2017: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_PRC_TYPE_CODE',p_interface.prc_type_code,g_sys_award_year) IS NULL THEN
2018: g_tab_index := g_tab_index + 1;
2019: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
2020: fnd_message.set_token('FIELD','PRC_TYPE_CODE');
2021: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 2044: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_SERV_CD',p_interface.service_type_code,g_sys_award_year) IS NULL THEN

2040:
2041:
2042:
2043: IF p_interface.service_type_code IS NOT NULL THEN
2044: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_SERV_CD',p_interface.service_type_code,g_sys_award_year) IS NULL THEN
2045: g_tab_index := g_tab_index + 1;
2046: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
2047: fnd_message.set_token('FIELD','SERVICE_TYPE_CODE');
2048: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 2054: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_REV_GUARNT_CD',p_interface.rev_notice_of_guarnt_code,g_sys_award_year) IS NULL THEN

2050: END IF;
2051: END IF;
2052:
2053: IF p_interface.rev_notice_of_guarnt_code IS NOT NULL THEN
2054: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_REV_GUARNT_CD',p_interface.rev_notice_of_guarnt_code,g_sys_award_year) IS NULL THEN
2055: g_tab_index := g_tab_index + 1;
2056: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
2057: fnd_message.set_token('FIELD','REV_NOTICE_OF_GUARNT_CODE');
2058: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 2064: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_PNOTE_DELIVERY',p_interface.pnote_delivery_code,g_sys_award_year) IS NULL THEN

2060: END IF;
2061: END IF;
2062:
2063: IF p_interface.pnote_delivery_code IS NOT NULL THEN
2064: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_PNOTE_DELIVERY',p_interface.pnote_delivery_code,g_sys_award_year) IS NULL THEN
2065: g_tab_index := g_tab_index + 1;
2066: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
2067: fnd_message.set_token('FIELD','PNOTE_DELIVERY_CODE');
2068: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 2079: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.guarnt_adj_flag) IS NULL THEN

2075: g_tab_index := g_tab_index + 1;
2076: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11) || fnd_message.get;
2077: p_status := FALSE;
2078: ELSIF p_interface.guarnt_adj_flag IS NOT NULL THEN
2079: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.guarnt_adj_flag) IS NULL THEN
2080: g_tab_index := g_tab_index + 1;
2081: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
2082: fnd_message.set_token('FIELD','GUARNT_ADJ_FLAG');
2083: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11) || fnd_message.get;

Line 2113: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_BORW_CONFIRM',p_interface.borw_confirm_flag,g_sys_award_year) IS NULL THEN

2109: p_status := FALSE;
2110: END IF;
2111:
2112: IF p_interface.borw_confirm_flag IS NOT NULL THEN
2113: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_BORW_CONFIRM',p_interface.borw_confirm_flag,g_sys_award_year) IS NULL THEN
2114: g_tab_index := g_tab_index + 1;
2115: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
2116: fnd_message.set_token('FIELD','BORW_CONFIRM_FLAG');
2117: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 2123: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.last_resort_lender_flag) IS NULL THEN

2119: END IF;
2120: END IF;
2121:
2122: IF p_interface.last_resort_lender_flag IS NOT NULL THEN
2123: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.last_resort_lender_flag) IS NULL THEN
2124: g_tab_index := g_tab_index + 1;
2125: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
2126: fnd_message.set_token('FIELD','LAST_RESORT_LENDER_FLAG');
2127: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 2133: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.resp_to_orig_flag) IS NULL THEN

2129: END IF;
2130: END IF;
2131:
2132: IF p_interface.resp_to_orig_flag IS NOT NULL THEN
2133: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.resp_to_orig_flag) IS NULL THEN
2134: g_tab_index := g_tab_index + 1;
2135: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
2136: fnd_message.set_token('FIELD','RESP_TO_ORIG_FLAG');
2137: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 2148: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_GUARNT_AMT_RED_CODE',p_interface.guarnt_amt_redn_code,g_sys_award_year) IS NULL THEN

2144: g_tab_index := g_tab_index + 1;
2145: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11) || fnd_message.get;
2146: p_status := FALSE;
2147: ELSIF p_interface.guarnt_amt_redn_code IS NOT NULL THEN
2148: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_GUARNT_AMT_RED_CODE',p_interface.guarnt_amt_redn_code,g_sys_award_year) IS NULL THEN
2149: g_tab_index := g_tab_index + 1;
2150: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
2151: fnd_message.set_token('FIELD','GUARNT_AMT_REDN_CODE');
2152: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 2170: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_GUARNT_STATUS',p_interface.guarnt_status_code,g_sys_award_year) IS NULL THEN

2166: g_tab_index := g_tab_index + 1;
2167: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11) || fnd_message.get;
2168: p_status := FALSE;
2169: ELSIF p_interface.guarnt_status_code IS NOT NULL THEN
2170: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_GUARNT_STATUS',p_interface.guarnt_status_code,g_sys_award_year) IS NULL THEN
2171: g_tab_index := g_tab_index + 1;
2172: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
2173: fnd_message.set_token('FIELD','GUARNT_STATUS_CODE');
2174: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 2213: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_LEND_STATUS',p_interface.lend_status_code,g_sys_award_year) IS NULL THEN

2209: g_tab_index := g_tab_index + 1;
2210: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11) || fnd_message.get;
2211: p_status := FALSE;
2212: ELSIF p_interface.lend_status_code IS NOT NULL THEN
2213: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_LEND_STATUS',p_interface.lend_status_code,g_sys_award_year) IS NULL THEN
2214: g_tab_index := g_tab_index + 1;
2215: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
2216: fnd_message.set_token('FIELD','LEND_STATUS_CODE');
2217: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 2257: OR (igf_ap_gen.get_aw_lookup_meaning('IGF_SL_PNOTE_STATUS',p_interface.pnote_status_code,g_sys_award_year) IS NULL) THEN

2253: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11) || fnd_message.get;
2254: p_status := FALSE;
2255: ELSIF p_interface.pnote_status_code IS NOT NULL THEN
2256: IF p_interface.pnote_status_code IN ('A','C','F','G','I','M','N','P','Q','R','S','X')
2257: OR (igf_ap_gen.get_aw_lookup_meaning('IGF_SL_PNOTE_STATUS',p_interface.pnote_status_code,g_sys_award_year) IS NULL) THEN
2258:
2259: g_tab_index := g_tab_index + 1;
2260: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
2261: fnd_message.set_token('FIELD','PNOTE_STATUS_CODE');

Line 2305: OR (igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CREDIT_OVERRIDE',p_interface.credit_status_code,g_sys_award_year) IS NULL) THEN

2301: p_status := FALSE;
2302:
2303: ELSIF p_interface.credit_status_code IS NOT NULL THEN
2304: IF p_interface.credit_status_code IN ('C','D','E','N')
2305: OR (igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CREDIT_OVERRIDE',p_interface.credit_status_code,g_sys_award_year) IS NULL) THEN
2306: g_tab_index := g_tab_index + 1;
2307: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
2308: fnd_message.set_token('FIELD','CREDIT_STATUS_CODE');
2309: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 2336: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.crdt_undr_difft_name_flag) IS NULL THEN

2332: END IF;
2333: END IF;
2334:
2335: IF p_fed_fund_cd = 'ALT' AND p_interface.crdt_undr_difft_name_flag IS NOT NULL THEN
2336: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.crdt_undr_difft_name_flag) IS NULL THEN
2337: g_tab_index := g_tab_index + 1;
2338: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
2339: fnd_message.set_token('FIELD','CRDT_UNDR_DIFFT_NAME_FLAG');
2340: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 2353: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_SERIAL_LOAN_CODE',p_interface.act_serial_loan_code,g_sys_award_year) IS NULL THEN

2349:
2350: -- FA 134:ACT_SERIAL_LOAN_CODE is a Release -5 field only
2351: IF g_rel_version = 'RELEASE-5' THEN
2352: IF p_interface.act_serial_loan_code IS NOT NULL THEN
2353: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_SERIAL_LOAN_CODE',p_interface.act_serial_loan_code,g_sys_award_year) IS NULL THEN
2354: g_tab_index := g_tab_index + 1;
2355: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
2356: fnd_message.set_token('FIELD','ACT_SERIAL_LOAN_CODE');
2357: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 2364: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_ALT_INT_RATE_OPTION',p_interface.int_rate_opt_code,g_sys_award_year) IS NULL THEN

2360: END IF;
2361: END IF;
2362:
2363: IF p_interface.int_rate_opt_code IS NOT NULL THEN
2364: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_ALT_INT_RATE_OPTION',p_interface.int_rate_opt_code,g_sys_award_year) IS NULL THEN
2365: g_tab_index := g_tab_index + 1;
2366: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
2367: fnd_message.set_token('FIELD','INT_RATE_OPT_CODE');
2368: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 2374: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_ALT_REPAY_OPTION',p_interface.repayment_opt_code,g_sys_award_year) IS NULL THEN

2370: END IF;
2371: END IF;
2372:
2373: IF p_interface.repayment_opt_code IS NOT NULL THEN
2374: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_ALT_REPAY_OPTION',p_interface.repayment_opt_code,g_sys_award_year) IS NULL THEN
2375: g_tab_index := g_tab_index + 1;
2376: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
2377: fnd_message.set_token('FIELD','REPAYMENT_OPT_CODE');
2378: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 2749: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_ERROR',p_interface.err_mesg_1_cd,g_sys_award_year) IS NULL THEN

2745: END IF;
2746: END IF;
2747:
2748: IF p_interface.err_mesg_1_cd IS NOT NULL THEN
2749: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_ERROR',p_interface.err_mesg_1_cd,g_sys_award_year) IS NULL THEN
2750: g_tab_index := g_tab_index + 1;
2751: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
2752: fnd_message.set_token('FIELD','ERR_MESG_1_CD');
2753: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 2759: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_ERROR',p_interface.err_mesg_2_cd,g_sys_award_year) IS NULL THEN

2755: END IF;
2756: END IF;
2757:
2758: IF p_interface.err_mesg_2_cd IS NOT NULL THEN
2759: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_ERROR',p_interface.err_mesg_2_cd,g_sys_award_year) IS NULL THEN
2760: g_tab_index := g_tab_index + 1;
2761: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
2762: fnd_message.set_token('FIELD','ERR_MESG_2_CD');
2763: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 2769: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_ERROR',p_interface.err_mesg_3_cd,g_sys_award_year) IS NULL THEN

2765: END IF;
2766: END IF;
2767:
2768: IF p_interface.err_mesg_3_cd IS NOT NULL THEN
2769: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_ERROR',p_interface.err_mesg_3_cd,g_sys_award_year) IS NULL THEN
2770: g_tab_index := g_tab_index + 1;
2771: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
2772: fnd_message.set_token('FIELD','ERR_MESG_3_CD');
2773: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 2779: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_ERROR',p_interface.err_mesg_4_cd,g_sys_award_year) IS NULL THEN

2775: END IF;
2776: END IF;
2777:
2778: IF p_interface.err_mesg_4_cd IS NOT NULL THEN
2779: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_ERROR',p_interface.err_mesg_4_cd,g_sys_award_year) IS NULL THEN
2780: g_tab_index := g_tab_index + 1;
2781: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
2782: fnd_message.set_token('FIELD','ERR_MESG_4_CD');
2783: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 2789: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_ERROR',p_interface.err_mesg_5_cd,g_sys_award_year) IS NULL THEN

2785: END IF;
2786: END IF;
2787:
2788: IF p_interface.err_mesg_5_cd IS NOT NULL THEN
2789: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_ERROR',p_interface.err_mesg_5_cd,g_sys_award_year) IS NULL THEN
2790: g_tab_index := g_tab_index + 1;
2791: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
2792: fnd_message.set_token('FIELD','ERR_MESG_5_CD');
2793: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 2825: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.b_reference_flag ) IS NULL THEN

2821: p_status := FALSE;
2822: END IF;
2823:
2824: IF p_interface.b_reference_flag IS NOT NULL THEN
2825: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_interface.b_reference_flag ) IS NULL THEN
2826: g_tab_index := g_tab_index + 1;
2827: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
2828: fnd_message.set_token('FIELD','B_REFERENCE_FLAG');
2829: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 2970: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_REC_TYPE_CD',p_disb_interface.record_type,g_sys_award_year) IS NULL THEN

2966: g_tab_index := g_tab_index + 1;
2967: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11) || fnd_message.get;
2968: p_d_status := FALSE;
2969: ELSE
2970: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_REC_TYPE_CD',p_disb_interface.record_type,g_sys_award_year) IS NULL THEN
2971: g_tab_index := g_tab_index + 1;
2972: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
2973: fnd_message.set_token('FIELD','RECORD_TYPE');
2974: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 3071: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_disb_interface.direct_to_borr_flag) IS NULL THEN

3067: END IF;
3068:
3069: -- FA 163 : direct_to_borr_flag should be either Y or N
3070: IF p_disb_interface.direct_to_borr_flag IS NOT NULL THEN
3071: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_disb_interface.direct_to_borr_flag) IS NULL THEN
3072: g_tab_index := g_tab_index + 1;
3073: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
3074: fnd_message.set_token('FIELD','DIRECT_TO_BORR_FLAG');
3075: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 3094: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_DB_FUND_DISB_METH',p_disb_interface.fund_dist_mthd_type,g_sys_award_year) IS NULL THEN

3090: p_d_status := FALSE;
3091: END IF;
3092:
3093: IF p_disb_interface.fund_dist_mthd_type IS NOT NULL THEN
3094: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_DB_FUND_DISB_METH',p_disb_interface.fund_dist_mthd_type,g_sys_award_year) IS NULL THEN
3095: g_tab_index := g_tab_index + 1;
3096: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
3097: fnd_message.set_token('FIELD','FUND_DIST_MTHD_TYPE');
3098: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 3104: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_disb_interface.late_disbursement_flag) IS NULL THEN

3100: END IF;
3101: END IF;
3102:
3103: IF p_disb_interface.late_disbursement_flag IS NOT NULL THEN
3104: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_disb_interface.late_disbursement_flag) IS NULL THEN
3105: g_tab_index := g_tab_index + 1;
3106: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
3107: fnd_message.set_token('FIELD','LATE_DISBURSEMENT_FLAG');
3108: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 3114: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_disb_interface.prev_reported_flag) IS NULL THEN

3110: END IF;
3111: END IF;
3112:
3113: IF p_disb_interface.prev_reported_flag IS NOT NULL THEN
3114: IF igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_disb_interface.prev_reported_flag) IS NULL THEN
3115: g_tab_index := g_tab_index + 1;
3116: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
3117: fnd_message.set_token('FIELD','PREV_REPORTED_FLAG');
3118: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 3125: (igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_DB_HOLD_REL_IND',p_disb_interface.disbursement_hld_release_flag,g_sys_award_year)) IS NULL

3121: END IF;
3122:
3123: IF p_disb_interface.disbursement_hld_release_flag IS NOT NULL THEN
3124: IF p_disb_interface.disbursement_hld_release_flag IN ('H','R') OR
3125: (igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_DB_HOLD_REL_IND',p_disb_interface.disbursement_hld_release_flag,g_sys_award_year)) IS NULL
3126: THEN
3127: g_tab_index := g_tab_index + 1;
3128: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
3129: fnd_message.set_token('FIELD','DISBURSEMENT_HLD_RELEASE_FLAG');

Line 3142: OR (igf_ap_gen.get_aw_lookup_meaning('IGF_SL_PNOTE_STATUS',p_disb_interface.pnote_code,g_sys_award_year) IS NULL)

3138: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11) || fnd_message.get;
3139: p_d_status := FALSE;
3140:
3141: ELSIF p_disb_interface.pnote_code IN ('A','C','F','G','I','M','N','P','Q','R','S','X')
3142: OR (igf_ap_gen.get_aw_lookup_meaning('IGF_SL_PNOTE_STATUS',p_disb_interface.pnote_code,g_sys_award_year) IS NULL)
3143: THEN
3144:
3145: g_tab_index := g_tab_index + 1;
3146: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');

Line 3174: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_DISB_STATUS',p_disb_interface.disbursement_status_code,g_sys_award_year) IS NULL THEN

3170: END IF;
3171:
3172:
3173: IF p_disb_interface.disbursement_status_code IS NOT NULL THEN
3174: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_DISB_STATUS',p_disb_interface.disbursement_status_code,g_sys_award_year) IS NULL THEN
3175: g_tab_index := g_tab_index + 1;
3176: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
3177: fnd_message.set_token('FIELD','DISBURSEMENT_STATUS_CODE');
3178: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 3184: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_DB_FUND_STATUS',p_disb_interface.fund_status_code,g_sys_award_year) IS NULL THEN

3180: END IF;
3181: END IF;
3182:
3183: IF p_disb_interface.fund_status_code IS NOT NULL THEN
3184: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_DB_FUND_STATUS',p_disb_interface.fund_status_code,g_sys_award_year) IS NULL THEN
3185: g_tab_index := g_tab_index + 1;
3186: fnd_message.set_name('IGF','IGF_SL_CL_INV_FND_STATUS');
3187: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11) || fnd_message.get;
3188: p_d_status := FALSE;

Line 3193: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_ERROR',p_disb_interface.err_mesg_1_cd,g_sys_award_year) IS NULL THEN

3189: END IF;
3190: END IF;
3191:
3192: IF p_disb_interface.err_mesg_1_cd IS NOT NULL THEN
3193: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_ERROR',p_disb_interface.err_mesg_1_cd,g_sys_award_year) IS NULL THEN
3194: g_tab_index := g_tab_index + 1;
3195: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
3196: fnd_message.set_token('FIELD','ERR_MESG_1_CD');
3197: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 3203: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_ERROR',p_disb_interface.err_mesg_2_cd,g_sys_award_year) IS NULL THEN

3199: END IF;
3200: END IF;
3201:
3202: IF p_disb_interface.err_mesg_2_cd IS NOT NULL THEN
3203: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_ERROR',p_disb_interface.err_mesg_2_cd,g_sys_award_year) IS NULL THEN
3204: g_tab_index := g_tab_index + 1;
3205: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
3206: fnd_message.set_token('FIELD','ERR_MESG_2_CD');
3207: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 3213: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_ERROR',p_disb_interface.err_mesg_3_cd,g_sys_award_year) IS NULL THEN

3209: END IF;
3210: END IF;
3211:
3212: IF p_disb_interface.err_mesg_3_cd IS NOT NULL THEN
3213: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_ERROR',p_disb_interface.err_mesg_3_cd,g_sys_award_year) IS NULL THEN
3214: g_tab_index := g_tab_index + 1;
3215: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
3216: fnd_message.set_token('FIELD','ERR_MESG_3_CD');
3217: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 3223: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_ERROR',p_disb_interface.err_mesg_4_cd,g_sys_award_year) IS NULL THEN

3219: END IF;
3220: END IF;
3221:
3222: IF p_disb_interface.err_mesg_4_cd IS NOT NULL THEN
3223: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_ERROR',p_disb_interface.err_mesg_4_cd,g_sys_award_year) IS NULL THEN
3224: g_tab_index := g_tab_index + 1;
3225: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
3226: fnd_message.set_token('FIELD','ERR_MESG_4_CD');
3227: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 3233: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_ERROR',p_disb_interface.err_mesg_5_cd,g_sys_award_year) IS NULL THEN

3229: END IF;
3230: END IF;
3231:
3232: IF p_disb_interface.err_mesg_5_cd IS NOT NULL THEN
3233: IF igf_ap_gen.get_aw_lookup_meaning('IGF_SL_CL_ERROR',p_disb_interface.err_mesg_5_cd,g_sys_award_year) IS NULL THEN
3234: g_tab_index := g_tab_index + 1;
3235: fnd_message.set_name('IGF','IGF_AP_INV_FLD_VAL');
3236: fnd_message.set_token('FIELD','ERR_MESG_5_CD');
3237: g_igf_sl_msg_table(g_tab_index).msg_text := RPAD(g_error,11)|| fnd_message.get;

Line 5204: log_parameters( l_get_alternate_code.alternate_code,p_batch_id,igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag));

5200: OPEN c_get_alternate_code(l_cal_type,l_seq_number);
5201: FETCH c_get_alternate_code INTO l_get_alternate_code;
5202: CLOSE c_get_alternate_code;
5203:
5204: log_parameters( l_get_alternate_code.alternate_code,p_batch_id,igf_ap_gen.get_lookup_meaning('IGF_AP_YES_NO',p_delete_flag));
5205:
5206: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5207: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_cal_type:'||l_cal_type ||' l_seq_number:'||l_seq_number);
5208: END IF;

Line 5210: l_chk_profile := igf_ap_gen.check_profile;

5206: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5207: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_cal_type:'||l_cal_type ||' l_seq_number:'||l_seq_number);
5208: END IF;
5209:
5210: l_chk_profile := igf_ap_gen.check_profile;
5211:
5212: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5213: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_chk_profile ' || l_chk_profile);
5214: END IF;

Line 5233: l_chk_batch := igf_ap_gen.check_batch(p_batch_id,'LOANS');

5229: fnd_file.put_line(fnd_file.log,RPAD(g_error,11) || fnd_message.get);
5230: RETURN;
5231: END IF;
5232:
5233: l_chk_batch := igf_ap_gen.check_batch(p_batch_id,'LOANS');
5234: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5235: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','l_chk_batch ' || l_chk_batch);
5236: END IF;
5237:

Line 5302: igf_ap_gen.check_person(l_interface.person_number,l_cal_type,l_seq_number,lv_person_id,lv_base_id);

5298: l_interface.person_number);
5299: --
5300: -- Check if person exists in OSS
5301: --
5302: igf_ap_gen.check_person(l_interface.person_number,l_cal_type,l_seq_number,lv_person_id,lv_base_id);
5303:
5304: IF fnd_log.level_statement >= fnd_log.g_current_runtime_level THEN
5305: fnd_log.string(fnd_log.level_statement,'igf.plsql.igf_sl_cl_imp_pkg.run.debug','lv_person_id ' || lv_person_id||' lv_base_id ' || lv_base_id);
5306: END IF;

Line 5715: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'), 40) || ' : ' || l_total_record_cnt);

5711: l_total_record_cnt := l_success_record_cnt + g_error_record_cnt;
5712: fnd_file.put_line(fnd_file.output,' ' );
5713: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));
5714: fnd_file.put_line(fnd_file.output,' ' );
5715: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'), 40) || ' : ' || l_total_record_cnt);
5716: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'), 40) || ' : ' || l_success_record_cnt);
5717: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'), 40) || ' : ' || g_error_record_cnt);
5718: fnd_file.put_line(fnd_file.output,' ' );
5719: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));

Line 5716: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'), 40) || ' : ' || l_success_record_cnt);

5712: fnd_file.put_line(fnd_file.output,' ' );
5713: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));
5714: fnd_file.put_line(fnd_file.output,' ' );
5715: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'), 40) || ' : ' || l_total_record_cnt);
5716: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'), 40) || ' : ' || l_success_record_cnt);
5717: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'), 40) || ' : ' || g_error_record_cnt);
5718: fnd_file.put_line(fnd_file.output,' ' );
5719: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));
5720: fnd_file.put_line(fnd_file.output,' ' );

Line 5717: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'), 40) || ' : ' || g_error_record_cnt);

5713: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));
5714: fnd_file.put_line(fnd_file.output,' ' );
5715: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_PROCESSED'), 40) || ' : ' || l_total_record_cnt);
5716: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_SUCCESSFUL'), 40) || ' : ' || l_success_record_cnt);
5717: fnd_file.put_line(fnd_file.output, RPAD(igf_ap_gen.get_lookup_meaning('IGF_GE_PARAMETERS','RECORDS_REJECTED'), 40) || ' : ' || g_error_record_cnt);
5718: fnd_file.put_line(fnd_file.output,' ' );
5719: fnd_file.put_line(fnd_file.output, RPAD('-',50,'-'));
5720: fnd_file.put_line(fnd_file.output,' ' );
5721: