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 2041: -- Standard Start of API savepoint

2037: AND ACTIVE_FLAG = 'T'
2038: AND APPLICATION_ID = 680);
2039:
2040: BEGIN
2041: -- Standard Start of API savepoint
2042: SAVEPOINT wrapUp_pvt;
2043: -- Init vars
2044: l_api_name :='wrapUp';
2045: l_api_version_number :=1.0;

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

2049: l_ob_action_id := 0;
2050: l_reroute_to_classi := null;
2051: l_mc_param_action := ' ';
2052:
2053: -- Standard call to check for call compatibility.
2054: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
2055: 1.0,
2056: l_api_name,
2057: G_PKG_NAME)

Line 2994: -- Standard Check Of p_commit.

2990: end if;
2991:
2992: -------------------End Code------------------------
2993: <>
2994: -- Standard Check Of p_commit.
2995: IF FND_API.To_Boolean(p_commit) THEN
2996: COMMIT WORK;
2997: END IF;
2998:

Line 3116: -- Standard Start of API savepoint

3112: ORDER BY m.rt_interaction_id;
3113:
3114: BEGIN
3115:
3116: -- Standard Start of API savepoint
3117: SAVEPOINT recoverCompose_pvt;
3118:
3119: -- Init vars
3120: l_api_name :='recoverCompose';

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

3122: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3123: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3124: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3125:
3126: -- Standard call to check for call compatibility.
3127: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3128: 1.0,
3129: l_api_name,
3130: G_PKG_NAME)

Line 3242: -- Standard Start of API savepoint

3238: WHERE email_account_id = p_account_id
3239: ORDER BY agent_id;
3240: BEGIN
3241:
3242: -- Standard Start of API savepoint
3243: SAVEPOINT getAccountDelStatus_pvt;
3244:
3245: -- Init vars
3246: l_api_name :='getAccountDelStatus';

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

3245: -- Init vars
3246: l_api_name :='getAccountDelStatus';
3247: l_api_version_number :=1.0;
3248:
3249: -- Standard call to check for call compatibility.
3250: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3251: p_api_version_number,
3252: l_api_name,
3253: G_PKG_NAME)

Line 3297: -- Standard Check Of p_commit.

3293: end if;
3294: END LOOP;
3295: END IF;
3296: ----------------------------------------CODE-----------------------------------
3297: -- Standard Check Of p_commit.
3298: IF FND_API.To_Boolean(p_commit) THEN
3299: COMMIT WORK;
3300: END IF;
3301: -- Standard callto get message count and if count is 1, get message info.

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

3297: -- Standard Check Of p_commit.
3298: IF FND_API.To_Boolean(p_commit) THEN
3299: COMMIT WORK;
3300: END IF;
3301: -- Standard callto get message count and if count is 1, get message info.
3302: FND_MSG_PUB.Count_And_Get
3303: ( p_encoded => FND_API.G_TRUE,
3304: p_count => x_msg_count,
3305: p_data => x_msg_data

Line 3392: -- Standard Start of API savepoint

3388: SELECT RT_MEDIA_ITEM_ID FROM iem_rt_media_items WHERE expire= 'Y';
3389:
3390: BEGIN
3391:
3392: -- Standard Start of API savepoint
3393: SAVEPOINT purgeOutbound_pvt;
3394:
3395: -- Init vars
3396: l_api_name :='purgeOutbound';

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

3397: l_api_version_number :=1.0;
3398: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
3399: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
3400:
3401: -- Standard call to check for call compatibility.
3402: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3403: 1.0,
3404: l_api_name,
3405: G_PKG_NAME)

Line 3581: -- Standard Check Of p_commit.

3577: raise FND_API.G_EXC_UNEXPECTED_ERROR;
3578: END;
3579:
3580: -------------------End Code------------------------
3581: -- Standard Check Of p_commit.
3582: IF FND_API.To_Boolean(p_commit) THEN
3583: COMMIT WORK;
3584: END IF;
3585: -- Standard callto get message count and if count is 1, get message info.

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

3581: -- Standard Check Of p_commit.
3582: IF FND_API.To_Boolean(p_commit) THEN
3583: COMMIT WORK;
3584: END IF;
3585: -- Standard callto get message count and if count is 1, get message info.
3586: FND_MSG_PUB.Count_And_Get
3587: ( p_encoded => FND_API.G_TRUE,
3588: p_count => x_msg_count,
3589: p_data => x_msg_data

Line 3680: -- Standard Start of API savepoint

3676:
3677:
3678: BEGIN
3679:
3680: -- Standard Start of API savepoint
3681: SAVEPOINT assignMsg_pvt;
3682:
3683: -- Init vars
3684: l_api_name :='assignMsg';

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

3694: l_lead_id :=null;
3695: l_milcs_id :=null;
3696:
3697:
3698: -- Standard call to check for call compatibility.
3699: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3700: 1.0,
3701: l_api_name,
3702: G_PKG_NAME)

Line 3914: -- Standard Check Of p_commit.

3910:
3911:
3912:
3913: -------------------End Code------------------------
3914: -- Standard Check Of p_commit.
3915: IF FND_API.To_Boolean(p_commit) THEN
3916: COMMIT WORK;
3917: END IF;
3918: -- Standard callto get message count and if count is 1, get message info.

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

3914: -- Standard Check Of p_commit.
3915: IF FND_API.To_Boolean(p_commit) THEN
3916: COMMIT WORK;
3917: END IF;
3918: -- Standard callto get message count and if count is 1, get message info.
3919: FND_MSG_PUB.Count_And_Get
3920: ( p_encoded => FND_API.G_TRUE,
3921: p_count => x_msg_count,
3922: p_data => x_msg_data

Line 4005: -- Standard Start of API savepoint

4001: l_noop NUMBER;
4002:
4003: BEGIN
4004:
4005: -- Standard Start of API savepoint
4006: SAVEPOINT queueToOutbox_pvt;
4007: -- Init vars
4008: l_api_name :='queueToOutbox';
4009: l_api_version_number :=1.0;

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

4011: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4012: l_last_update_login := NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4013: l_noop := 0;
4014:
4015: -- Standard call to check for call compatibility.
4016: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
4017: 1.0,
4018: l_api_name,
4019: G_PKG_NAME)

Line 4107: -- Standard Check Of p_commit.

4103:
4104: END IF;
4105:
4106: -------------------End Code------------------------
4107: -- Standard Check Of p_commit.
4108: IF FND_API.To_Boolean(p_commit) THEN
4109: COMMIT WORK;
4110: END IF;
4111:

Line 4219: -- Standard Start of API savepoint

4215:
4216:
4217: BEGIN
4218:
4219: -- Standard Start of API savepoint
4220: SAVEPOINT getNextOutboxItem_pvt;
4221: -- Init vars
4222: l_api_name :='getNextOutboxItem';
4223: l_api_version_number :=1.0;

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

4223: l_api_version_number :=1.0;
4224: l_email_account_id := 0;
4225: l_agent_account_id := 0;
4226:
4227: -- Standard call to check for call compatibility.
4228: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
4229: 1.0,
4230: l_api_name,
4231: G_PKG_NAME)

Line 4513: -- Standard Start of API savepoint

4509: l_ih_creator VARCHAR2(1);
4510:
4511: BEGIN
4512:
4513: -- Standard Start of API savepoint
4514: SAVEPOINT createRTItem_pvt;
4515:
4516: -- Init vars
4517: l_api_name :='createRTItem';

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

4524: l_customer_id :=null;
4525: l_contact_id :=null;
4526: l_lead_id :=null;
4527:
4528: -- Standard call to check for call compatibility.
4529: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
4530: 1.0,
4531: l_api_name,
4532: G_PKG_NAME)

Line 4670: -- Standard Check Of p_commit.

4666:
4667: END IF;
4668:
4669: -------------------End Code------------------------
4670: -- Standard Check Of p_commit.
4671: IF FND_API.To_Boolean(p_commit) THEN
4672: COMMIT WORK;
4673: END IF;
4674: -- Standard callto get message count and if count is 1, get message info.

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

4670: -- Standard Check Of p_commit.
4671: IF FND_API.To_Boolean(p_commit) THEN
4672: COMMIT WORK;
4673: END IF;
4674: -- Standard callto get message count and if count is 1, get message info.
4675: -- FND_MSG_PUB.Count_And_Get
4676: -- ( p_encoded => FND_API.G_TRUE,
4677: -- p_count => x_msg_count,
4678: -- p_data => x_msg_data

Line 4733: -- Standard Start of API savepoint

4729: l_user_name VARCHAR2(100);
4730:
4731: BEGIN
4732:
4733: -- Standard Start of API savepoint
4734: SAVEPOINT isAgentInboxClean_pvt;
4735:
4736: -- Init vars
4737: l_api_name :='isAgentInboxClean';

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

4739: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4740: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4741: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4742:
4743: -- Standard call to check for call compatibility.
4744: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
4745: 1.0,
4746: l_api_name,
4747: G_PKG_NAME)

Line 4798: -- Standard Check Of p_commit.

4794: if ( (l_count1 + l_count2) = 0 ) then
4795: x_is_clean := true;
4796: end if;
4797: -------------------End Code------------------------
4798: -- Standard Check Of p_commit.
4799: IF FND_API.To_Boolean(p_commit) THEN
4800: COMMIT WORK;
4801: END IF;
4802: -- Standard callto get message count and if count is 1, get message info.

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

4798: -- Standard Check Of p_commit.
4799: IF FND_API.To_Boolean(p_commit) THEN
4800: COMMIT WORK;
4801: END IF;
4802: -- Standard callto get message count and if count is 1, get message info.
4803: -- FND_MSG_PUB.Count_And_Get
4804: -- ( p_encoded => FND_API.G_TRUE,
4805: -- p_count => x_msg_count,
4806: -- p_data => x_msg_data

Line 4866: -- Standard Start of API savepoint

4862: l_last_update_login NUMBER;
4863:
4864: BEGIN
4865:
4866: -- Standard Start of API savepoint
4867: SAVEPOINT updateOutboundMessageID_pvt;
4868:
4869: -- Init vars
4870: l_api_name :='updateOutboundMessageID';

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

4872: l_created_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4873: l_last_updated_by :=NVL(to_number(FND_PROFILE.VALUE('USER_ID')),-1);
4874: l_last_update_login :=NVL(to_number(FND_PROFILE.VALUE('LOGIN_ID')), -1);
4875:
4876: -- Standard call to check for call compatibility.
4877: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
4878: 1.0,
4879: l_api_name,
4880: G_PKG_NAME)

Line 4905: -- Standard Check Of p_commit.

4901:
4902: end;
4903:
4904: -------------------End Code------------------------
4905: -- Standard Check Of p_commit.
4906: IF FND_API.To_Boolean(p_commit) THEN
4907: COMMIT WORK;
4908: END IF;
4909: -- Standard callto get message count and if count is 1, get message info.

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

4905: -- Standard Check Of p_commit.
4906: IF FND_API.To_Boolean(p_commit) THEN
4907: COMMIT WORK;
4908: END IF;
4909: -- Standard callto get message count and if count is 1, get message info.
4910: -- FND_MSG_PUB.Count_And_Get
4911: -- ( p_encoded => FND_API.G_TRUE,
4912: -- p_count => x_msg_count,
4913: -- p_data => x_msg_data