APPS.BSC_CUSTOM_VIEW_PVT dependencies on FND_API

Line 131: ( p_commit IN VARCHAR2 := FND_API.G_FALSE

127: /*******************************************************************************/
128:
129:
130: PROCEDURE Assign_Cust_Views
131: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
132: ,p_tab_id IN NUMBER
133: ,p_assign_views IN VARCHAR2
134: ,x_return_status OUT NOCOPY VARCHAR2
135: ,x_msg_count OUT NOCOPY NUMBER

Line 146: x_return_status := FND_API.G_RET_STS_SUCCESS;

142: l_Tab_View_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;
143: l_tab_view_id NUMBER;
144: BEGIN
145: FND_MSG_PUB.Initialize;
146: x_return_status := FND_API.G_RET_STS_SUCCESS;
147:
148: IF (p_tab_id IS NOT NULL) THEN
149:
150: -- Bug #3236356

Line 157: RAISE FND_API.G_EXC_ERROR;

153: IF(l_count =0) THEN
154: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SCORECARD_ID');
155: FND_MESSAGE.SET_TOKEN('BSC_SCORECARD', p_tab_id);
156: FND_MSG_PUB.ADD;
157: RAISE FND_API.G_EXC_ERROR;
158: END IF;
159: ELSE
160: FND_MESSAGE.SET_NAME('BSC','BSC_NO_SCORECARD_ID_ENTERED');
161: FND_MSG_PUB.ADD;

Line 162: RAISE FND_API.G_EXC_ERROR;

158: END IF;
159: ELSE
160: FND_MESSAGE.SET_NAME('BSC','BSC_NO_SCORECARD_ID_ENTERED');
161: FND_MSG_PUB.ADD;
162: RAISE FND_API.G_EXC_ERROR;
163: END IF;
164:
165: IF(p_assign_views IS NOT NULL) THEN
166: l_cust_views := p_assign_views;

Line 189: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

185: ,x_return_status => x_return_status
186: ,x_msg_count => x_msg_count
187: ,x_msg_data => x_msg_data
188: );
189: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
190: ----DBMS_OUTPUT.PUT_LINE\n('BSC_CUSTOM_VIEW_PVT.Update_default_View Failed: at BSC_CUSTOM_VIEW_PVT.Assign_Cust_Views <'||x_msg_data||'>');
191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
192: END IF;
193:

Line 191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

187: ,x_msg_data => x_msg_data
188: );
189: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
190: ----DBMS_OUTPUT.PUT_LINE\n('BSC_CUSTOM_VIEW_PVT.Update_default_View Failed: at BSC_CUSTOM_VIEW_PVT.Assign_Cust_Views <'||x_msg_data||'>');
191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
192: END IF;
193:
194: ELSE
195: l_Tab_View_Rec.Bsc_Tab_Id := p_tab_id;

Line 219: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

215: ,x_return_status => x_return_status
216: ,x_msg_count => x_msg_count
217: ,x_msg_data => x_msg_data
218: );
219: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
220: ----DBMS_OUTPUT.PUT_LINE\n('BSC_CUSTOM_VIEW_PVT.Update_Tab_View Failed: at BSC_CUSTOM_VIEW_PVT.Assign_Cust_Views <'||x_msg_data||'>');
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: END IF;
223: END IF;

Line 221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

217: ,x_msg_data => x_msg_data
218: );
219: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
220: ----DBMS_OUTPUT.PUT_LINE\n('BSC_CUSTOM_VIEW_PVT.Update_Tab_View Failed: at BSC_CUSTOM_VIEW_PVT.Assign_Cust_Views <'||x_msg_data||'>');
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: END IF;
223: END IF;
224: END IF;
225: END LOOP;

Line 229: WHEN FND_API.G_EXC_ERROR THEN

225: END LOOP;
226: END IF;
227:
228: EXCEPTION
229: WHEN FND_API.G_EXC_ERROR THEN
230: IF (x_msg_data IS NULL) THEN
231: FND_MSG_PUB.Count_And_Get
232: ( p_encoded => FND_API.G_FALSE
233: ,p_count => x_msg_count

Line 232: ( p_encoded => FND_API.G_FALSE

228: EXCEPTION
229: WHEN FND_API.G_EXC_ERROR THEN
230: IF (x_msg_data IS NULL) THEN
231: FND_MSG_PUB.Count_And_Get
232: ( p_encoded => FND_API.G_FALSE
233: ,p_count => x_msg_count
234: ,p_data => x_msg_data
235: );
236: END IF;

Line 238: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

234: ,p_data => x_msg_data
235: );
236: END IF;
237:
238: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
239: x_return_status := FND_API.G_RET_STS_ERROR;
240:
241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
242: IF (x_msg_data IS NULL) THEN

Line 239: x_return_status := FND_API.G_RET_STS_ERROR;

235: );
236: END IF;
237:
238: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
239: x_return_status := FND_API.G_RET_STS_ERROR;
240:
241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
242: IF (x_msg_data IS NULL) THEN
243: FND_MSG_PUB.Count_And_Get

Line 241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

237:
238: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
239: x_return_status := FND_API.G_RET_STS_ERROR;
240:
241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
242: IF (x_msg_data IS NULL) THEN
243: FND_MSG_PUB.Count_And_Get
244: ( p_encoded => FND_API.G_FALSE
245: , p_count => x_msg_count

Line 244: ( p_encoded => FND_API.G_FALSE

240:
241: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
242: IF (x_msg_data IS NULL) THEN
243: FND_MSG_PUB.Count_And_Get
244: ( p_encoded => FND_API.G_FALSE
245: , p_count => x_msg_count
246: , p_data => x_msg_data
247: );
248: END IF;

Line 250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

246: , p_data => x_msg_data
247: );
248: END IF;
249:
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
251: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
252:
253: WHEN NO_DATA_FOUND THEN
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 251: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

247: );
248: END IF;
249:
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
251: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
252:
253: WHEN NO_DATA_FOUND THEN
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: IF (x_msg_data IS NOT NULL) THEN

Line 254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
251: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
252:
253: WHEN NO_DATA_FOUND THEN
254: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
255: IF (x_msg_data IS NOT NULL) THEN
256: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views ';
257: ELSE
258: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views ';

Line 264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

260:
261: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION NO_DATA_FOUND '||x_msg_data);
262:
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_CUSTOM_VIEW_PVT.Unassign_Cust_Views ';
267: ELSE
268: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views ';

Line 285: ( p_commit IN VARCHAR2 := FND_API.G_FALSE

281: Created by :- ashankar 23-Oct-2003
282: /*******************************************************************************/
283:
284: PROCEDURE Unassign_Cust_Views
285: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
286: ,p_tab_id IN NUMBER
287: ,p_unassign_views IN VARCHAR2
288: ,x_return_status OUT NOCOPY VARCHAR2
289: ,x_msg_count OUT NOCOPY NUMBER

Line 301: x_return_status := FND_API.G_RET_STS_SUCCESS;

297: l_Tab_View_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;
298: l_tab_view_id NUMBER;
299: BEGIN
300: FND_MSG_PUB.Initialize;
301: x_return_status := FND_API.G_RET_STS_SUCCESS;
302:
303: IF (p_tab_id IS NOT NULL) THEN
304: -- Bug #3236356
305: l_count := get_Tab_Id_Count(p_tab_id);

Line 311: RAISE FND_API.G_EXC_ERROR;

307: IF(l_count =0) THEN
308: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SCORECARD_ID');
309: FND_MESSAGE.SET_TOKEN('BSC_SCORECARD', p_tab_id);
310: FND_MSG_PUB.ADD;
311: RAISE FND_API.G_EXC_ERROR;
312: END IF;
313: ELSE
314: FND_MESSAGE.SET_NAME('BSC','BSC_NO_SCORECARD_ID_ENTERED');
315: FND_MSG_PUB.ADD;

Line 316: RAISE FND_API.G_EXC_ERROR;

312: END IF;
313: ELSE
314: FND_MESSAGE.SET_NAME('BSC','BSC_NO_SCORECARD_ID_ENTERED');
315: FND_MSG_PUB.ADD;
316: RAISE FND_API.G_EXC_ERROR;
317: END IF;
318:
319: IF(p_unassign_views IS NOT NULL) THEN
320: l_cust_Views := p_unassign_views;

Line 345: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

341: ,x_return_status => x_return_status
342: ,x_msg_count => x_msg_count
343: ,x_msg_data => x_msg_data
344: );
345: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
346: ----DBMS_OUTPUT.PUT_LINE\n('BSC_CUSTOM_VIEW_PVT.Update_default_View Failed: at BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views <'||x_msg_data||'>');
347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
348: END IF;
349:

Line 347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

343: ,x_msg_data => x_msg_data
344: );
345: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
346: ----DBMS_OUTPUT.PUT_LINE\n('BSC_CUSTOM_VIEW_PVT.Update_default_View Failed: at BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views <'||x_msg_data||'>');
347: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
348: END IF;
349:
350: ELSE
351:

Line 396: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

392: ,x_return_status => x_return_status
393: ,x_msg_count => x_msg_count
394: ,x_msg_data => x_msg_data
395: );
396: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
397: ----DBMS_OUTPUT.PUT_LINE\n('BSC_CUSTOM_VIEW_PVT.Update_Tab_View Failed: at BSC_CUSTOM_VIEW_PVT.Create_Tab_View <'||x_msg_data||'>');
398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
399: END IF;
400: END IF;

Line 398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

394: ,x_msg_data => x_msg_data
395: );
396: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
397: ----DBMS_OUTPUT.PUT_LINE\n('BSC_CUSTOM_VIEW_PVT.Update_Tab_View Failed: at BSC_CUSTOM_VIEW_PVT.Create_Tab_View <'||x_msg_data||'>');
398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
399: END IF;
400: END IF;
401: END IF;
402:

Line 410: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

406: ,x_return_status => x_return_status
407: ,x_msg_count => x_msg_count
408: ,x_msg_data => x_msg_data
409: );
410: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
411: ----DBMS_OUTPUT.PUT_LINE\n('BSC_CUSTOM_VIEW_PVT.Update_Tab_View Failed: at BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views <'||x_msg_data||'>');
412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
413: END IF;
414: END IF;

Line 412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

408: ,x_msg_data => x_msg_data
409: );
410: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
411: ----DBMS_OUTPUT.PUT_LINE\n('BSC_CUSTOM_VIEW_PVT.Update_Tab_View Failed: at BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views <'||x_msg_data||'>');
412: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
413: END IF;
414: END IF;
415: END LOOP;
416: END IF;

Line 419: WHEN FND_API.G_EXC_ERROR THEN

415: END LOOP;
416: END IF;
417:
418: EXCEPTION
419: WHEN FND_API.G_EXC_ERROR THEN
420: IF (x_msg_data IS NULL) THEN
421: FND_MSG_PUB.Count_And_Get
422: ( p_encoded => FND_API.G_FALSE
423: , p_count => x_msg_count

Line 422: ( p_encoded => FND_API.G_FALSE

418: EXCEPTION
419: WHEN FND_API.G_EXC_ERROR THEN
420: IF (x_msg_data IS NULL) THEN
421: FND_MSG_PUB.Count_And_Get
422: ( p_encoded => FND_API.G_FALSE
423: , p_count => x_msg_count
424: , p_data => x_msg_data
425: );
426: END IF;

Line 428: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

424: , p_data => x_msg_data
425: );
426: END IF;
427:
428: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
429: x_return_status := FND_API.G_RET_STS_ERROR;
430:
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
432: IF (x_msg_data IS NULL) THEN

Line 429: x_return_status := FND_API.G_RET_STS_ERROR;

425: );
426: END IF;
427:
428: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
429: x_return_status := FND_API.G_RET_STS_ERROR;
430:
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
432: IF (x_msg_data IS NULL) THEN
433: FND_MSG_PUB.Count_And_Get

Line 431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

427:
428: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
429: x_return_status := FND_API.G_RET_STS_ERROR;
430:
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
432: IF (x_msg_data IS NULL) THEN
433: FND_MSG_PUB.Count_And_Get
434: ( p_encoded => FND_API.G_FALSE
435: , p_count => x_msg_count

Line 434: ( p_encoded => FND_API.G_FALSE

430:
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
432: IF (x_msg_data IS NULL) THEN
433: FND_MSG_PUB.Count_And_Get
434: ( p_encoded => FND_API.G_FALSE
435: , p_count => x_msg_count
436: , p_data => x_msg_data
437: );
438: END IF;

Line 439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

435: , p_count => x_msg_count
436: , p_data => x_msg_data
437: );
438: END IF;
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
440: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
441:
442: WHEN NO_DATA_FOUND THEN
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 440: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

436: , p_data => x_msg_data
437: );
438: END IF;
439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
440: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
441:
442: WHEN NO_DATA_FOUND THEN
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: IF (x_msg_data IS NOT NULL) THEN

Line 443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
440: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
441:
442: WHEN NO_DATA_FOUND THEN
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: IF (x_msg_data IS NOT NULL) THEN
445: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views ';
446: ELSE
447: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views ';

Line 452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

448: END IF;
449: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION NO_DATA_FOUND '||x_msg_data);
450:
451: WHEN OTHERS THEN
452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
453: IF (x_msg_data IS NOT NULL) THEN
454: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views ';
455: ELSE
456: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views ';

Line 481: p_commit IN VARCHAR2 := FND_API.G_FALSE

477: /******************************************************************************************/
478:
479:
480: PROCEDURE Assign_Unassign_Views(
481: p_commit IN VARCHAR2 := FND_API.G_FALSE
482: ,p_tab_id IN NUMBER
483: ,p_default_value IN NUMBER
484: ,p_assign_views IN VARCHAR2
485: ,p_unassign_views IN VARCHAR2

Line 495: x_return_status := FND_API.G_RET_STS_SUCCESS;

491: l_Tab_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type;
492: l_Tab_View_Rec BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type;
493: BEGIN
494: FND_MSG_PUB.Initialize;
495: x_return_status := FND_API.G_RET_STS_SUCCESS;
496:
497: IF (p_tab_id IS NULL) THEN
498: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SCORECARD_ID');
499: FND_MESSAGE.SET_TOKEN('BSC_SCORECARD', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'TAB_ID'), TRUE);

Line 501: RAISE FND_API.G_EXC_ERROR;

497: IF (p_tab_id IS NULL) THEN
498: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SCORECARD_ID');
499: FND_MESSAGE.SET_TOKEN('BSC_SCORECARD', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'TAB_ID'), TRUE);
500: FND_MSG_PUB.ADD;
501: RAISE FND_API.G_EXC_ERROR;
502: END IF;
503:
504: IF (p_default_value IS NULL) THEN
505: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DEFAULT_ID');

Line 508: RAISE FND_API.G_EXC_ERROR;

504: IF (p_default_value IS NULL) THEN
505: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DEFAULT_ID');
506: FND_MESSAGE.SET_TOKEN('BSC_DEF_ID', BSC_APPS.Get_Lookup_Value('BSC_UI_COMMON', 'DEFAULT_TAB_ID'), TRUE);
507: FND_MSG_PUB.ADD;
508: RAISE FND_API.G_EXC_ERROR;
509: END IF;
510:
511: -- call the unassign first and then assign the views APIS.
512:

Line 521: ( p_commit => FND_API.G_FALSE

517:
518: IF (p_unassign_views IS NOT NULL) THEN
519:
520: BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views
521: ( p_commit => FND_API.G_FALSE
522: ,p_tab_id => p_tab_id
523: ,p_unassign_views => p_unassign_views
524: ,x_return_status => x_return_status
525: ,x_msg_count => x_msg_count

Line 529: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

525: ,x_msg_count => x_msg_count
526: ,x_msg_data => x_msg_data
527: );
528:
529: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
530: ----DBMS_OUTPUT.PUT_LINE\n('BSC_CUSTOM_VIEW_PVT.Assign_Unassign_Views Failed: at BSC_CUSTOM_VIEW_PVT.Assign_Unassign_Views');
531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
532: END IF;
533: END IF;

Line 531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

527: );
528:
529: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
530: ----DBMS_OUTPUT.PUT_LINE\n('BSC_CUSTOM_VIEW_PVT.Assign_Unassign_Views Failed: at BSC_CUSTOM_VIEW_PVT.Assign_Unassign_Views');
531: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
532: END IF;
533: END IF;
534:
535: --DBMS_OUTPUT.PUT_LINE\n('aFTER SC_CUSTOM_VIEW_PVT.Unassign_Cust_Views');

Line 541: ( p_commit => FND_API.G_FALSE

537:
538: IF (p_assign_views IS NOT NULL) THEN
539:
540: BSC_CUSTOM_VIEW_PVT.Assign_Cust_Views
541: ( p_commit => FND_API.G_FALSE
542: ,p_tab_id => p_tab_id
543: ,p_assign_views => p_assign_views
544: ,x_return_status => x_return_status
545: ,x_msg_count => x_msg_count

Line 549: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

545: ,x_msg_count => x_msg_count
546: ,x_msg_data => x_msg_data
547: );
548:
549: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
550: ----DBMS_OUTPUT.PUT_LINE\n('BSC_CUSTOM_VIEW_PVT.Assign_Cust_Views Failed: at BSC_CUSTOM_VIEW_PVT.Assign_Cust_Views');
551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
552: END IF;
553: END IF;

Line 551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

547: );
548:
549: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
550: ----DBMS_OUTPUT.PUT_LINE\n('BSC_CUSTOM_VIEW_PVT.Assign_Cust_Views Failed: at BSC_CUSTOM_VIEW_PVT.Assign_Cust_Views');
551: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
552: END IF;
553: END IF;
554: --DBMS_OUTPUT.PUT_LINE\n('aFTER SC_CUSTOM_VIEW_PVT.Assign_Cust_Views');
555:

Line 586: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

582: ,x_return_status => x_return_status
583: ,x_msg_count => x_msg_count
584: ,x_msg_data => x_msg_data
585: );
586: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
587: ----DBMS_OUTPUT.PUT_LINE\n('BSC_CUSTOM_VIEW_PVT.Update_Tab_View Failed: at BSC_CUSTOM_VIEW_PVT.Create_Tab_View <'||x_msg_data||'>');
588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
589: END IF;
590: END IF;

Line 588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

584: ,x_msg_data => x_msg_data
585: );
586: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
587: ----DBMS_OUTPUT.PUT_LINE\n('BSC_CUSTOM_VIEW_PVT.Update_Tab_View Failed: at BSC_CUSTOM_VIEW_PVT.Create_Tab_View <'||x_msg_data||'>');
588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
589: END IF;
590: END IF;
591: END IF;
592:

Line 602: RAISE FND_API.G_EXC_ERROR;

598:
599: IF(l_count=0) THEN
600: FND_MESSAGE.SET_NAME('BSC','BSC_NOTSET_DEFAULT_ID');
601: FND_MSG_PUB.ADD;
602: RAISE FND_API.G_EXC_ERROR;
603: END IF;
604:
605: l_Tab_Rec.Bsc_Tab_Id := p_tab_id;
606: l_Tab_Rec.Bsc_Default_Model := p_default_value;

Line 619: WHEN FND_API.G_EXC_ERROR THEN

615: );
616:
617:
618: EXCEPTION
619: WHEN FND_API.G_EXC_ERROR THEN
620: IF (x_msg_data IS NULL) THEN
621: FND_MSG_PUB.Count_And_Get
622: ( p_encoded => FND_API.G_FALSE
623: , p_count => x_msg_count

Line 622: ( p_encoded => FND_API.G_FALSE

618: EXCEPTION
619: WHEN FND_API.G_EXC_ERROR THEN
620: IF (x_msg_data IS NULL) THEN
621: FND_MSG_PUB.Count_And_Get
622: ( p_encoded => FND_API.G_FALSE
623: , p_count => x_msg_count
624: , p_data => x_msg_data
625: );
626: END IF;

Line 628: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

624: , p_data => x_msg_data
625: );
626: END IF;
627:
628: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
629: x_return_status := FND_API.G_RET_STS_ERROR;
630:
631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
632: IF (x_msg_data IS NULL) THEN

Line 629: x_return_status := FND_API.G_RET_STS_ERROR;

625: );
626: END IF;
627:
628: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
629: x_return_status := FND_API.G_RET_STS_ERROR;
630:
631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
632: IF (x_msg_data IS NULL) THEN
633: FND_MSG_PUB.Count_And_Get

Line 631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

627:
628: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
629: x_return_status := FND_API.G_RET_STS_ERROR;
630:
631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
632: IF (x_msg_data IS NULL) THEN
633: FND_MSG_PUB.Count_And_Get
634: ( p_encoded => FND_API.G_FALSE
635: , p_count => x_msg_count

Line 634: ( p_encoded => FND_API.G_FALSE

630:
631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
632: IF (x_msg_data IS NULL) THEN
633: FND_MSG_PUB.Count_And_Get
634: ( p_encoded => FND_API.G_FALSE
635: , p_count => x_msg_count
636: , p_data => x_msg_data
637: );
638: END IF;

Line 639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

635: , p_count => x_msg_count
636: , p_data => x_msg_data
637: );
638: END IF;
639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
640: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
641:
642: WHEN NO_DATA_FOUND THEN
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 640: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

636: , p_data => x_msg_data
637: );
638: END IF;
639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
640: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
641:
642: WHEN NO_DATA_FOUND THEN
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: IF (x_msg_data IS NOT NULL) THEN

Line 643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

639: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
640: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
641:
642: WHEN NO_DATA_FOUND THEN
643: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
644: IF (x_msg_data IS NOT NULL) THEN
645: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views ';
646: ELSE
647: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views ';

Line 652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

648: END IF;
649: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION NO_DATA_FOUND '||x_msg_data);
650:
651: WHEN OTHERS THEN
652: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
653: IF (x_msg_data IS NOT NULL) THEN
654: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views ';
655: ELSE
656: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views ';

Line 668: p_commit IN VARCHAR2 := FND_API.G_FALSE

664: /******************************************************************************************/
665:
666: PROCEDURE Create_Tab_View
667: (
668: p_commit IN VARCHAR2 := FND_API.G_FALSE
669: ,p_Tab_View_Rec IN BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type
670: ,x_return_status OUT NOCOPY VARCHAR2
671: ,x_msg_count OUT NOCOPY NUMBER
672: ,x_msg_data OUT NOCOPY VARCHAR2

Line 679: x_return_status := FND_API.G_RET_STS_SUCCESS;

675: l_count NUMBER;
676: BEGIN
677: SAVEPOINT CreateTabView;
678: FND_MSG_PUB.Initialize;
679: x_return_status := FND_API.G_RET_STS_SUCCESS;
680:
681: l_Tab_View_Rec := p_Tab_View_Rec;
682:
683: IF (l_Tab_View_Rec.Bsc_Tab_Id IS NOT NULL) THEN

Line 691: RAISE FND_API.G_EXC_ERROR;

687: IF(l_count =0) THEN
688: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SCORECARD_ID');
689: FND_MESSAGE.SET_TOKEN('BSC_SCORECARD', l_Tab_View_Rec.Bsc_Tab_Id);
690: FND_MSG_PUB.ADD;
691: RAISE FND_API.G_EXC_ERROR;
692: END IF;
693: ELSE
694: FND_MESSAGE.SET_NAME('BSC','BSC_NO_SCORECARD_ID_ENTERED');
695: FND_MSG_PUB.ADD;

Line 696: RAISE FND_API.G_EXC_ERROR;

692: END IF;
693: ELSE
694: FND_MESSAGE.SET_NAME('BSC','BSC_NO_SCORECARD_ID_ENTERED');
695: FND_MSG_PUB.ADD;
696: RAISE FND_API.G_EXC_ERROR;
697: END IF;
698:
699:
700: INSERT INTO BSC_TAB_VIEWS_B

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

750: AND T.tab_view_id = l_Tab_View_Rec.Bsc_Tab_View_Id
751: AND T.LANGUAGE = L.LANGUAGE_CODE);
752:
753:
754: IF (p_commit =FND_API.G_TRUE) THEN
755: commit;
756: END IF;
757:
758: EXCEPTION

Line 759: WHEN FND_API.G_EXC_ERROR THEN

755: commit;
756: END IF;
757:
758: EXCEPTION
759: WHEN FND_API.G_EXC_ERROR THEN
760: ROLLBACK TO CreateTabView;
761: x_return_status := FND_API.G_RET_STS_ERROR;
762: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
763: ,p_data => x_msg_data);

Line 761: x_return_status := FND_API.G_RET_STS_ERROR;

757:
758: EXCEPTION
759: WHEN FND_API.G_EXC_ERROR THEN
760: ROLLBACK TO CreateTabView;
761: x_return_status := FND_API.G_RET_STS_ERROR;
762: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
763: ,p_data => x_msg_data);
764: RAISE;
765:

Line 766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

762: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
763: ,p_data => x_msg_data);
764: RAISE;
765:
766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
767: ROLLBACK TO CreateTabView;
768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
769: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
770: ,p_data => x_msg_data);

Line 768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

764: RAISE;
765:
766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
767: ROLLBACK TO CreateTabView;
768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
769: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
770: ,p_data => x_msg_data);
771: RAISE;
772:

Line 775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

771: RAISE;
772:
773: WHEN NO_DATA_FOUND THEN
774: ROLLBACK TO CreateTabView;
775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
776: IF (x_msg_data IS NOT NULL) THEN
777: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Retrieve_Tab';
778: ELSE
779: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Retrieve_Tab';

Line 784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

780: END IF;
781: RAISE;
782: WHEN OTHERS THEN
783: ROLLBACK TO CreateTabView;
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
785: IF (x_msg_data IS NOT NULL) THEN
786: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Create_Tab_View';
787: ELSE
788: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Create_Tab_View';

Line 809: x_return_status := FND_API.G_RET_STS_SUCCESS;

805: ,x_msg_data OUT NOCOPY VARCHAR2
806: ) IS
807: BEGIN
808: FND_MSG_PUB.Initialize;
809: x_return_status := FND_API.G_RET_STS_SUCCESS;
810:
811: SELECT a.tab_id
812: ,a.kpi_model
813: ,a.bsc_model

Line 845: WHEN FND_API.G_EXC_ERROR THEN

841: FROM BSC_TABS_B a
842: WHERE a.tab_id = p_Tab_Rec.Bsc_Tab_Id;
843:
844: EXCEPTION
845: WHEN FND_API.G_EXC_ERROR THEN
846: x_return_status := FND_API.G_RET_STS_ERROR;
847: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
848: ,p_data => x_msg_data);
849: RAISE;

Line 846: x_return_status := FND_API.G_RET_STS_ERROR;

842: WHERE a.tab_id = p_Tab_Rec.Bsc_Tab_Id;
843:
844: EXCEPTION
845: WHEN FND_API.G_EXC_ERROR THEN
846: x_return_status := FND_API.G_RET_STS_ERROR;
847: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
848: ,p_data => x_msg_data);
849: RAISE;
850: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 850: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

846: x_return_status := FND_API.G_RET_STS_ERROR;
847: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
848: ,p_data => x_msg_data);
849: RAISE;
850: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
852: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
853: ,p_data => x_msg_data);
854: RAISE;

Line 851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

847: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
848: ,p_data => x_msg_data);
849: RAISE;
850: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
852: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
853: ,p_data => x_msg_data);
854: RAISE;
855: WHEN NO_DATA_FOUND THEN

Line 856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

852: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
853: ,p_data => x_msg_data);
854: RAISE;
855: WHEN NO_DATA_FOUND THEN
856: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
857: IF (x_msg_data IS NOT NULL) THEN
858: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Retrieve_Tab ';
859: ELSE
860: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Retrieve_Tab ';

Line 864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

860: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Retrieve_Tab ';
861: END IF;
862: RAISE;
863: WHEN OTHERS THEN
864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
865: IF (x_msg_data IS NOT NULL) THEN
866: x_msg_data := x_msg_data||' -> BSC_BIS_KPI_MEAS_PUB.Update_Dim_Set ';
867: ELSE
868: x_msg_data := SQLERRM||' at BSC_BIS_KPI_MEAS_PUB.Update_Dim_Set ';

Line 889: x_return_status := FND_API.G_RET_STS_SUCCESS;

885: ,x_msg_data OUT NOCOPY VARCHAR2
886: )IS
887: BEGIN
888: FND_MSG_PUB.Initialize;
889: x_return_status := FND_API.G_RET_STS_SUCCESS;
890:
891: ----DBMS_OUTPUT.PUT_LINE\n('p_Tab_View_Rec.Bsc_Tab_Id --->' || p_Tab_View_Rec.Bsc_Tab_Id);
892: ----DBMS_OUTPUT.PUT_LINE\n('p_Tab_View_Rec.Bsc_Tab_View_Id --->' || p_Tab_View_Rec.Bsc_Tab_View_Id);
893:

Line 915: WHEN FND_API.G_EXC_ERROR THEN

911: WHERE tab_id = p_Tab_View_Rec.Bsc_Tab_Id
912: AND tab_view_id =p_Tab_View_Rec.Bsc_Tab_View_Id;
913:
914: EXCEPTION
915: WHEN FND_API.G_EXC_ERROR THEN
916: x_return_status := FND_API.G_RET_STS_ERROR;
917: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
918: ,p_data => x_msg_data);
919: RAISE;

Line 916: x_return_status := FND_API.G_RET_STS_ERROR;

912: AND tab_view_id =p_Tab_View_Rec.Bsc_Tab_View_Id;
913:
914: EXCEPTION
915: WHEN FND_API.G_EXC_ERROR THEN
916: x_return_status := FND_API.G_RET_STS_ERROR;
917: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
918: ,p_data => x_msg_data);
919: RAISE;
920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

916: x_return_status := FND_API.G_RET_STS_ERROR;
917: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
918: ,p_data => x_msg_data);
919: RAISE;
920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
922: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
923: ,p_data => x_msg_data);
924: RAISE;

Line 921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

917: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
918: ,p_data => x_msg_data);
919: RAISE;
920: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
922: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
923: ,p_data => x_msg_data);
924: RAISE;
925: WHEN NO_DATA_FOUND THEN

Line 927: ----DBMS_OUTPUT.PUT_LINE\n('p_Tab_View_Rec.Bsc_Tab_View_Id --->' || p_Tab_View_Rec.Bsc_Tab_View_Id);x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

923: ,p_data => x_msg_data);
924: RAISE;
925: WHEN NO_DATA_FOUND THEN
926: ----DBMS_OUTPUT.PUT_LINE\n('insdei exception p_Tab_View_Rec.Bsc_Tab_Id --->' || p_Tab_View_Rec.Bsc_Tab_Id);
927: ----DBMS_OUTPUT.PUT_LINE\n('p_Tab_View_Rec.Bsc_Tab_View_Id --->' || p_Tab_View_Rec.Bsc_Tab_View_Id);x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
928: IF (x_msg_data IS NOT NULL) THEN
929: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Retrieve_Tab_View ';
930: ELSE
931: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Retrieve_Tab_View ';

Line 935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

931: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Retrieve_Tab_View ';
932: END IF;
933: RAISE;
934: WHEN OTHERS THEN
935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
936: IF (x_msg_data IS NOT NULL) THEN
937: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Retrieve_Tab_View ';
938: ELSE
939: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Retrieve_Tab_View ';

Line 953: ( p_commit IN VARCHAR2 := FND_API.G_FALSE

949: Ouput :- Updates the BSC_TABS_B
950: Created By :- ashankar 23-Oct-2003
951: /******************************************************************************************/
952: PROCEDURE Update_Tab_View
953: ( p_commit IN VARCHAR2 := FND_API.G_FALSE
954: ,p_Tab_View_Rec IN BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type
955: ,x_return_status OUT NOCOPY VARCHAR2
956: ,x_msg_count OUT NOCOPY NUMBER
957: ,x_msg_data OUT NOCOPY VARCHAR2

Line 967: x_return_status := FND_API.G_RET_STS_SUCCESS;

963:
964: BEGIN
965: SAVEPOINT UpdateTabView;
966: FND_MSG_PUB.Initialize;
967: x_return_status := FND_API.G_RET_STS_SUCCESS;
968:
969: l_Tab_View_Rec.Bsc_Tab_Id := p_Tab_View_Rec.Bsc_Tab_Id;
970:
971: IF(l_Tab_View_Rec.Bsc_Tab_Id IS NOT NULL) THEN

Line 979: RAISE FND_API.G_EXC_ERROR;

975: IF(l_count =0) THEN
976: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SCORECARD_ID');
977: FND_MESSAGE.SET_TOKEN('BSC_SCORECARD', l_Tab_View_Rec.Bsc_Tab_Id);
978: FND_MSG_PUB.ADD;
979: RAISE FND_API.G_EXC_ERROR;
980: END IF;
981:
982: ELSE
983:

Line 986: RAISE FND_API.G_EXC_ERROR;

982: ELSE
983:
984: FND_MESSAGE.SET_NAME('BSC','BSC_NO_SCORECARD_ID_ENTERED');
985: FND_MSG_PUB.ADD;
986: RAISE FND_API.G_EXC_ERROR;
987:
988: END IF;
989:
990: l_Tab_View_Rec.Bsc_Tab_View_Id := p_Tab_View_Rec.Bsc_Tab_View_Id;

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

1035: ,Last_Update_Login=l_Tab_View_Out_Rec.Bsc_Last_Update_Login
1036: WHERE tab_id =l_Tab_View_Rec.Bsc_Tab_Id
1037: AND tab_view_id = l_Tab_View_Rec.Bsc_Tab_View_Id;
1038:
1039: IF (p_commit = FND_API.G_TRUE) THEN
1040: commit;
1041: END IF;
1042:
1043: EXCEPTION

Line 1045: WHEN FND_API.G_EXC_ERROR THEN

1041: END IF;
1042:
1043: EXCEPTION
1044:
1045: WHEN FND_API.G_EXC_ERROR THEN
1046: ROLLBACK TO UpdateTabView;
1047: IF (x_msg_data IS NULL) THEN
1048: FND_MSG_PUB.Count_And_Get
1049: ( p_encoded => FND_API.G_FALSE

Line 1049: ( p_encoded => FND_API.G_FALSE

1045: WHEN FND_API.G_EXC_ERROR THEN
1046: ROLLBACK TO UpdateTabView;
1047: IF (x_msg_data IS NULL) THEN
1048: FND_MSG_PUB.Count_And_Get
1049: ( p_encoded => FND_API.G_FALSE
1050: , p_count => x_msg_count
1051: , p_data => x_msg_data
1052: );
1053: END IF;

Line 1054: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

1050: , p_count => x_msg_count
1051: , p_data => x_msg_data
1052: );
1053: END IF;
1054: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1055: x_return_status := FND_API.G_RET_STS_ERROR;
1056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1057: ROLLBACK TO UpdateTabView;
1058: IF (x_msg_data IS NULL) THEN

Line 1055: x_return_status := FND_API.G_RET_STS_ERROR;

1051: , p_data => x_msg_data
1052: );
1053: END IF;
1054: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1055: x_return_status := FND_API.G_RET_STS_ERROR;
1056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1057: ROLLBACK TO UpdateTabView;
1058: IF (x_msg_data IS NULL) THEN
1059: FND_MSG_PUB.Count_And_Get

Line 1056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1052: );
1053: END IF;
1054: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1055: x_return_status := FND_API.G_RET_STS_ERROR;
1056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1057: ROLLBACK TO UpdateTabView;
1058: IF (x_msg_data IS NULL) THEN
1059: FND_MSG_PUB.Count_And_Get
1060: ( p_encoded => FND_API.G_FALSE

Line 1060: ( p_encoded => FND_API.G_FALSE

1056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1057: ROLLBACK TO UpdateTabView;
1058: IF (x_msg_data IS NULL) THEN
1059: FND_MSG_PUB.Count_And_Get
1060: ( p_encoded => FND_API.G_FALSE
1061: , p_count => x_msg_count
1062: , p_data => x_msg_data
1063: );
1064: END IF;

Line 1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1061: , p_count => x_msg_count
1062: , p_data => x_msg_data
1063: );
1064: END IF;
1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1066: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1067: WHEN NO_DATA_FOUND THEN
1068: ROLLBACK TO UpdateTabView;
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1066: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

1062: , p_data => x_msg_data
1063: );
1064: END IF;
1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1066: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1067: WHEN NO_DATA_FOUND THEN
1068: ROLLBACK TO UpdateTabView;
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1070: IF (x_msg_data IS NOT NULL) THEN

Line 1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1066: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1067: WHEN NO_DATA_FOUND THEN
1068: ROLLBACK TO UpdateTabView;
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1070: IF (x_msg_data IS NOT NULL) THEN
1071: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Update_Tab_View ';
1072: ELSE
1073: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Update_Tab_View ';

Line 1078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1074: END IF;
1075: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1076: WHEN OTHERS THEN
1077: ROLLBACK TO UpdateTabView;
1078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1079: IF (x_msg_data IS NOT NULL) THEN
1080: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Update_Tab_View ';
1081: ELSE
1082: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Update_Tab_View ';

Line 1096: p_commit IN VARCHAR2 := FND_API.G_FALSE

1092:
1093:
1094: PROCEDURE Update_Tab_default_View
1095: (
1096: p_commit IN VARCHAR2 := FND_API.G_FALSE
1097: ,p_Tab_Rec IN BSC_CUSTOM_VIEW_PUB.Bsc_Tab_Rec_Type
1098: ,x_return_status OUT NOCOPY VARCHAR2
1099: ,x_msg_count OUT NOCOPY NUMBER
1100: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1111: x_return_status := FND_API.G_RET_STS_SUCCESS;

1107:
1108: BEGIN
1109: SAVEPOINT UpdateTabdefaultView;
1110: FND_MSG_PUB.Initialize;
1111: x_return_status := FND_API.G_RET_STS_SUCCESS;
1112:
1113: l_Tab_Rec.Bsc_Tab_Id := p_Tab_Rec.Bsc_Tab_Id;
1114:
1115: IF(l_Tab_Rec.Bsc_Tab_Id IS NOT NULL) THEN

Line 1124: RAISE FND_API.G_EXC_ERROR;

1120: IF(l_count =0) THEN
1121: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SCORECARD_ID');
1122: FND_MESSAGE.SET_TOKEN('BSC_SCORECARD', l_Tab_Rec.Bsc_Tab_Id);
1123: FND_MSG_PUB.ADD;
1124: RAISE FND_API.G_EXC_ERROR;
1125: END IF;
1126:
1127: ELSE
1128:

Line 1131: RAISE FND_API.G_EXC_ERROR;

1127: ELSE
1128:
1129: FND_MESSAGE.SET_NAME('BSC','BSC_NO_SCORECARD_ID_ENTERED');
1130: FND_MSG_PUB.ADD;
1131: RAISE FND_API.G_EXC_ERROR;
1132:
1133: END IF;
1134:
1135: Retrieve_Tab

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

1214: ,Owner_Id=l_Tab_Ret_Rec.Bsc_Owner_Id
1215: ,Short_Name=l_Tab_Ret_Rec.Bsc_Short_Name
1216: WHERE Tab_Id = l_Tab_Ret_Rec.Bsc_Tab_Id;
1217:
1218: IF (p_commit = FND_API.G_TRUE) THEN
1219: commit;
1220: END IF;
1221:
1222: EXCEPTION

Line 1224: WHEN FND_API.G_EXC_ERROR THEN

1220: END IF;
1221:
1222: EXCEPTION
1223:
1224: WHEN FND_API.G_EXC_ERROR THEN
1225: ROLLBACK TO UpdateTabdefaultView;
1226: IF (x_msg_data IS NULL) THEN
1227: FND_MSG_PUB.Count_And_Get
1228: ( p_encoded => FND_API.G_FALSE

Line 1228: ( p_encoded => FND_API.G_FALSE

1224: WHEN FND_API.G_EXC_ERROR THEN
1225: ROLLBACK TO UpdateTabdefaultView;
1226: IF (x_msg_data IS NULL) THEN
1227: FND_MSG_PUB.Count_And_Get
1228: ( p_encoded => FND_API.G_FALSE
1229: , p_count => x_msg_count
1230: , p_data => x_msg_data
1231: );
1232: END IF;

Line 1233: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

1229: , p_count => x_msg_count
1230: , p_data => x_msg_data
1231: );
1232: END IF;
1233: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1234: x_return_status := FND_API.G_RET_STS_ERROR;
1235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1236: ROLLBACK TO UpdateTabdefaultView;
1237: IF (x_msg_data IS NULL) THEN

Line 1234: x_return_status := FND_API.G_RET_STS_ERROR;

1230: , p_data => x_msg_data
1231: );
1232: END IF;
1233: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1234: x_return_status := FND_API.G_RET_STS_ERROR;
1235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1236: ROLLBACK TO UpdateTabdefaultView;
1237: IF (x_msg_data IS NULL) THEN
1238: FND_MSG_PUB.Count_And_Get

Line 1235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1231: );
1232: END IF;
1233: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1234: x_return_status := FND_API.G_RET_STS_ERROR;
1235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1236: ROLLBACK TO UpdateTabdefaultView;
1237: IF (x_msg_data IS NULL) THEN
1238: FND_MSG_PUB.Count_And_Get
1239: ( p_encoded => FND_API.G_FALSE

Line 1239: ( p_encoded => FND_API.G_FALSE

1235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1236: ROLLBACK TO UpdateTabdefaultView;
1237: IF (x_msg_data IS NULL) THEN
1238: FND_MSG_PUB.Count_And_Get
1239: ( p_encoded => FND_API.G_FALSE
1240: , p_count => x_msg_count
1241: , p_data => x_msg_data
1242: );
1243: END IF;

Line 1244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1240: , p_count => x_msg_count
1241: , p_data => x_msg_data
1242: );
1243: END IF;
1244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1245: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1246: WHEN NO_DATA_FOUND THEN
1247: ROLLBACK TO UpdateTabdefaultView;
1248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1245: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

1241: , p_data => x_msg_data
1242: );
1243: END IF;
1244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1245: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1246: WHEN NO_DATA_FOUND THEN
1247: ROLLBACK TO UpdateTabdefaultView;
1248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1249: IF (x_msg_data IS NOT NULL) THEN

Line 1248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1245: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1246: WHEN NO_DATA_FOUND THEN
1247: ROLLBACK TO UpdateTabdefaultView;
1248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1249: IF (x_msg_data IS NOT NULL) THEN
1250: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Update_Tab_default_View ';
1251: ELSE
1252: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Update_Tab_default_View ';

Line 1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1253: END IF;
1254: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1255: WHEN OTHERS THEN
1256: ROLLBACK TO UpdateTabdefaultView;
1257: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1258: IF (x_msg_data IS NOT NULL) THEN
1259: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Update_Tab_default_View ';
1260: ELSE
1261: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Update_Tab_default_View ';

Line 1317: p_commit IN VARCHAR2 := FND_API.G_FALSE

1313: Creator/Modified by :- ashankar 10-NOV-2003
1314: /******************************************************************************/
1315: PROCEDURE delete_Custom_View
1316: (
1317: p_commit IN VARCHAR2 := FND_API.G_FALSE
1318: ,p_CustView_Rec IN BSC_CUSTOM_VIEW_PUB.Bsc_Cust_View_Rec_Type
1319: ,x_return_status OUT NOCOPY VARCHAR2
1320: ,x_msg_count OUT NOCOPY NUMBER
1321: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1353: RAISE FND_API.G_EXC_ERROR;

1349: IF(l_count =0) THEN
1350: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SCORECARD_ID');
1351: FND_MESSAGE.SET_TOKEN('BSC_SCORECARD', l_CustView_Rec.Bsc_Tab_Id);
1352: FND_MSG_PUB.ADD;
1353: RAISE FND_API.G_EXC_ERROR;
1354: END IF;
1355:
1356: ELSE
1357:

Line 1360: RAISE FND_API.G_EXC_ERROR;

1356: ELSE
1357:
1358: FND_MESSAGE.SET_NAME('BSC','BSC_NO_SCORECARD_ID_ENTERED');
1359: FND_MSG_PUB.ADD;
1360: RAISE FND_API.G_EXC_ERROR;
1361:
1362: END IF;
1363:
1364: IF((l_CustView_Rec.Bsc_Tab_Id IS NOT NULL) AND (l_CustView_Rec.Bsc_Tab_View_Id IS NOT NULL)) THEN

Line 1376: RAISE FND_API.G_EXC_ERROR;

1372: IF (l_count =0) THEN
1373: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SCORECARD_ID');
1374: FND_MESSAGE.SET_TOKEN('BSC_SCORECARD', l_CustView_Rec.Bsc_Tab_Id);
1375: FND_MSG_PUB.ADD;
1376: RAISE FND_API.G_EXC_ERROR;
1377: END IF;
1378:
1379: -- Before deleting the custom view check if it was the default view with the scorecard.
1380: -- if yes then set the default view to scorecard view and then delete the custom view.

Line 1475: WHEN FND_API.G_EXC_ERROR THEN

1471: END LOOP;
1472: END IF;
1473:
1474: EXCEPTION
1475: WHEN FND_API.G_EXC_ERROR THEN
1476: ROLLBACK TO deleteCustomView;
1477: IF (x_msg_data IS NULL) THEN
1478: FND_MSG_PUB.Count_And_Get
1479: ( p_encoded => FND_API.G_FALSE

Line 1479: ( p_encoded => FND_API.G_FALSE

1475: WHEN FND_API.G_EXC_ERROR THEN
1476: ROLLBACK TO deleteCustomView;
1477: IF (x_msg_data IS NULL) THEN
1478: FND_MSG_PUB.Count_And_Get
1479: ( p_encoded => FND_API.G_FALSE
1480: , p_count => x_msg_count
1481: , p_data => x_msg_data
1482: );
1483: END IF;

Line 1485: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

1481: , p_data => x_msg_data
1482: );
1483: END IF;
1484:
1485: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1486: x_return_status := FND_API.G_RET_STS_ERROR;
1487:
1488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1489: ROLLBACK TO deleteCustomView;

Line 1486: x_return_status := FND_API.G_RET_STS_ERROR;

1482: );
1483: END IF;
1484:
1485: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1486: x_return_status := FND_API.G_RET_STS_ERROR;
1487:
1488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1489: ROLLBACK TO deleteCustomView;
1490: IF (x_msg_data IS NULL) THEN

Line 1488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1484:
1485: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1486: x_return_status := FND_API.G_RET_STS_ERROR;
1487:
1488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1489: ROLLBACK TO deleteCustomView;
1490: IF (x_msg_data IS NULL) THEN
1491: FND_MSG_PUB.Count_And_Get
1492: ( p_encoded => FND_API.G_FALSE

Line 1492: ( p_encoded => FND_API.G_FALSE

1488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1489: ROLLBACK TO deleteCustomView;
1490: IF (x_msg_data IS NULL) THEN
1491: FND_MSG_PUB.Count_And_Get
1492: ( p_encoded => FND_API.G_FALSE
1493: , p_count => x_msg_count
1494: , p_data => x_msg_data
1495: );
1496: END IF;

Line 1497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1493: , p_count => x_msg_count
1494: , p_data => x_msg_data
1495: );
1496: END IF;
1497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1498: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1499:
1500: WHEN NO_DATA_FOUND THEN
1501: ROLLBACK TO deleteCustomView;

Line 1498: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

1494: , p_data => x_msg_data
1495: );
1496: END IF;
1497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1498: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1499:
1500: WHEN NO_DATA_FOUND THEN
1501: ROLLBACK TO deleteCustomView;
1502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1498: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1499:
1500: WHEN NO_DATA_FOUND THEN
1501: ROLLBACK TO deleteCustomView;
1502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1503: IF (x_msg_data IS NOT NULL) THEN
1504: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';
1505: ELSE
1506: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';

Line 1512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1508: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1509:
1510: WHEN OTHERS THEN
1511: ROLLBACK TO deleteCustomView;
1512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1513: IF (x_msg_data IS NOT NULL) THEN
1514: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';
1515: ELSE
1516: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PUB.delete_Custom_View ';

Line 1551: p_commit IN VARCHAR2 := FND_API.G_FALSE

1547: /*******************************************************************************/
1548:
1549: PROCEDURE Delete_Custom_View_Links
1550: (
1551: p_commit IN VARCHAR2 := FND_API.G_FALSE
1552: , p_tab_id IN NUMBER
1553: , p_obj_id IN NUMBER
1554: , x_return_status OUT NOCOPY VARCHAR2
1555: , x_msg_count OUT NOCOPY NUMBER

Line 1579: RAISE FND_API.G_EXC_ERROR;

1575: IF(l_count =0) THEN
1576: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_SCORECARD_ID');
1577: FND_MESSAGE.SET_TOKEN('BSC_SCORECARD', p_tab_id);
1578: FND_MSG_PUB.ADD;
1579: RAISE FND_API.G_EXC_ERROR;
1580: END IF;
1581: ELSE
1582: FND_MESSAGE.SET_NAME('BSC','BSC_NO_SCORECARD_ID_ENTERED');
1583: FND_MSG_PUB.ADD;

Line 1584: RAISE FND_API.G_EXC_ERROR;

1580: END IF;
1581: ELSE
1582: FND_MESSAGE.SET_NAME('BSC','BSC_NO_SCORECARD_ID_ENTERED');
1583: FND_MSG_PUB.ADD;
1584: RAISE FND_API.G_EXC_ERROR;
1585: END IF;
1586:
1587: l_Count := 0;
1588:

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

1629: FROM BSC_TAB_VIEW_LABELS_B
1630: WHERE tab_id = p_tab_id
1631: AND LINK_ID =p_obj_id;
1632:
1633: IF (p_commit = FND_API.G_TRUE) THEN
1634: COMMIT;
1635: END IF;
1636:
1637: EXCEPTION

Line 1639: WHEN FND_API.G_EXC_ERROR THEN

1635: END IF;
1636:
1637: EXCEPTION
1638:
1639: WHEN FND_API.G_EXC_ERROR THEN
1640: ROLLBACK TO DeleteCustomViewLinks;
1641: IF (x_msg_data IS NULL) THEN
1642: FND_MSG_PUB.Count_And_Get
1643: ( p_encoded => FND_API.G_FALSE

Line 1643: ( p_encoded => FND_API.G_FALSE

1639: WHEN FND_API.G_EXC_ERROR THEN
1640: ROLLBACK TO DeleteCustomViewLinks;
1641: IF (x_msg_data IS NULL) THEN
1642: FND_MSG_PUB.Count_And_Get
1643: ( p_encoded => FND_API.G_FALSE
1644: , p_count => x_msg_count
1645: , p_data => x_msg_data
1646: );
1647: END IF;

Line 1649: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

1645: , p_data => x_msg_data
1646: );
1647: END IF;
1648:
1649: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1650: x_return_status := FND_API.G_RET_STS_ERROR;
1651:
1652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1653: ROLLBACK TO DeleteCustomViewLinks;

Line 1650: x_return_status := FND_API.G_RET_STS_ERROR;

1646: );
1647: END IF;
1648:
1649: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1650: x_return_status := FND_API.G_RET_STS_ERROR;
1651:
1652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1653: ROLLBACK TO DeleteCustomViewLinks;
1654: IF (x_msg_data IS NULL) THEN

Line 1652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1648:
1649: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1650: x_return_status := FND_API.G_RET_STS_ERROR;
1651:
1652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1653: ROLLBACK TO DeleteCustomViewLinks;
1654: IF (x_msg_data IS NULL) THEN
1655: FND_MSG_PUB.Count_And_Get
1656: ( p_encoded => FND_API.G_FALSE

Line 1656: ( p_encoded => FND_API.G_FALSE

1652: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1653: ROLLBACK TO DeleteCustomViewLinks;
1654: IF (x_msg_data IS NULL) THEN
1655: FND_MSG_PUB.Count_And_Get
1656: ( p_encoded => FND_API.G_FALSE
1657: , p_count => x_msg_count
1658: , p_data => x_msg_data
1659: );
1660: END IF;

Line 1661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1657: , p_count => x_msg_count
1658: , p_data => x_msg_data
1659: );
1660: END IF;
1661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1662: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1663:
1664: WHEN NO_DATA_FOUND THEN
1665: ROLLBACK TO DeleteCustomViewLinks;

Line 1662: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

1658: , p_data => x_msg_data
1659: );
1660: END IF;
1661: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1662: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1663:
1664: WHEN NO_DATA_FOUND THEN
1665: ROLLBACK TO DeleteCustomViewLinks;
1666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1662: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1663:
1664: WHEN NO_DATA_FOUND THEN
1665: ROLLBACK TO DeleteCustomViewLinks;
1666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1667: IF (x_msg_data IS NOT NULL) THEN
1668: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Delete_Custom_View_Links ';
1669: ELSE
1670: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Delete_Custom_View_Links ';

Line 1675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1671: END IF;
1672: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1673: WHEN OTHERS THEN
1674: ROLLBACK TO DeleteCustomViewLinks;
1675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1676: IF (x_msg_data IS NOT NULL) THEN
1677: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Delete_Custom_View_Links ';
1678: ELSE
1679: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Delete_Custom_View_Links ';