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_PP_QUEUE_PVT dependencies on STANDARD

Line 59: -- Standard Start of API savepoint

55: l_action number :=1;
56:
57:
58: BEGIN
59: -- Standard Start of API savepoint
60: SAVEPOINT create_item_tag_PVT;
61:
62: -- Standard call to check for call compatibility.
63:

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

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

Line 163: -- Standard Check Of p_commit.

159:
160:
161: end if; -- FIRST is not null
162:
163: -- Standard Check Of p_commit.
164: IF FND_API.To_Boolean(p_commit) THEN
165: COMMIT WORK;
166: END IF;
167:

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

165: COMMIT WORK;
166: END IF;
167:
168:
169: -- Standard callto get message count and if count is 1, get message info.
170: FND_MSG_PUB.Count_And_Get
171: ( p_count => x_msg_count,
172: p_data => x_msg_data
173: );

Line 242: -- Standard Start of API savepoint

238:
239: e_nowait EXCEPTION;
240: PRAGMA EXCEPTION_INIT(e_nowait, -54);
241: BEGIN
242: -- Standard Start of API savepoint
243: SAVEPOINT get_queue_rec_PVT;
244:
245: -- Standard call to check for call compatibility.
246:

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

241: BEGIN
242: -- Standard Start of API savepoint
243: SAVEPOINT get_queue_rec_PVT;
244:
245: -- Standard call to check for call compatibility.
246:
247: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
248: p_api_version_number,
249: l_api_name,

Line 294: -- Standard Check Of p_commit.

290: x_subject := l_queue_rec.subject;
291: x_action := l_queue_rec.action;
292: END IF;
293:
294: -- Standard Check Of p_commit.
295: IF FND_API.To_Boolean(p_commit) THEN
296: COMMIT WORK;
297: END IF;
298:

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

295: IF FND_API.To_Boolean(p_commit) THEN
296: COMMIT WORK;
297: END IF;
298:
299: -- Standard callto get message count and if count is 1, get message info.
300: FND_MSG_PUB.Count_And_Get
301: ( p_count => x_msg_count,
302: p_data => x_msg_data
303: );

Line 359: -- Standard Start of API savepoint

355: l_msg_count NUMBER := 0;
356: l_msg_data VARCHAR2(2000);
357:
358: BEGIN
359: -- Standard Start of API savepoint
360: SAVEPOINT create_item_tag_PVT;
361:
362: -- Standard call to check for call compatibility.
363:

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

358: BEGIN
359: -- Standard Start of API savepoint
360: SAVEPOINT create_item_tag_PVT;
361:
362: -- Standard call to check for call compatibility.
363:
364: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
365: p_api_version_number,
366: l_api_name,

Line 392: -- Standard Check Of p_commit.

388: ( select email_id from iem_rt_pp_queues where flag in ('S','Q','X')
389: and email_account_id=p_acct_id );
390: delete IEM_RT_PP_QUEUES where flag in ('S','Q','X') and email_account_id=p_acct_id ;
391:
392: -- Standard Check Of p_commit.
393: IF FND_API.To_Boolean(p_commit) THEN
394: COMMIT WORK;
395: END IF;
396:

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

394: COMMIT WORK;
395: END IF;
396:
397:
398: -- Standard callto get message count and if count is 1, get message info.
399: FND_MSG_PUB.Count_And_Get
400: ( p_count => x_msg_count,
401: p_data => x_msg_data
402: );

Line 482: -- Standard Start of API savepoint

478: e_nowait EXCEPTION;
479: PRAGMA EXCEPTION_INIT(e_nowait, -54);
480:
481: BEGIN
482: -- Standard Start of API savepoint
483: SAVEPOINT get_queue_rec_PVT;
484:
485: -- Standard call to check for call compatibility.
486:

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

481: BEGIN
482: -- Standard Start of API savepoint
483: SAVEPOINT get_queue_rec_PVT;
484:
485: -- Standard call to check for call compatibility.
486:
487: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
488: p_api_version_number,
489: l_api_name,

Line 568: -- Standard Check Of p_commit.

564: x_subjects := l_subjects;
565: x_actions := l_actions;
566: x_rfc_msgids := l_rfc_msgids;
567:
568: -- Standard Check Of p_commit.
569: IF FND_API.To_Boolean(p_commit) THEN
570: COMMIT WORK;
571: END IF;
572:

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

569: IF FND_API.To_Boolean(p_commit) THEN
570: COMMIT WORK;
571: END IF;
572:
573: -- Standard callto get message count and if count is 1, get message info.
574: FND_MSG_PUB.Count_And_Get
575: ( p_count => x_msg_count,
576: p_data => x_msg_data
577: );

Line 636: -- Standard Start of API savepoint

632: l_msg_count NUMBER := 0;
633: l_msg_data VARCHAR2(2000);
634:
635: BEGIN
636: -- Standard Start of API savepoint
637: SAVEPOINT create_item_tag_PVT;
638:
639: -- Standard call to check for call compatibility.
640:

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

635: BEGIN
636: -- Standard Start of API savepoint
637: SAVEPOINT create_item_tag_PVT;
638:
639: -- Standard call to check for call compatibility.
640:
641: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
642: p_api_version_number,
643: l_api_name,

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

669: end if;
670:
671: end loop;
672:
673: -- Standard callto get message count and if count is 1, get message info.
674: FND_MSG_PUB.Count_And_Get
675: ( p_count => x_msg_count,
676: p_data => x_msg_data
677: );

Line 736: -- Standard Start of API savepoint

732: l_msg_count NUMBER := 0;
733: l_msg_data VARCHAR2(2000);
734:
735: BEGIN
736: -- Standard Start of API savepoint
737: SAVEPOINT reset_data_PVT;
738:
739: -- Standard call to check for call compatibility.
740:

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

735: BEGIN
736: -- Standard Start of API savepoint
737: SAVEPOINT reset_data_PVT;
738:
739: -- Standard call to check for call compatibility.
740:
741: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
742: p_api_version_number,
743: l_api_name,

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

758:
759: --begins here
760: update iem_rt_pp_queues set flag='N' where flag='A' and retry_count<=4;
761:
762: -- Standard callto get message count and if count is 1, get message info.
763: FND_MSG_PUB.Count_And_Get
764: ( p_count => x_msg_count,
765: p_data => x_msg_data
766: );