DBA Data[Home] [Help]

APPS.HR_TRANSACTION_SS dependencies on FND_GLOBAL

Line 14: -- This method calls the fnd_global.apps_initialize if the context user

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,

Line 15: -- responding to approval notification does not match fnd_global.user_name

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

Line 37: hr_utility.set_location('fnd_global.user_name:'||fnd_global.user_name,4);

33: if g_debug then
34: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
35: hr_utility.set_location('p_item_type:'||p_item_type,2);
36: hr_utility.set_location('p_item_key:'||p_item_key,3);
37: hr_utility.set_location('fnd_global.user_name:'||fnd_global.user_name,4);
38: hr_utility.set_location('fnd_global.user_id:'||fnd_global.user_id,5);
39: end if;
40:
41:

Line 38: hr_utility.set_location('fnd_global.user_id:'||fnd_global.user_id,5);

34: hr_utility.set_location('Entering:'|| g_package||'.'||c_proc, 1);
35: hr_utility.set_location('p_item_type:'||p_item_type,2);
36: hr_utility.set_location('p_item_key:'||p_item_key,3);
37: hr_utility.set_location('fnd_global.user_name:'||fnd_global.user_name,4);
38: hr_utility.set_location('fnd_global.user_id:'||fnd_global.user_id,5);
39: end if;
40:
41:
42: -- check if we have the context set by the Approver Notification

Line 69: and context user does not match the fnd_global.user_name

65: directory service,then context_user = 'email:'
66:
67:
68: Functionally we will call apps intialization only if we have valid FND user
69: and context user does not match the fnd_global.user_name
70: */
71:
72: if(contextUser is not null and substr (contextUser, 1, 6)<>'email:') then
73: -- we have valid wf role

Line 74: -- check if the role is same as fnd_global.user_name

70: */
71:
72: if(contextUser is not null and substr (contextUser, 1, 6)<>'email:') then
73: -- we have valid wf role
74: -- check if the role is same as fnd_global.user_name
75: if(contextUser<>fnd_global.user_name) then
76: if(nvl(contextProxyUser,contextUser)<>fnd_global.user_name) then
77:
78: -- check if the role is a valid FND user

Line 75: if(contextUser<>fnd_global.user_name) then

71:
72: if(contextUser is not null and substr (contextUser, 1, 6)<>'email:') then
73: -- we have valid wf role
74: -- check if the role is same as fnd_global.user_name
75: if(contextUser<>fnd_global.user_name) then
76: if(nvl(contextProxyUser,contextUser)<>fnd_global.user_name) then
77:
78: -- check if the role is a valid FND user
79: if g_debug then

Line 76: if(nvl(contextProxyUser,contextUser)<>fnd_global.user_name) then

72: if(contextUser is not null and substr (contextUser, 1, 6)<>'email:') then
73: -- we have valid wf role
74: -- check if the role is same as fnd_global.user_name
75: if(contextUser<>fnd_global.user_name) then
76: if(nvl(contextProxyUser,contextUser)<>fnd_global.user_name) then
77:
78: -- check if the role is a valid FND user
79: if g_debug then
80: hr_utility.set_location('contextUser and contextProxyUser does not match fnd_global.user_name',7);

Line 80: hr_utility.set_location('contextUser and contextProxyUser does not match fnd_global.user_name',7);

76: if(nvl(contextProxyUser,contextUser)<>fnd_global.user_name) then
77:
78: -- check if the role is a valid FND user
79: if g_debug then
80: hr_utility.set_location('contextUser and contextProxyUser does not match fnd_global.user_name',7);
81: end if;
82: open username;
83: fetch username into userId;
84: if username%found then

Line 87: hr_utility.set_location('calling fnd_global.apps_initialize for userId:'||userId,9);

83: fetch username into userId;
84: if username%found then
85: if g_debug then
86: hr_utility.set_location('found a valid fnd user corresponding to context user',8);
87: hr_utility.set_location('calling fnd_global.apps_initialize for userId:'||userId,9);
88: end if;
89: -- call the apps intialization
90: fnd_global.apps_initialize(userId,null,null,null,null);
91: if g_debug then

Line 90: fnd_global.apps_initialize(userId,null,null,null,null);

86: hr_utility.set_location('found a valid fnd user corresponding to context user',8);
87: hr_utility.set_location('calling fnd_global.apps_initialize for userId:'||userId,9);
88: end if;
89: -- call the apps intialization
90: fnd_global.apps_initialize(userId,null,null,null,null);
91: if g_debug then
92: hr_utility.set_location('returned from calling fnd_global.apps_initialize for userId:'||userId,10);
93: hr_utility.set_location('fnd_global.user_name after reset:'||fnd_global.user_name,11);
94: hr_utility.set_location('fnd_global.user_id after reset:'||fnd_global.user_id,12);

Line 92: hr_utility.set_location('returned from calling fnd_global.apps_initialize for userId:'||userId,10);

88: end if;
89: -- call the apps intialization
90: fnd_global.apps_initialize(userId,null,null,null,null);
91: if g_debug then
92: hr_utility.set_location('returned from calling fnd_global.apps_initialize for userId:'||userId,10);
93: hr_utility.set_location('fnd_global.user_name after reset:'||fnd_global.user_name,11);
94: hr_utility.set_location('fnd_global.user_id after reset:'||fnd_global.user_id,12);
95: end if;
96: end if;

Line 93: hr_utility.set_location('fnd_global.user_name after reset:'||fnd_global.user_name,11);

89: -- call the apps intialization
90: fnd_global.apps_initialize(userId,null,null,null,null);
91: if g_debug then
92: hr_utility.set_location('returned from calling fnd_global.apps_initialize for userId:'||userId,10);
93: hr_utility.set_location('fnd_global.user_name after reset:'||fnd_global.user_name,11);
94: hr_utility.set_location('fnd_global.user_id after reset:'||fnd_global.user_id,12);
95: end if;
96: end if;
97: close username;

Line 94: hr_utility.set_location('fnd_global.user_id after reset:'||fnd_global.user_id,12);

90: fnd_global.apps_initialize(userId,null,null,null,null);
91: if g_debug then
92: hr_utility.set_location('returned from calling fnd_global.apps_initialize for userId:'||userId,10);
93: hr_utility.set_location('fnd_global.user_name after reset:'||fnd_global.user_name,11);
94: hr_utility.set_location('fnd_global.user_id after reset:'||fnd_global.user_id,12);
95: end if;
96: end if;
97: close username;
98: end if;

Line 122: -- check if the role is same as fnd_global.user_name

118: end if;
119: return;
120: end if;
121: -- we have valid wf role
122: -- check if the role is same as fnd_global.user_name
123: open user_role_name;
124: fetch user_role_name into c_user_name;
125: hr_utility.set_location('c_user_name ' || c_user_name,13);
126: if user_role_name%found then

Line 128: if(c_user_name<>fnd_global.user_name) then

124: fetch user_role_name into c_user_name;
125: hr_utility.set_location('c_user_name ' || c_user_name,13);
126: if user_role_name%found then
127:
128: if(c_user_name<>fnd_global.user_name) then
129: -- check if the role is a valid FND user
130: if g_debug then
131: hr_utility.set_location('contextUser and contextProxyUser does not match fnd_global.user_name for email',13);
132: end if;

Line 131: hr_utility.set_location('contextUser and contextProxyUser does not match fnd_global.user_name for email',13);

127:
128: if(c_user_name<>fnd_global.user_name) then
129: -- check if the role is a valid FND user
130: if g_debug then
131: hr_utility.set_location('contextUser and contextProxyUser does not match fnd_global.user_name for email',13);
132: end if;
133: contextUser := c_user_name;
134: open username;
135: fetch username into userId;

Line 139: hr_utility.set_location('calling fnd_global.apps_initialize for userId:'||userId,15);

135: fetch username into userId;
136: if username%found then
137: if g_debug then
138: hr_utility.set_location('found a valid fnd user corresponding to context user',14);
139: hr_utility.set_location('calling fnd_global.apps_initialize for userId:'||userId,15);
140: end if;
141: -- call the apps intialization
142: fnd_global.apps_initialize(userId,null,null,null,null);
143: if g_debug then

Line 142: fnd_global.apps_initialize(userId,null,null,null,null);

138: hr_utility.set_location('found a valid fnd user corresponding to context user',14);
139: hr_utility.set_location('calling fnd_global.apps_initialize for userId:'||userId,15);
140: end if;
141: -- call the apps intialization
142: fnd_global.apps_initialize(userId,null,null,null,null);
143: if g_debug then
144: hr_utility.set_location('returned from calling fnd_global.apps_initialize for userId:'||userId,16);
145: hr_utility.set_location('fnd_global.user_name:'||fnd_global.user_name,17);
146: hr_utility.set_location('fnd_global.user_id:'||fnd_global.user_id,18);

Line 144: hr_utility.set_location('returned from calling fnd_global.apps_initialize for userId:'||userId,16);

140: end if;
141: -- call the apps intialization
142: fnd_global.apps_initialize(userId,null,null,null,null);
143: if g_debug then
144: hr_utility.set_location('returned from calling fnd_global.apps_initialize for userId:'||userId,16);
145: hr_utility.set_location('fnd_global.user_name:'||fnd_global.user_name,17);
146: hr_utility.set_location('fnd_global.user_id:'||fnd_global.user_id,18);
147: hr_utility.set_location('fnd_profile.value(PER_SECURITY_PROFILE_ID):'||fnd_profile.value('PER_SECURITY_PROFILE_ID'),19);
148: hr_utility.set_location('fnd_profile.value(PER_BUSINESS_GROUP_ID):'||fnd_profile.value('PER_BUSINESS_GROUP_ID'),20);

Line 145: hr_utility.set_location('fnd_global.user_name:'||fnd_global.user_name,17);

141: -- call the apps intialization
142: fnd_global.apps_initialize(userId,null,null,null,null);
143: if g_debug then
144: hr_utility.set_location('returned from calling fnd_global.apps_initialize for userId:'||userId,16);
145: hr_utility.set_location('fnd_global.user_name:'||fnd_global.user_name,17);
146: hr_utility.set_location('fnd_global.user_id:'||fnd_global.user_id,18);
147: hr_utility.set_location('fnd_profile.value(PER_SECURITY_PROFILE_ID):'||fnd_profile.value('PER_SECURITY_PROFILE_ID'),19);
148: hr_utility.set_location('fnd_profile.value(PER_BUSINESS_GROUP_ID):'||fnd_profile.value('PER_BUSINESS_GROUP_ID'),20);
149: hr_utility.set_location('fnd_global.resp_id :'||fnd_global.resp_id,21);

Line 146: hr_utility.set_location('fnd_global.user_id:'||fnd_global.user_id,18);

142: fnd_global.apps_initialize(userId,null,null,null,null);
143: if g_debug then
144: hr_utility.set_location('returned from calling fnd_global.apps_initialize for userId:'||userId,16);
145: hr_utility.set_location('fnd_global.user_name:'||fnd_global.user_name,17);
146: hr_utility.set_location('fnd_global.user_id:'||fnd_global.user_id,18);
147: hr_utility.set_location('fnd_profile.value(PER_SECURITY_PROFILE_ID):'||fnd_profile.value('PER_SECURITY_PROFILE_ID'),19);
148: hr_utility.set_location('fnd_profile.value(PER_BUSINESS_GROUP_ID):'||fnd_profile.value('PER_BUSINESS_GROUP_ID'),20);
149: hr_utility.set_location('fnd_global.resp_id :'||fnd_global.resp_id,21);
150: hr_utility.set_location('fnd_global.resp_appl_id :'||fnd_global.resp_appl_id,22);

Line 149: hr_utility.set_location('fnd_global.resp_id :'||fnd_global.resp_id,21);

145: hr_utility.set_location('fnd_global.user_name:'||fnd_global.user_name,17);
146: hr_utility.set_location('fnd_global.user_id:'||fnd_global.user_id,18);
147: hr_utility.set_location('fnd_profile.value(PER_SECURITY_PROFILE_ID):'||fnd_profile.value('PER_SECURITY_PROFILE_ID'),19);
148: hr_utility.set_location('fnd_profile.value(PER_BUSINESS_GROUP_ID):'||fnd_profile.value('PER_BUSINESS_GROUP_ID'),20);
149: hr_utility.set_location('fnd_global.resp_id :'||fnd_global.resp_id,21);
150: hr_utility.set_location('fnd_global.resp_appl_id :'||fnd_global.resp_appl_id,22);
151: hr_utility.set_location('fnd_global.per_business_group_id :'||fnd_global.per_business_group_id,23);
152: hr_utility.set_location('fnd_global.security_group_id:'||fnd_global.security_group_id,24);
153: hr_utility.set_location('fnd_global.per_security_profile_id:'||fnd_global.per_security_profile_id,25);

Line 150: hr_utility.set_location('fnd_global.resp_appl_id :'||fnd_global.resp_appl_id,22);

146: hr_utility.set_location('fnd_global.user_id:'||fnd_global.user_id,18);
147: hr_utility.set_location('fnd_profile.value(PER_SECURITY_PROFILE_ID):'||fnd_profile.value('PER_SECURITY_PROFILE_ID'),19);
148: hr_utility.set_location('fnd_profile.value(PER_BUSINESS_GROUP_ID):'||fnd_profile.value('PER_BUSINESS_GROUP_ID'),20);
149: hr_utility.set_location('fnd_global.resp_id :'||fnd_global.resp_id,21);
150: hr_utility.set_location('fnd_global.resp_appl_id :'||fnd_global.resp_appl_id,22);
151: hr_utility.set_location('fnd_global.per_business_group_id :'||fnd_global.per_business_group_id,23);
152: hr_utility.set_location('fnd_global.security_group_id:'||fnd_global.security_group_id,24);
153: hr_utility.set_location('fnd_global.per_security_profile_id:'||fnd_global.per_security_profile_id,25);
154: end if;

Line 151: hr_utility.set_location('fnd_global.per_business_group_id :'||fnd_global.per_business_group_id,23);

147: hr_utility.set_location('fnd_profile.value(PER_SECURITY_PROFILE_ID):'||fnd_profile.value('PER_SECURITY_PROFILE_ID'),19);
148: hr_utility.set_location('fnd_profile.value(PER_BUSINESS_GROUP_ID):'||fnd_profile.value('PER_BUSINESS_GROUP_ID'),20);
149: hr_utility.set_location('fnd_global.resp_id :'||fnd_global.resp_id,21);
150: hr_utility.set_location('fnd_global.resp_appl_id :'||fnd_global.resp_appl_id,22);
151: hr_utility.set_location('fnd_global.per_business_group_id :'||fnd_global.per_business_group_id,23);
152: hr_utility.set_location('fnd_global.security_group_id:'||fnd_global.security_group_id,24);
153: hr_utility.set_location('fnd_global.per_security_profile_id:'||fnd_global.per_security_profile_id,25);
154: end if;
155: end if; --end of if username%found then

Line 152: hr_utility.set_location('fnd_global.security_group_id:'||fnd_global.security_group_id,24);

148: hr_utility.set_location('fnd_profile.value(PER_BUSINESS_GROUP_ID):'||fnd_profile.value('PER_BUSINESS_GROUP_ID'),20);
149: hr_utility.set_location('fnd_global.resp_id :'||fnd_global.resp_id,21);
150: hr_utility.set_location('fnd_global.resp_appl_id :'||fnd_global.resp_appl_id,22);
151: hr_utility.set_location('fnd_global.per_business_group_id :'||fnd_global.per_business_group_id,23);
152: hr_utility.set_location('fnd_global.security_group_id:'||fnd_global.security_group_id,24);
153: hr_utility.set_location('fnd_global.per_security_profile_id:'||fnd_global.per_security_profile_id,25);
154: end if;
155: end if; --end of if username%found then
156: close username;

Line 153: hr_utility.set_location('fnd_global.per_security_profile_id:'||fnd_global.per_security_profile_id,25);

149: hr_utility.set_location('fnd_global.resp_id :'||fnd_global.resp_id,21);
150: hr_utility.set_location('fnd_global.resp_appl_id :'||fnd_global.resp_appl_id,22);
151: hr_utility.set_location('fnd_global.per_business_group_id :'||fnd_global.per_business_group_id,23);
152: hr_utility.set_location('fnd_global.security_group_id:'||fnd_global.security_group_id,24);
153: hr_utility.set_location('fnd_global.per_security_profile_id:'||fnd_global.per_security_profile_id,25);
154: end if;
155: end if; --end of if username%found then
156: close username;
157: end if; -- end of if(c_user_name<>fnd_global.user_name) then

Line 157: end if; -- end of if(c_user_name<>fnd_global.user_name) then

153: hr_utility.set_location('fnd_global.per_security_profile_id:'||fnd_global.per_security_profile_id,25);
154: end if;
155: end if; --end of if username%found then
156: close username;
157: end if; -- end of if(c_user_name<>fnd_global.user_name) then
158: end if; --end of if user_role_name%found then
159: close user_role_name;
160: end if; --end of if(contextUser is not null and substr (contextUser, 1, 6) = 'email:') then
161: