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

Line 25: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

21: PROCEDURE insert_common_dimensions
22: (
23: p_tab_id IN NUMBER
24: ,p_new_list_config IN VARCHAR2
25: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
26: ,x_return_status OUT NOCOPY VARCHAR2
27: ,x_msg_count OUT NOCOPY NUMBER
28: ,x_msg_data OUT NOCOPY VARCHAR2
29: ) IS

Line 91: IF(x_return_status IS NOT NULL AND x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN

87: ,x_return_status => x_return_status
88: ,x_msg_count => x_msg_count
89: ,x_msg_data => x_msg_data
90: );
91: IF(x_return_status IS NOT NULL AND x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: END IF;
94:
95: BSC_COMMON_DIMENSIONS_PVT.Get_Parent_level_properties

Line 92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

88: ,x_msg_count => x_msg_count
89: ,x_msg_data => x_msg_data
90: );
91: IF(x_return_status IS NOT NULL AND x_return_status <> FND_API.G_RET_STS_SUCCESS)THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
93: END IF;
94:
95: BSC_COMMON_DIMENSIONS_PVT.Get_Parent_level_properties
96: (

Line 110: IF (p_commit = FND_API.G_TRUE) THEN

106: END IF;
107: END IF;
108: END LOOP;
109:
110: IF (p_commit = FND_API.G_TRUE) THEN
111: COMMIT;
112: END IF;
113: END IF;
114:

Line 116: WHEN FND_API.G_EXC_ERROR THEN

112: END IF;
113: END IF;
114:
115: EXCEPTION
116: WHEN FND_API.G_EXC_ERROR THEN
117: FND_MSG_PUB.Count_And_Get
118: ( p_encoded => FND_API.G_FALSE
119: , p_count => x_msg_count
120: , p_data => x_msg_data

Line 118: ( p_encoded => FND_API.G_FALSE

114:
115: EXCEPTION
116: WHEN FND_API.G_EXC_ERROR THEN
117: FND_MSG_PUB.Count_And_Get
118: ( p_encoded => FND_API.G_FALSE
119: , p_count => x_msg_count
120: , p_data => x_msg_data
121: );
122:

Line 123: x_return_status := FND_API.G_RET_STS_ERROR;

119: , p_count => x_msg_count
120: , p_data => x_msg_data
121: );
122:
123: x_return_status := FND_API.G_RET_STS_ERROR;
124: RAISE;
125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
126: FND_MSG_PUB.Count_And_Get
127: ( p_encoded => FND_API.G_FALSE

Line 125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

121: );
122:
123: x_return_status := FND_API.G_RET_STS_ERROR;
124: RAISE;
125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
126: FND_MSG_PUB.Count_And_Get
127: ( p_encoded => FND_API.G_FALSE
128: , p_count => x_msg_count
129: , p_data => x_msg_data

Line 127: ( p_encoded => FND_API.G_FALSE

123: x_return_status := FND_API.G_RET_STS_ERROR;
124: RAISE;
125: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
126: FND_MSG_PUB.Count_And_Get
127: ( p_encoded => FND_API.G_FALSE
128: , p_count => x_msg_count
129: , p_data => x_msg_data
130: );
131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

127: ( p_encoded => FND_API.G_FALSE
128: , p_count => x_msg_count
129: , p_data => x_msg_data
130: );
131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
132:
133: RAISE;
134: WHEN NO_DATA_FOUND THEN
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

131: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
132:
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_COMMON_DIMENSIONS_PVT.insert_common_dimensions ';
138: ELSE
139: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.insert_common_dimensions ';

Line 144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

140: END IF;
141:
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_COMMON_DIMENSIONS_PVT.insert_common_dimensions ';
147: ELSE
148: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.insert_common_dimensions ';

Line 161: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

157:
158: PROCEDURE delete_common_dimensions
159: (
160: p_tab_id IN NUMBER
161: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
162: ,x_return_status OUT NOCOPY VARCHAR2
163: ,x_msg_count OUT NOCOPY NUMBER
164: ,x_msg_data OUT NOCOPY VARCHAR2
165: ) IS

Line 167: x_return_status := FND_API.G_RET_STS_SUCCESS;

163: ,x_msg_count OUT NOCOPY NUMBER
164: ,x_msg_data OUT NOCOPY VARCHAR2
165: ) IS
166: BEGIN
167: x_return_status := FND_API.G_RET_STS_SUCCESS;
168:
169: IF (p_tab_id IS NOT NULL ) THEN
170: DELETE
171: FROM bsc_sys_com_dim_levels

Line 175: IF (p_commit = FND_API.G_TRUE) THEN

171: FROM bsc_sys_com_dim_levels
172: WHERE tab_id = p_tab_id;
173:
174: END IF;
175: IF (p_commit = FND_API.G_TRUE) THEN
176: COMMIT;
177: END IF;
178:
179: EXCEPTION

Line 180: WHEN FND_API.G_EXC_ERROR THEN

176: COMMIT;
177: END IF;
178:
179: EXCEPTION
180: WHEN FND_API.G_EXC_ERROR THEN
181: FND_MSG_PUB.Count_And_Get
182: ( p_encoded => FND_API.G_FALSE
183: , p_count => x_msg_count
184: , p_data => x_msg_data

Line 182: ( p_encoded => FND_API.G_FALSE

178:
179: EXCEPTION
180: WHEN FND_API.G_EXC_ERROR THEN
181: FND_MSG_PUB.Count_And_Get
182: ( p_encoded => FND_API.G_FALSE
183: , p_count => x_msg_count
184: , p_data => x_msg_data
185: );
186:

Line 187: x_return_status := FND_API.G_RET_STS_ERROR;

183: , p_count => x_msg_count
184: , p_data => x_msg_data
185: );
186:
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: RAISE;
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190: FND_MSG_PUB.Count_And_Get
191: ( p_encoded => FND_API.G_FALSE

Line 189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

185: );
186:
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: RAISE;
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190: FND_MSG_PUB.Count_And_Get
191: ( p_encoded => FND_API.G_FALSE
192: , p_count => x_msg_count
193: , p_data => x_msg_data

Line 191: ( p_encoded => FND_API.G_FALSE

187: x_return_status := FND_API.G_RET_STS_ERROR;
188: RAISE;
189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
190: FND_MSG_PUB.Count_And_Get
191: ( p_encoded => FND_API.G_FALSE
192: , p_count => x_msg_count
193: , p_data => x_msg_data
194: );
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

191: ( p_encoded => FND_API.G_FALSE
192: , p_count => x_msg_count
193: , p_data => x_msg_data
194: );
195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196:
197: RAISE;
198: WHEN NO_DATA_FOUND THEN
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

195: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
196:
197: RAISE;
198: WHEN NO_DATA_FOUND THEN
199: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
200: IF (x_msg_data IS NOT NULL) THEN
201: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.delete_common_dimensions ';
202: ELSE
203: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.delete_common_dimensions ';

Line 208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

204: END IF;
205:
206: RAISE;
207: WHEN OTHERS THEN
208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
209: IF (x_msg_data IS NOT NULL) THEN
210: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.delete_common_dimensions ';
211: ELSE
212: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.delete_common_dimensions ';

Line 221: p_commit IN VARCHAR2 := FND_API.G_FALSE

217: END delete_common_dimensions;
218:
219:
220: PROCEDURE delete_common_dimensions_tabs (
221: p_commit IN VARCHAR2 := FND_API.G_FALSE
222: , p_tab_ids IN VARCHAR2
223: , x_return_status OUT NOCOPY VARCHAR2
224: , x_msg_count OUT NOCOPY NUMBER
225: , x_msg_data OUT NOCOPY VARCHAR2

Line 232: x_return_status := FND_API.G_RET_STS_SUCCESS;

228: l_tab_ids VARCHAR2(1000);
229: l_tab_id VARCHAR2(10);
230: BEGIN
231:
232: x_return_status := FND_API.G_RET_STS_SUCCESS;
233:
234: IF p_tab_ids IS NOT NULL THEN
235: l_tab_ids := p_tab_ids ;
236: WHILE (BSC_BIS_KPI_MEAS_PUB.is_more ( p_dim_short_names => l_tab_ids

Line 246: IF (x_return_status IS NULL OR x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

242: , x_msg_count => x_msg_count
243: , x_msg_data => x_msg_data
244: );
245:
246: IF (x_return_status IS NULL OR x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: END IF;
249:
250: END LOOP;

Line 247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

243: , x_msg_data => x_msg_data
244: );
245:
246: IF (x_return_status IS NULL OR x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
248: END IF;
249:
250: END LOOP;
251:

Line 255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

251:
252: END IF;
253:
254: EXCEPTION
255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
256: FND_MSG_PUB.Count_And_Get
257: ( p_encoded => FND_API.G_FALSE
258: , p_count => x_msg_count
259: , p_data => x_msg_data

Line 257: ( p_encoded => FND_API.G_FALSE

253:
254: EXCEPTION
255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
256: FND_MSG_PUB.Count_And_Get
257: ( p_encoded => FND_API.G_FALSE
258: , p_count => x_msg_count
259: , p_data => x_msg_data
260: );
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

257: ( p_encoded => FND_API.G_FALSE
258: , p_count => x_msg_count
259: , p_data => x_msg_data
260: );
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262: RAISE;
263: WHEN OTHERS THEN
264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
265: IF (x_msg_data IS NOT NULL) THEN

Line 264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

260: );
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262: RAISE;
263: WHEN OTHERS THEN
264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
265: IF (x_msg_data IS NOT NULL) THEN
266: x_msg_data := x_msg_data || ' -> BSC_COMMON_DIMENSIONS_PVT.delete_common_dimensions_tabs ';
267: ELSE
268: x_msg_data := SQLERRM || ' at BSC_COMMON_DIMENSIONS_PVT.delete_common_dimensions_tabs ';

Line 278: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

274: PROCEDURE delete_user_list_access
275: (
276: p_tab_id IN NUMBER
277: ,p_dim_level_index IN NUMBER
278: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
279: ,x_return_status OUT NOCOPY VARCHAR2
280: ,x_msg_count OUT NOCOPY NUMBER
281: ,x_msg_data OUT NOCOPY VARCHAR2
282: ) IS

Line 292: IF (p_commit = FND_API.G_TRUE) THEN

288: FROM BSC_USER_LIST_ACCESS
289: WHERE tab_id = p_tab_id
290: AND DIM_LEVEL_INDEX >= p_dim_level_index;
291:
292: IF (p_commit = FND_API.G_TRUE) THEN
293: COMMIT;
294: END IF;
295:
296: END IF;

Line 300: WHEN FND_API.G_EXC_ERROR THEN

296: END IF;
297:
298: EXCEPTION
299:
300: WHEN FND_API.G_EXC_ERROR THEN
301: FND_MSG_PUB.Count_And_Get
302: ( p_encoded => FND_API.G_FALSE
303: , p_count => x_msg_count
304: , p_data => x_msg_data

Line 302: ( p_encoded => FND_API.G_FALSE

298: EXCEPTION
299:
300: WHEN FND_API.G_EXC_ERROR THEN
301: FND_MSG_PUB.Count_And_Get
302: ( p_encoded => FND_API.G_FALSE
303: , p_count => x_msg_count
304: , p_data => x_msg_data
305: );
306:

Line 307: x_return_status := FND_API.G_RET_STS_ERROR;

303: , p_count => x_msg_count
304: , p_data => x_msg_data
305: );
306:
307: x_return_status := FND_API.G_RET_STS_ERROR;
308: RAISE;
309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
310: FND_MSG_PUB.Count_And_Get
311: ( p_encoded => FND_API.G_FALSE

Line 309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

305: );
306:
307: x_return_status := FND_API.G_RET_STS_ERROR;
308: RAISE;
309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
310: FND_MSG_PUB.Count_And_Get
311: ( p_encoded => FND_API.G_FALSE
312: , p_count => x_msg_count
313: , p_data => x_msg_data

Line 311: ( p_encoded => FND_API.G_FALSE

307: x_return_status := FND_API.G_RET_STS_ERROR;
308: RAISE;
309: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
310: FND_MSG_PUB.Count_And_Get
311: ( p_encoded => FND_API.G_FALSE
312: , p_count => x_msg_count
313: , p_data => x_msg_data
314: );
315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

311: ( p_encoded => FND_API.G_FALSE
312: , p_count => x_msg_count
313: , p_data => x_msg_data
314: );
315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
316:
317: RAISE;
318: WHEN NO_DATA_FOUND THEN
319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
316:
317: RAISE;
318: WHEN NO_DATA_FOUND THEN
319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
320: IF (x_msg_data IS NOT NULL) THEN
321: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.delete_user_list_access ';
322: ELSE
323: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.delete_user_list_access ';

Line 328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 352: ,p_commit IN VARCHAR2 := FND_API.G_FALSE

348: ,p_created_by IN bsc_user_list_access.created_by%TYPE
349: ,p_last_update_date IN bsc_user_list_access.last_update_date%TYPE
350: ,p_last_updated_by IN bsc_user_list_access.last_updated_by%TYPE
351: ,p_last_update_login IN bsc_user_list_access.last_update_login%TYPE
352: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
353: ,x_return_status OUT NOCOPY VARCHAR2
354: ,x_msg_count OUT NOCOPY NUMBER
355: ,x_msg_data OUT NOCOPY VARCHAR2
356: )

Line 385: IF (p_commit = FND_API.G_TRUE) THEN

381: ,p_last_updated_by
382: ,p_last_update_login
383: );
384:
385: IF (p_commit = FND_API.G_TRUE) THEN
386: COMMIT;
387: END IF;
388: END IF;
389: END IF;

Line 393: WHEN FND_API.G_EXC_ERROR THEN

389: END IF;
390:
391: EXCEPTION
392:
393: WHEN FND_API.G_EXC_ERROR THEN
394: FND_MSG_PUB.Count_And_Get
395: ( p_encoded => FND_API.G_FALSE
396: , p_count => x_msg_count
397: , p_data => x_msg_data

Line 395: ( p_encoded => FND_API.G_FALSE

391: EXCEPTION
392:
393: WHEN FND_API.G_EXC_ERROR THEN
394: FND_MSG_PUB.Count_And_Get
395: ( p_encoded => FND_API.G_FALSE
396: , p_count => x_msg_count
397: , p_data => x_msg_data
398: );
399:

Line 400: x_return_status := FND_API.G_RET_STS_ERROR;

396: , p_count => x_msg_count
397: , p_data => x_msg_data
398: );
399:
400: x_return_status := FND_API.G_RET_STS_ERROR;
401: RAISE;
402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
403: FND_MSG_PUB.Count_And_Get
404: ( p_encoded => FND_API.G_FALSE

Line 402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

398: );
399:
400: x_return_status := FND_API.G_RET_STS_ERROR;
401: RAISE;
402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
403: FND_MSG_PUB.Count_And_Get
404: ( p_encoded => FND_API.G_FALSE
405: , p_count => x_msg_count
406: , p_data => x_msg_data

Line 404: ( p_encoded => FND_API.G_FALSE

400: x_return_status := FND_API.G_RET_STS_ERROR;
401: RAISE;
402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
403: FND_MSG_PUB.Count_And_Get
404: ( p_encoded => FND_API.G_FALSE
405: , p_count => x_msg_count
406: , p_data => x_msg_data
407: );
408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

404: ( p_encoded => FND_API.G_FALSE
405: , p_count => x_msg_count
406: , p_data => x_msg_data
407: );
408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
409:
410: RAISE;
411: WHEN NO_DATA_FOUND THEN
412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
409:
410: RAISE;
411: WHEN NO_DATA_FOUND THEN
412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
413: IF (x_msg_data IS NOT NULL) THEN
414: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.insert_user_list_access ';
415: ELSE
416: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.insert_user_list_access ';

Line 421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

417: END IF;
418:
419: RAISE;
420: WHEN OTHERS THEN
421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
422: IF (x_msg_data IS NOT NULL) THEN
423: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.insert_user_list_access ';
424: ELSE
425: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.insert_user_list_access ';

Line 451: x_return_status := FND_API.G_RET_STS_SUCCESS;

447: l_sql VARCHAR2(1000);
448: l_bind_vars_values BSC_UPDATE_UTIL.t_array_of_number;
449:
450: BEGIN
451: x_return_status := FND_API.G_RET_STS_SUCCESS;
452:
453: UPDATE bsc_kpi_dim_levels_b
454: SET DEFAULT_VALUE = BSC_COMMON_DIMENSIONS_PVT.C_ALL
455: WHERE indicator IN (

Line 461: WHEN FND_API.G_EXC_ERROR THEN

457: AND default_value like BSC_COMMON_DIMENSIONS_PVT.C_COM_DIM_DEFAULT_VALUE;
458:
459: EXCEPTION
460:
461: WHEN FND_API.G_EXC_ERROR THEN
462: FND_MSG_PUB.Count_And_Get
463: ( p_encoded => FND_API.G_FALSE
464: , p_count => x_msg_count
465: , p_data => x_msg_data

Line 463: ( p_encoded => FND_API.G_FALSE

459: EXCEPTION
460:
461: WHEN FND_API.G_EXC_ERROR THEN
462: FND_MSG_PUB.Count_And_Get
463: ( p_encoded => FND_API.G_FALSE
464: , p_count => x_msg_count
465: , p_data => x_msg_data
466: );
467:

Line 468: x_return_status := FND_API.G_RET_STS_ERROR;

464: , p_count => x_msg_count
465: , p_data => x_msg_data
466: );
467:
468: x_return_status := FND_API.G_RET_STS_ERROR;
469: RAISE;
470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
471: FND_MSG_PUB.Count_And_Get
472: ( p_encoded => FND_API.G_FALSE

Line 470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

466: );
467:
468: x_return_status := FND_API.G_RET_STS_ERROR;
469: RAISE;
470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
471: FND_MSG_PUB.Count_And_Get
472: ( p_encoded => FND_API.G_FALSE
473: , p_count => x_msg_count
474: , p_data => x_msg_data

Line 472: ( p_encoded => FND_API.G_FALSE

468: x_return_status := FND_API.G_RET_STS_ERROR;
469: RAISE;
470: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
471: FND_MSG_PUB.Count_And_Get
472: ( p_encoded => FND_API.G_FALSE
473: , p_count => x_msg_count
474: , p_data => x_msg_data
475: );
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

472: ( p_encoded => FND_API.G_FALSE
473: , p_count => x_msg_count
474: , p_data => x_msg_data
475: );
476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
477:
478: RAISE;
479: WHEN NO_DATA_FOUND THEN
480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

476: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
477:
478: RAISE;
479: WHEN NO_DATA_FOUND THEN
480: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
481: IF (x_msg_data IS NOT NULL) THEN
482: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.reset_dim_default_value ';
483: ELSE
484: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.reset_dim_default_value ';

Line 489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

485: END IF;
486:
487: RAISE;
488: WHEN OTHERS THEN
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490: IF (x_msg_data IS NOT NULL) THEN
491: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.reset_dim_default_value ';
492: ELSE
493: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.reset_dim_default_value ';

Line 520: x_return_status := FND_API.G_RET_STS_SUCCESS;

516: l_sql VARCHAR2(1000);
517: l_bind_vars_values BSC_UPDATE_UTIL.t_array_of_varchar2;
518:
519: BEGIN
520: x_return_status := FND_API.G_RET_STS_SUCCESS;
521:
522: IF(p_dim_level_id IS NOT NULL AND p_default_value IS NOT NULL) THEN
523: SELECT level_table_name
524: INTO l_level_table_name

Line 539: WHEN FND_API.G_EXC_ERROR THEN

535: END IF;
536:
537: EXCEPTION
538:
539: WHEN FND_API.G_EXC_ERROR THEN
540: FND_MSG_PUB.Count_And_Get
541: ( p_encoded => FND_API.G_FALSE
542: , p_count => x_msg_count
543: , p_data => x_msg_data

Line 541: ( p_encoded => FND_API.G_FALSE

537: EXCEPTION
538:
539: WHEN FND_API.G_EXC_ERROR THEN
540: FND_MSG_PUB.Count_And_Get
541: ( p_encoded => FND_API.G_FALSE
542: , p_count => x_msg_count
543: , p_data => x_msg_data
544: );
545:

Line 546: x_return_status := FND_API.G_RET_STS_ERROR;

542: , p_count => x_msg_count
543: , p_data => x_msg_data
544: );
545:
546: x_return_status := FND_API.G_RET_STS_ERROR;
547: RAISE;
548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
549: FND_MSG_PUB.Count_And_Get
550: ( p_encoded => FND_API.G_FALSE

Line 548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

544: );
545:
546: x_return_status := FND_API.G_RET_STS_ERROR;
547: RAISE;
548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
549: FND_MSG_PUB.Count_And_Get
550: ( p_encoded => FND_API.G_FALSE
551: , p_count => x_msg_count
552: , p_data => x_msg_data

Line 550: ( p_encoded => FND_API.G_FALSE

546: x_return_status := FND_API.G_RET_STS_ERROR;
547: RAISE;
548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
549: FND_MSG_PUB.Count_And_Get
550: ( p_encoded => FND_API.G_FALSE
551: , p_count => x_msg_count
552: , p_data => x_msg_data
553: );
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

550: ( p_encoded => FND_API.G_FALSE
551: , p_count => x_msg_count
552: , p_data => x_msg_data
553: );
554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
555:
556: RAISE;
557: WHEN NO_DATA_FOUND THEN
558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

554: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
555:
556: RAISE;
557: WHEN NO_DATA_FOUND THEN
558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
559: IF (x_msg_data IS NOT NULL) THEN
560: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.set_dim_default_value ';
561: ELSE
562: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.set_dim_default_value ';

Line 567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

563: END IF;
564:
565: RAISE;
566: WHEN OTHERS THEN
567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
568: IF (x_msg_data IS NOT NULL) THEN
569: x_msg_data := x_msg_data||' -> BSC_COMMON_DIMENSIONS_PVT.set_dim_default_value ';
570: ELSE
571: x_msg_data := SQLERRM||' at BSC_COMMON_DIMENSIONS_PVT.set_dim_default_value ';