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

Line 71: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

67: l_dummy INTEGER;
68: BEGIN
69: SAVEPOINT search_message_pvt;
70: -- Standard call to check for call compatibility.
71: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
72: p_api_version_number,
73: l_api_name,
74: G_PKG_NAME)
75: THEN

Line 76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

72: p_api_version_number,
73: l_api_name,
74: G_PKG_NAME)
75: THEN
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: END IF;
78: -- Initialize message list if p_init_msg_list is set to TRUE.
79: IF FND_API.to_Boolean( p_init_msg_list )
80: THEN

Line 79: IF FND_API.to_Boolean( p_init_msg_list )

75: THEN
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: END IF;
78: -- Initialize message list if p_init_msg_list is set to TRUE.
79: IF FND_API.to_Boolean( p_init_msg_list )
80: THEN
81: FND_MSG_PUB.initialize;
82: END IF;
83:

Line 85: x_return_status := FND_API.G_RET_STS_SUCCESS;

81: FND_MSG_PUB.initialize;
82: END IF;
83:
84: -- Initialize API return status to SUCCESS
85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86:
87: -- detemine sort column
88: if (p_page_flag = 0) then -- for Inbox by account page
89: if (p_sort_column = 0) then

Line 286: IF FND_API.To_Boolean(p_commit) THEN

282:
283: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
284:
285: -- Standard Check Of p_commit.
286: IF FND_API.To_Boolean(p_commit) THEN
287: COMMIT WORK;
288: END IF;
289: -- Standard callto get message count and if count is 1, get message info.
290: FND_MSG_PUB.Count_And_Get

Line 296: WHEN FND_API.G_EXC_ERROR THEN

292: p_data => x_msg_data
293: );
294: EXCEPTION
295:
296: WHEN FND_API.G_EXC_ERROR THEN
297: ROLLBACK TO search_message_pvt;
298: x_return_status := FND_API.G_RET_STS_ERROR ;
299: FND_MSG_PUB.Count_And_Get
300: ( p_count => x_msg_count,

Line 298: x_return_status := FND_API.G_RET_STS_ERROR ;

294: EXCEPTION
295:
296: WHEN FND_API.G_EXC_ERROR THEN
297: ROLLBACK TO search_message_pvt;
298: x_return_status := FND_API.G_RET_STS_ERROR ;
299: FND_MSG_PUB.Count_And_Get
300: ( p_count => x_msg_count,
301: p_data => x_msg_data
302: );

Line 303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

299: FND_MSG_PUB.Count_And_Get
300: ( p_count => x_msg_count,
301: p_data => x_msg_data
302: );
303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
304: ROLLBACK TO search_message_pvt;
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
306: FND_MSG_PUB.Count_And_Get
307: ( p_count => x_msg_count,

Line 305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

301: p_data => x_msg_data
302: );
303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
304: ROLLBACK TO search_message_pvt;
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
306: FND_MSG_PUB.Count_And_Get
307: ( p_count => x_msg_count,
308: p_data => x_msg_data
309: );

Line 312: x_return_status := FND_API.G_RET_STS_ERROR;

308: p_data => x_msg_data
309: );
310: WHEN OTHERS THEN
311: ROLLBACK TO search_message_pvt;
312: x_return_status := FND_API.G_RET_STS_ERROR;
313: IF FND_MSG_PUB.Check_Msg_Level
314: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
315: THEN
316: FND_MSG_PUB.Add_Exc_Msg

Line 381: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

377: l_dummy INTEGER;
378: BEGIN
379: SAVEPOINT search_message_pvt;
380: -- Standard call to check for call compatibility.
381: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
382: p_api_version_number,
383: l_api_name,
384: G_PKG_NAME)
385: THEN

Line 386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

382: p_api_version_number,
383: l_api_name,
384: G_PKG_NAME)
385: THEN
386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
387: END IF;
388: -- Initialize message list if p_init_msg_list is set to TRUE.
389: IF FND_API.to_Boolean( p_init_msg_list )
390: THEN

Line 389: IF FND_API.to_Boolean( p_init_msg_list )

385: THEN
386: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
387: END IF;
388: -- Initialize message list if p_init_msg_list is set to TRUE.
389: IF FND_API.to_Boolean( p_init_msg_list )
390: THEN
391: FND_MSG_PUB.initialize;
392: END IF;
393:

Line 395: x_return_status := FND_API.G_RET_STS_SUCCESS;

391: FND_MSG_PUB.initialize;
392: END IF;
393:
394: -- Initialize API return status to SUCCESS
395: x_return_status := FND_API.G_RET_STS_SUCCESS;
396:
397: if (p_customer_name is not null) then
398:
399: l_query_string1 := 'select count(*)

Line 491: IF FND_API.To_Boolean(p_commit) THEN

487:
488: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
489:
490: -- Standard Check Of p_commit.
491: IF FND_API.To_Boolean(p_commit) THEN
492: COMMIT WORK;
493: END IF;
494: -- Standard callto get message count and if count is 1, get message info.
495: FND_MSG_PUB.Count_And_Get

Line 501: WHEN FND_API.G_EXC_ERROR THEN

497: p_data => x_msg_data
498: );
499: EXCEPTION
500:
501: WHEN FND_API.G_EXC_ERROR THEN
502: ROLLBACK TO search_message_pvt;
503: x_return_status := FND_API.G_RET_STS_ERROR ;
504: FND_MSG_PUB.Count_And_Get
505: ( p_count => x_msg_count,

Line 503: x_return_status := FND_API.G_RET_STS_ERROR ;

499: EXCEPTION
500:
501: WHEN FND_API.G_EXC_ERROR THEN
502: ROLLBACK TO search_message_pvt;
503: x_return_status := FND_API.G_RET_STS_ERROR ;
504: FND_MSG_PUB.Count_And_Get
505: ( p_count => x_msg_count,
506: p_data => x_msg_data
507: );

Line 508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

504: FND_MSG_PUB.Count_And_Get
505: ( p_count => x_msg_count,
506: p_data => x_msg_data
507: );
508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
509: ROLLBACK TO search_message_pvt;
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
511: FND_MSG_PUB.Count_And_Get
512: ( p_count => x_msg_count,

Line 510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

506: p_data => x_msg_data
507: );
508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
509: ROLLBACK TO search_message_pvt;
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
511: FND_MSG_PUB.Count_And_Get
512: ( p_count => x_msg_count,
513: p_data => x_msg_data
514: );

Line 517: x_return_status := FND_API.G_RET_STS_ERROR;

513: p_data => x_msg_data
514: );
515: WHEN OTHERS THEN
516: ROLLBACK TO search_message_pvt;
517: x_return_status := FND_API.G_RET_STS_ERROR;
518: IF FND_MSG_PUB.Check_Msg_Level
519: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
520: THEN
521: FND_MSG_PUB.Add_Exc_Msg

Line 575: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

571: BEGIN
572:
573: SAVEPOINT show_agent_list_pvt;
574: -- Standard call to check for call compatibility.
575: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
576: p_api_version_number,
577: l_api_name,
578: G_PKG_NAME)
579: THEN

Line 580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

576: p_api_version_number,
577: l_api_name,
578: G_PKG_NAME)
579: THEN
580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
581: END IF;
582: -- Initialize message list if p_init_msg_list is set to TRUE.
583: IF FND_API.to_Boolean( p_init_msg_list )
584: THEN

Line 583: IF FND_API.to_Boolean( p_init_msg_list )

579: THEN
580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
581: END IF;
582: -- Initialize message list if p_init_msg_list is set to TRUE.
583: IF FND_API.to_Boolean( p_init_msg_list )
584: THEN
585: FND_MSG_PUB.initialize;
586: END IF;
587:

Line 589: x_return_status := FND_API.G_RET_STS_SUCCESS;

585: FND_MSG_PUB.initialize;
586: END IF;
587:
588: -- Initialize API return status to SUCCESS
589: x_return_status := FND_API.G_RET_STS_SUCCESS;
590:
591: -- determine sort state
592: if (p_sort_state = 'ascending') then
593: l_sort_order := 'desc';

Line 831: IF FND_API.To_Boolean(p_commit) THEN

827: DBMS_SQL.CLOSE_CURSOR(l_cursorID);
828:
829: end if; -- if p_sort_column=2
830: -- Standard Check Of p_commit.
831: IF FND_API.To_Boolean(p_commit) THEN
832: COMMIT WORK;
833: END IF;
834: -- Standard callto get message count and if count is 1, get message info.
835: FND_MSG_PUB.Count_And_Get

Line 841: WHEN FND_API.G_EXC_ERROR THEN

837: p_data => x_msg_data
838: );
839: EXCEPTION
840:
841: WHEN FND_API.G_EXC_ERROR THEN
842: ROLLBACK TO show_agent_list_pvt;
843: x_return_status := FND_API.G_RET_STS_ERROR ;
844: FND_MSG_PUB.Count_And_Get
845: ( p_count => x_msg_count,

Line 843: x_return_status := FND_API.G_RET_STS_ERROR ;

839: EXCEPTION
840:
841: WHEN FND_API.G_EXC_ERROR THEN
842: ROLLBACK TO show_agent_list_pvt;
843: x_return_status := FND_API.G_RET_STS_ERROR ;
844: FND_MSG_PUB.Count_And_Get
845: ( p_count => x_msg_count,
846: p_data => x_msg_data
847: );

Line 848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

844: FND_MSG_PUB.Count_And_Get
845: ( p_count => x_msg_count,
846: p_data => x_msg_data
847: );
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: ROLLBACK TO show_agent_list_pvt;
850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
851: FND_MSG_PUB.Count_And_Get
852: ( p_count => x_msg_count,

Line 850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

846: p_data => x_msg_data
847: );
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: ROLLBACK TO show_agent_list_pvt;
850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
851: FND_MSG_PUB.Count_And_Get
852: ( p_count => x_msg_count,
853: p_data => x_msg_data
854: );

Line 857: x_return_status := FND_API.G_RET_STS_ERROR;

853: p_data => x_msg_data
854: );
855: WHEN OTHERS THEN
856: ROLLBACK TO show_agent_list_pvt;
857: x_return_status := FND_API.G_RET_STS_ERROR;
858: IF FND_MSG_PUB.Check_Msg_Level
859: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
860: THEN
861: FND_MSG_PUB.Add_Exc_Msg