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_CUSTOM_VIEW_UI_WRAPPER dependencies on BSC_CUSTOM_VIEW_UI_WRAPPER

Line 1: PACKAGE BODY BSC_CUSTOM_VIEW_UI_WRAPPER AS

1: PACKAGE BODY BSC_CUSTOM_VIEW_UI_WRAPPER AS
2: /* $Header: BSCCVDPB.pls 120.13 2007/03/15 10:42:34 ashankar ship $ */
3:
4: PROCEDURE add_or_update_kpi_trend(
5: p_tab_id IN NUMBER

Line 235: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(

231: SAVEPOINT RollBackPt;
232: fnd_msg_pub.initialize;
233: x_return_status := FND_API.G_RET_STS_SUCCESS;
234:
235: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
236: p_tab_id => p_tab_id
237: ,p_tab_view_id => p_tab_view_id
238: ,p_object_id => p_object_id
239: ,p_object_type => c_type_kpi_actual

Line 289: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(

285: SAVEPOINT RollBackPt;
286: fnd_msg_pub.initialize;
287: x_return_status := FND_API.G_RET_STS_SUCCESS;
288:
289: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
290: p_tab_id => p_tab_id
291: ,p_tab_view_id => p_tab_view_id
292: ,p_object_id => p_object_id
293: ,p_object_type => c_type_kpi_change

Line 343: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(

339: SAVEPOINT RollBackPt;
340: fnd_msg_pub.initialize;
341: x_return_status := FND_API.G_RET_STS_SUCCESS;
342:
343: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
344: p_tab_id => p_tab_id
345: ,p_tab_view_id => p_tab_view_id
346: ,p_object_id => p_object_id
347: ,p_object_type => c_type_kpi

Line 444: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_kpi(

440: ,x_msg_data => x_msg_data
441: );
442:
443: -- Add specified kpi to BSC_TAB_VIEW_KPI_TL
444: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_kpi(
445: p_tab_id => p_tab_id
446: ,p_tab_view_id => p_tab_view_id
447: ,p_kpi_id => p_kpi_id
448: ,p_text_flag => p_text_flag

Line 560: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(

556: SAVEPOINT RollBackPt;
557: fnd_msg_pub.initialize;
558: x_return_status := FND_API.G_RET_STS_SUCCESS;
559:
560: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
561: p_tab_id => p_tab_id
562: ,p_tab_view_id => p_tab_view_id
563: ,p_object_id => p_object_id
564: ,p_object_type => c_type_label

Line 608: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(

604: SAVEPOINT RollBackPt;
605: fnd_msg_pub.initialize;
606: x_return_status := FND_API.G_RET_STS_SUCCESS;
607:
608: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
609: p_tab_id => p_tab_id
610: ,p_tab_view_id => p_tab_view_id
611: ,p_object_id => p_object_id
612: ,p_object_type => c_type_hotspot

Line 661: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(

657: SAVEPOINT RollBackPt;
658: fnd_msg_pub.initialize;
659: x_return_status := FND_API.G_RET_STS_SUCCESS;
660:
661: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
662: p_tab_id => p_tab_id
663: ,p_tab_view_id => p_tab_view_id
664: ,p_object_id => p_object_id
665: ,p_object_type => c_type_link

Line 711: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(

707: SAVEPOINT RollBackPt;
708: fnd_msg_pub.initialize;
709: x_return_status := FND_API.G_RET_STS_SUCCESS;
710:
711: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
712: p_tab_id => p_tab_id
713: ,p_tab_view_id => p_tab_view_id
714: ,p_object_id => p_object_id
715: ,p_object_type => c_type_launch_pad

Line 783: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(

779: fnd_msg_pub.initialize;
780: x_return_status := FND_API.G_RET_STS_SUCCESS;
781:
782: --add name/hotspot
783: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
784: p_tab_id => p_tab_id
785: ,p_tab_view_id => p_tab_view_id
786: ,p_object_id => p_text_object_id
787: ,p_object_type => c_type_measure

Line 806: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(

802: ,x_msg_data => x_msg_data
803: );
804:
805: --add actual
806: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
807: p_tab_id => p_tab_id
808: ,p_tab_view_id => p_tab_view_id
809: ,p_object_id => p_actual_object_id
810: ,p_object_type => c_type_measure_actual

Line 829: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(

825: ,x_msg_data => x_msg_data
826: );
827:
828: --add change
829: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
830: p_tab_id => p_tab_id
831: ,p_tab_view_id => p_tab_view_id
832: ,p_object_id => p_change_object_id
833: ,p_object_type => c_type_measure_change

Line 852: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(

848: ,x_msg_data => x_msg_data
849: );
850:
851: --add slider
852: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
853: p_tab_id => p_tab_id
854: ,p_tab_view_id => p_tab_view_id
855: ,p_object_id => p_slider_object_id
856: ,p_object_type => c_type_measure_slider

Line 1381: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_function

1377: and when it is set to FND_API.G_TRUE then we will create the form fucntion
1378: /*****************************************************************/
1379: IF (p_create_form_func = FND_API.G_TRUE) THEN
1380: -- Enh 3934298, for each new custom view will create/update a form function to use in DBI
1381: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_function
1382: (p_tab_id => p_tab_id,
1383: p_tab_view_id => p_tab_view_id,
1384: p_name => p_name,
1385: p_internal_name => p_internal_name,

Line 1394: --DBMS_OUTPUT.PUT_LINE('BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view Failed: at BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_function');

1390: x_msg_data => x_msg_data
1391: );
1392:
1393: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1394: --DBMS_OUTPUT.PUT_LINE('BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view Failed: at BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_function');
1395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1396: END IF;
1397:
1398: -- Maps Functional area short name.

Line 1690: x_msg_data := 'BSC_CUSTOM_VIEW_UI_WRAPPER.create_function' || SQLERRM;

1686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1687: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1688: ,p_data => x_msg_data);
1689: if (x_msg_data is null) then
1690: x_msg_data := 'BSC_CUSTOM_VIEW_UI_WRAPPER.create_function' || SQLERRM;
1691: end if;
1692:
1693: end add_or_update_function;
1694:

Line 1753: x_msg_data := 'BSC_CUSTOM_VIEW_UI_WRAPPER.delete_function: no Row Found: ' || SQLERRM;

1749: x_return_status := FND_API.G_RET_STS_ERROR;
1750: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1751: ,p_data => x_msg_data);
1752: if (x_msg_data is null) then
1753: x_msg_data := 'BSC_CUSTOM_VIEW_UI_WRAPPER.delete_function: no Row Found: ' || SQLERRM;
1754: end if;
1755:
1756: WHEN FND_API.G_EXC_ERROR THEN
1757: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1765: x_msg_data := 'BSC_CUSTOM_VIEW_UI_WRAPPER.delete_function' || SQLERRM;

1761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1762: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1763: ,p_data => x_msg_data);
1764: if (x_msg_data is null) then
1765: x_msg_data := 'BSC_CUSTOM_VIEW_UI_WRAPPER.delete_function' || SQLERRM;
1766: end if;
1767:
1768: end delete_function;
1769:

Line 1907: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_UI_WRAPPER.Get_Or_CreateNew_Scorecard ';

1903: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1904: WHEN NO_DATA_FOUND THEN
1905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1906: IF (x_msg_data IS NOT NULL) THEN
1907: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_UI_WRAPPER.Get_Or_CreateNew_Scorecard ';
1908: ELSE
1909: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_UI_WRAPPER.Get_Or_CreateNew_Scorecard ';
1910: END IF;
1911: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1909: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_UI_WRAPPER.Get_Or_CreateNew_Scorecard ';

1905: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1906: IF (x_msg_data IS NOT NULL) THEN
1907: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_UI_WRAPPER.Get_Or_CreateNew_Scorecard ';
1908: ELSE
1909: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_UI_WRAPPER.Get_Or_CreateNew_Scorecard ';
1910: END IF;
1911: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1912: WHEN OTHERS THEN
1913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1915: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_UI_WRAPPER.Get_Or_CreateNew_Scorecard ';

1911: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1912: WHEN OTHERS THEN
1913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1914: IF (x_msg_data IS NOT NULL) THEN
1915: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_UI_WRAPPER.Get_Or_CreateNew_Scorecard ';
1916: ELSE
1917: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_UI_WRAPPER.Get_Or_CreateNew_Scorecard ';
1918: END IF;
1919: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1917: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_UI_WRAPPER.Get_Or_CreateNew_Scorecard ';

1913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1914: IF (x_msg_data IS NOT NULL) THEN
1915: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_UI_WRAPPER.Get_Or_CreateNew_Scorecard ';
1916: ELSE
1917: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_UI_WRAPPER.Get_Or_CreateNew_Scorecard ';
1918: END IF;
1919: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1920: END Get_Or_CreateNew_Scorecard;
1921:

Line 2042: RETURN BSC_CUSTOM_VIEW_UI_WRAPPER.C_FUNCTIONAL_AREA;

2038: /**************************************************/
2039: FUNCTION Get_Functional_Area_Code
2040: RETURN VARCHAR2 IS
2041: BEGIN
2042: RETURN BSC_CUSTOM_VIEW_UI_WRAPPER.C_FUNCTIONAL_AREA;
2043: END Get_Functional_Area_Code;
2044:
2045: /**************************************************
2046: NAME : Get_Form_Function_Code

Line 2053: RETURN BSC_CUSTOM_VIEW_UI_WRAPPER.C_FORM_FUNCTION;

2049: /**************************************************/
2050: FUNCTION Get_Form_Function_Code
2051: RETURN VARCHAR2 IS
2052: BEGIN
2053: RETURN BSC_CUSTOM_VIEW_UI_WRAPPER.C_FORM_FUNCTION;
2054: END Get_Form_Function_Code;
2055:
2056: /**************************************************
2057: NAME : Get_Tab_Fun_Fa_Prop

Line 2092: IF(BSC_CUSTOM_VIEW_UI_WRAPPER.C_FUNCTIONAL_AREA=p_type) THEN

2088: ff.parameters LIKE '%pTabId_'||p_tab_id|| '&pViewId_'||p_tab_view_id||'%'
2089: AND ext.functional_area_id = fa.functional_area_id (+)
2090: AND ff.function_name = ext.object_name (+);
2091:
2092: IF(BSC_CUSTOM_VIEW_UI_WRAPPER.C_FUNCTIONAL_AREA=p_type) THEN
2093: l_name:=l_short_name;
2094: ELSIF(BSC_CUSTOM_VIEW_UI_WRAPPER.C_FORM_FUNCTION=p_type)THEN
2095: l_name:=l_fun_name;
2096: END IF;

Line 2094: ELSIF(BSC_CUSTOM_VIEW_UI_WRAPPER.C_FORM_FUNCTION=p_type)THEN

2090: AND ff.function_name = ext.object_name (+);
2091:
2092: IF(BSC_CUSTOM_VIEW_UI_WRAPPER.C_FUNCTIONAL_AREA=p_type) THEN
2093: l_name:=l_short_name;
2094: ELSIF(BSC_CUSTOM_VIEW_UI_WRAPPER.C_FORM_FUNCTION=p_type)THEN
2095: l_name:=l_fun_name;
2096: END IF;
2097:
2098: RETURN l_name;

Line 2130: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(

2126: SAVEPOINT addorupdatekpitrend;
2127: fnd_msg_pub.initialize;
2128: x_return_status := FND_API.G_RET_STS_SUCCESS;
2129:
2130: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_tab_view_label(
2131: p_tab_id => p_tab_id
2132: ,p_tab_view_id => p_tab_view_id
2133: ,p_object_id => p_object_id
2134: ,p_object_type => c_type_kpi_trend

Line 2160: END BSC_CUSTOM_VIEW_UI_WRAPPER;

2156: x_msg_data := SQLERRM;
2157: END add_or_update_kpi_trend;
2158:
2159:
2160: END BSC_CUSTOM_VIEW_UI_WRAPPER;