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 110: FND_FILE.NEW_LINE(FND_FILE.log, 1);

106:
107: begin
108:
109:
110: FND_FILE.NEW_LINE(FND_FILE.log, 1);
111: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
112: FND_FILE.put_line(fnd_file.log,'Location Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
113:
114: /*Generate the initial load extraction for location and the column delimiter used is to_char(400)*/

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

107: begin
108:
109:
110: FND_FILE.NEW_LINE(FND_FILE.log, 1);
111: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
112: FND_FILE.put_line(fnd_file.log,'Location Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
113:
114: /*Generate the initial load extraction for location and the column delimiter used is to_char(400)*/
115: open CSR_LOC_INITIAL_LOAD;

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

108:
109:
110: FND_FILE.NEW_LINE(FND_FILE.log, 1);
111: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
112: FND_FILE.put_line(fnd_file.log,'Location Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
113:
114: /*Generate the initial load extraction for location and the column delimiter used is to_char(400)*/
115: open CSR_LOC_INITIAL_LOAD;
116: loop

Line 126: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_bg_id||

122:
123: exit when CSR_LOC_INITIAL_LOAD%NOTFOUND;
124:
125:
126: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,p_bg_id||
127: fnd_global.local_chr(400)||p_active_date||
128: fnd_global.local_chr(400)||p_effecive_status||
129: fnd_global.local_chr(400)||p_loc_id||
130: fnd_global.local_chr(400)||p_lang_code||

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

157: end loop;
158: close CSR_LOC_INITIAL_LOAD;
159:
160:
161: FND_FILE.NEW_LINE(FND_FILE.log, 1);
162: FND_FILE.put_line(fnd_file.log,'Location Initial Load Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
163:
164:
165: exception

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

158: close CSR_LOC_INITIAL_LOAD;
159:
160:
161: FND_FILE.NEW_LINE(FND_FILE.log, 1);
162: FND_FILE.put_line(fnd_file.log,'Location Initial Load Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
163:
164:
165: exception
166: when OTHERS then

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

165: exception
166: when OTHERS then
167: errbuf := errbuf||SQLERRM;
168: retcode := '1';
169: FND_FILE.put_line(fnd_file.log, 'Error in Location Initial Load Extraction: '||SQLCODE);
170: FND_FILE.NEW_LINE(FND_FILE.log, 1);
171: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
172:
173: END HR_LOCATION_INITIAL_LOAD;

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

166: when OTHERS then
167: errbuf := errbuf||SQLERRM;
168: retcode := '1';
169: FND_FILE.put_line(fnd_file.log, 'Error in Location Initial Load Extraction: '||SQLCODE);
170: FND_FILE.NEW_LINE(FND_FILE.log, 1);
171: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
172:
173: END HR_LOCATION_INITIAL_LOAD;
174: /*Procedure to extract Location Initial Load Extraction Ends*/

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

167: errbuf := errbuf||SQLERRM;
168: retcode := '1';
169: FND_FILE.put_line(fnd_file.log, 'Error in Location Initial Load Extraction: '||SQLCODE);
170: FND_FILE.NEW_LINE(FND_FILE.log, 1);
171: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
172:
173: END HR_LOCATION_INITIAL_LOAD;
174: /*Procedure to extract Location Initial Load Extraction Ends*/
175:

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

215:
216: begin
217:
218:
219: FND_FILE.NEW_LINE(FND_FILE.log, 1);
220: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
221: FND_FILE.put_line(fnd_file.log,'Job Code Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
222:
223: /*Generate the initial load extraction for job and the column delimiter used is to_char(400)*/

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

216: begin
217:
218:
219: FND_FILE.NEW_LINE(FND_FILE.log, 1);
220: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
221: FND_FILE.put_line(fnd_file.log,'Job Code Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
222:
223: /*Generate the initial load extraction for job and the column delimiter used is to_char(400)*/
224: OPEN csr_job_initial_load;

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

217:
218:
219: FND_FILE.NEW_LINE(FND_FILE.log, 1);
220: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
221: FND_FILE.put_line(fnd_file.log,'Job Code Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
222:
223: /*Generate the initial load extraction for job and the column delimiter used is to_char(400)*/
224: OPEN csr_job_initial_load;
225:

Line 233: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

229: INTO p_job_id,p_business_grp_id,p_lang_code,p_job_descr,p_eff_date,p_eff_status;
230: EXIT WHEN csr_job_initial_load%NOTFOUND;
231:
232:
233: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
234: p_business_grp_id||fnd_global.local_chr(400)||
235: p_job_id||fnd_global.local_chr(400)||
236: p_eff_date||fnd_global.local_chr(400)||
237: p_eff_status||fnd_global.local_chr(400)||

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

241:
242: END Loop;
243: CLOSE csr_job_initial_load;
244:
245: FND_FILE.NEW_LINE(FND_FILE.log, 1);
246: FND_FILE.put_line(fnd_file.log,'Job Code Initial Load Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
247:
248: EXCEPTION WHEN OTHERS THEN
249: errbuf := errbuf||SQLERRM;

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

242: END Loop;
243: CLOSE csr_job_initial_load;
244:
245: FND_FILE.NEW_LINE(FND_FILE.log, 1);
246: FND_FILE.put_line(fnd_file.log,'Job Code Initial Load Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
247:
248: EXCEPTION WHEN OTHERS THEN
249: errbuf := errbuf||SQLERRM;
250: retcode := '1';

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

247:
248: EXCEPTION WHEN OTHERS THEN
249: errbuf := errbuf||SQLERRM;
250: retcode := '1';
251: FND_FILE.put_line(fnd_file.log, 'Error in Job Initial Load Extraction: '||SQLCODE);
252: FND_FILE.NEW_LINE(FND_FILE.log, 1);
253: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
254:
255: END HR_JOBCODE_INITIAL_LOAD;

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

248: EXCEPTION WHEN OTHERS THEN
249: errbuf := errbuf||SQLERRM;
250: retcode := '1';
251: FND_FILE.put_line(fnd_file.log, 'Error in Job Initial Load Extraction: '||SQLCODE);
252: FND_FILE.NEW_LINE(FND_FILE.log, 1);
253: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
254:
255: END HR_JOBCODE_INITIAL_LOAD;
256:

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

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

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

339:
340: begin
341:
342:
343: FND_FILE.NEW_LINE(FND_FILE.log, 1);
344: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
345: FND_FILE.put_line(fnd_file.log,'Organization Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
346:
347: /*Generate the initial load extraction for organization and the column delimiter used is to_char(400)*/

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

340: begin
341:
342:
343: FND_FILE.NEW_LINE(FND_FILE.log, 1);
344: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
345: FND_FILE.put_line(fnd_file.log,'Organization Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
346:
347: /*Generate the initial load extraction for organization and the column delimiter used is to_char(400)*/
348: OPEN csr_org_initial_load;

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

341:
342:
343: FND_FILE.NEW_LINE(FND_FILE.log, 1);
344: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
345: FND_FILE.put_line(fnd_file.log,'Organization Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
346:
347: /*Generate the initial load extraction for organization and the column delimiter used is to_char(400)*/
348: OPEN csr_org_initial_load;
349:

Line 357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

353: 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;
354: EXIT WHEN csr_org_initial_load%NOTFOUND;
355:
356:
357: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
358: p_bg_id||fnd_global.local_chr(400)||
359: p_org_id||fnd_global.local_chr(400)||
360: p_eff_date||fnd_global.local_chr(400)||
361: p_eff_status||fnd_global.local_chr(400)||

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

367:
368: END Loop;
369: CLOSE csr_org_initial_load;
370:
371: FND_FILE.NEW_LINE(FND_FILE.log, 1);
372: FND_FILE.put_line(fnd_file.log,'Organization Initial Load Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
373:
374: EXCEPTION WHEN OTHERS THEN
375: errbuf := errbuf||SQLERRM;

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

368: END Loop;
369: CLOSE csr_org_initial_load;
370:
371: FND_FILE.NEW_LINE(FND_FILE.log, 1);
372: FND_FILE.put_line(fnd_file.log,'Organization Initial Load Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
373:
374: EXCEPTION WHEN OTHERS THEN
375: errbuf := errbuf||SQLERRM;
376: retcode := '1';

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

373:
374: EXCEPTION WHEN OTHERS THEN
375: errbuf := errbuf||SQLERRM;
376: retcode := '1';
377: FND_FILE.put_line(fnd_file.log, 'Error in Organization Initial Load Extraction: '||SQLCODE);
378: FND_FILE.NEW_LINE(FND_FILE.log, 1);
379: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
380:
381: END HR_ORGANIZATION_INITIAL_LOAD;

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

374: EXCEPTION WHEN OTHERS THEN
375: errbuf := errbuf||SQLERRM;
376: retcode := '1';
377: FND_FILE.put_line(fnd_file.log, 'Error in Organization Initial Load Extraction: '||SQLCODE);
378: FND_FILE.NEW_LINE(FND_FILE.log, 1);
379: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
380:
381: END HR_ORGANIZATION_INITIAL_LOAD;
382:

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

375: errbuf := errbuf||SQLERRM;
376: retcode := '1';
377: FND_FILE.put_line(fnd_file.log, 'Error in Organization Initial Load Extraction: '||SQLCODE);
378: FND_FILE.NEW_LINE(FND_FILE.log, 1);
379: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
380:
381: END HR_ORGANIZATION_INITIAL_LOAD;
382:
383: /*Procedure to extract Organization Initial Load Ends*/

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

455:
456: begin
457:
458:
459: FND_FILE.NEW_LINE(FND_FILE.log, 1);
460: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
461: FND_FILE.put_line(fnd_file.log,'Workforce Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
462:
463: /*Generate the initial load extraction for workforce and the column delimiter used is to_char(400)*/

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

456: begin
457:
458:
459: FND_FILE.NEW_LINE(FND_FILE.log, 1);
460: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
461: FND_FILE.put_line(fnd_file.log,'Workforce Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
462:
463: /*Generate the initial load extraction for workforce and the column delimiter used is to_char(400)*/
464: OPEN csr_wkfrc_initial_load;

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

457:
458:
459: FND_FILE.NEW_LINE(FND_FILE.log, 1);
460: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
461: FND_FILE.put_line(fnd_file.log,'Workforce Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
462:
463: /*Generate the initial load extraction for workforce and the column delimiter used is to_char(400)*/
464: OPEN csr_wkfrc_initial_load;
465:

Line 476: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

472: p_supervisor_id ,p_act_termn_date, p_final_prcs_date;
473: EXIT WHEN csr_wkfrc_initial_load%NOTFOUND;
474:
475:
476: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
477: p_business_group_id||fnd_global.local_chr(400)||
478: p_person_id||fnd_global.local_chr(400)||
479: p_assignment_id||fnd_global.local_chr(400)||
480: p_assignment_number||fnd_global.local_chr(400)||

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

498:
499: END Loop;
500: CLOSE csr_wkfrc_initial_load;
501:
502: FND_FILE.NEW_LINE(FND_FILE.log, 1);
503: FND_FILE.put_line(fnd_file.log,'Workforce Initial Load Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
504:
505: EXCEPTION WHEN OTHERS THEN
506: errbuf := errbuf||SQLERRM;

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

499: END Loop;
500: CLOSE csr_wkfrc_initial_load;
501:
502: FND_FILE.NEW_LINE(FND_FILE.log, 1);
503: FND_FILE.put_line(fnd_file.log,'Workforce Initial Load Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
504:
505: EXCEPTION WHEN OTHERS THEN
506: errbuf := errbuf||SQLERRM;
507: retcode := '1';

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

504:
505: EXCEPTION WHEN OTHERS THEN
506: errbuf := errbuf||SQLERRM;
507: retcode := '1';
508: FND_FILE.put_line(fnd_file.log, 'Error in Workforce Initial Load Extraction: '||SQLCODE);
509: FND_FILE.NEW_LINE(FND_FILE.log, 1);
510: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
511:
512: END HR_WORKFORCE_INITIAL_LOAD;

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

505: EXCEPTION WHEN OTHERS THEN
506: errbuf := errbuf||SQLERRM;
507: retcode := '1';
508: FND_FILE.put_line(fnd_file.log, 'Error in Workforce Initial Load Extraction: '||SQLCODE);
509: FND_FILE.NEW_LINE(FND_FILE.log, 1);
510: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
511:
512: END HR_WORKFORCE_INITIAL_LOAD;
513:

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

506: errbuf := errbuf||SQLERRM;
507: retcode := '1';
508: FND_FILE.put_line(fnd_file.log, 'Error in Workforce Initial Load Extraction: '||SQLCODE);
509: FND_FILE.NEW_LINE(FND_FILE.log, 1);
510: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
511:
512: END HR_WORKFORCE_INITIAL_LOAD;
513:
514: /*Procedure to extract Workforce Initial Load Ends*/

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

651:
652:
653: begin
654:
655: FND_FILE.NEW_LINE(FND_FILE.log, 1);
656: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
657: FND_FILE.put_line(fnd_file.log,'Person Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
658:
659: /*Generate the initial load extraction for location and the column delimiter used is to_char(400)*/

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

652:
653: begin
654:
655: FND_FILE.NEW_LINE(FND_FILE.log, 1);
656: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
657: FND_FILE.put_line(fnd_file.log,'Person Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
658:
659: /*Generate the initial load extraction for location and the column delimiter used is to_char(400)*/
660:

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

653: begin
654:
655: FND_FILE.NEW_LINE(FND_FILE.log, 1);
656: FND_FILE.NEW_LINE(FND_FILE.OUTPUT, 1);
657: FND_FILE.put_line(fnd_file.log,'Person Initial Load Extraction Begins:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
658:
659: /*Generate the initial load extraction for location and the column delimiter used is to_char(400)*/
660:
661: /*Generate the initial load extraction for person and the column delimiter used is to_char(400)*/

Line 686: FND_FILE.put_line(FND_FILE.OUTPUT,

682: loop
683: if k <= p_phn_type.count
684: then
685:
686: FND_FILE.put_line(FND_FILE.OUTPUT,
687: p_business_group_id||fnd_global.local_chr(400)||
688: p_person_id||fnd_global.local_chr(400)||
689: p_legislation_code||fnd_global.local_chr(400)||
690: p_employee_number||fnd_global.local_chr(400)||

Line 736: FND_FILE.put_line(FND_FILE.OUTPUT,

732:
733:
734: else
735:
736: FND_FILE.put_line(FND_FILE.OUTPUT,
737: p_business_group_id||fnd_global.local_chr(400)||
738: p_person_id||fnd_global.local_chr(400)||
739: p_legislation_code||fnd_global.local_chr(400)||
740: p_employee_number||fnd_global.local_chr(400)||

Line 796: FND_FILE.put_line(FND_FILE.OUTPUT,

792: loop
793: if k <= p_addr_type.count
794: then
795:
796: FND_FILE.put_line(FND_FILE.OUTPUT,
797: p_business_group_id||fnd_global.local_chr(400)||
798: p_person_id||fnd_global.local_chr(400)||
799: p_legislation_code||fnd_global.local_chr(400)||
800: p_employee_number||fnd_global.local_chr(400)||

Line 845: FND_FILE.put_line(FND_FILE.OUTPUT,

841: fnd_global.local_chr(10)||fnd_global.local_chr(13));
842:
843: else
844:
845: FND_FILE.put_line(FND_FILE.OUTPUT,
846: p_business_group_id||fnd_global.local_chr(400)||
847: p_person_id||fnd_global.local_chr(400)||
848: p_legislation_code||fnd_global.local_chr(400)||
849: p_employee_number||fnd_global.local_chr(400)||

Line 900: FND_FILE.put_line(FND_FILE.OUTPUT,

896: then
897: for k in p_phn_type.first .. p_phn_type.last
898: loop
899:
900: FND_FILE.put_line(FND_FILE.OUTPUT,
901: p_business_group_id||fnd_global.local_chr(400)||
902: p_person_id||fnd_global.local_chr(400)||
903: p_legislation_code||fnd_global.local_chr(400)||
904: p_employee_number||fnd_global.local_chr(400)||

Line 955: FND_FILE.put_line(FND_FILE.OUTPUT,

951: then
952: for k in p_addr_type.first .. p_addr_type.last
953: loop
954:
955: FND_FILE.put_line(FND_FILE.OUTPUT,
956: p_business_group_id||fnd_global.local_chr(400)||
957: p_person_id||fnd_global.local_chr(400)||
958: p_legislation_code||fnd_global.local_chr(400)||
959: p_employee_number||fnd_global.local_chr(400)||

Line 1010: FND_FILE.put_line(FND_FILE.OUTPUT,

1006: if p_addr_type.count = 0 and p_phn_type.count = 0
1007: then
1008:
1009:
1010: FND_FILE.put_line(FND_FILE.OUTPUT,
1011: p_business_group_id||fnd_global.local_chr(400)||
1012: p_person_id||fnd_global.local_chr(400)||
1013: p_legislation_code||fnd_global.local_chr(400)||
1014: p_employee_number||fnd_global.local_chr(400)||

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

1061: END Loop;
1062: close csr_person_data;
1063:
1064:
1065: FND_FILE.NEW_LINE(FND_FILE.log, 1);
1066: FND_FILE.put_line(fnd_file.log,'Person Initial Load Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
1067:
1068: EXCEPTION WHEN OTHERS THEN
1069: errbuf := errbuf||SQLERRM;

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

1062: close csr_person_data;
1063:
1064:
1065: FND_FILE.NEW_LINE(FND_FILE.log, 1);
1066: FND_FILE.put_line(fnd_file.log,'Person Initial Load Extraction Ends:'||to_char(p_effective_date, 'DD/MM/RRRR HH:MI:SS'));
1067:
1068: EXCEPTION WHEN OTHERS THEN
1069: errbuf := errbuf||SQLERRM;
1070: retcode := '1';

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

1067:
1068: EXCEPTION WHEN OTHERS THEN
1069: errbuf := errbuf||SQLERRM;
1070: retcode := '1';
1071: FND_FILE.put_line(fnd_file.log, 'Error in Person Initial Load Extraction: '||SQLCODE);
1072: FND_FILE.NEW_LINE(FND_FILE.log, 1);
1073: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
1074:
1075: END HR_PERSON_INITIAL_LOAD;

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

1068: EXCEPTION WHEN OTHERS THEN
1069: errbuf := errbuf||SQLERRM;
1070: retcode := '1';
1071: FND_FILE.put_line(fnd_file.log, 'Error in Person Initial Load Extraction: '||SQLCODE);
1072: FND_FILE.NEW_LINE(FND_FILE.log, 1);
1073: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
1074:
1075: END HR_PERSON_INITIAL_LOAD;
1076:

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

1069: errbuf := errbuf||SQLERRM;
1070: retcode := '1';
1071: FND_FILE.put_line(fnd_file.log, 'Error in Person Initial Load Extraction: '||SQLCODE);
1072: FND_FILE.NEW_LINE(FND_FILE.log, 1);
1073: FND_FILE.put_line(fnd_file.log, 'Error Msg: '||substr(SQLERRM,1,700));
1074:
1075: END HR_PERSON_INITIAL_LOAD;
1076:
1077: /*Procedure to extract Person Initial Load Ends*/