DBA Data[Home] [Help]

APPS.BIX_UTIL_PKG dependencies on FND_MESSAGE

Line 166: RETURN FND_MESSAGE.GET_STRING('BIX','BIX_DM_REFRESH_MSG') || ' '|| l_max_date;

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;
170: END BIX_DM_GET_FOOTER;

Line 183: RETURN FND_MESSAGE.GET_STRING('BIX','BIX_DM_REFRESH_MSG') || ' '|| l_max_date;

179: l_date_format := 'MM/DD/YYYY';
180: END IF;
181: l_date_format := l_date_format||' HH24:MI:SS';
182: l_max_date := to_char(sysdate, l_date_format);
183: RETURN FND_MESSAGE.GET_STRING('BIX','BIX_DM_REFRESH_MSG') || ' '|| l_max_date;
184: EXCEPTION
185: WHEN OTHERS THEN
186: RETURN NULL;
187: END BIX_REAL_GET_FOOTER;

Line 222: RETURN FND_MESSAGE.GET_STRING('BIX','BIX_DM_REFRESH_MSG') || ' '|| l_max_date;

218: ELSE
219: l_max_date := to_char(l_uwq_max_date,l_date_format)|| ' 00:00:00';
220: END IF;
221:
222: RETURN FND_MESSAGE.GET_STRING('BIX','BIX_DM_REFRESH_MSG') || ' '|| l_max_date;
223:
224: EXCEPTION
225: WHEN OTHERS THEN
226: RETURN NULL;

Line 262: RETURN FND_MESSAGE.GET_STRING('BIX','BIX_DM_REFRESH_MSG') || ' '||

258: ELSE
259: l_max_date := to_char(l_uwq_max_date,l_date_format)|| ' 00:00:00';
260: END IF;
261:
262: RETURN FND_MESSAGE.GET_STRING('BIX','BIX_DM_REFRESH_MSG') || ' '||
263: l_max_date || ' '||
264: FND_MESSAGE.GET_STRING('BIX','BIX_DM_DURATION_FORMAT');
265: EXCEPTION
266: WHEN OTHERS THEN

Line 264: FND_MESSAGE.GET_STRING('BIX','BIX_DM_DURATION_FORMAT');

260: END IF;
261:
262: RETURN FND_MESSAGE.GET_STRING('BIX','BIX_DM_REFRESH_MSG') || ' '||
263: l_max_date || ' '||
264: FND_MESSAGE.GET_STRING('BIX','BIX_DM_DURATION_FORMAT');
265: EXCEPTION
266: WHEN OTHERS THEN
267: RETURN NULL;
268: END GET_UWQ_DURATION_FOOTER;

Line 283: RETURN FND_MESSAGE.GET_STRING('BIX','BIX_DM_REFRESH_MSG') || ' '|| l_max_date;

279: l_date_format := l_date_format||' HH24:MI:SS';
280: SELECT to_char(sysdate,l_date_format)
281: INTO l_max_date
282: FROM dual;
283: RETURN FND_MESSAGE.GET_STRING('BIX','BIX_DM_REFRESH_MSG') || ' '|| l_max_date;
284: EXCEPTION
285: WHEN OTHERS THEN
286: RETURN NULL;
287: END GET_REALTIME_FOOTER;

Line 638: RETURN FND_MESSAGE.GET_STRING('BIX','BIX_DM_REFRESH_MSG') || ' '|| l_max_date;

634: SELECT to_char(MAX(period_start_date_time),l_date_format)
635: INTO l_max_date
636: FROM bix_dm_agent_sum;
637:
638: RETURN FND_MESSAGE.GET_STRING('BIX','BIX_DM_REFRESH_MSG') || ' '|| l_max_date;
639:
640: EXCEPTION
641: WHEN OTHERS THEN
642: RETURN NULL;

Line 662: RETURN FND_MESSAGE.GET_STRING('BIX','BIX_DM_REFRESH_MSG') || ' '|| l_max_date;

658: SELECT to_char(MAX(period_start_date_time),l_date_format)
659: INTO l_max_date
660: FROM bix_dm_call_sum;
661:
662: RETURN FND_MESSAGE.GET_STRING('BIX','BIX_DM_REFRESH_MSG') || ' '|| l_max_date;
663:
664: EXCEPTION
665: WHEN OTHERS THEN
666: RETURN NULL;