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

Line 37: IF NOT FND_API.Compatible_API_Call (l_api_version ,

33: l_server_group_id number;
34:
35:
36: BEGIN
37: IF NOT FND_API.Compatible_API_Call (l_api_version ,
38: p_api_version ,
39: l_api_name ,
40: G_PKG_NAME )
41: THEN

Line 42: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

38: p_api_version ,
39: l_api_name ,
40: G_PKG_NAME )
41: THEN
42: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
43: END IF;
44: -- Initialize message list if p_init_msg_list is set to TRUE.
45: IF FND_API.to_Boolean( p_init_msg_list ) THEN
46: FND_MSG_PUB.initialize;

Line 45: IF FND_API.to_Boolean( p_init_msg_list ) THEN

41: THEN
42: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
43: END IF;
44: -- Initialize message list if p_init_msg_list is set to TRUE.
45: IF FND_API.to_Boolean( p_init_msg_list ) THEN
46: FND_MSG_PUB.initialize;
47: END IF;
48: -- Initialize API return status to failure
49:

Line 50: x_return_status := FND_API.G_RET_STS_SUCCESS ;

46: FND_MSG_PUB.initialize;
47: END IF;
48: -- Initialize API return status to failure
49:
50: x_return_status := FND_API.G_RET_STS_SUCCESS ;
51: x_msg_count := 0;
52: x_msg_data := null;
53:
54: -- API body

Line 108: IF FND_API.To_Boolean( p_commit ) THEN

104: raise_application_error(1000, 'CCT_MQD_PUB:RECEIVE_MEDIA_ITEM: '
105: || 'RECEIVE_ITEM FAILED: ' || l_msg_data );
106: end if;
107:
108: IF FND_API.To_Boolean( p_commit ) THEN
109: COMMIT WORK;
110: END IF;
111:
112:

Line 115: WHEN FND_API.G_EXC_ERROR THEN

111:
112:
113: EXCEPTION
114:
115: WHEN FND_API.G_EXC_ERROR THEN
116: rollback;
117: x_return_status := FND_API.G_RET_STS_ERROR ;
118: x_msg_count := 1;
119: x_err_num := SQLCODE;

Line 117: x_return_status := FND_API.G_RET_STS_ERROR ;

113: EXCEPTION
114:
115: WHEN FND_API.G_EXC_ERROR THEN
116: rollback;
117: x_return_status := FND_API.G_RET_STS_ERROR ;
118: x_msg_count := 1;
119: x_err_num := SQLCODE;
120: x_err_msg := SUBSTR(SQLERRM, 1, 100);
121: x_msg_data := 'RECEIVE_MEDIA_ITEM: CCT_ERROR '

Line 126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

122: || ' ErrorCode = ' || x_err_num
123: || ' ErrorMsg = ' || x_err_msg;
124: --dbms_output.put_line(x_msg_data);
125:
126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
127: ROLLBACK;
128: x_return_status := FND_API.G_RET_STS_ERROR ;
129: x_msg_count := 1;
130: x_err_num := SQLCODE;

Line 128: x_return_status := FND_API.G_RET_STS_ERROR ;

124: --dbms_output.put_line(x_msg_data);
125:
126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
127: ROLLBACK;
128: x_return_status := FND_API.G_RET_STS_ERROR ;
129: x_msg_count := 1;
130: x_err_num := SQLCODE;
131: x_err_msg := SUBSTR(SQLERRM, 1, 100);
132: x_msg_data := 'RECEIVE_MEDIA_ITEM: CCT_ERROR '

Line 140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

136: --dbms_output.put_line(x_msg_data);
137:
138: WHEN OTHERS THEN
139: rollback;
140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
141: --dbms_output.put_line('Unexpected error in others');
142: x_msg_count := 1;
143: x_err_num := SQLCODE;
144: x_err_msg := SUBSTR(SQLERRM, 1, 100);

Line 191: IF NOT FND_API.Compatible_API_Call (l_api_version ,

187: pragma exception_init (no_messages, -25228);
188:
189:
190: BEGIN
191: IF NOT FND_API.Compatible_API_Call (l_api_version ,
192: p_api_version ,
193: l_api_name ,
194: G_PKG_NAME )
195: THEN

Line 196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

192: p_api_version ,
193: l_api_name ,
194: G_PKG_NAME )
195: THEN
196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
197: END IF;
198: -- Initialize message list if p_init_msg_list is set to TRUE.
199: IF FND_API.to_Boolean( p_init_msg_list ) THEN
200: FND_MSG_PUB.initialize;

Line 199: IF FND_API.to_Boolean( p_init_msg_list ) THEN

195: THEN
196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
197: END IF;
198: -- Initialize message list if p_init_msg_list is set to TRUE.
199: IF FND_API.to_Boolean( p_init_msg_list ) THEN
200: FND_MSG_PUB.initialize;
201: END IF;
202: -- Initialize API return status to failure
203: -- API body

Line 204: x_return_status := FND_API.G_RET_STS_SUCCESS ;

200: FND_MSG_PUB.initialize;
201: END IF;
202: -- Initialize API return status to failure
203: -- API body
204: x_return_status := FND_API.G_RET_STS_SUCCESS ;
205: x_msg_count := 0;
206: x_msg_data := null;
207: x_item_id := -1;
208: x_item_type := -1;

Line 276: IF FND_API.To_Boolean( p_commit ) THEN

272: --|| x_item_type || ' '
273: --|| x_classification || ' '
274: --|| x_kvp);
275:
276: IF FND_API.To_Boolean( p_commit ) THEN
277: COMMIT WORK;
278: END IF;
279:
280: EXCEPTION

Line 282: WHEN FND_API.G_EXC_ERROR THEN

278: END IF;
279:
280: EXCEPTION
281:
282: WHEN FND_API.G_EXC_ERROR THEN
283: rollback;
284: x_return_status := FND_API.G_RET_STS_ERROR ;
285: x_msg_count := 1;
286: x_err_num := SQLCODE;

Line 284: x_return_status := FND_API.G_RET_STS_ERROR ;

280: EXCEPTION
281:
282: WHEN FND_API.G_EXC_ERROR THEN
283: rollback;
284: x_return_status := FND_API.G_RET_STS_ERROR ;
285: x_msg_count := 1;
286: x_err_num := SQLCODE;
287: x_err_msg := SUBSTR(SQLERRM, 1, 100);
288: x_msg_data := 'GET_NEXT_MEDIA_ITEM: CCT_ERROR'

Line 292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

288: x_msg_data := 'GET_NEXT_MEDIA_ITEM: CCT_ERROR'
289: || ' ErrorCode = ' || x_err_num
290: || ' ErrorMsg = ' || x_err_msg;
291: --dbms_output.put_line(x_msg_data);
292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
293: ROLLBACK;
294: x_return_status := FND_API.G_RET_STS_ERROR ;
295: x_msg_count := 1;
296: x_err_num := SQLCODE;

Line 294: x_return_status := FND_API.G_RET_STS_ERROR ;

290: || ' ErrorMsg = ' || x_err_msg;
291: --dbms_output.put_line(x_msg_data);
292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
293: ROLLBACK;
294: x_return_status := FND_API.G_RET_STS_ERROR ;
295: x_msg_count := 1;
296: x_err_num := SQLCODE;
297: x_err_msg := SUBSTR(SQLERRM, 1, 100);
298: x_msg_data := 'GET_NEXT_MEDIA_ITEM: CCT_ERROR'

Line 304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

300: || ' ErrorMsg = ' || x_err_msg;
301: --dbms_output.put_line(x_msg_data);
302: WHEN OTHERS THEN
303: rollback;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
305: x_msg_count := 1;
306: x_err_num := SQLCODE;
307: x_err_msg := SUBSTR(SQLERRM, 1, 100);
308: x_msg_data := 'GET_NEXT_MEDIA_ITEM: CCT_ERROR'