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_DIMENSION_SETS_PVT dependencies on BSC_KPI_DIM_SETS_TL

Line 26: | 1. Modified Update Query for BSC_KPI_DIM_SETS_TL, |

22: | |
23: | 18-DEC-2002 ASHANKAR Bug Fix #2716498 |
24: | |
25: | 04-MAR-2003 PAJOHRI MLS Bug #2721899 |
26: | 1. Modified Update Query for BSC_KPI_DIM_SETS_TL, |
27: | BSC_KPI_DIM_LEVELS_TL, and Insert Query for |
28: | BSC_KPI_DIM_LEVELS_TL. |
29: | 2. Changed nvl(l_Dim_Set_Rec.Bsc_Language, userenv('LANG')) |
30: | to userenv('LANG') |

Line 448: procedure Create_Bsc_Kpi_Dim_Sets_Tl(

444:
445: --: This procedure creates the dimension set id and name for the KPI.
446: --: This procedure belongs to the Dimension Set API.
447:
448: procedure Create_Bsc_Kpi_Dim_Sets_Tl(
449: p_commit IN varchar2 := FND_API.G_FALSE
450: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
451: ,x_return_status OUT NOCOPY varchar2
452: ,x_msg_count OUT NOCOPY number

Line 476: from BSC_KPI_DIM_SETS_TL

472: -- If The dimension set Id is null then get the next available one.
473: if l_Dim_Set_Rec.Bsc_Dim_Set_Id is null then
474: select count(*)
475: into l_Dim_Set_Rec.Bsc_Dim_Set_Id
476: from BSC_KPI_DIM_SETS_TL
477: where indicator = l_Dim_Set_Rec.Bsc_Kpi_Id;
478: else -- Determine if the KPI already contains this dimension set id.
479: select count(*)
480: into l_count

Line 481: from BSC_KPI_DIM_SETS_TL

477: where indicator = l_Dim_Set_Rec.Bsc_Kpi_Id;
478: else -- Determine if the KPI already contains this dimension set id.
479: select count(*)
480: into l_count
481: from BSC_KPI_DIM_SETS_TL
482: where indicator = l_Dim_Set_Rec.Bsc_Kpi_Id
483: and dim_set_id = l_Dim_Set_Rec.Bsc_Dim_Set_Id;
484: end if;
485:

Line 496: g_db_object := 'BSC_KPI_DIM_SETS_TL';

492:
493: -- If Dim Set Id not in KPI yet then insert pertaining values, else raise error.
494: if l_count = 0 then
495:
496: g_db_object := 'BSC_KPI_DIM_SETS_TL';
497:
498: -- Insert pertaining values into table bsc_kpi_dim_sets_tl.
499: /* Fixed bug 2787553 */
500: insert into BSC_KPI_DIM_SETS_TL( indicator

Line 498: -- Insert pertaining values into table bsc_kpi_dim_sets_tl.

494: if l_count = 0 then
495:
496: g_db_object := 'BSC_KPI_DIM_SETS_TL';
497:
498: -- Insert pertaining values into table bsc_kpi_dim_sets_tl.
499: /* Fixed bug 2787553 */
500: insert into BSC_KPI_DIM_SETS_TL( indicator
501: ,dim_set_id
502: ,language

Line 500: insert into BSC_KPI_DIM_SETS_TL( indicator

496: g_db_object := 'BSC_KPI_DIM_SETS_TL';
497:
498: -- Insert pertaining values into table bsc_kpi_dim_sets_tl.
499: /* Fixed bug 2787553 */
500: insert into BSC_KPI_DIM_SETS_TL( indicator
501: ,dim_set_id
502: ,language
503: ,source_lang
504: ,name

Line 527: FROM BSC_KPI_DIM_SETS_TL T

523: FROM FND_LANGUAGES L
524: WHERE L.INSTALLED_FLAG IN ('I', 'B')
525: AND NOT EXISTS
526: ( SELECT NULL
527: FROM BSC_KPI_DIM_SETS_TL T
528: WHERE T.indicator = l_Dim_Set_Rec.Bsc_Kpi_Id
529: AND T.dim_set_id = l_Dim_Set_Rec.Bsc_Dim_Set_Id
530: AND T.LANGUAGE = L.LANGUAGE_CODE);
531: --PAJOHRI added 23-JUL-2003

Line 580: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PVT.Create_Bsc_Kpi_Dim_Sets_Tl ';

576: WHEN NO_DATA_FOUND THEN
577: ROLLBACK TO CreateBSCKpiDSetTlPvt;
578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
579: IF (x_msg_data IS NOT NULL) THEN
580: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PVT.Create_Bsc_Kpi_Dim_Sets_Tl ';
581: ELSE
582: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PVT.Create_Bsc_Kpi_Dim_Sets_Tl ';
583: END IF;
584: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 582: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PVT.Create_Bsc_Kpi_Dim_Sets_Tl ';

578: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
579: IF (x_msg_data IS NOT NULL) THEN
580: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PVT.Create_Bsc_Kpi_Dim_Sets_Tl ';
581: ELSE
582: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PVT.Create_Bsc_Kpi_Dim_Sets_Tl ';
583: END IF;
584: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
585: RAISE;
586: WHEN OTHERS THEN

Line 590: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PVT.Create_Bsc_Kpi_Dim_Sets_Tl ';

586: WHEN OTHERS THEN
587: ROLLBACK TO CreateBSCKpiDSetTlPvt;
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
589: IF (x_msg_data IS NOT NULL) THEN
590: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PVT.Create_Bsc_Kpi_Dim_Sets_Tl ';
591: ELSE
592: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PVT.Create_Bsc_Kpi_Dim_Sets_Tl ';
593: END IF;
594: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 592: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PVT.Create_Bsc_Kpi_Dim_Sets_Tl ';

588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
589: IF (x_msg_data IS NOT NULL) THEN
590: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PVT.Create_Bsc_Kpi_Dim_Sets_Tl ';
591: ELSE
592: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PVT.Create_Bsc_Kpi_Dim_Sets_Tl ';
593: END IF;
594: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
595: RAISE;
596: end Create_Bsc_Kpi_Dim_Sets_Tl;

Line 596: end Create_Bsc_Kpi_Dim_Sets_Tl;

592: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PVT.Create_Bsc_Kpi_Dim_Sets_Tl ';
593: END IF;
594: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
595: RAISE;
596: end Create_Bsc_Kpi_Dim_Sets_Tl;
597:
598: /************************************************************************************
599: ************************************************************************************/
600:

Line 601: procedure Retrieve_Bsc_Kpi_Dim_Sets_Tl(

597:
598: /************************************************************************************
599: ************************************************************************************/
600:
601: procedure Retrieve_Bsc_Kpi_Dim_Sets_Tl(
602: p_commit IN varchar2 := FND_API.G_FALSE
603: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
604: ,x_Dim_Set_Rec IN OUT NOCOPY BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
605: ,x_return_status OUT NOCOPY varchar2

Line 612: g_db_object := 'Retrieve_Bsc_Kpi_Dim_Sets_Tl';

608: ) is
609:
610: begin
611:
612: g_db_object := 'Retrieve_Bsc_Kpi_Dim_Sets_Tl';
613: FND_MSG_PUB.Initialize;
614: x_return_status := FND_API.G_RET_STS_SUCCESS;
615: -- fix the bug 2716498 INCORRECT MESSAGE REGARDING DELETE MASTER KPI WHILE ATTEMPTING TO ADD KPI TO TAB
616: -- added the condition "and LANGUAGE = p_Dim_Set_Rec.Bsc_Language" because two rows were returned.

Line 623: FROM BSC_KPI_DIM_SETS_TL

619: SELECT DISTINCT NAME
620: ,SHORT_NAME
621: INTO x_Dim_Set_Rec.Bsc_Dim_Set_Name
622: ,x_Dim_Set_Rec.Bsc_Dim_Set_Short_Name
623: FROM BSC_KPI_DIM_SETS_TL
624: WHERE INDICATOR = p_Dim_Set_Rec.Bsc_Kpi_Id
625: AND DIM_SET_ID = p_Dim_Set_Rec.Bsc_Dim_Set_Id
626: AND LANGUAGE = USERENV('LANG');
627:

Line 659: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PVT.Retrieve_Bsc_Kpi_Dim_Sets_Tl ';

655: WHEN NO_DATA_FOUND THEN
656: ROLLBACK TO CreateBSCDimLevMdPVT;
657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
658: IF (x_msg_data IS NOT NULL) THEN
659: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PVT.Retrieve_Bsc_Kpi_Dim_Sets_Tl ';
660: ELSE
661: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PVT.Retrieve_Bsc_Kpi_Dim_Sets_Tl ';
662: END IF;
663: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 661: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PVT.Retrieve_Bsc_Kpi_Dim_Sets_Tl ';

657: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
658: IF (x_msg_data IS NOT NULL) THEN
659: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PVT.Retrieve_Bsc_Kpi_Dim_Sets_Tl ';
660: ELSE
661: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PVT.Retrieve_Bsc_Kpi_Dim_Sets_Tl ';
662: END IF;
663: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
664: RAISE;
665: WHEN OTHERS THEN

Line 669: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PVT.Retrieve_Bsc_Kpi_Dim_Sets_Tl ';

665: WHEN OTHERS THEN
666: ROLLBACK TO CreateBSCDimLevMdPVT;
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
668: IF (x_msg_data IS NOT NULL) THEN
669: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PVT.Retrieve_Bsc_Kpi_Dim_Sets_Tl ';
670: ELSE
671: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PVT.Retrieve_Bsc_Kpi_Dim_Sets_Tl ';
672: END IF;
673: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 671: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PVT.Retrieve_Bsc_Kpi_Dim_Sets_Tl ';

667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
668: IF (x_msg_data IS NOT NULL) THEN
669: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PVT.Retrieve_Bsc_Kpi_Dim_Sets_Tl ';
670: ELSE
671: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PVT.Retrieve_Bsc_Kpi_Dim_Sets_Tl ';
672: END IF;
673: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
674: RAISE;
675: end Retrieve_Bsc_Kpi_Dim_Sets_Tl;

Line 675: end Retrieve_Bsc_Kpi_Dim_Sets_Tl;

671: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PVT.Retrieve_Bsc_Kpi_Dim_Sets_Tl ';
672: END IF;
673: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
674: RAISE;
675: end Retrieve_Bsc_Kpi_Dim_Sets_Tl;
676:
677: /************************************************************************************
678: ************************************************************************************/
679:

Line 680: procedure Update_Bsc_Kpi_Dim_Sets_Tl(

676:
677: /************************************************************************************
678: ************************************************************************************/
679:
680: procedure Update_Bsc_Kpi_Dim_Sets_Tl(
681: p_commit IN varchar2 := FND_API.G_FALSE
682: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
683: ,x_return_status OUT NOCOPY varchar2
684: ,x_msg_count OUT NOCOPY number

Line 711: from BSC_KPI_DIM_SETS_TL

707: RAISE FND_API.G_EXC_ERROR;
708: else
709: select count(dim_set_id)
710: into l_count
711: from BSC_KPI_DIM_SETS_TL
712: where indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
713: and dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id;
714: if l_count = 0 then
715: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_DSET_ID');

Line 745: UPDATE BSC_KPI_DIM_SETS_TL

741: END IF;
742:
743:
744: if l_Dim_Set_Rec.Bsc_Dim_Set_Name is not null then
745: UPDATE BSC_KPI_DIM_SETS_TL
746: SET NAME = l_Dim_Set_Rec.Bsc_Dim_Set_Name
747: ,SOURCE_LANG = userenv('LANG')
748: , LAST_UPDATED_BY = l_Dim_Set_Rec.Bsc_Last_Updated_By -- Added for PMD
749: , LAST_UPDATE_DATE = SYSDATE -- Added for PMD

Line 786: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PVT.Update_Bsc_Kpi_Dim_Sets_Tl ';

782: WHEN NO_DATA_FOUND THEN
783: ROLLBACK TO UpdateBSCKpiDSetTlPvt;
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_DIMENSION_SETS_PVT.Update_Bsc_Kpi_Dim_Sets_Tl ';
787: ELSE
788: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PVT.Update_Bsc_Kpi_Dim_Sets_Tl ';
789: END IF;
790: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 788: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PVT.Update_Bsc_Kpi_Dim_Sets_Tl ';

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_DIMENSION_SETS_PVT.Update_Bsc_Kpi_Dim_Sets_Tl ';
787: ELSE
788: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PVT.Update_Bsc_Kpi_Dim_Sets_Tl ';
789: END IF;
790: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
791: RAISE;
792: WHEN OTHERS THEN

Line 796: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PVT.Update_Bsc_Kpi_Dim_Sets_Tl ';

792: WHEN OTHERS THEN
793: ROLLBACK TO UpdateBSCKpiDSetTlPvt;
794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
795: IF (x_msg_data IS NOT NULL) THEN
796: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PVT.Update_Bsc_Kpi_Dim_Sets_Tl ';
797: ELSE
798: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PVT.Update_Bsc_Kpi_Dim_Sets_Tl ';
799: END IF;
800: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 798: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PVT.Update_Bsc_Kpi_Dim_Sets_Tl ';

794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
795: IF (x_msg_data IS NOT NULL) THEN
796: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PVT.Update_Bsc_Kpi_Dim_Sets_Tl ';
797: ELSE
798: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PVT.Update_Bsc_Kpi_Dim_Sets_Tl ';
799: END IF;
800: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
801: RAISE;
802: end Update_Bsc_Kpi_Dim_Sets_Tl;

Line 802: end Update_Bsc_Kpi_Dim_Sets_Tl;

798: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PVT.Update_Bsc_Kpi_Dim_Sets_Tl ';
799: END IF;
800: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
801: RAISE;
802: end Update_Bsc_Kpi_Dim_Sets_Tl;
803:
804: /************************************************************************************
805: ************************************************************************************/
806:

Line 807: procedure Delete_Bsc_Kpi_Dim_Sets_Tl(

803:
804: /************************************************************************************
805: ************************************************************************************/
806:
807: procedure Delete_Bsc_Kpi_Dim_Sets_Tl(
808: p_commit IN varchar2 := FND_API.G_FALSE
809: ,p_Dim_Set_Rec IN BSC_DIMENSION_SETS_PUB.Bsc_Dim_Set_Rec_Type
810: ,x_return_status OUT NOCOPY varchar2
811: ,x_msg_count OUT NOCOPY number

Line 829: delete from BSC_KPI_DIM_SETS_TL

825: where indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
826: and dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id;
827:
828: if l_count = 0 then
829: delete from BSC_KPI_DIM_SETS_TL
830: where indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
831: and dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id;
832:
833: if (p_commit = FND_API.G_TRUE) then

Line 865: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PVT.Delete_Bsc_Kpi_Dim_Sets_Tl ';

861: WHEN NO_DATA_FOUND THEN
862: ROLLBACK TO DeleteBSCKpiDSetTlPvt;
863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
864: IF (x_msg_data IS NOT NULL) THEN
865: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PVT.Delete_Bsc_Kpi_Dim_Sets_Tl ';
866: ELSE
867: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PVT.Delete_Bsc_Kpi_Dim_Sets_Tl ';
868: END IF;
869: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 867: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PVT.Delete_Bsc_Kpi_Dim_Sets_Tl ';

863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
864: IF (x_msg_data IS NOT NULL) THEN
865: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PVT.Delete_Bsc_Kpi_Dim_Sets_Tl ';
866: ELSE
867: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PVT.Delete_Bsc_Kpi_Dim_Sets_Tl ';
868: END IF;
869: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
870: RAISE;
871: WHEN OTHERS THEN

Line 875: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PVT.Delete_Bsc_Kpi_Dim_Sets_Tl ';

871: WHEN OTHERS THEN
872: ROLLBACK TO DeleteBSCKpiDSetTlPvt;
873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: IF (x_msg_data IS NOT NULL) THEN
875: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PVT.Delete_Bsc_Kpi_Dim_Sets_Tl ';
876: ELSE
877: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PVT.Delete_Bsc_Kpi_Dim_Sets_Tl ';
878: END IF;
879: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 877: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PVT.Delete_Bsc_Kpi_Dim_Sets_Tl ';

873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: IF (x_msg_data IS NOT NULL) THEN
875: x_msg_data := x_msg_data||' -> BSC_DIMENSION_SETS_PVT.Delete_Bsc_Kpi_Dim_Sets_Tl ';
876: ELSE
877: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PVT.Delete_Bsc_Kpi_Dim_Sets_Tl ';
878: END IF;
879: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
880: RAISE;
881: end Delete_Bsc_Kpi_Dim_Sets_Tl;

Line 881: end Delete_Bsc_Kpi_Dim_Sets_Tl;

877: x_msg_data := SQLERRM||' at BSC_DIMENSION_SETS_PVT.Delete_Bsc_Kpi_Dim_Sets_Tl ';
878: END IF;
879: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
880: RAISE;
881: end Delete_Bsc_Kpi_Dim_Sets_Tl;
882:
883: /************************************************************************************
884: ************************************************************************************/
885:

Line 1115: from BSC_KPI_DIM_SETS_TL

1111: RAISE FND_API.G_EXC_ERROR;
1112: else
1113: select count(dim_set_id)
1114: into l_count
1115: from BSC_KPI_DIM_SETS_TL
1116: where indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1117: and dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id;
1118: if l_count = 0 then
1119: FND_MESSAGE.SET_NAME('BSC','BSC_DSDL_COMBO_EXISTS');

Line 1288: from BSC_KPI_DIM_SETS_TL

1284: RAISE FND_API.G_EXC_ERROR;
1285: else
1286: select count(dim_set_id)
1287: into l_count
1288: from BSC_KPI_DIM_SETS_TL
1289: where indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1290: and dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id;
1291: if l_count = 0 then
1292: FND_MESSAGE.SET_NAME('BSC','BSC_DSDL_COMBO_EXISTS');

Line 1751: from BSC_KPI_DIM_SETS_TL

1747: RAISE FND_API.G_EXC_ERROR;
1748: else
1749: select count(dim_set_id)
1750: into l_count
1751: from BSC_KPI_DIM_SETS_TL
1752: where indicator = p_Dim_Set_Rec.Bsc_Kpi_Id
1753: and dim_set_id = p_Dim_Set_Rec.Bsc_Dim_Set_Id;
1754: if l_count = 0 then
1755: FND_MESSAGE.SET_NAME('BSC','BSC_DSDL_COMBO_EXISTS');