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

Line 83: -- Standard Start of API savepoint

79: l_relationship_id NUMBER;
80:
81: BEGIN
82:
83: -- Standard Start of API savepoint
84: SAVEPOINT getWork_pvt;
85:
86: -- Initialize variables
87: l_api_name :='getWork';

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

95: l_contact_id :=null;
96: l_lead_id :=null;
97:
98:
99: -- Standard call to check for call compatibility.
100: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
101: 1.0,
102: l_api_name,
103: G_PKG_NAME)

Line 124: --Set the l_classification_id to null if it is a NOP per 9i standard

120: */
121:
122: --Future: Call Media Check [check if max interactions reached]
123:
124: --Set the l_classification_id to null if it is a NOP per 9i standard
125: select decode(p_classification_id,G_NUM_NOP2, null,
126: p_classification_id) into l_classification_id from DUAL;
127:
128: --Call MailItem to get the next available message.

Line 264: -- Standard Check Of p_commit.

260: x_msg_data := l_msg_data;
261:
262: END IF;
263: -------------------End Code------------------------
264: -- Standard Check Of p_commit.
265: IF FND_API.To_Boolean(p_commit) THEN
266: COMMIT WORK;
267: END IF;
268: -- Standard callto get message count and if count is 1, get message info.

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

264: -- Standard Check Of p_commit.
265: IF FND_API.To_Boolean(p_commit) THEN
266: COMMIT WORK;
267: END IF;
268: -- Standard callto get message count and if count is 1, get message info.
269: FND_MSG_PUB.Count_And_Get
270: ( p_encoded => FND_API.G_TRUE,
271: p_count => x_msg_count,
272: p_data => x_msg_data

Line 379: -- Standard Start of API savepoint

375: l_ih_media_id NUMBER;
376:
377: BEGIN
378:
379: -- Standard Start of API savepoint
380: SAVEPOINT getMediaDetails_pvt;
381:
382: -- Init vars
383: l_api_name :='getMediaDetails';

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

395: l_message_id := 0;
396: l_customer_id := 0;
397: l_found := 0;
398:
399: -- Standard call to check for call compatibility.
400: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
401: 1.0,
402: l_api_name,
403: G_PKG_NAME)

Line 629: -- Standard Start of API savepoint

625: ExQ EXCEPTION;
626:
627: BEGIN
628:
629: -- Standard Start of API savepoint
630: SAVEPOINT getSearchDetails_pvt;
631:
632: -- Init vars
633: l_api_name :='getSearchDetails';

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

640: l_rt_interaction_id := 0;
641: l_oes_id := 0;
642: l_customer_id := 0;
643:
644: -- Standard call to check for call compatibility.
645: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
646: 1.0,
647: l_api_name,
648: G_PKG_NAME)

Line 848: -- Standard Start of API savepoint

844: l_ih_subject VARCHAR2(80);
845:
846: BEGIN
847:
848: -- Standard Start of API savepoint
849: SAVEPOINT createUnprocMediaItm_pvt;
850:
851: -- Init vars
852: l_api_name :='createUnprocMediaItm';

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

867: l_folder_uid := 0;
868: l_customer_id := 0;
869:
870:
871: -- Standard call to check for call compatibility.
872: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
873: 1.0,
874: l_api_name,
875: G_PKG_NAME)

Line 891: -- Standard Check Of p_commit.

887: x_return_status := FND_API.G_RET_STS_SUCCESS;
888:
889: -----------------------Code------------------------
890:
891: -- Standard Check Of p_commit.
892: IF FND_API.To_Boolean(p_commit) THEN
893: COMMIT WORK;
894: END IF;
895: -- Standard callto get message count and if count is 1, get message info.

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

891: -- Standard Check Of p_commit.
892: IF FND_API.To_Boolean(p_commit) THEN
893: COMMIT WORK;
894: END IF;
895: -- Standard callto get message count and if count is 1, get message info.
896: FND_MSG_PUB.Count_And_Get
897: ( p_encoded => FND_API.G_TRUE,
898: p_count => x_msg_count,
899: p_data => x_msg_data

Line 1001: -- Standard Start of API savepoint

997: l_ih_subject VARCHAR2(80);
998:
999: BEGIN
1000:
1001: -- Standard Start of API savepoint
1002: SAVEPOINT createMediaDetails_pvt;
1003: -- Init vars
1004: l_api_name :='createMediaDetails';
1005: l_api_version_number :=1.0;

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

1012: l_rt_interaction_id := 0;
1013: l_email_type := '';
1014: l_ib_media_id := -1;
1015:
1016: -- Standard call to check for call compatibility.
1017: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1018: 1.0,
1019: l_api_name,
1020: G_PKG_NAME)

Line 1326: -- Standard Start of API savepoint

1322: AND ACTIVE_FLAG = 'T'
1323: AND APPLICATION_ID = 680);
1324: BEGIN
1325:
1326: -- Standard Start of API savepoint
1327: SAVEPOINT updateMediaDetails_pvt;
1328:
1329: -- Init vars
1330: l_api_name :='updateMediaDetails';

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

1337: l_uwq_act_code := null;
1338: l_ib_media_id := -1;
1339: l_ob_media_id := null;
1340:
1341: -- Standard call to check for call compatibility.
1342: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1343: 1.0,
1344: l_api_name,
1345: G_PKG_NAME)

Line 1744: -- Standard Start of API savepoint

1740: l_primary_customer_id NUMBER;
1741:
1742: BEGIN
1743:
1744: -- Standard Start of API savepoint
1745: SAVEPOINT getIHID_pvt;
1746:
1747: -- Init vars
1748: l_api_name :='getIHID';

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

1750: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1751: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
1752: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
1753:
1754: -- Standard call to check for call compatibility.
1755: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1756: 1.0,
1757: l_api_name,
1758: G_PKG_NAME)

Line 1863: -- Standard Check Of p_commit.

1859:
1860: x_interaction_id := l_interaction_id;
1861:
1862: -------------------End Code------------------------
1863: -- Standard Check Of p_commit.
1864: IF FND_API.To_Boolean(p_commit) THEN
1865: COMMIT WORK;
1866: END IF;
1867:

Line 2035: -- Standard Start of API savepoint

2031: AND ACTIVE_FLAG = 'T'
2032: AND APPLICATION_ID = 680);
2033:
2034: BEGIN
2035: -- Standard Start of API savepoint
2036: SAVEPOINT wrapUp_pvt;
2037: -- Init vars
2038: l_api_name :='wrapUp';
2039: l_api_version_number :=1.0;

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

2043: l_ob_action_id := 0;
2044: l_reroute_to_classi := null;
2045: l_mc_param_action := ' ';
2046:
2047: -- Standard call to check for call compatibility.
2048: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
2049: 1.0,
2050: l_api_name,
2051: G_PKG_NAME)

Line 2932: -- Standard Check Of p_commit.

2928: end if;
2929:
2930: -------------------End Code------------------------
2931: <>
2932: -- Standard Check Of p_commit.
2933: IF FND_API.To_Boolean(p_commit) THEN
2934: COMMIT WORK;
2935: END IF;
2936:

Line 3054: -- Standard Start of API savepoint

3050: ORDER BY m.rt_interaction_id;
3051:
3052: BEGIN
3053:
3054: -- Standard Start of API savepoint
3055: SAVEPOINT recoverCompose_pvt;
3056:
3057: -- Init vars
3058: l_api_name :='recoverCompose';

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

3060: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3061: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3062: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3063:
3064: -- Standard call to check for call compatibility.
3065: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3066: 1.0,
3067: l_api_name,
3068: G_PKG_NAME)

Line 3180: -- Standard Start of API savepoint

3176: WHERE email_account_id = p_account_id
3177: ORDER BY agent_id;
3178: BEGIN
3179:
3180: -- Standard Start of API savepoint
3181: SAVEPOINT getAccountDelStatus_pvt;
3182:
3183: -- Init vars
3184: l_api_name :='getAccountDelStatus';

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

3183: -- Init vars
3184: l_api_name :='getAccountDelStatus';
3185: l_api_version_number :=1.0;
3186:
3187: -- Standard call to check for call compatibility.
3188: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3189: p_api_version_number,
3190: l_api_name,
3191: G_PKG_NAME)

Line 3235: -- Standard Check Of p_commit.

3231: end if;
3232: END LOOP;
3233: END IF;
3234: ----------------------------------------CODE-----------------------------------
3235: -- Standard Check Of p_commit.
3236: IF FND_API.To_Boolean(p_commit) THEN
3237: COMMIT WORK;
3238: END IF;
3239: -- Standard callto get message count and if count is 1, get message info.

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

3235: -- Standard Check Of p_commit.
3236: IF FND_API.To_Boolean(p_commit) THEN
3237: COMMIT WORK;
3238: END IF;
3239: -- Standard callto get message count and if count is 1, get message info.
3240: FND_MSG_PUB.Count_And_Get
3241: ( p_encoded => FND_API.G_TRUE,
3242: p_count => x_msg_count,
3243: p_data => x_msg_data

Line 3330: -- Standard Start of API savepoint

3326: SELECT RT_MEDIA_ITEM_ID FROM iem_rt_media_items WHERE expire= 'Y';
3327:
3328: BEGIN
3329:
3330: -- Standard Start of API savepoint
3331: SAVEPOINT purgeOutbound_pvt;
3332:
3333: -- Init vars
3334: l_api_name :='purgeOutbound';

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

3335: l_api_version_number :=1.0;
3336: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3337: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3338:
3339: -- Standard call to check for call compatibility.
3340: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3341: 1.0,
3342: l_api_name,
3343: G_PKG_NAME)

Line 3519: -- Standard Check Of p_commit.

3515: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3516: END;
3517:
3518: -------------------End Code------------------------
3519: -- Standard Check Of p_commit.
3520: IF FND_API.To_Boolean(p_commit) THEN
3521: COMMIT WORK;
3522: END IF;
3523: -- Standard callto get message count and if count is 1, get message info.

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

3519: -- Standard Check Of p_commit.
3520: IF FND_API.To_Boolean(p_commit) THEN
3521: COMMIT WORK;
3522: END IF;
3523: -- Standard callto get message count and if count is 1, get message info.
3524: FND_MSG_PUB.Count_And_Get
3525: ( p_encoded => FND_API.G_TRUE,
3526: p_count => x_msg_count,
3527: p_data => x_msg_data

Line 3616: -- Standard Start of API savepoint

3612:
3613:
3614: BEGIN
3615:
3616: -- Standard Start of API savepoint
3617: SAVEPOINT assignMsg_pvt;
3618:
3619: -- Init vars
3620: l_api_name :='assignMsg';

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

3630: l_lead_id :=null;
3631: l_milcs_id :=null;
3632:
3633:
3634: -- Standard call to check for call compatibility.
3635: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3636: 1.0,
3637: l_api_name,
3638: G_PKG_NAME)

Line 3839: -- Standard Check Of p_commit.

3835:
3836:
3837:
3838: -------------------End Code------------------------
3839: -- Standard Check Of p_commit.
3840: IF FND_API.To_Boolean(p_commit) THEN
3841: COMMIT WORK;
3842: END IF;
3843: -- Standard callto get message count and if count is 1, get message info.

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

3839: -- Standard Check Of p_commit.
3840: IF FND_API.To_Boolean(p_commit) THEN
3841: COMMIT WORK;
3842: END IF;
3843: -- Standard callto get message count and if count is 1, get message info.
3844: FND_MSG_PUB.Count_And_Get
3845: ( p_encoded => FND_API.G_TRUE,
3846: p_count => x_msg_count,
3847: p_data => x_msg_data

Line 3930: -- Standard Start of API savepoint

3926: l_noop NUMBER;
3927:
3928: BEGIN
3929:
3930: -- Standard Start of API savepoint
3931: SAVEPOINT queueToOutbox_pvt;
3932: -- Init vars
3933: l_api_name :='queueToOutbox';
3934: l_api_version_number :=1.0;

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

3936: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3937: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3938: l_noop := 0;
3939:
3940: -- Standard call to check for call compatibility.
3941: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3942: 1.0,
3943: l_api_name,
3944: G_PKG_NAME)

Line 4032: -- Standard Check Of p_commit.

4028:
4029: END IF;
4030:
4031: -------------------End Code------------------------
4032: -- Standard Check Of p_commit.
4033: IF FND_API.To_Boolean(p_commit) THEN
4034: COMMIT WORK;
4035: END IF;
4036:

Line 4144: -- Standard Start of API savepoint

4140:
4141:
4142: BEGIN
4143:
4144: -- Standard Start of API savepoint
4145: SAVEPOINT getNextOutboxItem_pvt;
4146: -- Init vars
4147: l_api_name :='getNextOutboxItem';
4148: l_api_version_number :=1.0;

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

4148: l_api_version_number :=1.0;
4149: l_email_account_id := 0;
4150: l_agent_account_id := 0;
4151:
4152: -- Standard call to check for call compatibility.
4153: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
4154: 1.0,
4155: l_api_name,
4156: G_PKG_NAME)

Line 4438: -- Standard Start of API savepoint

4434: l_ih_creator VARCHAR2(1);
4435:
4436: BEGIN
4437:
4438: -- Standard Start of API savepoint
4439: SAVEPOINT createRTItem_pvt;
4440:
4441: -- Init vars
4442: l_api_name :='createRTItem';

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

4449: l_customer_id :=null;
4450: l_contact_id :=null;
4451: l_lead_id :=null;
4452:
4453: -- Standard call to check for call compatibility.
4454: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
4455: 1.0,
4456: l_api_name,
4457: G_PKG_NAME)

Line 4595: -- Standard Check Of p_commit.

4591:
4592: END IF;
4593:
4594: -------------------End Code------------------------
4595: -- Standard Check Of p_commit.
4596: IF FND_API.To_Boolean(p_commit) THEN
4597: COMMIT WORK;
4598: END IF;
4599: -- Standard callto get message count and if count is 1, get message info.

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

4595: -- Standard Check Of p_commit.
4596: IF FND_API.To_Boolean(p_commit) THEN
4597: COMMIT WORK;
4598: END IF;
4599: -- Standard callto get message count and if count is 1, get message info.
4600: -- FND_MSG_PUB.Count_And_Get
4601: -- ( p_encoded => FND_API.G_TRUE,
4602: -- p_count => x_msg_count,
4603: -- p_data => x_msg_data

Line 4658: -- Standard Start of API savepoint

4654: l_user_name VARCHAR2(100);
4655:
4656: BEGIN
4657:
4658: -- Standard Start of API savepoint
4659: SAVEPOINT isAgentInboxClean_pvt;
4660:
4661: -- Init vars
4662: l_api_name :='isAgentInboxClean';

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

4664: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4665: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4666: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4667:
4668: -- Standard call to check for call compatibility.
4669: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
4670: 1.0,
4671: l_api_name,
4672: G_PKG_NAME)

Line 4723: -- Standard Check Of p_commit.

4719: if ( (l_count1 + l_count2) = 0 ) then
4720: x_is_clean := true;
4721: end if;
4722: -------------------End Code------------------------
4723: -- Standard Check Of p_commit.
4724: IF FND_API.To_Boolean(p_commit) THEN
4725: COMMIT WORK;
4726: END IF;
4727: -- Standard callto get message count and if count is 1, get message info.

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

4723: -- Standard Check Of p_commit.
4724: IF FND_API.To_Boolean(p_commit) THEN
4725: COMMIT WORK;
4726: END IF;
4727: -- Standard callto get message count and if count is 1, get message info.
4728: -- FND_MSG_PUB.Count_And_Get
4729: -- ( p_encoded => FND_API.G_TRUE,
4730: -- p_count => x_msg_count,
4731: -- p_data => x_msg_data

Line 4791: -- Standard Start of API savepoint

4787: l_last_update_login NUMBER;
4788:
4789: BEGIN
4790:
4791: -- Standard Start of API savepoint
4792: SAVEPOINT updateOutboundMessageID_pvt;
4793:
4794: -- Init vars
4795: l_api_name :='updateOutboundMessageID';

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

4797: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4798: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4799: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4800:
4801: -- Standard call to check for call compatibility.
4802: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
4803: 1.0,
4804: l_api_name,
4805: G_PKG_NAME)

Line 4830: -- Standard Check Of p_commit.

4826:
4827: end;
4828:
4829: -------------------End Code------------------------
4830: -- Standard Check Of p_commit.
4831: IF FND_API.To_Boolean(p_commit) THEN
4832: COMMIT WORK;
4833: END IF;
4834: -- Standard callto get message count and if count is 1, get message info.

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

4830: -- Standard Check Of p_commit.
4831: IF FND_API.To_Boolean(p_commit) THEN
4832: COMMIT WORK;
4833: END IF;
4834: -- Standard callto get message count and if count is 1, get message info.
4835: -- FND_MSG_PUB.Count_And_Get
4836: -- ( p_encoded => FND_API.G_TRUE,
4837: -- p_count => x_msg_count,
4838: -- p_data => x_msg_data