DBA Data[Home] [Help]

APPS.FND_USER_PKG dependencies on APP_EXCEPTION

Line 80: app_exception.raise_exception;

76: reason := fnd_message.get;
77: fnd_message.set_name('FND', 'LDAP_WRAPPER_CREATE_USER_FAIL');
78: fnd_message.set_token('USER_NAME', x_user_name);
79: fnd_message.set_token('REASON', reason);
80: app_exception.raise_exception;
81: end if;
82:
83: exception
84: when others then

Line 88: app_exception.raise_exception;

84: when others then
85: fnd_message.set_name('FND', 'LDAP_WRAPPER_CREATE_USER_FAIL');
86: fnd_message.set_token('USER_NAME', x_user_name);
87: fnd_message.set_token('REASON', sqlerrm);
88: app_exception.raise_exception;
89: end;
90:
91: ----------------------------------------------------------------------^M
92: --

Line 263: app_exception.raise_exception;

259: exception
260: when others then
261: fnd_message.set_name('FND', 'FND_INVALID_USER');
262: fnd_message.set_token('USER_NAME', X_USER_NAME);
263: app_exception.raise_exception;
264: end;
265:
266: -- PARTY
267: if (x_mode = 'PARTY') then

Line 322: app_exception.raise_exception;

318: reason := fnd_message.get();
319: fnd_message.set_name('FND', 'FND_CHANGE_PASSWORD_FAILED');
320: fnd_message.set_token('USER_NAME', X_USER_NAME);
321: fnd_message.set_token('REASON', reason);
322: app_exception.raise_exception;
323: end if;
324: end if;
325:
326: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then

Line 358: app_exception.raise_exception;

354:
355: if (SQL%NOTFOUND) then
356: fnd_message.set_name('FND', 'FND_INVALID_USER');
357: fnd_message.set_token('USER_NAME', X_USER_NAME);
358: app_exception.raise_exception;
359: else
360: -- Added for Function Security Cache Invalidation
361: select user_id into l_user_id
362: from fnd_user

Line 410: app_exception.raise_exception;

406: reason := fnd_message.get();
407: fnd_message.set_name('FND', 'FND_UPDATE_USER_FAILED');
408: fnd_message.set_token('USER_NAME', X_USER_NAME);
409: fnd_message.set_token('REASON', reason);
410: app_exception.raise_exception;
411: end;
412: end if;
413: -- End bug 4318754, 4424225
414:

Line 780: app_exception.raise_exception;

776: reason := fnd_message.get();
777: fnd_message.set_name('FND', 'FND_CREATE_USER_FAILED');
778: fnd_message.set_token('USER_NAME', X_USER_NAME);
779: fnd_message.set_token('REASON', reason);
780: app_exception.raise_exception;
781: end;
782:
783: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
784: fnd_log.string(FND_LOG.LEVEL_STATEMENT, c_log_head || l_api_name,

Line 867: app_exception.raise_exception;

863: reason := fnd_message.get();
864: fnd_message.set_name('FND', 'FND_CREATE_USER_FAILED');
865: fnd_message.set_token('USER_NAME', X_USER_NAME);
866: fnd_message.set_token('REASON', reason);
867: app_exception.raise_exception;
868: end if;
869:
870: return(user_id);
871: end;

Line 1325: app_exception.raise_exception;

1321: else
1322: fnd_message.set_name('FND', 'FND_NO_PASSWORD_PROVIDED');
1323: fnd_message.set_token('USER_NAME', X_USER_NAME);
1324: fnd_message.set_token('ROUTINE', 'FND_USER_PKG.LOADUSER');
1325: app_exception.raise_exception;
1326: end if;
1327: end if;
1328: end LoadUser;
1329:

Line 1421: app_exception.raise_exception;

1417: else
1418: fnd_message.set_name('FND', 'FND_NO_PASSWORD_PROVIDED');
1419: fnd_message.set_token('USER_NAME', X_USER_NAME);
1420: fnd_message.set_token('ROUTINE', 'FND_USER_PKG.LOADUSER');
1421: app_exception.raise_exception;
1422: end if;
1423: end if;
1424: end LoadUserParty;
1425:

Line 2101: app_exception.raise_exception;

2097: fnd_message.set_name('FND', 'FND_FAILED_UPDATE_UNAME_CHILD');
2098: fnd_message.set_token('OLD_NAME', old_name);
2099: fnd_message.set_token('NEW_NAME', new_name);
2100: fnd_message.set_token('REASON', reason);
2101: app_exception.raise_exception;
2102: end UpdateUserNameChildren;
2103: --------------------------------------------------------------------------
2104: --
2105: -- user_synch - The centralized routine for communicating user changes

Line 2380: app_exception.raise_exception;

2376: fnd_message.set_name('FND', 'INVALID_RESPONSIBILITY_DATA');
2377: fnd_message.set_token('APPS_NAME', resp_app);
2378: fnd_message.set_token('RESP_KEY', resp_key);
2379: fnd_message.set_token('SECURITY_GROUP', security_group);
2380: app_exception.raise_exception;
2381: end;
2382:
2383: if (fnd_user_resp_groups_api.assignment_exists(
2384: userid, respid, appid, secid)) then

Line 2453: app_exception.raise_exception;

2449: fnd_message.set_name('FND', 'INVALID_RESPONSIBILITY_DATA');
2450: fnd_message.set_token('APPS_NAME', resp_app);
2451: fnd_message.set_token('RESP_KEY', resp_key);
2452: fnd_message.set_token('SECURITY_GROUP', security_group);
2453: app_exception.raise_exception;
2454: end;
2455:
2456: if (fnd_user_resp_groups_api.assignment_exists(
2457: userid, respid, appid, secid)) then

Line 2600: app_exception.raise_exception;

2596: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2597: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2598: c_log_head || l_api_name || '.not_in_hz_parties', FALSE);
2599: end if;
2600: app_exception.raise_exception;
2601: else
2602: return null;
2603: end if;
2604: end;

Line 2627: app_exception.raise_exception;

2623: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2624: c_log_head || l_api_name || '.not_in_hz_party_relationships',
2625: FALSE);
2626: end if;
2627: app_exception.raise_exception;
2628: else
2629: return null;
2630: end if;
2631: end;

Line 2644: app_exception.raise_exception;

2640: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2641: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2642: c_log_head || l_api_name || '.bad_party_type', FALSE);
2643: end if;
2644: app_exception.raise_exception;
2645: else
2646: return null;
2647: end if;
2648: end if;

Line 2677: app_exception.raise_exception;

2673: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2674: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2675: c_log_head || l_api_name || '.bad_empid', FALSE);
2676: end if;
2677: app_exception.raise_exception;
2678: else
2679: return null;
2680: end if;
2681: end;

Line 2704: app_exception.raise_exception;

2700: fnd_log.g_current_runtime_level) then
2701: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2702: c_log_head || l_api_name || '.cust_emp_mismatch', FALSE);
2703: end if;
2704: app_exception.raise_exception;
2705: end;
2706:
2707: begin
2708: FND_OAM_USER_INFO.HZ_PARTY_ID_TO_NAME(l_emp_person_party_id,

Line 2721: app_exception.raise_exception;

2717: fnd_log.g_current_runtime_level) then
2718: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2719: c_log_head || l_api_name || '.cust_emp_mismatch', FALSE);
2720: end if;
2721: app_exception.raise_exception;
2722: end;
2723:
2724: fnd_message.set_name('FND', 'USER_CUST_EMP_MISMATCH');
2725: fnd_message.set_token('USER', user_name);

Line 2734: app_exception.raise_exception;

2730: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2731: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2732: c_log_head || l_api_name || '.cust_emp_mismatch', FALSE);
2733: end if;
2734: app_exception.raise_exception;
2735: else
2736: return null;
2737: end if;
2738: end if;

Line 2810: app_exception.raise_exception;

2806: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2807: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2808: c_log_head || l_api_name || '.not_in_hz_parties', FALSE);
2809: end if;
2810: app_exception.raise_exception;
2811: end;
2812: if (l_party_type <> 'PERSON') then
2813: fnd_message.set_name('FND', 'USER_INVALID_PARTY_TYPE');
2814: fnd_message.set_token('USER', user_name);

Line 2821: app_exception.raise_exception;

2817: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2818: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2819: c_log_head || l_api_name || '.bad_party_type', FALSE);
2820: end if;
2821: app_exception.raise_exception;
2822: end if;
2823: end if;
2824:
2825: -- Set customer_id to new party_id

Line 2996: app_exception.raise_exception;

2992: exception
2993: when no_data_found then
2994: fnd_message.set_name('FND', 'FND_INVALID_USER');
2995: fnd_message.set_token('USER_NAME', username);
2996: app_exception.raise_exception;
2997: end;
2998:
2999: -- Bug 4318754. Synch up with SSO
3000: if (l_user_guid is not null) then

Line 3004: app_exception.raise_exception;

3000: if (l_user_guid is not null) then
3001: begin
3002: fnd_ldap_wrapper.delete_user(l_user_guid, retval);
3003: if (retval <> fnd_ldap_wrapper.G_SUCCESS) then
3004: app_exception.raise_exception;
3005: end if;
3006: exception
3007: when others then
3008: app_exception.raise_exception;

Line 3008: app_exception.raise_exception;

3004: app_exception.raise_exception;
3005: end if;
3006: exception
3007: when others then
3008: app_exception.raise_exception;
3009: end;
3010: end if;
3011:
3012: -- Only allow to delete a PENDING user

Line 3021: app_exception.raise_exception;

3017:
3018: if (sql%rowcount = 0) then
3019: fnd_message.set_name('FND', 'FND_INVALID_USER');
3020: fnd_message.set_token('USER_NAME', username);
3021: app_exception.raise_exception;
3022: else
3023: -- Added for Function Security Cache Invalidation
3024: fnd_function_security_cache.delete_user(l_user_id);
3025: end if;

Line 3060: app_exception.raise_exception;

3056: exception
3057: when no_data_found then
3058: fnd_message.set_name('FND', 'FND_INVALID_PARTY');
3059: fnd_message.set_token('PARTY_NAME', x_party);
3060: app_exception.raise_exception;
3061: end;
3062:
3063: fnd_user_pkg.UpdateUserParty(x_user_name => x_user_name,
3064: x_owner => 'SEED',

Line 3092: app_exception.raise_exception;

3088: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
3089: reason := fnd_message.get();
3090: fnd_message.set_name('FND', 'LDAP_WRAPPER_CHANGE_USER_FAIL');
3091: fnd_message.set_token('REASON', reason);
3092: app_exception.raise_exception;
3093: end if;
3094: exception
3095: when others then
3096: fnd_message.set_name('FND', 'LDAP_WRAPPER_CHANGE_USER_FAIL');

Line 3098: app_exception.raise_exception;

3094: exception
3095: when others then
3096: fnd_message.set_name('FND', 'LDAP_WRAPPER_CHANGE_USER_FAIL');
3097: fnd_message.set_token('REASON', sqlerrm);
3098: app_exception.raise_exception;
3099: end;
3100:
3101: -- begin bug 2504562
3102:

Line 3140: app_exception.raise_exception;

3136: -- ensure x_new_user_name doesn't already exist in fnd_user
3137: select null into dummy from fnd_user
3138: where user_name = upper(x_new_user_name);
3139: fnd_message.set_name('FND', 'SECURITY-DUPLICATE USER');
3140: app_exception.raise_exception;
3141: exception
3142: when no_data_found then
3143: -- Start bug 5866089 just adding the following if check
3144: if (x_change_source is null) then

Line 3160: app_exception.raise_exception;

3156: upper(x_new_user_name));
3157: end if;
3158: exception
3159: when others then
3160: app_exception.raise_exception;
3161: end;
3162: -- end bug 4625235
3163:
3164: end if;

Line 3223: app_exception.raise_exception;

3219: fnd_message.set_name('FND', 'FND_FAILED_WF_USER_SYNCH');
3220: fnd_message.set_token('OLD_NAME', x_old_user_name);
3221: fnd_message.set_token('NEW_NAME', x_new_user_name);
3222: fnd_message.set_token('REASON', reason);
3223: app_exception.raise_exception;
3224: end;
3225:
3226: -- Added for bug 4676568
3227: -- A temp fix to update fnd_grants.grantee_key

Line 3248: app_exception.raise_exception;

3244: when no_data_found then
3245: -- old username does not exist in fnd_user
3246: fnd_message.set_name('FND', 'FND_CHANGE_USER_FAILED');
3247: fnd_message.set_token('USER_NAME', x_old_user_name);
3248: app_exception.raise_exception;
3249:
3250:
3251: end change_user_name;
3252:

Line 3333: app_exception.raise_exception;

3329: begin
3330: if (x_user_name is null or
3331: rtrim(x_user_name, ' ') is null) then
3332: fnd_message.set_name('FND', 'INVALID_USER_NAME_NULL');
3333: app_exception.raise_exception;
3334: elsif (rtrim(x_user_name, ' ') <> x_user_name or
3335: ltrim(x_user_name, ' ') <> x_user_name) then
3336: fnd_message.set_name('FND', 'INVALID_USER_NAME_SPACE');
3337: app_exception.raise_exception;

Line 3337: app_exception.raise_exception;

3333: app_exception.raise_exception;
3334: elsif (rtrim(x_user_name, ' ') <> x_user_name or
3335: ltrim(x_user_name, ' ') <> x_user_name) then
3336: fnd_message.set_name('FND', 'INVALID_USER_NAME_SPACE');
3337: app_exception.raise_exception;
3338: elsif (instr(x_user_name, '/') > 0 OR
3339: instr(x_user_name, '"') > 0 OR
3340: instr(x_user_name, '(') > 0 OR
3341: instr(x_user_name, ')') > 0 OR

Line 3353: app_exception.raise_exception;

3349: instr(x_user_name, '~') > 0 OR
3350: instr(x_user_name, ':') > 0 ) then
3351: fnd_message.set_name('FND', 'INVALID_USER_NAME');
3352: fnd_message.set_token('UNAME', x_user_name);
3353: app_exception.raise_exception;
3354: else
3355: -- we pass the generic validation, it is time to call any
3356: -- customized user name validation if there is any.
3357: begin

Line 3371: app_exception.raise_exception;

3367: fnd_message.set_encoded(msg);
3368: else
3369: fnd_message.set_name('FND', 'FND_CUST_UNAME_VALIDATE_FAILED');
3370: end if;
3371: app_exception.raise_exception;
3372: end;
3373: -- past generic and customized validation
3374: end if;
3375:

Line 3609: app_exception.raise_exception;

3605: begin
3606: retval := fnd_ldap_wrapper.user_exists(x_user_name);
3607: exception
3608: when others then
3609: app_exception.raise_exception;
3610: end;
3611:
3612: if (retval = 1) then
3613: -- The above check return that user exists in oid.

Line 3766: app_exception.raise_exception;

3762: reason := fnd_message.get();
3763: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_FAIL');
3764: fnd_message.set_token('USER_NAME', x_user_name);
3765: fnd_message.set_token('REASON', reason);
3766: app_exception.raise_exception;
3767: -- Bug 5605892
3768: end if;
3769:
3770: -- Bug 5605892

Line 3781: app_exception.raise_exception;

3777: when others then
3778: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_FAIL');
3779: fnd_message.set_token('USER_NAME', x_user_name);
3780: fnd_message.set_token('REASON', sqlerrm);
3781: app_exception.raise_exception;
3782: end;
3783: exception
3784: when others then
3785: app_exception.raise_exception;

Line 3785: app_exception.raise_exception;

3781: app_exception.raise_exception;
3782: end;
3783: exception
3784: when others then
3785: app_exception.raise_exception;
3786: end;
3787:
3788: ----------------------------------------------------------------------------
3789: --

Line 3875: app_exception.raise_exception;

3871: reason := fnd_message.get();
3872: fnd_message.set_name('FND', 'FND_CHANGE_PASSWORD_FAILED');
3873: fnd_message.set_token('USER_NAME', X_USER_NAME);
3874: fnd_message.set_token('REASON', reason);
3875: app_exception.raise_exception;
3876: end if;
3877: end if;
3878:
3879: exception

Line 3881: app_exception.raise_exception;

3877: end if;
3878:
3879: exception
3880: when others then
3881: app_exception.raise_exception;
3882: end;
3883:
3884: -- end bug 4318754
3885:

Line 3914: app_exception.raise_exception;

3910: end if;
3911:
3912: exception
3913: when others then
3914: app_exception.raise_exception;
3915: end;
3916:
3917: ----------------------------------------------------------------------------
3918: --

Line 3981: app_exception.raise_exception;

3977: x_out_pwd := l_pwd_ret;
3978:
3979: exception
3980: when others then
3981: app_exception.raise_exception;
3982: end;
3983:
3984: ----------------------------------------------------------------------------
3985: -- This routine is for AOL INTERNAL USE ONLY !!!!!!!

Line 4029: app_exception.raise_exception;

4025: reason := fnd_message.get();
4026: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_FAIL');
4027: fnd_message.set_token('USER_NAME', x_user_name);
4028: fnd_message.set_token('REASON', reason);
4029: app_exception.raise_exception;
4030: end if;
4031:
4032: if (l_pwd_ret = fnd_web_sec.external_pwd) then
4033: update fnd_user

Line 4044: app_exception.raise_exception;

4040: when others then
4041: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_LOADER_FAIL');
4042: fnd_message.set_token('USER_NAME', x_user_name);
4043: fnd_message.set_token('REASON', sqlerrm);
4044: app_exception.raise_exception;
4045:
4046: end;
4047:
4048: end FND_USER_PKG;