180: -- rmunjulu added oracle.apps.okl.cs.transferandassumption for bug 11717591
181: if p_event_name in ( 'oracle.apps.okl.am.preproceeds',
182: 'oracle.apps.okl.am.postproceeds',
183: 'oracle.apps.okl.cs.transferandassumption') then
184: wf_event.AddParameterToList('USER_ID',Fnd_Global.User_Id,l_parameter_list);
185: wf_event.AddParameterToList('RESPONSIBILITY_ID',Fnd_Global.Resp_Id,l_parameter_list);
186: wf_event.AddParameterToList('APPL_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);
187:
188: IF (is_debug_procedure_on) THEN
181: if p_event_name in ( 'oracle.apps.okl.am.preproceeds',
182: 'oracle.apps.okl.am.postproceeds',
183: 'oracle.apps.okl.cs.transferandassumption') then
184: wf_event.AddParameterToList('USER_ID',Fnd_Global.User_Id,l_parameter_list);
185: wf_event.AddParameterToList('RESPONSIBILITY_ID',Fnd_Global.Resp_Id,l_parameter_list);
186: wf_event.AddParameterToList('APPL_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);
187:
188: IF (is_debug_procedure_on) THEN
189: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : USER_ID '||Fnd_Global.User_Id);
182: 'oracle.apps.okl.am.postproceeds',
183: 'oracle.apps.okl.cs.transferandassumption') then
184: wf_event.AddParameterToList('USER_ID',Fnd_Global.User_Id,l_parameter_list);
185: wf_event.AddParameterToList('RESPONSIBILITY_ID',Fnd_Global.Resp_Id,l_parameter_list);
186: wf_event.AddParameterToList('APPL_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);
187:
188: IF (is_debug_procedure_on) THEN
189: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : USER_ID '||Fnd_Global.User_Id);
190: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : RESPONSIBILITY_ID '||Fnd_Global.Resp_Id);
185: wf_event.AddParameterToList('RESPONSIBILITY_ID',Fnd_Global.Resp_Id,l_parameter_list);
186: wf_event.AddParameterToList('APPL_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);
187:
188: IF (is_debug_procedure_on) THEN
189: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : USER_ID '||Fnd_Global.User_Id);
190: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : RESPONSIBILITY_ID '||Fnd_Global.Resp_Id);
191: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : APPLICATION_ID '||fnd_Global.Resp_Appl_Id);
192: END IF;
193: end if;
186: wf_event.AddParameterToList('APPL_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);
187:
188: IF (is_debug_procedure_on) THEN
189: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : USER_ID '||Fnd_Global.User_Id);
190: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : RESPONSIBILITY_ID '||Fnd_Global.Resp_Id);
191: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : APPLICATION_ID '||fnd_Global.Resp_Appl_Id);
192: END IF;
193: end if;
194:
187:
188: IF (is_debug_procedure_on) THEN
189: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : USER_ID '||Fnd_Global.User_Id);
190: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : RESPONSIBILITY_ID '||Fnd_Global.Resp_Id);
191: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : APPLICATION_ID '||fnd_Global.Resp_Appl_Id);
192: END IF;
193: end if;
194:
195: --vsgandhi
194:
195: --vsgandhi
196: if p_event_name in ( 'oracle.apps.okl.am.sendquote' ,
197: 'oracle.apps.okl.am.submitquoteforapproval') then
198: wf_event.AddParameterToList('USER_ID',Fnd_Global.User_Id,l_parameter_list);
199: wf_event.AddParameterToList('RESPONSIBILITY_ID',Fnd_Global.Resp_Id,l_parameter_list);
200: wf_event.AddParameterToList('APPLICATION_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);
201:
202: IF (is_debug_procedure_on) THEN
195: --vsgandhi
196: if p_event_name in ( 'oracle.apps.okl.am.sendquote' ,
197: 'oracle.apps.okl.am.submitquoteforapproval') then
198: wf_event.AddParameterToList('USER_ID',Fnd_Global.User_Id,l_parameter_list);
199: wf_event.AddParameterToList('RESPONSIBILITY_ID',Fnd_Global.Resp_Id,l_parameter_list);
200: wf_event.AddParameterToList('APPLICATION_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);
201:
202: IF (is_debug_procedure_on) THEN
203: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,' USER_ID
196: if p_event_name in ( 'oracle.apps.okl.am.sendquote' ,
197: 'oracle.apps.okl.am.submitquoteforapproval') then
198: wf_event.AddParameterToList('USER_ID',Fnd_Global.User_Id,l_parameter_list);
199: wf_event.AddParameterToList('RESPONSIBILITY_ID',Fnd_Global.Resp_Id,l_parameter_list);
200: wf_event.AddParameterToList('APPLICATION_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);
201:
202: IF (is_debug_procedure_on) THEN
203: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,' USER_ID
204: '||Fnd_Global.User_Id);
200: wf_event.AddParameterToList('APPLICATION_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);
201:
202: IF (is_debug_procedure_on) THEN
203: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,' USER_ID
204: '||Fnd_Global.User_Id);
205: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'
206: RESPONSIBILITY_ID '||Fnd_Global.Resp_Id);
207: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'
208: APPLICATION_ID '||fnd_Global.Resp_Appl_Id);
202: IF (is_debug_procedure_on) THEN
203: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,' USER_ID
204: '||Fnd_Global.User_Id);
205: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'
206: RESPONSIBILITY_ID '||Fnd_Global.Resp_Id);
207: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'
208: APPLICATION_ID '||fnd_Global.Resp_Appl_Id);
209: END IF;
210: end if;
204: '||Fnd_Global.User_Id);
205: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'
206: RESPONSIBILITY_ID '||Fnd_Global.Resp_Id);
207: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'
208: APPLICATION_ID '||fnd_Global.Resp_Appl_Id);
209: END IF;
210: end if;
211: -- 20-OCT-10 sechawla 10194171 : end
212:
1889: l_user_id:= wf_engine.GetItemAttrNumber(itemtype,
1890: itemkey,
1891: 'USER_ID');
1892: -- Get the current user
1893: current_user_id:= FND_GLOBAL.USER_ID;
1894: -- Get the responsibility at which the above user intiated the workflow
1895: l_resp_id:= wf_engine.GetItemAttrNumber(itemtype,
1896: itemkey,
1897: 'RESPONSIBILITY_ID');
1895: l_resp_id:= wf_engine.GetItemAttrNumber(itemtype,
1896: itemkey,
1897: 'RESPONSIBILITY_ID');
1898: -- Get the current responsibility
1899: current_resp_id:= FND_GLOBAL.RESP_ID;
1900: -- Get the application where the above user intiated the workflow
1901:
1902: l_appl_id:= wf_engine.GetItemAttrNumber(itemtype,
1903: itemkey,
1902: l_appl_id:= wf_engine.GetItemAttrNumber(itemtype,
1903: itemkey,
1904: 'APPL_ID');
1905: -- Get the current application
1906: current_appl_id:= FND_GLOBAL.RESP_APPL_ID;
1907: END IF;
1908: --sechawla 30-oct-10 10194171 : end
1909:
1910: -- rmunjulu 11717591 added OKLCSTRQ start
1913: l_user_id:= wf_engine.GetItemAttrNumber(itemtype,
1914: itemkey,
1915: 'USER_ID');
1916: -- Get the current user
1917: current_user_id:= FND_GLOBAL.USER_ID;
1918: -- Get the responsibility at which the above user intiated the workflow
1919: l_resp_id:= wf_engine.GetItemAttrNumber(itemtype,
1920: itemkey,
1921: 'RESPONSIBILITY_ID');
1919: l_resp_id:= wf_engine.GetItemAttrNumber(itemtype,
1920: itemkey,
1921: 'RESPONSIBILITY_ID');
1922: -- Get the current responsibility
1923: current_resp_id:= FND_GLOBAL.RESP_ID;
1924: -- Get the application where the above user intiated the workflow
1925:
1926: l_appl_id:= wf_engine.GetItemAttrNumber(itemtype,
1927: itemkey,
1926: l_appl_id:= wf_engine.GetItemAttrNumber(itemtype,
1927: itemkey,
1928: 'APPL_ID');
1929: -- Get the current application
1930: current_appl_id:= FND_GLOBAL.RESP_APPL_ID;
1931: END IF;
1932: -- rmunjulu 11717591 added OKLCSTRQ end
1933:
1934:
1938: l_user_id:= wf_engine.GetItemAttrNumber(itemtype,
1939: itemkey,
1940: 'USER_ID');
1941: -- Get the current user
1942: current_user_id:= FND_GLOBAL.USER_ID;
1943: -- Get the responsibility at which the above user intiated the workflow
1944: l_resp_id:= wf_engine.GetItemAttrNumber(itemtype,
1945: itemkey,
1946: 'RESPONSIBILITY_ID');
1944: l_resp_id:= wf_engine.GetItemAttrNumber(itemtype,
1945: itemkey,
1946: 'RESPONSIBILITY_ID');
1947: -- Get the current responsibility
1948: current_resp_id:= FND_GLOBAL.RESP_ID;
1949: -- Get the application where the above user intiated the workflow
1950: l_appl_id:= wf_engine.GetItemAttrNumber(itemtype,
1951: itemkey,
1952: 'APPLICATION_ID');
1950: l_appl_id:= wf_engine.GetItemAttrNumber(itemtype,
1951: itemkey,
1952: 'APPLICATION_ID');
1953: -- Get the current application
1954: current_appl_id:= FND_GLOBAL.RESP_APPL_ID;
1955: END IF;
1956:
1957:
1958: IF (itemtype = 'OKLAMNQT') THEN
1961: l_user_id:= wf_engine.GetItemAttrNumber(itemtype,
1962: itemkey,
1963: 'USER_ID');
1964: -- Get the current user
1965: current_user_id:= FND_GLOBAL.USER_ID;
1966: -- Get the responsibility at which the above user intiated the workflow
1967: l_resp_id:= wf_engine.GetItemAttrNumber(itemtype,
1968: itemkey,
1969: 'RESPONSIBILITY_ID');
1967: l_resp_id:= wf_engine.GetItemAttrNumber(itemtype,
1968: itemkey,
1969: 'RESPONSIBILITY_ID');
1970: -- Get the current responsibility
1971: current_resp_id:= FND_GLOBAL.RESP_ID;
1972: -- Get the application where the above user intiated the workflow
1973: l_appl_id:= wf_engine.GetItemAttrNumber(itemtype,
1974: itemkey,
1975: 'APPLICATION_ID');
1973: l_appl_id:= wf_engine.GetItemAttrNumber(itemtype,
1974: itemkey,
1975: 'APPLICATION_ID');
1976: -- Get the current application
1977: current_appl_id:= FND_GLOBAL.RESP_APPL_ID;
1978: END IF;
1979:
1980:
1981: -- Start of code added as part of Bug:15933691 venkatho
1985: l_user_id:= wf_engine.GetItemAttrNumber(itemtype,
1986: itemkey,
1987: 'USER_ID');
1988: -- Get the current user
1989: current_user_id:= FND_GLOBAL.USER_ID;
1990: -- Get the responsibility at which the above user intiated the workflow
1991: l_resp_id:= wf_engine.GetItemAttrNumber(itemtype,
1992: itemkey,
1993: 'RESPONSIBILITY_ID');
1991: l_resp_id:= wf_engine.GetItemAttrNumber(itemtype,
1992: itemkey,
1993: 'RESPONSIBILITY_ID');
1994: -- Get the current responsibility
1995: current_resp_id:= FND_GLOBAL.RESP_ID;
1996: -- Get the application where the above user intiated the workflow
1997: l_appl_id:= wf_engine.GetItemAttrNumber(itemtype,
1998: itemkey,
1999: 'APPLICATION_ID');
1997: l_appl_id:= wf_engine.GetItemAttrNumber(itemtype,
1998: itemkey,
1999: 'APPLICATION_ID');
2000: -- Get the current application
2001: current_appl_id:= FND_GLOBAL.RESP_APPL_ID;
2002: END IF;
2003: -- End of code added as part of Bug:15933691 venkatho
2004:
2005:
2032: IF (is_debug_procedure_on) THEN
2033: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'set ctx : going to initailaize ctx.. '||l_user_id||':'||l_resp_id||':'||l_appl_id);
2034: end if;
2035:
2036: FND_GLOBAL.APPS_initialize(l_user_id,l_resp_id,l_appl_id);
2037: END IF;
2038: mo_global.init('OKL');
2039: MO_GLOBAL.set_policy_context('S',l_org_id);
2040: resultout :='COMPLETE';
2149: l_user_id:= wf_engine.GetItemAttrNumber(itemtype,
2150: itemkey,
2151: 'USER_ID');
2152: -- Get the current user
2153: current_user_id:= FND_GLOBAL.USER_ID;
2154:
2155: -- Get the responsibility at which the above user intiated the workflow
2156: l_resp_id:= wf_engine.GetItemAttrNumber(itemtype,
2157: itemkey,
2156: l_resp_id:= wf_engine.GetItemAttrNumber(itemtype,
2157: itemkey,
2158: 'RESPONSIBILITY_ID');
2159: -- Get the current responsibility
2160: current_resp_id:= FND_GLOBAL.RESP_ID;
2161:
2162: -- Get the application where the above user intiated the workflow
2163: l_appl_id:= wf_engine.GetItemAttrNumber(itemtype,
2164: itemkey,
2163: l_appl_id:= wf_engine.GetItemAttrNumber(itemtype,
2164: itemkey,
2165: 'APPLICATION_ID');
2166: -- Get the current application
2167: current_appl_id:= FND_GLOBAL.RESP_APPL_ID;
2168:
2169: IF (command ='SET_CTX') THEN
2170: -- Set the application user context back to the original one
2171: FND_GLOBAL.APPS_initialize(l_user_id,l_resp_id,l_appl_id);
2167: current_appl_id:= FND_GLOBAL.RESP_APPL_ID;
2168:
2169: IF (command ='SET_CTX') THEN
2170: -- Set the application user context back to the original one
2171: FND_GLOBAL.APPS_initialize(l_user_id,l_resp_id,l_appl_id);
2172: -- Set the Org
2173: dbms_application_info.set_client_info(l_org_id);
2174: resultout :='COMPLETE';
2175: END IF;