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

Line 4: g_file_type utl_file.file_type;

1: PACKAGE BODY write_audit as
2: /* $Header: payustextio.pkb 120.1 2010/10/07 09:15:34 sjawid noship $ */
3:
4: g_file_type utl_file.file_type;
5: g_IL_fein varchar2(10);
6: g_file_name varchar2(30);
7: TEMP_DIR varchar2(255);
8: TEMP_UTL v$parameter.value%type;

Line 16: l_name varchar2(60) := 'utl_file.fopen';

12: l_per_top varchar2(2000);
13: l_applout varchar2(2000);
14: l_path varchar2(2000);
15: l_file_name varchar2(100);
16: l_name varchar2(60) := 'utl_file.fopen';
17:
18: CURSOR c_concurrent_id is
19: select max(fcr.request_id)
20: from fnd_concurrent_requests fcr

Line 34: where name = 'utl_file_dir';

30:
31: select translate(ltrim(value),',',' ')
32: into TEMP_UTL
33: from v$parameter
34: where name = 'utl_file_dir';
35:
36: if (instr(TEMP_UTL,' ') > 0 and TEMP_UTL is not null) then
37: select substrb(TEMP_UTL, 1, instr(TEMP_UTL,' ') - 1)
38: into TEMP_DIR

Line 56: g_file_type := utl_file.fopen(TEMP_DIR,l_file_name,'w');

52:
53: g_file_name := 'o' || to_char(l_request_id);
54: l_file_name := g_file_name || '.a03';
55:
56: g_file_type := utl_file.fopen(TEMP_DIR,l_file_name,'w');
57:
58: hr_utility.trace('utl_file.fopen :' || l_path);
59: exception when others then
60: hr_utility.set_location('Leaving....' || l_name,999);

Line 58: hr_utility.trace('utl_file.fopen :' || l_path);

54: l_file_name := g_file_name || '.a03';
55:
56: g_file_type := utl_file.fopen(TEMP_DIR,l_file_name,'w');
57:
58: hr_utility.trace('utl_file.fopen :' || l_path);
59: exception when others then
60: hr_utility.set_location('Leaving....' || l_name,999);
61: fnd_message.raise_error;
62: end open;

Line 66: l_name varchar2(60) := 'utl_file.put';

62: end open;
63:
64: procedure put(p_char in varchar2) is
65:
66: l_name varchar2(60) := 'utl_file.put';
67: begin
68:
69: --utl_file.put(g_file_type,convert(p_char,'US7ASCII',c_source_cset));
70:

Line 69: --utl_file.put(g_file_type,convert(p_char,'US7ASCII',c_source_cset));

65:
66: l_name varchar2(60) := 'utl_file.put';
67: begin
68:
69: --utl_file.put(g_file_type,convert(p_char,'US7ASCII',c_source_cset));
70:
71: /*utl_file.put(g_file_type,p_char);*/
72: utl_file.put_line(g_file_type,p_char,true);
73: hr_utility.trace('utl_file.put :' || p_char);

Line 71: /utl_file.put(g_file_type,p_char);/

67: begin
68:
69: --utl_file.put(g_file_type,convert(p_char,'US7ASCII',c_source_cset));
70:
71: /*utl_file.put(g_file_type,p_char);*/
72: utl_file.put_line(g_file_type,p_char,true);
73: hr_utility.trace('utl_file.put :' || p_char);
74:
75: exception when others then

Line 72: utl_file.put_line(g_file_type,p_char,true);

68:
69: --utl_file.put(g_file_type,convert(p_char,'US7ASCII',c_source_cset));
70:
71: /*utl_file.put(g_file_type,p_char);*/
72: utl_file.put_line(g_file_type,p_char,true);
73: hr_utility.trace('utl_file.put :' || p_char);
74:
75: exception when others then
76: hr_utility.set_location('Leaving....' || l_name,999);

Line 73: hr_utility.trace('utl_file.put :' || p_char);

69: --utl_file.put(g_file_type,convert(p_char,'US7ASCII',c_source_cset));
70:
71: /*utl_file.put(g_file_type,p_char);*/
72: utl_file.put_line(g_file_type,p_char,true);
73: hr_utility.trace('utl_file.put :' || p_char);
74:
75: exception when others then
76: hr_utility.set_location('Leaving....' || l_name,999);
77: fnd_message.raise_error;

Line 81: l_name varchar2(60) := ' utl_file.fclose';

77: fnd_message.raise_error;
78: end put;
79:
80: procedure close is
81: l_name varchar2(60) := ' utl_file.fclose';
82: begin
83:
84: -- Close file.
85:

Line 87: utl_file.fclose(g_file_type);

83:
84: -- Close file.
85:
86:
87: utl_file.fclose(g_file_type);
88:
89: hr_utility.trace('utl_file.fclose state mag file closed ');
90: exception when others then
91: hr_utility.set_location('Leaving....' || l_name,999);

Line 89: hr_utility.trace('utl_file.fclose state mag file closed ');

85:
86:
87: utl_file.fclose(g_file_type);
88:
89: hr_utility.trace('utl_file.fclose state mag file closed ');
90: exception when others then
91: hr_utility.set_location('Leaving....' || l_name,999);
92: fnd_message.raise_error;
93: end close;