DBA Data[Home] [Help]

APPS.IEX_STRY_API_PUB dependencies on WF_ENGINE

Line 692: wf_engine.ItemStatus( itemtype => 'IEXSTRY',

688: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
689: IEX_DEBUG_PUB.logmessage('Begin IEX_STRY_API_PUB.CHECK_STRATEGY_WORKFLOW' );
690: END IF;
691: --check status of the workflow
692: wf_engine.ItemStatus( itemtype => 'IEXSTRY',
693: itemkey => p_strategy,
694: status => l_return_status,
695: result => l_result);
696: x_wf_Status :=l_return_status;

Line 706: wf_engine.ItemInfo(itemtype =>'IEXSTRY',

702: --begin bug#13842980 schekuri 14-Mar-2012
703: /*OPEN c_get_Wf_error (l_strategy);
704: FETCH c_get_Wf_error INTO l_wf_error;
705: CLOSE c_get_wf_error;*/
706: wf_engine.ItemInfo(itemtype =>'IEXSTRY',
707: itemkey => l_strategy,
708: status =>l_status,
709: result =>l_result,
710: actid =>l_actid,

Line 720: if l_return_status = wf_engine.eng_error THEN

716: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
717: IEX_DEBUG_PUB.logmessage('CHECK_STRATEGY_WORKFLOW: ' || 'wf error is ' ||l_wf_error);
718: END IF;
719:
720: if l_return_status = wf_engine.eng_error THEN
721: -- work flow is in error
722: --get the error message from the error_message attribute
723: x_return_message :=wf_engine.GetItemAttrText(itemtype => 'IEXSTRY',
724: itemkey => p_strategy,

Line 723: x_return_message :=wf_engine.GetItemAttrText(itemtype => 'IEXSTRY',

719:
720: if l_return_status = wf_engine.eng_error THEN
721: -- work flow is in error
722: --get the error message from the error_message attribute
723: x_return_message :=wf_engine.GetItemAttrText(itemtype => 'IEXSTRY',
724: itemkey => p_strategy,
725: aname => 'ERROR_MESSAGE');
726: x_return_status := 'E';
727:

Line 735: elsif l_return_status =wf_engine.eng_active THEN

731: IEX_DEBUG_PUB.logmessage('CHECK_STRATEGY_WORKFLOW: ' || 'Work flow is in error for strategy Id'
732: ||p_strategy || 'error is ' ||x_return_message);
733: END IF;
734:
735: elsif l_return_status =wf_engine.eng_active THEN
736: -- work flow is active
737: -- and is in error if the activity name is not populated
738: -- the activity name gets populated for optional and escalation work items
739: -- if it is in error then get the error message from the error_message attribute

Line 745: l_activity_name :=wf_engine.GetItemAttrText(itemtype => 'IEXSTRY',

741: --could be due to many reason. these profiles might not be set
742: --IEX_STRY_MEATAPHOR_CREATION -- for uwq creation
743: --IEX_STRY_DEFAULT_RESOURCE --
744:
745: l_activity_name :=wf_engine.GetItemAttrText(itemtype => 'IEXSTRY',
746: itemkey => p_strategy,
747: aname => 'ACTIVITY_NAME');
748: If l_activity_name is null then
749: -- IF PG_DEBUG < 10 THEN

Line 753: x_return_message :=wf_engine.GetItemAttrText(itemtype => 'IEXSTRY',

749: -- IF PG_DEBUG < 10 THEN
750: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
751: IEX_DEBUG_PUB.logmessage('CHECK_STRATEGY_WORKFLOW: ' || 'l_activity_name is null ' );
752: END IF;
753: x_return_message :=wf_engine.GetItemAttrText(itemtype => 'IEXSTRY',
754: itemkey => p_strategy,
755: aname => 'ERROR_MESSAGE');
756:
757: x_return_message := x_return_message || l_wf_error;

Line 1187: l_activity_label := wf_engine.GetItemAttrText(itemtype => 'IEXSTRY',

1183: BEGIN
1184:
1185: SAVEPOINT SKIP_WAIT;
1186: l_return_status := FND_API.G_RET_STS_SUCCESS;
1187: l_activity_label := wf_engine.GetItemAttrText(itemtype => 'IEXSTRY',
1188: itemkey => p_strategy_id,
1189: aname => 'ACTIVITY_NAME');
1190:
1191: l_work_item_id := wf_engine.GetItemAttrNumber(itemtype => 'IEXSTRY',

Line 1191: l_work_item_id := wf_engine.GetItemAttrNumber(itemtype => 'IEXSTRY',

1187: l_activity_label := wf_engine.GetItemAttrText(itemtype => 'IEXSTRY',
1188: itemkey => p_strategy_id,
1189: aname => 'ACTIVITY_NAME');
1190:
1191: l_work_item_id := wf_engine.GetItemAttrNumber(itemtype => 'IEXSTRY',
1192: itemkey => p_strategy_id,
1193: aname => 'WORK_ITEMID');
1194:
1195: IF (l_activity_label = 'STRATEGY_SUBPROCESS:PRE_WAIT_PROCESS' and p_wkitem_status = 'PRE-WAIT') OR

Line 1202: wf_engine.CompleteActivity(itemtype => 'IEXSTRY',

1198: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1199: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || 'SKIP_WAIT' || ' Forcing to complete Wait Activity ' || l_activity_label);
1200: END IF;
1201:
1202: wf_engine.CompleteActivity(itemtype => 'IEXSTRY',
1203: itemkey => p_strategy_id,
1204: activity =>l_activity_label,
1205: result =>'#TIMEOUT');
1206: COMMIT WORK;