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_PVT dependencies on FND_API

Line 84: x_return_status := FND_API.G_RET_STS_SUCCESS;

80: SAVEPOINT CheckFiltersNotApplyPvt;
81: --DBMS_OUTPUT.PUT_LINE('BEGIN Check_Filters_Not_Apply' );
82: ----DBMS_OUTPUT.PUT_LINE('Check_Filters_Not_Apply p_Tab_Id = ' || p_Tab_Id );
83:
84: x_return_status := FND_API.G_RET_STS_SUCCESS;
85:
86: IF (p_Tab_Id IS NOT NULL) THEN
87: -- Find Tab Dim Levels
88: OPEN c_Filters_Not_Apply;

Line 113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

109: CLOSE c_Filters_Not_Apply;
110: END IF;
111: ----DBMS_OUTPUT.PUT_LINE('END Check_Filters_Not_Apply' );
112: EXCEPTION
113: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
114: IF (c_Filters_Not_Apply%ISOPEN) THEN
115: CLOSE c_Filters_Not_Apply;
116: END IF;
117: ROLLBACK TO CheckFiltersNotApplyPvt;

Line 118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

114: IF (c_Filters_Not_Apply%ISOPEN) THEN
115: CLOSE c_Filters_Not_Apply;
116: END IF;
117: ROLLBACK TO CheckFiltersNotApplyPvt;
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
119: FND_MSG_PUB.COUNT_And_Get
120: ( p_encoded => FND_API.G_FALSE
121: , p_COUNT => x_msg_COUNT
122: , p_data => x_msg_data

Line 120: ( p_encoded => FND_API.G_FALSE

116: END IF;
117: ROLLBACK TO CheckFiltersNotApplyPvt;
118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
119: FND_MSG_PUB.COUNT_And_Get
120: ( p_encoded => FND_API.G_FALSE
121: , p_COUNT => x_msg_COUNT
122: , p_data => x_msg_data
123: );
124: RAISE;

Line 130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

126: IF (c_Filters_Not_Apply%ISOPEN) THEN
127: CLOSE c_Filters_Not_Apply;
128: END IF;
129: ROLLBACK TO CheckFiltersNotApplyPvt;
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
131: FND_MSG_PUB.COUNT_And_Get
132: ( p_encoded => FND_API.G_FALSE
133: , p_COUNT => x_msg_COUNT
134: , p_data => x_msg_data

Line 132: ( p_encoded => FND_API.G_FALSE

128: END IF;
129: ROLLBACK TO CheckFiltersNotApplyPvt;
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
131: FND_MSG_PUB.COUNT_And_Get
132: ( p_encoded => FND_API.G_FALSE
133: , p_COUNT => x_msg_COUNT
134: , p_data => x_msg_data
135: );
136: RAISE;

Line 180: x_return_status := FND_API.G_RET_STS_SUCCESS;

176: --DBMS_OUTPUT.PUT_LINE('BEGIN Drop_Filter' );
177: --DBMS_OUTPUT.PUT_LINE('Drop_Filter p_Tab_Id = ' || p_Tab_Id );
178: --DBMS_OUTPUT.PUT_LINE('Drop_Filter p_Dim_Level_Id = ' || p_Dim_Level_Id );
179:
180: x_return_status := FND_API.G_RET_STS_SUCCESS;
181:
182: l_Filter_Level_View_Name := BSC_DIM_FILTERS_PVT.Get_Filter_View_Name(p_Tab_Id, p_Dim_Level_Id);
183:
184: --DBMS_OUTPUT.PUT_LINE(' Drop_Filter l_Filter_Level_View_Name = ' || l_Filter_Level_View_Name );

Line 235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

231: END IF;
232:
233: --DBMS_OUTPUT.PUT_LINE('END Drop_Filter p_Tab_Id = ' || p_Tab_Id || ' p_Dim_Level_Id = ' || p_Dim_Level_Id );
234: EXCEPTION
235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
236: IF (c_child_dim_obj%ISOPEN) THEN
237: CLOSE c_child_dim_obj;
238: END IF;
239: ROLLBACK TO BcsFiltersPubDeleteFilterView;

Line 240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

236: IF (c_child_dim_obj%ISOPEN) THEN
237: CLOSE c_child_dim_obj;
238: END IF;
239: ROLLBACK TO BcsFiltersPubDeleteFilterView;
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
241: FND_MSG_PUB.COUNT_And_Get
242: ( p_encoded => FND_API.G_FALSE
243: , p_COUNT => x_msg_COUNT
244: , p_data => x_msg_data

Line 242: ( p_encoded => FND_API.G_FALSE

238: END IF;
239: ROLLBACK TO BcsFiltersPubDeleteFilterView;
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
241: FND_MSG_PUB.COUNT_And_Get
242: ( p_encoded => FND_API.G_FALSE
243: , p_COUNT => x_msg_COUNT
244: , p_data => x_msg_data
245: );
246: RAISE;

Line 252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

248: IF (c_child_dim_obj%ISOPEN) THEN
249: CLOSE c_child_dim_obj;
250: END IF;
251: ROLLBACK TO BcsFiltersPubDeleteFilterView;
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
253: IF (x_msg_data IS NOT NULL) THEN
254: x_msg_data := x_msg_data||' -> BSC_DIM_FILTERS_PVT.Drop_Filter';
255: ELSE
256: x_msg_data := SQLERRM||' at BSC_DIM_FILTERS_PVT.Drop_Filter';

Line 282: x_return_status := FND_API.G_RET_STS_SUCCESS;

278: ----DBMS_OUTPUT.PUT_LINE('BEGIN Drop_Filter' );
279: ----DBMS_OUTPUT.PUT_LINE('Drop_Filter p_Tab_Id = ' || p_Tab_Id );
280: ----DBMS_OUTPUT.PUT_LINE('Drop_Filter p_Dim_Level_Id = ' || p_Dim_Level_Id );
281:
282: x_return_status := FND_API.G_RET_STS_SUCCESS;
283: -- Save point for the current filters view
284: SAVEPOINT BcsFiltersPvtDeleteFilterView;
285:
286: l_Filter_Level_View_Name := Get_Filter_View_Name(p_Tab_Id, p_Dim_Level_Id);

Line 345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

341: END IF;
342:
343: ----DBMS_OUTPUT.PUT_LINE('END Drop_Filter p_Tab_Id = ' || p_Tab_Id || ' p_Dim_Level_Id = ' || p_Dim_Level_Id );
344: EXCEPTION
345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
346: ROLLBACK TO BcsFiltersPvtDeleteFilterView;
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
348: FND_MSG_PUB.COUNT_And_Get
349: ( p_encoded => FND_API.G_FALSE

Line 347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

343: ----DBMS_OUTPUT.PUT_LINE('END Drop_Filter p_Tab_Id = ' || p_Tab_Id || ' p_Dim_Level_Id = ' || p_Dim_Level_Id );
344: EXCEPTION
345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
346: ROLLBACK TO BcsFiltersPvtDeleteFilterView;
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
348: FND_MSG_PUB.COUNT_And_Get
349: ( p_encoded => FND_API.G_FALSE
350: , p_COUNT => x_msg_COUNT
351: , p_data => x_msg_data

Line 349: ( p_encoded => FND_API.G_FALSE

345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
346: ROLLBACK TO BcsFiltersPvtDeleteFilterView;
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
348: FND_MSG_PUB.COUNT_And_Get
349: ( p_encoded => FND_API.G_FALSE
350: , p_COUNT => x_msg_COUNT
351: , p_data => x_msg_data
352: );
353: RAISE;

Line 356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

352: );
353: RAISE;
354: WHEN OTHERS THEN
355: ROLLBACK TO BcsFiltersPvtDeleteFilterView;
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
357: IF (x_msg_data IS NOT NULL) THEN
358: x_msg_data := x_msg_data||' -> BSC_DIM_FILTERS_PVT.Drop_Filter_Objects';
359: ELSE
360: x_msg_data := SQLERRM||' at BSC_DIM_FILTERS_PVT.Drop_Filter_Objects';

Line 422: x_return_status := FND_API.G_RET_STS_SUCCESS;

418: AND KD.Level_View_Name <> SD.Level_View_Name;
419:
420: BEGIN
421:
422: x_return_status := FND_API.G_RET_STS_SUCCESS;
423: SAVEPOINT BcsFiltersPvtSynchKpiDim;
424: ----DBMS_OUTPUT.PUT_LINE('BEGIN Synch_Fiters_And_Kpi_Dim' );
425:
426: IF p_Tab_Id IS NOT NULL THEN

Line 494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

490: END IF;
491:
492: ----DBMS_OUTPUT.PUT_LINE('END Synch_Fiters_And_Kpi_Dim' );
493: EXCEPTION
494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
495: IF (c_Kpi_Dim_Obj_To_Synch%ISOPEN) THEN
496: CLOSE c_Kpi_Dim_Obj_To_Synch;
497: END IF;
498: IF (c_Kpi_Dim_Obj_To_Synch2%ISOPEN) THEN

Line 502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

498: IF (c_Kpi_Dim_Obj_To_Synch2%ISOPEN) THEN
499: CLOSE c_Kpi_Dim_Obj_To_Synch;
500: END IF;
501: ROLLBACK TO BcsFiltersPvtSynchKpiDim;
502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
503: FND_MSG_PUB.COUNT_And_Get
504: ( p_encoded => FND_API.G_FALSE
505: , p_COUNT => x_msg_COUNT
506: , p_data => x_msg_data

Line 504: ( p_encoded => FND_API.G_FALSE

500: END IF;
501: ROLLBACK TO BcsFiltersPvtSynchKpiDim;
502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
503: FND_MSG_PUB.COUNT_And_Get
504: ( p_encoded => FND_API.G_FALSE
505: , p_COUNT => x_msg_COUNT
506: , p_data => x_msg_data
507: );
508: RAISE;

Line 517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

513: IF (c_Kpi_Dim_Obj_To_Synch%ISOPEN) THEN
514: CLOSE c_Kpi_Dim_Obj_To_Synch2;
515: END IF;
516: ROLLBACK TO BcsFiltersPvtSynchKpiDim;
517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
518: IF (x_msg_data IS NOT NULL) THEN
519: x_msg_data := x_msg_data ||' -> BSC_DIM_FILTERS_PVT.Synch_Fiters_And_Kpi_Dim ';
520: ELSE
521: x_msg_data := SQLERRM ||' at BSC_DIM_FILTERS_PVT.Synch_Fiters_And_Kpi_Dim ';