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 FND_LOG

Line 221: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

217: AND fu.user_name = p_user_name;
218:
219: begin
220:
221: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
222: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
223: 'fnd.plsql.UMXVUPWB.get_email_address.begin',
224: 'p_user_name: ' || p_user_name);
225: end if;

Line 222: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

218:
219: begin
220:
221: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
222: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
223: 'fnd.plsql.UMXVUPWB.get_email_address.begin',
224: 'p_user_name: ' || p_user_name);
225: end if;
226:

Line 239: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

235: open get_fnd_email (p_user_name);
236: fetch get_fnd_email into x_email_address;
237: if (get_fnd_email%NOTFOUND) then
238: x_message_name := 'UMX_LOGIN_HELP_UNEXP_ERROR';
239: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
240: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
241: 'fnd.plsql.UMXVUPWB.get_email_address',
242: 'UMX_LOGIN_HELP_INVALID_ACCT');
243: end if;

Line 240: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

236: fetch get_fnd_email into x_email_address;
237: if (get_fnd_email%NOTFOUND) then
238: x_message_name := 'UMX_LOGIN_HELP_UNEXP_ERROR';
239: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
240: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
241: 'fnd.plsql.UMXVUPWB.get_email_address',
242: 'UMX_LOGIN_HELP_INVALID_ACCT');
243: end if;
244: --fnd_message.set_name('FND', x_message_name);

Line 259: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

255: end if;
256: close get_fnd_email;
257: end if;
258:
259: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
260: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
261: 'fnd.plsql.UMXVUPWB.get_email_address.end',
262: 'x_role_name: ' || x_role_name ||
263: ' | x_email_address: ' || x_email_address ||

Line 260: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

256: close get_fnd_email;
257: end if;
258:
259: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
260: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
261: 'fnd.plsql.UMXVUPWB.get_email_address.end',
262: 'x_role_name: ' || x_role_name ||
263: ' | x_email_address: ' || x_email_address ||
264: ' | x_message_name: ' || x_message_name);

Line 298: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

294:
295:
296: begin
297:
298: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
299: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
300: 'fnd.plsql.UMXVUPWB.find_user_w_email.begin',
301: 'p_email: ' || p_email);
302: end if;

Line 299: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

295:
296: begin
297:
298: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
299: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
300: 'fnd.plsql.UMXVUPWB.find_user_w_email.begin',
301: 'p_email: ' || p_email);
302: end if;
303:

Line 334: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) 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
335: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
336: 'fnd.plsql.UMXVUPWB.find_user_w_email.end',
337: 'x_role_name: ' || x_role_name ||
338: ' | x_user_name: ' || x_user_name ||

Line 335: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

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
335: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
336: 'fnd.plsql.UMXVUPWB.find_user_w_email.end',
337: 'x_role_name: ' || x_role_name ||
338: ' | x_user_name: ' || x_user_name ||
339: ' | x_message_name: ' || x_message_name);

Line 372: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

368:
369:
370: begin
371:
372: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
373: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
374: 'fnd.plsql.UMXVUPWB.find_users_w_email.begin',
375: 'p_email: ' || p_email);
376: end if;

Line 373: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

369:
370: begin
371:
372: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
373: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
374: 'fnd.plsql.UMXVUPWB.find_users_w_email.begin',
375: 'p_email: ' || p_email);
376: end if;
377:

Line 400: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

396: i := i + 1;
397: end loop;
398: end if;
399:
400: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
401: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
402: 'fnd.plsql.UMXVUPWB.find_users_w_email.end',
403: ' | l_user_name: ' || l_user_name );
404: end if;

Line 401: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

397: end loop;
398: end if;
399:
400: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
401: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
402: 'fnd.plsql.UMXVUPWB.find_users_w_email.end',
403: ' | l_user_name: ' || l_user_name );
404: end if;
405:

Line 419: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

415: p_notification_preference in varchar2,
416: x_itemkey out nocopy varchar2) is
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 ||

Line 420: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

416: x_itemkey out nocopy varchar2) is
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 );

Line 472: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

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,
474: 'fnd.plsql.UMXVUPWB.start_workflow.end',
475: 'x_itemkey: ' || x_itemkey);
476: end if;

Line 473: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

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,
474: 'fnd.plsql.UMXVUPWB.start_workflow.end',
475: 'x_itemkey: ' || x_itemkey);
476: end if;
477:

Line 502: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

498:
499:
500: begin
501:
502: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
503: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
504: 'fnd.plsql.UMXVUPWB.ForgottenPwdPvt.begin',
505: 'p_username: ' || p_username );
506: end if;

Line 503: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

499:
500: begin
501:
502: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
503: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
504: 'fnd.plsql.UMXVUPWB.ForgottenPwdPvt.begin',
505: 'p_username: ' || p_username );
506: end if;
507:

Line 539: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

535: x_return_status := FND_API.G_RET_STS_SUCCESS;
536: x_message_name := 'UMX_LOGIN_HELP_SUB_SUC_MSG_1';
537: end if;
538: else -- email address is null
539: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
540: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
541: 'fnd.plsql.UMXVUPWB.ResetPwdPvt', 'UMX_LOGIN_HELP_NULL_EMAIL');
542: end if;
543: x_message_name := 'UMX_LOGIN_HELP_UNEXP_ERROR';

Line 540: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

536: x_message_name := 'UMX_LOGIN_HELP_SUB_SUC_MSG_1';
537: end if;
538: else -- email address is null
539: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
540: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
541: 'fnd.plsql.UMXVUPWB.ResetPwdPvt', 'UMX_LOGIN_HELP_NULL_EMAIL');
542: end if;
543: x_message_name := 'UMX_LOGIN_HELP_UNEXP_ERROR';
544: end if;

Line 547: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

543: x_message_name := 'UMX_LOGIN_HELP_UNEXP_ERROR';
544: end if;
545: end if;
546: else -- cannot change password for this user
547: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
548: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
549: 'fnd.plsql.UMXVUPWB.ResetPwdPvt', 'UMX_LOGIN_HELP_PWD_EXTERNAL');
550: end if;
551: x_message_name := 'UMX_LOGIN_HELP_UNEXP_ERROR';

Line 548: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

544: end if;
545: end if;
546: else -- cannot change password for this user
547: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
548: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
549: 'fnd.plsql.UMXVUPWB.ResetPwdPvt', 'UMX_LOGIN_HELP_PWD_EXTERNAL');
550: end if;
551: x_message_name := 'UMX_LOGIN_HELP_UNEXP_ERROR';
552: end if;

Line 554: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

550: end if;
551: x_message_name := 'UMX_LOGIN_HELP_UNEXP_ERROR';
552: end if;
553:
554: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
555: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
556: 'fnd.plsql.UMXVUPWB.ResetPwdPvt.end',
557: 'x_return_status: ' || x_return_status ||
558: ' | x_message_name: ' || x_message_name);

Line 555: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

551: x_message_name := 'UMX_LOGIN_HELP_UNEXP_ERROR';
552: end if;
553:
554: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
555: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
556: 'fnd.plsql.UMXVUPWB.ResetPwdPvt.end',
557: 'x_return_status: ' || x_return_status ||
558: ' | x_message_name: ' || x_message_name);
559: end if;

Line 564: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

560: EXCEPTION
561: when FND_SSO_MANAGER.userNotFound then
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563: --x_message_name := 'UMX_FORGOT_PWD_UNEXP_ERR_MSG';
564: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
565: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
566: 'fnd.plsql.UMXVUPWB.ResetPwdPvt', 'UMX_LOGIN_HELP_INVALID_ACCT');
567: end if;
568: x_message_name := 'UMX_LOGIN_HELP_UNEXP_ERROR';

Line 565: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

561: when FND_SSO_MANAGER.userNotFound then
562: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
563: --x_message_name := 'UMX_FORGOT_PWD_UNEXP_ERR_MSG';
564: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
565: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
566: 'fnd.plsql.UMXVUPWB.ResetPwdPvt', 'UMX_LOGIN_HELP_INVALID_ACCT');
567: end if;
568: x_message_name := 'UMX_LOGIN_HELP_UNEXP_ERROR';
569:

Line 578: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

574: x_return_status out NOCOPY varchar2,
575: x_message_name out NOCOPY varchar2) is
576: begin
577:
578: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
579: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
580: 'fnd.plsql.UMXVUPWB.ForgottenPwdPvt.begin',
581: 'p_username: ' || p_username
582: );

Line 579: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

575: x_message_name out NOCOPY varchar2) is
576: begin
577:
578: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
579: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
580: 'fnd.plsql.UMXVUPWB.ForgottenPwdPvt.begin',
581: 'p_username: ' || p_username
582: );
583: end if;

Line 591: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

587: x_return_status => x_return_status,
588: x_message_name => x_message_name);
589:
590:
591: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
592: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
593: 'fnd.plsql.UMXVUPWB.ForgottenPwdPvt.end',
594: 'x_return_status: ' || x_return_status ||
595: ' | x_message_name: ' || x_message_name);

Line 592: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

588: x_message_name => x_message_name);
589:
590:
591: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
592: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
593: 'fnd.plsql.UMXVUPWB.ForgottenPwdPvt.end',
594: 'x_return_status: ' || x_return_status ||
595: ' | x_message_name: ' || x_message_name);
596: end if;

Line 625: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

621: l_too_many_prev_reqs boolean := false;
622:
623: begin
624:
625: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
626: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
627: 'fnd.plsql.UMXVUPWB.ForgottenUnamePvt.begin',
628: 'p_email: ' || p_email );
629: end if;

Line 626: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

622:
623: begin
624:
625: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
626: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
627: 'fnd.plsql.UMXVUPWB.ForgottenUnamePvt.begin',
628: 'p_email: ' || p_email );
629: end if;
630:

Line 641: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

637: i := l_user_list.first();
638: l_first := i;
639: if ( i is null ) then
640: x_return_status := FND_API.G_RET_STS_ERROR;
641: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
642: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
643: 'fnd.plsql.UMXVUPWB.ForgottenUnamePvt.begin',
644: 'UMX_LOGIN_HELP_NO_USER_FOUND' );
645: end if;

Line 642: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

638: l_first := i;
639: if ( i is null ) then
640: x_return_status := FND_API.G_RET_STS_ERROR;
641: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
642: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
643: 'fnd.plsql.UMXVUPWB.ForgottenUnamePvt.begin',
644: 'UMX_LOGIN_HELP_NO_USER_FOUND' );
645: end if;
646: x_message_name := 'UMX_RESET_PWD2_UNEXP_ERROR';

Line 687: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

683: END LOOP; --End of UserList Loop
684: END IF;
685:
686:
687: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
688: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
689: 'fnd.plsql.UMXLHLPB.ForgottenUnamePvt.end',
690: 'x_return_status: ' || x_return_status ||
691: ' | x_message_name: ' || x_message_name);

Line 688: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

684: END IF;
685:
686:
687: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
688: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
689: 'fnd.plsql.UMXLHLPB.ForgottenUnamePvt.end',
690: 'x_return_status: ' || x_return_status ||
691: ' | x_message_name: ' || x_message_name);
692: end if;

Line 707: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

703: x_return_status out NOCOPY varchar2,
704: x_message_name out NOCOPY varchar2) is
705: begin
706:
707: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
708: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
709: 'fnd.plsql.UMXVUPWB.ForgottenUname.begin',
710: 'p_email: ' || p_email
711: );

Line 708: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

704: x_message_name out NOCOPY varchar2) is
705: begin
706:
707: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
708: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
709: 'fnd.plsql.UMXVUPWB.ForgottenUname.begin',
710: 'p_email: ' || p_email
711: );
712: end if;

Line 720: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

716: x_return_status => x_return_status,
717: x_message_name => x_message_name);
718:
719:
720: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
721: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
722: 'fnd.plsql.UMXVUPWB.ForgottenPwdPvt.end',
723: 'x_return_status: ' || x_return_status ||
724: ' | x_message_name: ' || x_message_name);

Line 721: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

717: x_message_name => x_message_name);
718:
719:
720: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
721: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
722: 'fnd.plsql.UMXVUPWB.ForgottenPwdPvt.end',
723: 'x_return_status: ' || x_return_status ||
724: ' | x_message_name: ' || x_message_name);
725: end if;

Line 738: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

734: ascii_offset int := 65;
735:
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:

Line 739: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

735:
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:

Line 758: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

754:
755: -- terminate the random number generator
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;

Line 759: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

755: -- terminate the random number generator
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:

Line 833: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

829:
830:
831: begin
832:
833: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
834: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
835: 'fnd.plsql.UMXVUPWB.GenUrl2ResetPwdPg.begin', '');
836: end if;
837:

Line 834: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

830:
831: begin
832:
833: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
834: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
835: 'fnd.plsql.UMXVUPWB.GenUrl2ResetPwdPg.begin', '');
836: end if;
837:
838: if (funcmode = 'RUN') then

Line 880: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

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',
883: 'l_url: ' || l_url);
884: end if;

Line 881: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

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',
883: 'l_url: ' || l_url);
884: end if;
885:

Line 904: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

900: resultout in out NOCOPY varchar2) is
901: l_url varchar2(32000);
902: begin
903:
904: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
905: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
906: 'fnd.plsql.UMXVUPWB.GenUrl2LoginPg.begin', '');
907: end if;
908:

Line 905: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

901: l_url varchar2(32000);
902: begin
903:
904: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
905: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
906: 'fnd.plsql.UMXVUPWB.GenUrl2LoginPg.begin', '');
907: end if;
908:
909: if (funcmode = 'RUN') then

Line 921: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

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,
923: 'fnd.plsql.UMXVUPWB.GenUrl2LoginPg.end',
924: 'l_url: ' || l_url);
925: end if;

Line 922: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

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,
923: 'fnd.plsql.UMXVUPWB.GenUrl2LoginPg.end',
924: 'l_url: ' || l_url);
925: end if;
926:

Line 938: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

934: resultout in out NOCOPY varchar2) is
935: l_user_name fnd_user.user_name%type;
936: begin
937:
938: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
939: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
940: 'fnd.plsql.UMXVUPWB.DisableAccount.begin', '');
941: end if;
942:

Line 939: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

935: l_user_name fnd_user.user_name%type;
936: begin
937:
938: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
939: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
940: 'fnd.plsql.UMXVUPWB.DisableAccount.begin', '');
941: end if;
942:
943: if (funcmode = 'RUN') then

Line 957: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

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,
959: 'fnd.plsql.UMXVUPWB.DisableAccount.end',
960: 'l_user_name: ' || l_user_name);
961: end if;

Line 958: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

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,
959: 'fnd.plsql.UMXVUPWB.DisableAccount.end',
960: 'l_user_name: ' || l_user_name);
961: end if;
962:

Line 980: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

976: l_item_status varchar2(8);
977: l_item_result varchar2(30);
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 );

Line 981: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

977: l_item_result varchar2(30);
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;

Line 1016: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1012: return;
1013: end if;
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 );

Line 1017: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1013: end if;
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;

Line 1031: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then

1027: if ( x_message_name is null ) then
1028: x_message_name := 'UMX_RESET_PWD2_VALID_FAILED';
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 ||

Line 1032: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,

1028: x_message_name := 'UMX_RESET_PWD2_VALID_FAILED';
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 );

Line 1060: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1056: l_item_status varchar2(8);
1057: l_item_result varchar2(30);
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 ||

Line 1061: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1057: l_item_result varchar2(30);
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 );

Line 1099: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) then

1095:
1096: if ( l_user_name <> p_username ) then
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;

Line 1100: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1096: if ( l_user_name <> p_username ) then
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,

Line 1115: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1111: x_message_name := 'UMX_LOGIN_HELP_PWD_EXTERNAL';
1112: return;
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 );

Line 1116: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1112: return;
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;

Line 1130: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then

1126: if ( x_message_name is null ) then
1127: x_message_name := 'UMX_RESET_PWD2_VALID_FAILED';
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 ||

Line 1131: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,

1127: x_message_name := 'UMX_RESET_PWD2_VALID_FAILED';
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 );

Line 1150: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1146: IS
1147: l_result varchar2(10);
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;

Line 1151: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1147: l_result varchar2(10);
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:

Line 1162: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then

1158:
1159: IF ( l_result <> 'Y' ) THEN
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;

Line 1163: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,

1159: IF ( l_result <> 'Y' ) THEN
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';

Line 1171: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then

1167: x_return_status := 'E';
1168: x_message_name := 'UMX_RESET_PWD2_VALID_FAIL';
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;

Line 1172: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,

1168: x_message_name := 'UMX_RESET_PWD2_VALID_FAIL';
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';

Line 1179: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1175: end if;
1176: x_return_status := 'S';
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;

Line 1180: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1176: x_return_status := 'S';
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:

Line 1233: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1229: l_item_status varchar2(8);
1230: l_item_result varchar2(30);
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;

Line 1234: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1230: l_item_result varchar2(30);
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:

Line 1250: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_STATEMENT) then

1246: x_return_status => x_return_status,
1247: x_message_name => x_message_name );
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;

Line 1251: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1247: x_message_name => x_message_name );
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;

Line 1278: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then

1274: EXCEPTION
1275: when others then
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 ||

Line 1279: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,

1275: when others then
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 );

Line 1288: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1284: end if;
1285: 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 );

Line 1289: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1285: 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;

Line 1314: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1310: x_message_data out NOCOPY varchar2) is
1311:
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);

Line 1315: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1311:
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;

Line 1336: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1332: x_return_status => x_return_status,
1333: x_message_name => x_message_name,
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);

Line 1337: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1333: x_message_name => x_message_name,
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;

Line 1357: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1353: l_orig_system_id wf_local_roles.orig_system_id%type;
1354: 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;

Line 1358: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1354: 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:

Line 1383: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1379: cascade => true);
1380:
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);

Line 1384: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1380:
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;