91: x_description, x_email_address, x_fax, x_expire_pwd, x_user_guid,
92: x_oid_pwd, l_result);
93:
94: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
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;
92: x_oid_pwd, l_result);
93:
94: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
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;
93:
94: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
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:
94: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
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
100: end if;
101:
102: 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;
101:
102: 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:
102: 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
239: -- If start_date > sysdate, do not update the start_date for GUEST.
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;
321: from fnd_user u
322: where u.user_name = upper(x_user_name);
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:
322: where u.user_name = upper(x_user_name);
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
450: end if;
451: G_EXPIRE_USER_PWD := NULL;
452:
453: if (ret = 'N') then
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;
451: G_EXPIRE_USER_PWD := NULL;
452:
453: if (ret = 'N') then
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;
452:
453: if (ret = 'N') then
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;
453: if (ret = 'N') then
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:
469: p_parameter_list => l_parameter_list,
470: p_send_date => Sysdate);
471: exception
472: when others then
473: reason := fnd_message.get_encoded;
474: if (reason is not null) then
475: fnd_message.set_encoded(reason);
476: else
477: fnd_message.set_name('FND', 'FND_CREATE_A_SYNCH_MSG');
471: exception
472: when others then
473: reason := fnd_message.get_encoded;
474: if (reason is not null) then
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;
473: reason := fnd_message.get_encoded;
474: if (reason is not null) then
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:
516: user_guid = l_user_guid
517: where user_name = upper(x_user_name);
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.
517: where user_name = upper(x_user_name);
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
558: x_fax => x_fax);
559: exception
560: when others then
561: ROLLBACK to update_user;
562: reason := fnd_message.get();
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);
559: exception
560: when others then
561: ROLLBACK to update_user;
562: reason := fnd_message.get();
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;
560: when others then
561: ROLLBACK to update_user;
562: reason := fnd_message.get();
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;
561: ROLLBACK to update_user;
562: reason := fnd_message.get();
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;
562: reason := fnd_message.get();
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
713: end if;
714: end if;
715: exception
716: when others then
717: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
718: fnd_message.set_token('ROUTINE', l_api_name);
719: fnd_message.set_token('ERRNO', SQLCODE);
720: fnd_message.set_token('REASON', SQLERRM);
721: end;
714: end if;
715: exception
716: when others then
717: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
718: fnd_message.set_token('ROUTINE', l_api_name);
719: fnd_message.set_token('ERRNO', SQLCODE);
720: fnd_message.set_token('REASON', SQLERRM);
721: end;
722: else -- l_employee_id is NULL
715: exception
716: when others then
717: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
718: fnd_message.set_token('ROUTINE', l_api_name);
719: fnd_message.set_token('ERRNO', SQLCODE);
720: fnd_message.set_token('REASON', SQLERRM);
721: end;
722: else -- l_employee_id is NULL
723:
716: when others then
717: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
718: fnd_message.set_token('ROUTINE', l_api_name);
719: fnd_message.set_token('ERRNO', SQLCODE);
720: fnd_message.set_token('REASON', SQLERRM);
721: end;
722: else -- l_employee_id is NULL
723:
724: -- Bug 13989225 if new employee_id is null then delete
741: and NUMBER_VALUE = l_old_employee_id;
742:
743: exception
744: when others then
745: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
746: fnd_message.set_token('ROUTINE', l_api_name);
747: fnd_message.set_token('ERRNO', SQLCODE);
748: fnd_message.set_token('REASON', SQLERRM);
749: end;
742:
743: exception
744: when others then
745: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
746: fnd_message.set_token('ROUTINE', l_api_name);
747: fnd_message.set_token('ERRNO', SQLCODE);
748: fnd_message.set_token('REASON', SQLERRM);
749: end;
750: end if;
743: exception
744: when others then
745: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
746: fnd_message.set_token('ROUTINE', l_api_name);
747: fnd_message.set_token('ERRNO', SQLCODE);
748: fnd_message.set_token('REASON', SQLERRM);
749: end;
750: end if;
751: end if;
744: when others then
745: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
746: fnd_message.set_token('ROUTINE', l_api_name);
747: fnd_message.set_token('ERRNO', SQLCODE);
748: fnd_message.set_token('REASON', SQLERRM);
749: end;
750: end if;
751: end if;
752:
786: end if;
787:
788: exception
789: when others then
790: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
791: fnd_message.set_token('ROUTINE', l_api_name);
792: fnd_message.set_token('ERRNO', SQLCODE);
793: fnd_message.set_token('REASON', SQLERRM);
794: end;
787:
788: exception
789: when others then
790: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
791: fnd_message.set_token('ROUTINE', l_api_name);
792: fnd_message.set_token('ERRNO', SQLCODE);
793: fnd_message.set_token('REASON', SQLERRM);
794: end;
795: end if;
788: exception
789: when others then
790: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
791: fnd_message.set_token('ROUTINE', l_api_name);
792: fnd_message.set_token('ERRNO', SQLCODE);
793: fnd_message.set_token('REASON', SQLERRM);
794: end;
795: end if;
796:
789: when others then
790: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
791: fnd_message.set_token('ROUTINE', l_api_name);
792: fnd_message.set_token('ERRNO', SQLCODE);
793: fnd_message.set_token('REASON', SQLERRM);
794: end;
795: end if;
796:
797: if (l_supplier_id is not null) then
830: end if;
831:
832: exception
833: when others then
834: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
835: fnd_message.set_token('ROUTINE', l_api_name);
836: fnd_message.set_token('ERRNO', SQLCODE);
837: fnd_message.set_token('REASON', SQLERRM);
838: end;
831:
832: exception
833: when others then
834: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
835: fnd_message.set_token('ROUTINE', l_api_name);
836: fnd_message.set_token('ERRNO', SQLCODE);
837: fnd_message.set_token('REASON', SQLERRM);
838: end;
839: end if;
832: exception
833: when others then
834: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
835: fnd_message.set_token('ROUTINE', l_api_name);
836: fnd_message.set_token('ERRNO', SQLCODE);
837: fnd_message.set_token('REASON', SQLERRM);
838: end;
839: end if;
840:
833: when others then
834: fnd_message.set_name( 'FND','SQL_PLSQL_ERROR' );
835: fnd_message.set_token('ROUTINE', l_api_name);
836: fnd_message.set_token('ERRNO', SQLCODE);
837: fnd_message.set_token('REASON', SQLERRM);
838: end;
839: end if;
840:
841: -- Sync user change to LDAP
899: p_parameters => l_parameter_list,
900: p_send_date => Sysdate);
901: exception
902: when others then
903: reason := fnd_message.get_encoded;
904: if (reason is not null) then
905: fnd_message.set_encoded(reason);
906: else
907: fnd_message.set_name('FND', 'FND_RAISE_EVENT_FAILED');
901: exception
902: when others then
903: reason := fnd_message.get_encoded;
904: if (reason is not null) then
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;
903: reason := fnd_message.get_encoded;
904: if (reason is not null) then
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;
1326: -- End Bug 4318754, 4424225
1327: exception
1328: when others then
1329: ROLLBACK to create_user;
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;
1327: exception
1328: when others then
1329: ROLLBACK to create_user;
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;
1328: when others then
1329: ROLLBACK to create_user;
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:
1329: ROLLBACK to create_user;
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
1431: p_send_date => Sysdate);
1432:
1433: exception
1434: when others then
1435: reason := fnd_message.get_encoded;
1436: if (reason is not null) then
1437: fnd_message.set_encoded(reason);
1438: else
1439: fnd_message.set_name('FND', 'FND_RAISE_EVENT_FAILED');
1433: exception
1434: when others then
1435: reason := fnd_message.get_encoded;
1436: if (reason is not null) then
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;
1435: reason := fnd_message.get_encoded;
1436: if (reason is not null) then
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:
1442: end;
1443:
1444: else -- fnd_web_sec.create_user must have failed.
1445: -- The java layer puts message onto the message stack.
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;
1443:
1444: else -- fnd_web_sec.create_user must have failed.
1445: -- The java layer puts message onto the message stack.
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;
1444: else -- fnd_web_sec.create_user must have failed.
1445: -- The java layer puts message onto the message stack.
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:
1445: -- The java layer puts message onto the message stack.
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);
1901: x_fax,
1902: x_customer_id,
1903: x_supplier_id);
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;
1902: x_customer_id,
1903: x_supplier_id);
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;
1903: x_supplier_id);
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;
1997: x_email_address,
1998: x_fax,
1999: x_person_party_id);
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;
1998: x_fax,
1999: x_person_party_id);
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;
1999: x_person_party_id);
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;
2699: tmpbuf);
2700: end if;
2701: exception
2702: when others then
2703: reason := fnd_message.get;
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);
2700: end if;
2701: exception
2702: when others then
2703: reason := fnd_message.get;
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;
2701: exception
2702: when others then
2703: reason := fnd_message.get;
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;
2702: when others then
2703: reason := fnd_message.get;
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: --------------------------------------------------------------------------
2703: reason := fnd_message.get;
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: --
2978: and responsibility_application_id = appid;
2979:
2980: exception
2981: when no_data_found then
2982: fnd_message.set_token('USER_NAME', username);
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);
2979:
2980: exception
2981: when no_data_found then
2982: fnd_message.set_token('USER_NAME', username);
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;
2980: exception
2981: when no_data_found then
2982: fnd_message.set_token('USER_NAME', username);
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;
2981: when no_data_found then
2982: fnd_message.set_token('USER_NAME', username);
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:
2982: fnd_message.set_token('USER_NAME', username);
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(
3051: where security_group_key = AddResp.security_group;
3052:
3053: exception
3054: when no_data_found then
3055: fnd_message.set_token('USER_NAME', username);
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);
3052:
3053: exception
3054: when no_data_found then
3055: fnd_message.set_token('USER_NAME', username);
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;
3053: exception
3054: when no_data_found then
3055: fnd_message.set_token('USER_NAME', username);
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;
3054: when no_data_found then
3055: fnd_message.set_token('USER_NAME', username);
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:
3055: fnd_message.set_token('USER_NAME', username);
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(
3196: l_party_name, l_party_type);
3197: exception
3198: when no_data_found then
3199: if (log_exception = 'Y') then
3200: fnd_message.set_name('FND', 'USER_INVALID_CUSTOMER');
3201: fnd_message.set_token('USER', user_name);
3202: fnd_message.set_token('CUSTID', l_customer_id);
3203: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3204: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3197: exception
3198: when no_data_found then
3199: if (log_exception = 'Y') then
3200: fnd_message.set_name('FND', 'USER_INVALID_CUSTOMER');
3201: fnd_message.set_token('USER', user_name);
3202: fnd_message.set_token('CUSTID', l_customer_id);
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);
3198: when no_data_found then
3199: if (log_exception = 'Y') then
3200: fnd_message.set_name('FND', 'USER_INVALID_CUSTOMER');
3201: fnd_message.set_token('USER', user_name);
3202: fnd_message.set_token('CUSTID', l_customer_id);
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;
3221: FND_OAM_USER_INFO.GET_ORGANIZATION_ID(l_customer_id);
3222: exception
3223: when no_data_found then
3224: if (log_exception = 'Y') then
3225: fnd_message.set_name('FND', 'USER_INVALID_PARTY_REL');
3226: fnd_message.set_token('USER', user_name);
3227: fnd_message.set_token('PNAME', l_party_name);
3228: fnd_message.set_token('CUSTID', l_customer_id);
3229: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3222: exception
3223: when no_data_found then
3224: if (log_exception = 'Y') then
3225: fnd_message.set_name('FND', 'USER_INVALID_PARTY_REL');
3226: fnd_message.set_token('USER', user_name);
3227: fnd_message.set_token('PNAME', l_party_name);
3228: fnd_message.set_token('CUSTID', l_customer_id);
3229: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3230: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3223: when no_data_found then
3224: if (log_exception = 'Y') then
3225: fnd_message.set_name('FND', 'USER_INVALID_PARTY_REL');
3226: fnd_message.set_token('USER', user_name);
3227: fnd_message.set_token('PNAME', l_party_name);
3228: fnd_message.set_token('CUSTID', l_customer_id);
3229: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3230: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3231: c_log_head || l_api_name || '.not_in_hz_party_relationships',
3224: if (log_exception = 'Y') then
3225: fnd_message.set_name('FND', 'USER_INVALID_PARTY_REL');
3226: fnd_message.set_token('USER', user_name);
3227: fnd_message.set_token('PNAME', l_party_name);
3228: fnd_message.set_token('CUSTID', l_customer_id);
3229: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3230: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3231: c_log_head || l_api_name || '.not_in_hz_party_relationships',
3232: FALSE);
3238: end;
3239: else
3240: if (log_exception = 'Y') then
3241: -- Invalid party type, raise error
3242: fnd_message.set_name('FND', 'USER_INVALID_PARTY_TYPE');
3243: fnd_message.set_token('USER', user_name);
3244: fnd_message.set_token('PNAME', l_party_name);
3245: fnd_message.set_token('PARTYID', l_customer_id);
3246: fnd_message.set_token('PARTY_TYPE', l_party_type);
3239: else
3240: if (log_exception = 'Y') then
3241: -- Invalid party type, raise error
3242: fnd_message.set_name('FND', 'USER_INVALID_PARTY_TYPE');
3243: fnd_message.set_token('USER', user_name);
3244: fnd_message.set_token('PNAME', l_party_name);
3245: fnd_message.set_token('PARTYID', l_customer_id);
3246: fnd_message.set_token('PARTY_TYPE', l_party_type);
3247: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3240: if (log_exception = 'Y') then
3241: -- Invalid party type, raise error
3242: fnd_message.set_name('FND', 'USER_INVALID_PARTY_TYPE');
3243: fnd_message.set_token('USER', user_name);
3244: fnd_message.set_token('PNAME', l_party_name);
3245: fnd_message.set_token('PARTYID', l_customer_id);
3246: fnd_message.set_token('PARTY_TYPE', l_party_type);
3247: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3248: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3241: -- Invalid party type, raise error
3242: fnd_message.set_name('FND', 'USER_INVALID_PARTY_TYPE');
3243: fnd_message.set_token('USER', user_name);
3244: fnd_message.set_token('PNAME', l_party_name);
3245: fnd_message.set_token('PARTYID', l_customer_id);
3246: fnd_message.set_token('PARTY_TYPE', l_party_type);
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);
3242: fnd_message.set_name('FND', 'USER_INVALID_PARTY_TYPE');
3243: fnd_message.set_token('USER', user_name);
3244: fnd_message.set_token('PNAME', l_party_name);
3245: fnd_message.set_token('PARTYID', l_customer_id);
3246: fnd_message.set_token('PARTY_TYPE', l_party_type);
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;
3273: l_emp_person_party_id := FND_OAM_USER_INFO.GET_PARTY_ID(l_employee_id);
3274: exception
3275: when no_data_found then
3276: if (log_exception = 'Y') then
3277: fnd_message.set_name('FND', 'USER_INVALID_EMPLOYEE');
3278: fnd_message.set_token('USER', user_name);
3279: fnd_message.set_token('EMPID', l_employee_id);
3280: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3281: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3274: exception
3275: when no_data_found then
3276: if (log_exception = 'Y') then
3277: fnd_message.set_name('FND', 'USER_INVALID_EMPLOYEE');
3278: fnd_message.set_token('USER', user_name);
3279: fnd_message.set_token('EMPID', l_employee_id);
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);
3275: when no_data_found then
3276: if (log_exception = 'Y') then
3277: fnd_message.set_name('FND', 'USER_INVALID_EMPLOYEE');
3278: fnd_message.set_token('USER', user_name);
3279: fnd_message.set_token('EMPID', l_employee_id);
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;
3299: l_cust_person_party_name,
3300: l_party_type);
3301: exception
3302: when no_data_found then
3303: fnd_message.set_name('FND', 'USER_CUST_PARTY_NOT_FOUND');
3304: fnd_message.set_token('USER', user_name);
3305: fnd_message.set_token('CUSTID', l_customer_id);
3306: if (fnd_log.LEVEL_EXCEPTION >=
3307: fnd_log.g_current_runtime_level) then
3300: l_party_type);
3301: exception
3302: when no_data_found then
3303: fnd_message.set_name('FND', 'USER_CUST_PARTY_NOT_FOUND');
3304: fnd_message.set_token('USER', user_name);
3305: fnd_message.set_token('CUSTID', l_customer_id);
3306: if (fnd_log.LEVEL_EXCEPTION >=
3307: fnd_log.g_current_runtime_level) then
3308: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3301: exception
3302: when no_data_found then
3303: fnd_message.set_name('FND', 'USER_CUST_PARTY_NOT_FOUND');
3304: fnd_message.set_token('USER', user_name);
3305: fnd_message.set_token('CUSTID', l_customer_id);
3306: if (fnd_log.LEVEL_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);
3316: l_emp_person_party_name,
3317: l_party_type);
3318: exception
3319: when no_data_found then
3320: fnd_message.set_name('FND', 'USER_EMP_PARTY_NOT_FOUND');
3321: fnd_message.set_token('USER', user_name);
3322: fnd_message.set_token('EMPID', l_emp_person_party_id);
3323: if (fnd_log.LEVEL_EXCEPTION >=
3324: fnd_log.g_current_runtime_level) then
3317: l_party_type);
3318: exception
3319: when no_data_found then
3320: fnd_message.set_name('FND', 'USER_EMP_PARTY_NOT_FOUND');
3321: fnd_message.set_token('USER', user_name);
3322: fnd_message.set_token('EMPID', l_emp_person_party_id);
3323: if (fnd_log.LEVEL_EXCEPTION >=
3324: fnd_log.g_current_runtime_level) then
3325: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3318: exception
3319: when no_data_found then
3320: fnd_message.set_name('FND', 'USER_EMP_PARTY_NOT_FOUND');
3321: fnd_message.set_token('USER', user_name);
3322: fnd_message.set_token('EMPID', l_emp_person_party_id);
3323: if (fnd_log.LEVEL_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);
3333: fnd_message.set_token('CUSTID', l_customer_id);
3334: fnd_message.set_token('CUSTPARTY', l_cust_person_party_name);
3335: fnd_message.set_token('EMPID', l_employee_id);
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);
3333: fnd_message.set_token('CUSTID', l_customer_id);
3334: fnd_message.set_token('CUSTPARTY', l_cust_person_party_name);
3335: fnd_message.set_token('EMPID', l_employee_id);
3336: fnd_message.set_token('EMPPARTY', l_emp_person_party_name);
3329: end;
3330:
3331: fnd_message.set_name('FND', 'USER_CUST_EMP_MISMATCH');
3332: fnd_message.set_token('USER', user_name);
3333: fnd_message.set_token('CUSTID', l_customer_id);
3334: fnd_message.set_token('CUSTPARTY', l_cust_person_party_name);
3335: fnd_message.set_token('EMPID', l_employee_id);
3336: fnd_message.set_token('EMPPARTY', l_emp_person_party_name);
3337: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3330:
3331: fnd_message.set_name('FND', 'USER_CUST_EMP_MISMATCH');
3332: fnd_message.set_token('USER', user_name);
3333: fnd_message.set_token('CUSTID', l_customer_id);
3334: fnd_message.set_token('CUSTPARTY', l_cust_person_party_name);
3335: fnd_message.set_token('EMPID', l_employee_id);
3336: fnd_message.set_token('EMPPARTY', l_emp_person_party_name);
3337: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3338: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3331: fnd_message.set_name('FND', 'USER_CUST_EMP_MISMATCH');
3332: fnd_message.set_token('USER', user_name);
3333: fnd_message.set_token('CUSTID', l_customer_id);
3334: fnd_message.set_token('CUSTPARTY', l_cust_person_party_name);
3335: fnd_message.set_token('EMPID', l_employee_id);
3336: fnd_message.set_token('EMPPARTY', l_emp_person_party_name);
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);
3332: fnd_message.set_token('USER', user_name);
3333: fnd_message.set_token('CUSTID', l_customer_id);
3334: fnd_message.set_token('CUSTPARTY', l_cust_person_party_name);
3335: fnd_message.set_token('EMPID', l_employee_id);
3336: fnd_message.set_token('EMPPARTY', l_emp_person_party_name);
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;
3406: l_person_party_name,
3407: l_party_type);
3408: exception
3409: when no_data_found then
3410: fnd_message.set_name('FND', 'USER_INVALID_PARTY');
3411: fnd_message.set_token('USER', user_name);
3412: fnd_message.set_token('PARTYID', l_person_party_id);
3413: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3414: fnd_log.message(FND_LOG.LEVEL_EXCEPTION,
3407: l_party_type);
3408: exception
3409: when no_data_found then
3410: fnd_message.set_name('FND', 'USER_INVALID_PARTY');
3411: fnd_message.set_token('USER', user_name);
3412: fnd_message.set_token('PARTYID', l_person_party_id);
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);
3408: exception
3409: when no_data_found then
3410: fnd_message.set_name('FND', 'USER_INVALID_PARTY');
3411: fnd_message.set_token('USER', user_name);
3412: fnd_message.set_token('PARTYID', l_person_party_id);
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;
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);
3422: fnd_message.set_token('PARTYID', l_person_party_id);
3423: fnd_message.set_token('PARTY_TYPE', l_party_type);
3424: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
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);
3422: fnd_message.set_token('PARTYID', l_person_party_id);
3423: fnd_message.set_token('PARTY_TYPE', l_party_type);
3424: if (fnd_log.LEVEL_EXCEPTION >= fnd_log.g_current_runtime_level) then
3425: fnd_log.message(FND_LOG.LEVEL_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);
3422: fnd_message.set_token('PARTYID', l_person_party_id);
3423: fnd_message.set_token('PARTY_TYPE', l_party_type);
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);
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);
3422: fnd_message.set_token('PARTYID', l_person_party_id);
3423: fnd_message.set_token('PARTY_TYPE', l_party_type);
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;
3610: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name,
3611: 'No disabled user');
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:
3611: 'No disabled user');
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
3649: if (fnd_log.LEVEL_STATEMENT >= fnd_log.g_current_runtime_level) then
3650: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name,
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:
3650: fnd_log.string(FND_LOG.LEVEL_STATEMENT, C_LOG_HEAD || l_api_name,
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
3704: from hz_parties
3705: where upper(party_name) = upper(x_party);
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:
3705: where upper(party_name) = upper(x_party);
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,
3735:
3736: fnd_ldap_wrapper.change_user_name(x_user_guid, x_old_user_name,
3737: x_new_user_name, l_result);
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;
3736: fnd_ldap_wrapper.change_user_name(x_user_guid, x_old_user_name,
3737: x_new_user_name, l_result);
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
3737: x_new_user_name, l_result);
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
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');
3747: fnd_message.set_token('REASON', sqlerrm);
3748: app_exception.raise_exception;
3749: end;
3750:
3743: end if;
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
3779:
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
3793: begin
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
3875: begin
3876: fnd_user_pkg.user_synch(upper(x_new_user_name));
3877: exception
3878: when others then
3879: reason := fnd_message.get;
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);
3876: fnd_user_pkg.user_synch(upper(x_new_user_name));
3877: exception
3878: when others then
3879: reason := fnd_message.get;
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;
3877: exception
3878: when others then
3879: reason := fnd_message.get;
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;
3878: when others then
3879: reason := fnd_message.get;
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:
3879: reason := fnd_message.get;
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
3911: p_send_date => Sysdate);
3912:
3913: exception
3914: when others then
3915: reason := fnd_message.get_encoded;
3916: if (reason is not null) then
3917: fnd_message.set_encoded(reason);
3918: else
3919: fnd_message.set_name('FND', 'FND_RAISE_EVENT_FAILED');
3913: exception
3914: when others then
3915: reason := fnd_message.get_encoded;
3916: if (reason is not null) then
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;
3915: reason := fnd_message.get_encoded;
3916: if (reason is not null) then
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
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:
3925: 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;
4010: uname varchar2(100);
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');
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;
4020: elsif (instr(x_user_name, '/') > 0 OR
4021: instr(x_user_name, '"') > 0 OR
4022: instr(x_user_name, '(') > 0 OR
4029: instr(x_user_name, '>') > 0 OR
4030: instr(x_user_name, '\') > 0 OR
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
4030: instr(x_user_name, '\') > 0 OR
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.
4043: p_parameters => NULL,
4044: p_send_date => Sysdate);
4045: exception
4046: when others then
4047: msg := fnd_message.get_encoded;
4048: if (msg is not null) then
4049: fnd_message.set_encoded(msg);
4050: else
4051: fnd_message.set_name('FND', 'FND_CUST_UNAME_VALIDATE_FAILED');
4045: exception
4046: when others then
4047: msg := fnd_message.get_encoded;
4048: if (msg is not null) then
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;
4047: msg := fnd_message.get_encoded;
4048: if (msg is not null) then
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
4280: return(USER_INVALID_NAME);
4281: end;
4282:
4283: if (fnd_user_pkg.userExists(x_user_name)) then
4284: fnd_message.set_name('FND', 'FND_USER_EXISTS_IN_FND');
4285: return(USER_EXISTS_IN_FND);
4286: else
4287: begin
4288: retval := fnd_ldap_wrapper.user_exists(x_user_name);
4295: -- The above check return that user exists in oid.
4296: fnd_profile.get('APPS_SSO_LINK_SAME_NAMES', pf);
4297:
4298: if(pf = 'Y') then
4299: fnd_message.set_name('FND', 'FND_USER_SYNCHED');
4300: fnd_message.set_token('USER_NAME', x_user_name);
4301: return(USER_SYNCHED);
4302: -- next time when this user gets created in fnd, it will be
4303: -- linked to each other.
4296: fnd_profile.get('APPS_SSO_LINK_SAME_NAMES', pf);
4297:
4298: if(pf = 'Y') then
4299: fnd_message.set_name('FND', 'FND_USER_SYNCHED');
4300: fnd_message.set_token('USER_NAME', x_user_name);
4301: return(USER_SYNCHED);
4302: -- next time when this user gets created in fnd, it will be
4303: -- linked to each other.
4304: else
4301: return(USER_SYNCHED);
4302: -- next time when this user gets created in fnd, it will be
4303: -- linked to each other.
4304: else
4305: fnd_message.set_name('FND', 'FND_USER_EXISTS_NO_LINK');
4306: return(USER_EXISTS_NO_LINK_ALLOWED);
4307: end if;
4308: else
4309: return(USER_OK_CREATE);
4460: l_pwd, x_start_date, x_end_date, x_description,
4461: x_email_address, x_fax, x_expire_pwd, l_pwd_ret, l_result);
4462:
4463: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
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;
4461: x_email_address, x_fax, x_expire_pwd, l_pwd_ret, l_result);
4462:
4463: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
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
4462:
4463: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
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;
4463: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
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:
4476: return(null);
4477: end if;
4478: 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;
4477: end if;
4478: 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
4478: 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
4599: -- Add third argument to not use autonomous transaction when chaning
4600: -- passowrd. This is for bug 5087728
4601: ret := fnd_web_sec.change_password(x_user_name, l_oid_pwd, FALSE);
4602: if (ret = 'N') then
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;
4600: -- passowrd. This is for bug 5087728
4601: ret := fnd_web_sec.change_password(x_user_name, l_oid_pwd, FALSE);
4602: if (ret = 'N') then
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;
4601: ret := fnd_web_sec.change_password(x_user_name, l_oid_pwd, FALSE);
4602: if (ret = 'N') then
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;
4602: if (ret = 'N') then
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:
4742: x_hashed_password, x_start_date, x_end_date, x_description,
4743: x_email_address, x_fax, x_expire_pwd, l_pwd_ret, l_result);
4744:
4745: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
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;
4743: x_email_address, x_fax, x_expire_pwd, l_pwd_ret, l_result);
4744:
4745: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
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;
4744:
4745: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
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:
4745: if (l_result <> fnd_ldap_wrapper.G_SUCCESS) then
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
4758: end if;
4759:
4760: 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:
4759:
4760: 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;
4760: 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: