[Home] [Help]
1295: begin
1296:
1297: --moved the code out of if condition for enhancement 4638578
1298: --CODE FIX FOR 4653272, CHANGED form apps_web_agent to apps_jsp_agent
1299: l_web_agent:=fnd_profile.value('APPS_JSP_AGENT');
1300: log(l_module, 'applications web agent:'||l_web_agent);
1301: log(l_module, 'getting the refresh details');
1302: open c_form_function;
1303: fetch c_form_function into l_function_id,l_function_html,l_function_parameters;
1310:
1311: if p_obj_type='PAGE' then
1312: if l_last_refresh_date is not null and l_last_refresh_date<>to_date('01-01-1900','DD-MM-YYYY') then
1313: --bug 4314736
1314: --l_formatted_date:=to_char(l_last_refresh_date,fnd_profile.value_specific('ICX_DATE_FORMAT_MASK'));
1315: l_formatted_date:= BIS_RSG_PMV_REPORT_PKG.date_to_charDTTZ(l_last_refresh_date);
1316:
1317: l_message_text1:=fnd_message.get_string('BIS','BIS_BIA_PMV_RFH_DATE_API_MSG');
1318: log(l_module, 'message text:'||l_message_text1);
1348: if p_obj_type in ('REPORT','PORTLET','TABLE','VIEW','MV') then
1349: if l_last_refresh_date is not null and l_last_refresh_date<>to_date('01-01-1900','DD-MM-YYYY') then
1350: l_message_text1:=fnd_message.get_string('BIS','BIS_BIA_PMV_RFH_DATE_API_MSG');
1351: --bug 4314736
1352: --l_formatted_date:=to_char(l_last_refresh_date,fnd_profile.value_specific('ICX_DATE_FORMAT_MASK'));
1353: l_formatted_date:= BIS_RSG_PMV_REPORT_PKG.date_to_charDTTZ(l_last_refresh_date);
1354:
1355: if p_url_flag='Y' then
1356: l_return_string:=''||l_message_text1||' '||'