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

Line 2538: utl_file.fgetattr(p_file_dir,p_file_name,l_check_file,l_file_size,l_block_size);

2534: l_block_size number;
2535: --
2536: begin
2537: --
2538: utl_file.fgetattr(p_file_dir,p_file_name,l_check_file,l_file_size,l_block_size);
2539: --
2540: -- workaround for some bug
2541: if l_check_file is null
2542: and l_file_size = 0

Line 2568: p_file_out out nocopy utl_file.file_type,

2564: -- -------------------------------------------------------------------------
2565: procedure open_file(
2566: p_file_name in varchar2,
2567: p_file_dir in varchar2,
2568: p_file_out out nocopy utl_file.file_type,
2569: p_file_type in varchar2 default 'a')
2570: is
2571: --
2572: l_file_out utl_file.file_type;

Line 2572: l_file_out utl_file.file_type;

2568: p_file_out out nocopy utl_file.file_type,
2569: p_file_type in varchar2 default 'a')
2570: is
2571: --
2572: l_file_out utl_file.file_type;
2573: l_user_error varchar2(255);
2574: --
2575: begin
2576: --

Line 2580: l_file_out := utl_file.fopen(p_file_dir,p_file_name,p_file_type);

2576: --
2577: if p_file_type = 'a'
2578: or p_file_type = 'w' then
2579: --
2580: l_file_out := utl_file.fopen(p_file_dir,p_file_name,p_file_type);
2581: --
2582: begin
2583: --
2584: utl_file.fclose(l_file_out);

Line 2584: utl_file.fclose(l_file_out);

2580: l_file_out := utl_file.fopen(p_file_dir,p_file_name,p_file_type);
2581: --
2582: begin
2583: --
2584: utl_file.fclose(l_file_out);
2585: --
2586: exception
2587: when others then
2588: null;

Line 2593: p_file_out := utl_file.fopen(p_file_dir,p_file_name,p_file_type,c_max_line_size);

2589: end;
2590: --
2591: end if;
2592: --
2593: p_file_out := utl_file.fopen(p_file_dir,p_file_name,p_file_type,c_max_line_size);
2594: --
2595: exception
2596: when utl_file.invalid_path then
2597: --

Line 2596: when utl_file.invalid_path then

2592: --
2593: p_file_out := utl_file.fopen(p_file_dir,p_file_name,p_file_type,c_max_line_size);
2594: --
2595: exception
2596: when utl_file.invalid_path then
2597: --
2598: if g_debug then
2599: hr_utility.trace('open_file : invalid_path');
2600: end if;

Line 2611: when utl_file.invalid_mode then

2607: fnd_message.set_token('FILE_DIR',p_file_dir,false);
2608: --
2609: raise_application_error(-20100,l_user_error);
2610: --
2611: when utl_file.invalid_mode then
2612: --
2613: if g_debug then
2614: hr_utility.trace('open_file : invalid_mode');
2615: end if;

Line 2627: when utl_file.invalid_operation then

2623: fnd_message.set_token('FILE_MODE','a',false);
2624: --
2625: raise_application_error(-20100,l_user_error);
2626: --
2627: when utl_file.invalid_operation then
2628: --
2629: if g_debug then
2630: hr_utility.trace('open_file : invalid_operation');
2631: end if;

Line 2643: when utl_file.invalid_maxlinesize then

2639: fnd_message.set_token('TEMP_DIR',p_file_dir,false);
2640: --
2641: raise_application_error(-20100,l_user_error);
2642: --
2643: when utl_file.invalid_maxlinesize then
2644: --
2645: if g_debug then
2646: hr_utility.trace('open_file : invalid_maxlinesize');
2647: end if;

Line 2674: p_file_out in utl_file.file_type,

2670: -- read_file
2671: -- -------------------------------------------------------------------------
2672: procedure read_file(
2673: p_file_name in varchar2,
2674: p_file_out in utl_file.file_type,
2675: p_file_data_tbl out nocopy t_file_data_tbl)
2676: is
2677: --
2678: l_file_data_tbl t_file_data_tbl;

Line 2692: utl_file.get_line(p_file_out,l_file_data_tbl(l_file_data_tbl_cnt));

2688: loop
2689: --
2690: begin
2691: --
2692: utl_file.get_line(p_file_out,l_file_data_tbl(l_file_data_tbl_cnt));
2693: -- remove carriage return for linux
2694: l_file_data_tbl(l_file_data_tbl_cnt) := replace(l_file_data_tbl(l_file_data_tbl_cnt),c_cr,null);
2695: l_file_data_tbl_cnt := l_file_data_tbl_cnt + 1;
2696: --

Line 2707: when utl_file.invalid_filehandle then

2703: --
2704: p_file_data_tbl := l_file_data_tbl;
2705: --
2706: exception
2707: when utl_file.invalid_filehandle then
2708: --
2709: if g_debug then
2710: hr_utility.trace('read_file : invalid_filehandle');
2711: end if;

Line 2722: when utl_file.invalid_operation then

2718: fnd_message.set_token('TEMP_FILE',p_file_name,false);
2719: --
2720: raise_application_error(-20100,l_user_error);
2721: --
2722: when utl_file.invalid_operation then
2723: --
2724: if g_debug then
2725: hr_utility.trace('read_file : invalid_operation');
2726: end if;

Line 2737: when utl_file.read_error then

2733: fnd_message.set_token('TEMP_FILE',p_file_name,false);
2734: --
2735: raise_application_error(-20100,l_user_error);
2736: --
2737: when utl_file.read_error then
2738: --
2739: if g_debug then
2740: hr_utility.trace('read_file : read_error');
2741: end if;

Line 2767: p_file_out in utl_file.file_type,

2763: -- write_file
2764: -- -------------------------------------------------------------------------
2765: procedure write_file(
2766: p_file_name in varchar2,
2767: p_file_out in utl_file.file_type,
2768: p_line in varchar2,
2769: p_char_set in varchar2 default null)
2770: is
2771: --

Line 2826: utl_file.put(p_file_out, substr(p_line,l_char_s,l_char_len));

2822: l_char_len := l_max_char_len;
2823: end if;
2824: --
2825: -- use substr (not substrb)
2826: utl_file.put(p_file_out, substr(p_line,l_char_s,l_char_len));
2827: -- mandatory for except ORA-29285 (limitation max char size in 1 line)
2828: utl_file.new_line(p_file_out,1);
2829: --
2830: l_char_s := l_char_s + l_char_len;

Line 2828: utl_file.new_line(p_file_out,1);

2824: --
2825: -- use substr (not substrb)
2826: utl_file.put(p_file_out, substr(p_line,l_char_s,l_char_len));
2827: -- mandatory for except ORA-29285 (limitation max char size in 1 line)
2828: utl_file.new_line(p_file_out,1);
2829: --
2830: l_char_s := l_char_s + l_char_len;
2831: --
2832: end if;

Line 2836: utl_file.new_line(p_file_out,1);

2832: end if;
2833: --
2834: end loop loop_write_line;
2835: --
2836: utl_file.new_line(p_file_out,1);
2837: --
2838: else
2839: --
2840: if g_debug then

Line 2844: utl_file.put_line(p_file_out,p_line);

2840: if g_debug then
2841: hr_utility.trace('write_file normal length');
2842: end if;
2843: --
2844: utl_file.put_line(p_file_out,p_line);
2845: --
2846: end if;
2847: --
2848: exception

Line 2849: when utl_file.invalid_filehandle then

2845: --
2846: end if;
2847: --
2848: exception
2849: when utl_file.invalid_filehandle then
2850: --
2851: if g_debug then
2852: hr_utility.trace('write_file : invalid_filehandle');
2853: end if;

Line 2864: when utl_file.invalid_operation then

2860: fnd_message.set_token('TEMP_FILE',p_file_name,false);
2861: --
2862: raise_application_error(-20100,l_user_error);
2863: --
2864: when utl_file.invalid_operation then
2865: --
2866: if g_debug then
2867: hr_utility.trace('write_file : invalid_operation');
2868: end if;

Line 2879: when utl_file.write_error then

2875: fnd_message.set_token('TEMP_FILE',p_file_name,false);
2876: --
2877: raise_application_error(-20100,l_user_error);
2878: --
2879: when utl_file.write_error then
2880: --
2881: if g_debug then
2882: hr_utility.trace('write_file : write_error');
2883: end if;

Line 2909: p_file_out in out nocopy utl_file.file_type,

2905: -- close_file
2906: -- -------------------------------------------------------------------------
2907: procedure close_file(
2908: p_file_name in varchar2,
2909: p_file_out in out nocopy utl_file.file_type,
2910: p_file_type in varchar2 default 'a')
2911: is
2912: --
2913: begin

Line 2919: utl_file.fflush(p_file_out);

2915: -- fflush is not necessary if the case is to refer file while writing
2916: -- exclude case in w, a because of performance reason
2917: if p_file_type = 'f' then
2918: --
2919: utl_file.fflush(p_file_out);
2920: --
2921: end if;
2922: --
2923: utl_file.fclose(p_file_out);

Line 2923: utl_file.fclose(p_file_out);

2919: utl_file.fflush(p_file_out);
2920: --
2921: end if;
2922: --
2923: utl_file.fclose(p_file_out);
2924: --
2925: exception
2926: when others then
2927: --

Line 2950: utl_file.fgetattr(p_file_dir,p_file_name,l_file_chk,l_file_size,l_block_size);

2946: l_block_size number;
2947: --
2948: begin
2949: --
2950: utl_file.fgetattr(p_file_dir,p_file_name,l_file_chk,l_file_size,l_block_size);
2951: if l_file_chk then
2952: --
2953: utl_file.fremove(p_file_dir,p_file_name);
2954: --

Line 2953: utl_file.fremove(p_file_dir,p_file_name);

2949: --
2950: utl_file.fgetattr(p_file_dir,p_file_name,l_file_chk,l_file_size,l_block_size);
2951: if l_file_chk then
2952: --
2953: utl_file.fremove(p_file_dir,p_file_name);
2954: --
2955: end if;
2956: --
2957: exception