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

Line 43: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

39: l_LAST_UPDATE_LOGIN number:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ID')) ;
40:
41: BEGIN
42: -- Standard call to check for call compatibility.
43: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
44: p_api_version_number,
45: l_api_name,
46: G_PKG_NAME)
47: THEN

Line 48: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

44: p_api_version_number,
45: l_api_name,
46: G_PKG_NAME)
47: THEN
48: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
49: END IF;
50: x_return_status := FND_API.G_RET_STS_SUCCESS;
51: -- Initialize message list if p_init_msg_list is set to TRUE.
52: IF p_init_msg_list ='T'

Line 50: x_return_status := FND_API.G_RET_STS_SUCCESS;

46: G_PKG_NAME)
47: THEN
48: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
49: END IF;
50: x_return_status := FND_API.G_RET_STS_SUCCESS;
51: -- Initialize message list if p_init_msg_list is set to TRUE.
52: IF p_init_msg_list ='T'
53: THEN
54: FND_MSG_PUB.initialize;

Line 56: x_return_status := FND_API.G_RET_STS_SUCCESS;

52: IF p_init_msg_list ='T'
53: THEN
54: FND_MSG_PUB.initialize;
55: END IF;
56: x_return_status := FND_API.G_RET_STS_SUCCESS;
57:
58: INSERT INTO IEM_RT_PROC_EMAILS (
59: MESSAGE_ID ,
60: EMAIL_ACCOUNT_ID ,

Line 156: WHEN FND_API.G_EXC_ERROR THEN

152: ( p_count => x_msg_count,
153: p_data => x_msg_data
154: );
155: EXCEPTION
156: WHEN FND_API.G_EXC_ERROR THEN
157: x_return_status := FND_API.G_RET_STS_ERROR ;
158: FND_MSG_PUB.Count_And_Get
159: ( p_count => x_msg_count,
160: p_data => x_msg_data

Line 157: x_return_status := FND_API.G_RET_STS_ERROR ;

153: p_data => x_msg_data
154: );
155: EXCEPTION
156: WHEN FND_API.G_EXC_ERROR THEN
157: x_return_status := FND_API.G_RET_STS_ERROR ;
158: FND_MSG_PUB.Count_And_Get
159: ( p_count => x_msg_count,
160: p_data => x_msg_data
161: );

Line 162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

158: FND_MSG_PUB.Count_And_Get
159: ( p_count => x_msg_count,
160: p_data => x_msg_data
161: );
162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
164: FND_MSG_PUB.Count_And_Get
165: ( p_count => x_msg_count,
166: p_data => x_msg_data

Line 163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

159: ( p_count => x_msg_count,
160: p_data => x_msg_data
161: );
162: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
164: FND_MSG_PUB.Count_And_Get
165: ( p_count => x_msg_count,
166: p_data => x_msg_data
167: );

Line 169: x_return_status := FND_API.G_RET_STS_ERROR;

165: ( p_count => x_msg_count,
166: p_data => x_msg_data
167: );
168: WHEN OTHERS THEN
169: x_return_status := FND_API.G_RET_STS_ERROR;
170: IF FND_MSG_PUB.Check_Msg_Level
171: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
172: THEN
173: FND_MSG_PUB.Add_Exc_Msg

Line 198: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

194: l_api_version_number NUMBER:=1.0;
195:
196: BEGIN
197: -- Standard call to check for call compatibility.
198: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
199: p_api_version_number,
200: l_api_name,
201: G_PKG_NAME)
202: THEN

Line 203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

199: p_api_version_number,
200: l_api_name,
201: G_PKG_NAME)
202: THEN
203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
204: END IF;
205: -- Initialize message list if p_init_msg_list is set to TRUE.
206: IF p_init_msg_list ='T'
207: THEN

Line 210: x_return_status := FND_API.G_RET_STS_SUCCESS;

206: IF p_init_msg_list ='T'
207: THEN
208: FND_MSG_PUB.initialize;
209: END IF;
210: x_return_status := FND_API.G_RET_STS_SUCCESS;
211: delete from IEM_POST_MDTS
212: where message_id=p_message_id;
213:
214: -- Standard Check Of p_commit.

Line 224: WHEN FND_API.G_EXC_ERROR THEN

220: ( p_count => x_msg_count,
221: p_data => x_msg_data
222: );
223: EXCEPTION
224: WHEN FND_API.G_EXC_ERROR THEN
225: ROLLBACK TO delete_item_PVT;
226: x_return_status := FND_API.G_RET_STS_ERROR ;
227: FND_MSG_PUB.Count_And_Get
228: ( p_count => x_msg_count,

Line 226: x_return_status := FND_API.G_RET_STS_ERROR ;

222: );
223: EXCEPTION
224: WHEN FND_API.G_EXC_ERROR THEN
225: ROLLBACK TO delete_item_PVT;
226: x_return_status := FND_API.G_RET_STS_ERROR ;
227: FND_MSG_PUB.Count_And_Get
228: ( p_count => x_msg_count,
229: p_data => x_msg_data
230: );

Line 231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

227: FND_MSG_PUB.Count_And_Get
228: ( p_count => x_msg_count,
229: p_data => x_msg_data
230: );
231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
232: ROLLBACK TO delete_item_PVT;
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
234: FND_MSG_PUB.Count_And_Get
235: ( p_count => x_msg_count,

Line 233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

229: p_data => x_msg_data
230: );
231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
232: ROLLBACK TO delete_item_PVT;
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
234: FND_MSG_PUB.Count_And_Get
235: ( p_count => x_msg_count,
236: p_data => x_msg_data
237: );

Line 240: x_return_status := FND_API.G_RET_STS_ERROR;

236: p_data => x_msg_data
237: );
238: WHEN OTHERS THEN
239: ROLLBACK TO delete_item_PVT;
240: x_return_status := FND_API.G_RET_STS_ERROR;
241: IF FND_MSG_PUB.Check_Msg_Level
242: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
243: THEN
244: FND_MSG_PUB.Add_Exc_Msg