95: return;
96: end if;
97:
98: when UTL_FILE.INVALID_FILEHANDLE then
99: fnd_message.set_name('FND', 'CONC-TEMPFILE_INVALID_HANDLE');
100: fnd_message.set_token('TEMP_FILE', LOG_FNAME, FALSE);
101: raise_application_error(-20104, fnd_message.get);
102:
103: when UTL_FILE.INVALID_OPERATION then
96: end if;
97:
98: when UTL_FILE.INVALID_FILEHANDLE then
99: fnd_message.set_name('FND', 'CONC-TEMPFILE_INVALID_HANDLE');
100: fnd_message.set_token('TEMP_FILE', LOG_FNAME, FALSE);
101: raise_application_error(-20104, fnd_message.get);
102:
103: when UTL_FILE.INVALID_OPERATION then
104: fnd_message.set_name('FND', 'CONC-TEMPFILE_INVALID_OPERATN');
97:
98: when UTL_FILE.INVALID_FILEHANDLE then
99: fnd_message.set_name('FND', 'CONC-TEMPFILE_INVALID_HANDLE');
100: fnd_message.set_token('TEMP_FILE', LOG_FNAME, FALSE);
101: raise_application_error(-20104, fnd_message.get);
102:
103: when UTL_FILE.INVALID_OPERATION then
104: fnd_message.set_name('FND', 'CONC-TEMPFILE_INVALID_OPERATN');
105: fnd_message.set_token('TEMP_FILE', LOG_FNAME, FALSE);
100: fnd_message.set_token('TEMP_FILE', LOG_FNAME, FALSE);
101: raise_application_error(-20104, fnd_message.get);
102:
103: when UTL_FILE.INVALID_OPERATION then
104: fnd_message.set_name('FND', 'CONC-TEMPFILE_INVALID_OPERATN');
105: fnd_message.set_token('TEMP_FILE', LOG_FNAME, FALSE);
106: raise_application_error(-20105, fnd_message.get);
107:
108: when UTL_FILE.READ_ERROR then
101: raise_application_error(-20104, fnd_message.get);
102:
103: when UTL_FILE.INVALID_OPERATION then
104: fnd_message.set_name('FND', 'CONC-TEMPFILE_INVALID_OPERATN');
105: fnd_message.set_token('TEMP_FILE', LOG_FNAME, FALSE);
106: raise_application_error(-20105, fnd_message.get);
107:
108: when UTL_FILE.READ_ERROR then
109: fnd_message.set_name('FND', 'CONC-TEMPFILE_READ_ERROR');
102:
103: when UTL_FILE.INVALID_OPERATION then
104: fnd_message.set_name('FND', 'CONC-TEMPFILE_INVALID_OPERATN');
105: fnd_message.set_token('TEMP_FILE', LOG_FNAME, FALSE);
106: raise_application_error(-20105, fnd_message.get);
107:
108: when UTL_FILE.READ_ERROR then
109: fnd_message.set_name('FND', 'CONC-TEMPFILE_READ_ERROR');
110: fnd_message.set_token('TEMP_FILE', LOG_FNAME, FALSE);
105: fnd_message.set_token('TEMP_FILE', LOG_FNAME, FALSE);
106: raise_application_error(-20105, fnd_message.get);
107:
108: when UTL_FILE.READ_ERROR then
109: fnd_message.set_name('FND', 'CONC-TEMPFILE_READ_ERROR');
110: fnd_message.set_token('TEMP_FILE', LOG_FNAME, FALSE);
111: raise_application_error(-20106, fnd_message.get);
112:
113:
106: raise_application_error(-20105, fnd_message.get);
107:
108: when UTL_FILE.READ_ERROR then
109: fnd_message.set_name('FND', 'CONC-TEMPFILE_READ_ERROR');
110: fnd_message.set_token('TEMP_FILE', LOG_FNAME, FALSE);
111: raise_application_error(-20106, fnd_message.get);
112:
113:
114: when OTHERS then
107:
108: when UTL_FILE.READ_ERROR then
109: fnd_message.set_name('FND', 'CONC-TEMPFILE_READ_ERROR');
110: fnd_message.set_token('TEMP_FILE', LOG_FNAME, FALSE);
111: raise_application_error(-20106, fnd_message.get);
112:
113:
114: when OTHERS then
115: raise;
141: return;
142: end if;
143:
144: when UTL_FILE.INVALID_FILEHANDLE then
145: fnd_message.set_name('FND', 'CONC-TEMPFILE_INVALID_HANDLE');
146: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
147: raise_application_error(-20104, fnd_message.get);
148:
149: when UTL_FILE.INVALID_OPERATION then
142: end if;
143:
144: when UTL_FILE.INVALID_FILEHANDLE then
145: fnd_message.set_name('FND', 'CONC-TEMPFILE_INVALID_HANDLE');
146: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
147: raise_application_error(-20104, fnd_message.get);
148:
149: when UTL_FILE.INVALID_OPERATION then
150: fnd_message.set_name('FND', 'CONC-TEMPFILE_INVALID_OPERATN');
143:
144: when UTL_FILE.INVALID_FILEHANDLE then
145: fnd_message.set_name('FND', 'CONC-TEMPFILE_INVALID_HANDLE');
146: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
147: raise_application_error(-20104, fnd_message.get);
148:
149: when UTL_FILE.INVALID_OPERATION then
150: fnd_message.set_name('FND', 'CONC-TEMPFILE_INVALID_OPERATN');
151: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
146: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
147: raise_application_error(-20104, fnd_message.get);
148:
149: when UTL_FILE.INVALID_OPERATION then
150: fnd_message.set_name('FND', 'CONC-TEMPFILE_INVALID_OPERATN');
151: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
152: raise_application_error(-20105, fnd_message.get);
153:
154: when UTL_FILE.READ_ERROR then
147: raise_application_error(-20104, fnd_message.get);
148:
149: when UTL_FILE.INVALID_OPERATION then
150: fnd_message.set_name('FND', 'CONC-TEMPFILE_INVALID_OPERATN');
151: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
152: raise_application_error(-20105, fnd_message.get);
153:
154: when UTL_FILE.READ_ERROR then
155: fnd_message.set_name('FND', 'CONC-TEMPFILE_READ_ERROR');
148:
149: when UTL_FILE.INVALID_OPERATION then
150: fnd_message.set_name('FND', 'CONC-TEMPFILE_INVALID_OPERATN');
151: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
152: raise_application_error(-20105, fnd_message.get);
153:
154: when UTL_FILE.READ_ERROR then
155: fnd_message.set_name('FND', 'CONC-TEMPFILE_READ_ERROR');
156: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
151: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
152: raise_application_error(-20105, fnd_message.get);
153:
154: when UTL_FILE.READ_ERROR then
155: fnd_message.set_name('FND', 'CONC-TEMPFILE_READ_ERROR');
156: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
157: raise_application_error(-20106, fnd_message.get);
158:
159: when OTHERS then
152: raise_application_error(-20105, fnd_message.get);
153:
154: when UTL_FILE.READ_ERROR then
155: fnd_message.set_name('FND', 'CONC-TEMPFILE_READ_ERROR');
156: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
157: raise_application_error(-20106, fnd_message.get);
158:
159: when OTHERS then
160: raise;
153:
154: when UTL_FILE.READ_ERROR then
155: fnd_message.set_name('FND', 'CONC-TEMPFILE_READ_ERROR');
156: fnd_message.set_token('TEMP_FILE', OUT_FNAME, FALSE);
157: raise_application_error(-20106, fnd_message.get);
158:
159: when OTHERS then
160: raise;
161:
198: return TRUE;
199:
200: exception
201: when UTL_FILE.INVALID_PATH then
202: fnd_message.set_name('FND', 'CONC-TEMPFILE_INVALID_PATH');
203: fnd_message.set_token('FILE_DIR', TEMP_DIR, FALSE);
204: raise_application_error(-20101, fnd_message.get);
205:
206: when OTHERS then
199:
200: exception
201: when UTL_FILE.INVALID_PATH then
202: fnd_message.set_name('FND', 'CONC-TEMPFILE_INVALID_PATH');
203: fnd_message.set_token('FILE_DIR', TEMP_DIR, FALSE);
204: raise_application_error(-20101, fnd_message.get);
205:
206: when OTHERS then
207: raise;
200: exception
201: when UTL_FILE.INVALID_PATH then
202: fnd_message.set_name('FND', 'CONC-TEMPFILE_INVALID_PATH');
203: fnd_message.set_token('FILE_DIR', TEMP_DIR, FALSE);
204: raise_application_error(-20101, fnd_message.get);
205:
206: when OTHERS then
207: raise;
208: