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.PAY_IE_TAX_VAL dependencies on PAY_IE_TAX_TRAILER_INTERFACE

Line 1665: , PAY_IE_TAX_TRAILER_INTERFACE pts

1661: ,NVL(PTS.TOT_YEARLY_USC_RATE_3,0) total_YEARLY_USC_RATE_3
1662: ,NVL(PTS.TOT_YEARLY_USC_RATE_4,0) total_YEARLY_USC_RATE_4
1663: --
1664: FROM PAY_IE_TAX_HEADER_INTERFACE phs
1665: , PAY_IE_TAX_TRAILER_INTERFACE pts
1666: WHERE PTS.EMPLOYER_NUMBER = p_employer_number
1667: AND PHS.TAX_YEAR = p_tax_year;
1668:
1669: l_error_stack VARCHAR2 (2000);

Line 1852: 'The value in pay_ie_tax_trailer_interface.record_no is '

1848: FND_FILE.PUT_LINE(fnd_file.log,
1849: 'The total number of record in pay_ie_tax_body_interface is '
1850: || TO_CHAR (l_count_mth_taxcredit));
1851: FND_FILE.PUT_LINE (fnd_file.log,
1852: 'The value in pay_ie_tax_trailer_interface.record_no is '
1853: || TO_CHAR(l_count_emp_recno));
1854: FND_FILE.PUT_LINE(fnd_file.log,
1855: 'Error - Retcode = 2, total number of record in pay_ie_tax_body_interface');
1856: FND_FILE.PUT_LINE(fnd_file.log,

Line 1857: 'does not match the value in pay_ie_tax_trailer_interface.record_no');

1853: || TO_CHAR(l_count_emp_recno));
1854: FND_FILE.PUT_LINE(fnd_file.log,
1855: 'Error - Retcode = 2, total number of record in pay_ie_tax_body_interface');
1856: FND_FILE.PUT_LINE(fnd_file.log,
1857: 'does not match the value in pay_ie_tax_trailer_interface.record_no');
1858: END IF;
1859:
1860: IF l_sum_mth_rate_cutoff <> l_total_mth_cutoff THEN
1861: FND_FILE.NEW_LINE(fnd_file.log, 1);

Line 1866: 'The total monthly cutoff in pay_ie_tax_trailer_interface.total_mth_rate_cutoff is '

1862: FND_FILE.PUT_LINE(fnd_file.log,
1863: 'The sum of pay_ie_tax_body_interface.mth_rate_cutoff is '
1864: || TO_CHAR (l_sum_mth_rate_cutoff));
1865: FND_FILE.PUT_LINE (fnd_file.log,
1866: 'The total monthly cutoff in pay_ie_tax_trailer_interface.total_mth_rate_cutoff is '
1867: || TO_CHAR(l_total_mth_cutoff));
1868: FND_FILE.PUT_LINE(fnd_file.log,
1869: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.mth_rate_cutoff');
1870: FND_FILE.PUT_LINE(fnd_file.log,

Line 1871: 'does not match the total monthly cutoff in pay_ie_tax_trailer_interface.total_mth_rate_cutoff');

1867: || TO_CHAR(l_total_mth_cutoff));
1868: FND_FILE.PUT_LINE(fnd_file.log,
1869: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.mth_rate_cutoff');
1870: FND_FILE.PUT_LINE(fnd_file.log,
1871: 'does not match the total monthly cutoff in pay_ie_tax_trailer_interface.total_mth_rate_cutoff');
1872: END IF;
1873: IF l_sum_wk_rate_cutoff <> l_total_wk_cutoff THEN
1874: FND_FILE.NEW_LINE(fnd_file.log, 1);
1875: FND_FILE.PUT_LINE(fnd_file.log,

Line 1879: 'The total weekly cutoff in pay_ie_tax_trailer_interface.total_wk_rate_cutoff is '

1875: FND_FILE.PUT_LINE(fnd_file.log,
1876: 'The sum of pay_ie_tax_body_interface.wk_rate_cutoff is '
1877: || TO_CHAR(l_sum_wk_rate_cutoff));
1878: FND_FILE.PUT_LINE(fnd_file.log,
1879: 'The total weekly cutoff in pay_ie_tax_trailer_interface.total_wk_rate_cutoff is '
1880: || TO_CHAR(l_total_wk_cutoff));
1881: FND_FILE.PUT_LINE(fnd_file.log,
1882: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.wk_rate_cutoff');
1883: FND_FILE.PUT_LINE(fnd_file.log,

Line 1884: 'does not match the the total weekly cutoff in pay_ie_tax_trailer_interface.total_wk_rate_cutoff');

1880: || TO_CHAR(l_total_wk_cutoff));
1881: FND_FILE.PUT_LINE(fnd_file.log,
1882: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.wk_rate_cutoff');
1883: FND_FILE.PUT_LINE(fnd_file.log,
1884: 'does not match the the total weekly cutoff in pay_ie_tax_trailer_interface.total_wk_rate_cutoff');
1885: END IF;
1886: IF l_sum_mth_tax_credit <> l_total_mth_credit THEN
1887: FND_FILE.NEW_LINE(fnd_file.log, 1);
1888: FND_FILE.PUT_LINE(fnd_file.log,

Line 1892: 'The total monthly credit in pay_ie_tax_trailer_interface.total_mth_tax_credit is '

1888: FND_FILE.PUT_LINE(fnd_file.log,
1889: 'The sum of pay_ie_tax_body_interface.mth_tax_credit is '
1890: || TO_CHAR(l_sum_mth_tax_credit));
1891: FND_FILE.PUT_LINE(fnd_file.log,
1892: 'The total monthly credit in pay_ie_tax_trailer_interface.total_mth_tax_credit is '
1893: || TO_CHAR(l_total_mth_credit));
1894: FND_FILE.PUT_LINE(fnd_file.log,
1895: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.mth_tax_credit');
1896: FND_FILE.PUT_LINE(fnd_file.log,

Line 1897: 'does not match the total monthly credit in pay_ie_tax_trailer_interface.total_mth_tax_credit');

1893: || TO_CHAR(l_total_mth_credit));
1894: FND_FILE.PUT_LINE(fnd_file.log,
1895: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.mth_tax_credit');
1896: FND_FILE.PUT_LINE(fnd_file.log,
1897: 'does not match the total monthly credit in pay_ie_tax_trailer_interface.total_mth_tax_credit');
1898: END IF;
1899: IF BodyRec.sum_wk_tax_credit <> TrailRec.total_wk_credit THEN
1900: FND_FILE.NEW_LINE(fnd_file.log, 1);
1901: FND_FILE.PUT_LINE(fnd_file.log,

Line 1905: 'The total weekly credit in pay_ie_tax_trailer_interface.total_wk_tax_credit is '

1901: FND_FILE.PUT_LINE(fnd_file.log,
1902: 'The sum of pay_ie_tax_body_interface.wk_tax_credit is '
1903: || TO_CHAR(l_sum_wk_tax_credit));
1904: FND_FILE.PUT_LINE(fnd_file.log,
1905: 'The total weekly credit in pay_ie_tax_trailer_interface.total_wk_tax_credit is '
1906: || TO_CHAR(l_total_wk_credit));
1907: FND_FILE.PUT_LINE(fnd_file.log,
1908: 'Error - Retcode = 2 because the sum of pay_ie_tax_body_interface.wk_tax_credit');
1909: FND_FILE.PUT_LINE(fnd_file.log,

Line 1910: 'does not match the total weekly credit in pay_ie_tax_trailer_interface.total_wk_tax_credit');

1906: || TO_CHAR(l_total_wk_credit));
1907: FND_FILE.PUT_LINE(fnd_file.log,
1908: 'Error - Retcode = 2 because the sum of pay_ie_tax_body_interface.wk_tax_credit');
1909: FND_FILE.PUT_LINE(fnd_file.log,
1910: 'does not match the total weekly credit in pay_ie_tax_trailer_interface.total_wk_tax_credit');
1911: END IF;
1912:
1913: --
1914: IF l_total_YEARLY_TAX_CRED <> l_sum_YRLY_TAX_CRED THEN

Line 1920: 'The total yearly tax credit in pay_ie_tax_trailer_interface.tc_tot_yearly_tax_cred is '

1916: FND_FILE.PUT_LINE(fnd_file.log,
1917: 'The sum of pay_ie_tax_body_interface.cd_yrly_tax_cred '
1918: || TO_CHAR(l_sum_YRLY_TAX_CRED));
1919: FND_FILE.PUT_LINE(fnd_file.log,
1920: 'The total yearly tax credit in pay_ie_tax_trailer_interface.tc_tot_yearly_tax_cred is '
1921: || TO_CHAR(l_total_YEARLY_TAX_CRED));
1922: FND_FILE.PUT_LINE(fnd_file.log,
1923: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_yrly_tax_cred');
1924: FND_FILE.PUT_LINE(fnd_file.log,

Line 1925: 'does not match the total yearly tax credit in pay_ie_tax_trailer_interface.tc_tot_yearly_tax_cred');

1921: || TO_CHAR(l_total_YEARLY_TAX_CRED));
1922: FND_FILE.PUT_LINE(fnd_file.log,
1923: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_yrly_tax_cred');
1924: FND_FILE.PUT_LINE(fnd_file.log,
1925: 'does not match the total yearly tax credit in pay_ie_tax_trailer_interface.tc_tot_yearly_tax_cred');
1926: END IF;
1927:
1928: IF l_total_YEARLY_TAX_RATE_1 <> l_sum_YRLY_TAX_RATE_1 THEN
1929: FND_FILE.NEW_LINE(fnd_file.log, 1);

Line 1934: 'The total yearly tax rate1 in pay_ie_tax_trailer_interface.tot_yearly_tax_rate_1 is '

1930: FND_FILE.PUT_LINE(fnd_file.log,
1931: 'The sum of pay_ie_tax_body_interface.cd_yrly_tax_rate_1 '
1932: || TO_CHAR(l_sum_YRLY_TAX_RATE_1));
1933: FND_FILE.PUT_LINE(fnd_file.log,
1934: 'The total yearly tax rate1 in pay_ie_tax_trailer_interface.tot_yearly_tax_rate_1 is '
1935: || TO_CHAR(l_total_YEARLY_TAX_RATE_1));
1936: FND_FILE.PUT_LINE(fnd_file.log,
1937: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_yrly_tax_rate_1');
1938: FND_FILE.PUT_LINE(fnd_file.log,

Line 1939: 'does not match the total yearly tax rate1 in pay_ie_tax_trailer_interface.tot_yearly_tax_rate_1');

1935: || TO_CHAR(l_total_YEARLY_TAX_RATE_1));
1936: FND_FILE.PUT_LINE(fnd_file.log,
1937: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_yrly_tax_rate_1');
1938: FND_FILE.PUT_LINE(fnd_file.log,
1939: 'does not match the total yearly tax rate1 in pay_ie_tax_trailer_interface.tot_yearly_tax_rate_1');
1940: END IF;
1941:
1942: IF l_total_YEARLY_TAX_RATE_2 <> l_sum_YRLY_TAX_RATE_2 THEN
1943: FND_FILE.NEW_LINE(fnd_file.log, 1);

Line 1948: 'The total yearly tax rate2 in pay_ie_tax_trailer_interface.tot_yearly_tax_rate_2 is '

1944: FND_FILE.PUT_LINE(fnd_file.log,
1945: 'The sum of pay_ie_tax_body_interface.cd_yrly_tax_rate_2 '
1946: || TO_CHAR(l_sum_YRLY_TAX_RATE_2));
1947: FND_FILE.PUT_LINE(fnd_file.log,
1948: 'The total yearly tax rate2 in pay_ie_tax_trailer_interface.tot_yearly_tax_rate_2 is '
1949: || TO_CHAR(l_total_YEARLY_TAX_RATE_2));
1950: FND_FILE.PUT_LINE(fnd_file.log,
1951: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_yrly_tax_rate_2');
1952: FND_FILE.PUT_LINE(fnd_file.log,

Line 1953: 'does not match the total yearly tax rate2 in pay_ie_tax_trailer_interface.tot_yearly_tax_rate_2');

1949: || TO_CHAR(l_total_YEARLY_TAX_RATE_2));
1950: FND_FILE.PUT_LINE(fnd_file.log,
1951: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_yrly_tax_rate_2');
1952: FND_FILE.PUT_LINE(fnd_file.log,
1953: 'does not match the total yearly tax rate2 in pay_ie_tax_trailer_interface.tot_yearly_tax_rate_2');
1954: END IF;
1955:
1956: IF l_total_MONTHLY_TAX_RATE_2 <> l_sum_MTHLY_TAX_RATE_2 THEN
1957: FND_FILE.NEW_LINE(fnd_file.log, 1);

Line 1962: 'The total monthly tax rate2 in pay_ie_tax_trailer_interface.tot_monthly_tax_rate_2 is '

1958: FND_FILE.PUT_LINE(fnd_file.log,
1959: 'The sum of pay_ie_tax_body_interface.cd_mthly_tax_rate_2 '
1960: || TO_CHAR(l_sum_MTHLY_TAX_RATE_2));
1961: FND_FILE.PUT_LINE(fnd_file.log,
1962: 'The total monthly tax rate2 in pay_ie_tax_trailer_interface.tot_monthly_tax_rate_2 is '
1963: || TO_CHAR(l_total_MONTHLY_TAX_RATE_2));
1964: FND_FILE.PUT_LINE(fnd_file.log,
1965: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_mthly_tax_rate_2');
1966: FND_FILE.PUT_LINE(fnd_file.log,

Line 1967: 'does not match the total monthly tax rate2 in pay_ie_tax_trailer_interface.tot_monthly_tax_rate_2');

1963: || TO_CHAR(l_total_MONTHLY_TAX_RATE_2));
1964: FND_FILE.PUT_LINE(fnd_file.log,
1965: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_mthly_tax_rate_2');
1966: FND_FILE.PUT_LINE(fnd_file.log,
1967: 'does not match the total monthly tax rate2 in pay_ie_tax_trailer_interface.tot_monthly_tax_rate_2');
1968: END IF;
1969:
1970: IF l_total_WEEKLY_TAX_RATE_2 <> l_sum_WKLY_TAX_RATE_2 THEN
1971: FND_FILE.NEW_LINE(fnd_file.log, 1);

Line 1976: 'The total weekly tax rate2 in pay_ie_tax_trailer_interface.tot_weekly_tax_rate_2 is '

1972: FND_FILE.PUT_LINE(fnd_file.log,
1973: 'The sum of pay_ie_tax_body_interface.cd_wkly_tax_rate_2 '
1974: || TO_CHAR(l_sum_WKLY_TAX_RATE_2));
1975: FND_FILE.PUT_LINE(fnd_file.log,
1976: 'The total weekly tax rate2 in pay_ie_tax_trailer_interface.tot_weekly_tax_rate_2 is '
1977: || TO_CHAR(l_total_WEEKLY_TAX_RATE_2));
1978: FND_FILE.PUT_LINE(fnd_file.log,
1979: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_wkly_tax_rate_2');
1980: FND_FILE.PUT_LINE(fnd_file.log,

Line 1981: 'does not match the total weekly tax rate2 in pay_ie_tax_trailer_interface.tot_weekly_tax_rate_2');

1977: || TO_CHAR(l_total_WEEKLY_TAX_RATE_2));
1978: FND_FILE.PUT_LINE(fnd_file.log,
1979: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_wkly_tax_rate_2');
1980: FND_FILE.PUT_LINE(fnd_file.log,
1981: 'does not match the total weekly tax rate2 in pay_ie_tax_trailer_interface.tot_weekly_tax_rate_2');
1982: END IF;
1983:
1984: IF l_total_YEARLY_TAX_RATE_3 <> l_sum_YRLY_TAX_RATE_3 THEN
1985: FND_FILE.NEW_LINE(fnd_file.log, 1);

Line 1990: 'The total yearly tax rate3 in pay_ie_tax_trailer_interface.tot_yearly_tax_rate_3 is '

1986: FND_FILE.PUT_LINE(fnd_file.log,
1987: 'The sum of pay_ie_tax_body_interface.cd_yrly_tax_rate_3 '
1988: || TO_CHAR(l_sum_YRLY_TAX_RATE_3));
1989: FND_FILE.PUT_LINE(fnd_file.log,
1990: 'The total yearly tax rate3 in pay_ie_tax_trailer_interface.tot_yearly_tax_rate_3 is '
1991: || TO_CHAR(l_total_YEARLY_TAX_RATE_3));
1992: FND_FILE.PUT_LINE(fnd_file.log,
1993: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_yrly_tax_rate_3');
1994: FND_FILE.PUT_LINE(fnd_file.log,

Line 1995: 'does not match the total yearly tax rate3 in pay_ie_tax_trailer_interface.tot_yearly_tax_rate_3');

1991: || TO_CHAR(l_total_YEARLY_TAX_RATE_3));
1992: FND_FILE.PUT_LINE(fnd_file.log,
1993: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_yrly_tax_rate_3');
1994: FND_FILE.PUT_LINE(fnd_file.log,
1995: 'does not match the total yearly tax rate3 in pay_ie_tax_trailer_interface.tot_yearly_tax_rate_3');
1996: END IF;
1997:
1998: IF l_total_MONTHLY_TAX_RATE_3 <> l_sum_MTHLY_TAX_RATE_3 THEN
1999: FND_FILE.NEW_LINE(fnd_file.log, 1);

Line 2004: 'The total monthly tax rate3 in pay_ie_tax_trailer_interface.tot_monthly_tax_rate_3 is '

2000: FND_FILE.PUT_LINE(fnd_file.log,
2001: 'The sum of pay_ie_tax_body_interface.cd_mthly_tax_rate_3 '
2002: || TO_CHAR(l_sum_MTHLY_TAX_RATE_3));
2003: FND_FILE.PUT_LINE(fnd_file.log,
2004: 'The total monthly tax rate3 in pay_ie_tax_trailer_interface.tot_monthly_tax_rate_3 is '
2005: || TO_CHAR(l_total_MONTHLY_TAX_RATE_3));
2006: FND_FILE.PUT_LINE(fnd_file.log,
2007: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_mthly_tax_rate_3');
2008: FND_FILE.PUT_LINE(fnd_file.log,

Line 2009: 'does not match the total monthly tax rate3 in pay_ie_tax_trailer_interface.tot_monthly_tax_rate_3');

2005: || TO_CHAR(l_total_MONTHLY_TAX_RATE_3));
2006: FND_FILE.PUT_LINE(fnd_file.log,
2007: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_mthly_tax_rate_3');
2008: FND_FILE.PUT_LINE(fnd_file.log,
2009: 'does not match the total monthly tax rate3 in pay_ie_tax_trailer_interface.tot_monthly_tax_rate_3');
2010: END IF;
2011:
2012: IF l_total_WEEKLY_TAX_RATE_3 <> l_sum_WKLY_TAX_RATE_3 THEN
2013: FND_FILE.NEW_LINE(fnd_file.log, 1);

Line 2018: 'The total weekly tax rate3 in pay_ie_tax_trailer_interface.tot_weekly_tax_rate_3 is '

2014: FND_FILE.PUT_LINE(fnd_file.log,
2015: 'The sum of pay_ie_tax_body_interface.cd_wkly_tax_rate_3 '
2016: || TO_CHAR(l_sum_WKLY_TAX_RATE_3));
2017: FND_FILE.PUT_LINE(fnd_file.log,
2018: 'The total weekly tax rate3 in pay_ie_tax_trailer_interface.tot_weekly_tax_rate_3 is '
2019: || TO_CHAR(l_total_WEEKLY_TAX_RATE_3));
2020: FND_FILE.PUT_LINE(fnd_file.log,
2021: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_wkly_tax_rate_3');
2022: FND_FILE.PUT_LINE(fnd_file.log,

Line 2023: 'does not match the total weekly tax rate3 in pay_ie_tax_trailer_interface.tot_weekly_tax_rate_3');

2019: || TO_CHAR(l_total_WEEKLY_TAX_RATE_3));
2020: FND_FILE.PUT_LINE(fnd_file.log,
2021: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_wkly_tax_rate_3');
2022: FND_FILE.PUT_LINE(fnd_file.log,
2023: 'does not match the total weekly tax rate3 in pay_ie_tax_trailer_interface.tot_weekly_tax_rate_3');
2024: END IF;
2025:
2026: IF l_total_YEARLY_TAX_RATE_4 <> l_sum_YRLY_TAX_RATE_4 THEN
2027: FND_FILE.NEW_LINE(fnd_file.log, 1);

Line 2032: 'The total yearly tax rate3 in pay_ie_tax_trailer_interface.tot_yearly_tax_rate_4 is '

2028: FND_FILE.PUT_LINE(fnd_file.log,
2029: 'The sum of pay_ie_tax_body_interface.cd_yrly_tax_rate_4 '
2030: || TO_CHAR(l_sum_YRLY_TAX_RATE_4));
2031: FND_FILE.PUT_LINE(fnd_file.log,
2032: 'The total yearly tax rate3 in pay_ie_tax_trailer_interface.tot_yearly_tax_rate_4 is '
2033: || TO_CHAR(l_total_YEARLY_TAX_RATE_4));
2034: FND_FILE.PUT_LINE(fnd_file.log,
2035: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_yrly_tax_rate_4');
2036: FND_FILE.PUT_LINE(fnd_file.log,

Line 2037: 'does not match the total yearly tax rate4 in pay_ie_tax_trailer_interface.tot_yearly_tax_rate_4');

2033: || TO_CHAR(l_total_YEARLY_TAX_RATE_4));
2034: FND_FILE.PUT_LINE(fnd_file.log,
2035: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_yrly_tax_rate_4');
2036: FND_FILE.PUT_LINE(fnd_file.log,
2037: 'does not match the total yearly tax rate4 in pay_ie_tax_trailer_interface.tot_yearly_tax_rate_4');
2038: END IF;
2039:
2040: IF l_total_MONTHLY_TAX_RATE_4 <> l_sum_MTHLY_TAX_RATE_4 THEN
2041: FND_FILE.NEW_LINE(fnd_file.log, 1);

Line 2046: 'The total monthly tax rate3 in pay_ie_tax_trailer_interface.tot_monthly_tax_rate_4 is '

2042: FND_FILE.PUT_LINE(fnd_file.log,
2043: 'The sum of pay_ie_tax_body_interface.cd_mthly_tax_rate_4 '
2044: || TO_CHAR(l_sum_MTHLY_TAX_RATE_4));
2045: FND_FILE.PUT_LINE(fnd_file.log,
2046: 'The total monthly tax rate3 in pay_ie_tax_trailer_interface.tot_monthly_tax_rate_4 is '
2047: || TO_CHAR(l_total_MONTHLY_TAX_RATE_4));
2048: FND_FILE.PUT_LINE(fnd_file.log,
2049: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_mthly_tax_rate_4');
2050: FND_FILE.PUT_LINE(fnd_file.log,

Line 2051: 'does not match the total monthly tax rate4 in pay_ie_tax_trailer_interface.tot_monthly_tax_rate_4');

2047: || TO_CHAR(l_total_MONTHLY_TAX_RATE_4));
2048: FND_FILE.PUT_LINE(fnd_file.log,
2049: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_mthly_tax_rate_4');
2050: FND_FILE.PUT_LINE(fnd_file.log,
2051: 'does not match the total monthly tax rate4 in pay_ie_tax_trailer_interface.tot_monthly_tax_rate_4');
2052: END IF;
2053:
2054: IF l_total_WEEKLY_TAX_RATE_4 <> l_sum_WKLY_TAX_RATE_4 THEN
2055: FND_FILE.NEW_LINE(fnd_file.log, 1);

Line 2060: 'The total weekly tax rate3 in pay_ie_tax_trailer_interface.tot_weekly_tax_rate_4 is '

2056: FND_FILE.PUT_LINE(fnd_file.log,
2057: 'The sum of pay_ie_tax_body_interface.cd_wkly_tax_rate_4 '
2058: || TO_CHAR(l_sum_WKLY_TAX_RATE_4));
2059: FND_FILE.PUT_LINE(fnd_file.log,
2060: 'The total weekly tax rate3 in pay_ie_tax_trailer_interface.tot_weekly_tax_rate_4 is '
2061: || TO_CHAR(l_total_WEEKLY_TAX_RATE_4));
2062: FND_FILE.PUT_LINE(fnd_file.log,
2063: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_wkly_tax_rate_4');
2064: FND_FILE.PUT_LINE(fnd_file.log,

Line 2065: 'does not match the total weekly tax rate4 in pay_ie_tax_trailer_interface.tot_weekly_tax_rate_4');

2061: || TO_CHAR(l_total_WEEKLY_TAX_RATE_4));
2062: FND_FILE.PUT_LINE(fnd_file.log,
2063: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.cd_wkly_tax_rate_4');
2064: FND_FILE.PUT_LINE(fnd_file.log,
2065: 'does not match the total weekly tax rate4 in pay_ie_tax_trailer_interface.tot_weekly_tax_rate_4');
2066: END IF;
2067:
2068: IF l_total_YEARLY_USC_RATE_1 <> l_sum_USC_YRLY_CUTOFF_1 THEN
2069: FND_FILE.NEW_LINE(fnd_file.log, 1);

Line 2074: 'The total yearly usc rate1 in pay_ie_tax_trailer_interface.tot_yearly_usc_rate_1 is '

2070: FND_FILE.PUT_LINE(fnd_file.log,
2071: 'The sum of pay_ie_tax_body_interface.am_usc_yrly_cutoff_1 '
2072: || TO_CHAR(l_sum_USC_YRLY_CUTOFF_1));
2073: FND_FILE.PUT_LINE(fnd_file.log,
2074: 'The total yearly usc rate1 in pay_ie_tax_trailer_interface.tot_yearly_usc_rate_1 is '
2075: || TO_CHAR(l_total_YEARLY_USC_RATE_1));
2076: FND_FILE.PUT_LINE(fnd_file.log,
2077: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.am_usc_yrly_cutoff_1');
2078: FND_FILE.PUT_LINE(fnd_file.log,

Line 2079: 'does not match the total yearly usc rate1 in pay_ie_tax_trailer_interface.tot_yearly_usc_rate_1');

2075: || TO_CHAR(l_total_YEARLY_USC_RATE_1));
2076: FND_FILE.PUT_LINE(fnd_file.log,
2077: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.am_usc_yrly_cutoff_1');
2078: FND_FILE.PUT_LINE(fnd_file.log,
2079: 'does not match the total yearly usc rate1 in pay_ie_tax_trailer_interface.tot_yearly_usc_rate_1');
2080: END IF;
2081:
2082: IF l_total_YEARLY_USC_RATE_2 <> l_sum_USC_YRLY_CUTOFF_2 THEN
2083: FND_FILE.NEW_LINE(fnd_file.log, 1);

Line 2088: 'The total yearly usc rate2 in pay_ie_tax_trailer_interface.tot_yearly_usc_rate_2 is '

2084: FND_FILE.PUT_LINE(fnd_file.log,
2085: 'The sum of pay_ie_tax_body_interface.am_usc_yrly_cutoff_2 '
2086: || TO_CHAR(l_sum_USC_YRLY_CUTOFF_2));
2087: FND_FILE.PUT_LINE(fnd_file.log,
2088: 'The total yearly usc rate2 in pay_ie_tax_trailer_interface.tot_yearly_usc_rate_2 is '
2089: || TO_CHAR(l_total_YEARLY_USC_RATE_2));
2090: FND_FILE.PUT_LINE(fnd_file.log,
2091: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.am_usc_yrly_cutoff_2');
2092: FND_FILE.PUT_LINE(fnd_file.log,

Line 2093: 'does not match the total yearly usc rate2 in pay_ie_tax_trailer_interface.tot_yearly_usc_rate_2');

2089: || TO_CHAR(l_total_YEARLY_USC_RATE_2));
2090: FND_FILE.PUT_LINE(fnd_file.log,
2091: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.am_usc_yrly_cutoff_2');
2092: FND_FILE.PUT_LINE(fnd_file.log,
2093: 'does not match the total yearly usc rate2 in pay_ie_tax_trailer_interface.tot_yearly_usc_rate_2');
2094: END IF;
2095:
2096: IF l_total_YEARLY_USC_RATE_3 <> l_sum_USC_YRLY_CUTOFF_3 THEN
2097: FND_FILE.NEW_LINE(fnd_file.log, 1);

Line 2102: 'The total yearly usc rate3 in pay_ie_tax_trailer_interface.tot_yearly_usc_rate_3 is '

2098: FND_FILE.PUT_LINE(fnd_file.log,
2099: 'The sum of pay_ie_tax_body_interface.am_usc_yrly_cutoff_3 '
2100: || TO_CHAR(l_sum_USC_YRLY_CUTOFF_3));
2101: FND_FILE.PUT_LINE(fnd_file.log,
2102: 'The total yearly usc rate3 in pay_ie_tax_trailer_interface.tot_yearly_usc_rate_3 is '
2103: || TO_CHAR(l_total_YEARLY_USC_RATE_3));
2104: FND_FILE.PUT_LINE(fnd_file.log,
2105: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.am_usc_yrly_cutoff_3');
2106: FND_FILE.PUT_LINE(fnd_file.log,

Line 2107: 'does not match the total yearly usc rate3 in pay_ie_tax_trailer_interface.tot_yearly_usc_rate_3');

2103: || TO_CHAR(l_total_YEARLY_USC_RATE_3));
2104: FND_FILE.PUT_LINE(fnd_file.log,
2105: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.am_usc_yrly_cutoff_3');
2106: FND_FILE.PUT_LINE(fnd_file.log,
2107: 'does not match the total yearly usc rate3 in pay_ie_tax_trailer_interface.tot_yearly_usc_rate_3');
2108: END IF;
2109:
2110: IF l_total_YEARLY_USC_RATE_4 <> l_sum_USC_YRLY_CUTOFF_4 THEN
2111: FND_FILE.NEW_LINE(fnd_file.log, 1);

Line 2116: 'The total yearly usc rate4 in pay_ie_tax_trailer_interface.tot_yearly_usc_rate_4 is '

2112: FND_FILE.PUT_LINE(fnd_file.log,
2113: 'The sum of pay_ie_tax_body_interface.am_usc_yrly_cutoff_4 '
2114: || TO_CHAR(l_sum_USC_YRLY_CUTOFF_4));
2115: FND_FILE.PUT_LINE(fnd_file.log,
2116: 'The total yearly usc rate4 in pay_ie_tax_trailer_interface.tot_yearly_usc_rate_4 is '
2117: || TO_CHAR(l_total_YEARLY_USC_RATE_4));
2118: FND_FILE.PUT_LINE(fnd_file.log,
2119: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.am_usc_yrly_cutoff_4');
2120: FND_FILE.PUT_LINE(fnd_file.log,

Line 2121: 'does not match the total yearly usc rate4 in pay_ie_tax_trailer_interface.tot_yearly_usc_rate_4');

2117: || TO_CHAR(l_total_YEARLY_USC_RATE_4));
2118: FND_FILE.PUT_LINE(fnd_file.log,
2119: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.am_usc_yrly_cutoff_4');
2120: FND_FILE.PUT_LINE(fnd_file.log,
2121: 'does not match the total yearly usc rate4 in pay_ie_tax_trailer_interface.tot_yearly_usc_rate_4');
2122: END IF;
2123:
2124: --
2125:

Line 2150: wing tables: pay_ie_tax_header_interface, pay_ie_tax_body_interface, pay_ie_tax_trailer_interface');

2146: l_error_stack := errbuf;
2147: l_error := SQLERRM;
2148: retcode := 2;
2149: FND_FILE.PUT_LINE (fnd_file.log, 'Error raised in loading data into one or all of the follo
2150: wing tables: pay_ie_tax_header_interface, pay_ie_tax_body_interface, pay_ie_tax_trailer_interface');
2151:
2152: INSERT INTO pay_ie_tax_error ( pps_number
2153: , employee_number
2154: , full_name

Line 2263: --l_record_type pay_ie_tax_trailer_interface.record_type%type;

2259: --
2260:
2261:
2262: --Trailer
2263: --l_record_type pay_ie_tax_trailer_interface.record_type%type;
2264: --l_employer_number pay_ie_tax_trailer_interface.employer_number%type;
2265: l_total_mth_rate_cutoff pay_ie_tax_trailer_interface.total_mth_rate_cutoff%type;
2266: l_total_wk_rate_cutoff pay_ie_tax_trailer_interface.total_wk_rate_cutoff%type;
2267: l_total_mth_tax_credit pay_ie_tax_trailer_interface.total_mth_tax_credit%type;

Line 2264: --l_employer_number pay_ie_tax_trailer_interface.employer_number%type;

2260:
2261:
2262: --Trailer
2263: --l_record_type pay_ie_tax_trailer_interface.record_type%type;
2264: --l_employer_number pay_ie_tax_trailer_interface.employer_number%type;
2265: l_total_mth_rate_cutoff pay_ie_tax_trailer_interface.total_mth_rate_cutoff%type;
2266: l_total_wk_rate_cutoff pay_ie_tax_trailer_interface.total_wk_rate_cutoff%type;
2267: l_total_mth_tax_credit pay_ie_tax_trailer_interface.total_mth_tax_credit%type;
2268: l_total_wk_tax_credit pay_ie_tax_trailer_interface.total_wk_tax_credit%type;

Line 2265: l_total_mth_rate_cutoff pay_ie_tax_trailer_interface.total_mth_rate_cutoff%type;

2261:
2262: --Trailer
2263: --l_record_type pay_ie_tax_trailer_interface.record_type%type;
2264: --l_employer_number pay_ie_tax_trailer_interface.employer_number%type;
2265: l_total_mth_rate_cutoff pay_ie_tax_trailer_interface.total_mth_rate_cutoff%type;
2266: l_total_wk_rate_cutoff pay_ie_tax_trailer_interface.total_wk_rate_cutoff%type;
2267: l_total_mth_tax_credit pay_ie_tax_trailer_interface.total_mth_tax_credit%type;
2268: l_total_wk_tax_credit pay_ie_tax_trailer_interface.total_wk_tax_credit%type;
2269: l_record_no pay_ie_tax_trailer_interface.record_no%type;

Line 2266: l_total_wk_rate_cutoff pay_ie_tax_trailer_interface.total_wk_rate_cutoff%type;

2262: --Trailer
2263: --l_record_type pay_ie_tax_trailer_interface.record_type%type;
2264: --l_employer_number pay_ie_tax_trailer_interface.employer_number%type;
2265: l_total_mth_rate_cutoff pay_ie_tax_trailer_interface.total_mth_rate_cutoff%type;
2266: l_total_wk_rate_cutoff pay_ie_tax_trailer_interface.total_wk_rate_cutoff%type;
2267: l_total_mth_tax_credit pay_ie_tax_trailer_interface.total_mth_tax_credit%type;
2268: l_total_wk_tax_credit pay_ie_tax_trailer_interface.total_wk_tax_credit%type;
2269: l_record_no pay_ie_tax_trailer_interface.record_no%type;
2270: --

Line 2267: l_total_mth_tax_credit pay_ie_tax_trailer_interface.total_mth_tax_credit%type;

2263: --l_record_type pay_ie_tax_trailer_interface.record_type%type;
2264: --l_employer_number pay_ie_tax_trailer_interface.employer_number%type;
2265: l_total_mth_rate_cutoff pay_ie_tax_trailer_interface.total_mth_rate_cutoff%type;
2266: l_total_wk_rate_cutoff pay_ie_tax_trailer_interface.total_wk_rate_cutoff%type;
2267: l_total_mth_tax_credit pay_ie_tax_trailer_interface.total_mth_tax_credit%type;
2268: l_total_wk_tax_credit pay_ie_tax_trailer_interface.total_wk_tax_credit%type;
2269: l_record_no pay_ie_tax_trailer_interface.record_no%type;
2270: --
2271: l_TC_TOT_YEARLY_TAX_CRED pay_ie_tax_trailer_interface.TC_TOT_YEARLY_TAX_CRED%type;

Line 2268: l_total_wk_tax_credit pay_ie_tax_trailer_interface.total_wk_tax_credit%type;

2264: --l_employer_number pay_ie_tax_trailer_interface.employer_number%type;
2265: l_total_mth_rate_cutoff pay_ie_tax_trailer_interface.total_mth_rate_cutoff%type;
2266: l_total_wk_rate_cutoff pay_ie_tax_trailer_interface.total_wk_rate_cutoff%type;
2267: l_total_mth_tax_credit pay_ie_tax_trailer_interface.total_mth_tax_credit%type;
2268: l_total_wk_tax_credit pay_ie_tax_trailer_interface.total_wk_tax_credit%type;
2269: l_record_no pay_ie_tax_trailer_interface.record_no%type;
2270: --
2271: l_TC_TOT_YEARLY_TAX_CRED pay_ie_tax_trailer_interface.TC_TOT_YEARLY_TAX_CRED%type;
2272: l_TOT_YEARLY_TAX_RATE_1 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_1%type;

Line 2269: l_record_no pay_ie_tax_trailer_interface.record_no%type;

2265: l_total_mth_rate_cutoff pay_ie_tax_trailer_interface.total_mth_rate_cutoff%type;
2266: l_total_wk_rate_cutoff pay_ie_tax_trailer_interface.total_wk_rate_cutoff%type;
2267: l_total_mth_tax_credit pay_ie_tax_trailer_interface.total_mth_tax_credit%type;
2268: l_total_wk_tax_credit pay_ie_tax_trailer_interface.total_wk_tax_credit%type;
2269: l_record_no pay_ie_tax_trailer_interface.record_no%type;
2270: --
2271: l_TC_TOT_YEARLY_TAX_CRED pay_ie_tax_trailer_interface.TC_TOT_YEARLY_TAX_CRED%type;
2272: l_TOT_YEARLY_TAX_RATE_1 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_1%type;
2273: l_TOT_YEARLY_TAX_RATE_2 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_2%type;

Line 2271: l_TC_TOT_YEARLY_TAX_CRED pay_ie_tax_trailer_interface.TC_TOT_YEARLY_TAX_CRED%type;

2267: l_total_mth_tax_credit pay_ie_tax_trailer_interface.total_mth_tax_credit%type;
2268: l_total_wk_tax_credit pay_ie_tax_trailer_interface.total_wk_tax_credit%type;
2269: l_record_no pay_ie_tax_trailer_interface.record_no%type;
2270: --
2271: l_TC_TOT_YEARLY_TAX_CRED pay_ie_tax_trailer_interface.TC_TOT_YEARLY_TAX_CRED%type;
2272: l_TOT_YEARLY_TAX_RATE_1 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_1%type;
2273: l_TOT_YEARLY_TAX_RATE_2 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_2%type;
2274: l_TOT_MONTHLY_TAX_RATE_2 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_2%type;
2275: l_TOT_WEEKLY_TAX_RATE_2 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_2%type;

Line 2272: l_TOT_YEARLY_TAX_RATE_1 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_1%type;

2268: l_total_wk_tax_credit pay_ie_tax_trailer_interface.total_wk_tax_credit%type;
2269: l_record_no pay_ie_tax_trailer_interface.record_no%type;
2270: --
2271: l_TC_TOT_YEARLY_TAX_CRED pay_ie_tax_trailer_interface.TC_TOT_YEARLY_TAX_CRED%type;
2272: l_TOT_YEARLY_TAX_RATE_1 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_1%type;
2273: l_TOT_YEARLY_TAX_RATE_2 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_2%type;
2274: l_TOT_MONTHLY_TAX_RATE_2 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_2%type;
2275: l_TOT_WEEKLY_TAX_RATE_2 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_2%type;
2276: l_TOT_YEARLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_3%type;

Line 2273: l_TOT_YEARLY_TAX_RATE_2 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_2%type;

2269: l_record_no pay_ie_tax_trailer_interface.record_no%type;
2270: --
2271: l_TC_TOT_YEARLY_TAX_CRED pay_ie_tax_trailer_interface.TC_TOT_YEARLY_TAX_CRED%type;
2272: l_TOT_YEARLY_TAX_RATE_1 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_1%type;
2273: l_TOT_YEARLY_TAX_RATE_2 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_2%type;
2274: l_TOT_MONTHLY_TAX_RATE_2 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_2%type;
2275: l_TOT_WEEKLY_TAX_RATE_2 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_2%type;
2276: l_TOT_YEARLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_3%type;
2277: l_TOT_MONTHLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_3%type;

Line 2274: l_TOT_MONTHLY_TAX_RATE_2 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_2%type;

2270: --
2271: l_TC_TOT_YEARLY_TAX_CRED pay_ie_tax_trailer_interface.TC_TOT_YEARLY_TAX_CRED%type;
2272: l_TOT_YEARLY_TAX_RATE_1 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_1%type;
2273: l_TOT_YEARLY_TAX_RATE_2 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_2%type;
2274: l_TOT_MONTHLY_TAX_RATE_2 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_2%type;
2275: l_TOT_WEEKLY_TAX_RATE_2 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_2%type;
2276: l_TOT_YEARLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_3%type;
2277: l_TOT_MONTHLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_3%type;
2278: l_TOT_WEEKLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_3%type;

Line 2275: l_TOT_WEEKLY_TAX_RATE_2 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_2%type;

2271: l_TC_TOT_YEARLY_TAX_CRED pay_ie_tax_trailer_interface.TC_TOT_YEARLY_TAX_CRED%type;
2272: l_TOT_YEARLY_TAX_RATE_1 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_1%type;
2273: l_TOT_YEARLY_TAX_RATE_2 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_2%type;
2274: l_TOT_MONTHLY_TAX_RATE_2 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_2%type;
2275: l_TOT_WEEKLY_TAX_RATE_2 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_2%type;
2276: l_TOT_YEARLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_3%type;
2277: l_TOT_MONTHLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_3%type;
2278: l_TOT_WEEKLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_3%type;
2279: l_TOT_YEARLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_4%type;

Line 2276: l_TOT_YEARLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_3%type;

2272: l_TOT_YEARLY_TAX_RATE_1 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_1%type;
2273: l_TOT_YEARLY_TAX_RATE_2 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_2%type;
2274: l_TOT_MONTHLY_TAX_RATE_2 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_2%type;
2275: l_TOT_WEEKLY_TAX_RATE_2 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_2%type;
2276: l_TOT_YEARLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_3%type;
2277: l_TOT_MONTHLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_3%type;
2278: l_TOT_WEEKLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_3%type;
2279: l_TOT_YEARLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_4%type;
2280: l_TOT_MONTHLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_4%type;

Line 2277: l_TOT_MONTHLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_3%type;

2273: l_TOT_YEARLY_TAX_RATE_2 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_2%type;
2274: l_TOT_MONTHLY_TAX_RATE_2 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_2%type;
2275: l_TOT_WEEKLY_TAX_RATE_2 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_2%type;
2276: l_TOT_YEARLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_3%type;
2277: l_TOT_MONTHLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_3%type;
2278: l_TOT_WEEKLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_3%type;
2279: l_TOT_YEARLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_4%type;
2280: l_TOT_MONTHLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_4%type;
2281: l_TOT_WEEKLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_4%type;

Line 2278: l_TOT_WEEKLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_3%type;

2274: l_TOT_MONTHLY_TAX_RATE_2 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_2%type;
2275: l_TOT_WEEKLY_TAX_RATE_2 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_2%type;
2276: l_TOT_YEARLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_3%type;
2277: l_TOT_MONTHLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_3%type;
2278: l_TOT_WEEKLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_3%type;
2279: l_TOT_YEARLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_4%type;
2280: l_TOT_MONTHLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_4%type;
2281: l_TOT_WEEKLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_4%type;
2282: l_TOT_YEARLY_USC_RATE_1 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_1%type;

Line 2279: l_TOT_YEARLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_4%type;

2275: l_TOT_WEEKLY_TAX_RATE_2 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_2%type;
2276: l_TOT_YEARLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_3%type;
2277: l_TOT_MONTHLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_3%type;
2278: l_TOT_WEEKLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_3%type;
2279: l_TOT_YEARLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_4%type;
2280: l_TOT_MONTHLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_4%type;
2281: l_TOT_WEEKLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_4%type;
2282: l_TOT_YEARLY_USC_RATE_1 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_1%type;
2283: l_TOT_YEARLY_USC_RATE_2 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_2%type;

Line 2280: l_TOT_MONTHLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_4%type;

2276: l_TOT_YEARLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_3%type;
2277: l_TOT_MONTHLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_3%type;
2278: l_TOT_WEEKLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_3%type;
2279: l_TOT_YEARLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_4%type;
2280: l_TOT_MONTHLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_4%type;
2281: l_TOT_WEEKLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_4%type;
2282: l_TOT_YEARLY_USC_RATE_1 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_1%type;
2283: l_TOT_YEARLY_USC_RATE_2 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_2%type;
2284: l_TOT_YEARLY_USC_RATE_3 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_3%type;

Line 2281: l_TOT_WEEKLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_4%type;

2277: l_TOT_MONTHLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_3%type;
2278: l_TOT_WEEKLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_3%type;
2279: l_TOT_YEARLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_4%type;
2280: l_TOT_MONTHLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_4%type;
2281: l_TOT_WEEKLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_4%type;
2282: l_TOT_YEARLY_USC_RATE_1 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_1%type;
2283: l_TOT_YEARLY_USC_RATE_2 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_2%type;
2284: l_TOT_YEARLY_USC_RATE_3 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_3%type;
2285: l_TOT_YEARLY_USC_RATE_4 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_4%type;

Line 2282: l_TOT_YEARLY_USC_RATE_1 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_1%type;

2278: l_TOT_WEEKLY_TAX_RATE_3 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_3%type;
2279: l_TOT_YEARLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_4%type;
2280: l_TOT_MONTHLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_4%type;
2281: l_TOT_WEEKLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_4%type;
2282: l_TOT_YEARLY_USC_RATE_1 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_1%type;
2283: l_TOT_YEARLY_USC_RATE_2 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_2%type;
2284: l_TOT_YEARLY_USC_RATE_3 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_3%type;
2285: l_TOT_YEARLY_USC_RATE_4 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_4%type;
2286: --

Line 2283: l_TOT_YEARLY_USC_RATE_2 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_2%type;

2279: l_TOT_YEARLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_YEARLY_TAX_RATE_4%type;
2280: l_TOT_MONTHLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_4%type;
2281: l_TOT_WEEKLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_4%type;
2282: l_TOT_YEARLY_USC_RATE_1 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_1%type;
2283: l_TOT_YEARLY_USC_RATE_2 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_2%type;
2284: l_TOT_YEARLY_USC_RATE_3 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_3%type;
2285: l_TOT_YEARLY_USC_RATE_4 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_4%type;
2286: --
2287:

Line 2284: l_TOT_YEARLY_USC_RATE_3 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_3%type;

2280: l_TOT_MONTHLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_MONTHLY_TAX_RATE_4%type;
2281: l_TOT_WEEKLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_4%type;
2282: l_TOT_YEARLY_USC_RATE_1 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_1%type;
2283: l_TOT_YEARLY_USC_RATE_2 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_2%type;
2284: l_TOT_YEARLY_USC_RATE_3 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_3%type;
2285: l_TOT_YEARLY_USC_RATE_4 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_4%type;
2286: --
2287:
2288: ------------

Line 2285: l_TOT_YEARLY_USC_RATE_4 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_4%type;

2281: l_TOT_WEEKLY_TAX_RATE_4 pay_ie_tax_trailer_interface.TOT_WEEKLY_TAX_RATE_4%type;
2282: l_TOT_YEARLY_USC_RATE_1 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_1%type;
2283: l_TOT_YEARLY_USC_RATE_2 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_2%type;
2284: l_TOT_YEARLY_USC_RATE_3 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_3%type;
2285: l_TOT_YEARLY_USC_RATE_4 pay_ie_tax_trailer_interface.TOT_YEARLY_USC_RATE_4%type;
2286: --
2287:
2288: ------------
2289: /* This function is used to read each assignment line and split the data into columns.

Line 2365: Delete from PAY_IE_TAX_TRAILER_INTERFACE;

2361:
2362: Begin
2363: Delete from PAY_IE_TAX_HEADER_INTERFACE;
2364: Delete from PAY_IE_TAX_BODY_INTERFACE;
2365: Delete from PAY_IE_TAX_TRAILER_INTERFACE;
2366: if sql%rowcount > 0 then
2367: commit;
2368: end if;
2369: exception

Line 2810: INSERT INTO PAY_IE_TAX_TRAILER_INTERFACE

2806: l_TOT_YEARLY_USC_RATE_4 := fnd_number.canonical_to_number(get_token(l_present_line,20));
2807: --
2808: --fnd_file.PUT_LINE(FND_FILE.LOG, '+++++++++TRAILER+++++++++');
2809:
2810: INSERT INTO PAY_IE_TAX_TRAILER_INTERFACE
2811: (
2812: RECORD_TYPE
2813: ,EMPLOYER_NUMBER
2814: ,RECORD_NO

Line 3028: , PAY_IE_TAX_TRAILER_INTERFACE pts

3024: , NVL(PTS.TOTAL_WK_RATE_CUTOFF,0) total_wk_cutoff
3025: , NVL(PTS.TOTAL_MTH_TAX_CREDIT,0) total_mth_credit
3026: , NVL(PTS.TOTAL_WK_TAX_CREDIT,0) total_wk_credit
3027: FROM PAY_IE_TAX_HEADER_INTERFACE phs
3028: , PAY_IE_TAX_TRAILER_INTERFACE pts
3029: WHERE PTS.EMPLOYER_NUMBER = p_employer_number
3030: AND PHS.TAX_YEAR = p_tax_year;
3031:
3032: l_error_stack VARCHAR2 (2000);

Line 3132: 'The value in pay_ie_tax_trailer_interface.record_no is '

3128: FND_FILE.PUT_LINE(fnd_file.log,
3129: 'The total number of record in pay_ie_tax_body_interface is '
3130: || TO_CHAR (l_count_mth_taxcredit));
3131: FND_FILE.PUT_LINE (fnd_file.log,
3132: 'The value in pay_ie_tax_trailer_interface.record_no is '
3133: || TO_CHAR(l_count_emp_recno));
3134: FND_FILE.PUT_LINE(fnd_file.log,
3135: 'Error - Retcode = 2, total number of record in pay_ie_tax_body_interface');
3136: FND_FILE.PUT_LINE(fnd_file.log,

Line 3137: 'does not match the value in pay_ie_tax_trailer_interface.record_no');

3133: || TO_CHAR(l_count_emp_recno));
3134: FND_FILE.PUT_LINE(fnd_file.log,
3135: 'Error - Retcode = 2, total number of record in pay_ie_tax_body_interface');
3136: FND_FILE.PUT_LINE(fnd_file.log,
3137: 'does not match the value in pay_ie_tax_trailer_interface.record_no');
3138: END IF;
3139:
3140: IF l_sum_mth_rate_cutoff <> l_total_mth_cutoff THEN
3141: FND_FILE.NEW_LINE(fnd_file.log, 1);

Line 3146: 'The total monthly cutoff in pay_ie_tax_trailer_interface.total_mth_rate_cutoff is '

3142: FND_FILE.PUT_LINE(fnd_file.log,
3143: 'The sum of pay_ie_tax_body_interface.mth_rate_cutoff is '
3144: || TO_CHAR (l_sum_mth_rate_cutoff));
3145: FND_FILE.PUT_LINE (fnd_file.log,
3146: 'The total monthly cutoff in pay_ie_tax_trailer_interface.total_mth_rate_cutoff is '
3147: || TO_CHAR(l_total_mth_cutoff));
3148: FND_FILE.PUT_LINE(fnd_file.log,
3149: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.mth_rate_cutoff');
3150: FND_FILE.PUT_LINE(fnd_file.log,

Line 3151: 'does not match the total monthly cutoff in pay_ie_tax_trailer_interface.total_mth_rate_cutoff');

3147: || TO_CHAR(l_total_mth_cutoff));
3148: FND_FILE.PUT_LINE(fnd_file.log,
3149: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.mth_rate_cutoff');
3150: FND_FILE.PUT_LINE(fnd_file.log,
3151: 'does not match the total monthly cutoff in pay_ie_tax_trailer_interface.total_mth_rate_cutoff');
3152: END IF;
3153: IF l_sum_wk_rate_cutoff <> l_total_wk_cutoff THEN
3154: FND_FILE.NEW_LINE(fnd_file.log, 1);
3155: FND_FILE.PUT_LINE(fnd_file.log,

Line 3159: 'The total weekly cutoff in pay_ie_tax_trailer_interface.total_wk_rate_cutoff is '

3155: FND_FILE.PUT_LINE(fnd_file.log,
3156: 'The sum of pay_ie_tax_body_interface.wk_rate_cutoff is '
3157: || TO_CHAR(l_sum_wk_rate_cutoff));
3158: FND_FILE.PUT_LINE(fnd_file.log,
3159: 'The total weekly cutoff in pay_ie_tax_trailer_interface.total_wk_rate_cutoff is '
3160: || TO_CHAR(l_total_wk_cutoff));
3161: FND_FILE.PUT_LINE(fnd_file.log,
3162: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.wk_rate_cutoff');
3163: FND_FILE.PUT_LINE(fnd_file.log,

Line 3164: 'does not match the the total weekly cutoff in pay_ie_tax_trailer_interface.total_wk_rate_cutoff');

3160: || TO_CHAR(l_total_wk_cutoff));
3161: FND_FILE.PUT_LINE(fnd_file.log,
3162: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.wk_rate_cutoff');
3163: FND_FILE.PUT_LINE(fnd_file.log,
3164: 'does not match the the total weekly cutoff in pay_ie_tax_trailer_interface.total_wk_rate_cutoff');
3165: END IF;
3166: IF l_sum_mth_tax_credit <> l_total_mth_credit THEN
3167: FND_FILE.NEW_LINE(fnd_file.log, 1);
3168: FND_FILE.PUT_LINE(fnd_file.log,

Line 3172: 'The total monthly credit in pay_ie_tax_trailer_interface.total_mth_tax_credit is '

3168: FND_FILE.PUT_LINE(fnd_file.log,
3169: 'The sum of pay_ie_tax_body_interface.mth_tax_credit is '
3170: || TO_CHAR(l_sum_mth_tax_credit));
3171: FND_FILE.PUT_LINE(fnd_file.log,
3172: 'The total monthly credit in pay_ie_tax_trailer_interface.total_mth_tax_credit is '
3173: || TO_CHAR(l_total_mth_credit));
3174: FND_FILE.PUT_LINE(fnd_file.log,
3175: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.mth_tax_credit');
3176: FND_FILE.PUT_LINE(fnd_file.log,

Line 3177: 'does not match the total monthly credit in pay_ie_tax_trailer_interface.total_mth_tax_credit');

3173: || TO_CHAR(l_total_mth_credit));
3174: FND_FILE.PUT_LINE(fnd_file.log,
3175: 'Error - Retcode = 2, the sum of pay_ie_tax_body_interface.mth_tax_credit');
3176: FND_FILE.PUT_LINE(fnd_file.log,
3177: 'does not match the total monthly credit in pay_ie_tax_trailer_interface.total_mth_tax_credit');
3178: END IF;
3179: IF BodyRec.sum_wk_tax_credit <> TrailRec.total_wk_credit THEN
3180: FND_FILE.NEW_LINE(fnd_file.log, 1);
3181: FND_FILE.PUT_LINE(fnd_file.log,

Line 3185: 'The total weekly credit in pay_ie_tax_trailer_interface.total_wk_tax_credit is '

3181: FND_FILE.PUT_LINE(fnd_file.log,
3182: 'The sum of pay_ie_tax_body_interface.wk_tax_credit is '
3183: || TO_CHAR(l_sum_wk_tax_credit));
3184: FND_FILE.PUT_LINE(fnd_file.log,
3185: 'The total weekly credit in pay_ie_tax_trailer_interface.total_wk_tax_credit is '
3186: || TO_CHAR(l_total_wk_credit));
3187: FND_FILE.PUT_LINE(fnd_file.log,
3188: 'Error - Retcode = 2 because the sum of pay_ie_tax_body_interface.wk_tax_credit');
3189: FND_FILE.PUT_LINE(fnd_file.log,

Line 3190: 'does not match the total weekly credit in pay_ie_tax_trailer_interface.total_wk_tax_credit');

3186: || TO_CHAR(l_total_wk_credit));
3187: FND_FILE.PUT_LINE(fnd_file.log,
3188: 'Error - Retcode = 2 because the sum of pay_ie_tax_body_interface.wk_tax_credit');
3189: FND_FILE.PUT_LINE(fnd_file.log,
3190: 'does not match the total weekly credit in pay_ie_tax_trailer_interface.total_wk_tax_credit');
3191: END IF;
3192:
3193: INSERT INTO pay_ie_tax_error ( pps_number
3194: , employee_number

Line 3217: wing tables: pay_ie_tax_header_interface, pay_ie_tax_body_interface, pay_ie_tax_trailer_interface');

3213: l_error_stack := errbuf;
3214: l_error := SQLERRM;
3215: retcode := 2;
3216: FND_FILE.PUT_LINE (fnd_file.log, 'Error raised in loading data into one or all of the follo
3217: wing tables: pay_ie_tax_header_interface, pay_ie_tax_body_interface, pay_ie_tax_trailer_interface');
3218:
3219: INSERT INTO pay_ie_tax_error ( pps_number
3220: , employee_number
3221: , full_name