DBA Data[Home] [Help]

APPS.CS_WF_ACTIVITIES_PKG dependencies on CS_WF_ACTIVITIES_PKG

Line 1: PACKAGE BODY CS_WF_ACTIVITIES_PKG AS

1: PACKAGE BODY CS_WF_ACTIVITIES_PKG AS
2: /* $Header: cswfactb.pls 120.3.12020000.2 2012/07/05 05:40:45 gasankar ship $ */
3:
4:
5: -- ***************************************************************************

Line 40: --CS_WF_Activities_PKG.FS_Planned_Status , 1 ,

36: sr.resolution_code_description sr_resolution_description,
37: sr.incident_urgency_id,
38: sr.urgency,
39: -- decode( st.status_code ,
40: --CS_WF_Activities_PKG.FS_Planned_Status , 1 ,
41: --CS_WF_Activities_PKG.FS_Cancelled_Status , 2 )
42: sr.incident_status_id,
43: --decode( st.status_code ,
44: --CS_WF_Activities_PKG.FS_Planned_Status , 'Planned' ,

Line 41: --CS_WF_Activities_PKG.FS_Cancelled_Status , 2 )

37: sr.incident_urgency_id,
38: sr.urgency,
39: -- decode( st.status_code ,
40: --CS_WF_Activities_PKG.FS_Planned_Status , 1 ,
41: --CS_WF_Activities_PKG.FS_Cancelled_Status , 2 )
42: sr.incident_status_id,
43: --decode( st.status_code ,
44: --CS_WF_Activities_PKG.FS_Planned_Status , 'Planned' ,
45: --CS_WF_Activities_PKG.FS_Cancelled_Status , 'Cancelled' )

Line 44: --CS_WF_Activities_PKG.FS_Planned_Status , 'Planned' ,

40: --CS_WF_Activities_PKG.FS_Planned_Status , 1 ,
41: --CS_WF_Activities_PKG.FS_Cancelled_Status , 2 )
42: sr.incident_status_id,
43: --decode( st.status_code ,
44: --CS_WF_Activities_PKG.FS_Planned_Status , 'Planned' ,
45: --CS_WF_Activities_PKG.FS_Cancelled_Status , 'Cancelled' )
46: st.status_code,
47: sr.incident_date status_date,
48: act.task_type_id incident_type_id,

Line 45: --CS_WF_Activities_PKG.FS_Cancelled_Status , 'Cancelled' )

41: --CS_WF_Activities_PKG.FS_Cancelled_Status , 2 )
42: sr.incident_status_id,
43: --decode( st.status_code ,
44: --CS_WF_Activities_PKG.FS_Planned_Status , 'Planned' ,
45: --CS_WF_Activities_PKG.FS_Cancelled_Status , 'Cancelled' )
46: st.status_code,
47: sr.incident_date status_date,
48: act.task_type_id incident_type_id,
49: -- act.action_type_meaning incident_type,

Line 231: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Servereq_Selector',

227: END IF;
228:
229: EXCEPTION
230: WHEN OTHERS THEN
231: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Servereq_Selector',
232: itemtype, itemkey, actid, funcmode);
233: RAISE;
234: END Servereq_Selector;
235:

Line 349: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Initialize_Request',

345: EXCEPTION
346: WHEN l_API_ERROR THEN
347: WF_CORE.Raise(l_errmsg_name);
348: WHEN OTHERS THEN
349: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Initialize_Request',
350: itemtype, itemkey, actid, funmode);
351: RAISE;
352:
353: END Initialize_Request;

Line 577: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Update_Request_Info',

573: CLOSE l_ServiceRequest_csr;
574: END IF;
575: WF_CORE.Raise(l_errmsg_name);
576: WHEN OTHERS THEN
577: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Update_Request_Info',
578: itemtype, itemkey, actid, funmode);
579: RAISE;
580:
581: END Update_Request_Info;

Line 741: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Select_Supervisor',

737: EXCEPTION
738: WHEN l_API_ERROR THEN
739: WF_CORE.Raise(l_errmsg_name);
740: WHEN OTHERS THEN
741: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Select_Supervisor',
742: itemtype, itemkey, actid, funmode);
743: RAISE;
744:
745: END Select_Supervisor;

Line 951: p_audit_comments => CS_WF_ACTIVITIES_PKG.Audit_Comments,

947: p_resp_appl_id => l_resp_appl_id,
948: p_owner_id => l_resource_id,
949: p_owner_group_id => l_owner_group_id,
950: p_resource_type => l_resource_type,
951: p_audit_comments => CS_WF_ACTIVITIES_PKG.Audit_Comments,
952: p_called_by_workflow => FND_API.G_TRUE,
953: p_workflow_process_id => l_wf_process_id,
954: x_interaction_id => l_dummy_id );
955:

Line 1032: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Update_Owner',

1028: EXCEPTION
1029: WHEN l_API_ERROR THEN
1030: WF_CORE.Raise(l_errmsg_name);
1031: WHEN OTHERS THEN
1032: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Update_Owner',
1033: itemtype, itemkey, actid, funmode);
1034: RAISE;
1035:
1036: END Update_Owner;

Line 1084: l_api_name CONSTANT VARCHAR2(60) := 'CS_WF_ACTIVITIES_PKG.Update_status';

1080: l_notes CS_SERVICEREQUEST_PVT.notes_table;
1081: l_contacts CS_SERVICEREQUEST_PVT.contacts_table;
1082: out_interaction_id number;
1083: out_wf_process_id number;
1084: l_api_name CONSTANT VARCHAR2(60) := 'CS_WF_ACTIVITIES_PKG.Update_status';
1085: l_msg_index_out number;
1086:
1087: l_resp_id NUMBER;
1088: l_resp_appl_id NUMBER;

Line 1248: p_audit_comments => CS_WF_ACTIVITIES_PKG.Audit_Comments,

1244: p_request_number => l_request_number,
1245: p_object_version_number => l_object_version_number,
1246: p_status_id => l_new_status_id,
1247: p_closed_date => sysdate,
1248: p_audit_comments => CS_WF_ACTIVITIES_PKG.Audit_Comments,
1249: p_called_by_workflow => FND_API.G_TRUE,
1250: p_workflow_process_id => l_wf_process_id,
1251: x_interaction_id => l_dummy_id );
1252:

Line 1415: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Update_Status',

1411: */
1412: WHEN l_API_ERROR THEN
1413: WF_CORE.Raise(l_errmsg_name);
1414: WHEN OTHERS THEN
1415: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Update_Status',
1416: itemtype, itemkey, actid, funmode);
1417: RAISE;
1418:
1419: END Update_Status;

Line 1459: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Validate_Response_Deadline',

1455: END IF;
1456:
1457: EXCEPTION
1458: WHEN OTHERS THEN
1459: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Validate_Response_Deadline',
1460: itemtype, itemkey, actid, funmode);
1461: RAISE;
1462:
1463: END Validate_Response_Deadline;

Line 1494: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Reset_Response_Deadline',

1490: END IF;
1491:
1492: EXCEPTION
1493: WHEN OTHERS THEN
1494: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Reset_Response_Deadline',
1495: itemtype, itemkey, actid, funmode);
1496: RAISE;
1497:
1498: END Reset_Response_Deadline;

Line 1599: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Initialize_Errors',

1595: END IF;
1596:
1597: EXCEPTION
1598: WHEN OTHERS THEN
1599: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Initialize_Errors',
1600: itemtype, itemkey, actid, funmode);
1601: RAISE;
1602: END Initialize_Errors;
1603:

Line 1667: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Action_Selector',

1663: END IF;
1664:
1665: EXCEPTION
1666: WHEN OTHERS THEN
1667: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Action_Selector',
1668: itemtype, itemkey, actid, funcmode);
1669: RAISE;
1670: END Action_Selector;
1671:

Line 1914: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Initialize_Action',

1910: EXCEPTION
1911: WHEN l_exc_api_error THEN
1912: WF_CORE.Raise(l_errmsg_name);
1913: WHEN OTHERS THEN
1914: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Initialize_Action',
1915: itemtype, itemkey, actid, funcmode);
1916: RAISE;
1917: END Initialize_Action;*/
1918:

Line 1954: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Is_Launched_From_Dispatch',

1950: END IF;
1951:
1952: EXCEPTION
1953: WHEN OTHERS THEN
1954: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Is_Launched_From_Dispatch',
1955: itemtype, itemkey, actid, funcmode);
1956: RAISE;
1957: END Is_Launched_From_Dispatch;
1958:

Line 2064: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Get_Dispatcher_Info',

2060: EXCEPTION
2061: WHEN l_exc_invalid_role THEN
2062: WF_CORE.Raise(l_errmsg_name);
2063: WHEN OTHERS THEN
2064: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'Get_Dispatcher_Info',
2065: itemtype, itemkey, actid, funcmode);
2066: RAISE;
2067: END Get_Dispatcher_Info;*/
2068:

Line 2101: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'IS_MOBILE_INSTALLED',

2097: END IF;
2098:
2099: EXCEPTION
2100: WHEN OTHERS THEN
2101: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'IS_MOBILE_INSTALLED',
2102: itemtype, itemkey, actid, funcmode);
2103: RAISE;
2104: END IS_MOBILE_INSTALLED;
2105:

Line 2158: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'IS_ACTION_CLOSED',

2154: IF l_stat_cur%ISOPEN THEN
2155: CLOSE l_stat_cur;
2156: END IF;
2157:
2158: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'IS_ACTION_CLOSED',
2159: itemtype, itemkey, actid, funcmode);
2160: RAISE;
2161: END IS_ACTION_CLOSED;*/
2162:

Line 2192: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'IS_FS_INSERT',

2188: result := 'COMPLETE';
2189: END IF;
2190: EXCEPTION
2191: WHEN OTHERS THEN
2192: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'IS_FS_INSERT',
2193: itemtype, itemkey, actid, funcmode);
2194: RAISE;
2195: END IS_FS_INSERT;
2196:

Line 2231: pkg_name => 'CS_WF_ACTIVITIES_PKG',

2227: FETCH fs_action_csr into action_rec;
2228:
2229: IF fs_action_csr%NOTFOUND THEN
2230: wf_core.context(
2231: pkg_name => 'CS_WF_ACTIVITIES_PKG',
2232: proc_name => 'INSERT_FS_INTERFACE',
2233: arg1 => 'p_itemkey=>'||itemkey );
2234: l_errmsg_name := 'CS_WF_SR_ACTION_NOT_FOUND';
2235: RAISE ACTION_NOT_FOUND;

Line 2426: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'INSERT_FS_INTERFACE',

2422: IF fs_action_csr%ISOPEN THEN
2423: CLOSE fs_action_csr;
2424: END IF;
2425: WHEN OTHERS THEN
2426: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'INSERT_FS_INTERFACE',
2427: itemtype, itemkey, actid, funcmode);
2428: IF fs_action_csr%ISOPEN THEN
2429: CLOSE fs_action_csr;
2430: END IF;

Line 2466: pkg_name => 'CS_WF_ACTIVITIES_PKG',

2462: FETCH fs_action_csr into action_rec;
2463:
2464: IF fs_action_csr%NOTFOUND THEN
2465: wf_core.context(
2466: pkg_name => 'CS_WF_ACTIVITIES_PKG',
2467: proc_name => 'UPDATE_FS_INTERFACE',
2468: arg1 => 'p_itemkey=>'||itemkey );
2469: l_errmsg_name := 'CS_WF_SR_ACTION_NOT_FOUND';
2470: RAISE ACTION_NOT_FOUND;

Line 2549: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'UPDATE_FS_INTERFACE',

2545: IF fs_action_csr%ISOPEN THEN
2546: CLOSE fs_action_csr;
2547: END IF;
2548: WHEN OTHERS THEN
2549: WF_CORE.Context('CS_WF_ACTIVITIES_PKG', 'UPDATE_FS_INTERFACE',
2550: itemtype, itemkey, actid, funcmode);
2551: IF fs_action_csr%ISOPEN THEN
2552: CLOSE fs_action_csr;
2553: END IF;

Line 2634: CS_WF_ACTIVITIES_PKG.Audit_Comments := FND_MESSAGE.Get;

2630: -- We need to get the audit comments from the message dictionary
2631: -- due to translation issues
2632: --
2633: FND_MESSAGE.Set_Name('CS', 'CS_WF_AUDIT_COMMENTS');
2634: CS_WF_ACTIVITIES_PKG.Audit_Comments := FND_MESSAGE.Get;
2635:
2636: END CS_WF_ACTIVITIES_PKG;

Line 2636: END CS_WF_ACTIVITIES_PKG;

2632: --
2633: FND_MESSAGE.Set_Name('CS', 'CS_WF_AUDIT_COMMENTS');
2634: CS_WF_ACTIVITIES_PKG.Audit_Comments := FND_MESSAGE.Get;
2635:
2636: END CS_WF_ACTIVITIES_PKG;