10:
11: --- -------------------------------------------------------------------------
12: --- -------------setRespondedUserCtx-----------------------------------
13: --- -------------------------------------------------------------------------
14: -- This method calls the fnd_global.apps_initialize if the context user
15: -- responding to approval notification does not match fnd_global.user_name
16: -- --------------------------------------------------------------------------
17:
18: procedure setRespondedUserCtx(p_item_type in varchar2,
11: --- -------------------------------------------------------------------------
12: --- -------------setRespondedUserCtx-----------------------------------
13: --- -------------------------------------------------------------------------
14: -- This method calls the fnd_global.apps_initialize if the context user
15: -- responding to approval notification does not match fnd_global.user_name
16: -- --------------------------------------------------------------------------
17:
18: procedure setRespondedUserCtx(p_item_type in varchar2,
19: p_item_key in varchar2) is
29: if g_debug then
30: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
31: hr_utility.set_location('p_item_type:'||p_item_type,2);
32: hr_utility.set_location('p_item_key:'||p_item_key,3);
33: hr_utility.set_location('fnd_global.user_name:'||fnd_global.user_name,4);
34: hr_utility.set_location('fnd_global.user_id:'||fnd_global.user_id,5);
35: end if;
36:
37:
30: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
31: hr_utility.set_location('p_item_type:'||p_item_type,2);
32: hr_utility.set_location('p_item_key:'||p_item_key,3);
33: hr_utility.set_location('fnd_global.user_name:'||fnd_global.user_name,4);
34: hr_utility.set_location('fnd_global.user_id:'||fnd_global.user_id,5);
35: end if;
36:
37:
38: -- check if we have the context set by the Approver Notification
62: directory service,then context_user = 'email:'
63:
64:
65: Functionally we will call apps intialization only if we have valid FND user
66: and context user does not match the fnd_global.user_name
67: */
68:
69: if(contextUser is not null and substr (contextUser, 1, 6)<>'email:') then
70: -- we have valid wf role
67: */
68:
69: if(contextUser is not null and substr (contextUser, 1, 6)<>'email:') then
70: -- we have valid wf role
71: -- check if the role is same as fnd_global.user_name
72: if(contextUser<>fnd_global.user_name) then
73: if(nvl(contextProxyUser,fnd_global.user_name)<>fnd_global.user_name) then
74:
75: -- check if the role is a valid FND user
68:
69: if(contextUser is not null and substr (contextUser, 1, 6)<>'email:') then
70: -- we have valid wf role
71: -- check if the role is same as fnd_global.user_name
72: if(contextUser<>fnd_global.user_name) then
73: if(nvl(contextProxyUser,fnd_global.user_name)<>fnd_global.user_name) then
74:
75: -- check if the role is a valid FND user
76: if g_debug then
69: if(contextUser is not null and substr (contextUser, 1, 6)<>'email:') then
70: -- we have valid wf role
71: -- check if the role is same as fnd_global.user_name
72: if(contextUser<>fnd_global.user_name) then
73: if(nvl(contextProxyUser,fnd_global.user_name)<>fnd_global.user_name) then
74:
75: -- check if the role is a valid FND user
76: if g_debug then
77: hr_utility.set_location('contextUser and contextProxyUser does not match fnd_global.user_name',7);
73: if(nvl(contextProxyUser,fnd_global.user_name)<>fnd_global.user_name) then
74:
75: -- check if the role is a valid FND user
76: if g_debug then
77: hr_utility.set_location('contextUser and contextProxyUser does not match fnd_global.user_name',7);
78: end if;
79: open username;
80: fetch username into userId;
81: if username%found then
80: fetch username into userId;
81: if username%found then
82: if g_debug then
83: hr_utility.set_location('found a valid fnd user corresponding to context user',8);
84: hr_utility.set_location('calling fnd_global.apps_initialize for userId:'||userId,9);
85: end if;
86: -- call the apps intialization
87: fnd_global.apps_initialize(userId,null,null,null,null);
88: if g_debug then
83: hr_utility.set_location('found a valid fnd user corresponding to context user',8);
84: hr_utility.set_location('calling fnd_global.apps_initialize for userId:'||userId,9);
85: end if;
86: -- call the apps intialization
87: fnd_global.apps_initialize(userId,null,null,null,null);
88: if g_debug then
89: hr_utility.set_location('returned from calling fnd_global.apps_initialize for userId:'||userId,10);
90: hr_utility.set_location('fnd_global.user_name after reset:'||fnd_global.user_name,11);
91: hr_utility.set_location('fnd_global.user_id after reset:'||fnd_global.user_id,12);
85: end if;
86: -- call the apps intialization
87: fnd_global.apps_initialize(userId,null,null,null,null);
88: if g_debug then
89: hr_utility.set_location('returned from calling fnd_global.apps_initialize for userId:'||userId,10);
90: hr_utility.set_location('fnd_global.user_name after reset:'||fnd_global.user_name,11);
91: hr_utility.set_location('fnd_global.user_id after reset:'||fnd_global.user_id,12);
92: end if;
93: end if;
86: -- call the apps intialization
87: fnd_global.apps_initialize(userId,null,null,null,null);
88: if g_debug then
89: hr_utility.set_location('returned from calling fnd_global.apps_initialize for userId:'||userId,10);
90: hr_utility.set_location('fnd_global.user_name after reset:'||fnd_global.user_name,11);
91: hr_utility.set_location('fnd_global.user_id after reset:'||fnd_global.user_id,12);
92: end if;
93: end if;
94: close username;
87: fnd_global.apps_initialize(userId,null,null,null,null);
88: if g_debug then
89: hr_utility.set_location('returned from calling fnd_global.apps_initialize for userId:'||userId,10);
90: hr_utility.set_location('fnd_global.user_name after reset:'||fnd_global.user_name,11);
91: hr_utility.set_location('fnd_global.user_id after reset:'||fnd_global.user_id,12);
92: end if;
93: end if;
94: close username;
95: end if;