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_GB_MOVDED_EDI dependencies on PAY_GB_EOY_MAGTAPE

Line 187: if pay_gb_eoy_magtape.validate_input(UPPER(p_value),p_mode) > 0 then

183: p_mode in varchar2) return boolean IS
184: l_proc CONSTANT VARCHAR2(50):= g_package||'validate_data';
185: BEGIN
186: hr_utility.set_location('Entering: '||l_proc,1);
187: if pay_gb_eoy_magtape.validate_input(UPPER(p_value),p_mode) > 0 then
188: hr_utility.set_location('Name/Value : ' || p_name || '/' || p_value ,10);
189: pay_core_utils.push_message(800, 'HR_78057_GB_MAGTAPE_VAILDATION', 'F');
190: pay_core_utils.push_token('INPUT_NAME', p_name);
191: pay_core_utils.push_token('INPUT_VALUE', p_value);

Line 1640: and pay_gb_eoy_magtape.validate_input(l_assignment_number,'P14_FULL_EDI') > 0) THEN

1636: edi_validation_fail := 'Y';
1637: END IF;
1638:
1639: IF ((l_assignment_number <> ' ' OR l_assignment_number IS NOT NULL)
1640: and pay_gb_eoy_magtape.validate_input(l_assignment_number,'P14_FULL_EDI') > 0) THEN
1641: populate_run_msg(p_assactid,' Assignment Number has invalid character(s).' || l_assignment_number);
1642: fnd_file.put_line (fnd_file.LOG,' : The Assignment Number has invalid character(s). ' || l_assignment_number);
1643: edi_validation_fail := 'Y';
1644: END IF;

Line 1676: l_msg_value := pay_gb_eoy_magtape.validate_tax_code_yrfil(p_assactid,l_tax_code_in_use,l_eff_date);

1672: l_eff_date := trunc (l_eff_date);
1673: hr_utility.trace('l_eff_date = '|| l_eff_date);
1674: --Modifications for the bug fix 10409668 ends here
1675:
1676: l_msg_value := pay_gb_eoy_magtape.validate_tax_code_yrfil(p_assactid,l_tax_code_in_use,l_eff_date);
1677:
1678: IF (l_tax_code_in_use <> ' ' OR l_tax_code_in_use IS NOT NULL)
1679: AND (l_msg_value <> ' ') THEN
1680: populate_run_msg(p_assactid, l_msg_value || 'tax code, ' || l_tax_code_in_use || ', for assignment ' || l_assignment_number);

Line 1885: ELSIF pay_gb_eoy_magtape.validate_input(l_address_line1,'P14_FULL_EDI') > 0 THEN

1881: populate_run_msg(p_assactid,'The Address Line 1 of the assignment ' || l_assignment_number || ' is missing.');
1882: fnd_file.put_line (fnd_file.LOG,' : The Address Line 1 of the assignment ' || l_assignment_number || ' is missing.');
1883: edi_validation_fail := 'Y';
1884: l_count_missing_val := l_count_missing_val + 1;
1885: ELSIF pay_gb_eoy_magtape.validate_input(l_address_line1,'P14_FULL_EDI') > 0 THEN
1886: populate_run_msg(p_assactid,'The Address Line 1 ' || l_address_line1 || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1887: fnd_file.put_line (fnd_file.LOG,' : The Address Line 1 ' || l_address_line1 || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1888: edi_validation_fail := 'Y';
1889: l_count_char_errors := l_count_char_errors + 1;

Line 1897: ELSIF pay_gb_eoy_magtape.validate_input(l_address_line2,'P14_FULL_EDI') > 0 THEN

1893: populate_run_msg(p_assactid,'The Address Line 2 of the assignment ' || l_assignment_number || ' is missing.');
1894: fnd_file.put_line (fnd_file.LOG,' : The Address Line 2 of the assignment ' || l_assignment_number || ' is missing.');
1895: edi_validation_fail := 'Y';
1896: l_count_missing_val := l_count_missing_val + 1;
1897: ELSIF pay_gb_eoy_magtape.validate_input(l_address_line2,'P14_FULL_EDI') > 0 THEN
1898: populate_run_msg(p_assactid,'The Address Line 2 ' || l_address_line2 || ' of the assignment '|| l_assignment_number || ' has invalid character(s).');
1899: fnd_file.put_line (fnd_file.LOG,' : The Address Line 2 ' || l_address_line2 || ' of the assignment '|| l_assignment_number || ' has invalid character(s).');
1900: edi_validation_fail := 'Y';
1901: l_count_char_errors := l_count_char_errors + 1;

Line 1905: IF pay_gb_eoy_magtape.validate_input(l_address_line3,'P14_FULL_EDI') > 0 THEN

1901: l_count_char_errors := l_count_char_errors + 1;
1902: END IF;
1903:
1904: IF l_address_line3 <> ' ' OR l_address_line3 IS NOT NULL THEN
1905: IF pay_gb_eoy_magtape.validate_input(l_address_line3,'P14_FULL_EDI') > 0 THEN
1906: populate_run_msg(p_assactid,'The Address Line 3 ' || l_address_line3 || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1907: fnd_file.put_line (fnd_file.LOG,' : The Address Line 3 ' || l_address_line3 || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1908: edi_validation_fail := 'Y';
1909: l_count_char_errors := l_count_char_errors + 1;

Line 1914: IF pay_gb_eoy_magtape.validate_input(l_town_or_city,'P14_FULL_EDI') > 0 THEN

1910: END IF;
1911: END IF;
1912:
1913: IF l_town_or_city <> ' ' OR l_town_or_city IS NOT NULL THEN
1914: IF pay_gb_eoy_magtape.validate_input(l_town_or_city,'P14_FULL_EDI') > 0 THEN
1915: populate_run_msg(p_assactid,'The Town Or City ' || l_town_or_city || ' of the assignment '|| l_assignment_number || ' has invalid character(s).');
1916: fnd_file.put_line (fnd_file.LOG,' : The Town Or City ' || l_town_or_city ||' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1917: edi_validation_fail := 'Y';
1918: l_count_char_errors := l_count_char_errors + 1;

Line 1923: IF pay_gb_eoy_magtape.validate_input(l_county,'P14_FULL_EDI') > 0 THEN

1919: END IF;
1920: END IF;
1921:
1922: IF l_county <> ' ' OR l_county IS NOT NULL THEN
1923: IF pay_gb_eoy_magtape.validate_input(l_county,'P14_FULL_EDI') > 0 THEN
1924: populate_run_msg(p_assactid,'The County ' || l_county || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1925: fnd_file.put_line (fnd_file.LOG,' : The County ' || l_county || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1926: edi_validation_fail := 'Y';
1927: l_count_char_errors := l_count_char_errors + 1;

Line 1936: elsif pay_gb_eoy_magtape.validate_input(l_last_name,'P45_46_LAST_NAME') > 0 then

1932: populate_run_msg(p_assactid,'The Last Name of the assignment ' || l_assignment_number || ' is missing.');
1933: fnd_file.put_line (fnd_file.LOG,' : The Last Name of the assignment '|| l_assignment_number || ' is missing.');
1934: edi_validation_fail := 'Y';
1935: l_count_missing_val := l_count_missing_val + 1;
1936: elsif pay_gb_eoy_magtape.validate_input(l_last_name,'P45_46_LAST_NAME') > 0 then
1937: populate_run_msg(p_assactid,'The Last Name ' || l_last_name || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1938: fnd_file.put_line (fnd_file.LOG,' : The Last Name ' + l_last_name || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1939: edi_validation_fail := 'Y';
1940: l_count_char_errors := l_count_char_errors + 1;

Line 1949: ELSIF pay_gb_eoy_magtape.validate_input(l_first_name,'P45_46_FIRST_NAME') > 0 THEN

1945: fnd_file.put_line (fnd_file.LOG,' : The First Name of the assignment ' || l_assignment_number || ' is missing.');
1946: edi_validation_fail := 'Y';
1947: l_count_missing_val := l_count_missing_val + 1;
1948:
1949: ELSIF pay_gb_eoy_magtape.validate_input(l_first_name,'P45_46_FIRST_NAME') > 0 THEN
1950: populate_run_msg(p_assactid,'The First Name ' || l_first_name ||' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1951: fnd_file.put_line (fnd_file.LOG,' : The First Name ' || l_first_name || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1952: edi_validation_fail := 'Y';
1953: l_count_char_errors := l_count_char_errors + 1;

Line 1957: IF pay_gb_eoy_magtape.validate_input(l_middle_name,'P45_46_FIRST_NAME') > 0 THEN

1953: l_count_char_errors := l_count_char_errors + 1;
1954: END IF;
1955:
1956: IF l_middle_name <> ' ' AND per_formula_functions.isnull(l_middle_name)<>'Y' THEN
1957: IF pay_gb_eoy_magtape.validate_input(l_middle_name,'P45_46_FIRST_NAME') > 0 THEN
1958: populate_run_msg(p_assactid,'The Middle Name ' || l_middle_name || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1959: fnd_file.put_line (fnd_file.LOG,' : The Middle Name ' || l_middle_name || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1960: edi_validation_fail := 'Y';
1961: l_count_char_errors := l_count_char_errors + 1;

Line 1966: IF pay_gb_eoy_magtape.validate_input(l_title,'P45_46_TITLE') > 0 THEN

1962: END IF;
1963: END IF;
1964:
1965: IF l_title <> ' ' AND per_formula_functions.isnull(l_title)<>'Y' THEN
1966: IF pay_gb_eoy_magtape.validate_input(l_title,'P45_46_TITLE') > 0 THEN
1967: populate_run_msg(p_assactid,'The Title ' || l_title || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1968: fnd_file.put_line (fnd_file.LOG,' : The Title ' || l_title || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1969: edi_validation_fail := 'Y';
1970: l_count_char_errors := l_count_char_errors + 1;

Line 1975: IF pay_gb_eoy_magtape.validate_input(l_postal_code,'P45_46_POSTCODE') > 0 THEN

1971: END IF;
1972: END IF;
1973:
1974: IF l_postal_code <> ' ' OR l_postal_code IS NOT NULL THEN
1975: IF pay_gb_eoy_magtape.validate_input(l_postal_code,'P45_46_POSTCODE') > 0 THEN
1976: populate_run_msg(p_assactid,'The Postal Code ' || l_postal_code || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1977: fnd_file.put_line (fnd_file.LOG,' : The Postal Code ' || l_postal_code || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1978: edi_validation_fail := 'Y';
1979: l_count_char_errors := l_count_char_errors + 1;

Line 1985: IF pay_gb_eoy_magtape.validate_input(upper(l_assignment_number),'FULL_EDI') > 0 THEN --Added 'upper' to fix the bug 9503248

1981: END IF;
1982:
1983: -- below validations are from fetch_person_rec
1984: IF l_assignment_number <> ' ' OR l_assignment_number IS NOT NULL THEN
1985: IF pay_gb_eoy_magtape.validate_input(upper(l_assignment_number),'FULL_EDI') > 0 THEN --Added 'upper' to fix the bug 9503248
1986: populate_run_msg(p_assactid,'The Assignment Number ' || l_assignment_number || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1987: fnd_file.put_line (fnd_file.LOG,' : The Assignment Number ' || l_assignment_number || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1988: edi_validation_fail := 'Y';
1989: l_count_char_errors := l_count_char_errors + 1;

Line 1994: IF pay_gb_eoy_magtape.validate_input(l_job_title,'P14_FULL_EDI') > 0 THEN

1990: END IF;
1991: END IF;
1992:
1993: IF l_job_title <> ' ' OR l_job_title IS NOT NULL THEN
1994: IF pay_gb_eoy_magtape.validate_input(l_job_title,'P14_FULL_EDI') > 0 THEN
1995: populate_run_msg(p_assactid,'The Job Title ' || l_job_title || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1996: fnd_file.put_line (fnd_file.LOG,' : The Job Title ' || l_job_title || ' of the assignment ' || l_assignment_number || ' has invalid character(s).');
1997: edi_validation_fail := 'Y';
1998: END IF;

Line 2332: ELSIF pay_gb_eoy_magtape.validate_input(l_tax_dist_ref,'P14_FULL_EDI') > 0

2328: l_err := TRUE;
2329: hr_utility.set_location('The employer''s PAYE Reference is missing.',10);
2330: fnd_file.put_line(fnd_file.output,'The employer''s PAYE Reference is missing.');
2331:
2332: ELSIF pay_gb_eoy_magtape.validate_input(l_tax_dist_ref,'P14_FULL_EDI') > 0
2333: THEN
2334: l_err := TRUE;
2335: hr_utility.set_location('The employer''s PAYE Reference contains invalid characters.',10);
2336: fnd_file.put_line(fnd_file.output,'The employer''s PAYE Reference contains invalid characters.');

Line 2346: ELSIF pay_gb_eoy_magtape.validate_input(p_employer_name,'P14_FULL_EDI') > 0

2342: l_err := TRUE;
2343: hr_utility.set_location('The employer''s name is missing for employer''s PAYE Reference '||p_tax_ref,10);
2344: fnd_file.put_line(fnd_file.output,'The employer''s name is missing for employer''s PAYE Reference '||p_tax_ref);
2345:
2346: ELSIF pay_gb_eoy_magtape.validate_input(p_employer_name,'P14_FULL_EDI') > 0
2347: THEN
2348: l_err := TRUE;
2349: hr_utility.set_location('The employer''s name '||p_employer_name||' contains invalid character(s) for the employer''s PAYE Reference '||p_tax_ref,10);
2350: fnd_file.put_line(fnd_file.output,'The employer''s name '||p_employer_name||' contains invalid character(s) for the employer''s PAYE Reference '||p_tax_ref);

Line 2356: IF pay_gb_eoy_magtape.validate_input(p_tst_id,'MIXED_CHAR_ALPHA_NUM') > 0

2352:
2353: --Test Indicator validations
2354: IF p_tst_indi = 'Y'
2355: THEN
2356: IF pay_gb_eoy_magtape.validate_input(p_tst_id,'MIXED_CHAR_ALPHA_NUM') > 0
2357: THEN
2358: l_err := TRUE;
2359: hr_utility.set_location('The Test ID '||p_tst_id||' contains invalid character(s).',10);
2360: fnd_file.put_line(fnd_file.output,'The Test ID '||p_tst_id||' contains invalid character(s).');

Line 2465: if pay_gb_eoy_magtape.validate_input(substr(l_tax_ref,1,3),'NUMBER') > 0

2461: l_err := true;
2462: end if;
2463: end if;
2464:
2465: if pay_gb_eoy_magtape.validate_input(substr(l_tax_ref,1,3),'NUMBER') > 0
2466: OR
2467: pay_gb_eoy_magtape.validate_input(l_tax_ref,'FULL_EDI') > 0 then
2468: pay_core_utils.push_message(800, 'HR_GB_78049_INV_EMP_PAYE_REF', 'F');
2469: l_err := true;

Line 2467: pay_gb_eoy_magtape.validate_input(l_tax_ref,'FULL_EDI') > 0 then

2463: end if;
2464:
2465: if pay_gb_eoy_magtape.validate_input(substr(l_tax_ref,1,3),'NUMBER') > 0
2466: OR
2467: pay_gb_eoy_magtape.validate_input(l_tax_ref,'FULL_EDI') > 0 then
2468: pay_core_utils.push_message(800, 'HR_GB_78049_INV_EMP_PAYE_REF', 'F');
2469: l_err := true;
2470: end if;
2471:

Line 2731: AND pay_gb_eoy_magtape.validate_input(l_assignment_number,'P14_FULL_EDI') > 0

2727: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The Tax Code in use of the assignment '||l_assignment_number||' is missing.');
2728: END IF;
2729:
2730: IF l_assignment_number IS NOT NULL
2731: AND pay_gb_eoy_magtape.validate_input(l_assignment_number,'P14_FULL_EDI') > 0
2732: THEN
2733: l_err := TRUE;
2734: populate_run_msg(p_assactid,'The Assignment Number '||l_assignment_number||' has invalid character(s).');
2735: hr_utility.set_location('The Assignment Number '||l_assignment_number||' has invalid character(s).',10);

Line 2778: l_msg_value := pay_gb_eoy_magtape.validate_tax_code_yrfil(p_assactid,l_tax_code_in_use,p_effective_date);

2774: fnd_file.put_line (fnd_file.LOG,l_assignment_number||': The assignment, '||l_assignment_number||', does not have a Hire Date.');
2775: END IF;
2776:
2777:
2778: l_msg_value := pay_gb_eoy_magtape.validate_tax_code_yrfil(p_assactid,l_tax_code_in_use,p_effective_date);
2779:
2780: IF l_tax_code_in_use IS NOT NULL
2781: AND l_msg_value <> ' '
2782: THEN