DBA Data[Home] [Help]

APPS.BSC_DIM_LEVEL_FILTERS_PVT dependencies on BSC_DIM_LEVEL_FILTERS_PVT

Line 1: PACKAGE BODY BSC_DIM_LEVEL_FILTERS_PVT AS

1: PACKAGE BODY BSC_DIM_LEVEL_FILTERS_PVT AS
2: /* $Header: BSCVFILB.pls 120.0.12000000.1 2007/07/17 07:44:42 appldev noship $ */
3: /*
4: REM +=======================================================================+
5: REM | Copyright (c) 2002 Oracle Corporation, Redwood Shores, CA, USA |

Line 65: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.delete_filters ';

61: RAISE;
62: WHEN NO_DATA_FOUND THEN
63: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
64: IF (x_msg_data IS NOT NULL) THEN
65: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.delete_filters ';
66: ELSE
67: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.delete_filters ';
68: END IF;
69:

Line 67: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.delete_filters ';

63: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
64: IF (x_msg_data IS NOT NULL) THEN
65: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.delete_filters ';
66: ELSE
67: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.delete_filters ';
68: END IF;
69:
70: RAISE;
71: WHEN OTHERS THEN

Line 74: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.delete_filters ';

70: RAISE;
71: WHEN OTHERS THEN
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
73: IF (x_msg_data IS NOT NULL) THEN
74: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.delete_filters ';
75: ELSE
76: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.delete_filters ';
77: END IF;
78:

Line 76: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.delete_filters ';

72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
73: IF (x_msg_data IS NOT NULL) THEN
74: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.delete_filters ';
75: ELSE
76: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.delete_filters ';
77: END IF;
78:
79: RAISE;
80:

Line 137: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.insert_filters ';

133: RAISE;
134: WHEN NO_DATA_FOUND THEN
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
136: IF (x_msg_data IS NOT NULL) THEN
137: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.insert_filters ';
138: ELSE
139: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.insert_filters ';
140: END IF;
141:

Line 139: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.insert_filters ';

135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
136: IF (x_msg_data IS NOT NULL) THEN
137: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.insert_filters ';
138: ELSE
139: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.insert_filters ';
140: END IF;
141:
142: RAISE;
143: WHEN OTHERS THEN

Line 146: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.insert_filters ';

142: RAISE;
143: WHEN OTHERS THEN
144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
145: IF (x_msg_data IS NOT NULL) THEN
146: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.insert_filters ';
147: ELSE
148: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.insert_filters ';
149: END IF;
150:

Line 148: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.insert_filters ';

144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
145: IF (x_msg_data IS NOT NULL) THEN
146: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.insert_filters ';
147: ELSE
148: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.insert_filters ';
149: END IF;
150:
151: RAISE;
152:

Line 202: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.delete_filters_view ';

198: RAISE;
199: WHEN NO_DATA_FOUND THEN
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
201: IF (x_msg_data IS NOT NULL) THEN
202: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.delete_filters_view ';
203: ELSE
204: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.delete_filters_view ';
205: END IF;
206:

Line 204: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.delete_filters_view ';

200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
201: IF (x_msg_data IS NOT NULL) THEN
202: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.delete_filters_view ';
203: ELSE
204: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.delete_filters_view ';
205: END IF;
206:
207: RAISE;
208: WHEN OTHERS THEN

Line 211: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.delete_filters_view ';

207: RAISE;
208: WHEN OTHERS THEN
209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
210: IF (x_msg_data IS NOT NULL) THEN
211: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.delete_filters_view ';
212: ELSE
213: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.delete_filters_view ';
214: END IF;
215:

Line 213: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.delete_filters_view ';

209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
210: IF (x_msg_data IS NOT NULL) THEN
211: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.delete_filters_view ';
212: ELSE
213: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.delete_filters_view ';
214: END IF;
215:
216: RAISE;
217: END delete_filters_view;

Line 277: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.insert_filters_view ';

273: RAISE;
274: WHEN NO_DATA_FOUND THEN
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: IF (x_msg_data IS NOT NULL) THEN
277: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.insert_filters_view ';
278: ELSE
279: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.insert_filters_view ';
280: END IF;
281:

Line 279: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.insert_filters_view ';

275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: IF (x_msg_data IS NOT NULL) THEN
277: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.insert_filters_view ';
278: ELSE
279: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.insert_filters_view ';
280: END IF;
281:
282: RAISE;
283: WHEN OTHERS THEN

Line 286: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.insert_filters_view ';

282: RAISE;
283: WHEN OTHERS THEN
284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
285: IF (x_msg_data IS NOT NULL) THEN
286: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.insert_filters_view ';
287: ELSE
288: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.insert_filters_view ';
289: END IF;
290:

Line 288: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.insert_filters_view ';

284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
285: IF (x_msg_data IS NOT NULL) THEN
286: x_msg_data := x_msg_data||' -> BSC_DIM_LEVEL_FILTERS_PVT.insert_filters_view ';
287: ELSE
288: x_msg_data := SQLERRM||' at BSC_DIM_LEVEL_FILTERS_PVT.insert_filters_view ';
289: END IF;
290:
291: RAISE;
292:

Line 295: END BSC_DIM_LEVEL_FILTERS_PVT;

291: RAISE;
292:
293: END insert_filters_view;
294:
295: END BSC_DIM_LEVEL_FILTERS_PVT;