135: RAISE e_in_upload;
136: end if;
137: EXCEPTION
138: when e_in_upload then
139: fnd_message.set_name('PER','HR_289277_INCOMPLETE_UPLOAD');
140: --l_message := fnd_message.get_string('PER','HR_289277_INCOMPLETE_UPLOAD');
141: --fnd_file.put_line(FND_FILE.LOG,l_message);
142: fnd_message.raise_error;
143: END;
136: end if;
137: EXCEPTION
138: when e_in_upload then
139: fnd_message.set_name('PER','HR_289277_INCOMPLETE_UPLOAD');
140: --l_message := fnd_message.get_string('PER','HR_289277_INCOMPLETE_UPLOAD');
141: --fnd_file.put_line(FND_FILE.LOG,l_message);
142: fnd_message.raise_error;
143: END;
144: */
138: when e_in_upload then
139: fnd_message.set_name('PER','HR_289277_INCOMPLETE_UPLOAD');
140: --l_message := fnd_message.get_string('PER','HR_289277_INCOMPLETE_UPLOAD');
141: --fnd_file.put_line(FND_FILE.LOG,l_message);
142: fnd_message.raise_error;
143: END;
144: */
145:
146: l_fp := UTL_FILE.fopen(FND_PROFILE.VALUE('PER_H2PI_DATA_UPLOAD_DIRECTORY'),p_file_name,'r');
826: hr_utility.set_location('Leaving:'|| l_proc, 300);
827:
828: EXCEPTION
829: WHEN UTL_FILE.INVALID_PATH THEN
830: fnd_message.set_name('PER','HR_52089_NOT_OPEN_FILE');
831: fnd_message.set_token('FILENAME',p_file_name);
832: fnd_message.raise_error;
833: WHEN UTL_FILE.INVALID_OPERATION THEN
834: fnd_message.set_name('PER','HR_52089_NOT_OPEN_FILE');
827:
828: EXCEPTION
829: WHEN UTL_FILE.INVALID_PATH THEN
830: fnd_message.set_name('PER','HR_52089_NOT_OPEN_FILE');
831: fnd_message.set_token('FILENAME',p_file_name);
832: fnd_message.raise_error;
833: WHEN UTL_FILE.INVALID_OPERATION THEN
834: fnd_message.set_name('PER','HR_52089_NOT_OPEN_FILE');
835: fnd_message.set_token('FILENAME',p_file_name);
828: EXCEPTION
829: WHEN UTL_FILE.INVALID_PATH THEN
830: fnd_message.set_name('PER','HR_52089_NOT_OPEN_FILE');
831: fnd_message.set_token('FILENAME',p_file_name);
832: fnd_message.raise_error;
833: WHEN UTL_FILE.INVALID_OPERATION THEN
834: fnd_message.set_name('PER','HR_52089_NOT_OPEN_FILE');
835: fnd_message.set_token('FILENAME',p_file_name);
836: fnd_message.raise_error;
830: fnd_message.set_name('PER','HR_52089_NOT_OPEN_FILE');
831: fnd_message.set_token('FILENAME',p_file_name);
832: fnd_message.raise_error;
833: WHEN UTL_FILE.INVALID_OPERATION THEN
834: fnd_message.set_name('PER','HR_52089_NOT_OPEN_FILE');
835: fnd_message.set_token('FILENAME',p_file_name);
836: fnd_message.raise_error;
837:
838: END upload;
831: fnd_message.set_token('FILENAME',p_file_name);
832: fnd_message.raise_error;
833: WHEN UTL_FILE.INVALID_OPERATION THEN
834: fnd_message.set_name('PER','HR_52089_NOT_OPEN_FILE');
835: fnd_message.set_token('FILENAME',p_file_name);
836: fnd_message.raise_error;
837:
838: END upload;
839:
832: fnd_message.raise_error;
833: WHEN UTL_FILE.INVALID_OPERATION THEN
834: fnd_message.set_name('PER','HR_52089_NOT_OPEN_FILE');
835: fnd_message.set_token('FILENAME',p_file_name);
836: fnd_message.raise_error;
837:
838: END upload;
839:
840: END hr_h2pi_upload ;