12: END IF;
13: l_date_format := l_date_format||' HH24:MI:SS';
14: SELECT to_char(MAX(period_start_date_time),l_date_format)
15: INTO l_max_date
16: FROM bix_dm_email_sum;
17: RETURN FND_MESSAGE.GET_STRING('BIX','BIX_DM_REFRESH_MSG') || ' '|| l_max_date;
18: EXCEPTION
19: WHEN OTHERS THEN
20: RETURN NULL;
31: END IF;
32: l_date_format := l_date_format||' HH24:MI:SS';
33: SELECT to_char(MAX(period_start_date_time),l_date_format)
34: INTO l_max_date
35: FROM bix_dm_email_sum;
36: RETURN l_max_date;
37: EXCEPTION
38: WHEN OTHERS THEN
39: RETURN NULL;