95:
96: -- COMMIT;
97: EXCEPTION
98: WHEN utl_file.invalid_path then
99: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
100: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
101: hr_utility.raise_error;
102: --
103: WHEN utl_file.invalid_mode then
96: -- COMMIT;
97: EXCEPTION
98: WHEN utl_file.invalid_path then
99: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
100: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
101: hr_utility.raise_error;
102: --
103: WHEN utl_file.invalid_mode then
104: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
97: EXCEPTION
98: WHEN utl_file.invalid_path then
99: hr_utility.set_message(8301, 'GHR_38830_INVALID_UTL_FILE_PATH');
100: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
101: hr_utility.raise_error;
102: --
103: WHEN utl_file.invalid_mode then
104: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
105: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
100: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
101: hr_utility.raise_error;
102: --
103: WHEN utl_file.invalid_mode then
104: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
105: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
106: hr_utility.raise_error;
107: --
108: WHEN utl_file.invalid_filehandle then
101: hr_utility.raise_error;
102: --
103: WHEN utl_file.invalid_mode then
104: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
105: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
106: hr_utility.raise_error;
107: --
108: WHEN utl_file.invalid_filehandle then
109: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
102: --
103: WHEN utl_file.invalid_mode then
104: hr_utility.set_message(8301, 'GHR_38831_INVALID_FILE_MODE');
105: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
106: hr_utility.raise_error;
107: --
108: WHEN utl_file.invalid_filehandle then
109: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
110: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
105: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
106: hr_utility.raise_error;
107: --
108: WHEN utl_file.invalid_filehandle then
109: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
110: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
111: hr_utility.raise_error;
112: --
113: WHEN utl_file.invalid_operation then
106: hr_utility.raise_error;
107: --
108: WHEN utl_file.invalid_filehandle then
109: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
110: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
111: hr_utility.raise_error;
112: --
113: WHEN utl_file.invalid_operation then
114: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
107: --
108: WHEN utl_file.invalid_filehandle then
109: hr_utility.set_message(8301, 'GHR_38832_INVALID_FILE_HANDLE');
110: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
111: hr_utility.raise_error;
112: --
113: WHEN utl_file.invalid_operation then
114: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
115: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
110: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
111: hr_utility.raise_error;
112: --
113: WHEN utl_file.invalid_operation then
114: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
115: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
116: hr_utility.raise_error;
117: --
118: WHEN utl_file.read_error then
111: hr_utility.raise_error;
112: --
113: WHEN utl_file.invalid_operation then
114: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
115: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
116: hr_utility.raise_error;
117: --
118: WHEN utl_file.read_error then
119: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
112: --
113: WHEN utl_file.invalid_operation then
114: hr_utility.set_message(8301, 'GHR_38833_INVALID_OPER');
115: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
116: hr_utility.raise_error;
117: --
118: WHEN utl_file.read_error then
119: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
120: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
115: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
116: hr_utility.raise_error;
117: --
118: WHEN utl_file.read_error then
119: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
120: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
121: hr_utility.raise_error;
122: --
123:
116: hr_utility.raise_error;
117: --
118: WHEN utl_file.read_error then
119: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
120: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
121: hr_utility.raise_error;
122: --
123:
124: WHEN others THEN
117: --
118: WHEN utl_file.read_error then
119: hr_utility.set_message(8301, 'GHR_38834_FILE_READ_ERROR');
120: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
121: hr_utility.raise_error;
122: --
123:
124: WHEN others THEN
125: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
121: hr_utility.raise_error;
122: --
123:
124: WHEN others THEN
125: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
126: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
127: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
128: hr_utility.raise_error;
129: END populate_sum;
122: --
123:
124: WHEN others THEN
125: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
126: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
127: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
128: hr_utility.raise_error;
129: END populate_sum;
130:
123:
124: WHEN others THEN
125: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
126: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
127: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
128: hr_utility.raise_error;
129: END populate_sum;
130:
131: --------------------------------------------
124: WHEN others THEN
125: hr_utility.set_message(800,'FFU10_GENERAL_ORACLE_ERROR');
126: hr_utility.set_message_token('2',substr(sqlerrm,1,200));
127: fnd_file.put_line(fnd_file.log,HR_UTILITY.get_message);
128: hr_utility.raise_error;
129: END populate_sum;
130:
131: --------------------------------------------
132: