[Home] [Help]
1: PACKAGE BODY JTF_EC_WORKFLOW_PKG as
2: /* $Header: jtfecwfb.pls 120.2.12010000.2 2009/01/29 12:22:13 ramchint ship $ */
3:
4: FUNCTION get_resource_name(
5: p_resource_type IN VARCHAR2,
70: p_role_name IN VARCHAR2,
71: x_return_status OUT NOCOPY VARCHAR2) is
72:
73: l_api_name VARCHAR2(30) := 'Include_Role';
74: i BINARY_INTEGER := jtf_ec_workflow_pkg.NotifList.COUNT;
75:
76: BEGIN
77:
78: -- doesn't perform a role validation
78: -- doesn't perform a role validation
79:
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81:
82: jtf_ec_workflow_pkg.NotifList(i+1).name := p_role_name;
83:
84: EXCEPTION
85: WHEN FND_API.G_EXC_ERROR THEN
86: x_return_status := FND_API.G_Ret_Sts_Error;
1227: -------------------------------------------------------------------------
1228: -- initialize the table with the performer details
1229: -------------------------------------------------------------------------
1230:
1231: JTF_EC_WORKFLOW_PKG.NotifList.Delete; -- := JTF_EC_WORKFLOW_PKG.G_Miss_NotifList;
1232:
1233: g_notif_not_sent := NULL;
1234:
1235: -------------------------------------------------------------------------
1662: -------------------------------------------------------------------------
1663: -- Set the process counters
1664: -------------------------------------------------------------------------
1665:
1666: l_counter := jtf_ec_workflow_pkg.NotifList.COUNT;
1667:
1668: wf_engine.SetItemAttrNumber(
1669: itemtype => p_wf_item_type_name,
1670: itemkey => l_itemkey,
1953: itemkey => itemkey,
1954: aname => 'LIST_COUNTER'
1955: );
1956:
1957: l_role := jtf_ec_workflow_pkg.NotifList(l_counter).Name;
1958:
1959: if l_role is not NULL then
1960:
1961: wf_engine.SetItemAttrText(
2039: l_list.DELETE;
2040: END Raise_Esc_Create_Event;
2041:
2042:
2043: PROCEDURE Raise_Esc_Update_Event(P_ESC_REC IN JTF_EC_WORKFLOW_PKG.esc_rec_type)
2044: IS
2045: l_list WF_PARAMETER_LIST_T;
2046: l_key varchar2(240);
2047: l_event_name varchar2(240) := 'oracle.apps.jtf.cac.esc.updateEscalation';
2044: IS
2045: l_list WF_PARAMETER_LIST_T;
2046: l_key varchar2(240);
2047: l_event_name varchar2(240) := 'oracle.apps.jtf.cac.esc.updateEscalation';
2048: l_esc_rec JTF_EC_WORKFLOW_PKG.esc_rec_type := p_esc_rec;
2049:
2050: BEGIN
2051: --Get the item key
2052: l_list := NULL;
2109: x_notif_not_sent =>l_notif_not_sent,
2110: X_WF_PROCESS_ID =>l_wf_process_id);
2111:
2112: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
2113: wf_core.CONTEXT('jtf_ec_workflow_pkg', 'create_esc_notif_subs', p_event.event_name, p_subscription_guid);
2114: wf_event.seterrorinfo(p_event, 'WARNING');
2115: RETURN 'WARNING';
2116: END IF;
2117:
2117:
2118: RETURN 'SUCCESS';
2119: EXCEPTION
2120: WHEN OTHERS THEN
2121: wf_core.CONTEXT('jtf_ec_workflow_pkg', 'create_esc_notif_subs', p_event.event_name, p_subscription_guid);
2122: wf_event.seterrorinfo(p_event, 'WARNING');
2123: RETURN 'WARNING';
2124: END create_esc_notif_subs;
2125:
2132: x_return_status VARCHAR2(200);
2133: x_msg_count NUMBER;
2134: x_msg_data VARCHAR2(1000);
2135:
2136: l_esc_rec JTF_EC_WORKFLOW_PKG.esc_rec_type;
2137: BEGIN
2138: l_esc_rec.task_id := wf_event.getvalueforparameter('TASK_ID', p_event.parameter_list);
2139: l_esc_rec.doc_created := wf_event.getvalueforparameter('DOC_CREATED', p_event.parameter_list);
2140: l_esc_rec.owner_changed := wf_event.getvalueforparameter('OWNER_CHANGED', p_event.parameter_list);
2170: x_notif_not_sent =>l_notif_not_sent,
2171: X_WF_PROCESS_ID =>l_wf_process_id);
2172:
2173: IF NOT(x_return_status = fnd_api.g_ret_sts_success) THEN
2174: wf_core.CONTEXT('jtf_ec_workflow_pkg', 'update_esc_notif_subs', p_event.event_name, p_subscription_guid);
2175: wf_event.seterrorinfo(p_event, 'WARNING');
2176: RETURN 'WARNING';
2177: END IF;
2178:
2178:
2179: RETURN 'SUCCESS';
2180: EXCEPTION
2181: WHEN OTHERS THEN
2182: wf_core.CONTEXT('jtf_ec_workflow_pkg', 'update_esc_notif_subs', p_event.event_name, p_subscription_guid);
2183: wf_event.seterrorinfo(p_event, 'WARNING');
2184: RETURN 'WARNING';
2185: END update_esc_notif_subs;
2186:
2185: END update_esc_notif_subs;
2186:
2187: --End of code for ER 7032664
2188:
2189: END JTF_EC_WORKFLOW_PKG;