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.IEM_SPV_ACTIONS_PVT dependencies on FND_API

Line 18: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;

14:
15: l_api_name varchar2(30):='delete_queue_msg';
16: l_api_version_number number:=1.0;
17: l_status NUMBER := 0;
18: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
19: l_msg_count NUMBER := 0;
20: l_msg_data VARCHAR2(2000);
21: l_post_mdts iem_rt_proc_emails%rowtype;
22: l_class_name iem_route_classifications.name%type;

Line 40: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

36: --Standard Savepoint
37: SAVEPOINT delete_queue_msg;
38:
39: -- Standard call to check for call compatibility.
40: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
41: p_api_version_number,
42: l_api_name,
43: G_PKG_NAME)
44: THEN

Line 45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

41: p_api_version_number,
42: l_api_name,
43: G_PKG_NAME)
44: THEN
45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
46: END IF;
47:
48: --Initialize the message list if p_init_msg_list is set to TRUE
49: If FND_API.to_Boolean(p_init_msg_list) THEN

Line 49: If FND_API.to_Boolean(p_init_msg_list) THEN

45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
46: END IF;
47:
48: --Initialize the message list if p_init_msg_list is set to TRUE
49: If FND_API.to_Boolean(p_init_msg_list) THEN
50: FND_MSG_PUB.initialize;
51: END IF;
52:
53: --Initialize API status return

Line 54: x_return_status := FND_API.G_RET_STS_SUCCESS;

50: FND_MSG_PUB.initialize;
51: END IF;
52:
53: --Initialize API status return
54: x_return_status := FND_API.G_RET_STS_SUCCESS;
55:
56: select * into l_post_mdts from iem_rt_proc_emails where message_id=p_message_id for update;
57:
58: --l_current_user := 1003651;

Line 212: p_init_msg_list => FND_API.G_FALSE,

208: -- Move Messages between folders
209: /*select name into l_class_name from iem_route_classifications where route_classification_id=l_post_mdts.rt_classification_id;
210:
211: iem_movemsg_pvt.moveOesMessage (p_api_version_number => 1.0,
212: p_init_msg_list => FND_API.G_FALSE,
213: p_commit=> FND_API.G_FALSE,
214: p_msgid => l_post_mdts.source_message_id,
215: p_email_account_id => l_post_mdts.email_account_id,
216: p_tofolder => 'Deleted',

Line 213: p_commit=> FND_API.G_FALSE,

209: /*select name into l_class_name from iem_route_classifications where route_classification_id=l_post_mdts.rt_classification_id;
210:
211: iem_movemsg_pvt.moveOesMessage (p_api_version_number => 1.0,
212: p_init_msg_list => FND_API.G_FALSE,
213: p_commit=> FND_API.G_FALSE,
214: p_msgid => l_post_mdts.source_message_id,
215: p_email_account_id => l_post_mdts.email_account_id,
216: p_tofolder => 'Deleted',
217: p_fromfolder => l_class_name,

Line 225: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

221:
222:
223: --Check for error, raise exception
224: --if error raise MOVE_MSG_FAIL;
225: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
226: raise MOVE_MSG_FAIL;
227: END IF;
228: */
229: -- Delete from queue and close media items

Line 231: p_init_msg_list => FND_API.G_FALSE,

227: END IF;
228: */
229: -- Delete from queue and close media items
230: IEM_MAILITEM_PUB.ResolvedMessage (p_api_version_number => 1.0,
231: p_init_msg_list => FND_API.G_FALSE,
232: p_commit => FND_API.G_FALSE,
233: p_message_id => l_post_mdts.message_id,
234: p_action_flag => 'D',
235: x_return_status => l_return_status,

Line 232: p_commit => FND_API.G_FALSE,

228: */
229: -- Delete from queue and close media items
230: IEM_MAILITEM_PUB.ResolvedMessage (p_api_version_number => 1.0,
231: p_init_msg_list => FND_API.G_FALSE,
232: p_commit => FND_API.G_FALSE,
233: p_message_id => l_post_mdts.message_id,
234: p_action_flag => 'D',
235: x_return_status => l_return_status,
236: x_msg_count => l_msg_count,

Line 241: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

237: x_msg_data => l_msg_data);
238:
239: --Check for error, raise exception
240: --if error raise MOVE_MSG_FAIL;
241: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
242: raise MOVE_MSG_FAIL;
243: END IF;
244:
245: --Standard check of p_commit

Line 246: IF FND_API.to_Boolean(p_commit) THEN

242: raise MOVE_MSG_FAIL;
243: END IF;
244:
245: --Standard check of p_commit
246: IF FND_API.to_Boolean(p_commit) THEN
247: COMMIT WORK;
248: END IF;
249:
250:

Line 254: x_return_status := FND_API.G_RET_STS_ERROR ;

250:
251: EXCEPTION
252: WHEN MOVE_MSG_FAIL THEN
253: ROLLBACK TO delete_queue_msg;
254: x_return_status := FND_API.G_RET_STS_ERROR ;
255: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
256:
257:
258:

Line 259: WHEN FND_API.G_EXC_ERROR THEN

255: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
256:
257:
258:
259: WHEN FND_API.G_EXC_ERROR THEN
260: ROLLBACK TO delete_queue_msg;
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
262: FND_MSG_PUB.Count_And_Get
263: ( p_count => x_msg_count,p_data => x_msg_data);

Line 261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

257:
258:
259: WHEN FND_API.G_EXC_ERROR THEN
260: ROLLBACK TO delete_queue_msg;
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
262: FND_MSG_PUB.Count_And_Get
263: ( p_count => x_msg_count,p_data => x_msg_data);
264:
265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
262: FND_MSG_PUB.Count_And_Get
263: ( p_count => x_msg_count,p_data => x_msg_data);
264:
265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
266: ROLLBACK TO delete_queue_msg;
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
268: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
269:

Line 267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

263: ( p_count => x_msg_count,p_data => x_msg_data);
264:
265: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
266: ROLLBACK TO delete_queue_msg;
267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
268: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
269:
270: WHEN OTHERS THEN
271: ROLLBACK TO delete_queue_msg;

Line 272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

268: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
269:
270: WHEN OTHERS THEN
271: ROLLBACK TO delete_queue_msg;
272: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
273: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
274: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
275: END IF;
276:

Line 295: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;

291:
292: l_api_name varchar2(30):='delete_queue_msg_batch';
293: l_api_version_number number:=1.0;
294: l_status NUMBER := 0;
295: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
296: l_msg_count NUMBER := 0;
297: l_msg_data VARCHAR2(2000);
298: l_moved_message_count NUMBER := 0;
299:

Line 306: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

302: --Standard Savepoint
303: SAVEPOINT delete_queue_msg_batch;
304:
305: -- Standard call to check for call compatibility.
306: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
307: p_api_version_number,
308: l_api_name,
309: G_PKG_NAME)
310: THEN

Line 311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

307: p_api_version_number,
308: l_api_name,
309: G_PKG_NAME)
310: THEN
311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
312: END IF;
313:
314: --Initialize the message list if p_init_msg_list is set to TRUE
315: If FND_API.to_Boolean(p_init_msg_list) THEN

Line 315: If FND_API.to_Boolean(p_init_msg_list) THEN

311: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
312: END IF;
313:
314: --Initialize the message list if p_init_msg_list is set to TRUE
315: If FND_API.to_Boolean(p_init_msg_list) THEN
316: FND_MSG_PUB.initialize;
317: END IF;
318:
319: --Initialize API status return

Line 320: x_return_status := FND_API.G_RET_STS_SUCCESS;

316: FND_MSG_PUB.initialize;
317: END IF;
318:
319: --Initialize API status return
320: x_return_status := FND_API.G_RET_STS_SUCCESS;
321:
322: FOR i IN p_message_ids_tbl.FIRST..p_message_ids_tbl.LAST LOOP
323:
324:

Line 326: p_init_msg_list => FND_API.G_FALSE,

322: FOR i IN p_message_ids_tbl.FIRST..p_message_ids_tbl.LAST LOOP
323:
324:
325: iem_spv_actions_pvt.delete_queue_msg (p_api_version_number => 1.0,
326: p_init_msg_list => FND_API.G_FALSE,
327: p_commit => FND_API.G_FALSE,
328: p_message_id => p_message_ids_tbl(i),
329: p_reason_id => p_reason_id,
330: x_return_status => l_return_status,

Line 327: p_commit => FND_API.G_FALSE,

323:
324:
325: iem_spv_actions_pvt.delete_queue_msg (p_api_version_number => 1.0,
326: p_init_msg_list => FND_API.G_FALSE,
327: p_commit => FND_API.G_FALSE,
328: p_message_id => p_message_ids_tbl(i),
329: p_reason_id => p_reason_id,
330: x_return_status => l_return_status,
331: x_msg_count => l_msg_count,

Line 334: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

330: x_return_status => l_return_status,
331: x_msg_count => l_msg_count,
332: x_msg_data => l_msg_data) ;
333:
334: IF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
335: l_moved_message_count := l_moved_message_count + 1;
336: END IF;
337:
338: END LOOP;

Line 344: IF FND_API.to_Boolean(p_commit) THEN

340: x_moved_message_count := l_moved_message_count;
341:
342:
343: --Standard check of p_commit
344: IF FND_API.to_Boolean(p_commit) THEN
345: COMMIT WORK;
346: END IF;
347:
348:

Line 351: WHEN FND_API.G_EXC_ERROR THEN

347:
348:
349: EXCEPTION
350:
351: WHEN FND_API.G_EXC_ERROR THEN
352: ROLLBACK TO delete_queue_msg;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
354: FND_MSG_PUB.Count_And_Get
355: ( p_count => x_msg_count,p_data => x_msg_data);

Line 353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

349: EXCEPTION
350:
351: WHEN FND_API.G_EXC_ERROR THEN
352: ROLLBACK TO delete_queue_msg;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
354: FND_MSG_PUB.Count_And_Get
355: ( p_count => x_msg_count,p_data => x_msg_data);
356:
357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
354: FND_MSG_PUB.Count_And_Get
355: ( p_count => x_msg_count,p_data => x_msg_data);
356:
357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
358: ROLLBACK TO delete_queue_msg;
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
360: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
361:

Line 359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

355: ( p_count => x_msg_count,p_data => x_msg_data);
356:
357: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
358: ROLLBACK TO delete_queue_msg;
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
360: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
361:
362: WHEN OTHERS THEN
363: ROLLBACK TO delete_queue_msg;

Line 364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

360: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,p_data => x_msg_data);
361:
362: WHEN OTHERS THEN
363: ROLLBACK TO delete_queue_msg;
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
365: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
366: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME , l_api_name);
367: END IF;
368: