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

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

28: l_api_name VARCHAR2(255):='get_folder_work_list';
29: l_api_version_number NUMBER:=1.0;
30: l_seq_id NUMBER;
31:
32: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
33: l_msg_count NUMBER := 0;
34: l_msg_data VARCHAR2(2000);
35:
36: x number;

Line 86: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

82: SAVEPOINT get_folder_work_list_PVT;
83:
84: -- Standard call to check for call compatibility.
85:
86: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
87: p_api_version_number,
88: l_api_name,
89: G_PKG_NAME)
90: THEN

Line 91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

87: p_api_version_number,
88: l_api_name,
89: G_PKG_NAME)
90: THEN
91: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
92: END IF;
93:
94:
95: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 96: IF FND_API.to_Boolean( p_init_msg_list )

92: END IF;
93:
94:
95: -- Initialize message list if p_init_msg_list is set to TRUE.
96: IF FND_API.to_Boolean( p_init_msg_list )
97: THEN
98: FND_MSG_PUB.initialize;
99: END IF;
100:

Line 102: x_return_status := FND_API.G_RET_STS_SUCCESS;

98: FND_MSG_PUB.initialize;
99: END IF;
100:
101: -- Initialize API return status to SUCCESS
102: x_return_status := FND_API.G_RET_STS_SUCCESS;
103:
104: --begins here
105:
106: -- first update the Flder_status for all finished account

Line 197: IF FND_API.To_Boolean(p_commit) THEN

193: END LOOP;
194:
195: x_folder_work_list := l_folder_list;
196: -- Standard Check Of p_commit.
197: IF FND_API.To_Boolean(p_commit) THEN
198: COMMIT WORK;
199: END IF;
200:
201:

Line 210: WHEN FND_API.G_EXC_ERROR THEN

206: );
207:
208: EXCEPTION
209:
210: WHEN FND_API.G_EXC_ERROR THEN
211: ROLLBACK TO get_folder_work_list_PVT;
212: x_return_status := FND_API.G_RET_STS_ERROR ;
213: FND_MSG_PUB.Count_And_Get
214:

Line 212: x_return_status := FND_API.G_RET_STS_ERROR ;

208: EXCEPTION
209:
210: WHEN FND_API.G_EXC_ERROR THEN
211: ROLLBACK TO get_folder_work_list_PVT;
212: x_return_status := FND_API.G_RET_STS_ERROR ;
213: FND_MSG_PUB.Count_And_Get
214:
215: ( p_count => x_msg_count,
216: p_data => x_msg_data

Line 219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

215: ( p_count => x_msg_count,
216: p_data => x_msg_data
217: );
218:
219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
220: ROLLBACK TO get_folder_work_list_PVT;
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
222: FND_MSG_PUB.Count_And_Get
223: ( p_count => x_msg_count,

Line 221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

217: );
218:
219: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
220: ROLLBACK TO get_folder_work_list_PVT;
221: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
222: FND_MSG_PUB.Count_And_Get
223: ( p_count => x_msg_count,
224: p_data => x_msg_data
225: );

Line 229: x_return_status := FND_API.G_RET_STS_ERROR;

225: );
226:
227: WHEN OTHERS THEN
228: ROLLBACK TO get_folder_work_list_PVT;
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: IF FND_MSG_PUB.Check_Msg_Level
231: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
232: THEN
233: FND_MSG_PUB.Add_Exc_Msg

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

264: l_api_name VARCHAR2(255):='get_msg_work_list';
265: l_api_version_number NUMBER:=1.0;
266: l_seq_id NUMBER;
267:
268: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
269: l_msg_count NUMBER := 0;
270: l_msg_data VARCHAR2(2000);
271:
272: l_queue_rec iem_migration_store_temp%rowtype;

Line 290: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

286: SAVEPOINT get_msg_work_list_PVT;
287:
288: -- Standard call to check for call compatibility.
289:
290: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
291: p_api_version_number,
292: l_api_name,
293: G_PKG_NAME)
294: THEN

Line 295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

291: p_api_version_number,
292: l_api_name,
293: G_PKG_NAME)
294: THEN
295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
296: END IF;
297:
298:
299: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 300: IF FND_API.to_Boolean( p_init_msg_list )

296: END IF;
297:
298:
299: -- Initialize message list if p_init_msg_list is set to TRUE.
300: IF FND_API.to_Boolean( p_init_msg_list )
301: THEN
302: FND_MSG_PUB.initialize;
303: END IF;
304:

Line 306: x_return_status := FND_API.G_RET_STS_SUCCESS;

302: FND_MSG_PUB.initialize;
303: END IF;
304:
305: -- Initialize API return status to SUCCESS
306: x_return_status := FND_API.G_RET_STS_SUCCESS;
307:
308:
309: i := 1;
310:

Line 360: IF FND_API.To_Boolean(p_commit) THEN

356: x_subjects := l_subjects;
357: x_rfc_msgids := l_rfc_msgids;
358:
359: -- Standard Check Of p_commit.
360: IF FND_API.To_Boolean(p_commit) THEN
361: COMMIT WORK;
362: END IF;
363:
364: -- Standard callto get message count and if count is 1, get message info.

Line 370: WHEN FND_API.G_EXC_ERROR THEN

366: ( p_count => x_msg_count,
367: p_data => x_msg_data
368: );
369: EXCEPTION
370: WHEN FND_API.G_EXC_ERROR THEN
371: ROLLBACK TO get_msg_work_list_PVT;
372: x_return_status := FND_API.G_RET_STS_ERROR ;
373: FND_MSG_PUB.Count_And_Get
374:

Line 372: x_return_status := FND_API.G_RET_STS_ERROR ;

368: );
369: EXCEPTION
370: WHEN FND_API.G_EXC_ERROR THEN
371: ROLLBACK TO get_msg_work_list_PVT;
372: x_return_status := FND_API.G_RET_STS_ERROR ;
373: FND_MSG_PUB.Count_And_Get
374:
375: ( p_count => x_msg_count,
376: p_data => x_msg_data

Line 379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

375: ( p_count => x_msg_count,
376: p_data => x_msg_data
377: );
378:
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: ROLLBACK TO get_msg_work_list_PVT;
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
382: FND_MSG_PUB.Count_And_Get
383: ( p_count => x_msg_count,

Line 381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

377: );
378:
379: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
380: ROLLBACK TO get_msg_work_list_PVT;
381: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
382: FND_MSG_PUB.Count_And_Get
383: ( p_count => x_msg_count,
384: p_data => x_msg_data
385: );

Line 389: x_return_status := FND_API.G_RET_STS_ERROR;

385: );
386:
387: WHEN OTHERS THEN
388: ROLLBACK TO get_msg_work_list_PVT;
389: x_return_status := FND_API.G_RET_STS_ERROR;
390: IF FND_MSG_PUB.Check_Msg_Level
391: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
392: THEN
393: FND_MSG_PUB.Add_Exc_Msg

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

419: l_api_name VARCHAR2(255):='log_batch_error';
420: l_api_version_number NUMBER:=1.0;
421: l_seq_id NUMBER;
422:
423: l_return_status VARCHAR2(20) := FND_API.G_RET_STS_SUCCESS;
424: l_msg_count NUMBER := 0;
425: l_msg_data VARCHAR2(2000);
426:
427: i number;

Line 437: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

433: SAVEPOINT log_batch_error_PVT;
434:
435: -- Standard call to check for call compatibility.
436:
437: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
438: p_api_version_number,
439: l_api_name,
440: G_PKG_NAME)
441: THEN

Line 442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

438: p_api_version_number,
439: l_api_name,
440: G_PKG_NAME)
441: THEN
442: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
443: END IF;
444:
445:
446: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 447: IF FND_API.to_Boolean( p_init_msg_list )

443: END IF;
444:
445:
446: -- Initialize message list if p_init_msg_list is set to TRUE.
447: IF FND_API.to_Boolean( p_init_msg_list )
448: THEN
449: FND_MSG_PUB.initialize;
450: END IF;
451:

Line 453: x_return_status := FND_API.G_RET_STS_SUCCESS;

449: FND_MSG_PUB.initialize;
450: END IF;
451:
452: -- Initialize API return status to SUCCESS
453: x_return_status := FND_API.G_RET_STS_SUCCESS;
454:
455: l_error := substr(p_error,1,1000);
456:
457: For i in 1..p_mail_ids.count loop

Line 469: IF FND_API.To_Boolean(p_commit) THEN

465: where migration_id=p_migration_id;
466:
467:
468: -- Standard Check Of p_commit.
469: IF FND_API.To_Boolean(p_commit) THEN
470: COMMIT WORK;
471: END IF;
472:
473: -- Standard callto get message count and if count is 1, get message info.

Line 479: WHEN FND_API.G_EXC_ERROR THEN

475: ( p_count => x_msg_count,
476: p_data => x_msg_data
477: );
478: EXCEPTION
479: WHEN FND_API.G_EXC_ERROR THEN
480: ROLLBACK TO log_batch_error_PVT;
481: x_return_status := FND_API.G_RET_STS_ERROR ;
482: FND_MSG_PUB.Count_And_Get
483:

Line 481: x_return_status := FND_API.G_RET_STS_ERROR ;

477: );
478: EXCEPTION
479: WHEN FND_API.G_EXC_ERROR THEN
480: ROLLBACK TO log_batch_error_PVT;
481: x_return_status := FND_API.G_RET_STS_ERROR ;
482: FND_MSG_PUB.Count_And_Get
483:
484: ( p_count => x_msg_count,
485: p_data => x_msg_data

Line 488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

484: ( p_count => x_msg_count,
485: p_data => x_msg_data
486: );
487:
488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
489: ROLLBACK TO log_batch_error_PVT;
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
491: FND_MSG_PUB.Count_And_Get
492: ( p_count => x_msg_count,

Line 490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

486: );
487:
488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
489: ROLLBACK TO log_batch_error_PVT;
490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
491: FND_MSG_PUB.Count_And_Get
492: ( p_count => x_msg_count,
493: p_data => x_msg_data
494: );

Line 498: x_return_status := FND_API.G_RET_STS_ERROR;

494: );
495:
496: WHEN OTHERS THEN
497: ROLLBACK TO log_batch_error_PVT;
498: x_return_status := FND_API.G_RET_STS_ERROR;
499: IF FND_MSG_PUB.Check_Msg_Level
500: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
501: THEN
502: FND_MSG_PUB.Add_Exc_Msg