DBA Data[Home] [Help]

APPS.PER_PERUSHRM_XMLP_PKG dependencies on FND_FILE

Line 1656: fnd_file.put_line(1,'Warning : The New Hire field of the following employees on people form is blank.');

1652: FETCH c_person_id INTO v_person_id,v_last_name,v_first_name,v_middle_name,v_ssn,v_dob,v_date_start,v_state;
1653: WHILE c_person_id%FOUND LOOP
1654: if v_header = 0 then
1655: v_boolean := fnd_concurrent.set_completion_status('WARNING','');
1656: fnd_file.put_line(1,'Warning : The New Hire field of the following employees on people form is blank.');
1657: fnd_file.put_line(1,'Warning : Please update the New Hire field.');
1658: fnd_file.put_line(1,' ');
1659: fnd_file.put_line(1,'Last Name First Name MI SSN Hire Date DOB ');
1660: fnd_file.put_line(1,' ') ;

Line 1657: fnd_file.put_line(1,'Warning : Please update the New Hire field.');

1653: WHILE c_person_id%FOUND LOOP
1654: if v_header = 0 then
1655: v_boolean := fnd_concurrent.set_completion_status('WARNING','');
1656: fnd_file.put_line(1,'Warning : The New Hire field of the following employees on people form is blank.');
1657: fnd_file.put_line(1,'Warning : Please update the New Hire field.');
1658: fnd_file.put_line(1,' ');
1659: fnd_file.put_line(1,'Last Name First Name MI SSN Hire Date DOB ');
1660: fnd_file.put_line(1,' ') ;
1661: v_buffer := rpad(v_last_name,24,' ') ||

Line 1658: fnd_file.put_line(1,' ');

1654: if v_header = 0 then
1655: v_boolean := fnd_concurrent.set_completion_status('WARNING','');
1656: fnd_file.put_line(1,'Warning : The New Hire field of the following employees on people form is blank.');
1657: fnd_file.put_line(1,'Warning : Please update the New Hire field.');
1658: fnd_file.put_line(1,' ');
1659: fnd_file.put_line(1,'Last Name First Name MI SSN Hire Date DOB ');
1660: fnd_file.put_line(1,' ') ;
1661: v_buffer := rpad(v_last_name,24,' ') ||
1662: rpad(' ',1,' ') ||

Line 1659: fnd_file.put_line(1,'Last Name First Name MI SSN Hire Date DOB ');

1655: v_boolean := fnd_concurrent.set_completion_status('WARNING','');
1656: fnd_file.put_line(1,'Warning : The New Hire field of the following employees on people form is blank.');
1657: fnd_file.put_line(1,'Warning : Please update the New Hire field.');
1658: fnd_file.put_line(1,' ');
1659: fnd_file.put_line(1,'Last Name First Name MI SSN Hire Date DOB ');
1660: fnd_file.put_line(1,' ') ;
1661: v_buffer := rpad(v_last_name,24,' ') ||
1662: rpad(' ',1,' ') ||
1663: rpad(nvl(v_first_name,' '),20,' ') ||

Line 1660: fnd_file.put_line(1,' ') ;

1656: fnd_file.put_line(1,'Warning : The New Hire field of the following employees on people form is blank.');
1657: fnd_file.put_line(1,'Warning : Please update the New Hire field.');
1658: fnd_file.put_line(1,' ');
1659: fnd_file.put_line(1,'Last Name First Name MI SSN Hire Date DOB ');
1660: fnd_file.put_line(1,' ') ;
1661: v_buffer := rpad(v_last_name,24,' ') ||
1662: rpad(' ',1,' ') ||
1663: rpad(nvl(v_first_name,' '),20,' ') ||
1664: rpad(' ',1,' ') ||

Line 1672: fnd_file.put_line(1,v_buffer);

1668: rpad(' ',1,' ') ||
1669: rpad(to_date(v_date_start,'DD-MM-RRRR'),9,' ') ||
1670: rpad(' ',1,' ') ||
1671: rpad(to_date(v_dob,'DD-MM-RRRR'),9,' ');
1672: fnd_file.put_line(1,v_buffer);
1673: v_header := 1;
1674: else
1675: v_buffer := rpad(v_last_name,24,' ') ||
1676: rpad(' ',1,' ') ||

Line 1686: fnd_file.put_line(1,v_buffer);

1682: rpad(' ',1,' ') ||
1683: rpad(to_date(v_date_start,'DD-MM-RRRR'),9,' ') ||
1684: rpad(' ',1,' ') ||
1685: rpad(to_date(v_dob,'DD-MM-RRRR'),9,' ') ;
1686: fnd_file.put_line(1,v_buffer);
1687: end if;
1688: FETCH c_person_id INTO v_person_id,v_last_name,v_first_name,v_middle_name,v_ssn,v_dob,v_date_start,v_state;
1689:
1690: END LOOP;

Line 1691: fnd_file.put_line(1,' ');

1687: end if;
1688: FETCH c_person_id INTO v_person_id,v_last_name,v_first_name,v_middle_name,v_ssn,v_dob,v_date_start,v_state;
1689:
1690: END LOOP;
1691: fnd_file.put_line(1,' ');
1692:
1693: hr_utility.set_location('p_output_new_hire_null',100);
1694:
1695: CLOSE c_person_id;