DBA Data[Home] [Help]

APPS.BSC_KPI_PVT dependencies on BSC_DIMENSION_LEVELS_PVT

Line 427: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

423: x_return_status := FND_API.G_RET_STS_SUCCESS;
424: SAVEPOINT BscKpiPvt_UptKPI;
425: -- Check that valid id was entered.
426: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
427: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
428: ,'indicator'
429: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
430: if l_count = 0 then
431: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 642: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

638: x_return_status := FND_API.G_RET_STS_SUCCESS;
639: SAVEPOINT BscKpiPvt_DelKPI;
640: -- Check that valid id was entered.
641: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
642: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
643: ,'indicator'
644: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
645: if l_count = 0 then
646: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 767: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

763:
764: -- Check that valid id was entered.
765: if l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
766:
767: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
768: ,'indicator'
769: ,l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
770: if l_count = 0 then
771:

Line 1122: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

1118: x_return_status := FND_API.G_RET_STS_SUCCESS;
1119: SAVEPOINT BscKpiPvt_CrtKPIProp;
1120: -- Check that valid id was entered.
1121: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
1122: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
1123: ,'indicator'
1124: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1125: if l_count = 0 then
1126: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 1294: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

1290: x_return_status := FND_API.G_RET_STS_SUCCESS;
1291: SAVEPOINT BscKpiPvt_UptKPIProp;
1292: -- Check that valid id was entered.
1293: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
1294: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
1295: ,'indicator'
1296: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1297: if l_count = 0 then
1298: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 1405: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

1401: FND_MSG_PUB.Initialize;
1402: x_return_status := FND_API.G_RET_STS_SUCCESS;
1403: SAVEPOINT BscKpiPvt_DelKPIProp;
1404: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
1405: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
1406: ,'indicator'
1407: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1408: if l_count = 0 then
1409: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 1497: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

1493: x_return_status := FND_API.G_RET_STS_SUCCESS;
1494: SAVEPOINT BscKpiPvt_CrtKPIAnal;
1495: -- Check that valid id was entered.
1496: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
1497: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
1498: ,'indicator'
1499: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1500: if l_count = 0 then
1501: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 1752: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

1748: x_return_status := FND_API.G_RET_STS_SUCCESS;
1749: SAVEPOINT BscKpiPvt_UpdKPIAnal;
1750: -- Check that valid id was entered.
1751: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
1752: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
1753: ,'indicator'
1754: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1755: if l_count = 0 then
1756: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 1906: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

1902: x_return_status := FND_API.G_RET_STS_SUCCESS;
1903: SAVEPOINT BscKpiPvt_DelKPIAnal;
1904: -- Check that valid id was entered.
1905: IF (p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id IS NOT NULL) THEN
1906: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
1907: ,'indicator'
1908: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1909: IF(l_count = 0 )THEN
1910: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 2013: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

2009: x_return_status := FND_API.G_RET_STS_SUCCESS;
2010: SAVEPOINT BscKpiPvt_DelObjColo;
2011: -- Check that valid id was entered.
2012: IF (p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id IS NOT NULL) THEN
2013: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
2014: ,'indicator'
2015: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2016: IF(l_count = 0 )THEN
2017: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 2135: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

2131: l_Bsc_Kpi_Entity_Rec := p_Bsc_Kpi_Entity_Rec;
2132:
2133: -- Check that valid id was entered.
2134: if l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
2135: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
2136: ,'indicator'
2137: ,l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2138: if l_count = 0 then
2139: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 2154: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_PERIODICITIES'

2150:
2151: -- Check that periodicity is valid. If periodicity is null then make it 5, default
2152: -- periodicity.
2153: if l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Periodicity_Id is not null then
2154: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_PERIODICITIES'
2155: ,'periodicity_id'
2156: ,l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Periodicity_Id);
2157: if l_count = 0 then
2158: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_PERIODICITY_ID');

Line 2368: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

2364: x_return_status := FND_API.G_RET_STS_SUCCESS;
2365: SAVEPOINT BscKpiPvt_UptKPIPerid;
2366: -- Check that valid id was entered.
2367: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
2368: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
2369: ,'indicator'
2370: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2371: if l_count = 0 then
2372: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 2520: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

2516: x_return_status := FND_API.G_RET_STS_SUCCESS;
2517: SAVEPOINT BscKpiPvt_DelKPIPerid;
2518: -- Check that valid id was entered.
2519: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
2520: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
2521: ,'indicator'
2522: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2523: if l_count = 0 then
2524: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 2608: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

2604: x_return_status := FND_API.G_RET_STS_SUCCESS;
2605: SAVEPOINT BscKpiPvt_CrtKPIDaTab;
2606: -- Check that valid id was entered.
2607: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
2608: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
2609: ,'indicator'
2610: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2611: if l_count = 0 then
2612: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 2786: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

2782: x_return_status := FND_API.G_RET_STS_SUCCESS;
2783: SAVEPOINT BscKpiPvt_UptKPIDaTab;
2784: -- Check that valid id was entered.
2785: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
2786: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
2787: ,'indicator'
2788: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2789: if l_count = 0 then
2790: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 2904: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

2900: x_return_status := FND_API.G_RET_STS_SUCCESS;
2901: SAVEPOINT BscKpiPvt_DelKPIDaTab;
2902: -- Check that valid id was entered.
2903: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
2904: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
2905: ,'indicator'
2906: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2907: if l_count = 0 then
2908: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 3012: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

3008: x_return_status := FND_API.G_RET_STS_SUCCESS;
3009: SAVEPOINT BscKpiPvt_CrtKPICalc;
3010: -- Check that valid id was entered.
3011: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
3012: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
3013: ,'indicator'
3014: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3015: if l_count = 0 then
3016: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 3197: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

3193: x_return_status := FND_API.G_RET_STS_SUCCESS;
3194: SAVEPOINT BscKpiPvt_UptKPICalc;
3195: -- Check that valid id was entered.
3196: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
3197: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
3198: ,'indicator'
3199: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3200: if l_count = 0 then
3201: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 3215: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPI_CALCULATIONS'

3211: end if;
3212:
3213: -- Check that valid id was entered.
3214: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Calculation_Id is not null then
3215: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPI_CALCULATIONS'
3216: ,'calculation_id'
3217: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Calculation_Id);
3218: if l_count = 0 then
3219: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_CALCULATION_ID');

Line 3341: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

3337: x_return_status := FND_API.G_RET_STS_SUCCESS;
3338: SAVEPOINT BscKpiPvt_DelKPICalc;
3339: -- Check that valid id was entered.
3340: IF(p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id IS NOT NULL) THEN
3341: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
3342: ,'indicator'
3343: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3344: IF (l_count = 0) THEN
3345: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 3433: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

3429: x_return_status := FND_API.G_RET_STS_SUCCESS;
3430: SAVEPOINT BscKpiPvt_CrtKPIUsrAcc;
3431: -- Check that valid id was entered.
3432: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
3433: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
3434: ,'indicator'
3435: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3436: if l_count = 0 then
3437: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 3631: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

3627: x_return_status := FND_API.G_RET_STS_SUCCESS;
3628: SAVEPOINT BscKpiPvt_UptKPIUsrAcc;
3629: -- Check that valid id was entered.
3630: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
3631: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
3632: ,'indicator'
3633: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3634: if l_count = 0 then
3635: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 3763: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

3759: x_return_status := FND_API.G_RET_STS_SUCCESS;
3760: SAVEPOINT BscKpiPvt_DelKPIUsrAcc;
3761: -- Check that valid id was entered.
3762: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
3763: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
3764: ,'indicator'
3765: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3766: if l_count = 0 then
3767: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 3855: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

3851: l_Bsc_Kpi_Entity_Rec := p_Bsc_Kpi_Entity_Rec;
3852:
3853: -- Check that valid id was entered.
3854: if l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
3855: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
3856: ,'indicator'
3857: ,l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3858: if l_count = 0 then
3859: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 4197: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

4193: x_return_status := FND_API.G_RET_STS_SUCCESS;
4194: SAVEPOINT BscKpiPvt_UpdKPIDefVals;
4195: -- Check that valid id was entered.
4196: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
4197: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
4198: ,'indicator'
4199: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4200: if l_count = 0 then
4201: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 4460: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

4456: x_return_status := FND_API.G_RET_STS_SUCCESS;
4457: SAVEPOINT BscKpiPvt_DelKPIDefVals;
4458: -- Check that valid id was entered.
4459: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
4460: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
4461: ,'indicator'
4462: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4463: if l_count = 0 then
4464: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 4558: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

4554: --DBMS_OUTPUT.PUT_LINE('l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Prototype_Flag = ' || l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Prototype_Flag);
4555:
4556: -- Check that valid id was entered.
4557: if l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
4558: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
4559: ,'indicator'
4560: ,l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4561: if l_count = 0 then
4562: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 4580: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_TABS_B'

4576: -- Check that valid id was entered.
4577: if l_Bsc_Kpi_Entity_Rec.Bsc_Tab_Id is not null then
4578: --DBMS_OUTPUT.PUT_LINE(' BSC_KPI_PVT.Create_Kpi_In_Tab - Flag 2');
4579:
4580: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_TABS_B'
4581: ,'tab_id'
4582: ,l_Bsc_Kpi_Entity_Rec.Bsc_Tab_Id);
4583: --DBMS_OUTPUT.PUT_LINE(' BSC_KPI_PVT.Create_Kpi_In_Tab - Flag 3');
4584:

Line 4848: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

4844: --DBMS_OUTPUT.PUT_LINE(' -- Begin BSC_KPI_PVT.Update_Kpi_In_Tab');
4845:
4846: -- Check that valid id was entered.
4847: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
4848: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
4849: ,'indicator'
4850: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4851: if l_count = 0 then
4852: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 4964: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

4960: x_return_status := FND_API.G_RET_STS_SUCCESS;
4961: SAVEPOINT BscKpiPvt_DelKPIInTab;
4962: -- Check that valid id was entered.
4963: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
4964: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
4965: ,'indicator'
4966: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4967: if l_count = 0 then
4968: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 5130: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'

5126: --DBMS_OUTPUT.PUT_LINE('-- Begin BSC_KPI_PVT.Create_Master_Kpi');
5127:
5128: -- Check that valid id was entered.
5129: if p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id is not null then
5130: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
5131: ,'indicator'
5132: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
5133: if l_count = 0 then
5134: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

Line 5152: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_TABS_B'

5148: -- Check that valid tab id was entered.
5149: if p_Bsc_Kpi_Entity_Rec.Bsc_Tab_Id is not null then
5150: --DBMS_OUTPUT.PUT_LINE(' BSC_KPI_PVT.Create_Master_Kpi Flag 2');
5151:
5152: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_TABS_B'
5153: ,'tab_id'
5154: ,p_Bsc_Kpi_Entity_Rec.Bsc_Tab_Id);
5155: --DBMS_OUTPUT.PUT_LINE(' BSC_KPI_PVT.Create_Master_Kpi Flag 3');
5156:

Line 5325: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id := BSC_DIMENSION_LEVELS_PVT.Get_Next_Value( 'BSC_KPIS_B'

5321: -- After we will change necessary values to make the new Indicator a shared
5322: -- Indicator.
5323:
5324: -- Get the next id available for the current Kpi.
5325: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id := BSC_DIMENSION_LEVELS_PVT.Get_Next_Value( 'BSC_KPIS_B'
5326: ,'indicator');
5327: --DBMS_OUTPUT.PUT_LINE(' BSC_KPI_PVT.Create_Shared_Kpi - Flag 1');
5328: --DBMS_OUTPUT.PUT_LINE(' New KPI code := ' || l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
5329:

Line 5597: l_cnt := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_TABS_B'

5593: x_return_status := FND_API.G_RET_STS_SUCCESS;
5594: SAVEPOINT BscKpiPvt_MoveTab;
5595: -- Check that valid id was entered.
5596: if p_tab_id is not null then
5597: l_cnt := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_TABS_B'
5598: ,'tab_id'
5599: ,p_tab_id);
5600: if l_cnt = 0 then
5601: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_TAB_ID');