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_REG_REQUESTS_PVT dependencies on FND_USER_PKG

Line 366: -- 1) Call fnd_user_pkg.reserve_username API to reserve

362: -- Function : reserve_username
363: -- Type : Private
364: -- Pre_reqs : None
365: -- Description : This API will ...
366: -- 1) Call fnd_user_pkg.reserve_username API to reserve
367: -- the requested username.
368: -- 2) Update the UMX_REG_REQUESTS table with the
369: -- requested for username and requested by username
370: -- (if requested by is null).

Line 435: 'Before calling fnd_user_pkg.CreatePendingUser');

431: -- Still waiting for their true implementation from the proposal
432: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
433: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
434: 'fnd.plsql.UMXVRRSB.reserve_username',
435: 'Before calling fnd_user_pkg.CreatePendingUser');
436: end if;
437:
438: l_user_id := fnd_user_pkg.CreatePendingUser (
439: x_user_name => p_username,

Line 438: l_user_id := fnd_user_pkg.CreatePendingUser (

434: 'fnd.plsql.UMXVRRSB.reserve_username',
435: 'Before calling fnd_user_pkg.CreatePendingUser');
436: end if;
437:
438: l_user_id := fnd_user_pkg.CreatePendingUser (
439: x_user_name => p_username,
440: x_owner => p_owner,
441: x_unencrypted_password => p_unencrypted_password,
442: x_session_number => p_session_number,

Line 444: x_password_date => nvl (p_password_date, fnd_user_pkg.null_date),

440: x_owner => p_owner,
441: x_unencrypted_password => p_unencrypted_password,
442: x_session_number => p_session_number,
443: x_description => p_description,
444: x_password_date => nvl (p_password_date, fnd_user_pkg.null_date),
445: x_password_accesses_left => p_password_accesses_left,
446: x_password_lifespan_accesses => p_password_lifespan_accesses,
447: x_password_lifespan_days => p_password_lifespan_days,
448: x_email_address => p_email_address,

Line 455: 'After calling fnd_user_pkg.CreatePendingUser');

451:
452: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
453: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
454: 'fnd.plsql.UMXVRRSB.reserve_username',
455: 'After calling fnd_user_pkg.CreatePendingUser');
456: end if;
457:
458: -- Find who is the requested_by_user_id. If it is null, then
459: -- we need to update the new user_id to the requested_by_user_id as well.

Line 497: -- fnd_user_pkg.activate_user_account.

493: -- Type : Private
494: -- Pre_reqs : None
495: -- Description : This API will ...
496: -- 1) Activiate the user account by calling
497: -- fnd_user_pkg.activate_user_account.
498: -- 2) Set the status code to "APPROVED" in
499: -- UMX_REG_REQUESTS table.
500: --
501: -- This API should be called from Self-Service Registration or

Line 546: fnd_user_pkg.EnableUser (

542: ' | endDate: ' || p_end_date);
543: end if;
544:
545: -- Call FND's activate_user_account API to activate the user account.
546: fnd_user_pkg.EnableUser (
547: username => p_username,
548: start_date => nvl (p_start_date, sysdate),
549: end_date => nvl (p_end_date, fnd_user_pkg.null_date));
550:

Line 549: end_date => nvl (p_end_date, fnd_user_pkg.null_date));

545: -- Call FND's activate_user_account API to activate the user account.
546: fnd_user_pkg.EnableUser (
547: username => p_username,
548: start_date => nvl (p_start_date, sysdate),
549: end_date => nvl (p_end_date, fnd_user_pkg.null_date));
550:
551: -- Need to update the Person Party's ID in the FND_USER table
552: fnd_user_pkg.UpdateUserParty (
553: x_user_name => p_username,

Line 552: fnd_user_pkg.UpdateUserParty (

548: start_date => nvl (p_start_date, sysdate),
549: end_date => nvl (p_end_date, fnd_user_pkg.null_date));
550:
551: -- Need to update the Person Party's ID in the FND_USER table
552: fnd_user_pkg.UpdateUserParty (
553: x_user_name => p_username,
554: x_owner => NULL,
555: x_person_party_id => p_person_party_id);
556:

Line 576: -- fnd_user_pkg.release_username API.

572: -- Type : Private
573: -- Pre_reqs : None
574: -- Description : This API will ...
575: -- 1) Release the username by calling
576: -- fnd_user_pkg.release_username API.
577: -- 2) Set the status code to "REJECT" or "CANCELLED" in
578: -- UMX_REG_REQUESTS table.
579: -- 3) Remove the REQUESTED_FOR_USER_ID
580: -- 4) If the REQUESTED_BY_USER_ID is the same as the

Line 625: 'Before calling fnd_user_pkg.RemovePendingUser');

621: ' | userId: ' || p_user_id ||
622: ' | statusCode: ' || p_status_code);
623: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
624: 'fnd.plsql.UMXVRRSB.reject_cancel_username_reg_req.begin',
625: 'Before calling fnd_user_pkg.RemovePendingUser');
626: end if;
627:
628: -- Call FND's release_username API to release/delete the username
629: fnd_user_pkg.RemovePendingUser (username => p_username);

Line 629: fnd_user_pkg.RemovePendingUser (username => p_username);

625: 'Before calling fnd_user_pkg.RemovePendingUser');
626: end if;
627:
628: -- Call FND's release_username API to release/delete the username
629: fnd_user_pkg.RemovePendingUser (username => p_username);
630:
631: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
632: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
633: 'fnd.plsql.UMXVRRSB.reject_cancel_username_reg_req.begin',

Line 634: 'After calling fnd_user_pkg.RemovePendingUser');

630:
631: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
632: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
633: 'fnd.plsql.UMXVRRSB.reject_cancel_username_reg_req.begin',
634: 'After calling fnd_user_pkg.RemovePendingUser');
635: end if;
636:
637: -- Query the requested_by_user_id from UMX_reg_requests table
638: -- If the requested_by_user_id is equal to the requested_for_user_id,