APPS.IEM_REROUTE_PUB dependencies on STANDARD

Line 61: -- Standard Start of API savepoint

57: NO_DEFAULT_RESOURCE_ID EXCEPTION;
58: INVALID_CLASSIFICATION EXCEPTION;
59: ERROR_RETRIEVE_SOURCE_MESSAGE EXCEPTION;
60: BEGIN
61: -- Standard Start of API savepoint
62: SAVEPOINT IEM_MAIL_REROUTE_PVT;
63: -- Standard call to check for call compatibility.
64: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
65: p_api_version_number,

Line 63: -- Standard call to check for call compatibility.

59: ERROR_RETRIEVE_SOURCE_MESSAGE EXCEPTION;
60: BEGIN
61: -- Standard Start of API savepoint
62: SAVEPOINT IEM_MAIL_REROUTE_PVT;
63: -- Standard call to check for call compatibility.
64: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
65: p_api_version_number,
66: l_api_name,
67: G_PKG_NAME)

Line 226: -- Standard Check Of p_commit.

222: where message_id=p_msgid;
223: delete from iem_rt_proc_emails where message_id=p_msgid;
224: END IF;
225:
226: -- Standard Check Of p_commit.
227: IF p_commit='T' THEN
228: COMMIT WORK;
229: END IF;
230: COMMIT;

Line 231: -- Standard callto get message count and if count is 1, get message info.

227: IF p_commit='T' THEN
228: COMMIT WORK;
229: END IF;
230: COMMIT;
231: -- Standard callto get message count and if count is 1, get message info.
232: FND_MSG_PUB.Count_And_Get
233: ( p_count => x_msg_count,
234: p_data => x_msg_data
235: );

Line 346: -- Standard Start of API savepoint

342: REROUTING_FAILS EXCEPTION;
343: INSERT_HIST_EXCEPTION EXCEPTION;
344:
345: BEGIN
346: -- Standard Start of API savepoint
347: SAVEPOINT IEM_MAIL_REROUTE_PVT;
348: -- Standard call to check for call compatibility.
349: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
350: p_api_version_number,

Line 348: -- Standard call to check for call compatibility.

344:
345: BEGIN
346: -- Standard Start of API savepoint
347: SAVEPOINT IEM_MAIL_REROUTE_PVT;
348: -- Standard call to check for call compatibility.
349: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
350: p_api_version_number,
351: l_api_name,
352: G_PKG_NAME)

Line 420: -- Standard Check Of p_commit.

416: IH_INTERACTION_ID=p_interaction_id,
417: IH_MEDIA_ITEM_ID=l_post_rec.ih_media_item_id
418: where message_id=p_msgid;
419: delete from iem_rt_proc_emails where message_id=p_msgid;
420: -- Standard Check Of p_commit.
421: IF p_commit='T' THEN
422: COMMIT WORK;
423: END IF;
424: COMMIT;

Line 425: -- Standard callto get message count and if count is 1, get message info.

421: IF p_commit='T' THEN
422: COMMIT WORK;
423: END IF;
424: COMMIT;
425: -- Standard callto get message count and if count is 1, get message info.
426: FND_MSG_PUB.Count_And_Get
427: ( p_count => x_msg_count,
428: p_data => x_msg_data
429: );

Line 496: -- Standard Start of API savepoint

492: l_api_version_number NUMBER:=1.0;
493: l_upd_count number:=0;
494:
495: BEGIN
496: -- Standard Start of API savepoint
497: SAVEPOINT IEM_UPD_GRP_QUEMSG_PVT;
498: -- Standard call to check for call compatibility.
499: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
500: p_api_version_number,

Line 498: -- Standard call to check for call compatibility.

494:
495: BEGIN
496: -- Standard Start of API savepoint
497: SAVEPOINT IEM_UPD_GRP_QUEMSG_PVT;
498: -- Standard call to check for call compatibility.
499: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
500: p_api_version_number,
501: l_api_name,
502: G_PKG_NAME)

Line 524: -- Standard Check Of p_commit.

520: ELSE
521: x_upd_count:=0;
522: END IF;
523:
524: -- Standard Check Of p_commit.
525: IF p_commit='T' THEN
526: COMMIT WORK;
527: END IF;
528: EXCEPTION WHEN FND_API.G_EXC_ERROR THEN