DBA Data[Home] [Help]

APPS.UMX_PASSWORD_PVT dependencies on WF_ENGINE

Line 304: l_password := WF_ENGINE.GetActivityAttrText (

300:
301: begin
302: if (funcmode = 'RUN') then
303: -- Check if the password is already set.
304: l_password := WF_ENGINE.GetActivityAttrText (
305: itemtype => itemtype,
306: itemkey => itemkey,
307: actid => actid,
308: aname => 'PASSWORD');

Line 313: l_user_name := WF_ENGINE.GetActivityAttrText(

309:
310: if (l_password is null) then
311: -- code for validating the generated username
312: -- get the username
313: l_user_name := WF_ENGINE.GetActivityAttrText(
314: itemtype => itemtype,
315: itemkey => itemkey,
316: actid => actid,
317: aname => 'USER_NAME');

Line 322: wf_engine.SetItemAttrText (itemtype => itemtype,

318:
319: SetPassword (p_username => l_user_name,
320: x_password => l_password);
321:
322: wf_engine.SetItemAttrText (itemtype => itemtype,
323: itemkey => itemkey,
324: aname => 'PASSWORD',
325: avalue => l_password);
326:

Line 330: resultout := WF_ENGINE.eng_completed || ':' || WF_ENGINE.eng_null;

326:
327: end if;
328: end if;
329:
330: resultout := WF_ENGINE.eng_completed || ':' || WF_ENGINE.eng_null;
331:
332: exception
333: when others then
334: Wf_Core.Context('UMX_PASSWORD_PVT', 'SetPassword_WF', itemtype, itemkey, actid);

Line 354: WF_ENGINE.GetActivityAttrText(itemtype, itemkey, actid,

350: if (funcmode = 'RUN') then
351:
352: FND_USER_PKG.UpdateUserParty (
353: x_user_name =>
354: WF_ENGINE.GetActivityAttrText(itemtype, itemkey, actid,
355: 'USER_NAME', TRUE),
356: x_owner => null,
357: x_unencrypted_password =>
358: WF_ENGINE.GetActivityAttrText(itemtype, itemkey, actid,

Line 358: WF_ENGINE.GetActivityAttrText(itemtype, itemkey, actid,

354: WF_ENGINE.GetActivityAttrText(itemtype, itemkey, actid,
355: 'USER_NAME', TRUE),
356: x_owner => null,
357: x_unencrypted_password =>
358: WF_ENGINE.GetActivityAttrText(itemtype, itemkey, actid,
359: 'PASSWORD', TRUE),
360: x_password_date => fnd_user_pkg.null_date);
361:
362: end if;

Line 364: resultout := WF_ENGINE.eng_completed || ':' || WF_ENGINE.eng_null;

360: x_password_date => fnd_user_pkg.null_date);
361:
362: end if;
363:
364: resultout := WF_ENGINE.eng_completed || ':' || WF_ENGINE.eng_null;
365:
366: exception
367: when others then
368: Wf_Core.Context('UMX_PASSWORD_PVT', 'UpdatePassword_WF', itemtype, itemkey,

Line 430: l_role_name := WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'X_USER_ROLE');

426: begin
427:
428: if (funcmode = 'RUN') then
429:
430: l_role_name := WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'X_USER_ROLE');
431: l_notification_preference := WF_ENGINE.GetItemAttrText (itemtype, itemkey, 'NOTIFICATION_PREFERENCE');
432:
433: if (l_role_name is NULL) or (l_notification_preference not like 'MAIL%') then
434: -- No role with the user_name, create an ad hoc role.

Line 431: l_notification_preference := WF_ENGINE.GetItemAttrText (itemtype, itemkey, 'NOTIFICATION_PREFERENCE');

427:
428: if (funcmode = 'RUN') then
429:
430: l_role_name := WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'X_USER_ROLE');
431: l_notification_preference := WF_ENGINE.GetItemAttrText (itemtype, itemkey, 'NOTIFICATION_PREFERENCE');
432:
433: if (l_role_name is NULL) or (l_notification_preference not like 'MAIL%') then
434: -- No role with the user_name, create an ad hoc role.
435: l_username := upper(WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'USER_NAME'));

Line 435: l_username := upper(WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'USER_NAME'));

431: l_notification_preference := WF_ENGINE.GetItemAttrText (itemtype, itemkey, 'NOTIFICATION_PREFERENCE');
432:
433: if (l_role_name is NULL) or (l_notification_preference not like 'MAIL%') then
434: -- No role with the user_name, create an ad hoc role.
435: l_username := upper(WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'USER_NAME'));
436: l_role_name := 'FNDPWD_' || itemkey || '_' || l_username;
437: l_display_name := getDisplayName(l_username);
438: WF_DIRECTORY.CreateAdHocRole (
439: role_name => l_role_name,

Line 441: email_address => WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'EMAIL_ADDRESS'));

437: l_display_name := getDisplayName(l_username);
438: WF_DIRECTORY.CreateAdHocRole (
439: role_name => l_role_name,
440: role_display_name => l_display_name,
441: email_address => WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'EMAIL_ADDRESS'));
442: wf_engine.SetItemAttrText (itemtype => itemtype,
443: itemkey => itemkey,
444: aname => 'X_USER_ROLE',
445: avalue => l_role_name);

Line 442: wf_engine.SetItemAttrText (itemtype => itemtype,

438: WF_DIRECTORY.CreateAdHocRole (
439: role_name => l_role_name,
440: role_display_name => l_display_name,
441: email_address => WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'EMAIL_ADDRESS'));
442: wf_engine.SetItemAttrText (itemtype => itemtype,
443: itemkey => itemkey,
444: aname => 'X_USER_ROLE',
445: avalue => l_role_name);
446: end if;

Line 448: resultout := WF_ENGINE.eng_completed || ':' || WF_ENGINE.eng_null;

444: aname => 'X_USER_ROLE',
445: avalue => l_role_name);
446: end if;
447: end if;
448: resultout := WF_ENGINE.eng_completed || ':' || WF_ENGINE.eng_null;
449:
450: exception
451: when others then
452: Wf_Core.Context('UMX_PASSWORD_PVT', 'CreateRole', itemtype, itemkey,

Line 487: wf_engine.CreateProcess(itemtype => g_itemtype,

483:
484: -- start the workflow that will send the notification and reset
485: -- the password
486:
487: wf_engine.CreateProcess(itemtype => g_itemtype,
488: itemkey => x_itemkey,
489: process => 'RESETPASSWD');
490:
491: wf_engine.SetItemAttrText(itemtype => g_itemtype,

Line 491: wf_engine.SetItemAttrText(itemtype => g_itemtype,

487: wf_engine.CreateProcess(itemtype => g_itemtype,
488: itemkey => x_itemkey,
489: process => 'RESETPASSWD');
490:
491: wf_engine.SetItemAttrText(itemtype => g_itemtype,
492: itemkey => x_itemkey,
493: aname => 'USER_NAME',
494: avalue => p_user_name);
495:

Line 496: wf_engine.SetItemAttrText(itemtype => g_itemtype,

492: itemkey => x_itemkey,
493: aname => 'USER_NAME',
494: avalue => p_user_name);
495:
496: wf_engine.SetItemAttrText(itemtype => g_itemtype,
497: itemkey => x_itemkey,
498: aname => 'PASSWORD',
499: avalue => p_password);
500:

Line 502: wf_engine.SetItemAttrText (itemtype => g_itemtype,

498: aname => 'PASSWORD',
499: avalue => p_password);
500:
501: if p_htmlagent is not null then
502: wf_engine.SetItemAttrText (itemtype => g_itemtype,
503: itemkey => x_itemkey,
504: aname => 'HTMLAGENT',
505: avalue => p_htmlagent);
506: end if;

Line 509: wf_engine.SetItemAttrText (itemtype => g_itemtype,

505: avalue => p_htmlagent);
506: end if;
507:
508: if p_email_address is not null then
509: wf_engine.SetItemAttrText (itemtype => g_itemtype,
510: itemkey => x_itemkey,
511: aname => 'EMAIL_ADDRESS',
512: avalue => p_email_address);
513: end if;

Line 516: wf_engine.SetItemAttrText (itemtype => g_itemtype,

512: avalue => p_email_address);
513: end if;
514:
515: if p_role_name is not null then
516: wf_engine.SetItemAttrText (itemtype => g_itemtype,
517: itemkey => x_itemkey,
518: aname => 'X_USER_ROLE',
519: avalue => p_role_name);
520: end if;

Line 523: wf_engine.SetItemAttrText (itemtype => g_itemtype,

519: avalue => p_role_name);
520: end if;
521:
522: if p_notification_preference is not null then
523: wf_engine.SetItemAttrText (itemtype => g_itemtype,
524: itemkey => x_itemkey,
525: aname => 'NOTIFICATION_PREFERENCE',
526: avalue => p_notification_preference);
527: end if;

Line 530: wf_engine.SetItemAttrText(itemtype => g_itemtype,

526: avalue => p_notification_preference);
527: end if;
528:
529: if p_user_appr_msg_name is not null then
530: wf_engine.SetItemAttrText(itemtype => g_itemtype,
531: itemkey => x_itemkey,
532: aname => 'APPR_MESSAGE',
533: avalue => p_user_appr_msg_name);
534: end if;

Line 537: wf_engine.SetItemAttrText(itemtype => g_itemtype,

533: avalue => p_user_appr_msg_name);
534: end if;
535:
536: if p_pwd_reset_msg_name is not null then
537: wf_engine.SetItemAttrText(itemtype => g_itemtype,
538: itemkey => x_itemkey,
539: aname => 'CONFIRM_MSG',
540: avalue => p_pwd_reset_msg_name);
541: end if;

Line 545: wf_engine.SetItemAttrText (itemtype => g_itemtype,

541: end if;
542:
543: -- Only update if the Notify User Flag is 'Y' or 'N'
544: if (p_check_identity = 'Y') or (p_check_identity = 'N') then
545: wf_engine.SetItemAttrText (itemtype => g_itemtype,
546: itemkey => x_itemkey,
547: aname => 'L_CHECK_IDENTITY_FLAG',
548: avalue => p_check_identity);
549: end if;

Line 551: wf_engine.StartProcess(itemtype => g_itemtype,

547: aname => 'L_CHECK_IDENTITY_FLAG',
548: avalue => p_check_identity);
549: end if;
550:
551: wf_engine.StartProcess(itemtype => g_itemtype,
552: itemkey => x_itemkey);
553:
554: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
555: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

Line 618: wf_engine.itemstatus (g_itemtype, l_itemkey, l_status, l_result);

614: start_workflow (l_user_name, p_password, l_email_address, l_role_name,
615: l_notification_preference, p_user_appr_msg_name,
616: p_pwd_reset_msg_name, p_check_identity, p_htmlagent, l_itemkey);
617: -- Check if the workflow is in error status
618: wf_engine.itemstatus (g_itemtype, l_itemkey, l_status, l_result);
619: if (l_status = 'ERROR') then
620: -- Error status
621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
622: x_message_name := 'UMX_FORGOT_PWD_UNEXP_ERR_MSG';

Line 788: l_role_name := WF_ENGINE.GetItemAttrText (itemtype, itemkey, 'X_USER_ROLE');

784:
785: begin
786:
787: if (funcmode = 'RUN') then
788: l_role_name := WF_ENGINE.GetItemAttrText (itemtype, itemkey, 'X_USER_ROLE');
789:
790: -- First check Ad Hoc Role is being used.
791: if (l_role_name = 'FNDPWD_' || itemkey || '_' || upper(WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'USER_NAME'))) then
792:

Line 791: if (l_role_name = 'FNDPWD_' || itemkey || '_' || upper(WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'USER_NAME'))) then

787: if (funcmode = 'RUN') then
788: l_role_name := WF_ENGINE.GetItemAttrText (itemtype, itemkey, 'X_USER_ROLE');
789:
790: -- First check Ad Hoc Role is being used.
791: if (l_role_name = 'FNDPWD_' || itemkey || '_' || upper(WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'USER_NAME'))) then
792:
793: -- Make Ad Hoc Role to expire.
794: -- The expiration_date is set to +30 based on the recommandation from WF.
795: wf_directory.SetAdHocRoleExpiration (role_name => l_role_name,

Line 804: resultout := WF_ENGINE.eng_completed || ':' || WF_ENGINE.eng_null;

800: status => 'INACTIVE');
801: end if;
802: end if;
803:
804: resultout := WF_ENGINE.eng_completed || ':' || WF_ENGINE.eng_null;
805:
806: exception
807: when others then
808: Wf_Core.Context('UMX_PASSWORD_PVT', 'clean_up_ad_hoc_role', itemtype, itemkey,