DBA Data[Home] [Help]

APPS.AS_LEAD_ASSIGN_WF dependencies on AS_LEAD_ASSIGN_WF

Line 1: package body AS_LEAD_ASSIGN_WF AS

1: package body AS_LEAD_ASSIGN_WF AS
2: /* $Header: asxlasnb.pls 115.7 2002/11/06 00:43:01 appldev ship $ */
3: --Declarations
4:
5:

Line 27: -- dbms_output.put_line('AS_LEAD_ASSIGN_WF: Startprocess Begin'||item_key);

23: -- If workflowprocess is passed, it will be run.
24: -- If workflowprocess is NOT passed, the selector FUNCTION
25: -- defined in the item type will determine which process to run.
26:
27: -- dbms_output.put_line('AS_LEAD_ASSIGN_WF: Startprocess Begin'||item_key);
28:
29: SELECT TO_CHAR(AS_WORKFLOW_KEYS_S.nextval) INTO Item_Key FROM dual;
30:
31: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,

Line 97: -- dbms_output.put_line('AS_LEAD_ASSIGN_WF: Startprocess End');

93: x_item_type := Item_Type;
94: x_item_key := Item_Key;
95: x_return_status := l_status;
96:
97: -- dbms_output.put_line('AS_LEAD_ASSIGN_WF: Startprocess End');
98: EXCEPTION
99: when others then
100: wf_core.context(Item_type, 'StartProcess', p_sales_lead_id,
101: Workflowprocess);

Line 104: -- dbms_output.put_line('Error in AS_LEAD_ASSIGN_WF: Startprocess ');

100: wf_core.context(Item_type, 'StartProcess', p_sales_lead_id,
101: Workflowprocess);
102: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_ERROR,
103: 'error in StartProcess');
104: -- dbms_output.put_line('Error in AS_LEAD_ASSIGN_WF: Startprocess ');
105: raise;
106: END StartProcess;
107:
108:

Line 120: -- dbms_output.put_line('AS_LEAD_ASSIGN_WF: CheckAssignID begin');

116: l_resource_id NUMBER;
117:
118: BEGIN
119:
120: -- dbms_output.put_line('AS_LEAD_ASSIGN_WF: CheckAssignID begin');
121: l_resource_id := wf_engine.GetItemAttrNumber(
122: itemtype => itemtype,
123: itemkey => itemkey,
124: aname => 'ASSIGN_ID' );

Line 133: -- dbms_output.put_line('AS_LEAD_ASSIGN_WF: CheckAssignID end - '||result);

129: else
130: result := 'COMPLETE:N';
131: end if ;
132:
133: -- dbms_output.put_line('AS_LEAD_ASSIGN_WF: CheckAssignID end - '||result);
134: EXCEPTION
135: when others then
136: wf_core.context(Itemtype, 'CheckAssignID', itemtype, itemkey,
137: to_char(actid), funcmode);

Line 177: -- dbms_output.put_line('AS_LEAD_ASSIGN_WF: AssignLead begin '||itemkey);

173: BEGIN
174: -- AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
175: -- 'AssignLead '||itemkey);
176: IF funcmode = 'RUN' then
177: -- dbms_output.put_line('AS_LEAD_ASSIGN_WF: AssignLead begin '||itemkey);
178: l_sales_lead_id := wf_engine.GetItemAttrNumber(
179: itemtype => itemtype,
180: itemkey => itemkey,
181: aname => 'SALES_LEAD_ID' );

Line 231: -- dbms_output.put_line('AS_LEAD_ASSIGN_WF: AssignLead end');

227: result := 'COMPLETE:ERROR';
228: end if;
229: end if;
230:
231: -- dbms_output.put_line('AS_LEAD_ASSIGN_WF: AssignLead end');
232: EXCEPTION
233: when others then
234: wf_core.context(Itemtype, 'AssignLead', itemtype, itemkey,
235: to_char(actid), funcmode);

Line 257: -- dbms_output.put_line('AS_LEAD_ASSIGN_WF: GetAcceptTime begin'||itemkey);

253:
254: BEGIN
255: -- dbms_output.put_line ('GetAcceptTime '||itemkey);
256: IF funcmode = 'RUN' THEN
257: -- dbms_output.put_line('AS_LEAD_ASSIGN_WF: GetAcceptTime begin'||itemkey);
258: l_acceptdays := fnd_profile.value('AS_AGING_DAYS_NOACT');
259:
260: -- dbms_output.put_line ('Time to Wait: '||l_acceptdays);
261:

Line 269: -- dbms_output.put_line('AS_LEAD_ASSIGN_WF: GetAcceptTime end');

265: avalue => l_acceptdays);
266: result := 'COMPLETE:';
267: END IF;
268:
269: -- dbms_output.put_line('AS_LEAD_ASSIGN_WF: GetAcceptTime end');
270: EXCEPTION
271: when others then
272: wf_core.context(Itemtype, 'GetAcceptTime', itemtype, itemkey,
273: to_char(actid), funcmode);

Line 297: -- dbms_output.put_line('AS_LEAD_ASSIGN_WF: CheckAccepted begin'||itemkey);

293:
294: BEGIN
295: -- dbms_output.put_line ('CheckAccepted '||itemkey);
296: IF funcmode = 'RUN' then
297: -- dbms_output.put_line('AS_LEAD_ASSIGN_WF: CheckAccepted begin'||itemkey);
298: l_sales_lead_id := wf_engine.GetItemAttrNumber(
299: itemtype => itemtype,
300: itemkey => itemkey,
301: aname => 'SALES_LEAD_ID' );

Line 314: -- dbms_output.put_line('AS_LEAD_ASSIGN_WF: CheckAccepted end');

310: result := 'COMPLETE:N';
311: END IF;
312: END IF;
313:
314: -- dbms_output.put_line('AS_LEAD_ASSIGN_WF: CheckAccepted end');
315: EXCEPTION
316: when others then
317: wf_core.context(Itemtype, 'CheckAccepted', itemtype, itemkey,
318: to_char(actid), funcmode);

Line 337: --dbms_output.put_line('AS_LEAD_ASSIGN_WF: CheckforAbandon begin'||itemkey);

333:
334: BEGIN
335: -- dbms_output.put_line ('CheckforAbandon '||itemkey);
336: IF funcmode = 'RUN' THEN
337: --dbms_output.put_line('AS_LEAD_ASSIGN_WF: CheckforAbandon begin'||itemkey);
338: l_action := fnd_profile.value('AS_AGING_NOACT_ACTIONS');
339: IF UPPER(l_action) = 'ABANDON' THEN
340: result := 'COMPLETE:Y';
341: ELSE

Line 346: -- dbms_output.put_line('AS_LEAD_ASSIGN_WF: CheckforAbandon end');

342: result := 'COMPLETE:N';
343: END IF;
344: END IF ;
345:
346: -- dbms_output.put_line('AS_LEAD_ASSIGN_WF: CheckforAbandon end');
347: EXCEPTION
348: when others then
349: wf_core.context(Itemtype, 'CheckforAbandon', itemtype, itemkey,
350: to_char(actid), funcmode);

Line 356: END AS_LEAD_ASSIGN_WF ;

352:
353: END CheckforAbandon;
354:
355:
356: END AS_LEAD_ASSIGN_WF ;
357:
358: