eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BSC_PORTLET_GRAPH dependencies on BSC_PORTLET_UTIL

Line 109: TRUE, bsc_portlet_util.VALUE_NOT_SET,

105:
106: ELSE -- no priviledge
107: l_ctm_url:= bsc_portlet_graph.get_customized_kpigraph_url(
108: p_session_id, p_plug_id, l_tab_id, l_kpi_id,
109: TRUE, bsc_portlet_util.VALUE_NOT_SET,
110: p_display_name);
111:
112: l_target_url := bsc_portlet_util.get_bsc_url(p_session_id, p_plug_id, 'BscPorWarnNoPriv.jsp', NULL, TRUE);
113:

Line 112: l_target_url := bsc_portlet_util.get_bsc_url(p_session_id, p_plug_id, 'BscPorWarnNoPriv.jsp', NULL, TRUE);

108: p_session_id, p_plug_id, l_tab_id, l_kpi_id,
109: TRUE, bsc_portlet_util.VALUE_NOT_SET,
110: p_display_name);
111:
112: l_target_url := bsc_portlet_util.get_bsc_url(p_session_id, p_plug_id, 'BscPorWarnNoPriv.jsp', NULL, TRUE);
113:
114: END IF; -- (bsc_portlet_graph.has_access(p_plug_id))
115:
116:

Line 123: TRUE, bsc_portlet_util.VALUE_NOT_SET, p_display_name);

119: -- no kpi selected, should be empty graph
120: --------------------------------------------
121: l_ctm_url:= bsc_portlet_graph.get_customized_kpigraph_url(
122: p_session_id, p_plug_id, l_tab_id, l_kpi_id,
123: TRUE, bsc_portlet_util.VALUE_NOT_SET, p_display_name);
124:
125:
126: ----------------------------------------------
127: -- bug# 1745058, make sure if no row in BSC_USER_KPIGRAPH_PLUGS

Line 133: l_target_url := bsc_portlet_util.get_bsc_url(p_session_id, p_plug_id, 'BscPorWarnEmpty.jsp', NULL, TRUE);

129: OPEN c_plug;
130: FETCH c_plug INTO l_temp;
131:
132: IF c_plug%NOTFOUND THEN -- no row
133: l_target_url := bsc_portlet_util.get_bsc_url(p_session_id, p_plug_id, 'BscPorWarnEmpty.jsp', NULL, TRUE);
134:
135: ELSE -- has customized already
136:
137: ----------------------------------------------

Line 144: l_target_url := bsc_portlet_util.get_bsc_url(p_session_id, p_plug_id, 'BscPorWarnEmpty.jsp', NULL, TRUE);

140: ----------------------------------------------
141: OPEN c_tab_kpi;
142: FETCH c_tab_kpi INTO l_temp;
143: IF c_tab_kpi%FOUND THEN
144: l_target_url := bsc_portlet_util.get_bsc_url(p_session_id, p_plug_id, 'BscPorWarnEmpty.jsp', NULL, TRUE);
145:
146: ELSE -- uncheck from the tab in builder
147: l_target_url := bsc_portlet_util.get_bsc_url(p_session_id, p_plug_id, 'BscPorWarnNoPriv.jsp', NULL, TRUE);
148:

Line 147: l_target_url := bsc_portlet_util.get_bsc_url(p_session_id, p_plug_id, 'BscPorWarnNoPriv.jsp', NULL, TRUE);

143: IF c_tab_kpi%FOUND THEN
144: l_target_url := bsc_portlet_util.get_bsc_url(p_session_id, p_plug_id, 'BscPorWarnEmpty.jsp', NULL, TRUE);
145:
146: ELSE -- uncheck from the tab in builder
147: l_target_url := bsc_portlet_util.get_bsc_url(p_session_id, p_plug_id, 'BscPorWarnNoPriv.jsp', NULL, TRUE);
148:
149:
150: END IF; --c_tab_kpi%FOUND
151: CLOSE c_tab_kpi;

Line 372: l_html_pieces := bsc_portlet_util.request_html_pieces(p_url => p_target_url);

368: l_ask := l_display_name;
369: END IF;
370: -----------------------------------------------------------------
371: --l_html_pieces := bsc_portlet_graph.re_align_html_pieces(utl_http.request_pieces(url => p_target_url, max_pieces => 32000));
372: l_html_pieces := bsc_portlet_util.request_html_pieces(p_url => p_target_url);
373:
374:
375: -----------------------------------------------------------------
376:

Line 516: l_kpi_url:= bsc_portlet_util.get_bsc_url(p_session_id,

512:
513:
514: IF icx_sec.validatePlugSession(p_plug_id,p_session_id) THEN
515:
516: l_kpi_url:= bsc_portlet_util.get_bsc_url(p_session_id,
517: p_plug_id, 'BscInit.jsp', NULL, FALSE);
518:
519: htp.p('' || '');
520: END IF; -- icx_sec.validatePlugSession

Line 561: bsc_portlet_util.decrypt_plug_info(p_cookie_value,

557: l_session_id NUMBER := -1;
558: l_plug_id NUMBER := -1;
559: BEGIN
560:
561: bsc_portlet_util.decrypt_plug_info(p_cookie_value,
562: p_encrypted_plug_id, l_session_id, l_plug_id);
563:
564: RETURN get_tab_url(l_session_id, l_plug_id);
565:

Line 597: bsc_portlet_util.decrypt_plug_info(p_cookie_value,

593: l_session_id NUMBER := -1;
594: l_plug_id NUMBER := -1;
595: BEGIN
596:
597: bsc_portlet_util.decrypt_plug_info(p_cookie_value,
598: p_encrypted_plug_id, l_session_id, l_plug_id);
599:
600: RETURN get_kpi_url(l_session_id, l_plug_id);
601:

Line 634: l_resp_id NUMBER := bsc_portlet_util.VALUE_NOT_SET;

630:
631: l_ext_params VARCHAR2(2000):= NULL;
632:
633: l_tab_url VARCHAR2(2000):= NULL;
634: l_resp_id NUMBER := bsc_portlet_util.VALUE_NOT_SET;
635: l_tab_id NUMBER := bsc_portlet_util.VALUE_NOT_SET;
636: l_kpi_id NUMBER := bsc_portlet_util.VALUE_NOT_SET;
637:
638:

Line 635: l_tab_id NUMBER := bsc_portlet_util.VALUE_NOT_SET;

631: l_ext_params VARCHAR2(2000):= NULL;
632:
633: l_tab_url VARCHAR2(2000):= NULL;
634: l_resp_id NUMBER := bsc_portlet_util.VALUE_NOT_SET;
635: l_tab_id NUMBER := bsc_portlet_util.VALUE_NOT_SET;
636: l_kpi_id NUMBER := bsc_portlet_util.VALUE_NOT_SET;
637:
638:
639: BEGIN

Line 636: l_kpi_id NUMBER := bsc_portlet_util.VALUE_NOT_SET;

632:
633: l_tab_url VARCHAR2(2000):= NULL;
634: l_resp_id NUMBER := bsc_portlet_util.VALUE_NOT_SET;
635: l_tab_id NUMBER := bsc_portlet_util.VALUE_NOT_SET;
636: l_kpi_id NUMBER := bsc_portlet_util.VALUE_NOT_SET;
637:
638:
639: BEGIN
640:

Line 644: l_ext_params := get_pluginfo_params(l_resp_id, p_session_id, p_plug_id) ||'&' || bsc_portlet_util.PR_TABCODE || '=' || l_tab_id;

640:
641: bsc_portlet_graph.get_customized_data_private(p_session_id,
642: p_plug_id, l_resp_id, l_tab_id, l_kpi_id);
643:
644: l_ext_params := get_pluginfo_params(l_resp_id, p_session_id, p_plug_id) ||'&' || bsc_portlet_util.PR_TABCODE || '=' || l_tab_id;
645:
646: l_tab_url := bsc_portlet_util.get_bsc_url(p_session_id, p_plug_id, 'BscInit.jsp', l_ext_params, FALSE);
647:
648:

Line 646: l_tab_url := bsc_portlet_util.get_bsc_url(p_session_id, p_plug_id, 'BscInit.jsp', l_ext_params, FALSE);

642: p_plug_id, l_resp_id, l_tab_id, l_kpi_id);
643:
644: l_ext_params := get_pluginfo_params(l_resp_id, p_session_id, p_plug_id) ||'&' || bsc_portlet_util.PR_TABCODE || '=' || l_tab_id;
645:
646: l_tab_url := bsc_portlet_util.get_bsc_url(p_session_id, p_plug_id, 'BscInit.jsp', l_ext_params, FALSE);
647:
648:
649:
650: RETURN l_tab_url;

Line 688: l_resp_id NUMBER := bsc_portlet_util.VALUE_NOT_SET;

684:
685: l_ext_params VARCHAR2(2000):= NULL;
686:
687: l_kpi_url VARCHAR2(2000):= NULL;
688: l_resp_id NUMBER := bsc_portlet_util.VALUE_NOT_SET;
689: l_tab_id NUMBER := bsc_portlet_util.VALUE_NOT_SET;
690: l_kpi_id NUMBER := bsc_portlet_util.VALUE_NOT_SET;
691:
692:

Line 689: l_tab_id NUMBER := bsc_portlet_util.VALUE_NOT_SET;

685: l_ext_params VARCHAR2(2000):= NULL;
686:
687: l_kpi_url VARCHAR2(2000):= NULL;
688: l_resp_id NUMBER := bsc_portlet_util.VALUE_NOT_SET;
689: l_tab_id NUMBER := bsc_portlet_util.VALUE_NOT_SET;
690: l_kpi_id NUMBER := bsc_portlet_util.VALUE_NOT_SET;
691:
692:
693:

Line 690: l_kpi_id NUMBER := bsc_portlet_util.VALUE_NOT_SET;

686:
687: l_kpi_url VARCHAR2(2000):= NULL;
688: l_resp_id NUMBER := bsc_portlet_util.VALUE_NOT_SET;
689: l_tab_id NUMBER := bsc_portlet_util.VALUE_NOT_SET;
690: l_kpi_id NUMBER := bsc_portlet_util.VALUE_NOT_SET;
691:
692:
693:
694: BEGIN

Line 699: l_ext_params := get_pluginfo_params(l_resp_id, p_session_id, p_plug_id) ||'&' || bsc_portlet_util.PR_KCODE || '=' || l_kpi_id;

695:
696: bsc_portlet_graph.get_customized_data_private(p_session_id,
697: p_plug_id, l_resp_id, l_tab_id, l_kpi_id);
698:
699: l_ext_params := get_pluginfo_params(l_resp_id, p_session_id, p_plug_id) ||'&' || bsc_portlet_util.PR_KCODE || '=' || l_kpi_id;
700:
701: l_kpi_url := bsc_portlet_util.get_bsc_url(p_session_id, p_plug_id, 'BscInit.jsp', l_ext_params, FALSE);
702:
703:

Line 701: l_kpi_url := bsc_portlet_util.get_bsc_url(p_session_id, p_plug_id, 'BscInit.jsp', l_ext_params, FALSE);

697: p_plug_id, l_resp_id, l_tab_id, l_kpi_id);
698:
699: l_ext_params := get_pluginfo_params(l_resp_id, p_session_id, p_plug_id) ||'&' || bsc_portlet_util.PR_KCODE || '=' || l_kpi_id;
700:
701: l_kpi_url := bsc_portlet_util.get_bsc_url(p_session_id, p_plug_id, 'BscInit.jsp', l_ext_params, FALSE);
702:
703:
704:
705: RETURN l_kpi_url;

Line 741: l_ext_params := bsc_portlet_util.PR_RESPID || '=' || p_resp_id;

737:
738:
739: BEGIN
740:
741: l_ext_params := bsc_portlet_util.PR_RESPID || '=' || p_resp_id;
742: /*
743: l_ext_params := bsc_portlet_util.PR_RESPID || '=' || p_resp_id || '&' ||
744: 'pSessionId=' || p_session_id || '&' ||
745: 'pPlugId=' || p_plug_id;

Line 743: l_ext_params := bsc_portlet_util.PR_RESPID || '=' || p_resp_id || '&' ||

739: BEGIN
740:
741: l_ext_params := bsc_portlet_util.PR_RESPID || '=' || p_resp_id;
742: /*
743: l_ext_params := bsc_portlet_util.PR_RESPID || '=' || p_resp_id || '&' ||
744: 'pSessionId=' || p_session_id || '&' ||
745: 'pPlugId=' || p_plug_id;
746: */
747:

Line 784: l_ext_params := bsc_portlet_util.PR_RESPID || '=' || p_resp_id || '&' ||

780: l_ext_params VARCHAR2(100) := NULL;
781:
782: BEGIN
783:
784: l_ext_params := bsc_portlet_util.PR_RESPID || '=' || p_resp_id || '&' ||
785: bsc_portlet_util.PR_KCODE || '=' || p_kpi_id || '&' ||
786: 'pPlugId=' || icx_call.encrypt3(p_plug_id);
787:
788: -----------------------------------------------------

Line 785: bsc_portlet_util.PR_KCODE || '=' || p_kpi_id || '&' ||

781:
782: BEGIN
783:
784: l_ext_params := bsc_portlet_util.PR_RESPID || '=' || p_resp_id || '&' ||
785: bsc_portlet_util.PR_KCODE || '=' || p_kpi_id || '&' ||
786: 'pPlugId=' || icx_call.encrypt3(p_plug_id);
787:
788: -----------------------------------------------------
789: -- Now, we form the url by passing jsp name and extra params.

Line 792: l_url := bsc_portlet_util.get_bsc_url(

788: -----------------------------------------------------
789: -- Now, we form the url by passing jsp name and extra params.
790: -- NOTE: do not use preferences's responsibility id.
791: -----------------------------------------------------
792: l_url := bsc_portlet_util.get_bsc_url(
793: p_session_id,
794: p_plug_id,
795: 'BscPorKpi.jsp',
796: l_ext_params,

Line 851: bsc_portlet_util.PR_KCODE || '=' || p_kpi_id || '&' ||

847: -- it has been customized, resonsibility id is available
848: IF ( NOT p_is_never_customized ) THEN
849:
850: l_ext_params := l_ext_params || '&' ||
851: bsc_portlet_util.PR_KCODE || '=' || p_kpi_id || '&' ||
852: bsc_portlet_util.PR_RESPID || '=' || p_resp_id;
853:
854:
855: END IF; -- (p_is_respid_used )

Line 852: bsc_portlet_util.PR_RESPID || '=' || p_resp_id;

848: IF ( NOT p_is_never_customized ) THEN
849:
850: l_ext_params := l_ext_params || '&' ||
851: bsc_portlet_util.PR_KCODE || '=' || p_kpi_id || '&' ||
852: bsc_portlet_util.PR_RESPID || '=' || p_resp_id;
853:
854:
855: END IF; -- (p_is_respid_used )
856:

Line 857: l_url := bsc_portlet_util.get_bsc_url(

853:
854:
855: END IF; -- (p_is_respid_used )
856:
857: l_url := bsc_portlet_util.get_bsc_url(
858: p_session_id,
859: p_plug_id,
860: 'BscGraphPortletCust.jsp',
861: l_ext_params,

Line 925: p_o_resp_id := bsc_portlet_util.VALUE_NOT_SET;

921: IF c_kg_p%FOUND THEN
922: RETURN;
923:
924: ELSE
925: p_o_resp_id := bsc_portlet_util.VALUE_NOT_SET;
926: p_o_tab_id := bsc_portlet_util.VALUE_NOT_SET;
927: p_o_kpi_id := bsc_portlet_util.VALUE_NOT_SET;
928:
929: END IF; --c_kg_p%FOUND

Line 926: p_o_tab_id := bsc_portlet_util.VALUE_NOT_SET;

922: RETURN;
923:
924: ELSE
925: p_o_resp_id := bsc_portlet_util.VALUE_NOT_SET;
926: p_o_tab_id := bsc_portlet_util.VALUE_NOT_SET;
927: p_o_kpi_id := bsc_portlet_util.VALUE_NOT_SET;
928:
929: END IF; --c_kg_p%FOUND
930:

Line 927: p_o_kpi_id := bsc_portlet_util.VALUE_NOT_SET;

923:
924: ELSE
925: p_o_resp_id := bsc_portlet_util.VALUE_NOT_SET;
926: p_o_tab_id := bsc_portlet_util.VALUE_NOT_SET;
927: p_o_kpi_id := bsc_portlet_util.VALUE_NOT_SET;
928:
929: END IF; --c_kg_p%FOUND
930:
931:

Line 967: l_errmesg VARCHAR2(2000) := bsc_portlet_util.MSGTXT_SUCCESS;

963:
964: insert_err EXCEPTION;
965: update_err EXCEPTION;
966:
967: l_errmesg VARCHAR2(2000) := bsc_portlet_util.MSGTXT_SUCCESS;
968: l_count NUMBER := 0;
969:
970: BEGIN
971: SELECT count(*)

Line 1015: bsc_portlet_util.update_portlet_name(p_user_id, p_plug_id, p_porlet_name);

1011:
1012: END IF; -- (l_count > 0)
1013:
1014: -- update display name !!!!
1015: bsc_portlet_util.update_portlet_name(p_user_id, p_plug_id, p_porlet_name);
1016:
1017: -- everything works ok so we commit
1018: COMMIT;
1019: p_o_ret_status := bsc_portlet_util.CODE_RET_SUCCESS;

Line 1019: p_o_ret_status := bsc_portlet_util.CODE_RET_SUCCESS;

1015: bsc_portlet_util.update_portlet_name(p_user_id, p_plug_id, p_porlet_name);
1016:
1017: -- everything works ok so we commit
1018: COMMIT;
1019: p_o_ret_status := bsc_portlet_util.CODE_RET_SUCCESS;
1020: RETURN bsc_portlet_util.MSGTXT_SUCCESS;
1021:
1022: EXCEPTION
1023:

Line 1020: RETURN bsc_portlet_util.MSGTXT_SUCCESS;

1016:
1017: -- everything works ok so we commit
1018: COMMIT;
1019: p_o_ret_status := bsc_portlet_util.CODE_RET_SUCCESS;
1020: RETURN bsc_portlet_util.MSGTXT_SUCCESS;
1021:
1022: EXCEPTION
1023:
1024: WHEN insert_err THEN

Line 1026: p_o_ret_status := bsc_portlet_util.CODE_RET_ERROR;

1022: EXCEPTION
1023:
1024: WHEN insert_err THEN
1025: ROLLBACK;
1026: p_o_ret_status := bsc_portlet_util.CODE_RET_ERROR;
1027: l_errmesg := 'Error inserting to BSC_USER_KPIGRAPH_PLUGS';
1028: RETURN l_errmesg;
1029:
1030:

Line 1033: p_o_ret_status := bsc_portlet_util.CODE_RET_ERROR;

1029:
1030:
1031: WHEN update_err THEN
1032: ROLLBACK;
1033: p_o_ret_status := bsc_portlet_util.CODE_RET_ERROR;
1034: l_errmesg := 'Error updating to BSC_USER_KPIGRAPH_PLUGS';
1035: RETURN l_errmesg;
1036:
1037: WHEN OTHERS THEN

Line 1039: p_o_ret_status := bsc_portlet_util.CODE_RET_ERROR;

1035: RETURN l_errmesg;
1036:
1037: WHEN OTHERS THEN
1038: ROLLBACK;
1039: p_o_ret_status := bsc_portlet_util.CODE_RET_ERROR;
1040: l_errmesg := 'Error in bsc_portlet_graph.set_customized_data_private. SQLERRM = ' || SQLERRM;
1041: RETURN l_errmesg;
1042:
1043:

Line 1108: bsc_portlet_util.decrypt_plug_info(p_cookie_value,

1104:
1105: BEGIN
1106:
1107:
1108: bsc_portlet_util.decrypt_plug_info(p_cookie_value,
1109: p_encrypted_plug_id, l_session_id, l_plug_id);
1110:
1111: p_has_access := 0;
1112: IF icx_sec.validatePlugSession(l_plug_id, l_session_id) THEN

Line 1124: p_tab_id := bsc_portlet_util.VALUE_NOT_SET;

1120: -- get the tab id this indicator belongs
1121: OPEN c_tab;
1122: FETCH c_tab INTO p_tab_id;
1123: IF c_tab%NOTFOUND THEN
1124: p_tab_id := bsc_portlet_util.VALUE_NOT_SET;
1125: END IF; --c_tab%NOTFOUND
1126: CLOSE c_tab;
1127:
1128:

Line 1144: RETURN bsc_portlet_util.CODE_RET_SUCCESS;

1140: ELSE
1141: p_has_access := 0;
1142: END IF;
1143: CLOSE c_kg_p;
1144: RETURN bsc_portlet_util.CODE_RET_SUCCESS;
1145:
1146: ELSE -- not found, no such plug i
1147: p_has_access := 0;
1148: CLOSE c_kg_p;

Line 1149: RETURN bsc_portlet_util.CODE_RET_NOROW;

1145:
1146: ELSE -- not found, no such plug i
1147: p_has_access := 0;
1148: CLOSE c_kg_p;
1149: RETURN bsc_portlet_util.CODE_RET_NOROW;
1150:
1151: END IF; -- c_kg_p%FOUND
1152:
1153: ELSE -- session expires

Line 1154: RETURN bsc_portlet_util.CODE_RET_SESSION_EXP;

1150:
1151: END IF; -- c_kg_p%FOUND
1152:
1153: ELSE -- session expires
1154: RETURN bsc_portlet_util.CODE_RET_SESSION_EXP;
1155: END IF; -- icx_sec.validatePlugSession(l_plug_id, l_session_id)
1156:
1157: END get_customization;
1158:

Line 1197: l_errmsg VARCHAR2(2000) := bsc_portlet_util.MSGTXT_SUCCESS;

1193: l_session_id NUMBER := -1;
1194: l_plug_id NUMBER := -1;
1195: l_user_id NUMBER := -1;
1196:
1197: l_errmsg VARCHAR2(2000) := bsc_portlet_util.MSGTXT_SUCCESS;
1198:
1199: BEGIN
1200:
1201: bsc_portlet_util.decrypt_plug_info(p_cookie_value,

Line 1201: bsc_portlet_util.decrypt_plug_info(p_cookie_value,

1197: l_errmsg VARCHAR2(2000) := bsc_portlet_util.MSGTXT_SUCCESS;
1198:
1199: BEGIN
1200:
1201: bsc_portlet_util.decrypt_plug_info(p_cookie_value,
1202: p_encrypted_plug_id, l_session_id, l_plug_id);
1203:
1204:
1205: IF icx_sec.validatePlugSession(l_plug_id, l_session_id) THEN

Line 1228: p_o_ret_status := bsc_portlet_util.CODE_RET_SESSION_EXP;

1224: EXCEPTION
1225:
1226: WHEN session_expire_err THEN
1227:
1228: p_o_ret_status := bsc_portlet_util.CODE_RET_SESSION_EXP;
1229: l_errmsg := bsc_portlet_util.MSGTXT_SESSION_EXP;
1230: RETURN l_errmsg;
1231:
1232:

Line 1229: l_errmsg := bsc_portlet_util.MSGTXT_SESSION_EXP;

1225:
1226: WHEN session_expire_err THEN
1227:
1228: p_o_ret_status := bsc_portlet_util.CODE_RET_SESSION_EXP;
1229: l_errmsg := bsc_portlet_util.MSGTXT_SESSION_EXP;
1230: RETURN l_errmsg;
1231:
1232:
1233: WHEN OTHERS THEN

Line 1279: l_errmesg VARCHAR2(2000) := bsc_portlet_util.MSGTXT_SUCCESS;

1275: insert_err EXCEPTION;
1276: update_err EXCEPTION;
1277:
1278: l_db_gkey VARCHAR2(100); -- stores the key retrieved from db
1279: l_errmesg VARCHAR2(2000) := bsc_portlet_util.MSGTXT_SUCCESS;
1280: l_w NUMBER := 600;
1281: l_h NUMBER := 400;
1282: -- l_sq_img_id NUMBER;
1283:

Line 1306: p_o_ret_status := bsc_portlet_util.CODE_RET_SUCCESS;

1302: ---------------------------------------------------
1303: -- row exists in bsc_sys_images and bsc_kpi_graphs
1304: ---------------------------------------------------
1305: CLOSE c_kg;
1306: p_o_ret_status := bsc_portlet_util.CODE_RET_SUCCESS;
1307: l_errmesg := bsc_portlet_util.MSGTXT_SUCCESS;
1308: RETURN l_errmesg;
1309:
1310: ELSE

Line 1307: l_errmesg := bsc_portlet_util.MSGTXT_SUCCESS;

1303: -- row exists in bsc_sys_images and bsc_kpi_graphs
1304: ---------------------------------------------------
1305: CLOSE c_kg;
1306: p_o_ret_status := bsc_portlet_util.CODE_RET_SUCCESS;
1307: l_errmesg := bsc_portlet_util.MSGTXT_SUCCESS;
1308: RETURN l_errmesg;
1309:
1310: ELSE
1311: ---------------------------------------------------

Line 1315: p_o_ret_status := bsc_portlet_util.CODE_RET_NOROW;

1311: ---------------------------------------------------
1312: -- row does not exist
1313: ---------------------------------------------------
1314: CLOSE c_kg;
1315: p_o_ret_status := bsc_portlet_util.CODE_RET_NOROW;
1316: l_errmesg := bsc_portlet_util.MSGTXT_NOROW;
1317: RETURN l_errmesg;
1318:
1319: END IF; -- c_kg%FOUND

Line 1316: l_errmesg := bsc_portlet_util.MSGTXT_NOROW;

1312: -- row does not exist
1313: ---------------------------------------------------
1314: CLOSE c_kg;
1315: p_o_ret_status := bsc_portlet_util.CODE_RET_NOROW;
1316: l_errmesg := bsc_portlet_util.MSGTXT_NOROW;
1317: RETURN l_errmesg;
1318:
1319: END IF; -- c_kg%FOUND
1320:

Line 1330: p_o_ret_status := bsc_portlet_util.CODE_RET_ERROR;

1326: IF c_kg%ISOPEN THEN
1327: CLOSE c_kg;
1328: END IF;
1329:
1330: p_o_ret_status := bsc_portlet_util.CODE_RET_ERROR;
1331: RETURN l_errmesg;
1332:
1333:
1334:

Line 1367: l_errmesg VARCHAR2(2000) := bsc_portlet_util.MSGTXT_SUCCESS;

1363: insert_err EXCEPTION;
1364: update_err EXCEPTION;
1365:
1366: l_gkey VARCHAR2(100);
1367: l_errmesg VARCHAR2(2000) := bsc_portlet_util.MSGTXT_SUCCESS;
1368: l_w NUMBER := 550;
1369: l_h NUMBER := 250;
1370:
1371: CURSOR c_kg IS

Line 1396: p_o_ret_status := bsc_portlet_util.CODE_RET_SUCCESS;

1392: -- graph key is the same, no need to update
1393: -- make sure all the return vars are set.
1394: ------------------------------------------------
1395: CLOSE c_kg;
1396: p_o_ret_status := bsc_portlet_util.CODE_RET_SUCCESS;
1397: RETURN bsc_portlet_util.MSGTXT_SUCCESS;
1398: END IF;
1399:
1400:

Line 1397: RETURN bsc_portlet_util.MSGTXT_SUCCESS;

1393: -- make sure all the return vars are set.
1394: ------------------------------------------------
1395: CLOSE c_kg;
1396: p_o_ret_status := bsc_portlet_util.CODE_RET_SUCCESS;
1397: RETURN bsc_portlet_util.MSGTXT_SUCCESS;
1398: END IF;
1399:
1400:
1401: ------------------------------------------------

Line 1491: p_o_ret_status := bsc_portlet_util.CODE_RET_SUCCESS;

1487: -- success if it goes here.
1488: ----------------------------
1489: COMMIT;
1490: CLOSE c_kg;
1491: p_o_ret_status := bsc_portlet_util.CODE_RET_SUCCESS;
1492: RETURN bsc_portlet_util.MSGTXT_SUCCESS;
1493:
1494:
1495: EXCEPTION

Line 1492: RETURN bsc_portlet_util.MSGTXT_SUCCESS;

1488: ----------------------------
1489: COMMIT;
1490: CLOSE c_kg;
1491: p_o_ret_status := bsc_portlet_util.CODE_RET_SUCCESS;
1492: RETURN bsc_portlet_util.MSGTXT_SUCCESS;
1493:
1494:
1495: EXCEPTION
1496:

Line 1500: p_o_ret_status := bsc_portlet_util.CODE_RET_ERROR;

1496:
1497: WHEN insert_err THEN
1498: ROLLBACK;
1499: CLOSE c_kg;
1500: p_o_ret_status := bsc_portlet_util.CODE_RET_ERROR;
1501: RETURN l_errmesg;
1502:
1503:
1504: WHEN update_err THEN

Line 1507: p_o_ret_status := bsc_portlet_util.CODE_RET_ERROR;

1503:
1504: WHEN update_err THEN
1505: ROLLBACK;
1506: CLOSE c_kg;
1507: p_o_ret_status := bsc_portlet_util.CODE_RET_ERROR;
1508: RETURN l_errmesg;
1509:
1510: WHEN OTHERS THEN
1511: ROLLBACK;

Line 1513: p_o_ret_status := bsc_portlet_util.CODE_RET_ERROR;

1509:
1510: WHEN OTHERS THEN
1511: ROLLBACK;
1512: CLOSE c_kg;
1513: p_o_ret_status := bsc_portlet_util.CODE_RET_ERROR;
1514: RETURN l_errmesg;
1515:
1516:
1517: