141: END IF;
142: l_date_format := l_date_format||' HH24:MI:SS';
143: SELECT to_char(MAX(period_start_date_time),l_date_format)
144: INTO l_max_date
145: FROM bix_dm_agent_call_sum;
146: RETURN l_max_date;
147: EXCEPTION
148: WHEN OTHERS
149: THEN
161: END IF;
162: l_date_format := l_date_format||' HH24:MI:SS';
163: SELECT to_char(MAX(period_start_date_time),l_date_format)
164: INTO l_max_date
165: FROM bix_dm_agent_call_sum;
166: RETURN FND_MESSAGE.GET_STRING('BIX','BIX_DM_REFRESH_MSG') || ' '|| l_max_date;
167: EXCEPTION
168: WHEN OTHERS THEN
169: RETURN NULL;