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.7.12020000.5 2013/03/13 10:45:17 avelu 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 421: 'fnd.plsql.UMX_LOGIN_HELP_PVT.start_workflow.begin',

417: begin
418:
419: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
420: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
421: 'fnd.plsql.UMX_LOGIN_HELP_PVT.start_workflow.begin',
422: 'p_user_name: ' || p_user_name ||
423: ' | p_email_address: ' || p_email_address ||
424: ' | p_role_name: ' || p_role_name );
425: end if;

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

736: begin
737:
738: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
739: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
740: 'fnd.plsql.UMX_LOGIN_HELP_PVT.GenerateAuthKey.begin', '');
741: end if;
742:
743:
744: for j in 1..l_password_len loop

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

756: --dbms_random.terminate;
757:
758: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
759: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
760: 'fnd.plsql.UMX_LOGIN_HELP_PVT.GenerateAuthKey.end',
761: 'x_auth_key: ' || x_auth_key);
762: end if;
763:
764: return x_auth_key;

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

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);
814: raise;
815: end;
816:
817:

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

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);
893: raise;
894: end GenUrl2ResetPwdPg;
895:
896: Procedure GenUrl2LoginPg(itemtype in varchar2,

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

978:
979: BEGIN
980: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
981: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
982: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidateResetPwdReq.begin',
983: ' | p_authkey: ' || p_authkey ||
984: ' | p_itemkey: ' || p_itemkey );
985: end if;
986:

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

1014:
1015:
1016: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1017: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1018: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidateResetPwdReq.end',
1019: 'x_return_status: ' || x_return_status ||
1020: 'x_message_name: ' || x_message_name );
1021: end if;
1022:

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

1029: end if;
1030:
1031: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
1032: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1033: 'Exception in fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePwdResetReq.end',
1034: 'x_return_status: ' || x_return_status ||
1035: 'x_message_name: ' || x_message_name ||
1036: fnd_message.get );
1037: end if;

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

1058:
1059: BEGIN
1060: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1061: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1062: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidateResetPwdReq.begin',
1063: 'p_username: ' || p_username ||
1064: ' | p_authkey: ' || p_authkey ||
1065: ' | p_itemkey: ' || p_itemkey );
1066: end if;

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

1097: x_return_status := 'E';
1098: x_message_name := 'UMX_RESET_PWD2_INVALID_UNAME';
1099: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) then
1100: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1101: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.ValidateResetPwdReq',
1102: 'failed');
1103: end if;
1104: decrementAttemptCounter( p_itemkey => p_itemKey,
1105: x_no_attempts => x_no_attempts);

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

1113: end if;
1114:
1115: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1116: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1117: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidateResetPwdReq.end',
1118: 'x_return_status: ' || x_return_status ||
1119: 'x_message_name: ' || x_message_name );
1120: end if;
1121:

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

1128: end if;
1129:
1130: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
1131: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1132: 'Exception in fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePwdResetReq.end',
1133: 'x_return_status: ' || x_return_status ||
1134: 'x_message_name: ' || x_message_name ||
1135: fnd_message.get );
1136: end if;

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

1148: begin
1149:
1150: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1151: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1152: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePassword.begin',
1153: 'p_username: ' || p_username ||' | x_password: ' || x_password);
1154: end if;
1155:
1156:

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

1160: -- Throw exception as even though generated password 100 times, but
1161: -- cannot pass validation criteria
1162: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
1163: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1164: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePassword',
1165: 'Validate Password failed.');
1166: end if;
1167: x_return_status := 'E';
1168: x_message_name := 'UMX_RESET_PWD2_VALID_FAIL';

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

1169: x_message_data := fnd_message.get;
1170: ELSE
1171: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
1172: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1173: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePassword',
1174: 'Validate Password success.');
1175: end if;
1176: x_return_status := 'S';
1177: x_message_name := 'UMX_RESET_PWD2_CONFIRM_MSG';

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

1177: x_message_name := 'UMX_RESET_PWD2_CONFIRM_MSG';
1178: END IF;
1179: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1180: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1181: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ValidatePassword.end',
1182: 'x_password: ' || x_password);
1183: end if;
1184:
1185: end;

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

1231:
1232: begin
1233: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1234: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1235: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.begin',
1236: 'p_username: ' || p_username || ' | p_password: ' || p_password);
1237: end if;
1238:
1239:

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

1248:
1249: if ( x_return_status <> 'S' ) then
1250: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) then
1251: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1252: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.ValidateResetPwdReq',
1253: 'failed');
1254: end if;
1255: return;
1256: end if;

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

1276: x_return_status := 'E';
1277: x_message_name := 'UMX_RESET_PWD2_UNEXP_ERROR';
1278: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
1279: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1280: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.FND_USER_PKG.UpdateUserParty',
1281: 'x_no_attempts: ' || x_no_attempts ||
1282: 'x_return_status: ' || x_return_status ||
1283: ' | x_message_name: ' || x_message_name );
1284: end if;

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

1286: end if;
1287:
1288: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1289: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1290: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPwdPvt.end',
1291: 'x_return_status: ' || x_return_status ||
1292: ' | x_message_name: ' || x_message_name );
1293: end if;
1294: EXCEPTION

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

1312: begin
1313:
1314: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1315: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1316: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPassword.begin',
1317: 'p_username: ' || p_username ||
1318: ' | p_password: ' || p_password);
1319: end if;
1320:

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

1334: x_message_data => x_message_data);
1335:
1336: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1337: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1338: 'fnd.plsql.UMX_LOGIN_HELP_PVT.ResetPassword.end',
1339: 'x_return_status: ' || x_return_status ||
1340: ' | x_message_name: ' || x_message_name);
1341: end if;
1342:

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

1355:
1356: x_return_status := 'S';
1357: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1358: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
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 (

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

1381: x_return_status := 'S';
1382:
1383: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1384: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1385: 'fnd.plsql.UMX_LOGIN_HELP_PVT.CompleteActivity.end',
1386: 'x_return_status: ' || x_return_status ||
1387: ' | x_message_name: ' || x_message_name);
1388: end if;
1389: EXCEPTION

Line 1396: END UMX_LOGIN_HELP_PVT;

1392: x_message_name := 'UMX_RESET_PWD2_UNEXP_ERROR';
1393:
1394: end CompleteActivity;
1395:
1396: END UMX_LOGIN_HELP_PVT;