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.9.12020000.3 2012/08/13 13:51:30 bibeura 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.9.12020000.3 2012/08/13 13:51:30 bibeura 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 445: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(l_strategy_work_item_Rec.work_item_id,p_commit);

441: END IF;
442: --Begin bug#5874874 gnramasa 25-Apr-2007
443: --Update the UWQ summary table after closing the strategy.
444: if l_strategy_work_item_Rec.work_item_id is not null then
445: IEX_STRY_UTL_PUB.refresh_uwq_str_summ(l_strategy_work_item_Rec.work_item_id,p_commit);
446: end if;
447: --End bug#5874874 gnramasa 25-Apr-2007
448:
449: -- Standard call to get message count and if count is 1, get message info

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

1094: -- IF PG_DEBUG < 10 THEN
1095: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1096: iex_debug_pub.logmessage ('create_workitem_check: ' || 'raised exe error');
1097: END IF;
1098: WF_CORE.CONTEXT('IEX_STRY_UTL_PUB', 'create_workitem_check', p_event.getEventName(), p_subscription_guid);
1099: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1100: RETURN 'ERROR';
1101: WHEN OTHERS THEN
1102: WF_CORE.CONTEXT('IEX_STRY_UTL_PUB', 'create_workitem_check', p_event.getEventName(), p_subscription_guid);

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

1098: WF_CORE.CONTEXT('IEX_STRY_UTL_PUB', 'create_workitem_check', p_event.getEventName(), p_subscription_guid);
1099: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1100: RETURN 'ERROR';
1101: WHEN OTHERS THEN
1102: WF_CORE.CONTEXT('IEX_STRY_UTL_PUB', 'create_workitem_check', p_event.getEventName(), p_subscription_guid);
1103: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1104: RETURN 'ERROR';
1105:
1106:

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

1161: -- IF PG_DEBUG < 10 THEN
1162: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1163: iex_debug_pub.logmessage ('create_workitem_complete: ' || 'raised exe error');
1164: END IF;
1165: WF_CORE.CONTEXT('IEX_STRY_UTL_PUB', 'create_workitem_complete', p_event.getEventName(), p_subscription_guid);
1166: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1167: RETURN 'ERROR';
1168: WHEN OTHERS THEN
1169: WF_CORE.CONTEXT('IEX_STRY_UTL_PUB', 'create_workitem_complete', p_event.getEventName(), p_subscription_guid);

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

1165: WF_CORE.CONTEXT('IEX_STRY_UTL_PUB', 'create_workitem_complete', p_event.getEventName(), p_subscription_guid);
1166: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1167: RETURN 'ERROR';
1168: WHEN OTHERS THEN
1169: WF_CORE.CONTEXT('IEX_STRY_UTL_PUB', 'create_workitem_complete', p_event.getEventName(), p_subscription_guid);
1170: WF_EVENT.setErrorInfo(p_event, 'ERROR');
1171: RETURN 'ERROR';
1172:
1173:

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

1177: --Clear the Strategy related data in UWQ summary table.
1178: procedure clear_uwq_str_summ(p_object_id in number,p_object_type in varchar2) is
1179: begin
1180: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1181: iex_debug_pub.logmessage ('**** BEGIN : IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM ************');
1182: iex_debug_pub.logmessage ('IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM object_type='||p_object_type);
1183: iex_debug_pub.logmessage ('IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM object_id='||p_object_id);
1184: END IF;
1185:

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

1178: procedure clear_uwq_str_summ(p_object_id in number,p_object_type in varchar2) is
1179: begin
1180: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1181: iex_debug_pub.logmessage ('**** BEGIN : IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM ************');
1182: iex_debug_pub.logmessage ('IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM object_type='||p_object_type);
1183: iex_debug_pub.logmessage ('IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM object_id='||p_object_id);
1184: END IF;
1185:
1186: IF p_object_type = 'PARTY' THEN

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

1179: begin
1180: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1181: iex_debug_pub.logmessage ('**** BEGIN : IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM ************');
1182: iex_debug_pub.logmessage ('IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM object_type='||p_object_type);
1183: iex_debug_pub.logmessage ('IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM object_id='||p_object_id);
1184: END IF;
1185:
1186: IF p_object_type = 'PARTY' THEN
1187:

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

1185:
1186: IF p_object_type = 'PARTY' THEN
1187:
1188: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1189: iex_debug_pub.logmessage ('**** IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM: Clearing party level strategy uwq summary ************');
1190: END IF;
1191: UPDATE IEX_DLN_UWQ_SUMMARY
1192: SET WORK_ITEM_ID = null,
1193: SCHEDULE_START = null,

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

1208: WHERE PARTY_ID = p_object_id;
1209:
1210: ELSIF p_object_type = 'IEX_ACCOUNT' THEN
1211: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1212: iex_debug_pub.logmessage ('**** IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM: Clearing account level strategy uwq summary ************');
1213: END IF;
1214: UPDATE IEX_DLN_UWQ_SUMMARY
1215: SET WORK_ITEM_ID = null,
1216: SCHEDULE_START = null,

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

1231: WHERE CUST_ACCOUNT_ID = p_object_id;
1232:
1233: ELSIF p_object_type = 'IEX_BILLTO' THEN
1234: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1235: iex_debug_pub.logmessage ('**** IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM: Clearing billto level strategy uwq summary ************');
1236: END IF;
1237: UPDATE IEX_DLN_UWQ_SUMMARY
1238: SET WORK_ITEM_ID = null,
1239: SCHEDULE_START = null,

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

1253: WKITEM_ESCALATED_YN = null
1254: WHERE SITE_USE_ID = p_object_id;
1255: END IF;
1256: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1257: iex_debug_pub.logmessage ('**** IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM: Clearing party level strategy uwq summary ************');
1258: END IF;
1259: exception
1260: when others then
1261: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

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

1258: END IF;
1259: exception
1260: when others then
1261: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1262: iex_debug_pub.logmessage ('**** EXCEPTION: IEX_STRY_UTL_PUB.CLEAR_UWQ_STR_SUMM ************');
1263: END IF;
1264: end;
1265:
1266: --Update the Strategy related data in UWQ summary table.

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

1348: return;
1349: end if;
1350: IF l_jtf_object_type = 'PARTY' THEN
1351: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1352: iex_debug_pub.logmessage ('**** IEX_STRY_UTL_PUB.REFRESH_UWQ_STR_SUMM: Updating party level strategy uwq summary ************');
1353: END IF;
1354: update iex_dln_uwq_summary
1355: set work_item_id = l_work_item_id,
1356: schedule_start = l_schedule_start,

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

1371: where party_id = l_jtf_object_id;
1372:
1373: ELSIF l_jtf_object_type = 'IEX_ACCOUNT' THEN
1374: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1375: iex_debug_pub.logmessage ('**** IEX_STRY_UTL_PUB.REFRESH_UWQ_STR_SUMM: Updating account level strategy uwq summary ************');
1376: END IF;
1377: update iex_dln_uwq_summary
1378: set work_item_id = l_work_item_id,
1379: schedule_start = l_schedule_start,

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

1394: where cust_account_id = l_jtf_object_id;
1395:
1396: ELSIF l_jtf_object_type = 'IEX_BILLTO' THEN
1397: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1398: iex_debug_pub.logmessage ('**** IEX_STRY_UTL_PUB.REFRESH_UWQ_STR_SUMM: Updating billto level strategy uwq summary ************');
1399: END IF;
1400: update iex_dln_uwq_summary
1401: set work_item_id = l_work_item_id,
1402: schedule_start = l_schedule_start,

Line 1757: END IEX_STRY_UTL_PUB ;

1753: iex_debug_pub.logmessage (' Exception update_wf_attributes '|| sqlerrm);
1754: END update_wf_attributes;
1755:
1756:
1757: END IEX_STRY_UTL_PUB ;
1758:
1759: