1840: l_message VARCHAR2(1000);
1841: l_module_name VARCHAR2(200) := g_module_name || 'FEDERAL_ID_NUMBER';
1842: l_org_id number;
1843: l_org_name hr_all_organization_units.name%TYPE;
1844: l_fed_employer_id_number fv_operating_units_all.fed_employer_id_number%TYPE;
1845:
1846: BEGIN
1847: x_error_code := g_SUCCESS;
1848:
1859:
1860:
1861: select fed_employer_id_number
1862: into l_fed_employer_id_number
1863: from fv_operating_units_all
1864: where org_id = l_org_id;
1865:
1866: IF l_fed_employer_id_number IS NULL THEN -- l_fed_employer_id_number should not be null
1867: