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.FND_USER_PKG dependencies on APP_EXCEPTION

Line 99: app_exception.raise_exception;

95: reason := fnd_message.get;
96: fnd_message.set_name('FND', 'LDAP_WRAPPER_CREATE_USER_FAIL');
97: fnd_message.set_token('USER_NAME', x_user_name);
98: fnd_message.set_token('REASON', reason);
99: app_exception.raise_exception;
100: end if;
101:
102: exception
103: when others then

Line 107: app_exception.raise_exception;

103: when others then
104: fnd_message.set_name('FND', 'LDAP_WRAPPER_CREATE_USER_FAIL');
105: fnd_message.set_token('USER_NAME', x_user_name);
106: fnd_message.set_token('REASON', sqlerrm);
107: app_exception.raise_exception;
108: end;
109:
110: ----------------------------------------------------------------------^M
111: --

Line 244: app_exception.raise_exception;

240: if (l_user_id = 6) then
241: if (x_start_date > sysdate) then
242: -- throw the error message SECURITY-GUEST START DATE
243: fnd_message.set_name('FND', 'SECURITY-GUEST START DATE');
244: app_exception.raise_exception;
245: else
246: l_start_date := x_start_date;
247: end if;
248: else

Line 327: app_exception.raise_exception;

323: exception
324: when others then
325: fnd_message.set_name('FND', 'FND_INVALID_USER');
326: fnd_message.set_token('USER_NAME', X_USER_NAME);
327: app_exception.raise_exception;
328: end;
329:
330: -- PARTY
331: if (x_mode = 'PARTY') then

Line 458: app_exception.raise_exception;

454: reason := fnd_message.get();
455: fnd_message.set_name('FND', 'FND_CHANGE_PASSWORD_FAILED');
456: fnd_message.set_token('USER_NAME', X_USER_NAME);
457: fnd_message.set_token('REASON', reason);
458: app_exception.raise_exception;
459: end if;
460: end if;
461:
462: -- Bug 8227171 UpdateUserInternal

Line 479: app_exception.raise_exception;

475: fnd_message.set_encoded(reason);
476: else
477: fnd_message.set_name('FND', 'FND_CREATE_A_SYNCH_MSG');
478: end if;
479: app_exception.raise_exception;
480: end;
481:
482: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
483: fnd_log.string(FND_LOG.LEVEL_STATEMENT,

Line 522: app_exception.raise_exception;

518:
519: if (SQL%NOTFOUND) then
520: fnd_message.set_name('FND', 'FND_INVALID_USER');
521: fnd_message.set_token('USER_NAME', X_USER_NAME);
522: app_exception.raise_exception;
523: else
524: -- bug 8227171 relocated the user_id fetch higher up.
525: -- Added for Function Security Cache Invalidation
526: fnd_function_security_cache.update_user(l_user_id);

Line 567: app_exception.raise_exception;

563: fnd_message.set_name('FND', 'FND_USER_UPDATE_FAILED');
564: fnd_message.set_token('USERNAME', X_USER_NAME);
565: fnd_message.set_token('USERID', l_user_id);
566: fnd_message.set_token('REASON', reason);
567: app_exception.raise_exception;
568: end;
569: end if;
570: -- End bug 4318754, 4424225
571:

Line 909: app_exception.raise_exception;

905: fnd_message.set_encoded(reason);
906: else
907: fnd_message.set_name('FND', 'FND_RAISE_EVENT_FAILED');
908: end if;
909: app_exception.raise_exception;
910:
911: end;
912: end if;
913:

Line 1334: app_exception.raise_exception;

1330: reason := fnd_message.get();
1331: fnd_message.set_name('FND', 'FND_CREATE_USER_FAILED');
1332: fnd_message.set_token('USER_NAME', X_USER_NAME);
1333: fnd_message.set_token('REASON', reason);
1334: app_exception.raise_exception;
1335: end;
1336:
1337: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
1338: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

Line 1441: app_exception.raise_exception;

1437: fnd_message.set_encoded(reason);
1438: else
1439: fnd_message.set_name('FND', 'FND_RAISE_EVENT_FAILED');
1440: end if;
1441: app_exception.raise_exception;
1442: end;
1443:
1444: else -- fnd_web_sec.create_user must have failed.
1445: -- The java layer puts message onto the message stack.

Line 1450: app_exception.raise_exception;

1446: reason := fnd_message.get();
1447: fnd_message.set_name('FND', 'FND_CREATE_USER_FAILED');
1448: fnd_message.set_token('USER_NAME', X_USER_NAME);
1449: fnd_message.set_token('REASON', reason);
1450: app_exception.raise_exception;
1451: end if;
1452:
1453: return (user_id);
1454: end;

Line 1908: app_exception.raise_exception;

1904: else
1905: fnd_message.set_name('FND', 'FND_NO_PASSWORD_PROVIDED');
1906: fnd_message.set_token('USER_NAME', X_USER_NAME);
1907: fnd_message.set_token('ROUTINE', 'FND_USER_PKG.LOADUSER');
1908: app_exception.raise_exception;
1909: end if;
1910: end if;
1911: end LoadUser;
1912:

Line 2004: app_exception.raise_exception;

2000: else
2001: fnd_message.set_name('FND', 'FND_NO_PASSWORD_PROVIDED');
2002: fnd_message.set_token('USER_NAME', X_USER_NAME);
2003: fnd_message.set_token('ROUTINE', 'FND_USER_PKG.LOADUSER');
2004: app_exception.raise_exception;
2005: end if;
2006: end if;
2007: end LoadUserParty;
2008:

Line 2708: app_exception.raise_exception;

2704: fnd_message.set_name('FND', 'FND_FAILED_UPDATE_UNAME_CHILD');
2705: fnd_message.set_token('OLD_NAME', old_name);
2706: fnd_message.set_token('NEW_NAME', new_name);
2707: fnd_message.set_token('REASON', reason);
2708: app_exception.raise_exception;
2709: end UpdateUserNameChildren;
2710: --------------------------------------------------------------------------
2711: --
2712: -- user_synch - The centralized routine for communicating user changes

Line 2987: app_exception.raise_exception;

2983: fnd_message.set_name('FND', 'INVALID_RESPONSIBILITY_DATA');
2984: fnd_message.set_token('APPS_NAME', resp_app);
2985: fnd_message.set_token('RESP_KEY', resp_key);
2986: fnd_message.set_token('SECURITY_GROUP', security_group);
2987: app_exception.raise_exception;
2988: end;
2989:
2990: if (fnd_user_resp_groups_api.assignment_exists(
2991: userid, respid, appid, secid)) then

Line 3060: app_exception.raise_exception;

3056: fnd_message.set_name('FND', 'INVALID_RESPONSIBILITY_DATA');
3057: fnd_message.set_token('APPS_NAME', resp_app);
3058: fnd_message.set_token('RESP_KEY', resp_key);
3059: fnd_message.set_token('SECURITY_GROUP', security_group);
3060: app_exception.raise_exception;
3061: end;
3062:
3063: if (fnd_user_resp_groups_api.assignment_exists(
3064: userid, respid, appid, secid)) then

Line 3207: app_exception.raise_exception;

3203: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3204: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3205: c_log_head || l_api_name || '.not_in_hz_parties', FALSE);
3206: end if;
3207: app_exception.raise_exception;
3208: else
3209: return null;
3210: end if;
3211: end;

Line 3234: app_exception.raise_exception;

3230: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3231: c_log_head || l_api_name || '.not_in_hz_party_relationships',
3232: FALSE);
3233: end if;
3234: app_exception.raise_exception;
3235: else
3236: return null;
3237: end if;
3238: end;

Line 3251: app_exception.raise_exception;

3247: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3248: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3249: c_log_head || l_api_name || '.bad_party_type', FALSE);
3250: end if;
3251: app_exception.raise_exception;
3252: else
3253: return null;
3254: end if;
3255: end if;

Line 3284: app_exception.raise_exception;

3280: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3281: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3282: c_log_head || l_api_name || '.bad_empid', FALSE);
3283: end if;
3284: app_exception.raise_exception;
3285: else
3286: return null;
3287: end if;
3288: end;

Line 3311: app_exception.raise_exception;

3307: fnd_log.g_current_runtime_level) then
3308: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3309: c_log_head || l_api_name || '.cust_emp_mismatch', FALSE);
3310: end if;
3311: app_exception.raise_exception;
3312: end;
3313:
3314: begin
3315: FND_OAM_USER_INFO.HZ_PARTY_ID_TO_NAME(l_emp_person_party_id,

Line 3328: app_exception.raise_exception;

3324: fnd_log.g_current_runtime_level) then
3325: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3326: c_log_head || l_api_name || '.cust_emp_mismatch', FALSE);
3327: end if;
3328: app_exception.raise_exception;
3329: end;
3330:
3331: fnd_message.set_name('FND', 'USER_CUST_EMP_MISMATCH');
3332: fnd_message.set_token('USER', user_name);

Line 3341: app_exception.raise_exception;

3337: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3338: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3339: c_log_head || l_api_name || '.cust_emp_mismatch', FALSE);
3340: end if;
3341: app_exception.raise_exception;
3342: else
3343: return null;
3344: end if;
3345: end if;

Line 3417: app_exception.raise_exception;

3413: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3414: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3415: c_log_head || l_api_name || '.not_in_hz_parties', FALSE);
3416: end if;
3417: app_exception.raise_exception;
3418: end;
3419: if (l_party_type <> 'PERSON') then
3420: fnd_message.set_name('FND', 'USER_INVALID_PARTY_TYPE');
3421: fnd_message.set_token('USER', user_name);

Line 3428: app_exception.raise_exception;

3424: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3425: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3426: c_log_head || l_api_name || '.bad_party_type', FALSE);
3427: end if;
3428: app_exception.raise_exception;
3429: end if;
3430: end if;
3431:
3432: -- Set customer_id to new party_id

Line 3616: app_exception.raise_exception;

3612: end if;
3613:
3614: fnd_message.set_name('FND', 'FND_INVALID_USER');
3615: fnd_message.set_token('USER_NAME', username);
3616: app_exception.raise_exception;
3617: end;
3618:
3619: -- Bug 4318754. Synch up with SSO
3620: if (l_user_guid is not null) then

Line 3629: app_exception.raise_exception;

3625: end if;
3626:
3627: fnd_ldap_wrapper.delete_user(l_user_guid, retval);
3628: if (retval <> fnd_ldap_wrapper.G_SUCCESS) then
3629: app_exception.raise_exception;
3630: end if;
3631: exception
3632: when others then
3633: app_exception.raise_exception;

Line 3633: app_exception.raise_exception;

3629: app_exception.raise_exception;
3630: end if;
3631: exception
3632: when others then
3633: app_exception.raise_exception;
3634: end;
3635: end if;
3636:
3637: -- Only allow to delete a PENDING user

Line 3655: app_exception.raise_exception;

3651: 'This pending user does not exist');
3652: end if;
3653: fnd_message.set_name('FND', 'FND_INVALID_USER');
3654: fnd_message.set_token('USER_NAME', username);
3655: app_exception.raise_exception;
3656: else
3657:
3658: -- Added for Function Security Cache Invalidation
3659: fnd_function_security_cache.delete_user(l_user_id);

Line 3710: app_exception.raise_exception;

3706: exception
3707: when no_data_found then
3708: fnd_message.set_name('FND', 'FND_INVALID_PARTY');
3709: fnd_message.set_token('PARTY_NAME', x_party);
3710: app_exception.raise_exception;
3711: end;
3712:
3713: fnd_user_pkg.UpdateUserParty(x_user_name => x_user_name,
3714: x_owner => 'SEED',

Line 3742: app_exception.raise_exception;

3738: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
3739: reason := fnd_message.get();
3740: fnd_message.set_name('FND', 'LDAP_WRAPPER_CHANGE_USER_FAIL');
3741: fnd_message.set_token('REASON', reason);
3742: app_exception.raise_exception;
3743: end if;
3744: exception
3745: when others then
3746: fnd_message.set_name('FND', 'LDAP_WRAPPER_CHANGE_USER_FAIL');

Line 3748: app_exception.raise_exception;

3744: exception
3745: when others then
3746: fnd_message.set_name('FND', 'LDAP_WRAPPER_CHANGE_USER_FAIL');
3747: fnd_message.set_token('REASON', sqlerrm);
3748: app_exception.raise_exception;
3749: end;
3750:
3751: -- begin bug 2504562
3752:

Line 3784: app_exception.raise_exception;

3780: begin
3781: -- 7311525 do not allow the username of GUEST to be changed
3782: if (upper(x_old_user_name) = 'GUEST') then
3783: fnd_message.set_name('FND', 'SECURITY-GUEST USERNAME');
3784: app_exception.raise_exception;
3785: end if;
3786:
3787: -- ensure x_old_user_name exists in fnd_user before we proceed
3788: select USER_GUID, encrypted_user_password

Line 3798: app_exception.raise_exception;

3794: -- ensure x_new_user_name doesn't already exist in fnd_user
3795: select null into dummy from fnd_user
3796: where user_name = upper(x_new_user_name);
3797: fnd_message.set_name('FND', 'SECURITY-DUPLICATE USER');
3798: app_exception.raise_exception;
3799: exception
3800: when no_data_found then
3801: -- bug 8227171 change_user_name
3802: validate_user_name(x_new_user_name);

Line 3821: app_exception.raise_exception;

3817: upper(x_new_user_name));
3818: end if;
3819: exception
3820: when others then
3821: app_exception.raise_exception;
3822: end;
3823: -- end bug 4625235
3824:
3825: end if;

Line 3884: app_exception.raise_exception;

3880: fnd_message.set_name('FND', 'FND_FAILED_WF_USER_SYNCH');
3881: fnd_message.set_token('OLD_NAME', x_old_user_name);
3882: fnd_message.set_token('NEW_NAME', x_new_user_name);
3883: fnd_message.set_token('REASON', reason);
3884: app_exception.raise_exception;
3885: end;
3886:
3887: -- Added for bug 4676568
3888: -- A temp fix to update fnd_grants.grantee_key

Line 3921: app_exception.raise_exception;

3917: fnd_message.set_encoded(reason);
3918: else
3919: fnd_message.set_name('FND', 'FND_RAISE_EVENT_FAILED');
3920: end if;
3921: app_exception.raise_exception;
3922: end;
3923: end;
3924:
3925: exception

Line 3930: app_exception.raise_exception;

3926: when no_data_found then
3927: -- old username does not exist in fnd_user
3928: fnd_message.set_name('FND', 'FND_CHANGE_USER_FAILED');
3929: fnd_message.set_token('USER_NAME', x_old_user_name);
3930: app_exception.raise_exception;
3931:
3932:
3933: end change_user_name;
3934:

Line 4015: app_exception.raise_exception;

4011: begin
4012: if (x_user_name is null or
4013: rtrim(x_user_name, ' ') is null) then
4014: fnd_message.set_name('FND', 'INVALID_USER_NAME_NULL');
4015: app_exception.raise_exception;
4016: elsif (rtrim(x_user_name, ' ') <> x_user_name or
4017: ltrim(x_user_name, ' ') <> x_user_name) then
4018: fnd_message.set_name('FND', 'INVALID_USER_NAME_SPACE');
4019: app_exception.raise_exception;

Line 4019: app_exception.raise_exception;

4015: app_exception.raise_exception;
4016: elsif (rtrim(x_user_name, ' ') <> x_user_name or
4017: ltrim(x_user_name, ' ') <> x_user_name) then
4018: fnd_message.set_name('FND', 'INVALID_USER_NAME_SPACE');
4019: app_exception.raise_exception;
4020: elsif (instr(x_user_name, '/') > 0 OR
4021: instr(x_user_name, '"') > 0 OR
4022: instr(x_user_name, '(') > 0 OR
4023: instr(x_user_name, ')') > 0 OR

Line 4035: app_exception.raise_exception;

4031: instr(x_user_name, '~') > 0 OR
4032: instr(x_user_name, ':') > 0 ) then
4033: fnd_message.set_name('FND', 'INVALID_USER_NAME');
4034: fnd_message.set_token('UNAME', x_user_name);
4035: app_exception.raise_exception;
4036: else
4037: -- we pass the generic validation, it is time to call any
4038: -- customized user name validation if there is any.
4039: begin

Line 4053: app_exception.raise_exception;

4049: fnd_message.set_encoded(msg);
4050: else
4051: fnd_message.set_name('FND', 'FND_CUST_UNAME_VALIDATE_FAILED');
4052: end if;
4053: app_exception.raise_exception;
4054: end;
4055: -- past generic and customized validation
4056: end if;
4057:

Line 4291: app_exception.raise_exception;

4287: begin
4288: retval := fnd_ldap_wrapper.user_exists(x_user_name);
4289: exception
4290: when others then
4291: app_exception.raise_exception;
4292: end;
4293:
4294: if (retval = 1) then
4295: -- The above check return that user exists in oid.

Line 4468: app_exception.raise_exception;

4464: reason := fnd_message.get();
4465: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_FAIL');
4466: fnd_message.set_token('USER_NAME', x_user_name);
4467: fnd_message.set_token('REASON', reason);
4468: app_exception.raise_exception;
4469: -- Bug 5605892
4470: end if;
4471:
4472: -- Bug 5605892

Line 4483: app_exception.raise_exception;

4479: when others then
4480: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_FAIL');
4481: fnd_message.set_token('USER_NAME', x_user_name);
4482: fnd_message.set_token('REASON', sqlerrm);
4483: app_exception.raise_exception;
4484: end;
4485: exception
4486: when others then
4487: app_exception.raise_exception;

Line 4487: app_exception.raise_exception;

4483: app_exception.raise_exception;
4484: end;
4485: exception
4486: when others then
4487: app_exception.raise_exception;
4488: end;
4489:
4490: ----------------------------------------------------------------------------
4491: --

Line 4607: app_exception.raise_exception;

4603: reason := fnd_message.get();
4604: fnd_message.set_name('FND', 'FND_CHANGE_PASSWORD_FAILED');
4605: fnd_message.set_token('USER_NAME', X_USER_NAME);
4606: fnd_message.set_token('REASON', reason);
4607: app_exception.raise_exception;
4608: end if;
4609: end if;
4610:
4611: exception

Line 4613: app_exception.raise_exception;

4609: end if;
4610:
4611: exception
4612: when others then
4613: app_exception.raise_exception;
4614: end;
4615:
4616: -- end bug 4318754
4617:

Line 4646: app_exception.raise_exception;

4642: end if;
4643:
4644: exception
4645: when others then
4646: app_exception.raise_exception;
4647: end;
4648:
4649: ----------------------------------------------------------------------------
4650: --

Line 4702: app_exception.raise_exception;

4698: x_out_pwd := l_pwd_ret;
4699:
4700: exception
4701: when others then
4702: app_exception.raise_exception;
4703: end;
4704:
4705: ----------------------------------------------------------------------------
4706: -- This routine is for AOL INTERNAL USE ONLY !!!!!!!

Line 4750: app_exception.raise_exception;

4746: reason := fnd_message.get();
4747: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_FAIL');
4748: fnd_message.set_token('USER_NAME', x_user_name);
4749: fnd_message.set_token('REASON', reason);
4750: app_exception.raise_exception;
4751: end if;
4752:
4753: if (l_pwd_ret = fnd_web_sec.external_pwd) then
4754: update fnd_user

Line 4765: app_exception.raise_exception;

4761: when others then
4762: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_LOADER_FAIL');
4763: fnd_message.set_token('USER_NAME', x_user_name);
4764: fnd_message.set_token('REASON', sqlerrm);
4765: app_exception.raise_exception;
4766:
4767: end;
4768:
4769: end FND_USER_PKG;