16: l_entity_id NUMBER;
17: l_comment VARCHAR2(30);
18: begin
19: -- start data fix project
20: OE_STANDARD_WF.Set_Msg_Context(actid);
21: -- end data fix project
22: --
23: -- RUN mode - normal process execution
24: --
59: -- in the case of an exception.
60: wf_core.context('OE_Holds_WF', 'APPLY_HOLDS',
61: itemtype, itemkey, to_char(actid), funcmode);
62: -- start data fix project
63: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
64: p_itemtype => itemtype,
65: p_itemkey => itemkey);
66: OE_STANDARD_WF.Save_Messages;
67: OE_STANDARD_WF.Clear_Msg_Context;
62: -- start data fix project
63: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
64: p_itemtype => itemtype,
65: p_itemkey => itemkey);
66: OE_STANDARD_WF.Save_Messages;
67: OE_STANDARD_WF.Clear_Msg_Context;
68: -- end data fix project
69: raise;
70: end APPLY_HOLDS;
63: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
64: p_itemtype => itemtype,
65: p_itemkey => itemkey);
66: OE_STANDARD_WF.Save_Messages;
67: OE_STANDARD_WF.Clear_Msg_Context;
68: -- end data fix project
69: raise;
70: end APPLY_HOLDS;
71:
85: l_wf_item VARCHAR2(8);
86: l_wf_activity VARCHAR2(30);
87: begin
88: -- start data fix project
89: OE_STANDARD_WF.Set_Msg_Context(actid);
90: -- end data fix project
91: --
92: -- RUN mode - normal process execution
93: --
204: -- in the case of an exception.
205: wf_core.context('OE_Holds_WF', 'CHECK_HOLDS',
206: itemtype, itemkey, to_char(actid), funcmode);
207: -- start data fix project
208: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
209: p_itemtype => itemtype,
210: p_itemkey => itemkey);
211: OE_STANDARD_WF.Save_Messages;
212: OE_STANDARD_WF.Clear_Msg_Context;
207: -- start data fix project
208: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
209: p_itemtype => itemtype,
210: p_itemkey => itemkey);
211: OE_STANDARD_WF.Save_Messages;
212: OE_STANDARD_WF.Clear_Msg_Context;
213: -- end data fix project
214: raise;
215: end CHECK_HOLDS;
208: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
209: p_itemtype => itemtype,
210: p_itemkey => itemkey);
211: OE_STANDARD_WF.Save_Messages;
212: OE_STANDARD_WF.Clear_Msg_Context;
213: -- end data fix project
214: raise;
215: end CHECK_HOLDS;
216:
232: l_comment VARCHAR2(30);
233: l_return_status VARCHAR2(240);
234: begin
235: -- start data fix project
236: OE_STANDARD_WF.Set_Msg_Context(actid);
237: -- end data fix project
238: --
239: -- RUN mode - normal process execution
240: --
275: -- in the case of an exception.
276: wf_core.context('OE_Holds_WF', 'RELEASE_HOLDS',
277: itemtype, itemkey, to_char(actid), funcmode);
278: -- start data fix project
279: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
280: p_itemtype => itemtype,
281: p_itemkey => itemkey);
282: OE_STANDARD_WF.Save_Messages;
283: OE_STANDARD_WF.Clear_Msg_Context;
278: -- start data fix project
279: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
280: p_itemtype => itemtype,
281: p_itemkey => itemkey);
282: OE_STANDARD_WF.Save_Messages;
283: OE_STANDARD_WF.Clear_Msg_Context;
284: -- end data fix project
285: raise;
286: end RELEASE_HOLDS;
279: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => actid,
280: p_itemtype => itemtype,
281: p_itemkey => itemkey);
282: OE_STANDARD_WF.Save_Messages;
283: OE_STANDARD_WF.Clear_Msg_Context;
284: -- end data fix project
285: raise;
286: end RELEASE_HOLDS;
287: