DBA Data[Home] [Help]

APPS.UMX_LOGIN_HELP_PVT dependencies on UMX_LOGIN_HELP_PVT

Line 1: PACKAGE BODY UMX_LOGIN_HELP_PVT AS

1: PACKAGE BODY UMX_LOGIN_HELP_PVT AS
2: /* $Header: UMXLHLPB.pls 120.6.12010000.2 2008/10/16 07:14:21 snellepa ship $ */
3: procedure decrementAttemptCounter(
4: p_itemkey in varchar2,
5: x_no_attempts out NOCOPY varchar2);

Line 113: Wf_Core.Context('UMX_LOGIN_HELP_PVT', 'CreateRole', itemtype, itemkey,

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,
114: actid);
115: raise;
116: end CreateRole;
117:

Line 416: 'fnd.plsql.UMX_LOGIN_HELP_PVT.start_workflow.begin',

412: begin
413:
414: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
415: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
416: 'fnd.plsql.UMX_LOGIN_HELP_PVT.start_workflow.begin',
417: 'p_user_name: ' || p_user_name ||
418: ' | p_email_address: ' || p_email_address ||
419: ' | p_role_name: ' || p_role_name );
420: end if;

Line 716: 'fnd.plsql.UMX_LOGIN_HELP_PVT.GenerateAuthKey.begin', '');

712: begin
713:
714: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
715: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
716: 'fnd.plsql.UMX_LOGIN_HELP_PVT.GenerateAuthKey.begin', '');
717: end if;
718:
719:
720: for j in 1..l_password_len loop

Line 736: 'fnd.plsql.UMX_LOGIN_HELP_PVT.GenerateAuthKey.end',

732: --dbms_random.terminate;
733:
734: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
735: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
736: 'fnd.plsql.UMX_LOGIN_HELP_PVT.GenerateAuthKey.end',
737: 'x_auth_key: ' || x_auth_key);
738: end if;
739:
740: return x_auth_key;

Line 789: Wf_Core.Context('UMX_LOGIN_HELP_PVT', 'GenAuthKey', itemtype, itemkey, actid);

785: resultout := WF_ENGINE.eng_completed || ':' || WF_ENGINE.eng_null;
786:
787: exception
788: when others then
789: Wf_Core.Context('UMX_LOGIN_HELP_PVT', 'GenAuthKey', itemtype, itemkey, actid);
790: raise;
791: end;
792:
793:

Line 868: Wf_Core.Context('UMX_LOGIN_HELP_PVT', 'GenUrl2ResetPwdPg', itemtype, itemkey, actid);

864: wf_engine.SetItemAttrText (itemtype => itemtype,
865: itemkey => itemkey,
866: aname => 'DEBUG_INFO',
867: avalue => to_char(actid));
868: Wf_Core.Context('UMX_LOGIN_HELP_PVT', 'GenUrl2ResetPwdPg', itemtype, itemkey, actid);
869: raise;
870: end GenUrl2ResetPwdPg;
871:
872: Procedure GenUrl2LoginPg(itemtype in varchar2,

Line 959: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidateResetPwdReq.begin',

955:
956: BEGIN
957: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
958: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
959: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidateResetPwdReq.begin',
960: ' | p_authkey: ' || p_authkey ||
961: ' | p_itemkey: ' || p_itemkey );
962: end if;
963:

Line 996: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidateResetPwdReq.end',

992:
993:
994: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
995: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
996: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidateResetPwdReq.end',
997: 'x_return_status: ' || x_return_status ||
998: 'x_message_name: ' || x_message_name );
999: end if;
1000:

Line 1011: 'Exception in fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePwdResetReq.end',

1007: end if;
1008:
1009: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
1010: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1011: 'Exception in fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePwdResetReq.end',
1012: 'x_return_status: ' || x_return_status ||
1013: 'x_message_name: ' || x_message_name ||
1014: fnd_message.get );
1015: end if;

Line 1039: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidateResetPwdReq.begin',

1035:
1036: BEGIN
1037: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1038: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1039: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidateResetPwdReq.begin',
1040: 'p_username: ' || p_username ||
1041: ' | p_authkey: ' || p_authkey ||
1042: ' | p_itemkey: ' || p_itemkey );
1043: end if;

Line 1078: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.ValidateResetPwdReq',

1074: x_return_status := 'E';
1075: x_message_name := 'UMX_RESET_PWD2_INVALID_UNAME';
1076: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) then
1077: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1078: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.ValidateResetPwdReq',
1079: 'failed');
1080: end if;
1081:
1082: decrementAttemptCounter( p_itemkey => p_itemKey,

Line 1096: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidateResetPwdReq.end',

1092: end if;
1093:
1094: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1095: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1096: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidateResetPwdReq.end',
1097: 'x_return_status: ' || x_return_status ||
1098: 'x_message_name: ' || x_message_name );
1099: end if;
1100:

Line 1111: 'Exception in fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePwdResetReq.end',

1107: end if;
1108:
1109: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
1110: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1111: 'Exception in fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePwdResetReq.end',
1112: 'x_return_status: ' || x_return_status ||
1113: 'x_message_name: ' || x_message_name ||
1114: fnd_message.get );
1115: end if;

Line 1131: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePassword.begin',

1127: begin
1128:
1129: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1130: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1131: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePassword.begin',
1132: 'p_username: ' || p_username ||' | x_password: ' || x_password);
1133: end if;
1134:
1135:

Line 1143: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePassword',

1139: -- Throw exception as even though generated password 100 times, but
1140: -- cannot pass validation criteria
1141: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
1142: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1143: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePassword',
1144: 'Validate Password failed.');
1145: end if;
1146: x_return_status := 'E';
1147: x_message_name := 'UMX_RESET_PWD2_VALID_FAIL';

Line 1152: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePassword',

1148: x_message_data := fnd_message.get;
1149: ELSE
1150: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
1151: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1152: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePassword',
1153: 'Validate Password success.');
1154: end if;
1155: x_return_status := 'S';
1156: x_message_name := 'UMX_RESET_PWD2_CONFIRM_MSG';

Line 1160: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePassword.end',

1156: x_message_name := 'UMX_RESET_PWD2_CONFIRM_MSG';
1157: END IF;
1158: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1159: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1160: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePassword.end',
1161: 'x_password: ' || x_password);
1162: end if;
1163:
1164: end;

Line 1215: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.begin',

1211:
1212: begin
1213: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1214: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1215: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.begin',
1216: 'p_username: ' || p_username || ' | p_password: ' || p_password);
1217: end if;
1218:
1219:

Line 1232: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.ValidateResetPwdReq',

1228:
1229: if ( x_return_status <> 'S' ) then
1230: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) then
1231: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1232: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.ValidateResetPwdReq',
1233: 'failed');
1234: end if;
1235: return;
1236: end if;

Line 1260: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.FND_USER_PKG.UpdateUserParty',

1256: x_return_status := 'E';
1257: x_message_name := 'UMX_RESET_PWD2_UNEXP_ERROR';
1258: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
1259: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1260: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.FND_USER_PKG.UpdateUserParty',
1261: 'x_no_attempts: ' || x_no_attempts ||
1262: 'x_return_status: ' || x_return_status ||
1263: ' | x_message_name: ' || x_message_name );
1264: end if;

Line 1270: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.end',

1266: end if;
1267:
1268: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1269: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1270: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.end',
1271: 'x_return_status: ' || x_return_status ||
1272: ' | x_message_name: ' || x_message_name );
1273: end if;
1274: EXCEPTION

Line 1296: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPassword.begin',

1292: begin
1293:
1294: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1295: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1296: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPassword.begin',
1297: 'p_username: ' || p_username ||
1298: ' | p_password: ' || p_password);
1299: end if;
1300:

Line 1318: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPassword.end',

1314: x_message_data => x_message_data);
1315:
1316: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1317: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1318: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPassword.end',
1319: 'x_return_status: ' || x_return_status ||
1320: ' | x_message_name: ' || x_message_name);
1321: end if;
1322:

Line 1339: 'fnd.plsql.UMX_LOGIN_HELP_PVT.CompleteActivity.begin',

1335:
1336: x_return_status := 'S';
1337: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1338: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1339: 'fnd.plsql.UMX_LOGIN_HELP_PVT.CompleteActivity.begin',
1340: ' p_itemkey: ' || p_itemKey );
1341: end if;
1342:
1343: l_role_name := WF_ENGINE.GetItemAttrText (

Line 1365: 'fnd.plsql.UMX_LOGIN_HELP_PVT.CompleteActivity.end',

1361: x_return_status := 'S';
1362:
1363: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1364: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1365: 'fnd.plsql.UMX_LOGIN_HELP_PVT.CompleteActivity.end',
1366: 'x_return_status: ' || x_return_status ||
1367: ' | x_message_name: ' || x_message_name);
1368: end if;
1369: EXCEPTION

Line 1376: END UMX_LOGIN_HELP_PVT;

1372: x_message_name := 'UMX_RESET_PWD2_UNEXP_ERROR';
1373:
1374: end CompleteActivity;
1375:
1376: END UMX_LOGIN_HELP_PVT;