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

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

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

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

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

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

35: application=>'CCT',
36: program => 'CCT_CLOSE_MEDIA_ITEMS',
37: description => 'Concurrent program to close IH media items');
38:
39: -- fnd_file.put_line(fnd_file.log, 'Request Id ' || to_char(l_submit_request_id));
40:
41: if l_submit_request_id = 0 then
42: rollback;
43: raise REQUEST_NOT_SUBMITTED;

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

43: raise REQUEST_NOT_SUBMITTED;
44: else
45: commit;
46: end if;
47: -- fnd_file.put_line(fnd_file.log, 'Controller Exited');
48:
49: EXCEPTION
50: WHEN REPEAT_OPTIONS_NOT_SET THEN
51: FND_MESSAGE.SET_NAME('CCT','CCT_IH_REPEAT_OPTIONS_NOT_SET');

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

49: EXCEPTION
50: WHEN REPEAT_OPTIONS_NOT_SET THEN
51: FND_MESSAGE.SET_NAME('CCT','CCT_IH_REPEAT_OPTIONS_NOT_SET');
52: error_msg := FND_MESSAGE.GET;
53: fnd_file.put_line(fnd_file.log, error_msg);
54: l_return_value := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', error_msg);
55:
56: WHEN REQUEST_NOT_SUBMITTED THEN
57: FND_MESSAGE.SET_NAME('CCT','CCT_IH_REQUEST_NOT_SUBMITTED');

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

55:
56: WHEN REQUEST_NOT_SUBMITTED THEN
57: FND_MESSAGE.SET_NAME('CCT','CCT_IH_REQUEST_NOT_SUBMITTED');
58: error_msg := FND_MESSAGE.GET;
59: fnd_file.put_line(fnd_file.log, error_msg);
60: l_return_value := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', error_msg);
61:
62: WHEN OTHERS THEN
63: FND_MESSAGE.SET_NAME('CCT','CCT_UNEXPECTED');

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

61:
62: WHEN OTHERS THEN
63: FND_MESSAGE.SET_NAME('CCT','CCT_UNEXPECTED');
64: error_msg := FND_MESSAGE.GET;
65: fnd_file.put_line(fnd_file.log, error_msg);
66: l_return_value := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', error_msg);
67: END START_PROCESS;
68:
69:

Line 99: -- fnd_file.put_line(fnd_file.log, 'Worker Program Started 1');

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

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

120: RETCODE := FND_API.G_RET_STS_SUCCESS;
121: -- API body
122:
123:
124: -- fnd_file.put_line(fnd_file.log, 'Worker Program Started 2');
125: -- dbms_output.put_line('Worker Program Started 2');
126:
127: declare cursor c1 is
128: select a.media_item_id, a.last_update_date, a.status, a.classification, a.attribute1, a.attribute2, b.start_date_time

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

129: from cct_media_items a, jtf_ih_media_items b
130: where a.media_type <> 1 and a.media_item_id = b.media_id and b.active = 'Y';
131:
132: begin
133: -- fnd_file.put_line(fnd_file.log,'Cursor declared');
134: -- dbms_output.put_line('Cursor declared');
135: for c1_rec in c1 loop
136:
137: begin

Line 138: -- fnd_file.put_line(fnd_file.log,'Processing media item id ' || c1_rec.media_item_id);

134: -- dbms_output.put_line('Cursor declared');
135: for c1_rec in c1 loop
136:
137: begin
138: -- fnd_file.put_line(fnd_file.log,'Processing media item id ' || c1_rec.media_item_id);
139: -- dbms_output.put_line('Processing media item id ' || c1_rec.media_item_id);
140: if c1_rec.attribute2 = 'Y' then
141: begin
142: -- call was abandoned.

Line 146: -- fnd_file.put_line(fnd_file.log,'Media item id is abandoned ' || c1_rec.media_item_id);

142: -- call was abandoned.
143: -- if routing milcs segment exists and is open close it.
144: -- if inqueue milcs segment exists and is open close it.
145: l_end_date_time := c1_rec.last_update_date;
146: -- fnd_file.put_line(fnd_file.log,'Media item id is abandoned ' || c1_rec.media_item_id);
147: -- dbms_output.put_line('Media item id is abandoned ' || c1_rec.media_item_id);
148: declare cursor c2 is
149: select milcs_id, start_date_time from jtf_ih_media_item_lc_segs where active = 'Y'
150: and media_id = c1_rec.media_item_id;

Line 177: -- fnd_file.put_line(fnd_file.log,'Others exception for abandoned media item ');

173: exception
174: when others then
175: begin
176: null;
177: -- fnd_file.put_line(fnd_file.log,'Others exception for abandoned media item ');
178: end;
179: end ;
180: end loop;
181: end;

Line 226: -- fnd_file.put_line(fnd_file.log,'l_end_date_time' || to_char(l_end_date_time));

222: end if;
223:
224: end;
225: end if;
226: -- fnd_file.put_line(fnd_file.log,'l_end_date_time' || to_char(l_end_date_time));
227: -- dbms_output.put_line('l_end_date_time' || to_char(l_end_date_time));
228:
229: l_duration := l_end_date_time - c1_rec.start_date_time;
230: l_duration := round(24*60*60*l_duration);

Line 232: -- fnd_file.put_line(fnd_file.log,'l_duration' || to_char(l_duration));

228:
229: l_duration := l_end_date_time - c1_rec.start_date_time;
230: l_duration := round(24*60*60*l_duration);
231:
232: -- fnd_file.put_line(fnd_file.log,'l_duration' || to_char(l_duration));
233: -- dbms_output.put_line('l_duration' || to_char(l_duration));
234:
235:
236: JTF_IH_PUB_W.CLOSE_MEDIAITEM

Line 254: -- fnd_file.put_line(fnd_file.log,'Closed mi');

250: ,x_return_status=>l_return_status
251: ,x_msg_count=>l_msg_count
252: ,x_msg_data=>l_msg_data );
253:
254: -- fnd_file.put_line(fnd_file.log,'Closed mi');
255: -- dbms_output.put_line('Closed mi');
256:
257: delete from cct_media_items where media_item_id = c1_rec.media_item_id;
258:

Line 259: -- fnd_file.put_line(fnd_file.log,'deleted mi');

255: -- dbms_output.put_line('Closed mi');
256:
257: delete from cct_media_items where media_item_id = c1_rec.media_item_id;
258:
259: -- fnd_file.put_line(fnd_file.log,'deleted mi');
260: -- dbms_output.put_line('deleted mi');
261: exception
262: when media_item_at_route_point_ex then
263: begin

Line 265: -- fnd_file.put_line(fnd_file.log,'media item is at route point, cannot close.');

261: exception
262: when media_item_at_route_point_ex then
263: begin
264: null;
265: -- fnd_file.put_line(fnd_file.log,'media item is at route point, cannot close.');
266: -- dbms_output.put_line('media item is at route point, cannot close.');
267: end;
268: when no_data_found_ex then
269: begin

Line 271: -- fnd_file.put_line(fnd_file.log,'no data found for media item ');

267: end;
268: when no_data_found_ex then
269: begin
270: null;
271: -- fnd_file.put_line(fnd_file.log,'no data found for media item ');
272: -- dbms_output.put_line('no data found for media item ');
273: end;
274: when others then
275: begin

Line 277: -- fnd_file.put_line(fnd_file.log,'Others exception for media item ');

273: end;
274: when others then
275: begin
276: null;
277: -- fnd_file.put_line(fnd_file.log,'Others exception for media item ');
278: -- dbms_output.put_line('Others exception for media item ');
279: end;
280: end;
281: end loop;

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

282:
283:
284: end;
285:
286: -- fnd_file.put_line(fnd_file.log, 'Worker Program Ended ');
287: -- End of API body.
288: -- Standard check of p_commit.
289: IF FND_API.To_Boolean( p_commit ) THEN
290: COMMIT WORK;

Line 350: -- fnd_file.put_line(fnd_file.log, 'Starting TIMEOUT Processing');

346: REQUEST_NOT_SUBMITTED EXCEPTION;
347:
348: BEGIN
349:
350: -- fnd_file.put_line(fnd_file.log, 'Starting TIMEOUT Processing');
351: -- fnd_file.put_line(fnd_file.log, 'p_timeout_interval = ' || to_char(p_timeout_interval));
352: -- fnd_file.put_line(fnd_file.log, 'p_check_timeout_interval = ' || to_char(p_check_timeout_interval));
353: l_is_repeat_options_set := fnd_request.set_repeat_options(
354: repeat_interval => p_check_timeout_interval,

Line 351: -- fnd_file.put_line(fnd_file.log, 'p_timeout_interval = ' || to_char(p_timeout_interval));

347:
348: BEGIN
349:
350: -- fnd_file.put_line(fnd_file.log, 'Starting TIMEOUT Processing');
351: -- fnd_file.put_line(fnd_file.log, 'p_timeout_interval = ' || to_char(p_timeout_interval));
352: -- fnd_file.put_line(fnd_file.log, 'p_check_timeout_interval = ' || to_char(p_check_timeout_interval));
353: l_is_repeat_options_set := fnd_request.set_repeat_options(
354: repeat_interval => p_check_timeout_interval,
355: repeat_unit => 'HOURS',

Line 352: -- fnd_file.put_line(fnd_file.log, 'p_check_timeout_interval = ' || to_char(p_check_timeout_interval));

348: BEGIN
349:
350: -- fnd_file.put_line(fnd_file.log, 'Starting TIMEOUT Processing');
351: -- fnd_file.put_line(fnd_file.log, 'p_timeout_interval = ' || to_char(p_timeout_interval));
352: -- fnd_file.put_line(fnd_file.log, 'p_check_timeout_interval = ' || to_char(p_check_timeout_interval));
353: l_is_repeat_options_set := fnd_request.set_repeat_options(
354: repeat_interval => p_check_timeout_interval,
355: repeat_unit => 'HOURS',
356: repeat_type => 'START');

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

367: argument2 => FND_API.G_FALSE,
368: argument3 => FND_API.G_TRUE,
369: argument4 => p_timeout_interval);
370:
371: -- fnd_file.put_line(fnd_file.log, 'Request Id ' || to_char(l_submit_request_id));
372:
373: if l_submit_request_id = 0 then
374: rollback;
375: raise REQUEST_NOT_SUBMITTED;

Line 379: -- fnd_file.put_line(fnd_file.log, 'Timeout Controller Exited');

375: raise REQUEST_NOT_SUBMITTED;
376: else
377: commit;
378: end if;
379: -- fnd_file.put_line(fnd_file.log, 'Timeout Controller Exited');
380:
381: EXCEPTION
382: WHEN REPEAT_OPTIONS_NOT_SET THEN
383: FND_MESSAGE.SET_NAME('CCT','CCT_IH_REPEAT_OPTIONS_NOT_SET');

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

381: EXCEPTION
382: WHEN REPEAT_OPTIONS_NOT_SET THEN
383: FND_MESSAGE.SET_NAME('CCT','CCT_IH_REPEAT_OPTIONS_NOT_SET');
384: error_msg := FND_MESSAGE.GET;
385: fnd_file.put_line(fnd_file.log, error_msg);
386: l_return_value := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', error_msg);
387:
388: WHEN REQUEST_NOT_SUBMITTED THEN
389: FND_MESSAGE.SET_NAME('CCT','CCT_IH_REQUEST_NOT_SUBMITTED');

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

387:
388: WHEN REQUEST_NOT_SUBMITTED THEN
389: FND_MESSAGE.SET_NAME('CCT','CCT_IH_REQUEST_NOT_SUBMITTED');
390: error_msg := FND_MESSAGE.GET;
391: fnd_file.put_line(fnd_file.log, error_msg);
392: l_return_value := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', error_msg);
393:
394: WHEN OTHERS THEN
395: FND_MESSAGE.SET_NAME('CCT','CCT_UNEXPTECTED');

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

393:
394: WHEN OTHERS THEN
395: FND_MESSAGE.SET_NAME('CCT','CCT_UNEXPTECTED');
396: error_msg := FND_MESSAGE.GET;
397: fnd_file.put_line(fnd_file.log, error_msg);
398: l_return_value := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR', error_msg);
399: END TIMEOUT_PROCESS;
400:
401:

Line 450: -- fnd_file.put_line(fnd_file.log, 'Worker Program Started 1');

446:
447: BEGIN
448: -- Standard Start of API savepoint
449:
450: -- fnd_file.put_line(fnd_file.log, 'Worker Program Started 1');
451:
452: SAVEPOINT TIMEOUT_MEDIA_ITEMS_PUB;
453: -- Standard call to check for call compatibility.
454: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

Line 471: -- fnd_file.put_line(fnd_file.log, 'Timeout Worker Program Started 2');

467: RETCODE := FND_API.G_RET_STS_SUCCESS;
468: -- API body
469:
470:
471: -- fnd_file.put_line(fnd_file.log, 'Timeout Worker Program Started 2');
472: ---- dbms_output.put_line('Timeout Worker Program Started 2');
473:
474: l_timeout_in_minutes := 60*p_timeout_in_hrs;
475:

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

478: (select media_item_id from cct_media_items where media_type <> 1 and status NOT IN (1,2))
479: and start_date_time <= (sysdate - (l_timeout_in_minutes/1440));
480:
481: begin
482: -- fnd_file.put_line(fnd_file.log,'Cursor declared');
483: -- dbms_output.put_line('Cursor declared');
484: for c1_rec in c1 loop
485:
486: begin

Line 487: -- fnd_file.put_line(fnd_file.log,'Processing media item id ' || c1_rec.media_id);

483: -- dbms_output.put_line('Cursor declared');
484: for c1_rec in c1 loop
485:
486: begin
487: -- fnd_file.put_line(fnd_file.log,'Processing media item id ' || c1_rec.media_id);
488: -- dbms_output.put_line('Processing media item id ' || c1_rec.media_id);
489:
490: l_duration := 0;
491: l_end_date_time := c1_rec.start_date_time;

Line 515: -- fnd_file.put_line(fnd_file.log,'l_end_date_time' || to_char(l_end_date_time));

511: l_end_date_time := l_max_milcs_start_date_time;
512: end if;
513: end if;
514:
515: -- fnd_file.put_line(fnd_file.log,'l_end_date_time' || to_char(l_end_date_time));
516:
517: -- dbms_output.put_line('l_end_date_time' || to_char(l_end_date_time));
518:
519: l_duration := l_end_date_time - c1_rec.start_date_time;

Line 530: -- fnd_file.put_line(fnd_file.log,'l_duration' || to_char(l_duration));

526:
527:
528: -- dbms_output.put_line('After classify');
529:
530: -- fnd_file.put_line(fnd_file.log,'l_duration' || to_char(l_duration));
531: -- dbms_output.put_line('l_duration' || to_char(l_duration));
532: declare cursor c2 is
533: select milcs_id, start_date_time from jtf_ih_media_item_lc_segs where active = 'Y'
534: and media_id = c1_rec.media_id;

Line 562: -- fnd_file.put_line(fnd_file.log,'Others exception for abandoned media item ');

558: exception
559: when others then
560: begin
561: null;
562: -- fnd_file.put_line(fnd_file.log,'Others exception for abandoned media item ');
563: end;
564: end ;
565: end loop;
566: end;

Line 586: -- fnd_file.put_line(fnd_file.log,'Closed mi');

582: ,x_return_status=>l_return_status
583: ,x_msg_count=>l_msg_count
584: ,x_msg_data=>l_msg_data );
585:
586: -- fnd_file.put_line(fnd_file.log,'Closed mi');
587: -- dbms_output.put_line('Closed mi');
588: delete from cct_media_items where media_item_id = c1_rec.media_id;
589: -- fnd_file.put_line(fnd_file.log,'deleted mi');
590: -- dbms_output.put_line('deleted mi');

Line 589: -- fnd_file.put_line(fnd_file.log,'deleted mi');

585:
586: -- fnd_file.put_line(fnd_file.log,'Closed mi');
587: -- dbms_output.put_line('Closed mi');
588: delete from cct_media_items where media_item_id = c1_rec.media_id;
589: -- fnd_file.put_line(fnd_file.log,'deleted mi');
590: -- dbms_output.put_line('deleted mi');
591:
592: exception
593: when others then

Line 596: -- fnd_file.put_line(fnd_file.log,'Others exception for media item ');

592: exception
593: when others then
594: begin
595: null;
596: -- fnd_file.put_line(fnd_file.log,'Others exception for media item ');
597: -- dbms_output.put_line('Others exception for media item ');
598: end;
599: end;
600: end loop;

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

605: media_type <> 1 and status NOT IN (1,2) and creation_date <= (sysdate - (l_timeout_in_minutes/1440)) ;
606:
607: end;
608:
609: -- fnd_file.put_line(fnd_file.log, 'Worker Program Ended ');
610: -- End of API body.
611: -- Standard check of p_commit.
612: IF FND_API.To_Boolean( p_commit ) THEN
613: COMMIT WORK;