APPS.FND_USER_PKG dependencies on FND_MESSAGE

Line 76: reason := fnd_message.get;

72: x_description, x_email_address, x_fax, x_expire_pwd, x_user_guid,
73: x_oid_pwd, l_result);
74:
75: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
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;

Line 77: fnd_message.set_name('FND', 'LDAP_WRAPPER_CREATE_USER_FAIL');

73: x_oid_pwd, l_result);
74:
75: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
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;

Line 78: fnd_message.set_token('USER_NAME', x_user_name);

74:
75: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
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:

Line 79: fnd_message.set_token('REASON', reason);

75: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
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

Line 85: fnd_message.set_name('FND', 'LDAP_WRAPPER_CREATE_USER_FAIL');

81: end if;
82:
83: 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;

Line 86: fnd_message.set_token('USER_NAME', x_user_name);

82:
83: 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:

Line 87: fnd_message.set_token('REASON', sqlerrm);

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

Line 261: fnd_message.set_name('FND', 'FND_INVALID_USER');

257: from fnd_user u
258: where u.user_name = upper(x_user_name);
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:

Line 262: fnd_message.set_token('USER_NAME', X_USER_NAME);

258: where u.user_name = upper(x_user_name);
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

Line 318: reason := fnd_message.get();

314:
315: end if;
316:
317: if (ret = 'N') then
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;

Line 319: fnd_message.set_name('FND', 'FND_CHANGE_PASSWORD_FAILED');

315: end if;
316:
317: if (ret = 'N') then
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;

Line 320: fnd_message.set_token('USER_NAME', X_USER_NAME);

316:
317: if (ret = 'N') then
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;

Line 321: fnd_message.set_token('REASON', reason);

317: if (ret = 'N') then
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:

Line 356: fnd_message.set_name('FND', 'FND_INVALID_USER');

352: user_guid = l_user_guid
353: where user_name = upper(x_user_name);
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

Line 357: fnd_message.set_token('USER_NAME', X_USER_NAME);

353: where user_name = upper(x_user_name);
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

Line 406: reason := fnd_message.get();

402: x_email_address, x_fax, l_expire_pwd);
403: exception
404: when others then
405: ROLLBACK to update_user;
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;

Line 407: fnd_message.set_name('FND', 'FND_UPDATE_USER_FAILED');

403: exception
404: when others then
405: ROLLBACK to update_user;
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;

Line 408: fnd_message.set_token('USER_NAME', X_USER_NAME);

404: when others then
405: ROLLBACK to update_user;
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;

Line 409: fnd_message.set_token('REASON', reason);

405: ROLLBACK to update_user;
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

Line 776: reason := fnd_message.get();

772: -- End Bug 4318754, 4424225
773: exception
774: when others then
775: ROLLBACK to create_user;
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;

Line 777: fnd_message.set_name('FND', 'FND_CREATE_USER_FAILED');

773: exception
774: when others then
775: ROLLBACK to create_user;
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;

Line 778: fnd_message.set_token('USER_NAME', X_USER_NAME);

774: when others then
775: ROLLBACK to create_user;
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:

Line 779: fnd_message.set_token('REASON', reason);

775: ROLLBACK to create_user;
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

Line 863: reason := fnd_message.get();

859: end if;
860:
861: else -- fnd_web_sec.create_user must have failed.
862: -- The java layer puts message onto the message stack.
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;

Line 864: fnd_message.set_name('FND', 'FND_CREATE_USER_FAILED');

860:
861: else -- fnd_web_sec.create_user must have failed.
862: -- The java layer puts message onto the message stack.
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;

Line 865: fnd_message.set_token('USER_NAME', X_USER_NAME);

861: else -- fnd_web_sec.create_user must have failed.
862: -- The java layer puts message onto the message stack.
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:

Line 866: fnd_message.set_token('REASON', reason);

862: -- The java layer puts message onto the message stack.
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);

Line 1322: fnd_message.set_name('FND', 'FND_NO_PASSWORD_PROVIDED');

1318: x_fax,
1319: x_customer_id,
1320: x_supplier_id);
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;

Line 1323: fnd_message.set_token('USER_NAME', X_USER_NAME);

1319: x_customer_id,
1320: x_supplier_id);
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;

Line 1324: fnd_message.set_token('ROUTINE', 'FND_USER_PKG.LOADUSER');

1320: x_supplier_id);
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;

Line 1418: fnd_message.set_name('FND', 'FND_NO_PASSWORD_PROVIDED');

1414: x_email_address,
1415: x_fax,
1416: x_person_party_id);
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;

Line 1419: fnd_message.set_token('USER_NAME', X_USER_NAME);

1415: x_fax,
1416: x_person_party_id);
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;

Line 1420: fnd_message.set_token('ROUTINE', 'FND_USER_PKG.LOADUSER');

1416: x_person_party_id);
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;

Line 2096: reason := fnd_message.get;

2092: tmpbuf);
2093: end if;
2094: exception
2095: when others then
2096: reason := fnd_message.get;
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);

Line 2097: fnd_message.set_name('FND', 'FND_FAILED_UPDATE_UNAME_CHILD');

2093: end if;
2094: exception
2095: when others then
2096: reason := fnd_message.get;
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;

Line 2098: fnd_message.set_token('OLD_NAME', old_name);

2094: exception
2095: when others then
2096: reason := fnd_message.get;
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;

Line 2099: fnd_message.set_token('NEW_NAME', new_name);

2095: when others then
2096: reason := fnd_message.get;
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: --------------------------------------------------------------------------

Line 2100: fnd_message.set_token('REASON', reason);

2096: reason := fnd_message.get;
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: --

Line 2375: fnd_message.set_token('USER_NAME', username);

2371: and responsibility_application_id = appid;
2372:
2373: exception
2374: when no_data_found then
2375: fnd_message.set_token('USER_NAME', username);
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);

Line 2376: fnd_message.set_name('FND', 'INVALID_RESPONSIBILITY_DATA');

2372:
2373: exception
2374: when no_data_found then
2375: fnd_message.set_token('USER_NAME', username);
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;

Line 2377: fnd_message.set_token('APPS_NAME', resp_app);

2373: exception
2374: when no_data_found then
2375: fnd_message.set_token('USER_NAME', username);
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;

Line 2378: fnd_message.set_token('RESP_KEY', resp_key);

2374: when no_data_found then
2375: fnd_message.set_token('USER_NAME', username);
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:

Line 2379: fnd_message.set_token('SECURITY_GROUP', security_group);

2375: fnd_message.set_token('USER_NAME', username);
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(

Line 2448: fnd_message.set_token('USER_NAME', username);

2444: where security_group_key = AddResp.security_group;
2445:
2446: exception
2447: when no_data_found then
2448: fnd_message.set_token('USER_NAME', username);
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);

Line 2449: fnd_message.set_name('FND', 'INVALID_RESPONSIBILITY_DATA');

2445:
2446: exception
2447: when no_data_found then
2448: fnd_message.set_token('USER_NAME', username);
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;

Line 2450: fnd_message.set_token('APPS_NAME', resp_app);

2446: exception
2447: when no_data_found then
2448: fnd_message.set_token('USER_NAME', username);
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;

Line 2451: fnd_message.set_token('RESP_KEY', resp_key);

2447: when no_data_found then
2448: fnd_message.set_token('USER_NAME', username);
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:

Line 2452: fnd_message.set_token('SECURITY_GROUP', security_group);

2448: fnd_message.set_token('USER_NAME', username);
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(

Line 2593: fnd_message.set_name('FND', 'USER_INVALID_CUSTOMER');

2589: l_party_name, l_party_type);
2590: exception
2591: when no_data_found then
2592: if (log_exception = 'Y') then
2593: fnd_message.set_name('FND', 'USER_INVALID_CUSTOMER');
2594: fnd_message.set_token('USER', user_name);
2595: fnd_message.set_token('CUSTID', l_customer_id);
2596: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2597: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 2594: fnd_message.set_token('USER', user_name);

2590: exception
2591: when no_data_found then
2592: if (log_exception = 'Y') then
2593: fnd_message.set_name('FND', 'USER_INVALID_CUSTOMER');
2594: fnd_message.set_token('USER', user_name);
2595: fnd_message.set_token('CUSTID', l_customer_id);
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);

Line 2595: fnd_message.set_token('CUSTID', l_customer_id);

2591: when no_data_found then
2592: if (log_exception = 'Y') then
2593: fnd_message.set_name('FND', 'USER_INVALID_CUSTOMER');
2594: fnd_message.set_token('USER', user_name);
2595: fnd_message.set_token('CUSTID', l_customer_id);
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;

Line 2618: fnd_message.set_name('FND', 'USER_INVALID_PARTY_REL');

2614: FND_OAM_USER_INFO.GET_ORGANIZATION_ID(l_customer_id);
2615: exception
2616: when no_data_found then
2617: if (log_exception = 'Y') then
2618: fnd_message.set_name('FND', 'USER_INVALID_PARTY_REL');
2619: fnd_message.set_token('USER', user_name);
2620: fnd_message.set_token('PNAME', l_party_name);
2621: fnd_message.set_token('CUSTID', l_customer_id);
2622: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

Line 2619: fnd_message.set_token('USER', user_name);

2615: exception
2616: when no_data_found then
2617: if (log_exception = 'Y') then
2618: fnd_message.set_name('FND', 'USER_INVALID_PARTY_REL');
2619: fnd_message.set_token('USER', user_name);
2620: fnd_message.set_token('PNAME', l_party_name);
2621: fnd_message.set_token('CUSTID', l_customer_id);
2622: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2623: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 2620: fnd_message.set_token('PNAME', l_party_name);

2616: when no_data_found then
2617: if (log_exception = 'Y') then
2618: fnd_message.set_name('FND', 'USER_INVALID_PARTY_REL');
2619: fnd_message.set_token('USER', user_name);
2620: fnd_message.set_token('PNAME', l_party_name);
2621: fnd_message.set_token('CUSTID', l_customer_id);
2622: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2623: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2624: c_log_head || l_api_name || '.not_in_hz_party_relationships',

Line 2621: fnd_message.set_token('CUSTID', l_customer_id);

2617: if (log_exception = 'Y') then
2618: fnd_message.set_name('FND', 'USER_INVALID_PARTY_REL');
2619: fnd_message.set_token('USER', user_name);
2620: fnd_message.set_token('PNAME', l_party_name);
2621: fnd_message.set_token('CUSTID', l_customer_id);
2622: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2623: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
2624: c_log_head || l_api_name || '.not_in_hz_party_relationships',
2625: FALSE);

Line 2635: fnd_message.set_name('FND', 'USER_INVALID_PARTY_TYPE');

2631: end;
2632: else
2633: if (log_exception = 'Y') then
2634: -- Invalid party type, raise error
2635: fnd_message.set_name('FND', 'USER_INVALID_PARTY_TYPE');
2636: fnd_message.set_token('USER', user_name);
2637: fnd_message.set_token('PNAME', l_party_name);
2638: fnd_message.set_token('PARTYID', l_customer_id);
2639: fnd_message.set_token('PARTY_TYPE', l_party_type);

Line 2636: fnd_message.set_token('USER', user_name);

2632: else
2633: if (log_exception = 'Y') then
2634: -- Invalid party type, raise error
2635: fnd_message.set_name('FND', 'USER_INVALID_PARTY_TYPE');
2636: fnd_message.set_token('USER', user_name);
2637: fnd_message.set_token('PNAME', l_party_name);
2638: fnd_message.set_token('PARTYID', l_customer_id);
2639: fnd_message.set_token('PARTY_TYPE', l_party_type);
2640: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

Line 2637: fnd_message.set_token('PNAME', l_party_name);

2633: if (log_exception = 'Y') then
2634: -- Invalid party type, raise error
2635: fnd_message.set_name('FND', 'USER_INVALID_PARTY_TYPE');
2636: fnd_message.set_token('USER', user_name);
2637: fnd_message.set_token('PNAME', l_party_name);
2638: fnd_message.set_token('PARTYID', l_customer_id);
2639: fnd_message.set_token('PARTY_TYPE', l_party_type);
2640: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2641: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 2638: fnd_message.set_token('PARTYID', l_customer_id);

2634: -- Invalid party type, raise error
2635: fnd_message.set_name('FND', 'USER_INVALID_PARTY_TYPE');
2636: fnd_message.set_token('USER', user_name);
2637: fnd_message.set_token('PNAME', l_party_name);
2638: fnd_message.set_token('PARTYID', l_customer_id);
2639: fnd_message.set_token('PARTY_TYPE', l_party_type);
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);

Line 2639: fnd_message.set_token('PARTY_TYPE', l_party_type);

2635: fnd_message.set_name('FND', 'USER_INVALID_PARTY_TYPE');
2636: fnd_message.set_token('USER', user_name);
2637: fnd_message.set_token('PNAME', l_party_name);
2638: fnd_message.set_token('PARTYID', l_customer_id);
2639: fnd_message.set_token('PARTY_TYPE', l_party_type);
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;

Line 2670: fnd_message.set_name('FND', 'USER_INVALID_EMPLOYEE');

2666: l_emp_person_party_id := FND_OAM_USER_INFO.GET_PARTY_ID(l_employee_id);
2667: exception
2668: when no_data_found then
2669: if (log_exception = 'Y') then
2670: fnd_message.set_name('FND', 'USER_INVALID_EMPLOYEE');
2671: fnd_message.set_token('USER', user_name);
2672: fnd_message.set_token('EMPID', l_employee_id);
2673: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2674: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 2671: fnd_message.set_token('USER', user_name);

2667: exception
2668: when no_data_found then
2669: if (log_exception = 'Y') then
2670: fnd_message.set_name('FND', 'USER_INVALID_EMPLOYEE');
2671: fnd_message.set_token('USER', user_name);
2672: fnd_message.set_token('EMPID', l_employee_id);
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);

Line 2672: fnd_message.set_token('EMPID', l_employee_id);

2668: when no_data_found then
2669: if (log_exception = 'Y') then
2670: fnd_message.set_name('FND', 'USER_INVALID_EMPLOYEE');
2671: fnd_message.set_token('USER', user_name);
2672: fnd_message.set_token('EMPID', l_employee_id);
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;

Line 2696: fnd_message.set_name('FND', 'USER_CUST_PARTY_NOT_FOUND');

2692: l_cust_person_party_name,
2693: l_party_type);
2694: exception
2695: when no_data_found then
2696: fnd_message.set_name('FND', 'USER_CUST_PARTY_NOT_FOUND');
2697: fnd_message.set_token('USER', user_name);
2698: fnd_message.set_token('CUSTID', l_customer_id);
2699: if (fnd_log.LEVEL_EXCEPTION >=
2700: fnd_log.g_current_runtime_level) then

Line 2697: fnd_message.set_token('USER', user_name);

2693: l_party_type);
2694: exception
2695: when no_data_found then
2696: fnd_message.set_name('FND', 'USER_CUST_PARTY_NOT_FOUND');
2697: fnd_message.set_token('USER', user_name);
2698: fnd_message.set_token('CUSTID', l_customer_id);
2699: if (fnd_log.LEVEL_EXCEPTION >=
2700: fnd_log.g_current_runtime_level) then
2701: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 2698: fnd_message.set_token('CUSTID', l_customer_id);

2694: exception
2695: when no_data_found then
2696: fnd_message.set_name('FND', 'USER_CUST_PARTY_NOT_FOUND');
2697: fnd_message.set_token('USER', user_name);
2698: fnd_message.set_token('CUSTID', l_customer_id);
2699: if (fnd_log.LEVEL_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);

Line 2713: fnd_message.set_name('FND', 'USER_EMP_PARTY_NOT_FOUND');

2709: l_emp_person_party_name,
2710: l_party_type);
2711: exception
2712: when no_data_found then
2713: fnd_message.set_name('FND', 'USER_EMP_PARTY_NOT_FOUND');
2714: fnd_message.set_token('USER', user_name);
2715: fnd_message.set_token('EMPID', l_emp_person_party_id);
2716: if (fnd_log.LEVEL_EXCEPTION >=
2717: fnd_log.g_current_runtime_level) then

Line 2714: fnd_message.set_token('USER', user_name);

2710: l_party_type);
2711: exception
2712: when no_data_found then
2713: fnd_message.set_name('FND', 'USER_EMP_PARTY_NOT_FOUND');
2714: fnd_message.set_token('USER', user_name);
2715: fnd_message.set_token('EMPID', l_emp_person_party_id);
2716: if (fnd_log.LEVEL_EXCEPTION >=
2717: fnd_log.g_current_runtime_level) then
2718: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 2715: fnd_message.set_token('EMPID', l_emp_person_party_id);

2711: exception
2712: when no_data_found then
2713: fnd_message.set_name('FND', 'USER_EMP_PARTY_NOT_FOUND');
2714: fnd_message.set_token('USER', user_name);
2715: fnd_message.set_token('EMPID', l_emp_person_party_id);
2716: if (fnd_log.LEVEL_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);

Line 2724: fnd_message.set_name('FND', 'USER_CUST_EMP_MISMATCH');

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);
2726: fnd_message.set_token('CUSTID', l_customer_id);
2727: fnd_message.set_token('CUSTPARTY', l_cust_person_party_name);
2728: fnd_message.set_token('EMPID', l_employee_id);

Line 2725: fnd_message.set_token('USER', user_name);

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);
2726: fnd_message.set_token('CUSTID', l_customer_id);
2727: fnd_message.set_token('CUSTPARTY', l_cust_person_party_name);
2728: fnd_message.set_token('EMPID', l_employee_id);
2729: fnd_message.set_token('EMPPARTY', l_emp_person_party_name);

Line 2726: fnd_message.set_token('CUSTID', l_customer_id);

2722: end;
2723:
2724: fnd_message.set_name('FND', 'USER_CUST_EMP_MISMATCH');
2725: fnd_message.set_token('USER', user_name);
2726: fnd_message.set_token('CUSTID', l_customer_id);
2727: fnd_message.set_token('CUSTPARTY', l_cust_person_party_name);
2728: fnd_message.set_token('EMPID', l_employee_id);
2729: fnd_message.set_token('EMPPARTY', l_emp_person_party_name);
2730: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

Line 2727: fnd_message.set_token('CUSTPARTY', l_cust_person_party_name);

2723:
2724: fnd_message.set_name('FND', 'USER_CUST_EMP_MISMATCH');
2725: fnd_message.set_token('USER', user_name);
2726: fnd_message.set_token('CUSTID', l_customer_id);
2727: fnd_message.set_token('CUSTPARTY', l_cust_person_party_name);
2728: fnd_message.set_token('EMPID', l_employee_id);
2729: fnd_message.set_token('EMPPARTY', l_emp_person_party_name);
2730: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2731: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 2728: fnd_message.set_token('EMPID', l_employee_id);

2724: fnd_message.set_name('FND', 'USER_CUST_EMP_MISMATCH');
2725: fnd_message.set_token('USER', user_name);
2726: fnd_message.set_token('CUSTID', l_customer_id);
2727: fnd_message.set_token('CUSTPARTY', l_cust_person_party_name);
2728: fnd_message.set_token('EMPID', l_employee_id);
2729: fnd_message.set_token('EMPPARTY', l_emp_person_party_name);
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);

Line 2729: fnd_message.set_token('EMPPARTY', l_emp_person_party_name);

2725: fnd_message.set_token('USER', user_name);
2726: fnd_message.set_token('CUSTID', l_customer_id);
2727: fnd_message.set_token('CUSTPARTY', l_cust_person_party_name);
2728: fnd_message.set_token('EMPID', l_employee_id);
2729: fnd_message.set_token('EMPPARTY', l_emp_person_party_name);
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;

Line 2803: fnd_message.set_name('FND', 'USER_INVALID_PARTY');

2799: l_person_party_name,
2800: l_party_type);
2801: exception
2802: when no_data_found then
2803: fnd_message.set_name('FND', 'USER_INVALID_PARTY');
2804: fnd_message.set_token('USER', user_name);
2805: fnd_message.set_token('PARTYID', l_person_party_id);
2806: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2807: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 2804: fnd_message.set_token('USER', user_name);

2800: l_party_type);
2801: exception
2802: when no_data_found then
2803: fnd_message.set_name('FND', 'USER_INVALID_PARTY');
2804: fnd_message.set_token('USER', user_name);
2805: fnd_message.set_token('PARTYID', l_person_party_id);
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);

Line 2805: fnd_message.set_token('PARTYID', l_person_party_id);

2801: exception
2802: when no_data_found then
2803: fnd_message.set_name('FND', 'USER_INVALID_PARTY');
2804: fnd_message.set_token('USER', user_name);
2805: fnd_message.set_token('PARTYID', l_person_party_id);
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;

Line 2813: fnd_message.set_name('FND', 'USER_INVALID_PARTY_TYPE');

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);
2815: fnd_message.set_token('PARTYID', l_person_party_id);
2816: fnd_message.set_token('PARTY_TYPE', l_party_type);
2817: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then

Line 2814: fnd_message.set_token('USER', user_name);

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);
2815: fnd_message.set_token('PARTYID', l_person_party_id);
2816: fnd_message.set_token('PARTY_TYPE', l_party_type);
2817: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
2818: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,

Line 2815: fnd_message.set_token('PARTYID', l_person_party_id);

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);
2815: fnd_message.set_token('PARTYID', l_person_party_id);
2816: fnd_message.set_token('PARTY_TYPE', l_party_type);
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);

Line 2816: fnd_message.set_token('PARTY_TYPE', l_party_type);

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);
2815: fnd_message.set_token('PARTYID', l_person_party_id);
2816: fnd_message.set_token('PARTY_TYPE', l_party_type);
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;

Line 2994: fnd_message.set_name('FND', 'FND_INVALID_USER');

2990: and to_char(end_date) = to_char(FND_API.G_MISS_DATE);
2991:
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:

Line 2995: fnd_message.set_token('USER_NAME', username);

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

Line 3019: fnd_message.set_name('FND', 'FND_INVALID_USER');

3015: and to_char(start_date) = to_char(FND_API.G_MISS_DATE)
3016: and to_char(end_date) = to_char(FND_API.G_MISS_DATE);
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

Line 3020: fnd_message.set_token('USER_NAME', username);

3016: and to_char(end_date) = to_char(FND_API.G_MISS_DATE);
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);

Line 3058: fnd_message.set_name('FND', 'FND_INVALID_PARTY');

3054: from hz_parties
3055: where upper(party_name) = upper(x_party);
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:

Line 3059: fnd_message.set_token('PARTY_NAME', x_party);

3055: where upper(party_name) = upper(x_party);
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,

Line 3089: reason := fnd_message.get();

3085:
3086: fnd_ldap_wrapper.change_user_name(x_user_guid, x_old_user_name,
3087: x_new_user_name, l_result);
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;

Line 3090: fnd_message.set_name('FND', 'LDAP_WRAPPER_CHANGE_USER_FAIL');

3086: fnd_ldap_wrapper.change_user_name(x_user_guid, x_old_user_name,
3087: x_new_user_name, l_result);
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

Line 3091: fnd_message.set_token('REASON', reason);

3087: x_new_user_name, l_result);
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

Line 3096: fnd_message.set_name('FND', 'LDAP_WRAPPER_CHANGE_USER_FAIL');

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');
3097: fnd_message.set_token('REASON', sqlerrm);
3098: app_exception.raise_exception;
3099: end;
3100:

Line 3097: fnd_message.set_token('REASON', sqlerrm);

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

Line 3139: fnd_message.set_name('FND', 'SECURITY-DUPLICATE USER');

3135: begin
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

Line 3218: reason := fnd_message.get;

3214: begin
3215: fnd_user_pkg.user_synch(upper(x_new_user_name));
3216: exception
3217: when others then
3218: reason := fnd_message.get;
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);

Line 3219: fnd_message.set_name('FND', 'FND_FAILED_WF_USER_SYNCH');

3215: fnd_user_pkg.user_synch(upper(x_new_user_name));
3216: exception
3217: when others then
3218: reason := fnd_message.get;
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;

Line 3220: fnd_message.set_token('OLD_NAME', x_old_user_name);

3216: exception
3217: when others then
3218: reason := fnd_message.get;
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;

Line 3221: fnd_message.set_token('NEW_NAME', x_new_user_name);

3217: when others then
3218: reason := fnd_message.get;
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:

Line 3222: fnd_message.set_token('REASON', reason);

3218: reason := fnd_message.get;
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

Line 3246: fnd_message.set_name('FND', 'FND_CHANGE_USER_FAILED');

3242:
3243: 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:

Line 3247: fnd_message.set_token('USER_NAME', x_old_user_name);

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

Line 3332: fnd_message.set_name('FND', 'INVALID_USER_NAME_NULL');

3328: uname varchar2(100);
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');

Line 3336: fnd_message.set_name('FND', 'INVALID_USER_NAME_SPACE');

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;
3338: elsif (instr(x_user_name, '/') > 0 OR
3339: instr(x_user_name, '"') > 0 OR
3340: instr(x_user_name, '(') > 0 OR

Line 3351: fnd_message.set_name('FND', 'INVALID_USER_NAME');

3347: instr(x_user_name, '>') > 0 OR
3348: instr(x_user_name, '\') > 0 OR
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

Line 3352: fnd_message.set_token('UNAME', x_user_name);

3348: instr(x_user_name, '\') > 0 OR
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.

Line 3365: msg := fnd_message.get_encoded;

3361: p_parameters => NULL,
3362: p_send_date => Sysdate);
3363: exception
3364: when others then
3365: msg := fnd_message.get_encoded;
3366: if (msg is not null) then
3367: fnd_message.set_encoded(msg);
3368: else
3369: fnd_message.set_name('FND', 'FND_CUST_UNAME_VALIDATE_FAILED');

Line 3367: fnd_message.set_encoded(msg);

3363: exception
3364: when others then
3365: msg := fnd_message.get_encoded;
3366: if (msg is not null) then
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;

Line 3369: fnd_message.set_name('FND', 'FND_CUST_UNAME_VALIDATE_FAILED');

3365: msg := fnd_message.get_encoded;
3366: if (msg is not null) then
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

Line 3602: fnd_message.set_name('FND', 'FND_USER_EXISTS_IN_FND');

3598: return(USER_INVALID_NAME);
3599: end;
3600:
3601: if (fnd_user_pkg.userExists(x_user_name)) then
3602: fnd_message.set_name('FND', 'FND_USER_EXISTS_IN_FND');
3603: return(USER_EXISTS_IN_FND);
3604: else
3605: begin
3606: retval := fnd_ldap_wrapper.user_exists(x_user_name);

Line 3617: fnd_message.set_name('FND', 'FND_USER_SYNCHED');

3613: -- The above check return that user exists in oid.
3614: fnd_profile.get('APPS_SSO_LINK_SAME_NAMES', pf);
3615:
3616: if(pf = 'Y') then
3617: fnd_message.set_name('FND', 'FND_USER_SYNCHED');
3618: fnd_message.set_token('USER_NAME', x_user_name);
3619: return(USER_SYNCHED);
3620: -- next time when this user gets created in fnd, it will be
3621: -- linked to each other.

Line 3618: fnd_message.set_token('USER_NAME', x_user_name);

3614: fnd_profile.get('APPS_SSO_LINK_SAME_NAMES', pf);
3615:
3616: if(pf = 'Y') then
3617: fnd_message.set_name('FND', 'FND_USER_SYNCHED');
3618: fnd_message.set_token('USER_NAME', x_user_name);
3619: return(USER_SYNCHED);
3620: -- next time when this user gets created in fnd, it will be
3621: -- linked to each other.
3622: else

Line 3623: fnd_message.set_name('FND', 'FND_USER_EXISTS_NO_LINK');

3619: return(USER_SYNCHED);
3620: -- next time when this user gets created in fnd, it will be
3621: -- linked to each other.
3622: else
3623: fnd_message.set_name('FND', 'FND_USER_EXISTS_NO_LINK');
3624: return(USER_EXISTS_NO_LINK_ALLOWED);
3625: end if;
3626: else
3627: return(USER_OK_CREATE);

Line 3762: reason := fnd_message.get();

3758: l_pwd, x_start_date, x_end_date, x_description,
3759: x_email_address, x_fax, x_expire_pwd, l_pwd_ret, l_result);
3760:
3761: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
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;

Line 3763: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_FAIL');

3759: x_email_address, x_fax, x_expire_pwd, l_pwd_ret, l_result);
3760:
3761: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
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

Line 3764: fnd_message.set_token('USER_NAME', x_user_name);

3760:
3761: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
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;

Line 3765: fnd_message.set_token('REASON', reason);

3761: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
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:

Line 3778: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_FAIL');

3774: return(null);
3775: end if;
3776: 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;

Line 3779: fnd_message.set_token('USER_NAME', x_user_name);

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

Line 3780: fnd_message.set_token('REASON', sqlerrm);

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

Line 3871: reason := fnd_message.get();

3867: -- Add third argument to not use autonomous transaction when chaning
3868: -- passowrd. This is for bug 5087728
3869: ret := fnd_web_sec.change_password(x_user_name, l_oid_pwd, FALSE);
3870: if (ret = 'N') then
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;

Line 3872: fnd_message.set_name('FND', 'FND_CHANGE_PASSWORD_FAILED');

3868: -- passowrd. This is for bug 5087728
3869: ret := fnd_web_sec.change_password(x_user_name, l_oid_pwd, FALSE);
3870: if (ret = 'N') then
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;

Line 3873: fnd_message.set_token('USER_NAME', X_USER_NAME);

3869: ret := fnd_web_sec.change_password(x_user_name, l_oid_pwd, FALSE);
3870: if (ret = 'N') then
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;

Line 3874: fnd_message.set_token('REASON', reason);

3870: if (ret = 'N') then
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:

Line 4025: reason := fnd_message.get();

4021: x_hashed_password, x_start_date, x_end_date, x_description,
4022: x_email_address, x_fax, x_expire_pwd, l_pwd_ret, l_result);
4023:
4024: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
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;

Line 4026: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_FAIL');

4022: x_email_address, x_fax, x_expire_pwd, l_pwd_ret, l_result);
4023:
4024: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
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;

Line 4027: fnd_message.set_token('USER_NAME', x_user_name);

4023:
4024: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
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:

Line 4028: fnd_message.set_token('REASON', reason);

4024: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
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

Line 4041: fnd_message.set_name('FND', 'LDAP_WRAPPER_UPDATE_USER_LOADER_FAIL');

4037: end if;
4038:
4039: 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:

Line 4042: fnd_message.set_token('USER_NAME', x_user_name);

4038:
4039: 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;

Line 4043: fnd_message.set_token('REASON', sqlerrm);

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