516: x_message_data := fnd_message.get;
517: return;
518: end if;
519: */
520: IF FND_SSO_Manager.isPasswordChangeable( p_name ) THEN
521: WF_DIRECTORY.GetRoleInfo(p_name, display_name,
522: email_address, notification_preference, language, territory);
523:
524:
666: where user_name = p_name
667: and start_date <= sysdate
668: and nvl(end_date, sysdate + 1) > sysdate;
669:
670: IF FND_SSO_Manager.isPasswordChangeable( p_name ) THEN
671: WF_DIRECTORY.GetRoleInfo(p_name, display_name,
672: email_address, notification_preference, language, territory);
673:
674: if email_address is null then