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_DIM_FILTERS_PUB dependencies on BSC_DIM_FILTERS_PUB

Line 1: PACKAGE BODY BSC_DIM_FILTERS_PUB AS

1: PACKAGE BODY BSC_DIM_FILTERS_PUB AS
2: /* $Header: BSCPFDLB.pls 120.4 2007/02/23 10:41:26 psomesul ship $ */
3: /*
4: REM +=======================================================================+
5: REM | Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA |

Line 40: WHERE Source_Type = BSC_DIM_FILTERS_PUB.SOURCE_TYPE_TAB;

36: -- Cursor to get all tab with filter views
37: CURSOR c_Tabs_With_Filters IS
38: SELECT DISTINCT Source_Code -- Distinct need it
39: FROM BSC_SYS_FILTERS_VIEWS
40: WHERE Source_Type = BSC_DIM_FILTERS_PUB.SOURCE_TYPE_TAB;
41:
42: BEGIN
43: SAVEPOINT CheckFiltersNotApply;
44: --DBMS_OUTPUT.PUT_LINE('BEGIN Check_Filters_Not_Apply' );

Line 131: AND C.Source_Type = BSC_DIM_FILTERS_PUB.Source_Type_Tab

127: FROM BSC_TAB_INDICATORS A
128: , BSC_KPIS_B B
129: , BSC_SYS_FILTERS_VIEWS C
130: WHERE A.Indicator = B.Indicator
131: AND C.Source_Type = BSC_DIM_FILTERS_PUB.Source_Type_Tab
132: AND C.Source_Code = A.Tab_Id
133: AND ((B.Indicator = p_kpi_id) OR (B.Source_Indicator = p_kpi_id));
134:
135: BEGIN

Line 144: BSC_DIM_FILTERS_PUB.Check_Filters_Not_Apply

140:
141: --INSERT INTO TESTBUG values('Now deleting -->'|| to_char(cd.Source_Code));
142: --commit;
143:
144: BSC_DIM_FILTERS_PUB.Check_Filters_Not_Apply
145: ( p_Tab_Id => cd.Source_Code
146: , x_return_status => x_return_status
147: , x_msg_count => x_msg_count
148: , x_msg_data => x_msg_data

Line 151: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Check_Filters_Not_Apply Failed: at BSC_DIM_FILTERS_PUB.Check_Filters_Not_Apply');

147: , x_msg_count => x_msg_count
148: , x_msg_data => x_msg_data
149: );
150: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
151: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.Check_Filters_Not_Apply Failed: at BSC_DIM_FILTERS_PUB.Check_Filters_Not_Apply');
152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
153: END IF;
154: END LOOP;
155:

Line 179: x_msg_data := x_msg_data||' -> BSC_DIM_FILTERS_PUB.Check_Filters_Not_Apply_By_KPI ';

175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176: WHEN OTHERS THEN
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: IF (x_msg_data IS NULL) THEN
179: x_msg_data := x_msg_data||' -> BSC_DIM_FILTERS_PUB.Check_Filters_Not_Apply_By_KPI ';
180: ELSE
181: x_msg_data := SQLERRM||' at BSC_DIM_FILTERS_PUB.Check_Filters_Not_Apply_By_KPI ';
182: END IF;
183: END Check_Filters_Not_Apply_By_KPI;

Line 181: x_msg_data := SQLERRM||' at BSC_DIM_FILTERS_PUB.Check_Filters_Not_Apply_By_KPI ';

177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: IF (x_msg_data IS NULL) THEN
179: x_msg_data := x_msg_data||' -> BSC_DIM_FILTERS_PUB.Check_Filters_Not_Apply_By_KPI ';
180: ELSE
181: x_msg_data := SQLERRM||' at BSC_DIM_FILTERS_PUB.Check_Filters_Not_Apply_By_KPI ';
182: END IF;
183: END Check_Filters_Not_Apply_By_KPI;
184:
185: /*-------------------------------------------------------------------------------------------------------------------

Line 221: x_msg_data := x_msg_data||' -> BSC_DIM_FILTERS_PUB.Drop_Filter';

217: RAISE;
218: WHEN OTHERS THEN
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
220: IF (x_msg_data IS NOT NULL) THEN
221: x_msg_data := x_msg_data||' -> BSC_DIM_FILTERS_PUB.Drop_Filter';
222: ELSE
223: x_msg_data := SQLERRM||' at BSC_DIM_FILTERS_PUB.Drop_Filter';
224: END IF;
225: RAISE;

Line 223: x_msg_data := SQLERRM||' at BSC_DIM_FILTERS_PUB.Drop_Filter';

219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
220: IF (x_msg_data IS NOT NULL) THEN
221: x_msg_data := x_msg_data||' -> BSC_DIM_FILTERS_PUB.Drop_Filter';
222: ELSE
223: x_msg_data := SQLERRM||' at BSC_DIM_FILTERS_PUB.Drop_Filter';
224: END IF;
225: RAISE;
226: END Drop_Filter;
227:

Line 260: x_msg_data := x_msg_data ||' -> BSC_DIM_FILTERS_PUB.Synch_Fiters_And_Kpi_Dim ';

256: WHEN OTHERS THEN
257: ROLLBACK TO BcsFiltersPubSynchKpiDim;
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
259: IF (x_msg_data IS NOT NULL) THEN
260: x_msg_data := x_msg_data ||' -> BSC_DIM_FILTERS_PUB.Synch_Fiters_And_Kpi_Dim ';
261: ELSE
262: x_msg_data := SQLERRM ||' at BSC_DIM_FILTERS_PUB.Synch_Fiters_And_Kpi_Dim ';
263: END IF;
264: RAISE;

Line 262: x_msg_data := SQLERRM ||' at BSC_DIM_FILTERS_PUB.Synch_Fiters_And_Kpi_Dim ';

258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
259: IF (x_msg_data IS NOT NULL) THEN
260: x_msg_data := x_msg_data ||' -> BSC_DIM_FILTERS_PUB.Synch_Fiters_And_Kpi_Dim ';
261: ELSE
262: x_msg_data := SQLERRM ||' at BSC_DIM_FILTERS_PUB.Synch_Fiters_And_Kpi_Dim ';
263: END IF;
264: RAISE;
265: END Synch_Fiters_And_Kpi_Dim;
266:

Line 296: BSC_DIM_FILTERS_PUB.Drop_Filter

292:
293: EXIT WHEN c_tabs_with_current_dim_obj%NOTFOUND;
294:
295: --DBMS_OUTPUT.PUT_LINE(' call Drop_Filter_By_Dim_Obj for Tab_Id = ' || l_Tab_Id);
296: BSC_DIM_FILTERS_PUB.Drop_Filter
297: ( p_Tab_Id => l_Tab_Id
298: , p_Dim_Level_Id => p_Dim_Level_Id
299: , x_return_status => x_return_status
300: , x_msg_COUNT => x_msg_COUNT

Line 326: x_msg_data := x_msg_data||' -> BSC_DIM_FILTERS_PUB.Drop_Filter_By_Dim_Obj';

322: END IF;
323: ROLLBACK TO BcsFiltersPubDelFilterViewBDO;
324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
325: IF (x_msg_data IS NOT NULL) THEN
326: x_msg_data := x_msg_data||' -> BSC_DIM_FILTERS_PUB.Drop_Filter_By_Dim_Obj';
327: ELSE
328: x_msg_data := SQLERRM||' at BSC_DIM_FILTERS_PUB.Drop_Filter_By_Dim_Obj';
329: END IF;
330: RAISE;

Line 328: x_msg_data := SQLERRM||' at BSC_DIM_FILTERS_PUB.Drop_Filter_By_Dim_Obj';

324: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
325: IF (x_msg_data IS NOT NULL) THEN
326: x_msg_data := x_msg_data||' -> BSC_DIM_FILTERS_PUB.Drop_Filter_By_Dim_Obj';
327: ELSE
328: x_msg_data := SQLERRM||' at BSC_DIM_FILTERS_PUB.Drop_Filter_By_Dim_Obj';
329: END IF;
330: RAISE;
331: END Drop_Filter_By_Dim_Obj;
332:

Line 362: BSC_DIM_FILTERS_PUB.Drop_Filter

358:
359: EXIT WHEN c_dim_filters%NOTFOUND;
360: --DBMS_OUTPUT.PUT_LINE(' call Drop_Filter_By_Tab -- l_Dim_Level_id = ' || l_Dim_Level_id);
361:
362: BSC_DIM_FILTERS_PUB.Drop_Filter
363: ( p_Tab_Id => p_Tab_Id
364: , p_Dim_Level_Id => l_Dim_Level_id
365: , x_return_status => x_return_status
366: , x_msg_COUNT => x_msg_COUNT

Line 392: x_msg_data := x_msg_data||' -> BSC_DIM_FILTERS_PUB.Drop_Filter_By_Tab';

388: END IF;
389: ROLLBACK TO BcsFiltersPubDelFilterViewBT;
390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
391: IF (x_msg_data IS NOT NULL) THEN
392: x_msg_data := x_msg_data||' -> BSC_DIM_FILTERS_PUB.Drop_Filter_By_Tab';
393: ELSE
394: x_msg_data := SQLERRM||' at BSC_DIM_FILTERS_PUB.Drop_Filter_By_Tab';
395: END IF;
396: RAISE;

Line 394: x_msg_data := SQLERRM||' at BSC_DIM_FILTERS_PUB.Drop_Filter_By_Tab';

390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
391: IF (x_msg_data IS NOT NULL) THEN
392: x_msg_data := x_msg_data||' -> BSC_DIM_FILTERS_PUB.Drop_Filter_By_Tab';
393: ELSE
394: x_msg_data := SQLERRM||' at BSC_DIM_FILTERS_PUB.Drop_Filter_By_Tab';
395: END IF;
396: RAISE;
397: END Drop_Filter_By_Tab;
398:

Line 417: AND B.Source_Type = BSC_DIM_FILTERS_PUB.Source_Type_Tab;

413: , BSC_SYS_FILTERS_VIEWS B
414: WHERE A.Indicator = p_Kpi_Id
415: AND B.Dim_Level_Id = p_Dim_Level_Id
416: AND B.Source_Code = A.Tab_Id
417: AND B.Source_Type = BSC_DIM_FILTERS_PUB.Source_Type_Tab;
418:
419: l_Filter_View_Name BSC_KPI_DIM_LEVELS_B.Level_View_Name%TYPE := NULL;
420: BEGIN
421: IF (c_Filter_View_Name%ISOPEN) THEN

Line 439: END BSC_DIM_FILTERS_PUB;

435:
436:
437:
438:
439: END BSC_DIM_FILTERS_PUB;