APPS.PAY_GB_MOVDED_EDI dependencies on PER_FORMULA_FUNCTIONS

Line 1931: IF l_last_name = ' ' OR per_formula_functions.isnull(l_last_name)='Y' THEN

1927: l_count_char_errors := l_count_char_errors + 1;
1928: END IF;
1929: END IF;
1930:
1931: IF l_last_name = ' ' OR per_formula_functions.isnull(l_last_name)='Y' 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;

Line 1943: IF l_first_name = ' ' OR per_formula_functions.isnull(l_first_name)='Y' THEN

1939: edi_validation_fail := 'Y';
1940: l_count_char_errors := l_count_char_errors + 1;
1941: END IF;
1942:
1943: IF l_first_name = ' ' OR per_formula_functions.isnull(l_first_name)='Y' THEN
1944: populate_run_msg(p_assactid,'The First Name of the assignment '|| l_assignment_number || ' is missing.');
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;

Line 1956: IF l_middle_name <> ' ' AND per_formula_functions.isnull(l_middle_name)<>'Y' THEN

1952: edi_validation_fail := 'Y';
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';

Line 1965: IF l_title <> ' ' AND per_formula_functions.isnull(l_title)<>'Y' THEN

1961: l_count_char_errors := l_count_char_errors + 1;
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';