DBA Data[Home] [Help]

APPS.OKL_AM_WF dependencies on FND_GLOBAL

Line 184: wf_event.AddParameterToList('USER_ID',Fnd_Global.User_Id,l_parameter_list);

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

Line 185: wf_event.AddParameterToList('RESPONSIBILITY_ID',Fnd_Global.Resp_Id,l_parameter_list);

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);

Line 186: wf_event.AddParameterToList('APPL_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);

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);

Line 189: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : USER_ID '||Fnd_Global.User_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;

Line 190: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : RESPONSIBILITY_ID '||Fnd_Global.Resp_Id);

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:

Line 191: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'raise BE : APPLICATION_ID '||fnd_Global.Resp_Appl_Id);

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

Line 198: wf_event.AddParameterToList('USER_ID',Fnd_Global.User_Id,l_parameter_list);

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

Line 199: wf_event.AddParameterToList('RESPONSIBILITY_ID',Fnd_Global.Resp_Id,l_parameter_list);

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

Line 200: wf_event.AddParameterToList('APPLICATION_ID',Fnd_Global.Resp_Appl_Id,l_parameter_list);

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);

Line 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);

Line 206: RESPONSIBILITY_ID '||Fnd_Global.Resp_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;

Line 208: APPLICATION_ID '||fnd_Global.Resp_Appl_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;
211: -- 20-OCT-10 sechawla 10194171 : end
212:

Line 1893: current_user_id:= FND_GLOBAL.USER_ID;

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');

Line 1899: current_resp_id:= FND_GLOBAL.RESP_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,

Line 1906: current_appl_id:= FND_GLOBAL.RESP_APPL_ID;

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

Line 1917: current_user_id:= FND_GLOBAL.USER_ID;

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');

Line 1923: current_resp_id:= FND_GLOBAL.RESP_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,

Line 1930: current_appl_id:= FND_GLOBAL.RESP_APPL_ID;

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:

Line 1942: current_user_id:= FND_GLOBAL.USER_ID;

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');

Line 1948: current_resp_id:= FND_GLOBAL.RESP_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');

Line 1954: current_appl_id:= FND_GLOBAL.RESP_APPL_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

Line 1965: current_user_id:= FND_GLOBAL.USER_ID;

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');

Line 1971: current_resp_id:= FND_GLOBAL.RESP_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');

Line 1977: current_appl_id:= FND_GLOBAL.RESP_APPL_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

Line 1989: current_user_id:= FND_GLOBAL.USER_ID;

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');

Line 1995: current_resp_id:= FND_GLOBAL.RESP_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');

Line 2001: current_appl_id:= FND_GLOBAL.RESP_APPL_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:

Line 2036: FND_GLOBAL.APPS_initialize(l_user_id,l_resp_id,l_appl_id);

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';

Line 2153: current_user_id:= FND_GLOBAL.USER_ID;

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,

Line 2160: current_resp_id:= FND_GLOBAL.RESP_ID;

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,

Line 2167: current_appl_id:= FND_GLOBAL.RESP_APPL_ID;

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);

Line 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;