8436: -- fnd_message.set_name('ENG','ENG_NIR_CANNOT_APPROVE');
8437: -- app_exception.raise_exception;
8438:
8439: l_message_text := fnd_message.get_String('ENG','ENG_NIR_CANNOT_APPROVE');
8440: wf_core.token('ERRCODE', l_message_text);
8441: wf_core.raise('WFENG_NOTIFICATION_FUNCTION');
8442:
8443: end if;
8444:
8437: -- app_exception.raise_exception;
8438:
8439: l_message_text := fnd_message.get_String('ENG','ENG_NIR_CANNOT_APPROVE');
8440: wf_core.token('ERRCODE', l_message_text);
8441: wf_core.raise('WFENG_NOTIFICATION_FUNCTION');
8442:
8443: end if;
8444:
8445: --9615312
8448: --13717209
8449: AND (NOT ENG_NIR_UTIL_PKG.checkSKUNIRValidForApproval(p_change_id =>l_change_id))
8450: then
8451: l_message_text := fnd_message.get_String('ENG','ENG_SKU_NIR_CANNOT_APPROVE');
8452: wf_core.token('ERRCODE', l_message_text);
8453: wf_core.raise('WFENG_NOTIFICATION_FUNCTION');
8454: end if;
8455:
8456:
8449: AND (NOT ENG_NIR_UTIL_PKG.checkSKUNIRValidForApproval(p_change_id =>l_change_id))
8450: then
8451: l_message_text := fnd_message.get_String('ENG','ENG_SKU_NIR_CANNOT_APPROVE');
8452: wf_core.token('ERRCODE', l_message_text);
8453: wf_core.raise('WFENG_NOTIFICATION_FUNCTION');
8454: end if;
8455:
8456:
8457:
8778: );
8779: END IF;
8780:
8781: -- Bug 12667853 start
8782: IF ( l_base_change_mgmt_type_code = 'NEW_ITEM_REQUEST' and wf_core.error_name = 'WFENG_NOTIFICATION_FUNCTION' )
8783: THEN
8784: raise;
8785: END IF;
8786: -- Bug 12667853 end
9724: end if;
9725:
9726: -- SYNCHMODE: Not allowed
9727: if (itemkey = wf_engine.eng_synch) then
9728: Wf_Core.Token('OPERATION', 'Wf_Standard.VotForResultType');
9729: Wf_Core.Raise('WFENG_SYNCH_DISABLED');
9730: end if;
9731:
9732: -- Always clear the cache first
9725:
9726: -- SYNCHMODE: Not allowed
9727: if (itemkey = wf_engine.eng_synch) then
9728: Wf_Core.Token('OPERATION', 'Wf_Standard.VotForResultType');
9729: Wf_Core.Raise('WFENG_SYNCH_DISABLED');
9730: end if;
9731:
9732: -- Always clear the cache first
9733: -- Bug2885157
9899: return;
9900:
9901: exception
9902: when wf_invalid_command then
9903: Wf_Core.Context('Wf_Standard', 'VoteForResultType', itemtype,
9904: itemkey, to_char(actid), funcmode);
9905: Wf_Core.Token('COMMAND', l_voting_option);
9906: Wf_Core.Raise('WFSQL_COMMAND');
9907: when others then
9901: exception
9902: when wf_invalid_command then
9903: Wf_Core.Context('Wf_Standard', 'VoteForResultType', itemtype,
9904: itemkey, to_char(actid), funcmode);
9905: Wf_Core.Token('COMMAND', l_voting_option);
9906: Wf_Core.Raise('WFSQL_COMMAND');
9907: when others then
9908: Wf_Core.Context('Wf_Standard', 'VoteForResultType',itemtype,
9909: itemkey, to_char(actid), funcmode);
9902: when wf_invalid_command then
9903: Wf_Core.Context('Wf_Standard', 'VoteForResultType', itemtype,
9904: itemkey, to_char(actid), funcmode);
9905: Wf_Core.Token('COMMAND', l_voting_option);
9906: Wf_Core.Raise('WFSQL_COMMAND');
9907: when others then
9908: Wf_Core.Context('Wf_Standard', 'VoteForResultType',itemtype,
9909: itemkey, to_char(actid), funcmode);
9910: raise;
9904: itemkey, to_char(actid), funcmode);
9905: Wf_Core.Token('COMMAND', l_voting_option);
9906: Wf_Core.Raise('WFSQL_COMMAND');
9907: when others then
9908: Wf_Core.Context('Wf_Standard', 'VoteForResultType',itemtype,
9909: itemkey, to_char(actid), funcmode);
9910: raise;
9911:
9912:
10098:
10099:
10100: exception
10101: when others then
10102: wf_core.context('Eng_Workflow_Util',
10103: 'PeopleLevelVoteCount',
10104: to_char(gid),
10105: ResultCode );
10106: raise;
10192: end if;
10193:
10194: -- SYNCHMODE: Not allowed
10195: if (itemkey = wf_engine.eng_synch) then
10196: Wf_Core.Token('OPERATION', 'Eng_Workflow_Util.PeopleLevelVoteForResultType');
10197: Wf_Core.Raise('WFENG_SYNCH_DISABLED');
10198: end if;
10199:
10200: -- Always clear the cache first
10193:
10194: -- SYNCHMODE: Not allowed
10195: if (itemkey = wf_engine.eng_synch) then
10196: Wf_Core.Token('OPERATION', 'Eng_Workflow_Util.PeopleLevelVoteForResultType');
10197: Wf_Core.Raise('WFENG_SYNCH_DISABLED');
10198: end if;
10199:
10200: -- Always clear the cache first
10201: -- Bug2885157
10418:
10419:
10420: exception
10421: when wf_invalid_command then
10422: Wf_Core.Context('Eng_Workflow_Util', 'PeopleLevelVoteForResultType', itemtype,
10423: itemkey, to_char(actid), funcmode);
10424: Wf_Core.Token('COMMAND', l_voting_option);
10425: Wf_Core.Raise('WFSQL_COMMAND');
10426: when others then
10420: exception
10421: when wf_invalid_command then
10422: Wf_Core.Context('Eng_Workflow_Util', 'PeopleLevelVoteForResultType', itemtype,
10423: itemkey, to_char(actid), funcmode);
10424: Wf_Core.Token('COMMAND', l_voting_option);
10425: Wf_Core.Raise('WFSQL_COMMAND');
10426: when others then
10427: Wf_Core.Context('Eng_Workflow_Util', 'PeopleLevelVoteForResultType',itemtype,
10428: itemkey, to_char(actid), funcmode);
10421: when wf_invalid_command then
10422: Wf_Core.Context('Eng_Workflow_Util', 'PeopleLevelVoteForResultType', itemtype,
10423: itemkey, to_char(actid), funcmode);
10424: Wf_Core.Token('COMMAND', l_voting_option);
10425: Wf_Core.Raise('WFSQL_COMMAND');
10426: when others then
10427: Wf_Core.Context('Eng_Workflow_Util', 'PeopleLevelVoteForResultType',itemtype,
10428: itemkey, to_char(actid), funcmode);
10429: raise;
10423: itemkey, to_char(actid), funcmode);
10424: Wf_Core.Token('COMMAND', l_voting_option);
10425: Wf_Core.Raise('WFSQL_COMMAND');
10426: when others then
10427: Wf_Core.Context('Eng_Workflow_Util', 'PeopleLevelVoteForResultType',itemtype,
10428: itemkey, to_char(actid), funcmode);
10429: raise;
10430:
10431:
10648: --
10649: -- If call to CompleteActivity cannot find activity, return null
10650: -- and wait for master flow
10651: --
10652: if ( wf_core.error_name = 'WFENG_NOT_NOTIFIED' ) then
10653: wf_core.clear;
10654: x_resultout := wf_engine.eng_null;
10655: IF g_debug_flag THEN
10656: Write_Debug('call to CompleteActivity cannot find activity. . . ');
10649: -- If call to CompleteActivity cannot find activity, return null
10650: -- and wait for master flow
10651: --
10652: if ( wf_core.error_name = 'WFENG_NOT_NOTIFIED' ) then
10653: wf_core.clear;
10654: x_resultout := wf_engine.eng_null;
10655: IF g_debug_flag THEN
10656: Write_Debug('call to CompleteActivity cannot find activity. . . ');
10657: END IF ;
11484: END IF ;
11485:
11486: -- Get Web Agent
11487: l_apps_web_agent := fnd_web_config.plsql_agent(help_mode => 'APPS') ;
11488: l_wf_web_agent := WF_CORE.Translate('WF_WEB_AGENT') ;
11489:
11490:
11491:
11492: IF p_url_type = Eng_Workflow_Util.G_MONITOR_ACCESSKEY
13425: Write_Debug('Transfer only supports users, new rols is invalid ');
13426: END IF ;
13427:
13428: x_return_status := FND_API.G_RET_STS_ERROR ;
13429: Wf_Core.context('Eng_Workflow_Util', 'reassignRoutePeople',
13430: p_item_type, p_item_key, p_notification_id, p_reassign_mode);
13431: Wf_Core.Token('ROLE', WF_ENGINE.context_new_role);
13432: Wf_Core.Raise('WFNTF_TRANSFER_FAIL');
13433: end;
13427:
13428: x_return_status := FND_API.G_RET_STS_ERROR ;
13429: Wf_Core.context('Eng_Workflow_Util', 'reassignRoutePeople',
13430: p_item_type, p_item_key, p_notification_id, p_reassign_mode);
13431: Wf_Core.Token('ROLE', WF_ENGINE.context_new_role);
13432: Wf_Core.Raise('WFNTF_TRANSFER_FAIL');
13433: end;
13434: -- end 14060173
13435:
13428: x_return_status := FND_API.G_RET_STS_ERROR ;
13429: Wf_Core.context('Eng_Workflow_Util', 'reassignRoutePeople',
13430: p_item_type, p_item_key, p_notification_id, p_reassign_mode);
13431: Wf_Core.Token('ROLE', WF_ENGINE.context_new_role);
13432: Wf_Core.Raise('WFNTF_TRANSFER_FAIL');
13433: end;
13434: -- end 14060173
13435:
13436: IF g_debug_flag THEN