eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_HRHD_INITIAL_LOAD dependencies on FND_FILE

Line 122: FND_FILE.NEW_LINE(FND_FILE.log, 1);

118:
119: begin
120:
121:
122: FND_FILE.NEW_LINE(FND_FILE.log, 1);
123: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
124: FND_FILE.put_line(fnd_file.log,'Location Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
125:
126: /*Start of logic to break the load into preset number of files*/

Line 123: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

119: begin
120:
121:
122: FND_FILE.NEW_LINE(FND_FILE.log, 1);
123: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
124: FND_FILE.put_line(fnd_file.log,'Location Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
125:
126: /*Start of logic to break the load into preset number of files*/
127: If number_of_files is not null

Line 124: FND_FILE.put_line(fnd_file.log,'Location Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));

120:
121:
122: FND_FILE.NEW_LINE(FND_FILE.log, 1);
123: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
124: FND_FILE.put_line(fnd_file.log,'Location Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
125:
126: /*Start of logic to break the load into preset number of files*/
127: If number_of_files is not null
128: Then

Line 138: FND_FILE.put_line(fnd_file.log,'No. of files is more than the Number of total records');

134:
135: --If r >0 then total_record_count := r; End If;
136:
137: If r < number_of_files Then
138: FND_FILE.put_line(fnd_file.log,'No. of files is more than the Number of total records');
139: End If;
140: Else
141: number_of_files := 1;
142: r := 1;

Line 144: FND_FILE.NEW_LINE(FND_FILE.log, 1);

140: Else
141: number_of_files := 1;
142: r := 1;
143: End If;
144: FND_FILE.NEW_LINE(FND_FILE.log, 1);
145: FND_FILE.NEW_LINE(FND_FILE.log, 1);
146: FND_FILE.put_line(fnd_file.log,'Total number_of_files = '||number_of_files);
147: if (r > 1) then
148: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);

Line 145: FND_FILE.NEW_LINE(FND_FILE.log, 1);

141: number_of_files := 1;
142: r := 1;
143: End If;
144: FND_FILE.NEW_LINE(FND_FILE.log, 1);
145: FND_FILE.NEW_LINE(FND_FILE.log, 1);
146: FND_FILE.put_line(fnd_file.log,'Total number_of_files = '||number_of_files);
147: if (r > 1) then
148: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);
149: end if;

Line 146: FND_FILE.put_line(fnd_file.log,'Total number_of_files = '||number_of_files);

142: r := 1;
143: End If;
144: FND_FILE.NEW_LINE(FND_FILE.log, 1);
145: FND_FILE.NEW_LINE(FND_FILE.log, 1);
146: FND_FILE.put_line(fnd_file.log,'Total number_of_files = '||number_of_files);
147: if (r > 1) then
148: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);
149: end if;
150: fnd_profile.get('UTL_FILE_OUT', l_file_path);

Line 148: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);

144: FND_FILE.NEW_LINE(FND_FILE.log, 1);
145: FND_FILE.NEW_LINE(FND_FILE.log, 1);
146: FND_FILE.put_line(fnd_file.log,'Total number_of_files = '||number_of_files);
147: if (r > 1) then
148: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);
149: end if;
150: fnd_profile.get('UTL_FILE_OUT', l_file_path);
151: FND_FILE.put_line(fnd_file.log,'File Path = '||l_file_path);
152: l_file_name_part := fnd_global.conc_request_id;

Line 151: FND_FILE.put_line(fnd_file.log,'File Path = '||l_file_path);

147: if (r > 1) then
148: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);
149: end if;
150: fnd_profile.get('UTL_FILE_OUT', l_file_path);
151: FND_FILE.put_line(fnd_file.log,'File Path = '||l_file_path);
152: l_file_name_part := fnd_global.conc_request_id;
153: FND_FILE.put_line(fnd_file.log,'File names start with : '||l_file_name_part);
154: if (l_file_path is not null)
155: Then

Line 153: FND_FILE.put_line(fnd_file.log,'File names start with : '||l_file_name_part);

149: end if;
150: fnd_profile.get('UTL_FILE_OUT', l_file_path);
151: FND_FILE.put_line(fnd_file.log,'File Path = '||l_file_path);
152: l_file_name_part := fnd_global.conc_request_id;
153: FND_FILE.put_line(fnd_file.log,'File names start with : '||l_file_name_part);
154: if (l_file_path is not null)
155: Then
156:
157: /*Generate the initial load extraction for location and the column delimiter used is to_char(400)*/

Line 169: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out'||' - Opened.');

165: if ((l_record_counter = ((l_file_counter-1)*(TRUNC((r/number_of_files))))+1 ) )
166: Then
167: l_file_pointer := null;
168: l_file_pointer := UTL_FILE.FOPEN(l_file_path,l_file_name_part||'_'||l_file_counter||'.out','W',32767);
169: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out'||' - Opened.');
170: End If;
171:
172: fetch CSR_LOC_INITIAL_LOAD into p_bg_id,p_active_date,p_effecive_status,p_loc_id,p_lang_code,
173: p_loc_desc, p_loc_style , p_country, p_add_line_1, p_add_line_2, p_add_line_3,

Line 216: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');

212: If UTL_FILE.IS_OPEN(l_file_pointer)
213: Then
214: UTL_FILE.FCLOSE(l_file_pointer);
215:
216: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');
217: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||(l_record_counter - l_break_count));
218: l_break_count := l_record_counter;
219: End If;
220: l_file_counter := l_file_counter + 1;

Line 217: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||(l_record_counter - l_break_count));

213: Then
214: UTL_FILE.FCLOSE(l_file_pointer);
215:
216: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');
217: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||(l_record_counter - l_break_count));
218: l_break_count := l_record_counter;
219: End If;
220: l_file_counter := l_file_counter + 1;
221: End If;

Line 230: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');

226:
227: If UTL_FILE.IS_OPEN(l_file_pointer)
228: Then
229: UTL_FILE.FCLOSE(l_file_pointer);
230: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');
231: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||((l_record_counter - 1) - l_break_count));
232: End If;
233: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );
234: Else

Line 231: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||((l_record_counter - 1) - l_break_count));

227: If UTL_FILE.IS_OPEN(l_file_pointer)
228: Then
229: UTL_FILE.FCLOSE(l_file_pointer);
230: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');
231: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||((l_record_counter - 1) - l_break_count));
232: End If;
233: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );
234: Else
235: FND_FILE.NEW_LINE(FND_FILE.log, 1);

Line 233: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );

229: UTL_FILE.FCLOSE(l_file_pointer);
230: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');
231: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||((l_record_counter - 1) - l_break_count));
232: End If;
233: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );
234: Else
235: FND_FILE.NEW_LINE(FND_FILE.log, 1);
236: FND_FILE.put_line(fnd_file.log,'Profile option FND_FILE_OUT has null value. Please specify valid path');
237: raise l_location_exception;

Line 235: FND_FILE.NEW_LINE(FND_FILE.log, 1);

231: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||((l_record_counter - 1) - l_break_count));
232: End If;
233: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );
234: Else
235: FND_FILE.NEW_LINE(FND_FILE.log, 1);
236: FND_FILE.put_line(fnd_file.log,'Profile option FND_FILE_OUT has null value. Please specify valid path');
237: raise l_location_exception;
238: End If;
239:

Line 236: FND_FILE.put_line(fnd_file.log,'Profile option FND_FILE_OUT has null value. Please specify valid path');

232: End If;
233: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );
234: Else
235: FND_FILE.NEW_LINE(FND_FILE.log, 1);
236: FND_FILE.put_line(fnd_file.log,'Profile option FND_FILE_OUT has null value. Please specify valid path');
237: raise l_location_exception;
238: End If;
239:
240:

Line 241: FND_FILE.NEW_LINE(FND_FILE.log, 1);

237: raise l_location_exception;
238: End If;
239:
240:
241: FND_FILE.NEW_LINE(FND_FILE.log, 1);
242: FND_FILE.put_line(fnd_file.log,'Location Initial Load Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
243:
244:
245: exception

Line 242: FND_FILE.put_line(fnd_file.log,'Location Initial Load Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));

238: End If;
239:
240:
241: FND_FILE.NEW_LINE(FND_FILE.log, 1);
242: FND_FILE.put_line(fnd_file.log,'Location Initial Load Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
243:
244:
245: exception
246: when OTHERS then

Line 249: FND_FILE.put_line(fnd_file.log, 'Error in Location Initial Load Extraction: '||SQLCODE);

245: exception
246: when OTHERS then
247: errbuf := errbuf||SQLERRM;
248: retcode := '1';
249: FND_FILE.put_line(fnd_file.log, 'Error in Location Initial Load Extraction: '||SQLCODE);
250: FND_FILE.NEW_LINE(FND_FILE.log, 1);
251: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
252:
253: END HR_LOCATION_INITIAL_LOAD;

Line 250: FND_FILE.NEW_LINE(FND_FILE.log, 1);

246: when OTHERS then
247: errbuf := errbuf||SQLERRM;
248: retcode := '1';
249: FND_FILE.put_line(fnd_file.log, 'Error in Location Initial Load Extraction: '||SQLCODE);
250: FND_FILE.NEW_LINE(FND_FILE.log, 1);
251: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
252:
253: END HR_LOCATION_INITIAL_LOAD;
254: /*Procedure to extract Location Initial Load Extraction Ends*/

Line 251: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));

247: errbuf := errbuf||SQLERRM;
248: retcode := '1';
249: FND_FILE.put_line(fnd_file.log, 'Error in Location Initial Load Extraction: '||SQLCODE);
250: FND_FILE.NEW_LINE(FND_FILE.log, 1);
251: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
252:
253: END HR_LOCATION_INITIAL_LOAD;
254: /*Procedure to extract Location Initial Load Extraction Ends*/
255:

Line 311: FND_FILE.NEW_LINE(FND_FILE.log, 1);

307:
308: begin
309:
310:
311: FND_FILE.NEW_LINE(FND_FILE.log, 1);
312: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
313: FND_FILE.put_line(fnd_file.log,'Job Code Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
314: If number_of_files is not null
315: Then

Line 312: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

308: begin
309:
310:
311: FND_FILE.NEW_LINE(FND_FILE.log, 1);
312: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
313: FND_FILE.put_line(fnd_file.log,'Job Code Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
314: If number_of_files is not null
315: Then
316: r :=0;

Line 313: FND_FILE.put_line(fnd_file.log,'Job Code Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));

309:
310:
311: FND_FILE.NEW_LINE(FND_FILE.log, 1);
312: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
313: FND_FILE.put_line(fnd_file.log,'Job Code Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
314: If number_of_files is not null
315: Then
316: r :=0;
317: For rec in csr_job_initial_load

Line 325: FND_FILE.put_line(fnd_file.log,'No. of files is more than the Number of total records');

321:
322: --If r >0 then total_record_count := r; End If;
323:
324: If r < number_of_files Then
325: FND_FILE.put_line(fnd_file.log,'No. of files is more than the Number of total records');
326: End If;
327: Else
328: number_of_files := 1;
329: r := 1;

Line 331: FND_FILE.NEW_LINE(FND_FILE.log, 1);

327: Else
328: number_of_files := 1;
329: r := 1;
330: End If;
331: FND_FILE.NEW_LINE(FND_FILE.log, 1);
332: FND_FILE.NEW_LINE(FND_FILE.log, 1);
333: FND_FILE.put_line(fnd_file.log,'Total number_of_files = '||number_of_files);
334: if (r > 1) then
335: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);

Line 332: FND_FILE.NEW_LINE(FND_FILE.log, 1);

328: number_of_files := 1;
329: r := 1;
330: End If;
331: FND_FILE.NEW_LINE(FND_FILE.log, 1);
332: FND_FILE.NEW_LINE(FND_FILE.log, 1);
333: FND_FILE.put_line(fnd_file.log,'Total number_of_files = '||number_of_files);
334: if (r > 1) then
335: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);
336: end if;

Line 333: FND_FILE.put_line(fnd_file.log,'Total number_of_files = '||number_of_files);

329: r := 1;
330: End If;
331: FND_FILE.NEW_LINE(FND_FILE.log, 1);
332: FND_FILE.NEW_LINE(FND_FILE.log, 1);
333: FND_FILE.put_line(fnd_file.log,'Total number_of_files = '||number_of_files);
334: if (r > 1) then
335: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);
336: end if;
337: fnd_profile.get('UTL_FILE_OUT', l_file_path);

Line 335: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);

331: FND_FILE.NEW_LINE(FND_FILE.log, 1);
332: FND_FILE.NEW_LINE(FND_FILE.log, 1);
333: FND_FILE.put_line(fnd_file.log,'Total number_of_files = '||number_of_files);
334: if (r > 1) then
335: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);
336: end if;
337: fnd_profile.get('UTL_FILE_OUT', l_file_path);
338: FND_FILE.put_line(fnd_file.log,'File Path = '||l_file_path);
339: l_file_name_part := fnd_global.conc_request_id;

Line 338: FND_FILE.put_line(fnd_file.log,'File Path = '||l_file_path);

334: if (r > 1) then
335: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);
336: end if;
337: fnd_profile.get('UTL_FILE_OUT', l_file_path);
338: FND_FILE.put_line(fnd_file.log,'File Path = '||l_file_path);
339: l_file_name_part := fnd_global.conc_request_id;
340: FND_FILE.put_line(fnd_file.log,'File names start with : '||l_file_name_part);
341: if (l_file_path is not null)
342: Then

Line 340: FND_FILE.put_line(fnd_file.log,'File names start with : '||l_file_name_part);

336: end if;
337: fnd_profile.get('UTL_FILE_OUT', l_file_path);
338: FND_FILE.put_line(fnd_file.log,'File Path = '||l_file_path);
339: l_file_name_part := fnd_global.conc_request_id;
340: FND_FILE.put_line(fnd_file.log,'File names start with : '||l_file_name_part);
341: if (l_file_path is not null)
342: Then
343:
344: /*Generate the initial load extraction for location and the column delimiter used is to_char(400)*/

Line 356: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out'||' - Opened.');

352: if ((l_record_counter = ((l_file_counter-1)*(TRUNC((r/number_of_files))))+1 ) )
353: Then
354: l_file_pointer := null;
355: l_file_pointer := UTL_FILE.FOPEN(l_file_path,l_file_name_part||'_'||l_file_counter||'.out','W',32767);
356: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out'||' - Opened.');
357: End If;
358: FETCH csr_job_initial_load
359: INTO p_job_id,p_business_grp_id,p_lang_code,p_job_descr,p_eff_date,p_eff_status;
360: EXIT WHEN csr_job_initial_load%NOTFOUND;

Line 378: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');

374: If UTL_FILE.IS_OPEN(l_file_pointer)
375: Then
376: UTL_FILE.FCLOSE(l_file_pointer);
377:
378: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');
379: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||(l_record_counter - l_break_count));
380: l_break_count := l_record_counter;
381: End If;
382: l_file_counter := l_file_counter + 1;

Line 379: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||(l_record_counter - l_break_count));

375: Then
376: UTL_FILE.FCLOSE(l_file_pointer);
377:
378: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');
379: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||(l_record_counter - l_break_count));
380: l_break_count := l_record_counter;
381: End If;
382: l_file_counter := l_file_counter + 1;
383: End If;

Line 391: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');

387:
388: If UTL_FILE.IS_OPEN(l_file_pointer)
389: Then
390: UTL_FILE.FCLOSE(l_file_pointer);
391: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');
392: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||((l_record_counter - 1) - l_break_count));
393: End If;
394: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );
395: Else

Line 392: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||((l_record_counter - 1) - l_break_count));

388: If UTL_FILE.IS_OPEN(l_file_pointer)
389: Then
390: UTL_FILE.FCLOSE(l_file_pointer);
391: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');
392: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||((l_record_counter - 1) - l_break_count));
393: End If;
394: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );
395: Else
396: FND_FILE.NEW_LINE(FND_FILE.log, 1);

Line 394: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );

390: UTL_FILE.FCLOSE(l_file_pointer);
391: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');
392: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||((l_record_counter - 1) - l_break_count));
393: End If;
394: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );
395: Else
396: FND_FILE.NEW_LINE(FND_FILE.log, 1);
397: FND_FILE.put_line(fnd_file.log,'Profile option FND_FILE_OUT has null value. Please specify valid path');
398: raise l_location_exception;

Line 396: FND_FILE.NEW_LINE(FND_FILE.log, 1);

392: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||((l_record_counter - 1) - l_break_count));
393: End If;
394: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );
395: Else
396: FND_FILE.NEW_LINE(FND_FILE.log, 1);
397: FND_FILE.put_line(fnd_file.log,'Profile option FND_FILE_OUT has null value. Please specify valid path');
398: raise l_location_exception;
399: End If;
400:

Line 397: FND_FILE.put_line(fnd_file.log,'Profile option FND_FILE_OUT has null value. Please specify valid path');

393: End If;
394: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );
395: Else
396: FND_FILE.NEW_LINE(FND_FILE.log, 1);
397: FND_FILE.put_line(fnd_file.log,'Profile option FND_FILE_OUT has null value. Please specify valid path');
398: raise l_location_exception;
399: End If;
400:
401: FND_FILE.NEW_LINE(FND_FILE.log, 1);

Line 401: FND_FILE.NEW_LINE(FND_FILE.log, 1);

397: FND_FILE.put_line(fnd_file.log,'Profile option FND_FILE_OUT has null value. Please specify valid path');
398: raise l_location_exception;
399: End If;
400:
401: FND_FILE.NEW_LINE(FND_FILE.log, 1);
402: FND_FILE.put_line(fnd_file.log,'Job Code Initial Load Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
403:
404: EXCEPTION WHEN OTHERS THEN
405: errbuf := errbuf||SQLERRM;

Line 402: FND_FILE.put_line(fnd_file.log,'Job Code Initial Load Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));

398: raise l_location_exception;
399: End If;
400:
401: FND_FILE.NEW_LINE(FND_FILE.log, 1);
402: FND_FILE.put_line(fnd_file.log,'Job Code Initial Load Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
403:
404: EXCEPTION WHEN OTHERS THEN
405: errbuf := errbuf||SQLERRM;
406: retcode := '1';

Line 407: FND_FILE.put_line(fnd_file.log, 'Error in Job Initial Load Extraction: '||SQLCODE);

403:
404: EXCEPTION WHEN OTHERS THEN
405: errbuf := errbuf||SQLERRM;
406: retcode := '1';
407: FND_FILE.put_line(fnd_file.log, 'Error in Job Initial Load Extraction: '||SQLCODE);
408: FND_FILE.NEW_LINE(FND_FILE.log, 1);
409: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
410:
411: END HR_JOBCODE_INITIAL_LOAD;

Line 408: FND_FILE.NEW_LINE(FND_FILE.log, 1);

404: EXCEPTION WHEN OTHERS THEN
405: errbuf := errbuf||SQLERRM;
406: retcode := '1';
407: FND_FILE.put_line(fnd_file.log, 'Error in Job Initial Load Extraction: '||SQLCODE);
408: FND_FILE.NEW_LINE(FND_FILE.log, 1);
409: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
410:
411: END HR_JOBCODE_INITIAL_LOAD;
412:

Line 409: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));

405: errbuf := errbuf||SQLERRM;
406: retcode := '1';
407: FND_FILE.put_line(fnd_file.log, 'Error in Job Initial Load Extraction: '||SQLCODE);
408: FND_FILE.NEW_LINE(FND_FILE.log, 1);
409: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
410:
411: END HR_JOBCODE_INITIAL_LOAD;
412:
413: /*Procedure to extract Job Initial Load Ends*/

Line 510: FND_FILE.NEW_LINE(FND_FILE.log, 1);

506:
507: begin
508:
509:
510: FND_FILE.NEW_LINE(FND_FILE.log, 1);
511: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
512: FND_FILE.put_line(fnd_file.log,'Organization Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
513: If number_of_files is not null
514: Then

Line 511: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

507: begin
508:
509:
510: FND_FILE.NEW_LINE(FND_FILE.log, 1);
511: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
512: FND_FILE.put_line(fnd_file.log,'Organization Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
513: If number_of_files is not null
514: Then
515: r :=0;

Line 512: FND_FILE.put_line(fnd_file.log,'Organization Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));

508:
509:
510: FND_FILE.NEW_LINE(FND_FILE.log, 1);
511: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
512: FND_FILE.put_line(fnd_file.log,'Organization Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
513: If number_of_files is not null
514: Then
515: r :=0;
516: For rec in csr_org_initial_load

Line 524: FND_FILE.put_line(fnd_file.log,'No. of files is more than the Number of total records');

520:
521: --If r >0 then total_record_count := r; End If;
522:
523: If r < number_of_files Then
524: FND_FILE.put_line(fnd_file.log,'No. of files is more than the Number of total records');
525: End If;
526: Else
527: number_of_files := 1;
528: r := 1;

Line 530: FND_FILE.NEW_LINE(FND_FILE.log, 1);

526: Else
527: number_of_files := 1;
528: r := 1;
529: End If;
530: FND_FILE.NEW_LINE(FND_FILE.log, 1);
531: FND_FILE.NEW_LINE(FND_FILE.log, 1);
532: FND_FILE.put_line(fnd_file.log,'Total number_of_files = '||number_of_files);
533: if (r > 1) then
534: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);

Line 531: FND_FILE.NEW_LINE(FND_FILE.log, 1);

527: number_of_files := 1;
528: r := 1;
529: End If;
530: FND_FILE.NEW_LINE(FND_FILE.log, 1);
531: FND_FILE.NEW_LINE(FND_FILE.log, 1);
532: FND_FILE.put_line(fnd_file.log,'Total number_of_files = '||number_of_files);
533: if (r > 1) then
534: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);
535: end if;

Line 532: FND_FILE.put_line(fnd_file.log,'Total number_of_files = '||number_of_files);

528: r := 1;
529: End If;
530: FND_FILE.NEW_LINE(FND_FILE.log, 1);
531: FND_FILE.NEW_LINE(FND_FILE.log, 1);
532: FND_FILE.put_line(fnd_file.log,'Total number_of_files = '||number_of_files);
533: if (r > 1) then
534: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);
535: end if;
536: fnd_profile.get('UTL_FILE_OUT', l_file_path);

Line 534: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);

530: FND_FILE.NEW_LINE(FND_FILE.log, 1);
531: FND_FILE.NEW_LINE(FND_FILE.log, 1);
532: FND_FILE.put_line(fnd_file.log,'Total number_of_files = '||number_of_files);
533: if (r > 1) then
534: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);
535: end if;
536: fnd_profile.get('UTL_FILE_OUT', l_file_path);
537: FND_FILE.put_line(fnd_file.log,'File Path = '||l_file_path);
538: l_file_name_part := fnd_global.conc_request_id;

Line 537: FND_FILE.put_line(fnd_file.log,'File Path = '||l_file_path);

533: if (r > 1) then
534: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);
535: end if;
536: fnd_profile.get('UTL_FILE_OUT', l_file_path);
537: FND_FILE.put_line(fnd_file.log,'File Path = '||l_file_path);
538: l_file_name_part := fnd_global.conc_request_id;
539: FND_FILE.put_line(fnd_file.log,'File names start with : '||l_file_name_part);
540: if (l_file_path is not null)
541: Then

Line 539: FND_FILE.put_line(fnd_file.log,'File names start with : '||l_file_name_part);

535: end if;
536: fnd_profile.get('UTL_FILE_OUT', l_file_path);
537: FND_FILE.put_line(fnd_file.log,'File Path = '||l_file_path);
538: l_file_name_part := fnd_global.conc_request_id;
539: FND_FILE.put_line(fnd_file.log,'File names start with : '||l_file_name_part);
540: if (l_file_path is not null)
541: Then
542:
543: /*Generate the initial load extraction for location and the column delimiter used is to_char(400)*/

Line 555: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out'||' - Opened.');

551: if ((l_record_counter = ((l_file_counter-1)*(TRUNC((r/number_of_files))))+1 ) )
552: Then
553: l_file_pointer := null;
554: l_file_pointer := UTL_FILE.FOPEN(l_file_path,l_file_name_part||'_'||l_file_counter||'.out','W',32767);
555: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out'||' - Opened.');
556: End If;
557: FETCH csr_org_initial_load
558: INTO p_bg_id,p_org_id,p_eff_date,p_eff_status,p_lang_code,p_bg_name,p_loc_id,p_person_id;
559: EXIT WHEN csr_org_initial_load%NOTFOUND;

Line 579: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');

575: If UTL_FILE.IS_OPEN(l_file_pointer)
576: Then
577: UTL_FILE.FCLOSE(l_file_pointer);
578:
579: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');
580: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||(l_record_counter - l_break_count));
581: l_break_count := l_record_counter;
582: End If;
583: l_file_counter := l_file_counter + 1;

Line 580: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||(l_record_counter - l_break_count));

576: Then
577: UTL_FILE.FCLOSE(l_file_pointer);
578:
579: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');
580: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||(l_record_counter - l_break_count));
581: l_break_count := l_record_counter;
582: End If;
583: l_file_counter := l_file_counter + 1;
584: End If;

Line 593: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');

589: CLOSE csr_org_initial_load;
590: If UTL_FILE.IS_OPEN(l_file_pointer)
591: Then
592: UTL_FILE.FCLOSE(l_file_pointer);
593: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');
594: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||((l_record_counter - 1) - l_break_count));
595: End If;
596: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );
597: Else

Line 594: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||((l_record_counter - 1) - l_break_count));

590: If UTL_FILE.IS_OPEN(l_file_pointer)
591: Then
592: UTL_FILE.FCLOSE(l_file_pointer);
593: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');
594: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||((l_record_counter - 1) - l_break_count));
595: End If;
596: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );
597: Else
598: FND_FILE.NEW_LINE(FND_FILE.log, 1);

Line 596: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );

592: UTL_FILE.FCLOSE(l_file_pointer);
593: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');
594: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||((l_record_counter - 1) - l_break_count));
595: End If;
596: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );
597: Else
598: FND_FILE.NEW_LINE(FND_FILE.log, 1);
599: FND_FILE.put_line(fnd_file.log,'Profile option FND_FILE_OUT has null value. Please specify valid path');
600: raise l_location_exception;

Line 598: FND_FILE.NEW_LINE(FND_FILE.log, 1);

594: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||((l_record_counter - 1) - l_break_count));
595: End If;
596: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );
597: Else
598: FND_FILE.NEW_LINE(FND_FILE.log, 1);
599: FND_FILE.put_line(fnd_file.log,'Profile option FND_FILE_OUT has null value. Please specify valid path');
600: raise l_location_exception;
601: End If;
602: FND_FILE.NEW_LINE(FND_FILE.log, 1);

Line 599: FND_FILE.put_line(fnd_file.log,'Profile option FND_FILE_OUT has null value. Please specify valid path');

595: End If;
596: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );
597: Else
598: FND_FILE.NEW_LINE(FND_FILE.log, 1);
599: FND_FILE.put_line(fnd_file.log,'Profile option FND_FILE_OUT has null value. Please specify valid path');
600: raise l_location_exception;
601: End If;
602: FND_FILE.NEW_LINE(FND_FILE.log, 1);
603: FND_FILE.put_line(fnd_file.log,'Organization Initial Load Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));

Line 602: FND_FILE.NEW_LINE(FND_FILE.log, 1);

598: FND_FILE.NEW_LINE(FND_FILE.log, 1);
599: FND_FILE.put_line(fnd_file.log,'Profile option FND_FILE_OUT has null value. Please specify valid path');
600: raise l_location_exception;
601: End If;
602: FND_FILE.NEW_LINE(FND_FILE.log, 1);
603: FND_FILE.put_line(fnd_file.log,'Organization Initial Load Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
604:
605: EXCEPTION WHEN OTHERS THEN
606: errbuf := errbuf||SQLERRM;

Line 603: FND_FILE.put_line(fnd_file.log,'Organization Initial Load Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));

599: FND_FILE.put_line(fnd_file.log,'Profile option FND_FILE_OUT has null value. Please specify valid path');
600: raise l_location_exception;
601: End If;
602: FND_FILE.NEW_LINE(FND_FILE.log, 1);
603: FND_FILE.put_line(fnd_file.log,'Organization Initial Load Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
604:
605: EXCEPTION WHEN OTHERS THEN
606: errbuf := errbuf||SQLERRM;
607: retcode := '1';

Line 608: FND_FILE.put_line(fnd_file.log, 'Error in Organization Initial Load Extraction: '||SQLCODE);

604:
605: EXCEPTION WHEN OTHERS THEN
606: errbuf := errbuf||SQLERRM;
607: retcode := '1';
608: FND_FILE.put_line(fnd_file.log, 'Error in Organization Initial Load Extraction: '||SQLCODE);
609: FND_FILE.NEW_LINE(FND_FILE.log, 1);
610: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
611:
612: END HR_ORGANIZATION_INITIAL_LOAD;

Line 609: FND_FILE.NEW_LINE(FND_FILE.log, 1);

605: EXCEPTION WHEN OTHERS THEN
606: errbuf := errbuf||SQLERRM;
607: retcode := '1';
608: FND_FILE.put_line(fnd_file.log, 'Error in Organization Initial Load Extraction: '||SQLCODE);
609: FND_FILE.NEW_LINE(FND_FILE.log, 1);
610: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
611:
612: END HR_ORGANIZATION_INITIAL_LOAD;
613:

Line 610: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));

606: errbuf := errbuf||SQLERRM;
607: retcode := '1';
608: FND_FILE.put_line(fnd_file.log, 'Error in Organization Initial Load Extraction: '||SQLCODE);
609: FND_FILE.NEW_LINE(FND_FILE.log, 1);
610: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
611:
612: END HR_ORGANIZATION_INITIAL_LOAD;
613:
614: /*Procedure to extract Organization Initial Load Ends*/

Line 702: FND_FILE.NEW_LINE(FND_FILE.log, 1);

698:
699: begin
700:
701:
702: FND_FILE.NEW_LINE(FND_FILE.log, 1);
703: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
704: FND_FILE.put_line(fnd_file.log,'Workforce Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
705:
706: If number_of_files is not null

Line 703: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

699: begin
700:
701:
702: FND_FILE.NEW_LINE(FND_FILE.log, 1);
703: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
704: FND_FILE.put_line(fnd_file.log,'Workforce Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
705:
706: If number_of_files is not null
707: Then

Line 704: FND_FILE.put_line(fnd_file.log,'Workforce Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));

700:
701:
702: FND_FILE.NEW_LINE(FND_FILE.log, 1);
703: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
704: FND_FILE.put_line(fnd_file.log,'Workforce Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
705:
706: If number_of_files is not null
707: Then
708: r :=0;

Line 717: FND_FILE.put_line(fnd_file.log,'No. of files is more than the Number of total records');

713:
714: --If r >0 then total_record_count := r; End If;
715:
716: If r < number_of_files Then
717: FND_FILE.put_line(fnd_file.log,'No. of files is more than the Number of total records');
718: End If;
719: Else
720: number_of_files := 1;
721: r := 1;

Line 723: FND_FILE.NEW_LINE(FND_FILE.log, 1);

719: Else
720: number_of_files := 1;
721: r := 1;
722: End If;
723: FND_FILE.NEW_LINE(FND_FILE.log, 1);
724: FND_FILE.NEW_LINE(FND_FILE.log, 1);
725: FND_FILE.put_line(fnd_file.log,'Total number_of_files = '||number_of_files);
726: if (r > 1) then
727: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);

Line 724: FND_FILE.NEW_LINE(FND_FILE.log, 1);

720: number_of_files := 1;
721: r := 1;
722: End If;
723: FND_FILE.NEW_LINE(FND_FILE.log, 1);
724: FND_FILE.NEW_LINE(FND_FILE.log, 1);
725: FND_FILE.put_line(fnd_file.log,'Total number_of_files = '||number_of_files);
726: if (r > 1) then
727: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);
728: end if;

Line 725: FND_FILE.put_line(fnd_file.log,'Total number_of_files = '||number_of_files);

721: r := 1;
722: End If;
723: FND_FILE.NEW_LINE(FND_FILE.log, 1);
724: FND_FILE.NEW_LINE(FND_FILE.log, 1);
725: FND_FILE.put_line(fnd_file.log,'Total number_of_files = '||number_of_files);
726: if (r > 1) then
727: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);
728: end if;
729: fnd_profile.get('UTL_FILE_OUT', l_file_path);

Line 727: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);

723: FND_FILE.NEW_LINE(FND_FILE.log, 1);
724: FND_FILE.NEW_LINE(FND_FILE.log, 1);
725: FND_FILE.put_line(fnd_file.log,'Total number_of_files = '||number_of_files);
726: if (r > 1) then
727: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);
728: end if;
729: fnd_profile.get('UTL_FILE_OUT', l_file_path);
730: FND_FILE.put_line(fnd_file.log,'File Path = '||l_file_path);
731: l_file_name_part := fnd_global.conc_request_id;

Line 730: FND_FILE.put_line(fnd_file.log,'File Path = '||l_file_path);

726: if (r > 1) then
727: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);
728: end if;
729: fnd_profile.get('UTL_FILE_OUT', l_file_path);
730: FND_FILE.put_line(fnd_file.log,'File Path = '||l_file_path);
731: l_file_name_part := fnd_global.conc_request_id;
732: FND_FILE.put_line(fnd_file.log,'File names start with : '||l_file_name_part);
733: if (l_file_path is not null)
734: Then

Line 732: FND_FILE.put_line(fnd_file.log,'File names start with : '||l_file_name_part);

728: end if;
729: fnd_profile.get('UTL_FILE_OUT', l_file_path);
730: FND_FILE.put_line(fnd_file.log,'File Path = '||l_file_path);
731: l_file_name_part := fnd_global.conc_request_id;
732: FND_FILE.put_line(fnd_file.log,'File names start with : '||l_file_name_part);
733: if (l_file_path is not null)
734: Then
735:
736: l_record_counter := 1;

Line 748: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out'||' - Opened.');

744: if ((l_record_counter = ((l_file_counter-1)*(TRUNC((r/number_of_files))))+1 ) )
745: Then
746: l_file_pointer := null;
747: l_file_pointer := UTL_FILE.FOPEN(l_file_path,l_file_name_part||'_'||l_file_counter||'.out','W',32767);
748: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out'||' - Opened.');
749: End If;
750:
751: FETCH csr_wkfrc_initial_load
752: INTO p_person_id,p_assignment_id,p_assignment_number,p_effective_start_date,p_effective_end_date,

Line 789: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');

785: If UTL_FILE.IS_OPEN(l_file_pointer)
786: Then
787: UTL_FILE.FCLOSE(l_file_pointer);
788:
789: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');
790: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||(l_record_counter - l_break_count));
791: l_break_count := l_record_counter;
792: End If;
793: l_file_counter := l_file_counter + 1;

Line 790: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||(l_record_counter - l_break_count));

786: Then
787: UTL_FILE.FCLOSE(l_file_pointer);
788:
789: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');
790: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||(l_record_counter - l_break_count));
791: l_break_count := l_record_counter;
792: End If;
793: l_file_counter := l_file_counter + 1;
794: End If;

Line 803: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');

799:
800: If UTL_FILE.IS_OPEN(l_file_pointer)
801: Then
802: UTL_FILE.FCLOSE(l_file_pointer);
803: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');
804: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||((l_record_counter - 1) - l_break_count));
805: End If;
806: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );
807: Else

Line 804: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||((l_record_counter - 1) - l_break_count));

800: If UTL_FILE.IS_OPEN(l_file_pointer)
801: Then
802: UTL_FILE.FCLOSE(l_file_pointer);
803: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');
804: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||((l_record_counter - 1) - l_break_count));
805: End If;
806: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );
807: Else
808: FND_FILE.NEW_LINE(FND_FILE.log, 1);

Line 806: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );

802: UTL_FILE.FCLOSE(l_file_pointer);
803: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');
804: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||((l_record_counter - 1) - l_break_count));
805: End If;
806: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );
807: Else
808: FND_FILE.NEW_LINE(FND_FILE.log, 1);
809: FND_FILE.put_line(fnd_file.log,'Profile option FND_FILE_OUT has null value. Please specify valid path');
810: raise l_location_exception;

Line 808: FND_FILE.NEW_LINE(FND_FILE.log, 1);

804: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||((l_record_counter - 1) - l_break_count));
805: End If;
806: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );
807: Else
808: FND_FILE.NEW_LINE(FND_FILE.log, 1);
809: FND_FILE.put_line(fnd_file.log,'Profile option FND_FILE_OUT has null value. Please specify valid path');
810: raise l_location_exception;
811: End If;
812:

Line 809: FND_FILE.put_line(fnd_file.log,'Profile option FND_FILE_OUT has null value. Please specify valid path');

805: End If;
806: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );
807: Else
808: FND_FILE.NEW_LINE(FND_FILE.log, 1);
809: FND_FILE.put_line(fnd_file.log,'Profile option FND_FILE_OUT has null value. Please specify valid path');
810: raise l_location_exception;
811: End If;
812:
813: FND_FILE.NEW_LINE(FND_FILE.log, 1);

Line 813: FND_FILE.NEW_LINE(FND_FILE.log, 1);

809: FND_FILE.put_line(fnd_file.log,'Profile option FND_FILE_OUT has null value. Please specify valid path');
810: raise l_location_exception;
811: End If;
812:
813: FND_FILE.NEW_LINE(FND_FILE.log, 1);
814: FND_FILE.put_line(fnd_file.log,'Workforce Initial Load Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
815:
816: EXCEPTION WHEN OTHERS THEN
817: errbuf := errbuf||SQLERRM;

Line 814: FND_FILE.put_line(fnd_file.log,'Workforce Initial Load Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));

810: raise l_location_exception;
811: End If;
812:
813: FND_FILE.NEW_LINE(FND_FILE.log, 1);
814: FND_FILE.put_line(fnd_file.log,'Workforce Initial Load Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
815:
816: EXCEPTION WHEN OTHERS THEN
817: errbuf := errbuf||SQLERRM;
818: retcode := '1';

Line 819: FND_FILE.put_line(fnd_file.log, 'Error in Workforce Initial Load Extraction: '||SQLCODE);

815:
816: EXCEPTION WHEN OTHERS THEN
817: errbuf := errbuf||SQLERRM;
818: retcode := '1';
819: FND_FILE.put_line(fnd_file.log, 'Error in Workforce Initial Load Extraction: '||SQLCODE);
820: FND_FILE.NEW_LINE(FND_FILE.log, 1);
821: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
822:
823: END HR_WORKFORCE_INITIAL_LOAD;

Line 820: FND_FILE.NEW_LINE(FND_FILE.log, 1);

816: EXCEPTION WHEN OTHERS THEN
817: errbuf := errbuf||SQLERRM;
818: retcode := '1';
819: FND_FILE.put_line(fnd_file.log, 'Error in Workforce Initial Load Extraction: '||SQLCODE);
820: FND_FILE.NEW_LINE(FND_FILE.log, 1);
821: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
822:
823: END HR_WORKFORCE_INITIAL_LOAD;
824:

Line 821: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));

817: errbuf := errbuf||SQLERRM;
818: retcode := '1';
819: FND_FILE.put_line(fnd_file.log, 'Error in Workforce Initial Load Extraction: '||SQLCODE);
820: FND_FILE.NEW_LINE(FND_FILE.log, 1);
821: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
822:
823: END HR_WORKFORCE_INITIAL_LOAD;
824:
825: /*Procedure to extract Workforce Initial Load Ends*/

Line 978: FND_FILE.NEW_LINE(FND_FILE.log, 1);

974:
975:
976: begin
977:
978: FND_FILE.NEW_LINE(FND_FILE.log, 1);
979: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
980: FND_FILE.put_line(fnd_file.log,'Person Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
981:
982: /*Generate the initial load extraction for location and the column delimiter used is to_char(400)*/

Line 979: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);

975:
976: begin
977:
978: FND_FILE.NEW_LINE(FND_FILE.log, 1);
979: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
980: FND_FILE.put_line(fnd_file.log,'Person Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
981:
982: /*Generate the initial load extraction for location and the column delimiter used is to_char(400)*/
983: If number_of_files is not null

Line 980: FND_FILE.put_line(fnd_file.log,'Person Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));

976: begin
977:
978: FND_FILE.NEW_LINE(FND_FILE.log, 1);
979: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
980: FND_FILE.put_line(fnd_file.log,'Person Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
981:
982: /*Generate the initial load extraction for location and the column delimiter used is to_char(400)*/
983: If number_of_files is not null
984: Then

Line 994: FND_FILE.put_line(fnd_file.log,'No. of files is more than the Number of total records');

990:
991: --If r >0 then total_record_count := r; End If;
992:
993: If r < number_of_files Then
994: FND_FILE.put_line(fnd_file.log,'No. of files is more than the Number of total records');
995: End If;
996: Else
997: number_of_files := 1;
998: r := 1;

Line 1000: FND_FILE.NEW_LINE(FND_FILE.log, 1);

996: Else
997: number_of_files := 1;
998: r := 1;
999: End If;
1000: FND_FILE.NEW_LINE(FND_FILE.log, 1);
1001: FND_FILE.NEW_LINE(FND_FILE.log, 1);
1002: FND_FILE.put_line(fnd_file.log,'Total number_of_files = '||number_of_files);
1003: if (r > 1) then
1004: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);

Line 1001: FND_FILE.NEW_LINE(FND_FILE.log, 1);

997: number_of_files := 1;
998: r := 1;
999: End If;
1000: FND_FILE.NEW_LINE(FND_FILE.log, 1);
1001: FND_FILE.NEW_LINE(FND_FILE.log, 1);
1002: FND_FILE.put_line(fnd_file.log,'Total number_of_files = '||number_of_files);
1003: if (r > 1) then
1004: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);
1005: end if;

Line 1002: FND_FILE.put_line(fnd_file.log,'Total number_of_files = '||number_of_files);

998: r := 1;
999: End If;
1000: FND_FILE.NEW_LINE(FND_FILE.log, 1);
1001: FND_FILE.NEW_LINE(FND_FILE.log, 1);
1002: FND_FILE.put_line(fnd_file.log,'Total number_of_files = '||number_of_files);
1003: if (r > 1) then
1004: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);
1005: end if;
1006: fnd_profile.get('UTL_FILE_OUT', l_file_path);

Line 1004: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);

1000: FND_FILE.NEW_LINE(FND_FILE.log, 1);
1001: FND_FILE.NEW_LINE(FND_FILE.log, 1);
1002: FND_FILE.put_line(fnd_file.log,'Total number_of_files = '||number_of_files);
1003: if (r > 1) then
1004: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);
1005: end if;
1006: fnd_profile.get('UTL_FILE_OUT', l_file_path);
1007: FND_FILE.put_line(fnd_file.log,'File Path = '||l_file_path);
1008: l_file_name_part := fnd_global.conc_request_id;

Line 1007: FND_FILE.put_line(fnd_file.log,'File Path = '||l_file_path);

1003: if (r > 1) then
1004: FND_FILE.put_line(fnd_file.log,'Total Number of Records = '||r);
1005: end if;
1006: fnd_profile.get('UTL_FILE_OUT', l_file_path);
1007: FND_FILE.put_line(fnd_file.log,'File Path = '||l_file_path);
1008: l_file_name_part := fnd_global.conc_request_id;
1009: FND_FILE.put_line(fnd_file.log,'File names start with : '||l_file_name_part);
1010: if (l_file_path is not null)
1011: Then

Line 1009: FND_FILE.put_line(fnd_file.log,'File names start with : '||l_file_name_part);

1005: end if;
1006: fnd_profile.get('UTL_FILE_OUT', l_file_path);
1007: FND_FILE.put_line(fnd_file.log,'File Path = '||l_file_path);
1008: l_file_name_part := fnd_global.conc_request_id;
1009: FND_FILE.put_line(fnd_file.log,'File names start with : '||l_file_name_part);
1010: if (l_file_path is not null)
1011: Then
1012:
1013: /*Generate the initial load extraction for location and the column delimiter used is to_char(400)*/

Line 1025: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out'||' - Opened.');

1021: if ((l_record_counter = ((l_file_counter-1)*(TRUNC((r/number_of_files))))+1 ) )
1022: Then
1023: l_file_pointer := null;
1024: l_file_pointer := UTL_FILE.FOPEN(l_file_path,l_file_name_part||'_'||l_file_counter||'.out','W',32767);
1025: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out'||' - Opened.');
1026: End If;
1027:
1028: fetch csr_person_data into p_person_id,p_business_group_id,p_legislation_code,p_employee_number,p_applicant_number,p_npw_number,p_person_type_id,
1029: p_date_of_birth,p_town_of_birth,p_cntry_of_birth,p_date_of_death,p_orig_dt_of_hire,p_eff_start_date,

Line 1438: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');

1434: If UTL_FILE.IS_OPEN(l_file_pointer)
1435: Then
1436: UTL_FILE.FCLOSE(l_file_pointer);
1437:
1438: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');
1439: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||(l_record_counter - l_break_count));
1440: l_break_count := l_record_counter;
1441: End If;
1442: l_file_counter := l_file_counter + 1;

Line 1439: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||(l_record_counter - l_break_count));

1435: Then
1436: UTL_FILE.FCLOSE(l_file_pointer);
1437:
1438: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');
1439: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||(l_record_counter - l_break_count));
1440: l_break_count := l_record_counter;
1441: End If;
1442: l_file_counter := l_file_counter + 1;
1443: End If;

Line 1452: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');

1448:
1449: If UTL_FILE.IS_OPEN(l_file_pointer)
1450: Then
1451: UTL_FILE.FCLOSE(l_file_pointer);
1452: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');
1453: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||((l_record_counter - 1) - l_break_count));
1454: End If;
1455: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );
1456: Else

Line 1453: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||((l_record_counter - 1) - l_break_count));

1449: If UTL_FILE.IS_OPEN(l_file_pointer)
1450: Then
1451: UTL_FILE.FCLOSE(l_file_pointer);
1452: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');
1453: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||((l_record_counter - 1) - l_break_count));
1454: End If;
1455: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );
1456: Else
1457: FND_FILE.NEW_LINE(FND_FILE.log, 1);

Line 1455: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );

1451: UTL_FILE.FCLOSE(l_file_pointer);
1452: FND_FILE.put_line(fnd_file.log,'File - '||l_file_counter||' = '||l_file_name_part||'_'||l_file_counter||'.out - closed.');
1453: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||((l_record_counter - 1) - l_break_count));
1454: End If;
1455: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );
1456: Else
1457: FND_FILE.NEW_LINE(FND_FILE.log, 1);
1458: FND_FILE.put_line(fnd_file.log,'Profile option FND_FILE_OUT has null value. Please specify valid path');
1459: raise l_location_exception;

Line 1457: FND_FILE.NEW_LINE(FND_FILE.log, 1);

1453: FND_FILE.put_line(fnd_file.log,'Number of records written into '||l_file_name_part||'_'||l_file_counter||'.out = '||((l_record_counter - 1) - l_break_count));
1454: End If;
1455: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );
1456: Else
1457: FND_FILE.NEW_LINE(FND_FILE.log, 1);
1458: FND_FILE.put_line(fnd_file.log,'Profile option FND_FILE_OUT has null value. Please specify valid path');
1459: raise l_location_exception;
1460: End If;
1461:

Line 1458: FND_FILE.put_line(fnd_file.log,'Profile option FND_FILE_OUT has null value. Please specify valid path');

1454: End If;
1455: FND_FILE.PUT_LINE(fnd_file.log,'Total Number of records written into '||l_file_counter||' files = '|| (l_record_counter - 1) );
1456: Else
1457: FND_FILE.NEW_LINE(FND_FILE.log, 1);
1458: FND_FILE.put_line(fnd_file.log,'Profile option FND_FILE_OUT has null value. Please specify valid path');
1459: raise l_location_exception;
1460: End If;
1461:
1462: FND_FILE.NEW_LINE(FND_FILE.log, 1);

Line 1462: FND_FILE.NEW_LINE(FND_FILE.log, 1);

1458: FND_FILE.put_line(fnd_file.log,'Profile option FND_FILE_OUT has null value. Please specify valid path');
1459: raise l_location_exception;
1460: End If;
1461:
1462: FND_FILE.NEW_LINE(FND_FILE.log, 1);
1463: FND_FILE.put_line(fnd_file.log,'Person Initial Load Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
1464:
1465: EXCEPTION WHEN OTHERS THEN
1466: errbuf := errbuf||SQLERRM;

Line 1463: FND_FILE.put_line(fnd_file.log,'Person Initial Load Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));

1459: raise l_location_exception;
1460: End If;
1461:
1462: FND_FILE.NEW_LINE(FND_FILE.log, 1);
1463: FND_FILE.put_line(fnd_file.log,'Person Initial Load Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
1464:
1465: EXCEPTION WHEN OTHERS THEN
1466: errbuf := errbuf||SQLERRM;
1467: retcode := '1';

Line 1468: FND_FILE.put_line(fnd_file.log, 'Error in Person Initial Load Extraction: '||SQLCODE);

1464:
1465: EXCEPTION WHEN OTHERS THEN
1466: errbuf := errbuf||SQLERRM;
1467: retcode := '1';
1468: FND_FILE.put_line(fnd_file.log, 'Error in Person Initial Load Extraction: '||SQLCODE);
1469: FND_FILE.NEW_LINE(FND_FILE.log, 1);
1470: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
1471:
1472: END HR_PERSON_INITIAL_LOAD;

Line 1469: FND_FILE.NEW_LINE(FND_FILE.log, 1);

1465: EXCEPTION WHEN OTHERS THEN
1466: errbuf := errbuf||SQLERRM;
1467: retcode := '1';
1468: FND_FILE.put_line(fnd_file.log, 'Error in Person Initial Load Extraction: '||SQLCODE);
1469: FND_FILE.NEW_LINE(FND_FILE.log, 1);
1470: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
1471:
1472: END HR_PERSON_INITIAL_LOAD;
1473:

Line 1470: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));

1466: errbuf := errbuf||SQLERRM;
1467: retcode := '1';
1468: FND_FILE.put_line(fnd_file.log, 'Error in Person Initial Load Extraction: '||SQLCODE);
1469: FND_FILE.NEW_LINE(FND_FILE.log, 1);
1470: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
1471:
1472: END HR_PERSON_INITIAL_LOAD;
1473:
1474: /*Procedure to extract Person Initial Load Ends*/