APPS.GMI_WF_ITEM_ACTIVATION dependencies on WF_ITEM

Line 1: package body gmi_wf_item_activation as

1: package body gmi_wf_item_activation as
2: /* $Header: gmiitmwb.pls 120.1 2005/10/03 11:52:28 jsrivast noship $ */
3:
4: procedure init_wf
5: (

Line 24: wf_item_exists EXCEPTION ;

20: l_errmsg varchar2(2000);
21: l_status varchar2(2000);
22: l_errstack varchar2(32000);
23: l_result VARCHAR2 (30);
24: wf_item_exists EXCEPTION ;
25:
26: esig_active VARCHAR2(2);
27:
28: begin

Line 43: IF (wf_item.item_exist (l_itemtype, l_itemkey)) THEN

39: END IF;
40: END IF;
41:
42:
43: IF (wf_item.item_exist (l_itemtype, l_itemkey)) THEN
44: /* Check the status of the root activity */
45: wf_item_activity_status.root_status (l_itemtype, l_itemkey, l_status, l_result);
46: /* If it is not completed then abort the process */
47: IF (l_status = 'COMPLETE')THEN

Line 45: wf_item_activity_status.root_status (l_itemtype, l_itemkey, l_status, l_result);

41:
42:
43: IF (wf_item.item_exist (l_itemtype, l_itemkey)) THEN
44: /* Check the status of the root activity */
45: wf_item_activity_status.root_status (l_itemtype, l_itemkey, l_status, l_result);
46: /* If it is not completed then abort the process */
47: IF (l_status = 'COMPLETE')THEN
48: /* Purge the workflow data for workflow key */
49: wf_purge.items(itemtype=> l_itemtype, itemkey=> l_itemkey, docommit=>FALSE);

Line 54: WF_CORE.CONTEXT ('GMI_WF_ITEM_ACTIVATION', 'init_wf', l_itemtype, l_itemkey) ;

50: END IF;
51: END IF;
52: EXCEPTION
53: WHEN OTHERS THEN
54: WF_CORE.CONTEXT ('GMI_WF_ITEM_ACTIVATION', 'init_wf', l_itemtype, l_itemkey) ;
55: WF_CORE.GET_ERROR (l_errname, l_errmsg, l_errstack);
56: RAISE;
57: END;
58: BEGIN

Line 65: RAISE wf_item_exists ;

61: itemkey => l_itemkey,
62: process => l_WorkflowProcess);
63: EXCEPTION
64: WHEN DUP_VAL_ON_INDEX THEN
65: RAISE wf_item_exists ;
66: END ;
67:
68: /* get the user name from fnd_user */
69: select

Line 132: WHEN wf_item_exists THEN

128: /* the inactive_ind on the inventory item */
129: /* is set in the trigger, not here! */
130:
131: exception
132: WHEN wf_item_exists THEN
133: null;
134: when others then
135: wf_core.context ('GMI_WF_ITEM_ACTIVATION',
136: 'INIT_WF',

Line 135: wf_core.context ('GMI_WF_ITEM_ACTIVATION',

131: exception
132: WHEN wf_item_exists THEN
133: null;
134: when others then
135: wf_core.context ('GMI_WF_ITEM_ACTIVATION',
136: 'INIT_WF',
137: l_itemtype, l_itemkey,
138: p_item_id, p_item_no);
139: wf_core.get_error (l_errname, l_errmsg, l_errstack);

Line 184: IF (FND_PROFILE.DEFINED ('IC$WF_ITEM_HIERARCHY')) THEN

180: pragma exception_init(selection_timeout, -20102);
181: begin
182: if (p_funcmode = 'RUN') then
183: /* Added the code to fix bug 1102815 */
184: IF (FND_PROFILE.DEFINED ('IC$WF_ITEM_HIERARCHY')) THEN
185: l_hierarchy_flag := FND_PROFILE.VALUE ('IC$WF_ITEM_HIERARCHY');
186: IF (l_hierarchy_flag is NULL) THEN
187: p_result := 'COMPLETE:SELERR';
188: return;

Line 185: l_hierarchy_flag := FND_PROFILE.VALUE ('IC$WF_ITEM_HIERARCHY');

181: begin
182: if (p_funcmode = 'RUN') then
183: /* Added the code to fix bug 1102815 */
184: IF (FND_PROFILE.DEFINED ('IC$WF_ITEM_HIERARCHY')) THEN
185: l_hierarchy_flag := FND_PROFILE.VALUE ('IC$WF_ITEM_HIERARCHY');
186: IF (l_hierarchy_flag is NULL) THEN
187: p_result := 'COMPLETE:SELERR';
188: return;
189: END IF;

Line 388: end gmi_wf_item_activation;

384: return;
385: end activate_item;
386:
387:
388: end gmi_wf_item_activation;