display data as per user's Preferences

Hi

We have a  requirement to show the reports data (date fields) in the user's below Preferences.

Date Format

Timezone

Current Session Language

Regarding date format and timezone, i tried to use below to convert

TO_CHAR(apps.hz_timezone_pub.Convert_DateTime(apps.fnd_profile.value('SERVER_TIMEZONE_ID'),
apps.FND_PROFILE.VALUE_SPECIFIC('CLIENT_TIMEZONE_ID',apps.FND_GLOBAL.USER_ID),
systimestamp),apps.FND_PROFILE.VALUE_SPECIFIC('ICX_DATE_FORMAT_MASK',
apps.FND_GLOBAL.USER_ID))

But it's not working.

Regarding lanuguage, i tried below:

LANGUAGE = USERENV('LANG')

it's not working.

Please share your thoughts on this.

Thanks&Regards