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.PAY_NL_IZA_UPLOAD dependencies on UTL_FILE

Line 60: l_file_handle UTL_FILE.file_type;

56: l_proc VARCHAR2 (72) ;
57: l_legislation_code per_business_groups.legislation_code%TYPE;
58:
59: -- File Handling variables
60: l_file_handle UTL_FILE.file_type;
61: l_filename VARCHAR2 (240);
62: l_location VARCHAR2 (400);
63: l_line_read VARCHAR2 (400);
64:

Line 316: UTL_FILE.fopen (l_location, l_filename, c_read_file, c_max_linesize);

312:
313:
314: -- Opening flat file from the specified directory
315: l_file_handle :=
316: UTL_FILE.fopen (l_location, l_filename, c_read_file, c_max_linesize);
317:
318:
319: -- Loop over the file, reading in each line. GET_LINE will
320: -- raise NO_DATA_FOUND when it is done, so we use that as the

Line 330: UTL_FILE.get_line (l_file_handle, l_line_read);

326: BEGIN
327:
328: -- read the file line by line into a string
329:
330: UTL_FILE.get_line (l_file_handle, l_line_read);
331:
332: -- check if the record is Opening Record
333:
334: if substr(l_line_read,1,1) ='1' then

Line 368: -- Input line too large for buffer specified in UTL_FILE.fopen

364: -- exceptions handling
365:
366: EXCEPTION
367: WHEN VALUE_ERROR
368: -- Input line too large for buffer specified in UTL_FILE.fopen
369: THEN
370: IF UTL_FILE.is_open (l_file_handle)
371: THEN
372: UTL_FILE.fclose (l_file_handle);

Line 370: IF UTL_FILE.is_open (l_file_handle)

366: EXCEPTION
367: WHEN VALUE_ERROR
368: -- Input line too large for buffer specified in UTL_FILE.fopen
369: THEN
370: IF UTL_FILE.is_open (l_file_handle)
371: THEN
372: UTL_FILE.fclose (l_file_handle);
373: END IF;
374:

Line 372: UTL_FILE.fclose (l_file_handle);

368: -- Input line too large for buffer specified in UTL_FILE.fopen
369: THEN
370: IF UTL_FILE.is_open (l_file_handle)
371: THEN
372: UTL_FILE.fclose (l_file_handle);
373: END IF;
374:
375: if g_debug then
376: hr_utility.set_location (l_proc, 350);

Line 528: UTL_FILE.fclose (l_file_handle);

524:
525:
526: -- Commit the outstanding records
527: COMMIT;
528: UTL_FILE.fclose (l_file_handle);
529:
530: if g_debug then
531: hr_utility.set_location ( 'Leaving:'|| l_proc, 500);
532: end if;

Line 545: IF UTL_FILE.is_open (l_file_handle) THEN

541:
542: WHEN e_org_id THEN
543: -- Close the file in case off error
544: ROLLBACK;
545: IF UTL_FILE.is_open (l_file_handle) THEN
546: UTL_FILE.fclose (l_file_handle);
547: END IF;
548:
549: if g_debug then

Line 546: UTL_FILE.fclose (l_file_handle);

542: WHEN e_org_id THEN
543: -- Close the file in case off error
544: ROLLBACK;
545: IF UTL_FILE.is_open (l_file_handle) THEN
546: UTL_FILE.fclose (l_file_handle);
547: END IF;
548:
549: if g_debug then
550: hr_utility.set_location (l_proc, 500);

Line 568: IF UTL_FILE.is_open (l_file_handle)

564: WHEN e_fatal_error
565: -- No directory specified
566: THEN
567: -- Close the file in case off error
568: IF UTL_FILE.is_open (l_file_handle)
569: THEN
570: UTL_FILE.fclose (l_file_handle);
571: END IF;
572:

Line 570: UTL_FILE.fclose (l_file_handle);

566: THEN
567: -- Close the file in case off error
568: IF UTL_FILE.is_open (l_file_handle)
569: THEN
570: UTL_FILE.fclose (l_file_handle);
571: END IF;
572:
573: if g_debug then
574: hr_utility.set_location (l_proc, 500);

Line 587: WHEN UTL_FILE.invalid_operation

583:
584: -- Return the message to the ConcMgr (This msg will appear in the log file)
585: errbuf := hr_utility.get_message;
586:
587: WHEN UTL_FILE.invalid_operation
588: -- File could not be opened as requested, perhaps because of operating system permissions
589: -- Also raised when attempting a write operation on a file opened for read, or a read operation
590: -- on a file opened for write.
591:

Line 593: IF UTL_FILE.is_open (l_file_handle)

589: -- Also raised when attempting a write operation on a file opened for read, or a read operation
590: -- on a file opened for write.
591:
592: THEN
593: IF UTL_FILE.is_open (l_file_handle)
594: THEN
595: UTL_FILE.fclose (l_file_handle);
596: END IF;
597:

Line 595: UTL_FILE.fclose (l_file_handle);

591:
592: THEN
593: IF UTL_FILE.is_open (l_file_handle)
594: THEN
595: UTL_FILE.fclose (l_file_handle);
596: END IF;
597:
598: if g_debug then
599: hr_utility.set_location (l_proc, 550);

Line 611: WHEN UTL_FILE.internal_error

607:
608: errbuf := fnd_message.get();
609:
610:
611: WHEN UTL_FILE.internal_error
612: -- Unspecified internal error
613: THEN
614: IF UTL_FILE.is_open (l_file_handle)
615: THEN

Line 614: IF UTL_FILE.is_open (l_file_handle)

610:
611: WHEN UTL_FILE.internal_error
612: -- Unspecified internal error
613: THEN
614: IF UTL_FILE.is_open (l_file_handle)
615: THEN
616: UTL_FILE.fclose (l_file_handle);
617: END IF;
618:

Line 616: UTL_FILE.fclose (l_file_handle);

612: -- Unspecified internal error
613: THEN
614: IF UTL_FILE.is_open (l_file_handle)
615: THEN
616: UTL_FILE.fclose (l_file_handle);
617: END IF;
618:
619: if g_debug then
620: hr_utility.set_location (l_proc, 550);

Line 632: WHEN UTL_FILE.invalid_mode

628:
629: errbuf := fnd_message.get();
630:
631:
632: WHEN UTL_FILE.invalid_mode
633: -- Invalid string specified for file mode
634: THEN
635: IF UTL_FILE.is_open (l_file_handle)
636: THEN

Line 635: IF UTL_FILE.is_open (l_file_handle)

631:
632: WHEN UTL_FILE.invalid_mode
633: -- Invalid string specified for file mode
634: THEN
635: IF UTL_FILE.is_open (l_file_handle)
636: THEN
637: UTL_FILE.fclose (l_file_handle);
638: END IF;
639:

Line 637: UTL_FILE.fclose (l_file_handle);

633: -- Invalid string specified for file mode
634: THEN
635: IF UTL_FILE.is_open (l_file_handle)
636: THEN
637: UTL_FILE.fclose (l_file_handle);
638: END IF;
639:
640: if g_debug then
641: hr_utility.set_location (l_proc, 550);

Line 653: WHEN UTL_FILE.invalid_path

649:
650: errbuf := fnd_message.get();
651:
652:
653: WHEN UTL_FILE.invalid_path
654: -- Directory or filename is invalid or not accessible
655: THEN
656: IF UTL_FILE.is_open (l_file_handle)
657: THEN

Line 656: IF UTL_FILE.is_open (l_file_handle)

652:
653: WHEN UTL_FILE.invalid_path
654: -- Directory or filename is invalid or not accessible
655: THEN
656: IF UTL_FILE.is_open (l_file_handle)
657: THEN
658: UTL_FILE.fclose (l_file_handle);
659: END IF;
660:

Line 658: UTL_FILE.fclose (l_file_handle);

654: -- Directory or filename is invalid or not accessible
655: THEN
656: IF UTL_FILE.is_open (l_file_handle)
657: THEN
658: UTL_FILE.fclose (l_file_handle);
659: END IF;
660:
661: retcode := c_error;
662:

Line 672: WHEN UTL_FILE.invalid_filehandle

668: if g_debug then
669: hr_utility.set_location (l_proc, 550);
670: end if;
671:
672: WHEN UTL_FILE.invalid_filehandle
673: -- File handle does not specify an open file
674: THEN
675: IF UTL_FILE.is_open (l_file_handle)
676: THEN

Line 675: IF UTL_FILE.is_open (l_file_handle)

671:
672: WHEN UTL_FILE.invalid_filehandle
673: -- File handle does not specify an open file
674: THEN
675: IF UTL_FILE.is_open (l_file_handle)
676: THEN
677: UTL_FILE.fclose (l_file_handle);
678: END IF;
679:

Line 677: UTL_FILE.fclose (l_file_handle);

673: -- File handle does not specify an open file
674: THEN
675: IF UTL_FILE.is_open (l_file_handle)
676: THEN
677: UTL_FILE.fclose (l_file_handle);
678: END IF;
679:
680: if g_debug then
681: hr_utility.set_location (l_proc, 550);

Line 694: WHEN UTL_FILE.read_error

690:
691: errbuf := fnd_message.get();
692:
693:
694: WHEN UTL_FILE.read_error
695:
696: -- Operating system error occurred during a read operation
697: THEN
698: IF UTL_FILE.is_open (l_file_handle)

Line 698: IF UTL_FILE.is_open (l_file_handle)

694: WHEN UTL_FILE.read_error
695:
696: -- Operating system error occurred during a read operation
697: THEN
698: IF UTL_FILE.is_open (l_file_handle)
699: THEN
700: UTL_FILE.fclose (l_file_handle);
701: END IF;
702:

Line 700: UTL_FILE.fclose (l_file_handle);

696: -- Operating system error occurred during a read operation
697: THEN
698: IF UTL_FILE.is_open (l_file_handle)
699: THEN
700: UTL_FILE.fclose (l_file_handle);
701: END IF;
702:
703: if g_debug then
704: hr_utility.set_location (l_proc, 650);