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_H2PI_UPLOAD dependencies on UTL_FILE

Line 113: l_fp UTL_FILE.file_type;

109: procedure upload (p_errbuf OUT NOCOPY VARCHAR2,
110: p_retcode OUT NOCOPY NUMBER,
111: p_file_name IN VARCHAR2) IS
112:
113: l_fp UTL_FILE.file_type;
114: l_line varchar2(32767);
115: l_text varchar2(32767);
116:
117: l_xmldoc clob;

Line 146: l_fp := UTL_FILE.fopen(FND_PROFILE.VALUE('PER_H2PI_DATA_UPLOAD_DIRECTORY'),p_file_name,'r');

142: fnd_message.raise_error;
143: END;
144: */
145:
146: l_fp := UTL_FILE.fopen(FND_PROFILE.VALUE('PER_H2PI_DATA_UPLOAD_DIRECTORY'),p_file_name,'r');
147:
148: --
149: -- FOR HR_H2PI_EMPLOYEES table.
150: --

Line 157: utl_file.get_line(l_fp,l_line);

153: --
154: hr_utility.set_location(l_proc, 20);
155: <>
156: loop
157: utl_file.get_line(l_fp,l_line);
158: l_text := l_line;
159: if l_text is not null then
160: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
161: end if;

Line 181: utl_file.get_line(l_fp,l_line);

177: --
178: hr_utility.set_location('Entering:'|| l_proc, 30);
179: <>
180: loop
181: utl_file.get_line(l_fp,l_line);
182: l_text := l_line;
183: if l_text is not null then
184: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
185: end if;

Line 205: utl_file.get_line(l_fp,l_line);

201: --
202: hr_utility.set_location('Entering:'|| l_proc, 40);
203: <>
204: loop
205: utl_file.get_line(l_fp,l_line);
206: l_text := l_line;
207: if l_text is not null then
208: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
209: end if;

Line 229: utl_file.get_line(l_fp,l_line);

225: --
226: hr_utility.set_location('Entering:'|| l_proc, 50);
227: <>
228: loop
229: utl_file.get_line(l_fp,l_line);
230: l_text := l_line;
231: if l_text is not null then
232: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
233: end if;

Line 252: utl_file.get_line(l_fp,l_line);

248: --
249: hr_utility.set_location('Entering:'|| l_proc, 60);
250: <>
251: loop
252: utl_file.get_line(l_fp,l_line);
253: l_text := l_line;
254: if l_text is not null then
255: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
256: end if;

Line 275: utl_file.get_line(l_fp,l_line);

271: --
272: hr_utility.set_location('Entering:'|| l_proc, 70);
273: <>
274: loop
275: utl_file.get_line(l_fp,l_line);
276: l_text := l_line;
277: if l_text is not null then
278: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
279: end if;

Line 300: utl_file.get_line(l_fp,l_line);

296: --
297: hr_utility.set_location('Entering:'|| l_proc, 80);
298: <>
299: loop
300: utl_file.get_line(l_fp,l_line);
301: l_text := l_line;
302: if l_text is not null then
303: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
304: end if;

Line 324: utl_file.get_line(l_fp,l_line);

320: --
321: hr_utility.set_location('Entering:'|| l_proc, 90);
322: <>
323: loop
324: utl_file.get_line(l_fp,l_line);
325: l_text := l_line;
326: if l_text is not null then
327: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
328: end if;

Line 348: utl_file.get_line(l_fp,l_line);

344: --
345: hr_utility.set_location('Entering:'|| l_proc, 100);
346: <>
347: loop
348: utl_file.get_line(l_fp,l_line);
349: l_text := l_line;
350: if l_text is not null then
351: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
352: end if;

Line 372: utl_file.get_line(l_fp,l_line);

368: hr_utility.set_location('Entering:'|| l_proc,110);
369: --
370: <>
371: loop
372: utl_file.get_line(l_fp,l_line);
373: l_text := l_line;
374: if l_text is not null then
375: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
376: end if;

Line 396: utl_file.get_line(l_fp,l_line);

392: --
393: hr_utility.set_location('Entering:'|| l_proc, 120);
394: <>
395: loop
396: utl_file.get_line(l_fp,l_line);
397: l_text := l_line;
398: if l_text is not null then
399: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
400: end if;

Line 421: utl_file.get_line(l_fp,l_line);

417: --
418: hr_utility.set_location('Entering:'|| l_proc, 130);
419: <>
420: loop
421: utl_file.get_line(l_fp,l_line);
422: l_text := l_line;
423: if l_text is not null then
424: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
425: end if;

Line 445: utl_file.get_line(l_fp,l_line);

441: --
442: hr_utility.set_location('Entering:'|| l_proc, 140);
443: <>
444: loop
445: utl_file.get_line(l_fp,l_line);
446: l_text := l_line;
447: if l_text is not null then
448: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
449: end if;

Line 469: utl_file.get_line(l_fp,l_line);

465: --
466: hr_utility.set_location('Entering:'|| l_proc, 150);
467: <>
468: loop
469: utl_file.get_line(l_fp,l_line);
470: l_text := l_line;
471: if l_text is not null then
472: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
473: end if;

Line 493: utl_file.get_line(l_fp,l_line);

489: --
490: hr_utility.set_location('Entering:'|| l_proc, 160);
491: <>
492: loop
493: utl_file.get_line(l_fp,l_line);
494: l_text := l_line;
495: if l_text is not null then
496: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
497: end if;

Line 517: utl_file.get_line(l_fp,l_line);

513: --
514: hr_utility.set_location('Entering:'|| l_proc, 170);
515: <>
516: loop
517: utl_file.get_line(l_fp,l_line);
518: l_text := l_line;
519: if l_text is not null then
520: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
521: end if;

Line 541: utl_file.get_line(l_fp,l_line);

537: --
538: hr_utility.set_location('Entering:'|| l_proc, 180);
539: <>
540: loop
541: utl_file.get_line(l_fp,l_line);
542: l_text := l_line;
543: if l_text is not null then
544: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
545: end if;

Line 565: utl_file.get_line(l_fp,l_line);

561: --
562: hr_utility.set_location('Entering:'|| l_proc, 190);
563: <>
564: loop
565: utl_file.get_line(l_fp,l_line);
566: l_text := l_line;
567: if l_text is not null then
568: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
569: end if;

Line 589: utl_file.get_line(l_fp,l_line);

585: --
586: hr_utility.set_location('Entering:'|| l_proc, 200);
587: <>
588: loop
589: utl_file.get_line(l_fp,l_line);
590: l_text := l_line;
591: if l_text is not null then
592: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
593: end if;

Line 612: utl_file.get_line(l_fp,l_line);

608: --
609: hr_utility.set_location('Entering:'|| l_proc, 210);
610: <>
611: loop
612: utl_file.get_line(l_fp,l_line);
613: l_text := l_line;
614: if l_text is not null then
615: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
616: end if;

Line 636: utl_file.get_line(l_fp,l_line);

632: --
633: hr_utility.set_location('Entering:'|| l_proc, 220);
634: <>
635: loop
636: utl_file.get_line(l_fp,l_line);
637: l_text := l_line;
638: if l_text is not null then
639: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
640: end if;

Line 660: utl_file.get_line(l_fp,l_line);

656: --
657: hr_utility.set_location('Entering:'|| l_proc, 230);
658: <>
659: loop
660: utl_file.get_line(l_fp,l_line);
661: l_text := l_line;
662: if l_text is not null then
663: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
664: end if;

Line 684: utl_file.get_line(l_fp,l_line);

680: --
681: hr_utility.set_location('Entering:'|| l_proc, 240);
682: <>
683: loop
684: utl_file.get_line(l_fp,l_line);
685: l_text := l_line;
686: if l_text is not null then
687: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
688: end if;

Line 708: utl_file.get_line(l_fp,l_line);

704: --
705: hr_utility.set_location('Entering:'|| l_proc, 250);
706: <>
707: loop
708: utl_file.get_line(l_fp,l_line);
709: l_text := l_line;
710: if l_text is not null then
711: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
712: end if;

Line 732: utl_file.get_line(l_fp,l_line);

728: --
729: hr_utility.set_location('Entering:'|| l_proc, 260);
730: <>
731: loop
732: utl_file.get_line(l_fp,l_line);
733: l_text := l_line;
734: if l_text is not null then
735: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
736: end if;

Line 757: utl_file.get_line(l_fp,l_line);

753: --
754: <>
755: hr_utility.set_location('Entering:'|| l_proc, 270);
756: loop
757: utl_file.get_line(l_fp,l_line);
758: l_text := l_line;
759: if l_text is not null then
760: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
761: end if;

Line 783: utl_file.get_line(l_fp,l_line);

779: --
780: <>
781: hr_utility.set_location('Entering:'|| l_proc, 280);
782: loop
783: utl_file.get_line(l_fp,l_line);
784: l_text := l_line;
785: if l_text is not null then
786: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
787: end if;

Line 808: utl_file.get_line(l_fp,l_line);

804: --
805: <>
806: hr_utility.set_location('Entering:'|| l_proc, 290);
807: loop
808: utl_file.get_line(l_fp,l_line);
809: l_text := l_line;
810: if l_text is not null then
811: dbms_lob.writeappend(l_dest_clob_loc,length(l_text),l_text);
812: end if;

Line 823: utl_file.fclose(l_fp);

819: --
820: insert_xml_into_table('HR_H2PI_US_CITY_NAMES',l_dest_clob_loc);
821: DBMS_LOB.FREETEMPORARY(l_dest_clob_loc);
822: --
823: utl_file.fclose(l_fp);
824:
825: --commit;
826: hr_utility.set_location('Leaving:'|| l_proc, 300);
827:

Line 829: WHEN UTL_FILE.INVALID_PATH THEN

825: --commit;
826: hr_utility.set_location('Leaving:'|| l_proc, 300);
827:
828: EXCEPTION
829: WHEN UTL_FILE.INVALID_PATH THEN
830: fnd_message.set_name('PER','HR_52089_NOT_OPEN_FILE');
831: fnd_message.set_token('FILENAME',p_file_name);
832: fnd_message.raise_error;
833: WHEN UTL_FILE.INVALID_OPERATION THEN

Line 833: WHEN UTL_FILE.INVALID_OPERATION THEN

829: WHEN UTL_FILE.INVALID_PATH THEN
830: fnd_message.set_name('PER','HR_52089_NOT_OPEN_FILE');
831: fnd_message.set_token('FILENAME',p_file_name);
832: fnd_message.raise_error;
833: WHEN UTL_FILE.INVALID_OPERATION THEN
834: fnd_message.set_name('PER','HR_52089_NOT_OPEN_FILE');
835: fnd_message.set_token('FILENAME',p_file_name);
836: fnd_message.raise_error;
837: