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

Line 44: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

40: BEGIN
41:
42: SAVEPOINT get_email_activity_pvt;
43: -- Standard call to check for call compatibility.
44: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
45: p_api_version_number,
46: l_api_name,
47: G_PKG_NAME)
48: THEN

Line 49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

45: p_api_version_number,
46: l_api_name,
47: G_PKG_NAME)
48: THEN
49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
50: END IF;
51: -- Initialize message list if p_init_msg_list is set to TRUE.
52: IF FND_API.to_Boolean( p_init_msg_list )
53: THEN

Line 52: IF FND_API.to_Boolean( p_init_msg_list )

48: THEN
49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
50: END IF;
51: -- Initialize message list if p_init_msg_list is set to TRUE.
52: IF FND_API.to_Boolean( p_init_msg_list )
53: THEN
54: FND_MSG_PUB.initialize;
55: END IF;
56:

Line 58: x_return_status := FND_API.G_RET_STS_SUCCESS;

54: FND_MSG_PUB.initialize;
55: END IF;
56:
57: -- Initialize API return status to SUCCESS
58: x_return_status := FND_API.G_RET_STS_SUCCESS;
59:
60: select a.email_account_id, a.from_name bulk collect into l_email_account_id_tbl, l_account_name_tbl
61: from iem_mstemail_accounts a, iem_agents b, jtf_rs_resource_extns c
62: where a.email_account_id=b.email_account_id and b.resource_id = c.resource_id and c.user_id = l_current_user

Line 165: IF FND_API.To_Boolean(p_commit) THEN

161: end loop;
162: end loop;
163:
164: -- Standard Check Of p_commit.
165: IF FND_API.To_Boolean(p_commit) THEN
166: COMMIT WORK;
167: END IF;
168: -- Standard callto get message count and if count is 1, get message info.
169: FND_MSG_PUB.Count_And_Get

Line 175: WHEN FND_API.G_EXC_ERROR THEN

171: p_data => x_msg_data
172: );
173: EXCEPTION
174:
175: WHEN FND_API.G_EXC_ERROR THEN
176: ROLLBACK TO get_email_activity_pvt;
177: x_return_status := FND_API.G_RET_STS_ERROR ;
178: FND_MSG_PUB.Count_And_Get
179: ( p_count => x_msg_count,

Line 177: x_return_status := FND_API.G_RET_STS_ERROR ;

173: EXCEPTION
174:
175: WHEN FND_API.G_EXC_ERROR THEN
176: ROLLBACK TO get_email_activity_pvt;
177: x_return_status := FND_API.G_RET_STS_ERROR ;
178: FND_MSG_PUB.Count_And_Get
179: ( p_count => x_msg_count,
180: p_data => x_msg_data
181: );

Line 182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

178: FND_MSG_PUB.Count_And_Get
179: ( p_count => x_msg_count,
180: p_data => x_msg_data
181: );
182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
183: ROLLBACK TO get_email_activity_pvt;
184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
185: FND_MSG_PUB.Count_And_Get
186: ( p_count => x_msg_count,

Line 184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

180: p_data => x_msg_data
181: );
182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
183: ROLLBACK TO get_email_activity_pvt;
184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
185: FND_MSG_PUB.Count_And_Get
186: ( p_count => x_msg_count,
187: p_data => x_msg_data
188: );

Line 191: x_return_status := FND_API.G_RET_STS_ERROR;

187: p_data => x_msg_data
188: );
189: WHEN OTHERS THEN
190: ROLLBACK TO get_email_activity_pvt;
191: x_return_status := FND_API.G_RET_STS_ERROR;
192: IF FND_MSG_PUB.Check_Msg_Level
193: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
194: THEN
195: FND_MSG_PUB.Add_Exc_Msg

Line 251: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

247: BEGIN
248:
249: SAVEPOINT get_email_activity_pvt;
250: -- Standard call to check for call compatibility.
251: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
252: p_api_version_number,
253: l_api_name,
254: G_PKG_NAME)
255: THEN

Line 256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

252: p_api_version_number,
253: l_api_name,
254: G_PKG_NAME)
255: THEN
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END IF;
258: -- Initialize message list if p_init_msg_list is set to TRUE.
259: IF FND_API.to_Boolean( p_init_msg_list )
260: THEN

Line 259: IF FND_API.to_Boolean( p_init_msg_list )

255: THEN
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257: END IF;
258: -- Initialize message list if p_init_msg_list is set to TRUE.
259: IF FND_API.to_Boolean( p_init_msg_list )
260: THEN
261: FND_MSG_PUB.initialize;
262: END IF;
263:

Line 265: x_return_status := FND_API.G_RET_STS_SUCCESS;

261: FND_MSG_PUB.initialize;
262: END IF;
263:
264: -- Initialize API return status to SUCCESS
265: x_return_status := FND_API.G_RET_STS_SUCCESS;
266:
267: if p_resource_role = 0 then -- All Agents
268: if (p_resource_name is not null) then
269: select unique res.resource_id,concat(concat(res.source_last_name, ', '), res.source_first_name) as resource_name

Line 427: IF FND_API.To_Boolean(p_commit) THEN

423: end loop;
424: end loop;
425:
426: -- Standard Check Of p_commit.
427: IF FND_API.To_Boolean(p_commit) THEN
428: COMMIT WORK;
429: END IF;
430: -- Standard callto get message count and if count is 1, get message info.
431: FND_MSG_PUB.Count_And_Get

Line 437: WHEN FND_API.G_EXC_ERROR THEN

433: p_data => x_msg_data
434: );
435: EXCEPTION
436:
437: WHEN FND_API.G_EXC_ERROR THEN
438: ROLLBACK TO get_email_activity_pvt;
439: x_return_status := FND_API.G_RET_STS_ERROR ;
440: FND_MSG_PUB.Count_And_Get
441: ( p_count => x_msg_count,

Line 439: x_return_status := FND_API.G_RET_STS_ERROR ;

435: EXCEPTION
436:
437: WHEN FND_API.G_EXC_ERROR THEN
438: ROLLBACK TO get_email_activity_pvt;
439: x_return_status := FND_API.G_RET_STS_ERROR ;
440: FND_MSG_PUB.Count_And_Get
441: ( p_count => x_msg_count,
442: p_data => x_msg_data
443: );

Line 444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

440: FND_MSG_PUB.Count_And_Get
441: ( p_count => x_msg_count,
442: p_data => x_msg_data
443: );
444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
445: ROLLBACK TO get_email_activity_pvt;
446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
447: FND_MSG_PUB.Count_And_Get
448: ( p_count => x_msg_count,

Line 446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

442: p_data => x_msg_data
443: );
444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
445: ROLLBACK TO get_email_activity_pvt;
446: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
447: FND_MSG_PUB.Count_And_Get
448: ( p_count => x_msg_count,
449: p_data => x_msg_data
450: );

Line 453: x_return_status := FND_API.G_RET_STS_ERROR;

449: p_data => x_msg_data
450: );
451: WHEN OTHERS THEN
452: ROLLBACK TO get_email_activity_pvt;
453: x_return_status := FND_API.G_RET_STS_ERROR;
454: IF FND_MSG_PUB.Check_Msg_Level
455: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
456: THEN
457: FND_MSG_PUB.Add_Exc_Msg