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_UTIL_PUB dependencies on FND_API

Line 26: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

22: BEGIN
23: -- Standard Start of API savepoint
24: SAVEPOINT GET_MIDDLEWARE_ID_PUB;
25: -- Standard call to check for call compatibility.
26: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
27: p_api_version ,
28: l_api_name ,
29: G_PKG_NAME )
30: THEN

Line 31: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

27: p_api_version ,
28: l_api_name ,
29: G_PKG_NAME )
30: THEN
31: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
32: END IF;
33: -- Initialize message list if p_init_msg_list is set to TRUE.
34: IF FND_API.To_Boolean( p_init_msg_list ) THEN
35: FND_MSG_PUB.initialize;

Line 34: IF FND_API.To_Boolean( p_init_msg_list ) THEN

30: THEN
31: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
32: END IF;
33: -- Initialize message list if p_init_msg_list is set to TRUE.
34: IF FND_API.To_Boolean( p_init_msg_list ) THEN
35: FND_MSG_PUB.initialize;
36: END IF;
37: -- Initialize API return status to success
38: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 38: x_return_status := FND_API.G_RET_STS_SUCCESS;

34: IF FND_API.To_Boolean( p_init_msg_list ) THEN
35: FND_MSG_PUB.initialize;
36: END IF;
37: -- Initialize API return status to success
38: x_return_status := FND_API.G_RET_STS_SUCCESS;
39: -- API body
40:
41: x_middleware_id := -1;
42:

Line 48: IF FND_API.To_Boolean( p_commit ) THEN

44: (select client_id from cct_agent_rt_stats where attribute1='T' and agent_id = p_agent_id);
45:
46: -- End of API body.
47: -- Standard check of p_commit.
48: IF FND_API.To_Boolean( p_commit ) THEN
49: COMMIT WORK;
50: END IF;
51: -- Standard call to get message count and if count is 1, get message info.
52: FND_MSG_PUB.Count_And_Get

Line 58: WHEN FND_API.G_EXC_ERROR THEN

54: p_data => x_msg_data
55: );
56: EXCEPTION
57:
58: WHEN FND_API.G_EXC_ERROR THEN
59: ROLLBACK TO GET_MIDDLEWARE_ID_PUB;
60: x_return_status := FND_API.G_RET_STS_ERROR ;
61: FND_MSG_PUB.Count_And_Get
62: ( p_count => x_msg_count ,

Line 60: x_return_status := FND_API.G_RET_STS_ERROR ;

56: EXCEPTION
57:
58: WHEN FND_API.G_EXC_ERROR THEN
59: ROLLBACK TO GET_MIDDLEWARE_ID_PUB;
60: x_return_status := FND_API.G_RET_STS_ERROR ;
61: FND_MSG_PUB.Count_And_Get
62: ( p_count => x_msg_count ,
63: p_data => x_msg_data
64: );

Line 65: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

61: FND_MSG_PUB.Count_And_Get
62: ( p_count => x_msg_count ,
63: p_data => x_msg_data
64: );
65: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
66: ROLLBACK TO GET_MIDDLEWARE_ID_PUB;
67: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
68: FND_MSG_PUB.Count_And_Get
69: ( p_count => x_msg_count ,

Line 67: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

63: p_data => x_msg_data
64: );
65: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
66: ROLLBACK TO GET_MIDDLEWARE_ID_PUB;
67: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
68: FND_MSG_PUB.Count_And_Get
69: ( p_count => x_msg_count ,
70: p_data => x_msg_data
71: );

Line 74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

70: p_data => x_msg_data
71: );
72: WHEN OTHERS THEN
73: ROLLBACK TO GET_MIDDLEWARE_ID_PUB;
74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
75: IF FND_MSG_PUB.Check_Msg_Level
76: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
77: THEN
78: FND_MSG_PUB.Add_Exc_Msg

Line 113: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

109: BEGIN
110: -- Standard Start of API savepoint
111: SAVEPOINT CLOSE_MILCS_PUB;
112: -- Standard call to check for call compatibility.
113: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
114: p_api_version ,
115: l_api_name ,
116: G_PKG_NAME )
117: THEN

Line 118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

114: p_api_version ,
115: l_api_name ,
116: G_PKG_NAME )
117: THEN
118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
119: END IF;
120:
121: x_return_status := FND_API.G_RET_STS_SUCCESS;
122: -- API body

Line 121: x_return_status := FND_API.G_RET_STS_SUCCESS;

117: THEN
118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
119: END IF;
120:
121: x_return_status := FND_API.G_RET_STS_SUCCESS;
122: -- API body
123:
124: select milcs_id, start_date_time into l_milcs_id, l_start_date_time
125: from jtf_ih_media_item_lc_segs

Line 137: ,p_init_msg_list=>FND_API.G_FALSE

133: l_milcs_duration := round(24*60*60*l_milcs_duration);
134:
135: JTF_IH_PUB_W.Update_MediaLifecycle
136: (p_api_version=>1.0
137: ,p_init_msg_list=>FND_API.G_FALSE
138: ,p_commit=>FND_API.G_TRUE
139: ,p_resp_appl_id=>1 -- IN RESP APPL ID
140: ,p_resp_id=>1 -- IN RESP ID
141: ,p_user_id=>FND_GLOBAL.USER_ID -- IN USER ID

Line 138: ,p_commit=>FND_API.G_TRUE

134:
135: JTF_IH_PUB_W.Update_MediaLifecycle
136: (p_api_version=>1.0
137: ,p_init_msg_list=>FND_API.G_FALSE
138: ,p_commit=>FND_API.G_TRUE
139: ,p_resp_appl_id=>1 -- IN RESP APPL ID
140: ,p_resp_id=>1 -- IN RESP ID
141: ,p_user_id=>FND_GLOBAL.USER_ID -- IN USER ID
142: ,p_login_id=>NULL -- IN LOGIN ID

Line 155: IF FND_API.To_Boolean( p_commit ) THEN

151:
152:
153: -- End of API body.
154: -- Standard check of p_commit.
155: IF FND_API.To_Boolean( p_commit ) THEN
156: COMMIT WORK;
157: END IF;
158: EXCEPTION
159: WHEN NO_DATA_FOUND THEN

Line 160: x_return_status := FND_API.G_RET_STS_SUCCESS;

156: COMMIT WORK;
157: END IF;
158: EXCEPTION
159: WHEN NO_DATA_FOUND THEN
160: x_return_status := FND_API.G_RET_STS_SUCCESS;
161: x_msg_data := 'CCT_NO_DATA_FOUND';
162: x_msg_count := 1;
163: WHEN FND_API.G_EXC_ERROR THEN
164: ROLLBACK TO CLOSE_MILCS_PUB;

Line 163: WHEN FND_API.G_EXC_ERROR THEN

159: WHEN NO_DATA_FOUND THEN
160: x_return_status := FND_API.G_RET_STS_SUCCESS;
161: x_msg_data := 'CCT_NO_DATA_FOUND';
162: x_msg_count := 1;
163: WHEN FND_API.G_EXC_ERROR THEN
164: ROLLBACK TO CLOSE_MILCS_PUB;
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
166: x_msg_data := 'CCT_UNEXPECTED_ERROR';
167: x_msg_count := 1;

Line 165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

161: x_msg_data := 'CCT_NO_DATA_FOUND';
162: x_msg_count := 1;
163: WHEN FND_API.G_EXC_ERROR THEN
164: ROLLBACK TO CLOSE_MILCS_PUB;
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
166: x_msg_data := 'CCT_UNEXPECTED_ERROR';
167: x_msg_count := 1;
168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
169: ROLLBACK TO CLOSE_MILCS_PUB;

Line 168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

164: ROLLBACK TO CLOSE_MILCS_PUB;
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
166: x_msg_data := 'CCT_UNEXPECTED_ERROR';
167: x_msg_count := 1;
168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
169: ROLLBACK TO CLOSE_MILCS_PUB;
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
171: x_msg_data := 'CCT_UNEXPECTED_ERROR';
172: x_msg_count := 1;

Line 170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

166: x_msg_data := 'CCT_UNEXPECTED_ERROR';
167: x_msg_count := 1;
168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
169: ROLLBACK TO CLOSE_MILCS_PUB;
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
171: x_msg_data := 'CCT_UNEXPECTED_ERROR';
172: x_msg_count := 1;
173: WHEN OTHERS THEN
174: ROLLBACK TO CLOSE_MILCS_PUB;

Line 175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

171: x_msg_data := 'CCT_UNEXPECTED_ERROR';
172: x_msg_count := 1;
173: WHEN OTHERS THEN
174: ROLLBACK TO CLOSE_MILCS_PUB;
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
176: x_msg_data := 'CCT_UNEXPECTED_ERROR';
177: x_msg_count := 1;
178: END CLOSE_MILCS;
179:

Line 210: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

206: BEGIN
207: -- Standard Start of API savepoint
208: SAVEPOINT CAN_CLOSE_MEDIA_ITEM_PUB;
209: -- Standard call to check for call compatibility.
210: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
211: p_api_version ,
212: l_api_name ,
213: G_PKG_NAME )
214: THEN

Line 215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

211: p_api_version ,
212: l_api_name ,
213: G_PKG_NAME )
214: THEN
215: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
216: END IF;
217:
218: -- API body
219:

Line 222: x_return_status := FND_API.G_RET_STS_SUCCESS;

218: -- API body
219:
220: -- dbms_output.put_line('Processing media item id ' || p_media_item_id);
221:
222: x_return_status := FND_API.G_RET_STS_SUCCESS;
223: x_can_close_media_item := 1; -- initialize to cannot close.
224:
225: select max(c.end_date_time) into l_end_date_time from jtf_ih_media_item_lc_segs c
226: where c.media_id = p_media_item_id and c.milcs_type_id = IH_MILCS_TYPE_WITH_AGENT;

Line 256: IF FND_API.To_Boolean( p_commit ) THEN

252: x_can_close_media_item := 0;
253:
254: -- End of API body.
255: -- Standard check of p_commit.
256: IF FND_API.To_Boolean( p_commit ) THEN
257: COMMIT WORK;
258: END IF;
259:
260: EXCEPTION

Line 265: x_return_status := FND_API.G_RET_STS_SUCCESS;

261: WHEN media_item_at_route_point_ex then
262: begin
263: fnd_file.put_line(fnd_file.log,'media item is at route point, cannot close.');
264: -- dbms_output.put_line('media item is at route point, cannot close.');
265: x_return_status := FND_API.G_RET_STS_SUCCESS;
266: x_msg_data := 'CCT_MEDIA_ITEM_AT_ROUTE_POINT';
267: x_msg_count := 1;
268: end;
269: WHEN NO_DATA_FOUND THEN

Line 270: x_return_status := FND_API.G_RET_STS_SUCCESS;

266: x_msg_data := 'CCT_MEDIA_ITEM_AT_ROUTE_POINT';
267: x_msg_count := 1;
268: end;
269: WHEN NO_DATA_FOUND THEN
270: x_return_status := FND_API.G_RET_STS_SUCCESS;
271: x_msg_data := 'CCT_NO_DATA_FOUND';
272: x_msg_count := 1;
273: WHEN OTHERS THEN
274: ROLLBACK TO CAN_CLOSE_MEDIA_ITEM_PUB;

Line 275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

271: x_msg_data := 'CCT_NO_DATA_FOUND';
272: x_msg_count := 1;
273: WHEN OTHERS THEN
274: ROLLBACK TO CAN_CLOSE_MEDIA_ITEM_PUB;
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
276: x_msg_data := 'CCT_UNEXPECTED_ERROR';
277: x_msg_count := 1;
278: END CAN_CLOSE_MEDIA_ITEM;
279: