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_API

Line 101: p_init_msg_list := FND_API.G_FALSE;

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:
104:
105: SAVEPOINT CLOSE_MEDIA_ITEMS_PUB;

Line 102: p_commit := FND_API.G_TRUE;

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:
104:
105: SAVEPOINT CLOSE_MEDIA_ITEMS_PUB;
106: -- Standard call to check for call compatibility.

Line 107: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

103:
104:
105: SAVEPOINT CLOSE_MEDIA_ITEMS_PUB;
106: -- Standard call to check for call compatibility.
107: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
108: p_api_version ,
109: l_api_name ,
110: G_PKG_NAME )
111:

Line 113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

109: l_api_name ,
110: G_PKG_NAME )
111:
112: THEN
113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
114: END IF;
115: -- Initialize message list if p_init_msg_list is set to TRUE.
116: IF FND_API.To_Boolean( p_init_msg_list ) THEN
117: FND_MSG_PUB.initialize;

Line 116: IF FND_API.To_Boolean( p_init_msg_list ) THEN

112: THEN
113: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
114: END IF;
115: -- Initialize message list if p_init_msg_list is set to TRUE.
116: IF FND_API.To_Boolean( p_init_msg_list ) THEN
117: FND_MSG_PUB.initialize;
118: END IF;
119: -- Initialize API return status to success
120: RETCODE := FND_API.G_RET_STS_SUCCESS;

Line 120: RETCODE := FND_API.G_RET_STS_SUCCESS;

116: IF FND_API.To_Boolean( p_init_msg_list ) THEN
117: FND_MSG_PUB.initialize;
118: END IF;
119: -- Initialize API return status to success
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');

Line 158: ,p_init_msg_list=>FND_API.G_FALSE

154: l_milcs_duration := l_end_date_time - c2_rec.start_date_time;
155:
156: JTF_IH_PUB_W.Update_MediaLifecycle
157: (p_api_version=>1.0
158: ,p_init_msg_list=>FND_API.G_FALSE
159: ,p_commit=>FND_API.G_TRUE
160: ,p_resp_appl_id=>1 -- IN RESP APPL ID
161: ,p_resp_id=>1 -- IN RESP ID
162: ,p_user_id=>FND_GLOBAL.USER_ID -- IN USER ID

Line 159: ,p_commit=>FND_API.G_TRUE

155:
156: JTF_IH_PUB_W.Update_MediaLifecycle
157: (p_api_version=>1.0
158: ,p_init_msg_list=>FND_API.G_FALSE
159: ,p_commit=>FND_API.G_TRUE
160: ,p_resp_appl_id=>1 -- IN RESP APPL ID
161: ,p_resp_id=>1 -- IN RESP ID
162: ,p_user_id=>FND_GLOBAL.USER_ID -- IN USER ID
163: ,p_login_id=>NULL -- IN LOGIN ID

Line 289: IF FND_API.To_Boolean( p_commit ) THEN

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;
291: END IF;
292: -- Standard call to get message count and if count is 1, get message info.
293: FND_MSG_PUB.Count_And_Get

Line 299: WHEN FND_API.G_EXC_ERROR THEN

295: p_data => ERRBUF
296: );
297: EXCEPTION
298:
299: WHEN FND_API.G_EXC_ERROR THEN
300: ROLLBACK TO CLOSE_MEDIA_ITEMS_PUB;
301: RETCODE := FND_API.G_RET_STS_ERROR ;
302: FND_MSG_PUB.Count_And_Get
303: ( p_count => l_msg_count ,

Line 301: RETCODE := FND_API.G_RET_STS_ERROR ;

297: EXCEPTION
298:
299: WHEN FND_API.G_EXC_ERROR THEN
300: ROLLBACK TO CLOSE_MEDIA_ITEMS_PUB;
301: RETCODE := FND_API.G_RET_STS_ERROR ;
302: FND_MSG_PUB.Count_And_Get
303: ( p_count => l_msg_count ,
304: p_data => ERRBUF
305: );

Line 306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

302: FND_MSG_PUB.Count_And_Get
303: ( p_count => l_msg_count ,
304: p_data => ERRBUF
305: );
306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
307: ROLLBACK TO CLOSE_MEDIA_ITEMS_PUB;
308: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;
309: FND_MSG_PUB.Count_And_Get
310: ( p_count => l_msg_count ,

Line 308: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;

304: p_data => ERRBUF
305: );
306: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
307: ROLLBACK TO CLOSE_MEDIA_ITEMS_PUB;
308: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;
309: FND_MSG_PUB.Count_And_Get
310: ( p_count => l_msg_count ,
311: p_data => ERRBUF
312: );

Line 315: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;

311: p_data => ERRBUF
312: );
313: WHEN OTHERS THEN
314: ROLLBACK TO CLOSE_MEDIA_ITEMS_PUB;
315: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;
316: IF FND_MSG_PUB.Check_Msg_Level
317: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
318: THEN
319: FND_MSG_PUB.Add_Exc_Msg

Line 367: argument2 => FND_API.G_FALSE,

363: application=>'CCT',
364: program => 'CCT_TIMEOUT_MEDIA_ITEMS',
365: description => 'Concurrent program to timeout IH media items',
366: argument1 => '1.0',
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));

Line 368: argument3 => FND_API.G_TRUE,

364: program => 'CCT_TIMEOUT_MEDIA_ITEMS',
365: description => 'Concurrent program to timeout IH media items',
366: argument1 => '1.0',
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:

Line 415: FND_API.G_FALSE,

411: TIMEOUT_MEDIA_ITEMS(
412: ERRBUF,
413: RETCODE,
414: l_api_version,
415: FND_API.G_FALSE,
416: FND_API.G_FALSE,
417: p_timeout_in_hrs
418: );
419: END TIMEOUT_MEDIA_ITEMS_RS;

Line 416: FND_API.G_FALSE,

412: ERRBUF,
413: RETCODE,
414: l_api_version,
415: FND_API.G_FALSE,
416: FND_API.G_FALSE,
417: p_timeout_in_hrs
418: );
419: END TIMEOUT_MEDIA_ITEMS_RS;
420:

Line 427: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,

423: (
424: ERRBUF OUT NOCOPY VARCHAR2,
425: RETCODE OUT NOCOPY VARCHAR2,
426: p_api_version IN NUMBER,
427: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,
428: p_commit IN VARCHAR2 Default FND_API.G_FALSE,
429: p_timeout_in_hrs IN NUMBER
430: )
431: IS

Line 428: p_commit IN VARCHAR2 Default FND_API.G_FALSE,

424: ERRBUF OUT NOCOPY VARCHAR2,
425: RETCODE OUT NOCOPY VARCHAR2,
426: p_api_version IN NUMBER,
427: p_init_msg_list IN VARCHAR2 Default FND_API.G_FALSE,
428: p_commit IN VARCHAR2 Default FND_API.G_FALSE,
429: p_timeout_in_hrs IN NUMBER
430: )
431: IS
432: l_api_name CONSTANT VARCHAR2(30) := 'TIMEOUT_MEDIA_ITEMS';

Line 454: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

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 ,
455: p_api_version ,
456: l_api_name ,
457: G_PKG_NAME )
458:

Line 460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

456: l_api_name ,
457: G_PKG_NAME )
458:
459: THEN
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: END IF;
462: -- Initialize message list if p_init_msg_list is set to TRUE.
463: IF FND_API.To_Boolean( p_init_msg_list ) THEN
464: FND_MSG_PUB.initialize;

Line 463: IF FND_API.To_Boolean( p_init_msg_list ) THEN

459: THEN
460: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
461: END IF;
462: -- Initialize message list if p_init_msg_list is set to TRUE.
463: IF FND_API.To_Boolean( p_init_msg_list ) THEN
464: FND_MSG_PUB.initialize;
465: END IF;
466: -- Initialize API return status to success
467: RETCODE := FND_API.G_RET_STS_SUCCESS;

Line 467: RETCODE := FND_API.G_RET_STS_SUCCESS;

463: IF FND_API.To_Boolean( p_init_msg_list ) THEN
464: FND_MSG_PUB.initialize;
465: END IF;
466: -- Initialize API return status to success
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');

Line 543: ,p_init_msg_list=>FND_API.G_FALSE

539: l_milcs_duration := l_end_date_time - c2_rec.start_date_time;
540: -- dbms_output.put_line('l_milcs_duration' || to_char(l_milcs_duration));
541: JTF_IH_PUB_W.Update_MediaLifecycle
542: (p_api_version=>1.0
543: ,p_init_msg_list=>FND_API.G_FALSE
544: ,p_commit=>FND_API.G_TRUE
545: ,p_resp_appl_id=>1 -- IN RESP APPL ID
546: ,p_resp_id=>1 -- IN RESP ID
547: ,p_user_id=>FND_GLOBAL.USER_ID -- IN USER ID

Line 544: ,p_commit=>FND_API.G_TRUE

540: -- dbms_output.put_line('l_milcs_duration' || to_char(l_milcs_duration));
541: JTF_IH_PUB_W.Update_MediaLifecycle
542: (p_api_version=>1.0
543: ,p_init_msg_list=>FND_API.G_FALSE
544: ,p_commit=>FND_API.G_TRUE
545: ,p_resp_appl_id=>1 -- IN RESP APPL ID
546: ,p_resp_id=>1 -- IN RESP ID
547: ,p_user_id=>FND_GLOBAL.USER_ID -- IN USER ID
548: ,p_login_id=>NULL -- IN LOGIN ID

Line 612: IF FND_API.To_Boolean( p_commit ) THEN

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;
614: END IF;
615: -- Standard call to get message count and if count is 1, get message info.
616: FND_MSG_PUB.Count_And_Get

Line 622: WHEN FND_API.G_EXC_ERROR THEN

618: p_data => ERRBUF
619: );
620: EXCEPTION
621:
622: WHEN FND_API.G_EXC_ERROR THEN
623: ROLLBACK TO TIMEOUT_MEDIA_ITEMS_PUB;
624: RETCODE := FND_API.G_RET_STS_ERROR ;
625: FND_MSG_PUB.Count_And_Get
626: ( p_count => l_msg_count ,

Line 624: RETCODE := FND_API.G_RET_STS_ERROR ;

620: EXCEPTION
621:
622: WHEN FND_API.G_EXC_ERROR THEN
623: ROLLBACK TO TIMEOUT_MEDIA_ITEMS_PUB;
624: RETCODE := FND_API.G_RET_STS_ERROR ;
625: FND_MSG_PUB.Count_And_Get
626: ( p_count => l_msg_count ,
627: p_data => ERRBUF
628: );

Line 629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

625: FND_MSG_PUB.Count_And_Get
626: ( p_count => l_msg_count ,
627: p_data => ERRBUF
628: );
629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
630: ROLLBACK TO TIMEOUT_MEDIA_ITEMS_PUB;
631: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;
632: FND_MSG_PUB.Count_And_Get
633: ( p_count => l_msg_count ,

Line 631: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;

627: p_data => ERRBUF
628: );
629: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
630: ROLLBACK TO TIMEOUT_MEDIA_ITEMS_PUB;
631: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;
632: FND_MSG_PUB.Count_And_Get
633: ( p_count => l_msg_count ,
634: p_data => ERRBUF
635: );

Line 638: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;

634: p_data => ERRBUF
635: );
636: WHEN OTHERS THEN
637: ROLLBACK TO TIMEOUT_MEDIA_ITEMS_PUB;
638: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR ;
639: IF FND_MSG_PUB.Check_Msg_Level
640: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
641: THEN
642: FND_MSG_PUB.Add_Exc_Msg