82: CLOSE c_tabs_with_filters;
83: END IF;
84: ROLLBACK TO CheckFiltersNotApply;
85: x_return_status := FND_API.G_RET_STS_ERROR;
86: FND_MSG_PUB.COUNT_And_Get
87: ( p_encoded => FND_API.G_FALSE
88: , p_COUNT => x_msg_COUNT
89: , p_data => x_msg_data
90: );
95: CLOSE c_tabs_with_filters;
96: END IF;
97: ROLLBACK TO CheckFiltersNotApply;
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
99: FND_MSG_PUB.COUNT_And_Get
100: ( p_encoded => FND_API.G_FALSE
101: , p_COUNT => x_msg_COUNT
102: , p_data => x_msg_data
103: );
107: CLOSE c_tabs_with_filters;
108: END IF;
109: ROLLBACK TO CheckFiltersNotApply;
110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
111: FND_MSG_PUB.COUNT_And_Get
112: ( p_encoded => FND_API.G_FALSE
113: , p_COUNT => x_msg_COUNT
114: , p_data => x_msg_data
115: );
156: --DBMS_OUTPUT.PUT_LINE('Exiting from BSC_BIS_KPI_MEAS_PUB.Check_Filters_Not_Apply Procedure');
157: EXCEPTION
158: WHEN FND_API.G_EXC_ERROR THEN
159: IF (x_msg_data IS NULL) THEN
160: FND_MSG_PUB.Count_And_Get
161: ( p_encoded => FND_API.G_FALSE
162: , p_count => x_msg_count
163: , p_data => x_msg_data
164: );
165: END IF;
166: x_return_status := FND_API.G_RET_STS_ERROR;
167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
168: IF (x_msg_data IS NULL) THEN
169: FND_MSG_PUB.Count_And_Get
170: ( p_encoded => FND_API.G_FALSE
171: , p_count => x_msg_count
172: , p_data => x_msg_data
173: );
208: --DBMS_OUTPUT.PUT_LINE('END Drop_Filter p_Tab_Id = ' || p_Tab_Id || ' p_Dim_Level_Id = ' || p_Dim_Level_Id );
209: EXCEPTION
210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212: FND_MSG_PUB.COUNT_And_Get
213: ( p_encoded => FND_API.G_FALSE
214: , p_COUNT => x_msg_COUNT
215: , p_data => x_msg_data
216: );
246: EXCEPTION
247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
248: ROLLBACK TO BcsFiltersPubSynchKpiDim;
249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
250: FND_MSG_PUB.COUNT_And_Get
251: ( p_encoded => FND_API.G_FALSE
252: , p_COUNT => x_msg_COUNT
253: , p_data => x_msg_data
254: );
309: CLOSE c_tabs_with_current_dim_obj;
310: END IF;
311: ROLLBACK TO BcsFiltersPubDelFilterViewBDO;
312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
313: FND_MSG_PUB.COUNT_And_Get
314: ( p_encoded => FND_API.G_FALSE
315: , p_COUNT => x_msg_COUNT
316: , p_data => x_msg_data
317: );
375: CLOSE c_dim_filters;
376: END IF;
377: ROLLBACK TO BcsFiltersPubDelFilterViewBT;
378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
379: FND_MSG_PUB.COUNT_And_Get
380: ( p_encoded => FND_API.G_FALSE
381: , p_COUNT => x_msg_COUNT
382: , p_data => x_msg_data
383: );