[Home] [Help]
91:
92: l_role_name := 'FNDPWD_' || itemkey || '_' || l_username;
93: l_display_name := getDisplayName(l_username);
94:
95: WF_DIRECTORY.CreateAdHocRole (
96: role_name => l_role_name,
97: role_display_name => l_display_name,
98: email_address => WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'EMAIL_ADDRESS'));
99:
223: 'fnd.plsql.UMXVUPWB.get_email_address.begin',
224: 'p_user_name: ' || p_user_name);
225: end if;
226:
227: -- First get the email from wf directory
228: WF_DIRECTORY.GetRoleInfo (p_user_name, l_role_display_name, x_email_address,
229: x_notification_preference, l_language, l_territory);
230:
231: if x_email_address is not null then
224: 'p_user_name: ' || p_user_name);
225: end if;
226:
227: -- First get the email from wf directory
228: WF_DIRECTORY.GetRoleInfo (p_user_name, l_role_display_name, x_email_address,
229: x_notification_preference, l_language, l_territory);
230:
231: if x_email_address is not null then
232: x_role_name := p_user_name;
300: 'fnd.plsql.UMXVUPWB.find_user_w_email.begin',
301: 'p_email: ' || p_email);
302: end if;
303:
304: -- First get the email from wf directory
305: /*
306: WF_DIRECTORY.GetRoleInfo (p_user_name, l_role_display_name, x_email_address,
307: x_notification_preference, l_language, l_territory);
308: */
302: end if;
303:
304: -- First get the email from wf directory
305: /*
306: WF_DIRECTORY.GetRoleInfo (p_user_name, l_role_display_name, x_email_address,
307: x_notification_preference, l_language, l_territory);
308: */
309:
310: -- Try to get the email from fnd_user
326: end if;
327: close get_user_fnd;
328:
329: if (x_user_name is not null ) then
330: WF_DIRECTORY.GetRoleInfo (x_user_name, l_role_display_name, l_email_address,
331: x_notification_preference, l_language, l_territory);
332: end if;
333:
334: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
378: -- Try to get the email from fnd_user
379: --open get_user_fnd (p_email);
380: --fetch get_user_fnd into l_user_name;
381: for aUser in get_user_fnd(p_email) loop
382: WF_DIRECTORY.GetRoleInfo ( aUser.user_name, l_role_display_name, l_email_address,
383: l_notification_preference, l_language, l_territory);
384: x_users(i).user_name := aUser.user_name;
385: x_users(i).notification_preference := l_notification_preference;
386: i := i + 1;
388:
389: if ( i = 0 ) then
390: for party in get_user_hz(p_email) loop
391: l_user_name := party.user_name;
392: WF_DIRECTORY.GetRoleInfo (l_user_name, l_role_display_name, l_email_address,
393: l_notification_preference, l_language, l_territory);
394: x_users(i).user_name := party.user_name;
395: x_users(i).notification_preference := l_notification_preference;
396: i := i + 1;
1364: itemtype => g_itemtype,
1365: itemkey => p_itemKey,
1366: aname => 'X_USER_ROLE');
1367: -- get orig system info and check if this is an ad-hoc role ,7445188
1368: wf_directory.getroleOrigsysinfo(l_role_name,l_orig_system,l_orig_system_id);
1369: if l_orig_system ='WF_LOCAL_ROLES' then
1370: wf_directory.setAdHocRoleExpiration(l_role_name);
1371: end if;
1372:
1366: aname => 'X_USER_ROLE');
1367: -- get orig system info and check if this is an ad-hoc role ,7445188
1368: wf_directory.getroleOrigsysinfo(l_role_name,l_orig_system,l_orig_system_id);
1369: if l_orig_system ='WF_LOCAL_ROLES' then
1370: wf_directory.setAdHocRoleExpiration(l_role_name);
1371: end if;
1372:
1373: wf_engine.abortprocess(
1374: itemtype => g_itemtype,