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.IEO_CONCURRENT_PUB dependencies on FND_FILE

Line 23: fnd_file.put_line(fnd_file.log, 'Starting Processing');

19:
20: BEGIN
21:
22: -- dbms_output.put_line('Starting Processing');
23: fnd_file.put_line(fnd_file.log, 'Starting Processing');
24: fnd_file.put_line(fnd_file.log, 'p_repeat_interval = ' || to_char(p_repeat_interval));
25: l_is_repeat_options_set := fnd_request.set_repeat_options(
26: repeat_interval => p_repeat_interval,
27: repeat_unit => 'MINUTES',

Line 24: fnd_file.put_line(fnd_file.log, 'p_repeat_interval = ' || to_char(p_repeat_interval));

20: BEGIN
21:
22: -- dbms_output.put_line('Starting Processing');
23: fnd_file.put_line(fnd_file.log, 'Starting Processing');
24: fnd_file.put_line(fnd_file.log, 'p_repeat_interval = ' || to_char(p_repeat_interval));
25: l_is_repeat_options_set := fnd_request.set_repeat_options(
26: repeat_interval => p_repeat_interval,
27: repeat_unit => 'MINUTES',
28: repeat_type => 'START');

Line 41: fnd_file.put_line(fnd_file.log, 'Request Id ' || to_char(l_submit_request_id));

37: application=>'IEO',
38: program => 'IEO_CHECK_SERVERS',
39: description => 'Starts the Failover monitoring process');
40:
41: fnd_file.put_line(fnd_file.log, 'Request Id ' || to_char(l_submit_request_id));
42: -- dbms_output.put_line('Request Id ' || to_char(l_submit_request_id));
43:
44: if l_submit_request_id = 0 then
45: rollback;

Line 50: fnd_file.put_line(fnd_file.log, 'Controller Exited');

46: raise REQUEST_NOT_SUBMITTED;
47: else
48: commit;
49: end if;
50: fnd_file.put_line(fnd_file.log, 'Controller Exited');
51: -- dbms_output.put_line('Controller Exited');
52:
53: EXCEPTION
54: WHEN REPEAT_OPTIONS_NOT_SET THEN

Line 57: fnd_file.put_line(fnd_file.log, error_msg);

53: EXCEPTION
54: WHEN REPEAT_OPTIONS_NOT_SET THEN
55: FND_MESSAGE.SET_NAME('IEO','IEO_FO_REPEAT_OPTIONS_NOT_SET');
56: error_msg := FND_MESSAGE.GET;
57: fnd_file.put_line(fnd_file.log, error_msg);
58: l_return_value := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', error_msg);
59:
60: WHEN REQUEST_NOT_SUBMITTED THEN
61: FND_MESSAGE.SET_NAME('IEO','IEO_FO_REQUEST_NOT_SUBMITTED');

Line 63: fnd_file.put_line(fnd_file.log, error_msg);

59:
60: WHEN REQUEST_NOT_SUBMITTED THEN
61: FND_MESSAGE.SET_NAME('IEO','IEO_FO_REQUEST_NOT_SUBMITTED');
62: error_msg := FND_MESSAGE.GET;
63: fnd_file.put_line(fnd_file.log, error_msg);
64: l_return_value := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', error_msg);
65:
66: WHEN OTHERS THEN
67: FND_MESSAGE.SET_NAME('IEO','IEO_FO_UNEXPECTED');

Line 69: fnd_file.put_line(fnd_file.log, error_msg);

65:
66: WHEN OTHERS THEN
67: FND_MESSAGE.SET_NAME('IEO','IEO_FO_UNEXPECTED');
68: error_msg := FND_MESSAGE.GET;
69: fnd_file.put_line(fnd_file.log, error_msg);
70: l_return_value := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', error_msg);
71: END START_PROCESS;
72:
73:

Line 98: fnd_file.put_line(fnd_file.log, 'Check and Restart Worker Program Started 1');

94:
95: BEGIN
96: -- Standard Start of API savepoint
97:
98: fnd_file.put_line(fnd_file.log, 'Check and Restart Worker Program Started 1');
99: p_api_version := 1.0;
100: p_init_msg_list := FND_API.G_FALSE;
101: p_commit := FND_API.G_TRUE;
102:

Line 123: fnd_file.put_line(fnd_file.log, 'Worker Program Started 2');

119: RETCODE := FND_API.G_RET_STS_SUCCESS;
120: -- API body
121:
122:
123: fnd_file.put_line(fnd_file.log, 'Worker Program Started 2');
124: -- dbms_output.put_line('Worker Program Started 2');
125:
126: declare cursor c1 is
127: select server_id, status, trunc((sysdate-last_update_date)*24*60*60) diff1

Line 132: fnd_file.put_line(fnd_file.log,'Cursor declared');

128: from ieo_svr_rt_info
129: where ABS(status) >= 4;
130:
131: begin
132: fnd_file.put_line(fnd_file.log,'Cursor declared');
133: -- dbms_output.put_line('Cursor declared');
134:
135: for c1_rec in c1 loop
136: begin

Line 137: fnd_file.put_line(fnd_file.log,'Processing server id ' || c1_rec.server_id);

133: -- dbms_output.put_line('Cursor declared');
134:
135: for c1_rec in c1 loop
136: begin
137: fnd_file.put_line(fnd_file.log,'Processing server id ' || c1_rec.server_id);
138: -- dbms_output.put_line('Processing server id ' || c1_rec.server_id);
139:
140: if c1_rec.diff1 > 70 then
141: begin

Line 150: fnd_file.put_line(fnd_file.log, 'Request Id ' || to_char(l_submit_request_id));

146: program => 'IEO_PING_AND_RESTART_SVR',
147: description => 'Ping and restart one IC Java Server',
148: argument1 => c1_rec.server_id);
149:
150: fnd_file.put_line(fnd_file.log, 'Request Id ' || to_char(l_submit_request_id));
151: -- dbms_output.put_line('Ping and check server, Request Id ' || to_char(l_submit_request_id));
152:
153: if l_submit_request_id = 0 then
154: rollback;

Line 160: fnd_file.put_line(fnd_file.log, 'Controller Exited');

156: else
157: commit;
158: end if;
159:
160: fnd_file.put_line(fnd_file.log, 'Controller Exited');
161: -- dbms_output.put_line('Controller Exited for server '||c1_rec.server_id);
162:
163: end;
164: end if;

Line 169: fnd_file.put_line(fnd_file.log, 'Worker Program Ended ');

165: end;
166: end loop;
167: end;
168:
169: fnd_file.put_line(fnd_file.log, 'Worker Program Ended ');
170: -- End of API body.
171: -- Standard check of p_commit.
172: IF FND_API.To_Boolean( p_commit ) THEN
173: COMMIT WORK;

Line 199: fnd_file.put_line(fnd_file.log, error_msg);

195: );
196: WHEN REQUEST_NOT_SUBMITTED THEN
197: FND_MESSAGE.SET_NAME('IEO','IEO_FO_REQUEST_NOT_SUBMITTED');
198: error_msg := FND_MESSAGE.GET;
199: fnd_file.put_line(fnd_file.log, error_msg);
200: WHEN OTHERS THEN
201: ROLLBACK TO IEO_CHECK_RESTART_SERVERS_PUB;
202: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;
203: IF FND_MSG_PUB.Check_Msg_Level

Line 249: fnd_file.put_line(fnd_file.log, 'PING and Restart Worker Program Started 1');

245:
246: BEGIN
247: -- Standard Start of API savepoint
248:
249: fnd_file.put_line(fnd_file.log, 'PING and Restart Worker Program Started 1');
250: p_api_version := 1.0;
251: p_init_msg_list := FND_API.G_FALSE;
252: p_commit := FND_API.G_TRUE;
253:

Line 277: fnd_file.put_line(fnd_file.log, 'Execute Server Cmd:');

273: -- heartbeat time is not updated
274: -- send one command through AQ
275: l_server_id := SERVER_ID;
276:
277: fnd_file.put_line(fnd_file.log, 'Execute Server Cmd:');
278: -- dbms_output.put_line('Execute Server Cmd'||SERVER_ID);
279:
280: IEO_ICSM_CMD_PUB.EXECUTE_SERVER_CMD(
281: p_api_version => 1.0 ,

Line 289: fnd_file.put_line(fnd_file.log,'x_result is ' || l_result);

285: x_return_status => l_return_status ,
286: x_msg_count => l_msg_count ,
287: x_msg_data => l_msg_data );
288:
289: fnd_file.put_line(fnd_file.log,'x_result is ' || l_result);
290: fnd_file.put_line(fnd_file.log,'x_return_status is ' || l_return_status);
291: fnd_file.put_line(fnd_file.log,'x_msg_count is ' || l_msg_count);
292: fnd_file.put_line(fnd_file.log,'x_msg_data is ' || l_msg_data);
293:

Line 290: fnd_file.put_line(fnd_file.log,'x_return_status is ' || l_return_status);

286: x_msg_count => l_msg_count ,
287: x_msg_data => l_msg_data );
288:
289: fnd_file.put_line(fnd_file.log,'x_result is ' || l_result);
290: fnd_file.put_line(fnd_file.log,'x_return_status is ' || l_return_status);
291: fnd_file.put_line(fnd_file.log,'x_msg_count is ' || l_msg_count);
292: fnd_file.put_line(fnd_file.log,'x_msg_data is ' || l_msg_data);
293:
294: -- dbms_output.put_line('Done with EXECUTE_SERVER_CMD... here is the result:');

Line 291: fnd_file.put_line(fnd_file.log,'x_msg_count is ' || l_msg_count);

287: x_msg_data => l_msg_data );
288:
289: fnd_file.put_line(fnd_file.log,'x_result is ' || l_result);
290: fnd_file.put_line(fnd_file.log,'x_return_status is ' || l_return_status);
291: fnd_file.put_line(fnd_file.log,'x_msg_count is ' || l_msg_count);
292: fnd_file.put_line(fnd_file.log,'x_msg_data is ' || l_msg_data);
293:
294: -- dbms_output.put_line('Done with EXECUTE_SERVER_CMD... here is the result:');
295: -- dbms_output.put_line('x_result is ' || l_result);

Line 292: fnd_file.put_line(fnd_file.log,'x_msg_data is ' || l_msg_data);

288:
289: fnd_file.put_line(fnd_file.log,'x_result is ' || l_result);
290: fnd_file.put_line(fnd_file.log,'x_return_status is ' || l_return_status);
291: fnd_file.put_line(fnd_file.log,'x_msg_count is ' || l_msg_count);
292: fnd_file.put_line(fnd_file.log,'x_msg_data is ' || l_msg_data);
293:
294: -- dbms_output.put_line('Done with EXECUTE_SERVER_CMD... here is the result:');
295: -- dbms_output.put_line('x_result is ' || l_result);
296: -- dbms_output.put_line('x_return_status is ' || l_return_status);

Line 314: fnd_file.put_line(fnd_file.log,'Checking this node id ' || c2_rec.node_id);

310:
311: begin
312: for c2_rec in c2 loop
313: begin
314: fnd_file.put_line(fnd_file.log,'Checking this node id ' || c2_rec.node_id);
315: -- dbms_output.put_line('Checking this node id ' || c2_rec.node_id);
316:
317: l_node_id := c2_rec.node_id;
318:

Line 359: fnd_file.put_line(fnd_file.log, 'Worker Program Ended ');

355: end;
356: end;
357: end if;
358:
359: fnd_file.put_line(fnd_file.log, 'Worker Program Ended ');
360: -- End of API body.
361: -- Standard check of p_commit.
362: IF FND_API.To_Boolean( p_commit ) THEN
363: COMMIT WORK;