eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.UMX_LOGIN_HELP_PVT dependencies on WF_ENGINE

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

80: begin
81:
82: if (funcmode = 'RUN') then
83:
84: l_role_name := WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'X_USER_ROLE');
85:
86: l_notification_preference := WF_ENGINE.GetItemAttrText (itemtype, itemkey, 'NOTIFICATION_PREFERENCE');
87:
88: if (l_role_name is NULL) or (l_notification_preference not like 'MAIL%') then

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

82: if (funcmode = 'RUN') then
83:
84: l_role_name := WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'X_USER_ROLE');
85:
86: l_notification_preference := WF_ENGINE.GetItemAttrText (itemtype, itemkey, 'NOTIFICATION_PREFERENCE');
87:
88: if (l_role_name is NULL) or (l_notification_preference not like 'MAIL%') then
89: -- No role with the user_name, create an ad hoc role.
90: l_username := upper(WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'USER_NAME'));

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

86: l_notification_preference := WF_ENGINE.GetItemAttrText (itemtype, itemkey, 'NOTIFICATION_PREFERENCE');
87:
88: if (l_role_name is NULL) or (l_notification_preference not like 'MAIL%') then
89: -- No role with the user_name, create an ad hoc role.
90: l_username := upper(WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'USER_NAME'));
91:
92: l_role_name := 'FNDPWD_' || itemkey || '_' || l_username;
93: l_display_name := getDisplayName(l_username);
94:

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

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:
100: wf_engine.SetItemAttrText (itemtype => itemtype,
101: itemkey => itemkey,
102: aname => 'X_USER_ROLE',

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

96: role_name => l_role_name,
97: role_display_name => l_display_name,
98: email_address => WF_ENGINE.GetItemAttrText(itemtype, itemkey, 'EMAIL_ADDRESS'));
99:
100: wf_engine.SetItemAttrText (itemtype => itemtype,
101: itemkey => itemkey,
102: aname => 'X_USER_ROLE',
103: avalue => l_role_name);
104:

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

105: end if;
106:
107: end if;
108:
109: resultout := WF_ENGINE.eng_completed || ':' || WF_ENGINE.eng_null;
110:
111: exception
112: when others then
113: Wf_Core.Context('UMX_LOGIN_HELP_PVT', 'CreateRole', itemtype, itemkey,

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

428:
429: -- start the workflow that will send the notification and reset
430: -- the password
431:
432: wf_engine.CreateProcess(itemtype => g_itemtype,
433: itemkey => x_itemkey,
434: process => 'LOGIN_HELP');
435:
436: wf_engine.SetItemAttrText(itemtype => g_itemtype,

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

432: wf_engine.CreateProcess(itemtype => g_itemtype,
433: itemkey => x_itemkey,
434: process => 'LOGIN_HELP');
435:
436: wf_engine.SetItemAttrText(itemtype => g_itemtype,
437: itemkey => x_itemkey,
438: aname => 'REQUEST_TYPE',
439: avalue => p_request_type);
440:

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

438: aname => 'REQUEST_TYPE',
439: avalue => p_request_type);
440:
441: if ( p_user_name is not null ) then
442: wf_engine.SetItemAttrText(itemtype => g_itemtype,
443: itemkey => x_itemkey,
444: aname => 'USER_NAME',
445: avalue => p_user_name);
446: end if;

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

445: avalue => p_user_name);
446: end if;
447:
448: if p_email_address is not null then
449: wf_engine.SetItemAttrText (itemtype => g_itemtype,
450: itemkey => x_itemkey,
451: aname => 'EMAIL_ADDRESS',
452: avalue => p_email_address);
453: end if;

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

452: avalue => p_email_address);
453: end if;
454:
455: if p_role_name is not null then
456: wf_engine.SetItemAttrText (itemtype => g_itemtype,
457: itemkey => x_itemkey,
458: aname => 'X_USER_ROLE',
459: avalue => p_role_name);
460: end if;

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

459: avalue => p_role_name);
460: end if;
461:
462: if p_notification_preference is not null then
463: wf_engine.SetItemAttrText (itemtype => g_itemtype,
464: itemkey => x_itemkey,
465: aname => 'NOTIFICATION_PREFERENCE',
466: avalue => p_notification_preference);
467: end if;

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

465: aname => 'NOTIFICATION_PREFERENCE',
466: avalue => p_notification_preference);
467: end if;
468:
469: wf_engine.StartProcess(itemtype => g_itemtype,
470: itemkey => x_itemkey);
471:
472: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
473: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

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

524: -- Start Workflow to reset user's password.
525: start_workflow ( 'P', l_user_name, l_email_address, l_role_name,
526: l_notification_preference, l_itemkey);
527: -- Check if the workflow is in error status
528: wf_engine.itemstatus (g_itemtype, l_itemkey, l_status, l_result);
529: if (l_status = 'ERROR') then
530: -- Error status
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: x_message_name := 'UMX_LOGIN_HELP_UNEXP_ERROR';

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

665: start_workflow ( 'U', l_user_name, l_email_address, l_role_name,
666: l_notification_preference, l_itemkey);
667: -- Check if the workflow is in error status
668:
669: wf_engine.itemstatus (g_itemtype, l_itemkey, l_status, l_result);
670: if (l_status = 'ERROR') then
671: -- Error status
672: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
673: x_message_name := 'UMX_RESET_PWD2_UNEXP_ERROR';

Line 782: l_auth_key := WF_ENGINE.GetActivityAttrText (

778: begin
779: if (funcmode = 'RUN') then
780: -- Check if the password is already set.
781: /*
782: l_auth_key := WF_ENGINE.GetActivityAttrText (
783: itemtype => itemtype,
784: itemkey => itemkey,
785: actid => actid,
786: aname => 'AUTH_KEY');

Line 794: l_user_name := WF_ENGINE.GetActivityAttrText(

790: if (l_auth_key is not null) then
791: -- code for validating the generated username
792: -- get the username
793: /*
794: l_user_name := WF_ENGINE.GetActivityAttrText(
795: itemtype => itemtype,
796: itemkey => itemkey,
797: actid => actid,
798: aname => 'USER_NAME');

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

797: actid => actid,
798: aname => 'USER_NAME');
799: */
800:
801: wf_engine.SetItemAttrText (itemtype => itemtype,
802: itemkey => itemkey,
803: aname => 'AUTH_KEY',
804: avalue => l_auth_key);
805:

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

805:
806: end if;
807: end if;
808:
809: resultout := WF_ENGINE.eng_completed || ':' || WF_ENGINE.eng_null;
810:
811: exception
812: when others then
813: Wf_Core.Context('UMX_LOGIN_HELP_PVT', 'GenAuthKey', itemtype, itemkey, actid);

Line 842: l_auth_key := WF_ENGINE.GetItemAttrText (

838: if (funcmode = 'RUN') then
839: -- Check if the password is already set.
840:
841:
842: l_auth_key := WF_ENGINE.GetItemAttrText (
843: itemtype => itemtype,
844: itemkey => itemkey,
845: aname => 'AUTH_KEY');
846:

Line 848: l_user_name := WF_ENGINE.GetItemAttrText(

844: itemkey => itemkey,
845: aname => 'AUTH_KEY');
846:
847:
848: l_user_name := WF_ENGINE.GetItemAttrText(
849: itemtype => itemtype,
850: itemkey => itemkey,
851: aname => 'USER_NAME');
852:

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

867: p_security_group_key => null,
868: p_parameters => l_param);
869:
870:
871: wf_engine.SetItemAttrText (itemtype => itemtype,
872: itemkey => itemkey,
873: aname => 'RESETURL',
874: avalue => l_url);
875:

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

874: avalue => l_url);
875:
876: end if;
877:
878: resultout := WF_ENGINE.eng_completed || ':' || WF_ENGINE.eng_null;
879:
880: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
881: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
882: 'fnd.plsql.UMXVUPWB.GenUrl2ResetPwdPg.end',

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

884: end if;
885:
886: exception
887: when others then
888: wf_engine.SetItemAttrText (itemtype => itemtype,
889: itemkey => itemkey,
890: aname => 'DEBUG_INFO',
891: avalue => to_char(actid));
892: Wf_Core.Context('UMX_LOGIN_HELP_PVT', 'GenUrl2ResetPwdPg', itemtype, itemkey, actid);

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

908:
909: if (funcmode = 'RUN') then
910: l_url := FND_SSO_MANAGER.getloginurl;
911:
912: wf_engine.SetItemAttrText (itemtype => itemtype,
913: itemkey => itemkey,
914: aname => 'LOGINURL',
915: avalue => l_url);
916: end if;

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

914: aname => 'LOGINURL',
915: avalue => l_url);
916: end if;
917:
918: resultout := WF_ENGINE.eng_completed || ':' || WF_ENGINE.eng_null;
919:
920:
921: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
922: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

Line 944: l_user_name := WF_ENGINE.GetItemAttrText (

940: 'fnd.plsql.UMXVUPWB.DisableAccount.begin', '');
941: end if;
942:
943: if (funcmode = 'RUN') then
944: l_user_name := WF_ENGINE.GetItemAttrText (
945: itemtype => itemtype,
946: itemkey => itemkey,
947: aname => 'USER_NAME');
948:

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

950: fnd_user_pkg.disableuser( username => l_user_name );
951: end if;
952: end if;
953:
954: resultout := WF_ENGINE.eng_completed || ':' || WF_ENGINE.eng_null;
955:
956:
957: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
958: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

Line 988: WF_ENGINE.itemstatus( g_itemtype, p_itemkey, l_item_status, l_item_result );

984: ' | p_itemkey: ' || p_itemkey );
985: end if;
986:
987:
988: WF_ENGINE.itemstatus( g_itemtype, p_itemkey, l_item_status, l_item_result );
989:
990: if ( l_item_status <> 'ACTIVE' ) then
991: x_return_status := 'E';
992: x_message_name := 'UMX_RESET_PWD2_VALID_FAILED';

Line 995: x_no_attempts := WF_ENGINE.GetItemAttrText(g_itemtype, p_itemkey, 'MAX_NO_ATTEMPT');

991: x_return_status := 'E';
992: x_message_name := 'UMX_RESET_PWD2_VALID_FAILED';
993: return;
994: end if;
995: x_no_attempts := WF_ENGINE.GetItemAttrText(g_itemtype, p_itemkey, 'MAX_NO_ATTEMPT');
996: if ( to_number( x_no_attempts ) <= 0 ) then
997: x_return_status := 'E';
998: x_message_name := 'UMX_RESET_PWD2_VALID_FAILED';
999: return;

Line 1003: l_authkey := WF_ENGINE.GetItemAttrText(g_itemtype, p_itemkey, 'AUTH_KEY');

999: return;
1000: end if;
1001:
1002:
1003: l_authkey := WF_ENGINE.GetItemAttrText(g_itemtype, p_itemkey, 'AUTH_KEY');
1004:
1005: if ( l_authkey = p_authkey ) then
1006: x_return_status := 'S';
1007: return;

Line 1068: WF_ENGINE.itemstatus( g_itemtype, p_itemkey, l_item_status, l_item_result );

1064: ' | p_authkey: ' || p_authkey ||
1065: ' | p_itemkey: ' || p_itemkey );
1066: end if;
1067:
1068: WF_ENGINE.itemstatus( g_itemtype, p_itemkey, l_item_status, l_item_result );
1069:
1070: if ( l_item_status <> 'ACTIVE' ) then
1071: x_return_status := 'E';
1072: x_message_name := 'UMX_RESET_PWD2_VALID_FAILED';

Line 1076: x_no_attempts := WF_ENGINE.GetItemAttrText(g_itemtype, p_itemkey, 'MAX_NO_ATTEMPT');

1072: x_message_name := 'UMX_RESET_PWD2_VALID_FAILED';
1073: return;
1074: end if;
1075:
1076: x_no_attempts := WF_ENGINE.GetItemAttrText(g_itemtype, p_itemkey, 'MAX_NO_ATTEMPT');
1077:
1078: if ( to_number( x_no_attempts ) <= 0 ) then
1079: x_return_status := 'E';
1080: x_message_name := 'UMX_RESET_PWD2_VALID_FAILED';

Line 1084: l_user_name := WF_ENGINE.GetItemAttrText(g_itemtype, p_itemkey, 'USER_NAME');

1080: x_message_name := 'UMX_RESET_PWD2_VALID_FAILED';
1081: return;
1082: end if;
1083:
1084: l_user_name := WF_ENGINE.GetItemAttrText(g_itemtype, p_itemkey, 'USER_NAME');
1085: l_authkey := WF_ENGINE.GetItemAttrText(g_itemtype, p_itemkey, 'AUTH_KEY');
1086:
1087: if ( l_authkey = p_authkey ) then
1088: x_return_status := 'S';

Line 1085: l_authkey := WF_ENGINE.GetItemAttrText(g_itemtype, p_itemkey, 'AUTH_KEY');

1081: return;
1082: end if;
1083:
1084: l_user_name := WF_ENGINE.GetItemAttrText(g_itemtype, p_itemkey, 'USER_NAME');
1085: l_authkey := WF_ENGINE.GetItemAttrText(g_itemtype, p_itemkey, 'AUTH_KEY');
1086:
1087: if ( l_authkey = p_authkey ) then
1088: x_return_status := 'S';
1089: else

Line 1192: l_no_attempt := wf_engine.getitemattrnumber(

1188: x_no_attempts out NOCOPY varchar2) IS
1189: l_no_attempt pls_integer := 0;
1190: begin
1191: -- retrieve no of attempts from wf
1192: l_no_attempt := wf_engine.getitemattrnumber(
1193: itemtype => g_itemtype,
1194: itemkey => p_itemkey,
1195: aname => 'MAX_NO_ATTEMPT');
1196: l_no_attempt := l_no_attempt - 1;

Line 1198: wf_engine.SetItemAttrNumber (itemtype => g_itemtype,

1194: itemkey => p_itemkey,
1195: aname => 'MAX_NO_ATTEMPT');
1196: l_no_attempt := l_no_attempt - 1;
1197:
1198: wf_engine.SetItemAttrNumber (itemtype => g_itemtype,
1199: itemkey => p_itemkey,
1200: aname => 'MAX_NO_ATTEMPT',
1201: avalue => l_no_attempt );
1202: x_no_attempts := to_char( l_no_attempt );

Line 1363: l_role_name := WF_ENGINE.GetItemAttrText (

1359: 'fnd.plsql.UMX_LOGIN_HELP_PVT.CompleteActivity.begin',
1360: ' p_itemkey: ' || p_itemKey );
1361: end if;
1362:
1363: l_role_name := WF_ENGINE.GetItemAttrText (
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

Line 1373: wf_engine.abortprocess(

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,
1375: itemkey => p_itemKey,
1376: process => null,
1377: result => null,