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.IEX_STRY_UTL_PUB dependencies on IEX_STRY_UTL_PUB

Line 1: PACKAGE BODY IEX_STRY_UTL_PUB as

1: PACKAGE BODY IEX_STRY_UTL_PUB as
2: /* $Header: iexpsutb.pls 120.1.12010000.5 2009/01/22 10:54:12 barathsr ship $ */
3: -- Start of Comments
4: -- Package name : IEX_STRY_UTL_PUB
5: -- Purpose :

Line 4: -- Package name : IEX_STRY_UTL_PUB

1: PACKAGE BODY IEX_STRY_UTL_PUB as
2: /* $Header: iexpsutb.pls 120.1.12010000.5 2009/01/22 10:54:12 barathsr ship $ */
3: -- Start of Comments
4: -- Package name : IEX_STRY_UTL_PUB
5: -- Purpose :
6: -- History :
7: -- NOTE :
8: -- End of Comments

Line 10: G_PKG_NAME CONSTANT VARCHAR2(100):= 'IEX_STRY_UTL_PUB ';

6: -- History :
7: -- NOTE :
8: -- End of Comments
9:
10: G_PKG_NAME CONSTANT VARCHAR2(100):= 'IEX_STRY_UTL_PUB ';
11: G_FILE_NAME CONSTANT VARCHAR2(12) := 'iexpsutb.pls';
12:
13:
14: /**Name AddInvalidArgMsg

Line 439: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(l_strategy_work_item_Rec.work_item_id);

435: END IF;
436: --Begin bug#5874874 gnramasa 25-Apr-2007
437: --Update the UWQ summary table after closing the strategy.
438: if l_strategy_work_item_Rec.work_item_id is not null then
439: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(l_strategy_work_item_Rec.work_item_id);
440: end if;
441: --End bug#5874874 gnramasa 25-Apr-2007
442:
443: -- Standard call to get message count and if count is 1, get message info

Line 1092: WF_CORE.CONTEXT('IEX_STRY_UTL_PUB', 'create_workitem_check', p_event.getEventName(), p_subscription_guid);

1088: -- IF PG_DEBUG < 10 THEN
1089: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1090: iex_debug_pub.logmessage ('create_workitem_check: ' || 'raised exe error');
1091: END IF;
1092: WF_CORE.CONTEXT('IEX_STRY_UTL_PUB', 'create_workitem_check', p_event.getEventName(), p_subscription_guid);
1093: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1094: RETURN 'ERROR';
1095: WHEN OTHERS THEN
1096: WF_CORE.CONTEXT('IEX_STRY_UTL_PUB', 'create_workitem_check', p_event.getEventName(), p_subscription_guid);

Line 1096: WF_CORE.CONTEXT('IEX_STRY_UTL_PUB', 'create_workitem_check', p_event.getEventName(), p_subscription_guid);

1092: WF_CORE.CONTEXT('IEX_STRY_UTL_PUB', 'create_workitem_check', p_event.getEventName(), p_subscription_guid);
1093: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1094: RETURN 'ERROR';
1095: WHEN OTHERS THEN
1096: WF_CORE.CONTEXT('IEX_STRY_UTL_PUB', 'create_workitem_check', p_event.getEventName(), p_subscription_guid);
1097: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1098: RETURN 'ERROR';
1099:
1100:

Line 1159: WF_CORE.CONTEXT('IEX_STRY_UTL_PUB', 'create_workitem_complete', p_event.getEventName(), p_subscription_guid);

1155: -- IF PG_DEBUG < 10 THEN
1156: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1157: iex_debug_pub.logmessage ('create_workitem_complete: ' || 'raised exe error');
1158: END IF;
1159: WF_CORE.CONTEXT('IEX_STRY_UTL_PUB', 'create_workitem_complete', p_event.getEventName(), p_subscription_guid);
1160: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1161: RETURN 'ERROR';
1162: WHEN OTHERS THEN
1163: WF_CORE.CONTEXT('IEX_STRY_UTL_PUB', 'create_workitem_complete', p_event.getEventName(), p_subscription_guid);

Line 1163: WF_CORE.CONTEXT('IEX_STRY_UTL_PUB', 'create_workitem_complete', p_event.getEventName(), p_subscription_guid);

1159: WF_CORE.CONTEXT('IEX_STRY_UTL_PUB', 'create_workitem_complete', p_event.getEventName(), p_subscription_guid);
1160: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1161: RETURN 'ERROR';
1162: WHEN OTHERS THEN
1163: WF_CORE.CONTEXT('IEX_STRY_UTL_PUB', 'create_workitem_complete', p_event.getEventName(), p_subscription_guid);
1164: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1165: RETURN 'ERROR';
1166:
1167:

Line 1175: iex_debug_pub.logmessage (' BEGIN : IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM ********');

1171: --Clear the Strategy related data in UWQ summary table.
1172: procedure clear_uwq_str_summ(p_object_id in number,p_object_type in varchar2) is
1173: begin
1174: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1175: iex_debug_pub.logmessage ('**** BEGIN : IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM ************');
1176: iex_debug_pub.logmessage ('IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM object_type='||p_object_type);
1177: iex_debug_pub.logmessage ('IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM object_id='||p_object_id);
1178: END IF;
1179:

Line 1176: iex_debug_pub.logmessage ('IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM object_type='||p_object_type);

1172: procedure clear_uwq_str_summ(p_object_id in number,p_object_type in varchar2) is
1173: begin
1174: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1175: iex_debug_pub.logmessage ('**** BEGIN : IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM ************');
1176: iex_debug_pub.logmessage ('IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM object_type='||p_object_type);
1177: iex_debug_pub.logmessage ('IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM object_id='||p_object_id);
1178: END IF;
1179:
1180: IF p_object_type = 'PARTY' THEN

Line 1177: iex_debug_pub.logmessage ('IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM object_id='||p_object_id);

1173: begin
1174: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1175: iex_debug_pub.logmessage ('**** BEGIN : IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM ************');
1176: iex_debug_pub.logmessage ('IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM object_type='||p_object_type);
1177: iex_debug_pub.logmessage ('IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM object_id='||p_object_id);
1178: END IF;
1179:
1180: IF p_object_type = 'PARTY' THEN
1181:

Line 1183: iex_debug_pub.logmessage (' IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM: Clearing party level strategy uwq summary ********');

1179:
1180: IF p_object_type = 'PARTY' THEN
1181:
1182: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1183: iex_debug_pub.logmessage ('**** IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM: Clearing party level strategy uwq summary ************');
1184: END IF;
1185: UPDATE IEX_DLN_UWQ_SUMMARY
1186: SET WORK_ITEM_ID = null,
1187: SCHEDULE_START = null,

Line 1205: iex_debug_pub.logmessage (' IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM: Clearing account level strategy uwq summary ********');

1201: WHERE PARTY_ID = p_object_id;
1202:
1203: ELSIF p_object_type = 'IEX_ACCOUNT' THEN
1204: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1205: iex_debug_pub.logmessage ('**** IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM: Clearing account level strategy uwq summary ************');
1206: END IF;
1207: UPDATE IEX_DLN_UWQ_SUMMARY
1208: SET WORK_ITEM_ID = null,
1209: SCHEDULE_START = null,

Line 1227: iex_debug_pub.logmessage (' IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM: Clearing billto level strategy uwq summary ********');

1223: WHERE CUST_ACCOUNT_ID = p_object_id;
1224:
1225: ELSIF p_object_type = 'IEX_BILLTO' THEN
1226: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1227: iex_debug_pub.logmessage ('**** IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM: Clearing billto level strategy uwq summary ************');
1228: END IF;
1229: UPDATE IEX_DLN_UWQ_SUMMARY
1230: SET WORK_ITEM_ID = null,
1231: SCHEDULE_START = null,

Line 1248: iex_debug_pub.logmessage (' IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM: Clearing party level strategy uwq summary ********');

1244: WKITEM_ESCALATED_YN = null
1245: WHERE SITE_USE_ID = p_object_id;
1246: END IF;
1247: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1248: iex_debug_pub.logmessage ('**** IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM: Clearing party level strategy uwq summary ************');
1249: END IF;
1250: exception
1251: when others then
1252: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1253: iex_debug_pub.logmessage (' EXCEPTION: IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM ********');

1249: END IF;
1250: exception
1251: when others then
1252: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1253: iex_debug_pub.logmessage ('**** EXCEPTION: IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM ************');
1254: END IF;
1255: end;
1256:
1257: --Update the Strategy related data in UWQ summary table.

Line 1339: iex_debug_pub.logmessage (' IEX_STRY_UTL_PUB.REFRESH_UWQ_STR_SUMM: Updating party level strategy uwq summary ********');

1335: return;
1336: end if;
1337: IF l_jtf_object_type = 'PARTY' THEN
1338: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1339: iex_debug_pub.logmessage ('**** IEX_STRY_UTL_PUB.REFRESH_UWQ_STR_SUMM: Updating party level strategy uwq summary ************');
1340: END IF;
1341: update iex_dln_uwq_summary
1342: set work_item_id = l_work_item_id,
1343: schedule_start = l_schedule_start,

Line 1361: iex_debug_pub.logmessage (' IEX_STRY_UTL_PUB.REFRESH_UWQ_STR_SUMM: Updating account level strategy uwq summary ********');

1357: where party_id = l_jtf_object_id;
1358:
1359: ELSIF l_jtf_object_type = 'IEX_ACCOUNT' THEN
1360: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1361: iex_debug_pub.logmessage ('**** IEX_STRY_UTL_PUB.REFRESH_UWQ_STR_SUMM: Updating account level strategy uwq summary ************');
1362: END IF;
1363: update iex_dln_uwq_summary
1364: set work_item_id = l_work_item_id,
1365: schedule_start = l_schedule_start,

Line 1383: iex_debug_pub.logmessage (' IEX_STRY_UTL_PUB.REFRESH_UWQ_STR_SUMM: Updating billto level strategy uwq summary ********');

1379: where cust_account_id = l_jtf_object_id;
1380:
1381: ELSIF l_jtf_object_type = 'IEX_BILLTO' THEN
1382: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1383: iex_debug_pub.logmessage ('**** IEX_STRY_UTL_PUB.REFRESH_UWQ_STR_SUMM: Updating billto level strategy uwq summary ************');
1384: END IF;
1385: update iex_dln_uwq_summary
1386: set work_item_id = l_work_item_id,
1387: schedule_start = l_schedule_start,

Line 1627: END IEX_STRY_UTL_PUB ;

1623:
1624: END UPDATE_AND_SENDSIGNAL;
1625: */
1626:
1627: END IEX_STRY_UTL_PUB ;
1628:
1629: