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 UTL_FILE

Line 47: l_file_pointer utl_file.file_type;

43: number_of_files Number := p_number_of_files;
44: l_file_path Varchar2(500) := null;
45: l_file_name_part Varchar2(200) := null;
46: l_location_exception Exception;
47: l_file_pointer utl_file.file_type;
48: l_break_count Number;
49:
50:
51:

Line 150: fnd_profile.get('UTL_FILE_OUT', l_file_path);

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;
153: FND_FILE.put_line(fnd_file.log,'File names start with : '||l_file_name_part);
154: if (l_file_path is not null)

Line 168: l_file_pointer := UTL_FILE.FOPEN(l_file_path,l_file_name_part||'_'||l_file_counter||'.out','W',32767);

164:
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,

Line 181: UTL_FILE.PUT_LINE(l_file_pointer,p_bg_id||

177:
178: exit when CSR_LOC_INITIAL_LOAD%NOTFOUND;
179:
180:
181: UTL_FILE.PUT_LINE(l_file_pointer,p_bg_id||
182: fnd_global.local_chr(400)||p_active_date||
183: fnd_global.local_chr(400)||p_effecive_status||
184: fnd_global.local_chr(400)||p_loc_id||
185: fnd_global.local_chr(400)||p_lang_code||

Line 212: If UTL_FILE.IS_OPEN(l_file_pointer)

208: fnd_global.local_chr(10)||fnd_global.local_chr(13));
209:
210: if (l_record_counter = ((l_file_counter)*(TRUNC(r/number_of_files))) and l_file_counter <> number_of_files)
211: Then
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.');

Line 214: UTL_FILE.FCLOSE(l_file_pointer);

210: if (l_record_counter = ((l_file_counter)*(TRUNC(r/number_of_files))) and l_file_counter <> number_of_files)
211: Then
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;

Line 227: If UTL_FILE.IS_OPEN(l_file_pointer)

223:
224: end loop;
225: close CSR_LOC_INITIAL_LOAD;
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));

Line 229: UTL_FILE.FCLOSE(l_file_pointer);

225: close CSR_LOC_INITIAL_LOAD;
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) );

Line 278: l_file_pointer utl_file.file_type;

274: number_of_files Number := p_number_of_files;
275: l_file_path Varchar2(500) := null;
276: l_file_name_part Varchar2(200) := null;
277: l_location_exception Exception;
278: l_file_pointer utl_file.file_type;
279: l_break_count Number;
280:
281:
282: /*Cursor to fetch the job details*/

Line 337: fnd_profile.get('UTL_FILE_OUT', l_file_path);

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;
340: FND_FILE.put_line(fnd_file.log,'File names start with : '||l_file_name_part);
341: if (l_file_path is not null)

Line 355: l_file_pointer := UTL_FILE.FOPEN(l_file_path,l_file_name_part||'_'||l_file_counter||'.out','W',32767);

351: LOOP
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;

Line 363: UTL_FILE.PUT_LINE(l_file_pointer,

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;
361:
362:
363: UTL_FILE.PUT_LINE(l_file_pointer,
364: p_business_grp_id||fnd_global.local_chr(400)||
365: p_job_id||fnd_global.local_chr(400)||
366: p_eff_date||fnd_global.local_chr(400)||
367: p_eff_status||fnd_global.local_chr(400)||

Line 374: If UTL_FILE.IS_OPEN(l_file_pointer)

370: fnd_global.local_chr(10)||fnd_global.local_chr(13));
371:
372: if (l_record_counter = ((l_file_counter)*(TRUNC(r/number_of_files))) and l_file_counter <> number_of_files)
373: Then
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.');

Line 376: UTL_FILE.FCLOSE(l_file_pointer);

372: if (l_record_counter = ((l_file_counter)*(TRUNC(r/number_of_files))) and l_file_counter <> number_of_files)
373: Then
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;

Line 388: If UTL_FILE.IS_OPEN(l_file_pointer)

384: l_record_counter := l_record_counter + 1;
385: END Loop;
386: CLOSE csr_job_initial_load;
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));

Line 390: UTL_FILE.FCLOSE(l_file_pointer);

386: CLOSE csr_job_initial_load;
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) );

Line 440: l_file_pointer utl_file.file_type;

436: number_of_files Number := p_number_of_files;
437: l_file_path Varchar2(500) := null;
438: l_file_name_part Varchar2(200) := null;
439: l_location_exception Exception;
440: l_file_pointer utl_file.file_type;
441: l_break_count Number;
442:
443:
444:

Line 536: fnd_profile.get('UTL_FILE_OUT', l_file_path);

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;
539: FND_FILE.put_line(fnd_file.log,'File names start with : '||l_file_name_part);
540: if (l_file_path is not null)

Line 554: l_file_pointer := UTL_FILE.FOPEN(l_file_path,l_file_name_part||'_'||l_file_counter||'.out','W',32767);

550: LOOP
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;

Line 562: UTL_FILE.PUT_LINE(l_file_pointer,

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;
560:
561:
562: UTL_FILE.PUT_LINE(l_file_pointer,
563: p_bg_id||fnd_global.local_chr(400)||
564: p_org_id||fnd_global.local_chr(400)||
565: p_eff_date||fnd_global.local_chr(400)||
566: p_eff_status||fnd_global.local_chr(400)||

Line 575: If UTL_FILE.IS_OPEN(l_file_pointer)

571: fnd_global.local_chr(10)||fnd_global.local_chr(13));
572:
573: if (l_record_counter = ((l_file_counter)*(TRUNC(r/number_of_files))) and l_file_counter <> number_of_files)
574: Then
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.');

Line 577: UTL_FILE.FCLOSE(l_file_pointer);

573: if (l_record_counter = ((l_file_counter)*(TRUNC(r/number_of_files))) and l_file_counter <> number_of_files)
574: Then
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;

Line 590: If UTL_FILE.IS_OPEN(l_file_pointer)

586:
587:
588: END Loop;
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));

Line 592: UTL_FILE.FCLOSE(l_file_pointer);

588: END Loop;
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) );

Line 653: l_file_pointer utl_file.file_type;

649: number_of_files Number := p_number_of_files;
650: l_file_path Varchar2(500) := null;
651: l_file_name_part Varchar2(200) := null;
652: l_location_exception Exception;
653: l_file_pointer utl_file.file_type;
654: l_break_count Number;
655:
656:
657: /*Cursor to fetch the workforce details*/

Line 729: fnd_profile.get('UTL_FILE_OUT', l_file_path);

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;
732: FND_FILE.put_line(fnd_file.log,'File names start with : '||l_file_name_part);
733: if (l_file_path is not null)

Line 747: l_file_pointer := UTL_FILE.FOPEN(l_file_path,l_file_name_part||'_'||l_file_counter||'.out','W',32767);

743: LOOP
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

Line 759: UTL_FILE.PUT_LINE(l_file_pointer,

755: p_supervisor_id ,p_act_termn_date, p_final_prcs_date,p_primary_flag;
756: EXIT WHEN csr_wkfrc_initial_load%NOTFOUND;
757:
758:
759: UTL_FILE.PUT_LINE(l_file_pointer,
760: p_business_group_id||fnd_global.local_chr(400)||
761: p_person_id||fnd_global.local_chr(400)||
762: p_assignment_id||fnd_global.local_chr(400)||
763: p_assignment_number||fnd_global.local_chr(400)||

Line 785: If UTL_FILE.IS_OPEN(l_file_pointer)

781: fnd_global.local_chr(10)||fnd_global.local_chr(13));
782:
783: if (l_record_counter = ((l_file_counter)*(TRUNC(r/number_of_files))) and l_file_counter <> number_of_files)
784: Then
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.');

Line 787: UTL_FILE.FCLOSE(l_file_pointer);

783: if (l_record_counter = ((l_file_counter)*(TRUNC(r/number_of_files))) and l_file_counter <> number_of_files)
784: Then
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;

Line 800: If UTL_FILE.IS_OPEN(l_file_pointer)

796:
797: END Loop;
798: CLOSE csr_wkfrc_initial_load;
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));

Line 802: UTL_FILE.FCLOSE(l_file_pointer);

798: CLOSE csr_wkfrc_initial_load;
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) );

Line 867: l_file_pointer utl_file.file_type;

863: number_of_files Number := p_number_of_files;
864: l_file_path Varchar2(500) := null;
865: l_file_name_part Varchar2(200) := null;
866: l_location_exception Exception;
867: l_file_pointer utl_file.file_type;
868: l_break_count Number;
869:
870: TYPE ADDRESS IS RECORD
871: (

Line 1006: fnd_profile.get('UTL_FILE_OUT', l_file_path);

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;
1009: FND_FILE.put_line(fnd_file.log,'File names start with : '||l_file_name_part);
1010: if (l_file_path is not null)

Line 1024: l_file_pointer := UTL_FILE.FOPEN(l_file_path,l_file_name_part||'_'||l_file_counter||'.out','W',32767);

1020:
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,

Line 1050: UTL_FILE.put_line(l_file_pointer,

1046: loop
1047: if k <= p_phn_type.count
1048: then
1049:
1050: UTL_FILE.put_line(l_file_pointer,
1051: p_business_group_id||fnd_global.local_chr(400)||
1052: p_person_id||fnd_global.local_chr(400)||
1053: p_legislation_code||fnd_global.local_chr(400)||
1054: p_employee_number||fnd_global.local_chr(400)||

Line 1101: UTL_FILE.put_line(l_file_pointer,

1097:
1098:
1099: else
1100:
1101: UTL_FILE.put_line(l_file_pointer,
1102: p_business_group_id||fnd_global.local_chr(400)||
1103: p_person_id||fnd_global.local_chr(400)||
1104: p_legislation_code||fnd_global.local_chr(400)||
1105: p_employee_number||fnd_global.local_chr(400)||

Line 1162: UTL_FILE.put_line(l_file_pointer,

1158: loop
1159: if k <= p_addr_type.count
1160: then
1161:
1162: UTL_FILE.put_line(l_file_pointer,
1163: p_business_group_id||fnd_global.local_chr(400)||
1164: p_person_id||fnd_global.local_chr(400)||
1165: p_legislation_code||fnd_global.local_chr(400)||
1166: p_employee_number||fnd_global.local_chr(400)||

Line 1212: UTL_FILE.put_line(l_file_pointer,

1208: fnd_global.local_chr(10)||fnd_global.local_chr(13));
1209:
1210: else
1211:
1212: UTL_FILE.put_line(l_file_pointer,
1213: p_business_group_id||fnd_global.local_chr(400)||
1214: p_person_id||fnd_global.local_chr(400)||
1215: p_legislation_code||fnd_global.local_chr(400)||
1216: p_employee_number||fnd_global.local_chr(400)||

Line 1268: UTL_FILE.put_line(l_file_pointer,

1264: then
1265: for k in p_phn_type.first .. p_phn_type.last
1266: loop
1267:
1268: UTL_FILE.put_line(l_file_pointer,
1269: p_business_group_id||fnd_global.local_chr(400)||
1270: p_person_id||fnd_global.local_chr(400)||
1271: p_legislation_code||fnd_global.local_chr(400)||
1272: p_employee_number||fnd_global.local_chr(400)||

Line 1324: UTL_FILE.put_line(l_file_pointer,

1320: then
1321: for k in p_addr_type.first .. p_addr_type.last
1322: loop
1323:
1324: UTL_FILE.put_line(l_file_pointer,
1325: p_business_group_id||fnd_global.local_chr(400)||
1326: p_person_id||fnd_global.local_chr(400)||
1327: p_legislation_code||fnd_global.local_chr(400)||
1328: p_employee_number||fnd_global.local_chr(400)||

Line 1380: UTL_FILE.put_line(l_file_pointer,

1376: if p_addr_type.count = 0 and p_phn_type.count = 0
1377: then
1378:
1379:
1380: UTL_FILE.put_line(l_file_pointer,
1381: p_business_group_id||fnd_global.local_chr(400)||
1382: p_person_id||fnd_global.local_chr(400)||
1383: p_legislation_code||fnd_global.local_chr(400)||
1384: p_employee_number||fnd_global.local_chr(400)||

Line 1434: If UTL_FILE.IS_OPEN(l_file_pointer)

1430: /*Fix for bug 7650158 ends here*/
1431:
1432: if (l_record_counter = ((l_file_counter)*(TRUNC(r/number_of_files))) and l_file_counter <> number_of_files)
1433: Then
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.');

Line 1436: UTL_FILE.FCLOSE(l_file_pointer);

1432: if (l_record_counter = ((l_file_counter)*(TRUNC(r/number_of_files))) and l_file_counter <> number_of_files)
1433: Then
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;

Line 1449: If UTL_FILE.IS_OPEN(l_file_pointer)

1445:
1446: END Loop;
1447: close csr_person_data;
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));

Line 1451: UTL_FILE.FCLOSE(l_file_pointer);

1447: close csr_person_data;
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) );