DBA Data[Home] [Help]

APPS.PAY_US_EMP_DT_TAX_VAL dependencies on FND_MESSAGE

Line 617: fnd_message.set_name ('PAY', 'PAY_52282_FUTR_LOC_CHNG_EXISTS');

613: NULL;
614: else
615: if l_location_id <> p_new_location_id then
616: check_payroll_enabled := 0;
617: fnd_message.set_name ('PAY', 'PAY_52282_FUTR_LOC_CHNG_EXISTS');
618: fnd_message.set_token('current_location_id',p_new_location_code);
619: app_exception.raise_exception; /* raise error message */
620: else
621: check_payroll_enabled := 1;

Line 618: fnd_message.set_token('current_location_id',p_new_location_code);

614: else
615: if l_location_id <> p_new_location_id then
616: check_payroll_enabled := 0;
617: fnd_message.set_name ('PAY', 'PAY_52282_FUTR_LOC_CHNG_EXISTS');
618: fnd_message.set_token('current_location_id',p_new_location_code);
619: app_exception.raise_exception; /* raise error message */
620: else
621: check_payroll_enabled := 1;
622: end if;

Line 639: fnd_message.set_name ('PAY', 'PAY_52282_FUTR_LOC_CHNG_EXISTS');

635: exit;
636: else
637: if l_location_id <> p_new_location_id then
638: check_payroll_enabled := 0;
639: fnd_message.set_name ('PAY', 'PAY_52282_FUTR_LOC_CHNG_EXISTS');
640: fnd_message.set_token('current_location_id',p_new_location_code);
641: app_exception.raise_exception; /* raise error message */
642: close csr_get_next_locations;
643: exit;

Line 640: fnd_message.set_token('current_location_id',p_new_location_code);

636: else
637: if l_location_id <> p_new_location_id then
638: check_payroll_enabled := 0;
639: fnd_message.set_name ('PAY', 'PAY_52282_FUTR_LOC_CHNG_EXISTS');
640: fnd_message.set_token('current_location_id',p_new_location_code);
641: app_exception.raise_exception; /* raise error message */
642: close csr_get_next_locations;
643: exit;
644: end if;

Line 671: fnd_message.set_name('PAY', 'PAY_52388_SUI_TAX_LOC_CHNG') ;

667: -- This is being added as part of SUI Wage Base Override enh
668: -- Turning Off SUI Wage Base Override Functionality due to Bug# 5486281
669: /*
670: if l_work_state_code <> l_new_work_state_code then
671: fnd_message.set_name('PAY', 'PAY_52388_SUI_TAX_LOC_CHNG') ;
672: l_returned_warning1 := fnd_message.get ;
673: end if ;
674: */
675:

Line 672: l_returned_warning1 := fnd_message.get ;

668: -- Turning Off SUI Wage Base Override Functionality due to Bug# 5486281
669: /*
670: if l_work_state_code <> l_new_work_state_code then
671: fnd_message.set_name('PAY', 'PAY_52388_SUI_TAX_LOC_CHNG') ;
672: l_returned_warning1 := fnd_message.get ;
673: end if ;
674: */
675:
676: open csr_chk_fed_row;

Line 699: fnd_message.set_name ('PAY', 'PAY_52232_TAX_LOC_CHNG');

695: fetch csr_chk_payroll into l_code;
696:
697: if csr_chk_payroll%FOUND then
698: hr_utility.set_location('pay_us_emp_tax_rules.check_payroll_run - payroll found',5);
699: fnd_message.set_name ('PAY', 'PAY_52232_TAX_LOC_CHNG');
700: l_returned_warning := fnd_message.get;
701: close csr_chk_payroll;
702: else
703: hr_utility.set_location('pay_us_emp_tax_rules.check_payroll_run - No payroll run',6);

Line 700: l_returned_warning := fnd_message.get;

696:
697: if csr_chk_payroll%FOUND then
698: hr_utility.set_location('pay_us_emp_tax_rules.check_payroll_run - payroll found',5);
699: fnd_message.set_name ('PAY', 'PAY_52232_TAX_LOC_CHNG');
700: l_returned_warning := fnd_message.get;
701: close csr_chk_payroll;
702: else
703: hr_utility.set_location('pay_us_emp_tax_rules.check_payroll_run - No payroll run',6);
704: fnd_message.set_name ('PAY', 'PAY_52233_TAX_LOC_CHNG_OVRD');

Line 704: fnd_message.set_name ('PAY', 'PAY_52233_TAX_LOC_CHNG_OVRD');

700: l_returned_warning := fnd_message.get;
701: close csr_chk_payroll;
702: else
703: hr_utility.set_location('pay_us_emp_tax_rules.check_payroll_run - No payroll run',6);
704: fnd_message.set_name ('PAY', 'PAY_52233_TAX_LOC_CHNG_OVRD');
705: l_returned_warning := fnd_message.get;
706: close csr_chk_payroll;
707: end if; /* End csr_chk_payroll%found */
708: end if; /* End check_payroll_run_enabled=1 */

Line 705: l_returned_warning := fnd_message.get;

701: close csr_chk_payroll;
702: else
703: hr_utility.set_location('pay_us_emp_tax_rules.check_payroll_run - No payroll run',6);
704: fnd_message.set_name ('PAY', 'PAY_52233_TAX_LOC_CHNG_OVRD');
705: l_returned_warning := fnd_message.get;
706: close csr_chk_payroll;
707: end if; /* End csr_chk_payroll%found */
708: end if; /* End check_payroll_run_enabled=1 */
709: else

Line 1524: fnd_message.set_name ('PAY', 'PAY_52300_TAX_SD_ASGN');

1520: open chk_ins_sd;
1521: fetch chk_ins_sd into l_code;
1522:
1523: if chk_ins_sd%FOUND then
1524: fnd_message.set_name ('PAY', 'PAY_52300_TAX_SD_ASGN');
1525: fnd_message.raise_error;
1526: end if;
1527:
1528: close chk_ins_sd;

Line 1525: fnd_message.raise_error;

1521: fetch chk_ins_sd into l_code;
1522:
1523: if chk_ins_sd%FOUND then
1524: fnd_message.set_name ('PAY', 'PAY_52300_TAX_SD_ASGN');
1525: fnd_message.raise_error;
1526: end if;
1527:
1528: close chk_ins_sd;
1529:

Line 1536: fnd_message.set_name ('PAY', 'PAY_52300_TAX_SD_ASGN');

1532: open chk_upd_sd;
1533: fetch chk_upd_sd into l_code;
1534:
1535: if chk_upd_sd%FOUND then
1536: fnd_message.set_name ('PAY', 'PAY_52300_TAX_SD_ASGN');
1537: fnd_message.raise_error;
1538: end if;
1539:
1540: close chk_upd_sd;

Line 1537: fnd_message.raise_error;

1533: fetch chk_upd_sd into l_code;
1534:
1535: if chk_upd_sd%FOUND then
1536: fnd_message.set_name ('PAY', 'PAY_52300_TAX_SD_ASGN');
1537: fnd_message.raise_error;
1538: end if;
1539:
1540: close chk_upd_sd;
1541:

Line 1583: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

1579: l_curr_eff_start_dt,
1580: l_curr_eff_end_dt;
1581:
1582: if csr_get_curr_loc%NOTFOUND then
1583: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1584: fnd_message.set_token('PROCEDURE',
1585: 'pay_us_emp_dt_tax_rules.check_locations');
1586: fnd_message.set_token('STEP','1');
1587: fnd_message.raise_error;

Line 1584: fnd_message.set_token('PROCEDURE',

1580: l_curr_eff_end_dt;
1581:
1582: if csr_get_curr_loc%NOTFOUND then
1583: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1584: fnd_message.set_token('PROCEDURE',
1585: 'pay_us_emp_dt_tax_rules.check_locations');
1586: fnd_message.set_token('STEP','1');
1587: fnd_message.raise_error;
1588: close csr_get_curr_loc;

Line 1586: fnd_message.set_token('STEP','1');

1582: if csr_get_curr_loc%NOTFOUND then
1583: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1584: fnd_message.set_token('PROCEDURE',
1585: 'pay_us_emp_dt_tax_rules.check_locations');
1586: fnd_message.set_token('STEP','1');
1587: fnd_message.raise_error;
1588: close csr_get_curr_loc;
1589:
1590: end if;

Line 1587: fnd_message.raise_error;

1583: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1584: fnd_message.set_token('PROCEDURE',
1585: 'pay_us_emp_dt_tax_rules.check_locations');
1586: fnd_message.set_token('STEP','1');
1587: fnd_message.raise_error;
1588: close csr_get_curr_loc;
1589:
1590: end if;
1591:

Line 1884: fnd_message.set_name('PAY', 'PAY_52293_TAX_STDEL_LOC');

1880:
1881: if p_state_code is not null and p_county_code is null
1882: and p_city_code is null then
1883:
1884: fnd_message.set_name('PAY', 'PAY_52293_TAX_STDEL_LOC');
1885: fnd_message.raise_error;
1886:
1887: elsif p_state_code is not null and p_county_code is not null
1888: and p_city_code is null then

Line 1885: fnd_message.raise_error;

1881: if p_state_code is not null and p_county_code is null
1882: and p_city_code is null then
1883:
1884: fnd_message.set_name('PAY', 'PAY_52293_TAX_STDEL_LOC');
1885: fnd_message.raise_error;
1886:
1887: elsif p_state_code is not null and p_county_code is not null
1888: and p_city_code is null then
1889:

Line 1890: fnd_message.set_name('PAY', 'PAY_52294_TAX_CODEL_LOC');

1886:
1887: elsif p_state_code is not null and p_county_code is not null
1888: and p_city_code is null then
1889:
1890: fnd_message.set_name('PAY', 'PAY_52294_TAX_CODEL_LOC');
1891: fnd_message.raise_error;
1892:
1893: elsif p_state_code is not null and p_county_code is not null
1894: and p_city_code is not null then

Line 1891: fnd_message.raise_error;

1887: elsif p_state_code is not null and p_county_code is not null
1888: and p_city_code is null then
1889:
1890: fnd_message.set_name('PAY', 'PAY_52294_TAX_CODEL_LOC');
1891: fnd_message.raise_error;
1892:
1893: elsif p_state_code is not null and p_county_code is not null
1894: and p_city_code is not null then
1895:

Line 1896: fnd_message.set_name('PAY', 'PAY_52295_TAX_CIEL_LOC');

1892:
1893: elsif p_state_code is not null and p_county_code is not null
1894: and p_city_code is not null then
1895:
1896: fnd_message.set_name('PAY', 'PAY_52295_TAX_CIEL_LOC');
1897: fnd_message.raise_error;
1898:
1899: end if;
1900:

Line 1897: fnd_message.raise_error;

1893: elsif p_state_code is not null and p_county_code is not null
1894: and p_city_code is not null then
1895:
1896: fnd_message.set_name('PAY', 'PAY_52295_TAX_CIEL_LOC');
1897: fnd_message.raise_error;
1898:
1899: end if;
1900:
1901: elsif l_ret_code = 2 then

Line 1906: fnd_message.set_name('PAY', 'PAY_76860_TAX_STDEL_TAX_LOC');

1902:
1903: if p_state_code is not null and p_county_code is null
1904: and p_city_code is null then
1905:
1906: fnd_message.set_name('PAY', 'PAY_76860_TAX_STDEL_TAX_LOC');
1907: fnd_message.raise_error;
1908:
1909: elsif p_state_code is not null and p_county_code is not null
1910: and p_city_code is null then

Line 1907: fnd_message.raise_error;

1903: if p_state_code is not null and p_county_code is null
1904: and p_city_code is null then
1905:
1906: fnd_message.set_name('PAY', 'PAY_76860_TAX_STDEL_TAX_LOC');
1907: fnd_message.raise_error;
1908:
1909: elsif p_state_code is not null and p_county_code is not null
1910: and p_city_code is null then
1911:

Line 1912: fnd_message.set_name('PAY', 'PAY_76861_TAX_CODEL_TAX_LOC');

1908:
1909: elsif p_state_code is not null and p_county_code is not null
1910: and p_city_code is null then
1911:
1912: fnd_message.set_name('PAY', 'PAY_76861_TAX_CODEL_TAX_LOC');
1913: fnd_message.raise_error;
1914:
1915: elsif p_state_code is not null and p_county_code is not null
1916: and p_city_code is not null then

Line 1913: fnd_message.raise_error;

1909: elsif p_state_code is not null and p_county_code is not null
1910: and p_city_code is null then
1911:
1912: fnd_message.set_name('PAY', 'PAY_76861_TAX_CODEL_TAX_LOC');
1913: fnd_message.raise_error;
1914:
1915: elsif p_state_code is not null and p_county_code is not null
1916: and p_city_code is not null then
1917:

Line 1918: fnd_message.set_name('PAY', 'PAY_76862_TAX_CIDEL_TAX_LOC');

1914:
1915: elsif p_state_code is not null and p_county_code is not null
1916: and p_city_code is not null then
1917:
1918: fnd_message.set_name('PAY', 'PAY_76862_TAX_CIDEL_TAX_LOC');
1919: fnd_message.raise_error;
1920:
1921: end if;
1922:

Line 1919: fnd_message.raise_error;

1915: elsif p_state_code is not null and p_county_code is not null
1916: and p_city_code is not null then
1917:
1918: fnd_message.set_name('PAY', 'PAY_76862_TAX_CIDEL_TAX_LOC');
1919: fnd_message.raise_error;
1920:
1921: end if;
1922:
1923: end if;

Line 1947: /* fnd_message.set_name('Cannot delete. State assigned to resident address') */

1943:
1944: if p_state_code is not null and p_county_code is null
1945: and p_city_code is null then
1946:
1947: /* fnd_message.set_name('Cannot delete. State assigned to resident address') */
1948: fnd_message.set_name('PAY', 'PAY_52296_TAX_STDEL_RES');
1949: fnd_message.raise_error;
1950:
1951: elsif p_state_code is not null and p_county_code is not null

Line 1948: fnd_message.set_name('PAY', 'PAY_52296_TAX_STDEL_RES');

1944: if p_state_code is not null and p_county_code is null
1945: and p_city_code is null then
1946:
1947: /* fnd_message.set_name('Cannot delete. State assigned to resident address') */
1948: fnd_message.set_name('PAY', 'PAY_52296_TAX_STDEL_RES');
1949: fnd_message.raise_error;
1950:
1951: elsif p_state_code is not null and p_county_code is not null
1952: and p_city_code is null then

Line 1949: fnd_message.raise_error;

1945: and p_city_code is null then
1946:
1947: /* fnd_message.set_name('Cannot delete. State assigned to resident address') */
1948: fnd_message.set_name('PAY', 'PAY_52296_TAX_STDEL_RES');
1949: fnd_message.raise_error;
1950:
1951: elsif p_state_code is not null and p_county_code is not null
1952: and p_city_code is null then
1953:

Line 1954: /* fnd_message.set_name('Cannot delete. County assigned to resident address') */

1950:
1951: elsif p_state_code is not null and p_county_code is not null
1952: and p_city_code is null then
1953:
1954: /* fnd_message.set_name('Cannot delete. County assigned to resident address') */
1955: fnd_message.set_name('PAY', 'PAY_52297_TAX_CODEL_RES');
1956: fnd_message.raise_error;
1957:
1958: elsif p_state_code is not null and p_county_code is not null

Line 1955: fnd_message.set_name('PAY', 'PAY_52297_TAX_CODEL_RES');

1951: elsif p_state_code is not null and p_county_code is not null
1952: and p_city_code is null then
1953:
1954: /* fnd_message.set_name('Cannot delete. County assigned to resident address') */
1955: fnd_message.set_name('PAY', 'PAY_52297_TAX_CODEL_RES');
1956: fnd_message.raise_error;
1957:
1958: elsif p_state_code is not null and p_county_code is not null
1959: and p_city_code is not null then

Line 1956: fnd_message.raise_error;

1952: and p_city_code is null then
1953:
1954: /* fnd_message.set_name('Cannot delete. County assigned to resident address') */
1955: fnd_message.set_name('PAY', 'PAY_52297_TAX_CODEL_RES');
1956: fnd_message.raise_error;
1957:
1958: elsif p_state_code is not null and p_county_code is not null
1959: and p_city_code is not null then
1960:

Line 1961: /* fnd_message.set_name('Cannot delete. City assigned to resident address') */

1957:
1958: elsif p_state_code is not null and p_county_code is not null
1959: and p_city_code is not null then
1960:
1961: /* fnd_message.set_name('Cannot delete. City assigned to resident address') */
1962: fnd_message.set_name('PAY', 'PAY_52298_TAX_CIDEL_RES');
1963: fnd_message.raise_error;
1964:
1965: end if;

Line 1962: fnd_message.set_name('PAY', 'PAY_52298_TAX_CIDEL_RES');

1958: elsif p_state_code is not null and p_county_code is not null
1959: and p_city_code is not null then
1960:
1961: /* fnd_message.set_name('Cannot delete. City assigned to resident address') */
1962: fnd_message.set_name('PAY', 'PAY_52298_TAX_CIDEL_RES');
1963: fnd_message.raise_error;
1964:
1965: end if;
1966:

Line 1963: fnd_message.raise_error;

1959: and p_city_code is not null then
1960:
1961: /* fnd_message.set_name('Cannot delete. City assigned to resident address') */
1962: fnd_message.set_name('PAY', 'PAY_52298_TAX_CIDEL_RES');
1963: fnd_message.raise_error;
1964:
1965: end if;
1966:
1967: end if;

Line 1989: /* fnd_message.set_name('Cannot delete. Payroll has been run ') */

1985:
1986: if p_state_code is not null and p_county_code is null
1987: and p_city_code is null then
1988:
1989: /* fnd_message.set_name('Cannot delete. Payroll has been run ') */
1990: fnd_message.set_name('PAY', 'PAY_52235_TAX_RULE_DELETE');
1991: fnd_message.raise_error;
1992:
1993: elsif p_state_code is not null and p_county_code is not null

Line 1990: fnd_message.set_name('PAY', 'PAY_52235_TAX_RULE_DELETE');

1986: if p_state_code is not null and p_county_code is null
1987: and p_city_code is null then
1988:
1989: /* fnd_message.set_name('Cannot delete. Payroll has been run ') */
1990: fnd_message.set_name('PAY', 'PAY_52235_TAX_RULE_DELETE');
1991: fnd_message.raise_error;
1992:
1993: elsif p_state_code is not null and p_county_code is not null
1994: and p_city_code is null then

Line 1991: fnd_message.raise_error;

1987: and p_city_code is null then
1988:
1989: /* fnd_message.set_name('Cannot delete. Payroll has been run ') */
1990: fnd_message.set_name('PAY', 'PAY_52235_TAX_RULE_DELETE');
1991: fnd_message.raise_error;
1992:
1993: elsif p_state_code is not null and p_county_code is not null
1994: and p_city_code is null then
1995:

Line 1996: /* fnd_message.set_name('Cannot delete. Payroll has been run ') */

1992:
1993: elsif p_state_code is not null and p_county_code is not null
1994: and p_city_code is null then
1995:
1996: /* fnd_message.set_name('Cannot delete. Payroll has been run ') */
1997: fnd_message.set_name('PAY', 'PAY_52235_TAX_RULE_DELETE');
1998: fnd_message.raise_error;
1999:
2000: elsif p_state_code is not null and p_county_code is not null

Line 1997: fnd_message.set_name('PAY', 'PAY_52235_TAX_RULE_DELETE');

1993: elsif p_state_code is not null and p_county_code is not null
1994: and p_city_code is null then
1995:
1996: /* fnd_message.set_name('Cannot delete. Payroll has been run ') */
1997: fnd_message.set_name('PAY', 'PAY_52235_TAX_RULE_DELETE');
1998: fnd_message.raise_error;
1999:
2000: elsif p_state_code is not null and p_county_code is not null
2001: and p_city_code is not null then

Line 1998: fnd_message.raise_error;

1994: and p_city_code is null then
1995:
1996: /* fnd_message.set_name('Cannot delete. Payroll has been run ') */
1997: fnd_message.set_name('PAY', 'PAY_52235_TAX_RULE_DELETE');
1998: fnd_message.raise_error;
1999:
2000: elsif p_state_code is not null and p_county_code is not null
2001: and p_city_code is not null then
2002:

Line 2003: /* fnd_message.set_name('Cannot delete. Payroll has been run ') */

1999:
2000: elsif p_state_code is not null and p_county_code is not null
2001: and p_city_code is not null then
2002:
2003: /* fnd_message.set_name('Cannot delete. Payroll has been run ') */
2004: fnd_message.set_name('PAY', 'PAY_52235_TAX_RULE_DELETE');
2005: fnd_message.raise_error;
2006:
2007: end if;

Line 2004: fnd_message.set_name('PAY', 'PAY_52235_TAX_RULE_DELETE');

2000: elsif p_state_code is not null and p_county_code is not null
2001: and p_city_code is not null then
2002:
2003: /* fnd_message.set_name('Cannot delete. Payroll has been run ') */
2004: fnd_message.set_name('PAY', 'PAY_52235_TAX_RULE_DELETE');
2005: fnd_message.raise_error;
2006:
2007: end if;
2008:

Line 2005: fnd_message.raise_error;

2001: and p_city_code is not null then
2002:
2003: /* fnd_message.set_name('Cannot delete. Payroll has been run ') */
2004: fnd_message.set_name('PAY', 'PAY_52235_TAX_RULE_DELETE');
2005: fnd_message.raise_error;
2006:
2007: end if;
2008:
2009: end if;