DBA Data[Home] [Help]

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 550: fnd_user_pkg.EnableUser (

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

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

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

Line 556: fnd_user_pkg.UpdateUserParty (

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

Line 612: fnd_user_pkg.UpdateUser (x_user_name =>p_username, x_owner => NULL , x_employee_id =>pid);

608: END;
609: -- Changes for employee security attributes ( For HRMS Employee) + for future employee bug#7460262
610: -- calling UpdateUser would populate default security attributes, but for this customer one-off we
611: -- are explicitily inserting them. The insert commands should be removed for next releases
612: fnd_user_pkg.UpdateUser (x_user_name =>p_username, x_owner => NULL , x_employee_id =>pid);
613: eid :=pid;
614: END IF;
615: -- Changes for employee security attributes ( For HRMS Employee)
616: -- populate both the default security attributes with employee_id as value.

Line 724: -- fnd_user_pkg.release_username API.

720: -- Type : Private
721: -- Pre_reqs : None
722: -- Description : This API will ...
723: -- 1) Release the username by calling
724: -- fnd_user_pkg.release_username API.
725: -- 2) Set the status code to "REJECT" or "CANCELLED" in
726: -- UMX_REG_REQUESTS table.
727: -- 3) Remove the REQUESTED_FOR_USER_ID
728: -- 4) If the REQUESTED_BY_USER_ID is the same as the

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

769: ' | userId: ' || p_user_id ||
770: ' | statusCode: ' || p_status_code);
771: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
772: 'fnd.plsql.UMXVRRSB.reject_cancel_username_reg_req.begin',
773: 'Before calling fnd_user_pkg.RemovePendingUser');
774: end if;
775:
776: -- Call FND's release_username API to release/delete the username
777: fnd_user_pkg.RemovePendingUser (username => p_username);

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

773: 'Before calling fnd_user_pkg.RemovePendingUser');
774: end if;
775:
776: -- Call FND's release_username API to release/delete the username
777: fnd_user_pkg.RemovePendingUser (username => p_username);
778:
779: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
780: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
781: 'fnd.plsql.UMXVRRSB.reject_cancel_username_reg_req.begin',

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

778:
779: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
780: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
781: 'fnd.plsql.UMXVRRSB.reject_cancel_username_reg_req.begin',
782: 'After calling fnd_user_pkg.RemovePendingUser');
783: end if;
784:
785: -- Query the requested_by_user_id from UMX_reg_requests table
786: -- If the requested_by_user_id is equal to the requested_for_user_id,