897:
898: -- =======================
899: -- loading messages
900: -- =======================
901: l_none_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_NONE');
902: l_na_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_NA_LBL'));
903: l_un_auth := BIS_UTILITIES_PVT.Get_FND_Message('BIS_UNAUTHORIZED');
904:
905: -- header labels
898: -- =======================
899: -- loading messages
900: -- =======================
901: l_none_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_NONE');
902: l_na_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_NA_LBL'));
903: l_un_auth := BIS_UTILITIES_PVT.Get_FND_Message('BIS_UNAUTHORIZED');
904:
905: -- header labels
906: l_status_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_STATUS');
899: -- loading messages
900: -- =======================
901: l_none_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_NONE');
902: l_na_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_NA_LBL'));
903: l_un_auth := BIS_UTILITIES_PVT.Get_FND_Message('BIS_UNAUTHORIZED');
904:
905: -- header labels
906: l_status_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_STATUS');
907: l_measure_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_NAME');
902: l_na_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_NA_LBL'));
903: l_un_auth := BIS_UTILITIES_PVT.Get_FND_Message('BIS_UNAUTHORIZED');
904:
905: -- header labels
906: l_status_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_STATUS');
907: l_measure_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_NAME');
908: l_value_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_VALUE_LBL');
909: l_change_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE'));
910: l_perc_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_PERC_LBL'));
903: l_un_auth := BIS_UTILITIES_PVT.Get_FND_Message('BIS_UNAUTHORIZED');
904:
905: -- header labels
906: l_status_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_STATUS');
907: l_measure_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_NAME');
908: l_value_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_VALUE_LBL');
909: l_change_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE'));
910: l_perc_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_PERC_LBL'));
911:
904:
905: -- header labels
906: l_status_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_STATUS');
907: l_measure_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_NAME');
908: l_value_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_VALUE_LBL');
909: l_change_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE'));
910: l_perc_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_PERC_LBL'));
911:
912: -- msgs
905: -- header labels
906: l_status_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_STATUS');
907: l_measure_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_NAME');
908: l_value_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_VALUE_LBL');
909: l_change_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE'));
910: l_perc_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_PERC_LBL'));
911:
912: -- msgs
913: l_in_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_WITHIN_RANGE');
906: l_status_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_STATUS');
907: l_measure_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_NAME');
908: l_value_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_VALUE_LBL');
909: l_change_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE'));
910: l_perc_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_PERC_LBL'));
911:
912: -- msgs
913: l_in_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_WITHIN_RANGE');
914: l_out_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_OUTSIDE_RANGE');
909: l_change_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE'));
910: l_perc_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_PERC_LBL'));
911:
912: -- msgs
913: l_in_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_WITHIN_RANGE');
914: l_out_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_OUTSIDE_RANGE');
915: l_worse_msg := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE_WORSE');
916: l_improve_msg := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE_IMPROVE');
917:
910: l_perc_lbl := (BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_PERC_LBL'));
911:
912: -- msgs
913: l_in_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_WITHIN_RANGE');
914: l_out_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_OUTSIDE_RANGE');
915: l_worse_msg := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE_WORSE');
916: l_improve_msg := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE_IMPROVE');
917:
918:
911:
912: -- msgs
913: l_in_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_WITHIN_RANGE');
914: l_out_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_OUTSIDE_RANGE');
915: l_worse_msg := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE_WORSE');
916: l_improve_msg := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE_IMPROVE');
917:
918:
919: -- =======================
912: -- msgs
913: l_in_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_WITHIN_RANGE');
914: l_out_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_OUTSIDE_RANGE');
915: l_worse_msg := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE_WORSE');
916: l_improve_msg := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_CHANGE_IMPROVE');
917:
918:
919: -- =======================
920: -- Begin Main block
1108: RETURN;
1109: END IF;
1110:
1111: -- demo is on
1112: l_url_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_PMF_ENTER_PT_DATA');
1113:
1114: l_servlet_agent := FND_WEB_CONFIG.JSP_AGENT; -- 'http://serv:port/OA_HTML/'
1115: IF ( l_servlet_agent IS NULL ) THEN -- 'APPS_SERVLET_AGENT' is null
1116: l_servlet_agent := FND_WEB_CONFIG.WEB_SERVER || 'OA_HTML/';
1220: l_nbsp := '&'||'nbsp;';
1221: l_initialize := ' ';
1222:
1223: -- Get all the message strings from the database
1224: fnd_message.set_name('BIS','BIS_SELECT_TARLEVEL');
1225: l_select_tarlevel := icx_util.replace_quotes(fnd_message.get);
1226: --changed from BIS_DUP_TARLEVEL to BIS_DUP_TARLEVELS
1227: fnd_message.set_name('BIS','BIS_DUP_TARLEVELS');
1228: l_dup_tarlevel := icx_util.replace_quotes(fnd_message.get);
1221: l_initialize := ' ';
1222:
1223: -- Get all the message strings from the database
1224: fnd_message.set_name('BIS','BIS_SELECT_TARLEVEL');
1225: l_select_tarlevel := icx_util.replace_quotes(fnd_message.get);
1226: --changed from BIS_DUP_TARLEVEL to BIS_DUP_TARLEVELS
1227: fnd_message.set_name('BIS','BIS_DUP_TARLEVELS');
1228: l_dup_tarlevel := icx_util.replace_quotes(fnd_message.get);
1229:
1223: -- Get all the message strings from the database
1224: fnd_message.set_name('BIS','BIS_SELECT_TARLEVEL');
1225: l_select_tarlevel := icx_util.replace_quotes(fnd_message.get);
1226: --changed from BIS_DUP_TARLEVEL to BIS_DUP_TARLEVELS
1227: fnd_message.set_name('BIS','BIS_DUP_TARLEVELS');
1228: l_dup_tarlevel := icx_util.replace_quotes(fnd_message.get);
1229:
1230: -- Create a dummy value in the indicators table to send it
1231: -- to the next proc because one of parameters is a plsql table
1224: fnd_message.set_name('BIS','BIS_SELECT_TARLEVEL');
1225: l_select_tarlevel := icx_util.replace_quotes(fnd_message.get);
1226: --changed from BIS_DUP_TARLEVEL to BIS_DUP_TARLEVELS
1227: fnd_message.set_name('BIS','BIS_DUP_TARLEVELS');
1228: l_dup_tarlevel := icx_util.replace_quotes(fnd_message.get);
1229:
1230: -- Create a dummy value in the indicators table to send it
1231: -- to the next proc because one of parameters is a plsql table
1232: -- which cannot be nullable
1305: l_string := l_string || '';
1306:
1307:
1308: -- Print out NOCOPY the instructions for this page
1309: fnd_message.set_name('BIS','BIS_PLUG_INSTRUCTION1');
1310: l_instruction := bis_utilities_pvt.escape_html_input(icx_util.replace_quotes(fnd_message.get));
1311: l_string := l_string ||'
';
1312: l_string := l_string ||'
';Line 1310: l_instruction := bis_utilities_pvt.escape_html_input(icx_util.replace_quotes(fnd_message.get)); |
'; 1314: l_string := l_string ||l_instruction||' |
'||l_instruction||' |
'||l_instruction||' |
3584: V := REPLACE(V,' ',c_hash);
3585:
3586:
3587: -- Set the message strings from the database
3588: fnd_message.set_name('BIS','BIS_ENTER_DISPLABEL');
3589: l_enter_displabel := icx_util.replace_quotes(fnd_message.get);
3590: fnd_message.set_name('BIS','BIS_SELECT_DISPLABEL');
3591: l_select_displabel := icx_util.replace_quotes(fnd_message.get);
3592: fnd_message.set_name('BIS','BIS_DUP_DISPLABEL');
3585:
3586:
3587: -- Set the message strings from the database
3588: fnd_message.set_name('BIS','BIS_ENTER_DISPLABEL');
3589: l_enter_displabel := icx_util.replace_quotes(fnd_message.get);
3590: fnd_message.set_name('BIS','BIS_SELECT_DISPLABEL');
3591: l_select_displabel := icx_util.replace_quotes(fnd_message.get);
3592: fnd_message.set_name('BIS','BIS_DUP_DISPLABEL');
3593: l_dup_displabel := icx_util.replace_quotes(fnd_message.get);
3586:
3587: -- Set the message strings from the database
3588: fnd_message.set_name('BIS','BIS_ENTER_DISPLABEL');
3589: l_enter_displabel := icx_util.replace_quotes(fnd_message.get);
3590: fnd_message.set_name('BIS','BIS_SELECT_DISPLABEL');
3591: l_select_displabel := icx_util.replace_quotes(fnd_message.get);
3592: fnd_message.set_name('BIS','BIS_DUP_DISPLABEL');
3593: l_dup_displabel := icx_util.replace_quotes(fnd_message.get);
3594: fnd_message.set_name('BIS','BIS_DUP_COMBO');
3587: -- Set the message strings from the database
3588: fnd_message.set_name('BIS','BIS_ENTER_DISPLABEL');
3589: l_enter_displabel := icx_util.replace_quotes(fnd_message.get);
3590: fnd_message.set_name('BIS','BIS_SELECT_DISPLABEL');
3591: l_select_displabel := icx_util.replace_quotes(fnd_message.get);
3592: fnd_message.set_name('BIS','BIS_DUP_DISPLABEL');
3593: l_dup_displabel := icx_util.replace_quotes(fnd_message.get);
3594: fnd_message.set_name('BIS','BIS_DUP_COMBO');
3595: l_dup_combo := icx_util.replace_quotes(fnd_message.get);
3588: fnd_message.set_name('BIS','BIS_ENTER_DISPLABEL');
3589: l_enter_displabel := icx_util.replace_quotes(fnd_message.get);
3590: fnd_message.set_name('BIS','BIS_SELECT_DISPLABEL');
3591: l_select_displabel := icx_util.replace_quotes(fnd_message.get);
3592: fnd_message.set_name('BIS','BIS_DUP_DISPLABEL');
3593: l_dup_displabel := icx_util.replace_quotes(fnd_message.get);
3594: fnd_message.set_name('BIS','BIS_DUP_COMBO');
3595: l_dup_combo := icx_util.replace_quotes(fnd_message.get);
3596: fnd_message.set_name('BIS','BIS_CHOOSE_DIM_VALUE');
3589: l_enter_displabel := icx_util.replace_quotes(fnd_message.get);
3590: fnd_message.set_name('BIS','BIS_SELECT_DISPLABEL');
3591: l_select_displabel := icx_util.replace_quotes(fnd_message.get);
3592: fnd_message.set_name('BIS','BIS_DUP_DISPLABEL');
3593: l_dup_displabel := icx_util.replace_quotes(fnd_message.get);
3594: fnd_message.set_name('BIS','BIS_DUP_COMBO');
3595: l_dup_combo := icx_util.replace_quotes(fnd_message.get);
3596: fnd_message.set_name('BIS','BIS_CHOOSE_DIM_VALUE');
3597: l_choose_dim_value := icx_util.replace_quotes(fnd_message.get);
3590: fnd_message.set_name('BIS','BIS_SELECT_DISPLABEL');
3591: l_select_displabel := icx_util.replace_quotes(fnd_message.get);
3592: fnd_message.set_name('BIS','BIS_DUP_DISPLABEL');
3593: l_dup_displabel := icx_util.replace_quotes(fnd_message.get);
3594: fnd_message.set_name('BIS','BIS_DUP_COMBO');
3595: l_dup_combo := icx_util.replace_quotes(fnd_message.get);
3596: fnd_message.set_name('BIS','BIS_CHOOSE_DIM_VALUE');
3597: l_choose_dim_value := icx_util.replace_quotes(fnd_message.get);
3598:
3591: l_select_displabel := icx_util.replace_quotes(fnd_message.get);
3592: fnd_message.set_name('BIS','BIS_DUP_DISPLABEL');
3593: l_dup_displabel := icx_util.replace_quotes(fnd_message.get);
3594: fnd_message.set_name('BIS','BIS_DUP_COMBO');
3595: l_dup_combo := icx_util.replace_quotes(fnd_message.get);
3596: fnd_message.set_name('BIS','BIS_CHOOSE_DIM_VALUE');
3597: l_choose_dim_value := icx_util.replace_quotes(fnd_message.get);
3598:
3599: -- Unpack the one element that was selected for edit from the Favorites box
3592: fnd_message.set_name('BIS','BIS_DUP_DISPLABEL');
3593: l_dup_displabel := icx_util.replace_quotes(fnd_message.get);
3594: fnd_message.set_name('BIS','BIS_DUP_COMBO');
3595: l_dup_combo := icx_util.replace_quotes(fnd_message.get);
3596: fnd_message.set_name('BIS','BIS_CHOOSE_DIM_VALUE');
3597: l_choose_dim_value := icx_util.replace_quotes(fnd_message.get);
3598:
3599: -- Unpack the one element that was selected for edit from the Favorites box
3600: -- to obtain individual dim_level_value id's
3593: l_dup_displabel := icx_util.replace_quotes(fnd_message.get);
3594: fnd_message.set_name('BIS','BIS_DUP_COMBO');
3595: l_dup_combo := icx_util.replace_quotes(fnd_message.get);
3596: fnd_message.set_name('BIS','BIS_CHOOSE_DIM_VALUE');
3597: l_choose_dim_value := icx_util.replace_quotes(fnd_message.get);
3598:
3599: -- Unpack the one element that was selected for edit from the Favorites box
3600: -- to obtain individual dim_level_value id's
3601: l_length := length(V);
5787: -- Image_Directory := FND_WEB_CONFIG.TRAIL_SLASH(ICX_REPORT_IMAGES);
5788: Image_Directory := BIS_REPORT_UTIL_PVT.get_Images_Server;
5789:
5790: Home_URL := BIS_REPORT_UTIL_PVT.Get_Home_URL;
5791: l_section_header := FND_MESSAGE.GET_STRING('BIS','BIS_SPECIFY_PARAMS');
5792:
5793: l_HTML_Header :=
5794: '
6524: l_result VARCHAR2(1000);
6525:
6526: BEGIN
6527: IF ( p_val IS NULL) THEN -- should not go here
6528: RETURN BIS_UTILITIES_PVT.Get_FND_Message('BIS_NONE');
6529: END IF;
6530:
6531: get_region_code( p_measure_id => p_measure_id
6532: ,x_region_code => l_region_code
6724: l_wh_val NUMBER;
6725: l_abs_val NUMBER;
6726: BEGIN
6727: IF ( p_val IS NULL) THEN -- should not go here
6728: RETURN BIS_UTILITIES_PVT.Get_FND_Message('BIS_NONE');
6729: END IF;
6730:
6731: l_abs_val := ABS(p_val);
6732: l_wh_val := FLOOR(l_abs_val);
6813: IS
6814:
6815: BEGIN
6816: IF ( p_val IS NULL) THEN -- should not go here
6817: RETURN BIS_UTILITIES_PVT.Get_FND_Message('BIS_NONE');
6818: END IF;
6819:
6820: IF ( p_format_mask IS NULL) THEN
6821: RETURN getFormatValue(p_val);
7064: l_out_range_lbl VARCHAR2(2000);
7065: l_gif VARCHAR2(100);
7066: BEGIN
7067:
7068: l_in_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_WITHIN_RANGE');
7069: l_out_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_OUTSIDE_RANGE');
7070: IF ( p_status = 1 ) THEN
7071: l_gif := 'bisinrng.gif';
7072: l_range_lbl := l_in_range_lbl;
7065: l_gif VARCHAR2(100);
7066: BEGIN
7067:
7068: l_in_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_WITHIN_RANGE');
7069: l_out_range_lbl := BIS_UTILITIES_PVT.Get_FND_Message('BIS_OUTSIDE_RANGE');
7070: IF ( p_status = 1 ) THEN
7071: l_gif := 'bisinrng.gif';
7072: l_range_lbl := l_in_range_lbl;
7073: ELSIF ( p_status = 2 ) THEN