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_CUSTOM_VIEW_PVT dependencies on BSC_CUSTOM_VIEW_PVT

Line 1: PACKAGE BODY BSC_CUSTOM_VIEW_PVT AS

1: PACKAGE BODY BSC_CUSTOM_VIEW_PVT AS
2: /* $Header: BSCCVDVB.pls 120.0 2005/06/01 16:15:52 appldev noship $ */
3: /*********************************************************************************/
4:
5:

Line 182: BSC_CUSTOM_VIEW_PVT.Update_Tab_default_View

178: ELSE
179: l_Tab_Rec.Bsc_Bsc_Model :=1;
180: END IF;
181:
182: BSC_CUSTOM_VIEW_PVT.Update_Tab_default_View
183: (
184: p_Tab_Rec => l_Tab_Rec
185: ,x_return_status => x_return_status
186: ,x_msg_count => x_msg_count

Line 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||'>');

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:
194: ELSE

Line 204: l_count := BSC_CUSTOM_VIEW_PVT.Validate_Tab_View

200: --If no records exists then no need to insert the record into the data base
201: -- just skip it.
202: l_count := -1;
203: IF (l_Tab_View_Rec.Bsc_Tab_View_Id < 0) THEN
204: l_count := BSC_CUSTOM_VIEW_PVT.Validate_Tab_View
205: (
206: p_tab_id => l_Tab_View_Rec.Bsc_Tab_Id
207: , p_tab_view_id => l_Tab_View_Rec.Bsc_Tab_View_Id
208: );

Line 212: BSC_CUSTOM_VIEW_PVT.Update_Tab_View

208: );
209:
210: END IF;
211: IF ((l_count = -1) OR (l_count > 0)) THEN
212: BSC_CUSTOM_VIEW_PVT.Update_Tab_View
213: (
214: p_Tab_View_Rec => l_Tab_View_Rec
215: ,x_return_status => x_return_status
216: ,x_msg_count => x_msg_count

Line 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||'>');

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;
224: END IF;

Line 256: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views ';

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 ';
259: END IF;
260:

Line 258: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views ';

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 ';
259: END IF;
260:
261: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION NO_DATA_FOUND '||x_msg_data);
262:

Line 266: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views ';

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 ';
269: END IF;
270:

Line 268: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views ';

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 ';
269: END IF;
270:
271: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION OTHERS '||x_msg_data);
272: END Assign_Cust_Views;

Line 338: BSC_CUSTOM_VIEW_PVT.Update_Tab_default_View

334: l_Tab_Rec.Bsc_Bsc_Model :=0;
335: END IF;
336:
337: ----DBMS_OUTPUT.PUT_LINE\n(' inside if l_tab_view_id--> '|| l_tab_view_id) ;
338: BSC_CUSTOM_VIEW_PVT.Update_Tab_default_View
339: (
340: p_Tab_Rec => l_Tab_Rec
341: ,x_return_status => x_return_status
342: ,x_msg_count => x_msg_count

Line 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||'>');

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:
350: ELSE

Line 360: l_count := BSC_CUSTOM_VIEW_PVT.Validate_Tab_View

356:
357: -- Check if the records are there for the tab view id -2 and -1.
358: -- if not then create a record for -2 and -1 and setthe enabled flag to 0
359: IF (l_Tab_View_Rec.Bsc_Tab_View_Id < 0) THEN
360: l_count := BSC_CUSTOM_VIEW_PVT.Validate_Tab_View
361: (
362: p_tab_id => l_Tab_View_Rec.Bsc_Tab_Id
363: , p_tab_view_id => l_Tab_View_Rec.Bsc_Tab_View_Id
364: );

Line 389: BSC_CUSTOM_VIEW_PVT.Create_Tab_View

385: l_Tab_View_Rec.Bsc_Help := l_Tab_View_Rec.Bsc_Name;
386: END IF;
387: END IF;
388:
389: BSC_CUSTOM_VIEW_PVT.Create_Tab_View
390: (
391: p_Tab_View_Rec => l_Tab_View_Rec
392: ,x_return_status => x_return_status
393: ,x_msg_count => x_msg_count

Line 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||'>');

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;
401: END IF;

Line 403: BSC_CUSTOM_VIEW_PVT.Update_Tab_View

399: END IF;
400: END IF;
401: END IF;
402:
403: BSC_CUSTOM_VIEW_PVT.Update_Tab_View
404: (
405: p_Tab_View_Rec => l_Tab_View_Rec
406: ,x_return_status => x_return_status
407: ,x_msg_count => x_msg_count

Line 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||'>');

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;
415: END LOOP;

Line 445: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views ';

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 ';
448: END IF;
449: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 447: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views ';

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 ';
448: END IF;
449: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION NO_DATA_FOUND '||x_msg_data);
450:
451: WHEN OTHERS THEN

Line 454: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views ';

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 ';
457: END IF;
458: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION OTHERS '||x_msg_data);

Line 456: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views ';

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 ';
457: END IF;
458: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION OTHERS '||x_msg_data);
459: END Unassign_Cust_Views;
460:

Line 520: BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views

516: --DBMS_OUTPUT.PUT_LINE\n('p_unassign_views--->' || p_unassign_views);
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

Line 530: ----DBMS_OUTPUT.PUT_LINE\n('BSC_CUSTOM_VIEW_PVT.Assign_Unassign_Views Failed: at BSC_CUSTOM_VIEW_PVT.Assign_Unassign_Views');

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;
534:

Line 540: BSC_CUSTOM_VIEW_PVT.Assign_Cust_Views

536: -- call the assign view API
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

Line 550: ----DBMS_OUTPUT.PUT_LINE\n('BSC_CUSTOM_VIEW_PVT.Assign_Cust_Views Failed: at BSC_CUSTOM_VIEW_PVT.Assign_Cust_Views');

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;
554: --DBMS_OUTPUT.PUT_LINE\n('aFTER SC_CUSTOM_VIEW_PVT.Assign_Cust_Views');

Line 564: l_count := BSC_CUSTOM_VIEW_PVT.Validate_Tab_View

560: l_Tab_View_Rec.Bsc_Tab_Id := p_tab_id;
561: l_Tab_View_Rec.Bsc_Tab_View_Id := p_default_value ;
562: l_Tab_View_Rec.Bsc_Enabled_Flag := 1;
563:
564: l_count := BSC_CUSTOM_VIEW_PVT.Validate_Tab_View
565: (
566: p_tab_id => l_Tab_View_Rec.Bsc_Tab_Id
567: , p_tab_view_id => l_Tab_View_Rec.Bsc_Tab_View_Id
568: );

Line 579: BSC_CUSTOM_VIEW_PVT.Create_Tab_View

575: END IF;
576:
577: l_Tab_View_Rec.Bsc_Help := l_Tab_View_Rec.Bsc_Name;
578:
579: BSC_CUSTOM_VIEW_PVT.Create_Tab_View
580: (
581: p_Tab_View_Rec => l_Tab_View_Rec
582: ,x_return_status => x_return_status
583: ,x_msg_count => x_msg_count

Line 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||'>');

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;
591: END IF;

Line 593: l_count := BSC_CUSTOM_VIEW_PVT.get_enabled_flag_for_View

589: END IF;
590: END IF;
591: END IF;
592:
593: l_count := BSC_CUSTOM_VIEW_PVT.get_enabled_flag_for_View
594: (
595: p_tab_id => p_tab_id
596: , p_tab_view_id => p_default_value
597: );

Line 609: BSC_CUSTOM_VIEW_PVT.Update_Tab_default_View

605: l_Tab_Rec.Bsc_Tab_Id := p_tab_id;
606: l_Tab_Rec.Bsc_Default_Model := p_default_value;
607: l_Tab_Rec.Bsc_Last_Update_Date := SYSDATE;
608:
609: BSC_CUSTOM_VIEW_PVT.Update_Tab_default_View
610: (
611: p_Tab_Rec => l_Tab_Rec
612: ,x_return_status => x_return_status
613: ,x_msg_count => x_msg_count

Line 645: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views ';

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 ';
648: END IF;
649: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 647: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views ';

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 ';
648: END IF;
649: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION NO_DATA_FOUND '||x_msg_data);
650:
651: WHEN OTHERS THEN

Line 654: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views ';

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 ';
657: END IF;
658: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION OTHERS '||x_msg_data);

Line 656: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Unassign_Cust_Views ';

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 ';
657: END IF;
658: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION OTHERS '||x_msg_data);
659: END Assign_Unassign_Views;
660:

Line 777: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Retrieve_Tab';

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';
780: END IF;
781: RAISE;

Line 779: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Retrieve_Tab';

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';
780: END IF;
781: RAISE;
782: WHEN OTHERS THEN
783: ROLLBACK TO CreateTabView;

Line 786: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Create_Tab_View';

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';
789: END IF;
790: RAISE;

Line 788: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Create_Tab_View';

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';
789: END IF;
790: RAISE;
791:
792: END Create_Tab_View;

Line 858: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Retrieve_Tab ';

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 ';
861: END IF;
862: RAISE;

Line 860: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Retrieve_Tab ';

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 ';
861: END IF;
862: RAISE;
863: WHEN OTHERS THEN
864: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 929: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Retrieve_Tab_View ';

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 ';
932: END IF;
933: RAISE;

Line 931: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Retrieve_Tab_View ';

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 ';
932: END IF;
933: RAISE;
934: WHEN OTHERS THEN
935: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 937: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Retrieve_Tab_View ';

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 ';
940: END IF;
941: RAISE;

Line 939: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Retrieve_Tab_View ';

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 ';
940: END IF;
941: RAISE;
942: END Retrieve_Tab_View;
943:

Line 1071: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Update_Tab_View ';

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 ';
1074: END IF;
1075: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1073: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Update_Tab_View ';

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 ';
1074: END IF;
1075: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1076: WHEN OTHERS THEN
1077: ROLLBACK TO UpdateTabView;

Line 1080: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Update_Tab_View ';

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 ';
1083: END IF;
1084: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION OTHERS '||x_msg_data);

Line 1082: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Update_Tab_View ';

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 ';
1083: END IF;
1084: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION OTHERS '||x_msg_data);
1085: END Update_Tab_View;
1086:

Line 1250: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Update_Tab_default_View ';

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 ';
1253: END IF;
1254: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1252: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Update_Tab_default_View ';

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 ';
1253: END IF;
1254: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1255: WHEN OTHERS THEN
1256: ROLLBACK TO UpdateTabdefaultView;

Line 1259: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Update_Tab_default_View ';

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 ';
1262: END IF;
1263: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION OTHERS '||x_msg_data);

Line 1261: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Update_Tab_default_View ';

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 ';
1262: END IF;
1263: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION OTHERS '||x_msg_data);
1264:
1265: END Update_Tab_default_View;

Line 1393: BSC_CUSTOM_VIEW_PVT.Update_Tab_default_View

1389: l_Tab_Rec.Bsc_Default_Model :=0;
1390: l_Tab_Rec.Bsc_Kpi_Model :=1;
1391: l_Tab_Rec.Bsc_Last_update_Date := SYSDATE;
1392:
1393: BSC_CUSTOM_VIEW_PVT.Update_Tab_default_View
1394: (
1395: p_Tab_Rec => l_Tab_Rec
1396: ,x_return_status => x_return_status
1397: ,x_msg_count => x_msg_count

Line 1404: BSC_CUSTOM_VIEW_PVT.Update_Tab_default_View

1400: ELSE
1401:
1402: l_Tab_Rec.Bsc_Last_update_Date := SYSDATE;
1403:
1404: BSC_CUSTOM_VIEW_PVT.Update_Tab_default_View
1405: (
1406: p_Tab_Rec => l_Tab_Rec
1407: ,x_return_status => x_return_status
1408: ,x_msg_count => x_msg_count

Line 1668: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Delete_Custom_View_Links ';

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 ';
1671: END IF;
1672: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1670: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Delete_Custom_View_Links ';

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 ';
1671: END IF;
1672: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1673: WHEN OTHERS THEN
1674: ROLLBACK TO DeleteCustomViewLinks;

Line 1677: x_msg_data := x_msg_data||' -> BSC_CUSTOM_VIEW_PVT.Delete_Custom_View_Links ';

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 ';
1680: END IF;
1681: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION OTHERS '||x_msg_data);

Line 1679: x_msg_data := SQLERRM||' at BSC_CUSTOM_VIEW_PVT.Delete_Custom_View_Links ';

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 ';
1680: END IF;
1681: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION OTHERS '||x_msg_data);
1682: END Delete_Custom_View_Links;
1683:

Line 1684: END BSC_CUSTOM_VIEW_PVT;

1680: END IF;
1681: ----DBMS_OUTPUT.PUT_LINE\n('EXCEPTION OTHERS '||x_msg_data);
1682: END Delete_Custom_View_Links;
1683:
1684: END BSC_CUSTOM_VIEW_PVT;