APPS.BSC_PORTLET_KPILISTCUST dependencies on BSC_PORTLET_UTIL

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

41:
42:
43: BEGIN
44:
45: l_ext_params := bsc_portlet_util.PR_RESPID || '=' || p_resp_id;
46: RETURN l_ext_params;
47:
48:
49:

Line 76: l_resp_id NUMBER := bsc_portlet_util.VALUE_NOT_SET;

72: FUNCTION get_resp_id(
73: p_session_id IN pls_integer,
74: p_plug_id IN pls_integer) RETURN NUMBER IS
75:
76: l_resp_id NUMBER := bsc_portlet_util.VALUE_NOT_SET;
77:
78: CURSOR c_kg_p IS
79: SELECT p.RESPONSIBILITY_ID
80: FROM icx_portlet_customizations p

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

524:
525: insert_err EXCEPTION;
526: update_err EXCEPTION;
527:
528: l_errmesg VARCHAR2(2000) := bsc_portlet_util.MSGTXT_SUCCESS;
529: l_count NUMBER := 0;
530:
531: BEGIN
532: SELECT count(*)

Line 563: p_o_ret_status := bsc_portlet_util.CODE_RET_SUCCESS;

559:
560:
561: -- everything works ok so we commit
562: COMMIT;
563: p_o_ret_status := bsc_portlet_util.CODE_RET_SUCCESS;
564: RETURN bsc_portlet_util.MSGTXT_SUCCESS;
565:
566: EXCEPTION
567:

Line 564: RETURN bsc_portlet_util.MSGTXT_SUCCESS;

560:
561: -- everything works ok so we commit
562: COMMIT;
563: p_o_ret_status := bsc_portlet_util.CODE_RET_SUCCESS;
564: RETURN bsc_portlet_util.MSGTXT_SUCCESS;
565:
566: EXCEPTION
567:
568: WHEN insert_err THEN

Line 570: p_o_ret_status := bsc_portlet_util.CODE_RET_ERROR;

566: EXCEPTION
567:
568: WHEN insert_err THEN
569: ROLLBACK;
570: p_o_ret_status := bsc_portlet_util.CODE_RET_ERROR;
571: l_errmesg := 'Error inserting to BSC_USER_KPILIST_PLUGS';
572: RETURN l_errmesg;
573:
574:

Line 577: p_o_ret_status := bsc_portlet_util.CODE_RET_ERROR;

573:
574:
575: WHEN update_err THEN
576: ROLLBACK;
577: p_o_ret_status := bsc_portlet_util.CODE_RET_ERROR;
578: l_errmesg := 'Error updating to BSC_USER_KPILIST_PLUGS';
579: RETURN l_errmesg;
580:
581: WHEN OTHERS THEN

Line 583: p_o_ret_status := bsc_portlet_util.CODE_RET_ERROR;

579: RETURN l_errmesg;
580:
581: WHEN OTHERS THEN
582: ROLLBACK;
583: p_o_ret_status := bsc_portlet_util.CODE_RET_ERROR;
584: l_errmesg := 'Error in bsc_portlet_graph.set_customized_data_private. SQLERRM = ' || SQLERRM;
585: RETURN l_errmesg;
586:
587:

Line 643: bsc_portlet_util.decrypt_plug_info(p_cookie_value,

639:
640: BEGIN
641:
642:
643: bsc_portlet_util.decrypt_plug_info(p_cookie_value,
644: p_encrypted_plug_id, l_session_id, p_plug_id);
645:
646:
647: IF icx_sec.validateSessionPrivate(l_session_id) THEN

Line 676: RETURN bsc_portlet_util.CODE_RET_SUCCESS;

672: p_has_selected_kpi := 0;
673: ELSE
674: p_has_selected_kpi := 1;
675: END IF; -- (l_num_sel_kpis = 0 )
676: RETURN bsc_portlet_util.CODE_RET_SUCCESS;
677:
678: ELSE -- not found, no such plug i
679: CLOSE c_kg_p;
680: RETURN bsc_portlet_util.CODE_RET_NOROW;

Line 680: RETURN bsc_portlet_util.CODE_RET_NOROW;

676: RETURN bsc_portlet_util.CODE_RET_SUCCESS;
677:
678: ELSE -- not found, no such plug i
679: CLOSE c_kg_p;
680: RETURN bsc_portlet_util.CODE_RET_NOROW;
681:
682: END IF; -- c_kg_p%FOUND
683:
684: ELSE -- session expires

Line 685: RETURN bsc_portlet_util.CODE_RET_SESSION_EXP;

681:
682: END IF; -- c_kg_p%FOUND
683:
684: ELSE -- session expires
685: RETURN bsc_portlet_util.CODE_RET_SESSION_EXP;
686: END IF; -- icx_sec.validateSessionPrivate(l_session_id)
687: EXCEPTION
688: WHEN OTHERS THEN
689: --close the open cursors if any.