DBA Data[Home] [Help]

APPS.IEX_STRY_API_PUB dependencies on WF_ENGINE

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

580: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
581: IEX_DEBUG_PUB.logmessage('Begin IEX_STRY_API_PUB.CHECK_STRATEGY_WORKFLOW' );
582: END IF;
583: --check status of the workflow
584: wf_engine.ItemStatus( itemtype => 'IEXSTRY',
585: itemkey => p_strategy,
586: status => l_return_status,
587: result => l_result);
588: x_wf_Status :=l_return_status;

Line 600: if l_return_status = wf_engine.eng_error THEN

596: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
597: IEX_DEBUG_PUB.logmessage('CHECK_STRATEGY_WORKFLOW: ' || 'wf error is ' ||l_wf_error);
598: END IF;
599:
600: if l_return_status = wf_engine.eng_error THEN
601: -- work flow is in error
602: --get the error message from the error_message attribute
603: x_return_message :=wf_engine.GetItemAttrText(itemtype => 'IEXSTRY',
604: itemkey => p_strategy,

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

599:
600: if l_return_status = wf_engine.eng_error THEN
601: -- work flow is in error
602: --get the error message from the error_message attribute
603: x_return_message :=wf_engine.GetItemAttrText(itemtype => 'IEXSTRY',
604: itemkey => p_strategy,
605: aname => 'ERROR_MESSAGE');
606: x_return_status := 'E';
607:

Line 615: elsif l_return_status =wf_engine.eng_active THEN

611: IEX_DEBUG_PUB.logmessage('CHECK_STRATEGY_WORKFLOW: ' || 'Work flow is in error for strategy Id'
612: ||p_strategy || 'error is ' ||x_return_message);
613: END IF;
614:
615: elsif l_return_status =wf_engine.eng_active THEN
616: -- work flow is active
617: -- and is in error if the activity name is not populated
618: -- the activity name gets populated for optional and escalation work items
619: -- if it is in error then get the error message from the error_message attribute

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

621: --could be due to many reason. these profiles might not be set
622: --IEX_STRY_MEATAPHOR_CREATION -- for uwq creation
623: --IEX_STRY_DEFAULT_RESOURCE --
624:
625: l_activity_name :=wf_engine.GetItemAttrText(itemtype => 'IEXSTRY',
626: itemkey => p_strategy,
627: aname => 'ACTIVITY_NAME');
628: If l_activity_name is null then
629: -- IF PG_DEBUG < 10 THEN

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

629: -- IF PG_DEBUG < 10 THEN
630: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
631: IEX_DEBUG_PUB.logmessage('CHECK_STRATEGY_WORKFLOW: ' || 'l_activity_name is null ' );
632: END IF;
633: x_return_message :=wf_engine.GetItemAttrText(itemtype => 'IEXSTRY',
634: itemkey => p_strategy,
635: aname => 'ERROR_MESSAGE');
636:
637: x_return_message := x_return_message || l_wf_error;

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

1027: BEGIN
1028:
1029: SAVEPOINT SKIP_WAIT;
1030: l_return_status := FND_API.G_RET_STS_SUCCESS;
1031: l_activity_label := wf_engine.GetItemAttrText(itemtype => 'IEXSTRY',
1032: itemkey => p_strategy_id,
1033: aname => 'ACTIVITY_NAME');
1034:
1035: l_work_item_id := wf_engine.GetItemAttrNumber(itemtype => 'IEXSTRY',

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

1031: l_activity_label := wf_engine.GetItemAttrText(itemtype => 'IEXSTRY',
1032: itemkey => p_strategy_id,
1033: aname => 'ACTIVITY_NAME');
1034:
1035: l_work_item_id := wf_engine.GetItemAttrNumber(itemtype => 'IEXSTRY',
1036: itemkey => p_strategy_id,
1037: aname => 'WORK_ITEMID');
1038:
1039: IF (l_activity_label = 'STRATEGY_SUBPROCESS:PRE_WAIT_PROCESS' and p_wkitem_status = 'PRE-WAIT') OR

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

1042: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1043: iex_debug_pub.LogMessage(G_PKG_NAME || '.' || 'SKIP_WAIT' || ' Forcing to complete Wait Activity ' || l_activity_label);
1044: END IF;
1045:
1046: wf_engine.CompleteActivity(itemtype => 'IEXSTRY',
1047: itemkey => p_strategy_id,
1048: activity =>l_activity_label,
1049: result =>'#TIMEOUT');
1050: COMMIT WORK;