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_BIS_MEASURE_PUB dependencies on BSC_BIS_MEASURE_PUB

Line 1: PACKAGE BODY BSC_BIS_MEASURE_PUB AS

1: PACKAGE BODY BSC_BIS_MEASURE_PUB AS
2: /* $Header: BSCPBMSB.pls 120.15 2007/06/08 08:59:32 akoduri ship $ */
3: --- Copyright (c) 2000 Oracle Corporation, Redwood Shores, CA, USA
4: --- All rights reserved.
5: ---

Line 256: l_Flag := BSC_BIS_MEASURE_PUB.Validate_Conditions

252: RAISE FND_API.G_EXC_ERROR;
253: END IF;
254: ELSE
255: FOR cd IN c_Create_Measure LOOP
256: l_Flag := BSC_BIS_MEASURE_PUB.Validate_Conditions
257: ( p_Bsc_source => p_dataset_source
258: , p_Pmf_Old_source => cd.Bis_Source
259: , p_Bsc_Old_Source => cd.Bsc_Source
260: );

Line 286: l_Flag := BSC_BIS_MEASURE_PUB.Validate_Conditions

282: RAISE FND_API.G_EXC_ERROR;
283: END IF;
284: ELSE
285: FOR cd IN c_Update_Measure LOOP
286: l_Flag := BSC_BIS_MEASURE_PUB.Validate_Conditions
287: ( p_Bsc_source => p_dataset_source
288: , p_Pmf_Old_source => cd.Bis_Source
289: , p_Bsc_Old_Source => cd.Bsc_Source
290: );

Line 387: l_alias := BSC_BIS_MEASURE_PUB.get_Next_Alias(l_alias);

383: IF (l_count = 0) THEN
384: l_flag := FALSE;
385: l_measure_short_name := l_temp_var;
386: END IF;
387: l_alias := BSC_BIS_MEASURE_PUB.get_Next_Alias(l_alias);
388: l_temp_var := l_measure_short_name||l_alias;
389: END LOOP;
390: END IF;
391:

Line 393: BSC_BIS_MEASURE_PUB.Create_Measure(

389: END LOOP;
390: END IF;
391:
392: --dispatch create_measure
393: BSC_BIS_MEASURE_PUB.Create_Measure(
394: p_commit => p_commit
395: ,x_dataset_id => x_dataset_id
396: ,p_dataset_source => p_dataset_source
397: ,p_dataset_name => p_dataset_name

Line 473: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Create_Measure ';

469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
470: WHEN NO_DATA_FOUND THEN
471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
472: IF (x_msg_data IS NOT NULL) THEN
473: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Create_Measure ';
474: ELSE
475: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Create_Measure ';
476: END IF;
477: ROLLBACK TO SP_CREATE_MEASURE;

Line 475: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Create_Measure ';

471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
472: IF (x_msg_data IS NOT NULL) THEN
473: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Create_Measure ';
474: ELSE
475: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Create_Measure ';
476: END IF;
477: ROLLBACK TO SP_CREATE_MEASURE;
478: WHEN OTHERS THEN
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 481: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Create_Measure ';

477: ROLLBACK TO SP_CREATE_MEASURE;
478: WHEN OTHERS THEN
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
480: IF (x_msg_data IS NOT NULL) THEN
481: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Create_Measure ';
482: ELSE
483: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Create_Measure ';
484: END IF;
485: ROLLBACK TO SP_CREATE_MEASURE;

Line 483: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Create_Measure ';

479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
480: IF (x_msg_data IS NOT NULL) THEN
481: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Create_Measure ';
482: ELSE
483: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Create_Measure ';
484: END IF;
485: ROLLBACK TO SP_CREATE_MEASURE;
486: end Create_Measure;
487: /************************End Create_Measure wrapper****************************/

Line 552: BSC_BIS_MEASURE_PUB.Create_Measure(

548: x_return_status := FND_API.G_RET_STS_SUCCESS;
549: fnd_msg_pub.initialize;
550:
551: --dispatch create_measure
552: BSC_BIS_MEASURE_PUB.Create_Measure(
553: p_commit => p_commit
554: ,x_dataset_id => x_dataset_id
555: ,p_dataset_source => p_dataset_source
556: ,p_dataset_name => p_dataset_name

Line 632: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Create_Measure ';

628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
629: WHEN NO_DATA_FOUND THEN
630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
631: IF (x_msg_data IS NOT NULL) THEN
632: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Create_Measure ';
633: ELSE
634: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Create_Measure ';
635: END IF;
636: ROLLBACK TO SP_CREATE_MEASURE;

Line 634: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Create_Measure ';

630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
631: IF (x_msg_data IS NOT NULL) THEN
632: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Create_Measure ';
633: ELSE
634: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Create_Measure ';
635: END IF;
636: ROLLBACK TO SP_CREATE_MEASURE;
637: WHEN OTHERS THEN
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 640: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Create_Measure ';

636: ROLLBACK TO SP_CREATE_MEASURE;
637: WHEN OTHERS THEN
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: IF (x_msg_data IS NOT NULL) THEN
640: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Create_Measure ';
641: ELSE
642: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Create_Measure ';
643: END IF;
644: ROLLBACK TO SP_CREATE_MEASURE;

Line 642: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Create_Measure ';

638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: IF (x_msg_data IS NOT NULL) THEN
640: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Create_Measure ';
641: ELSE
642: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Create_Measure ';
643: END IF;
644: ROLLBACK TO SP_CREATE_MEASURE;
645: end CREATE_MEASURE;
646:

Line 780: BSC_BIS_MEASURE_PUB.get_Measure_Name

776: END IF;
777:
778:
779: /******************* PAJOHRI ADDED Bug #3184408*************************/
780: BSC_BIS_MEASURE_PUB.get_Measure_Name
781: ( p_dataset_id => NULL
782: , p_ui_flag => p_ui_flag
783: , p_dataset_source => p_dataset_source
784: , p_dataset_name => p_dataset_name

Line 853: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_DATASETS_PUB.Create_Measures');

849: ,x_return_status => x_return_status
850: ,x_msg_count => x_msg_count
851: ,x_msg_data => x_msg_data);
852: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
853: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_DATASETS_PUB.Create_Measures');
854: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
855: END IF;
856:
857: else

Line 903: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_DATASETS_PUB.Create_Dataset');

899: ,x_return_status => x_return_status
900: ,x_msg_count => x_msg_count
901: ,x_msg_data => x_msg_data);
902: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
903: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_DATASETS_PUB.Create_Dataset');
904: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
905: END IF;
906:
907: -- POSCO Bug#3817894

Line 1086: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Create_Measure ';

1082: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1083: WHEN NO_DATA_FOUND THEN
1084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1085: IF (x_msg_data IS NOT NULL) THEN
1086: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Create_Measure ';
1087: ELSE
1088: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Create_Measure ';
1089: END IF;
1090: ROLLBACK TO SP_CREATE_MEASURE;

Line 1088: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Create_Measure ';

1084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1085: IF (x_msg_data IS NOT NULL) THEN
1086: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Create_Measure ';
1087: ELSE
1088: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Create_Measure ';
1089: END IF;
1090: ROLLBACK TO SP_CREATE_MEASURE;
1091: WHEN OTHERS THEN
1092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1094: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Create_Measure ';

1090: ROLLBACK TO SP_CREATE_MEASURE;
1091: WHEN OTHERS THEN
1092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1093: IF (x_msg_data IS NOT NULL) THEN
1094: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Create_Measure ';
1095: ELSE
1096: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Create_Measure ';
1097: END IF;
1098: ROLLBACK TO SP_CREATE_MEASURE;

Line 1096: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Create_Measure ';

1092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1093: IF (x_msg_data IS NOT NULL) THEN
1094: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Create_Measure ';
1095: ELSE
1096: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Create_Measure ';
1097: END IF;
1098: ROLLBACK TO SP_CREATE_MEASURE;
1099: end CREATE_MEASURE;
1100:

Line 1244: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Update_measure ';

1240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1241: WHEN NO_DATA_FOUND THEN
1242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1243: IF (x_msg_data IS NOT NULL) THEN
1244: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Update_measure ';
1245: ELSE
1246: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Update_measure ';
1247: END IF;
1248: ROLLBACK TO SP_UPDATE_MEASURE;

Line 1246: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Update_measure ';

1242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1243: IF (x_msg_data IS NOT NULL) THEN
1244: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Update_measure ';
1245: ELSE
1246: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Update_measure ';
1247: END IF;
1248: ROLLBACK TO SP_UPDATE_MEASURE;
1249: WHEN OTHERS THEN
1250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1252: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Update_measure ';

1248: ROLLBACK TO SP_UPDATE_MEASURE;
1249: WHEN OTHERS THEN
1250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1251: IF (x_msg_data IS NOT NULL) THEN
1252: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Update_measure ';
1253: ELSE
1254: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Update_measure ';
1255: END IF;
1256: ROLLBACK TO SP_UPDATE_MEASURE;

Line 1254: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Update_measure ';

1250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1251: IF (x_msg_data IS NOT NULL) THEN
1252: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Update_measure ';
1253: ELSE
1254: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Update_measure ';
1255: END IF;
1256: ROLLBACK TO SP_UPDATE_MEASURE;
1257: end Update_measure;
1258:

Line 1405: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_DATASETS_PUB.Create_Measures');

1401: ,x_msg_data);
1402:
1403:
1404: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
1405: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_DATASETS_PUB.Create_Measures');
1406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1407: END IF;
1408:
1409: --Need to update Dataset Info with the new Measure Id generated

Line 1420: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_DATASETS_PUB.Update_Measures');

1416: ,x_msg_count => x_msg_count
1417: ,x_msg_data => x_msg_data);
1418:
1419: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
1420: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_DATASETS_PUB.Update_Measures');
1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1422: END IF;
1423:
1424: /*Checking for Structural changes in indicators*/

Line 1462: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Upd_Sing_To_Formula ';

1458:
1459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1460:
1461: IF (x_msg_data IS NOT NULL) THEN
1462: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Upd_Sing_To_Formula ';
1463: ELSE
1464: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Upd_Sing_To_Formula ';
1465: END IF;
1466:

Line 1464: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Upd_Sing_To_Formula ';

1460:
1461: IF (x_msg_data IS NOT NULL) THEN
1462: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Upd_Sing_To_Formula ';
1463: ELSE
1464: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Upd_Sing_To_Formula ';
1465: END IF;
1466:
1467: ROLLBACK TO SP_UPD_TO_FORMULA;
1468: END Update_Single_To_Formula;

Line 1652: BSC_BIS_MEASURE_PUB.get_Measure_Name

1648: END LOOP;
1649: END IF;
1650:
1651: IF(NOT l_Same_Name) THEN
1652: BSC_BIS_MEASURE_PUB.get_Measure_Name
1653: ( p_dataset_id => NVL(l_Dataset_Rec.Bsc_dataset_id, -1)
1654: , p_ui_flag => p_ui_flag
1655: , p_dataset_source => p_dataset_source
1656: , p_dataset_name => p_dataset_name

Line 1746: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_BIS_LOCKS_PUB.LOCK_UPDATE_MEASURE');

1742:
1743: -- The APIs should check for return status ...
1744: -- Raising an unexpected error.
1745: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
1746: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_BIS_LOCKS_PUB.LOCK_UPDATE_MEASURE');
1747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1748: END IF;
1749: -- END Granular Locking
1750:

Line 1815: BSC_BIS_MEASURE_PUB.Update_Single_To_Formula(

1811: Is_Src_Col_In_Formulas(l_Dataset_Rec_db.Bsc_Measure_Col)) THEN
1812: /*Create a new entry in BSC_SYS_MEASURES if a Single Source Column is being changed to a Formula
1813: of A+B type while the source column is being used in other Formula. Then associate this new Measure Id
1814: as the Measure Id1 of the dataset*/
1815: BSC_BIS_MEASURE_PUB.Update_Single_To_Formula(
1816: p_commit => p_commit
1817: ,p_Dataset_Rec => l_Dataset_Rec
1818: ,p_Dataset_Rec_db => l_Dataset_Rec_db
1819: ,x_return_status => x_return_status

Line 1841: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_DATASETS_PUB.Update_Measures');

1837: ,x_msg_count => x_msg_count
1838: ,x_msg_data => x_msg_data);
1839:
1840: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
1841: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_DATASETS_PUB.Update_Measures');
1842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1843: END IF;
1844: END IF;
1845:

Line 1899: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at bsc_db_measure_cols_pkg.update_row');

1895: , x_Measure_Type => NVL(p_Measure_Type, l_measure_type)
1896: , x_Help => NVL(l_measure_col_help, l_Dataset_Rec.Bsc_Measure_Col)
1897: );
1898: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
1899: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at bsc_db_measure_cols_pkg.update_row');
1900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1901: END IF;
1902: else
1903: IF NOT (isFormula(l_Dataset_Rec.Bsc_Measure_Col) OR l_Dataset_Rec.Bsc_Source = c_CDS) THEN

Line 1912: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at bsc_db_measure_cols_pkg.insert_row');

1908: ,l_Dataset_Rec.Bsc_Measure_Projection_Id
1909: ,p_Measure_Type
1910: ,l_measure_col_help);
1911: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
1912: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at bsc_db_measure_cols_pkg.insert_row');
1913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1914: END IF;
1915: end if;
1916: end if;

Line 1994: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BIS_MEASURE_PUB.Update_Measure');

1990: x_msg_data := NULL;
1991: END IF;
1992: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1993: END IF;
1994: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BIS_MEASURE_PUB.Update_Measure');
1995: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1996: END IF;
1997: else
1998: -- Normally, PMF measure should always exist once BSC measure was created.

Line 2018: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BIS_MEASURE_PUB.Create_Measure');

2014: x_msg_data := NULL;
2015: END IF;
2016: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2017: END IF;
2018: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BIS_MEASURE_PUB.Create_Measure');
2019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2020: END IF;
2021: end if;
2022:

Line 2041: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET');

2037: ,x_msg_data => x_msg_data
2038: ) ;
2039:
2040: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
2041: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASET');
2042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2043: END IF;
2044: END IF;
2045: -- Change the time stamp of the Current Datasource (1)

Line 2057: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASOURCE');

2053: ,x_msg_data => x_msg_data
2054: ) ;
2055:
2056: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
2057: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASOURCE');
2058: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2059: END IF;
2060: END IF;
2061: -- Change the time stamp of the Current Datasource (2)

Line 2072: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASOURCE');

2068: ,x_msg_count => x_msg_count
2069: ,x_msg_data => x_msg_data
2070: ) ;
2071: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
2072: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_BIS_LOCKS_PUB.SET_TIME_STAMP_DATASOURCE');
2073: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2074: END IF;
2075: END IF;
2076: -- END Granular Locking

Line 2085: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_UTILITY.Add_To_Fnd_Msg_Stack');

2081: ,x_return_status => x_return_status
2082: ,x_msg_count => x_msg_count
2083: ,x_msg_data => x_msg_data);
2084: IF ((x_return_status IS NOT NULL) AND (x_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
2085: --DBMS_OUTPUT.PUT_LINE('BSC_BIS_KPI_MEAS_PUB.BSC_BIS_MEASURE_PUB Failed: at BSC_UTILITY.Add_To_Fnd_Msg_Stack');
2086: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2087: END IF;
2088: EXCEPTION
2089: WHEN FND_API.G_EXC_ERROR THEN

Line 2130: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Update_measure ';

2126: CLOSE c_Bsc_Measure_Color_Formula;
2127: END IF;
2128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2129: IF (x_msg_data IS NOT NULL) THEN
2130: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Update_measure ';
2131: ELSE
2132: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Update_measure ';
2133: END IF;
2134: ROLLBACK TO SP_UPDATE_MEASURE;

Line 2132: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Update_measure ';

2128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2129: IF (x_msg_data IS NOT NULL) THEN
2130: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Update_measure ';
2131: ELSE
2132: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Update_measure ';
2133: END IF;
2134: ROLLBACK TO SP_UPDATE_MEASURE;
2135: WHEN OTHERS THEN
2136: IF ( c_measure_col_cur%ISOPEN) THEN

Line 2144: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Update_measure ';

2140: CLOSE c_Bsc_Measure_Color_Formula;
2141: END IF;
2142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2143: IF (x_msg_data IS NOT NULL) THEN
2144: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Update_measure ';
2145: ELSE
2146: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Update_measure ';
2147: END IF;
2148: ROLLBACK TO SP_UPDATE_MEASURE;

Line 2146: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Update_measure ';

2142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2143: IF (x_msg_data IS NOT NULL) THEN
2144: x_msg_data := x_msg_data||' -> BSC_BIS_MEASURE_PUB.Update_measure ';
2145: ELSE
2146: x_msg_data := SQLERRM||' at BSC_BIS_MEASURE_PUB.Update_measure ';
2147: END IF;
2148: ROLLBACK TO SP_UPDATE_MEASURE;
2149: end Update_measure;
2150:

Line 2575: ,p_level => BSC_BIS_MEASURE_PUB.c_LEVEL

2571:
2572: BSC_CAUSE_EFFECT_REL_PUB.Delete_All_Cause_Effect_Rels(
2573: p_commit => p_commit
2574: ,p_indicator => p_dataset_id
2575: ,p_level => BSC_BIS_MEASURE_PUB.c_LEVEL
2576: ,x_return_status => x_return_status
2577: ,x_msg_count => x_msg_count
2578: ,x_msg_data => x_msg_data);
2579:

Line 2583: l_Bsc_Cause_Effect_Rel_Rec.Cause_Level := BSC_BIS_MEASURE_PUB.c_LEVEL;

2579:
2580: if p_causes_table is not null then
2581: for i in 1..p_causes_table.count loop
2582: l_Bsc_Cause_Effect_Rel_Rec.Cause_Indicator := p_causes_table(i);
2583: l_Bsc_Cause_Effect_Rel_Rec.Cause_Level := BSC_BIS_MEASURE_PUB.c_LEVEL;
2584: l_Bsc_Cause_Effect_Rel_Rec.Effect_Indicator := p_dataset_id;
2585: l_Bsc_Cause_Effect_Rel_Rec.Effect_Level := BSC_BIS_MEASURE_PUB.c_LEVEL;
2586:
2587: BSC_CAUSE_EFFECT_REL_PUB.Create_Cause_Effect_Rel(

Line 2585: l_Bsc_Cause_Effect_Rel_Rec.Effect_Level := BSC_BIS_MEASURE_PUB.c_LEVEL;

2581: for i in 1..p_causes_table.count loop
2582: l_Bsc_Cause_Effect_Rel_Rec.Cause_Indicator := p_causes_table(i);
2583: l_Bsc_Cause_Effect_Rel_Rec.Cause_Level := BSC_BIS_MEASURE_PUB.c_LEVEL;
2584: l_Bsc_Cause_Effect_Rel_Rec.Effect_Indicator := p_dataset_id;
2585: l_Bsc_Cause_Effect_Rel_Rec.Effect_Level := BSC_BIS_MEASURE_PUB.c_LEVEL;
2586:
2587: BSC_CAUSE_EFFECT_REL_PUB.Create_Cause_Effect_Rel(
2588: p_commit => p_commit
2589: ,p_Bsc_Cause_Effect_Rel_Rec => l_Bsc_Cause_Effect_Rel_Rec

Line 2601: l_Bsc_Cause_Effect_Rel_Rec.Cause_Level := BSC_BIS_MEASURE_PUB.c_LEVEL;

2597:
2598: if p_effects_table is not null then
2599: for i in 1..p_effects_table.count loop
2600: l_Bsc_Cause_Effect_Rel_Rec.Cause_Indicator := p_dataset_id;
2601: l_Bsc_Cause_Effect_Rel_Rec.Cause_Level := BSC_BIS_MEASURE_PUB.c_LEVEL;
2602: l_Bsc_Cause_Effect_Rel_Rec.Effect_Indicator := p_effects_table(i);
2603: l_Bsc_Cause_Effect_Rel_Rec.Effect_Level := BSC_BIS_MEASURE_PUB.c_LEVEL;
2604:
2605: BSC_CAUSE_EFFECT_REL_PUB.Create_Cause_Effect_Rel(

Line 2603: l_Bsc_Cause_Effect_Rel_Rec.Effect_Level := BSC_BIS_MEASURE_PUB.c_LEVEL;

2599: for i in 1..p_effects_table.count loop
2600: l_Bsc_Cause_Effect_Rel_Rec.Cause_Indicator := p_dataset_id;
2601: l_Bsc_Cause_Effect_Rel_Rec.Cause_Level := BSC_BIS_MEASURE_PUB.c_LEVEL;
2602: l_Bsc_Cause_Effect_Rel_Rec.Effect_Indicator := p_effects_table(i);
2603: l_Bsc_Cause_Effect_Rel_Rec.Effect_Level := BSC_BIS_MEASURE_PUB.c_LEVEL;
2604:
2605: BSC_CAUSE_EFFECT_REL_PUB.Create_Cause_Effect_Rel(
2606: p_commit => p_commit
2607: ,p_Bsc_Cause_Effect_Rel_Rec => l_Bsc_Cause_Effect_Rel_Rec

Line 2943: -- BSC_BIS_MEASURE_PUB.Create_Measure is called.

2939:
2940: -- BIS_MEASURE_PUB.Measure_Value_Id_Conversion and
2941: -- BIS_MEASURE_PUB.Dimension_Value_ID_Conversion are not called from Load_Measure
2942: -- as they will be called where BIS_MEASURE_PUB.Create_Measure is called from
2943: -- BSC_BIS_MEASURE_PUB.Create_Measure is called.
2944:
2945: -- Give a call to BIS_MEASURE_PUB.Dimension_Value_ID_Conversion so that
2946: -- we have dimension ids populated.
2947: -- These Ids are used in giving a call to BIS_MEASURE_PVT.IS_OLD_DATA_MODEL

Line 2950: BSC_BIS_MEASURE_PUB.Order_Dimensions_For_Ldt(

2946: -- we have dimension ids populated.
2947: -- These Ids are used in giving a call to BIS_MEASURE_PVT.IS_OLD_DATA_MODEL
2948:
2949: --
2950: BSC_BIS_MEASURE_PUB.Order_Dimensions_For_Ldt(
2951: p_Measure_Rec => l_measure_rec
2952: ,p_Org_Dimension_Short_Name => p_Org_Dimension_Short_Name
2953: ,p_Time_Dimension_Short_Name => p_Time_Dimension_Short_Name
2954: ,x_Measure_Rec => l_measure_rec_new

Line 2983: l_upload_test := BSC_BIS_MEASURE_PUB.Upload_Test(

2979: l_is_create := TRUE;
2980: ELSE
2981: l_is_create := FALSE;
2982: --bug#4045278: data versioning
2983: l_upload_test := BSC_BIS_MEASURE_PUB.Upload_Test(
2984: p_measure_short_name => p_Measure_Rec.Measure_Short_Name
2985: ,p_nls_mode => null
2986: ,p_file_lub => BIS_UTILITIES_PUB.Get_Owner_Id(p_owner)
2987: ,p_file_lud => p_Measure_Rec.Last_Update_Date

Line 3029: BSC_BIS_MEASURE_PUB.Create_Measure(

3025: -- one for PMF and the other for BSC
3026: IF (l_is_create) THEN
3027: -- call create measure
3028:
3029: BSC_BIS_MEASURE_PUB.Create_Measure(
3030: p_commit => FND_API.G_FALSE
3031: ,x_dataset_id => l_dataset_id
3032: ,p_dataset_source => nvl(l_dataset_rec.Bsc_Source, 'PMF')
3033: ,p_dataset_name => l_dataset_rec.Bsc_Dataset_Name

Line 3109: BSC_BIS_MEASURE_PUB.Update_Measure(

3105: -- These changes are to be applied to BIS record as well as BSC record.
3106:
3107: -- Call the Update API
3108:
3109: BSC_BIS_MEASURE_PUB.Update_Measure(
3110: p_commit => FND_API.G_FALSE
3111: ,p_dataset_id => l_dataset_id
3112: ,p_dataset_source => NVL(l_dataset_rec.Bsc_Source, 'PMF') -- :SOURCE
3113: ,p_dataset_name => NVL(l_dataset_rec.Bsc_Dataset_Name, l_dataset_rec_db.Bsc_Dataset_Name)

Line 3227: l_upload_test := BSC_BIS_MEASURE_PUB.Upload_Test(

3223:
3224: FND_MSG_PUB.Initialize;
3225:
3226: --bug#4045278: data versioning
3227: l_upload_test := BSC_BIS_MEASURE_PUB.Upload_Test(
3228: p_measure_short_name => p_Measure_Rec.Measure_Short_Name
3229: ,p_nls_mode => 'NLS'
3230: ,p_file_lub => BIS_UTILITIES_PUB.Get_Owner_Id(p_owner)
3231: ,p_file_lud => p_Measure_Rec.Last_Update_Date

Line 3246: BSC_BIS_MEASURE_PUB.Ret_Dataset_Fr_Meas_Shrt_Name(

3242:
3243: l_dataset_rec := p_Dataset_Rec;
3244: l_measure_rec := p_Measure_Rec;
3245:
3246: BSC_BIS_MEASURE_PUB.Ret_Dataset_Fr_Meas_Shrt_Name(
3247: p_Measure_Short_Name => p_dataset_rec.Bsc_Measure_Short_Name
3248: ,x_Dataset_Id => l_Dataset_Id
3249: );
3250:

Line 3568: l_alias := BSC_BIS_MEASURE_PUB.get_Next_Alias(l_alias);

3564: l_flag := FALSE;
3565: l_measure_col := l_temp_var;
3566: END IF;
3567: BEGIN
3568: l_alias := BSC_BIS_MEASURE_PUB.get_Next_Alias(l_alias);
3569: EXCEPTION
3570: WHEN OTHERS THEN
3571: l_measure_col := substr(l_measure_col, 1, 30);
3572: END;

Line 3844: l_temp := bsc_bis_measure_pub.getMeasureKpis(p_dataset_id => p_dataset_id);

3840: l_length number;
3841: begin
3842:
3843:
3844: l_temp := bsc_bis_measure_pub.getMeasureKpis(p_dataset_id => p_dataset_id);
3845: l_message := bsc_apps.get_message(p_message);
3846: l_length := nvl(0, length(l_message));
3847:
3848:

Line 4232: p_source_type := either BSC_BIS_MEASURE_PUB.c_BSC or

4228: Return 'T' if measure exists with given display name and source type,
4229: return 'F' otherwise.
4230: Parameters:
4231: p_display_name := measure display name
4232: p_source_type := either BSC_BIS_MEASURE_PUB.c_BSC or
4233: BSC_BIS_MEASURE_PUB.c_PMF
4234: *******************************************************************************/
4235: FUNCTION Is_Unique_Measure_Display_Name(
4236: p_dataset_id NUMBER

Line 4233: BSC_BIS_MEASURE_PUB.c_PMF

4229: return 'F' otherwise.
4230: Parameters:
4231: p_display_name := measure display name
4232: p_source_type := either BSC_BIS_MEASURE_PUB.c_BSC or
4233: BSC_BIS_MEASURE_PUB.c_PMF
4234: *******************************************************************************/
4235: FUNCTION Is_Unique_Measure_Display_Name(
4236: p_dataset_id NUMBER
4237: ,p_display_name VARCHAR2

Line 4242: BSC_BIS_MEASURE_PUB.get_Measure_Name

4238: ,p_source_type VARCHAR2
4239: ) RETURN VARCHAR2 IS
4240: l_display_name BIS_INDICATORS_TL.NAME%TYPE;
4241: BEGIN
4242: BSC_BIS_MEASURE_PUB.get_Measure_Name
4243: ( p_dataset_id => p_dataset_id
4244: ,p_ui_flag => 'Y'
4245: ,p_dataset_source => p_source_type
4246: ,p_dataset_name => p_display_name

Line 4440: l_Flag := BSC_BIS_MEASURE_PUB.Is_MeasureCol_In_Formula(p_measure_col,cd.measure_col);

4436:
4437:
4438: FOR cd in c_chk_col_in_formula(p_measure_col) LOOP
4439: --for every formula retrieved checking if the measure column is a part of the formula.
4440: l_Flag := BSC_BIS_MEASURE_PUB.Is_MeasureCol_In_Formula(p_measure_col,cd.measure_col);
4441:
4442: IF (l_Flag) THEN
4443:
4444: IF (cd.measure_id) IS NOT NULL THEN

Line 4566: end BSC_BIS_MEASURE_PUB;

4562: WHEN OTHERS THEN
4563: RETURN NULL;
4564: END Get_Report_Objectives;
4565:
4566: end BSC_BIS_MEASURE_PUB;