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

Line 74: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

70: BEGIN
71: -- Standard Start of API savepoint
72: SAVEPOINT moveMessage_PVT;
73: -- Standard call to check for call compatibility.
74: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
75: p_api_version_number,
76: l_api_name,
77: G_PKG_NAME)
78: THEN

Line 79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 82: IF FND_API.to_Boolean( p_init_msg_list )

78: THEN
79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
80: END IF;
81: -- Initialize message list if p_init_msg_list is set to TRUE.
82: IF FND_API.to_Boolean( p_init_msg_list )
83: THEN
84: FND_MSG_PUB.initialize;
85: END IF;
86: -- Initialize API return status to SUCCESS

Line 87: x_return_status := FND_API.G_RET_STS_SUCCESS;

83: THEN
84: FND_MSG_PUB.initialize;
85: END IF;
86: -- Initialize API return status to SUCCESS
87: x_return_status := FND_API.G_RET_STS_SUCCESS;
88:
89: SELECT DB_SERVER_ID,EMAIL_USER,DOMAIN,EMAIL_PASSWORD
90: INTO l_db_server_id,l_user,l_domain,l_pass
91: FROM IEM_EMAIL_ACCOUNTS

Line 111: x_return_status := FND_API.G_RET_STS_SUCCESS;

107: end if;
108: l_str:='begin :l_ret:=im_api.authenticate'||l_im_link||'(:a_user,:a_domain,:a_password);end; ';
109: EXECUTE IMMEDIATE l_str using OUT l_ret,l_user,l_domain,l_pass;
110: IF l_ret=0 THEN
111: x_return_status := FND_API.G_RET_STS_SUCCESS;
112: ELSE
113: x_return_status := FND_API.G_RET_STS_ERROR;
114: END IF;
115:

Line 113: x_return_status := FND_API.G_RET_STS_ERROR;

109: EXECUTE IMMEDIATE l_str using OUT l_ret,l_user,l_domain,l_pass;
110: IF l_ret=0 THEN
111: x_return_status := FND_API.G_RET_STS_SUCCESS;
112: ELSE
113: x_return_status := FND_API.G_RET_STS_ERROR;
114: END IF;
115:
116: -- Now we are ready to call im movetoFolder
117: IF (p_reverse='N') THEN

Line 128: x_return_status := FND_API.G_RET_STS_SUCCESS;

124: l_str:='begin :l_ret:=im_api.movetofolder'||l_im_link||'(:a_msgid,:a_frfolder,:a_tofolder);end; ';
125:
126: EXECUTE IMMEDIATE l_str using OUT l_ret,p_msgid,l_frfolder,l_tofolder;
127: IF l_ret=0 THEN
128: x_return_status := FND_API.G_RET_STS_SUCCESS;
129: x_status := 0;
130: ELSIF l_ret=2 THEN
131: x_return_status := FND_API.G_RET_STS_SUCCESS;
132: x_status := 2;

Line 131: x_return_status := FND_API.G_RET_STS_SUCCESS;

127: IF l_ret=0 THEN
128: x_return_status := FND_API.G_RET_STS_SUCCESS;
129: x_status := 0;
130: ELSIF l_ret=2 THEN
131: x_return_status := FND_API.G_RET_STS_SUCCESS;
132: x_status := 2;
133: ELSIF l_ret=3 THEN
134: x_return_status := FND_API.G_RET_STS_SUCCESS;
135: x_status := 3;

Line 134: x_return_status := FND_API.G_RET_STS_SUCCESS;

130: ELSIF l_ret=2 THEN
131: x_return_status := FND_API.G_RET_STS_SUCCESS;
132: x_status := 2;
133: ELSIF l_ret=3 THEN
134: x_return_status := FND_API.G_RET_STS_SUCCESS;
135: x_status := 3;
136: END IF;
137:
138: -- Standard Check Of p_commit.

Line 139: IF FND_API.To_Boolean(p_commit) THEN

135: x_status := 3;
136: END IF;
137:
138: -- Standard Check Of p_commit.
139: IF FND_API.To_Boolean(p_commit) THEN
140: COMMIT WORK;
141: END IF;
142: -- Standard callto get message count and if count is 1, get message info.
143: FND_MSG_PUB.Count_And_Get

Line 148: WHEN FND_API.G_EXC_ERROR THEN

144: ( p_count => x_msg_count,
145: p_data => x_msg_data
146: );
147: EXCEPTION
148: WHEN FND_API.G_EXC_ERROR THEN
149: ROLLBACK TO moveMessage_PVT;
150: x_return_status := FND_API.G_RET_STS_ERROR ;
151: FND_MSG_PUB.Count_And_Get
152: ( p_count => x_msg_count,

Line 150: x_return_status := FND_API.G_RET_STS_ERROR ;

146: );
147: EXCEPTION
148: WHEN FND_API.G_EXC_ERROR THEN
149: ROLLBACK TO moveMessage_PVT;
150: x_return_status := FND_API.G_RET_STS_ERROR ;
151: FND_MSG_PUB.Count_And_Get
152: ( p_count => x_msg_count,
153: p_data => x_msg_data
154: );

Line 155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

151: FND_MSG_PUB.Count_And_Get
152: ( p_count => x_msg_count,
153: p_data => x_msg_data
154: );
155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
156: ROLLBACK TO moveMessage_PVT;
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
158: FND_MSG_PUB.Count_And_Get
159: ( p_count => x_msg_count,

Line 157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

153: p_data => x_msg_data
154: );
155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
156: ROLLBACK TO moveMessage_PVT;
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
158: FND_MSG_PUB.Count_And_Get
159: ( p_count => x_msg_count,
160: p_data => x_msg_data
161: );

Line 164: x_return_status := FND_API.G_RET_STS_ERROR;

160: p_data => x_msg_data
161: );
162: WHEN OTHERS THEN
163: ROLLBACK TO moveMessage_PVT;
164: x_return_status := FND_API.G_RET_STS_ERROR;
165: IF FND_MSG_PUB.Check_Msg_Level
166: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
167: THEN
168: FND_MSG_PUB.Add_Exc_Msg

Line 217: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

213: BEGIN
214: -- Standard Start of API savepoint
215: SAVEPOINT moveMessage_PVT;
216: -- Standard call to check for call compatibility.
217: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
218: p_api_version_number,
219: l_api_name,
220: G_PKG_NAME)
221: THEN

Line 222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

218: p_api_version_number,
219: l_api_name,
220: G_PKG_NAME)
221: THEN
222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
223: END IF;
224: -- Initialize message list if p_init_msg_list is set to TRUE.
225: IF FND_API.to_Boolean( p_init_msg_list )
226: THEN

Line 225: IF FND_API.to_Boolean( p_init_msg_list )

221: THEN
222: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
223: END IF;
224: -- Initialize message list if p_init_msg_list is set to TRUE.
225: IF FND_API.to_Boolean( p_init_msg_list )
226: THEN
227: FND_MSG_PUB.initialize;
228: END IF;
229: -- Initialize API return status to SUCCESS

Line 230: x_return_status := FND_API.G_RET_STS_SUCCESS;

226: THEN
227: FND_MSG_PUB.initialize;
228: END IF;
229: -- Initialize API return status to SUCCESS
230: x_return_status := FND_API.G_RET_STS_SUCCESS;
231:
232: SELECT DB_SERVER_ID,EMAIL_USER,DOMAIN,EMAIL_PASSWORD
233: INTO l_db_server_id,l_user,l_domain,l_pass
234: FROM IEM_EMAIL_ACCOUNTS

Line 254: x_return_status := FND_API.G_RET_STS_SUCCESS;

250: end if;
251: l_str:='begin :l_ret:=im_api.authenticate'||l_im_link||'(:a_user,:a_domain,:a_password);end; ';
252: EXECUTE IMMEDIATE l_str using OUT l_ret,l_user,l_domain,l_pass;
253: IF l_ret=0 THEN
254: x_return_status := FND_API.G_RET_STS_SUCCESS;
255: ELSE
256: x_return_status := FND_API.G_RET_STS_ERROR;
257: END IF;
258:

Line 256: x_return_status := FND_API.G_RET_STS_ERROR;

252: EXECUTE IMMEDIATE l_str using OUT l_ret,l_user,l_domain,l_pass;
253: IF l_ret=0 THEN
254: x_return_status := FND_API.G_RET_STS_SUCCESS;
255: ELSE
256: x_return_status := FND_API.G_RET_STS_ERROR;
257: END IF;
258:
259: -- Now we are ready to call im movetoFolder
260:

Line 272: IF FND_API.To_Boolean(p_commit) THEN

268: raise MOVE_MSG_FAIL;
269: END IF;
270:
271: -- Standard Check Of p_commit.
272: IF FND_API.To_Boolean(p_commit) THEN
273: COMMIT WORK;
274: END IF;
275: -- Standard callto get message count and if count is 1, get message info.
276: FND_MSG_PUB.Count_And_Get

Line 283: x_return_status := FND_API.G_RET_STS_ERROR ;

279: );
280: EXCEPTION
281: WHEN MOVE_MSG_FAIL THEN
282: ROLLBACK TO moveMessage_PVT;
283: x_return_status := FND_API.G_RET_STS_ERROR ;
284: FND_MESSAGE.SET_NAME('IEM', 'IEM_MOVE_DEL_MESSAGE_FAIL');
285: FND_MSG_PUB.ADD;
286: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
287:

Line 290: x_return_status := FND_API.G_RET_STS_ERROR ;

286: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
287:
288: WHEN OES_DOWN THEN
289: ROLLBACK TO moveMessage_PVT;
290: x_return_status := FND_API.G_RET_STS_ERROR ;
291: FND_MESSAGE.SET_NAME('IEM', 'IEM_OES_DOWN');
292: FND_MSG_PUB.ADD;
293: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
294:

Line 295: WHEN FND_API.G_EXC_ERROR THEN

291: FND_MESSAGE.SET_NAME('IEM', 'IEM_OES_DOWN');
292: FND_MSG_PUB.ADD;
293: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
294:
295: WHEN FND_API.G_EXC_ERROR THEN
296: ROLLBACK TO moveMessage_PVT;
297: x_return_status := FND_API.G_RET_STS_ERROR ;
298: FND_MSG_PUB.Count_And_Get
299: ( p_count => x_msg_count,

Line 297: x_return_status := FND_API.G_RET_STS_ERROR ;

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

Line 302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 311: x_return_status := FND_API.G_RET_STS_ERROR;

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