DBA Data[Home] [Help]

APPS.PER_PERUSHRM_XMLP_PKG dependencies on FND_FILE

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

1660: 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;
1661: WHILE c_person_id%FOUND LOOP
1662: if v_header = 0 then
1663: v_boolean := fnd_concurrent.set_completion_status('WARNING','');
1664: fnd_file.put_line(1,'Warning : The New Hire field of the following employees on people form is blank.');
1665: fnd_file.put_line(1,'Warning : Please update the New Hire field.');
1666: fnd_file.put_line(1,' ');
1667: fnd_file.put_line(1,'Last Name First Name MI SSN Hire Date DOB ');
1668: fnd_file.put_line(1,' ') ;

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

1661: WHILE c_person_id%FOUND LOOP
1662: if v_header = 0 then
1663: v_boolean := fnd_concurrent.set_completion_status('WARNING','');
1664: fnd_file.put_line(1,'Warning : The New Hire field of the following employees on people form is blank.');
1665: fnd_file.put_line(1,'Warning : Please update the New Hire field.');
1666: fnd_file.put_line(1,' ');
1667: fnd_file.put_line(1,'Last Name First Name MI SSN Hire Date DOB ');
1668: fnd_file.put_line(1,' ') ;
1669: v_buffer := rpad(v_last_name,24,' ') ||

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

1662: if v_header = 0 then
1663: v_boolean := fnd_concurrent.set_completion_status('WARNING','');
1664: fnd_file.put_line(1,'Warning : The New Hire field of the following employees on people form is blank.');
1665: fnd_file.put_line(1,'Warning : Please update the New Hire field.');
1666: fnd_file.put_line(1,' ');
1667: fnd_file.put_line(1,'Last Name First Name MI SSN Hire Date DOB ');
1668: fnd_file.put_line(1,' ') ;
1669: v_buffer := rpad(v_last_name,24,' ') ||
1670: rpad(' ',1,' ') ||

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

1663: v_boolean := fnd_concurrent.set_completion_status('WARNING','');
1664: fnd_file.put_line(1,'Warning : The New Hire field of the following employees on people form is blank.');
1665: fnd_file.put_line(1,'Warning : Please update the New Hire field.');
1666: fnd_file.put_line(1,' ');
1667: fnd_file.put_line(1,'Last Name First Name MI SSN Hire Date DOB ');
1668: fnd_file.put_line(1,' ') ;
1669: v_buffer := rpad(v_last_name,24,' ') ||
1670: rpad(' ',1,' ') ||
1671: rpad(nvl(v_first_name,' '),20,' ') ||

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

1664: fnd_file.put_line(1,'Warning : The New Hire field of the following employees on people form is blank.');
1665: fnd_file.put_line(1,'Warning : Please update the New Hire field.');
1666: fnd_file.put_line(1,' ');
1667: fnd_file.put_line(1,'Last Name First Name MI SSN Hire Date DOB ');
1668: fnd_file.put_line(1,' ') ;
1669: v_buffer := rpad(v_last_name,24,' ') ||
1670: rpad(' ',1,' ') ||
1671: rpad(nvl(v_first_name,' '),20,' ') ||
1672: rpad(' ',1,' ') ||

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

1676: rpad(' ',1,' ') ||
1677: rpad(to_date(v_date_start,'DD-MM-RRRR'),9,' ') ||
1678: rpad(' ',1,' ') ||
1679: rpad(to_date(v_dob,'DD-MM-RRRR'),9,' ');
1680: fnd_file.put_line(1,v_buffer);
1681: v_header := 1;
1682: else
1683: v_buffer := rpad(v_last_name,24,' ') ||
1684: rpad(' ',1,' ') ||

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

1690: rpad(' ',1,' ') ||
1691: rpad(to_date(v_date_start,'DD-MM-RRRR'),9,' ') ||
1692: rpad(' ',1,' ') ||
1693: rpad(to_date(v_dob,'DD-MM-RRRR'),9,' ') ;
1694: fnd_file.put_line(1,v_buffer);
1695: end if;
1696: 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;
1697:
1698: END LOOP;

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

1695: end if;
1696: 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;
1697:
1698: END LOOP;
1699: fnd_file.put_line(1,' ');
1700:
1701: hr_utility.set_location('p_output_new_hire_null',100);
1702:
1703: CLOSE c_person_id;