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 391: -- Standard Check Of p_commit.

387:
388: delete IEM_RT_PP_QUEUES where flag = 'S' and email_account_id=p_acct_id ;
389:
390:
391: -- Standard Check Of p_commit.
392: IF FND_API.To_Boolean(p_commit) THEN
393: COMMIT WORK;
394: END IF;
395:

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

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

Line 481: -- Standard Start of API savepoint

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

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

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

Line 567: -- Standard Check Of p_commit.

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

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

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

Line 635: -- Standard Start of API savepoint

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

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

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

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

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

Line 735: -- Standard Start of API savepoint

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

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

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

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

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