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

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

78: l_count number;
79: IEM_NO_DATA EXCEPTION;
80: NOT_A_VALID_AGENT EXCEPTION;
81: BEGIN
82: -- Standard call to check for call compatibility.
83: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
84: p_api_version_number,
85: l_api_name,
86: G_PKG_NAME)

Line 169: -- Standard Check Of p_commit.

165: if x_email_count.count=0 THEN
166: raise IEM_NO_DATA;
167: end if;
168: commit;
169: -- Standard Check Of p_commit.
170: IF p_commit='T' THEN
171: COMMIT WORK;
172: END IF;
173: -- Standard callto get message count and if count is 1, get message info.

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

169: -- Standard Check Of p_commit.
170: IF p_commit='T' THEN
171: COMMIT WORK;
172: END IF;
173: -- Standard callto get message count and if count is 1, get message info.
174: FND_MSG_PUB.Count_And_Get
175: ( p_count => x_msg_count,
176: p_data => x_msg_data
177: );

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

253: l_msg_count number;
254: l_msg_data varchar2(500);
255: IEM_NO_DATA EXCEPTION;
256: begin
257: -- Standard call to check for call compatibility.
258: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
259: p_api_version_number,
260: l_api_name,
261: G_PKG_NAME)

Line 309: -- Standard Check Of p_commit.

305: x_class_bin(l_index).rt_classification_name:=x_rt_class_name_TbL(l_index);
306: x_class_bin(l_index).email_count:=x_count(l_index);
307: END LOOP;
308:
309: -- Standard Check Of p_commit.
310: IF p_commit='T' THEN
311: COMMIT WORK;
312: END IF;
313: -- Standard callto get message count and if count is 1, get message info.

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

309: -- Standard Check Of p_commit.
310: IF p_commit='T' THEN
311: COMMIT WORK;
312: END IF;
313: -- Standard callto get message count and if count is 1, get message info.
314: FND_MSG_PUB.Count_And_Get
315: ( p_count => x_msg_count,
316: p_data => x_msg_data
317: );

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

377: x_rt_class_name_Tbl jtf_varchar2_table_100:=jtf_varchar2_table_100() ;
378: x_count t_number_table:=t_number_table() ;
379: IEM_NO_DATA EXCEPTION;
380: begin
381: -- Standard call to check for call compatibility.
382: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
383: p_api_version_number,
384: l_api_name,
385: G_PKG_NAME)

Line 403: -- Standard Check Of p_commit.

399: x_class_bin(l_index).rt_classification_name:=x_rt_class_name_TbL(l_index);
400: x_class_bin(l_index).email_count:=x_count(l_index);
401: END LOOP;
402:
403: -- Standard Check Of p_commit.
404: IF p_commit='T' THEN
405: COMMIT WORK;
406: END IF;
407: -- Standard callto get message count and if count is 1, get message info.

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

403: -- Standard Check Of p_commit.
404: IF p_commit='T' THEN
405: COMMIT WORK;
406: END IF;
407: -- Standard callto get message count and if count is 1, get message info.
408: FND_MSG_PUB.Count_And_Get
409: ( p_count => x_msg_count,
410: p_data => x_msg_data
411: );

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

467: l_msg_count number;
468: l_msg_data varchar2(500);
469: IEM_NO_DATA EXCEPTION;
470: begin
471: -- Standard call to check for call compatibility.
472: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
473: p_api_version_number,
474: l_api_name,
475: G_PKG_NAME)

Line 521: -- Standard Check Of p_commit.

517: and group_id in (select * from TABLE(cast(i_tbl as jtf_number_table)));
518: IF x_count=0 THEN
519: RAISE IEM_NO_DATA;
520: END IF;
521: -- Standard Check Of p_commit.
522: IF p_commit='T' THEN
523: COMMIT WORK;
524: END IF;
525: -- Standard callto get message count and if count is 1, get message info.

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

521: -- Standard Check Of p_commit.
522: IF p_commit='T' THEN
523: COMMIT WORK;
524: END IF;
525: -- Standard callto get message count and if count is 1, get message info.
526: FND_MSG_PUB.Count_And_Get
527: ( p_count => x_msg_count,
528: p_data => x_msg_data
529: );

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

603: e_nowait EXCEPTION;
604: PRAGMA EXCEPTION_INIT(e_nowait, -54);
605: l_time number;
606: BEGIN
607: -- Standard call to check for call compatibility.
608: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
609: p_api_version_number,
610: l_api_name,
611: G_PKG_NAME)

Line 714: -- Standard Check Of p_commit.

710: commit;
711: ELSE
712: RAISE IEM_NO_DATA;
713: END IF;
714: -- Standard Check Of p_commit.
715: IF p_commit='T' THEN
716: COMMIT WORK;
717: END IF;
718: -- Standard callto get message count and if count is 1, get message info.

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

714: -- Standard Check Of p_commit.
715: IF p_commit='T' THEN
716: COMMIT WORK;
717: END IF;
718: -- Standard callto get message count and if count is 1, get message info.
719: FND_MSG_PUB.Count_And_Get
720: ( p_count => x_msg_count,
721: p_data => x_msg_data
722: );

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

776: l_msg_count number;
777: l_media_id number;
778:
779: BEGIN
780: -- Standard call to check for call compatibility.
781: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
782: p_api_version_number,
783: l_api_name,
784: G_PKG_NAME)

Line 830: -- Standard Check Of p_commit.

826: /*
827: delete from iem_encrypted_tags
828: where message_id=p_message_id;
829: */
830: -- Standard Check Of p_commit.
831: IF p_commit='T' THEN
832: COMMIT WORK;
833: END IF;
834: -- Standard callto get message count and if count is 1, get message info.

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

830: -- Standard Check Of p_commit.
831: IF p_commit='T' THEN
832: COMMIT WORK;
833: END IF;
834: -- Standard callto get message count and if count is 1, get message info.
835: FND_MSG_PUB.Count_And_Get
836: ( p_count => x_msg_count,
837: p_data => x_msg_data
838: );

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

881: l_api_name VARCHAR2(255):='getGroupDetails';
882: l_api_version_number NUMBER:=1.0;
883: NOT_A_VALID_AGENT EXCEPTION;
884: BEGIN
885: -- Standard call to check for call compatibility.
886: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
887: p_api_version_number,
888: l_api_name,
889: G_PKG_NAME)

Line 904: -- Standard Check Of p_commit.

900: raise NOT_A_VALID_AGENT;
901: END IF;
902: x_tbl.extend;
903: x_tbl(x_tbl.count):=0;
904: -- Standard Check Of p_commit.
905: IF p_commit='T' THEN
906: COMMIT WORK;
907: END IF;
908: -- Standard callto get message count and if count is 1, get message info.

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

904: -- Standard Check Of p_commit.
905: IF p_commit='T' THEN
906: COMMIT WORK;
907: END IF;
908: -- Standard callto get message count and if count is 1, get message info.
909: FND_MSG_PUB.Count_And_Get
910: ( p_count => x_msg_count,
911: p_data => x_msg_data
912: );

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

963: l_LAST_UPDATE_DATE DATE:=SYSDATE;
964: l_LAST_UPDATE_LOGIN NUMBER:=TO_NUMBER (FND_PROFILE.VALUE('LOGIN_ ID')) ;
965:
966: BEGIN
967: -- Standard call to check for call compatibility.
968: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
969: p_api_version_number,
970: l_api_name,
971: G_PKG_NAME)

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

1009: IF p_commit='T' THEN
1010: COMMIT WORK;
1011: END IF;
1012:
1013: -- Standard callto get message count and if count is 1, get message info.
1014: FND_MSG_PUB.Count_And_Get
1015: ( p_count => x_msg_count,
1016: p_data => x_msg_data
1017: );

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

1061:
1062: l_api_name VARCHAR2(255):='GetMailItemInfo';
1063: l_api_version_number NUMBER:=1.0;
1064: BEGIN
1065: -- Standard call to check for call compatibility.
1066: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1067: p_api_version_number,
1068: l_api_name,
1069: G_PKG_NAME)

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

1098: END;
1099: END IF;
1100:
1101:
1102: -- Standard callto get message count and if count is 1, get message info.
1103: FND_MSG_PUB.Count_And_Get
1104: ( p_count => x_msg_count,
1105: p_data => x_msg_data
1106: );

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

1165: l_expire varchar2(1):='N';
1166: l_status_type varchar2(40):='IEM_MESSAGE_STATUS_TYPE';
1167:
1168: BEGIN
1169: -- Standard call to check for call compatibility.
1170: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1171: p_api_version_number,
1172: l_api_name,
1173: G_PKG_NAME)

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

1240: IF p_commit='T' THEN
1241: COMMIT WORK;
1242: END IF;
1243:
1244: -- Standard callto get message count and if count is 1, get message info.
1245: FND_MSG_PUB.Count_And_Get
1246: ( p_count => x_msg_count,
1247: p_data => x_msg_data
1248: );

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

1298: l_ret_status varchar2(50);
1299: l_encrypted_id varchar2(500);
1300: l_index number;
1301: BEGIN
1302: -- Standard call to check for call compatibility.
1303: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1304: p_api_version_number,
1305: l_api_name,
1306: G_PKG_NAME)

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

1339: END IF;
1340: IF p_commit='T' THEN
1341: COMMIT WORK;
1342: END IF;
1343: -- Standard callto get message count and if count is 1, get message info.
1344: FND_MSG_PUB.Count_And_Get
1345: ( p_count => x_msg_count,
1346: p_data => x_msg_data
1347: );

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

1436: l_media_rec JTF_IH_PUB.media_rec_type;
1437: l_media_data JTF_IH_MEDIA_ITEMS%ROWTYPE;
1438: ERROR_CLOSING_MEDIA EXCEPTION;
1439: BEGIN
1440: -- Standard call to check for call compatibility.
1441: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1442: p_api_version_number,
1443: l_api_name,
1444: G_PKG_NAME)