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_ANALYSIS_OPTION_PVT dependencies on BSC_ANALYSIS_OPTION_PVT

Line 1: package body BSC_ANALYSIS_OPTION_PVT as

1: package body BSC_ANALYSIS_OPTION_PVT as
2: /* $Header: BSCVANOB.pls 120.7 2007/04/13 13:07:14 ppandey ship $ */
3: /*
4: +======================================================================================+
5: | Copyright (c) 2001 Oracle Corporation, Redwood Shores, CA, USA |

Line 53: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_ANALYSIS_OPTION_PVT';

49: | 31-Jan-2007 akoduri Enh #5679096 Migration of multibar functionality from |
50: | VB to Html |
51: +======================================================================================+
52: */
53: G_PKG_NAME CONSTANT varchar2(30) := 'BSC_ANALYSIS_OPTION_PVT';
54: g_db_object varchar2(30) := null;
55:
56:
57: TYPE Swap_Ana_Opts_Type IS Record

Line 435: l_Swap_Table BSC_ANALYSIS_OPTION_PVT.Swap_Ana_Opts_Table;

431: , p_group_Id NUMBER
432: , p_parent_option_Id NUMBER
433: , p_grand_parent_option_Id NUMBER
434: ) IS
435: l_Swap_Table BSC_ANALYSIS_OPTION_PVT.Swap_Ana_Opts_Table;
436: l_Count NUMBER := 0;
437: l_Table_Count NUMBER := 0;
438: l_Dependency_Flag NUMBER := 0;
439: l_parent_option_Id NUMBER := -1;

Line 908: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Options ';

904: WHEN NO_DATA_FOUND THEN
905: ROLLBACK TO CreateBSCAnaOptPVT;
906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
907: IF (x_msg_data IS NOT NULL) THEN
908: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Options ';
909: ELSE
910: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Options ';
911: END IF;
912: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 910: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Options ';

906: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
907: IF (x_msg_data IS NOT NULL) THEN
908: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Options ';
909: ELSE
910: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Options ';
911: END IF;
912: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
913: RAISE;
914: WHEN OTHERS THEN

Line 918: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Options ';

914: WHEN OTHERS THEN
915: ROLLBACK TO CreateBSCAnaOptPVT;
916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
917: IF (x_msg_data IS NOT NULL) THEN
918: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Options ';
919: ELSE
920: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Options ';
921: END IF;
922: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 920: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Options ';

916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
917: IF (x_msg_data IS NOT NULL) THEN
918: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Options ';
919: ELSE
920: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Options ';
921: END IF;
922: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
923: RAISE;
924: end Create_Analysis_Options;

Line 1057: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Retrieve_Analysis_Options ';

1053: RAISE;
1054: WHEN NO_DATA_FOUND THEN
1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1056: IF (x_msg_data IS NOT NULL) THEN
1057: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Retrieve_Analysis_Options ';
1058: ELSE
1059: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Retrieve_Analysis_Options ';
1060: END IF;
1061: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1059: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Retrieve_Analysis_Options ';

1055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1056: IF (x_msg_data IS NOT NULL) THEN
1057: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Retrieve_Analysis_Options ';
1058: ELSE
1059: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Retrieve_Analysis_Options ';
1060: END IF;
1061: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1062: RAISE;
1063: WHEN OTHERS THEN

Line 1066: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Retrieve_Analysis_Options ';

1062: RAISE;
1063: WHEN OTHERS THEN
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1065: IF (x_msg_data IS NOT NULL) THEN
1066: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Retrieve_Analysis_Options ';
1067: ELSE
1068: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Retrieve_Analysis_Options ';
1069: END IF;
1070: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1068: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Retrieve_Analysis_Options ';

1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1065: IF (x_msg_data IS NOT NULL) THEN
1066: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Retrieve_Analysis_Options ';
1067: ELSE
1068: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Retrieve_Analysis_Options ';
1069: END IF;
1070: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1071: RAISE;
1072: end Retrieve_Analysis_Options;

Line 1278: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Options ';

1274: WHEN NO_DATA_FOUND THEN
1275: ROLLBACK TO UpdateBSCAnaOptPVT;
1276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1277: IF (x_msg_data IS NOT NULL) THEN
1278: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Options ';
1279: ELSE
1280: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Options ';
1281: END IF;
1282: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1280: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Options ';

1276: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1277: IF (x_msg_data IS NOT NULL) THEN
1278: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Options ';
1279: ELSE
1280: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Options ';
1281: END IF;
1282: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1283: RAISE;
1284: WHEN OTHERS THEN

Line 1288: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Options ';

1284: WHEN OTHERS THEN
1285: ROLLBACK TO UpdateBSCAnaOptPVT;
1286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1287: IF (x_msg_data IS NOT NULL) THEN
1288: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Options ';
1289: ELSE
1290: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Options ';
1291: END IF;
1292: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1290: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Options ';

1286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1287: IF (x_msg_data IS NOT NULL) THEN
1288: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Options ';
1289: ELSE
1290: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Options ';
1291: END IF;
1292: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1293: RAISE;
1294: end Update_Analysis_Options;

Line 1457: BSC_ANALYSIS_OPTION_PVT.Swap_Option_Id

1453: --DBMS_OUTPUT.PUT_LINE(' Swap_Option_Id( p_Kpi_Id <'||l_Anal_Opt_Rec.Bsc_Kpi_Id ||'>');
1454: --DBMS_OUTPUT.PUT_LINE(' Swap_Option_Id( p_group_id <'||l_Anal_Opt_Rec.Bsc_Analysis_Group_Id||'>');
1455: --DBMS_OUTPUT.PUT_LINE(' Swap_Option_Id( p_parent_option_Id <'||NVL(l_Parent_Opt_Id, 0)||'>');
1456: --DBMS_OUTPUT.PUT_LINE(' Swap_Option_Id( p_grand_parent_option_Id <'||NVL(l_Gra_Parent_Opt_Id, 0)||'>');
1457: BSC_ANALYSIS_OPTION_PVT.Swap_Option_Id
1458: ( p_Kpi_Id => l_Anal_Opt_Rec.Bsc_Kpi_Id
1459: , p_group_id => l_Anal_Opt_Rec.Bsc_Analysis_Group_Id
1460: , p_parent_option_Id => NVL(l_Parent_Opt_Id, 0)
1461: , p_grand_parent_option_Id => NVL(l_Gra_Parent_Opt_Id, 0)

Line 1463: BSC_ANALYSIS_OPTION_PVT.Set_Default_Value

1459: , p_group_id => l_Anal_Opt_Rec.Bsc_Analysis_Group_Id
1460: , p_parent_option_Id => NVL(l_Parent_Opt_Id, 0)
1461: , p_grand_parent_option_Id => NVL(l_Gra_Parent_Opt_Id, 0)
1462: );
1463: BSC_ANALYSIS_OPTION_PVT.Set_Default_Value
1464: ( p_Kpi_Id => l_Anal_Opt_Rec.Bsc_Kpi_Id
1465: , p_group_id => l_Anal_Opt_Rec.Bsc_Analysis_Group_Id
1466: , p_parent_option_Id => NVL(l_Parent_Opt_Id, 0)
1467: , p_grand_parent_option_Id => NVL(l_Gra_Parent_Opt_Id, 0)

Line 1541: --BSC_ANALYSIS_OPTION_PVT.Swap_Option_Id( p_Kpi_Id => l_Anal_Opt_Rec.Bsc_Kpi_Id);

1537: ,x_return_status
1538: ,x_msg_count
1539: ,x_msg_data);
1540:
1541: --BSC_ANALYSIS_OPTION_PVT.Swap_Option_Id( p_Kpi_Id => l_Anal_Opt_Rec.Bsc_Kpi_Id);
1542: BSC_ANALYSIS_OPTION_PVT.Swap_Option_Id
1543: ( p_Kpi_Id => l_Anal_Opt_Rec.Bsc_Kpi_Id
1544: , p_group_id => l_Anal_Opt_Rec.Bsc_Analysis_Group_Id
1545: , p_parent_option_Id => NVL(l_Parent_Opt_Id, 0)

Line 1542: BSC_ANALYSIS_OPTION_PVT.Swap_Option_Id

1538: ,x_msg_count
1539: ,x_msg_data);
1540:
1541: --BSC_ANALYSIS_OPTION_PVT.Swap_Option_Id( p_Kpi_Id => l_Anal_Opt_Rec.Bsc_Kpi_Id);
1542: BSC_ANALYSIS_OPTION_PVT.Swap_Option_Id
1543: ( p_Kpi_Id => l_Anal_Opt_Rec.Bsc_Kpi_Id
1544: , p_group_id => l_Anal_Opt_Rec.Bsc_Analysis_Group_Id
1545: , p_parent_option_Id => NVL(l_Parent_Opt_Id, 0)
1546: , p_grand_parent_option_Id => NVL(l_Gra_Parent_Opt_Id, 0)

Line 1548: BSC_ANALYSIS_OPTION_PVT.Set_Default_Value

1544: , p_group_id => l_Anal_Opt_Rec.Bsc_Analysis_Group_Id
1545: , p_parent_option_Id => NVL(l_Parent_Opt_Id, 0)
1546: , p_grand_parent_option_Id => NVL(l_Gra_Parent_Opt_Id, 0)
1547: );
1548: BSC_ANALYSIS_OPTION_PVT.Set_Default_Value
1549: ( p_Kpi_Id => l_Anal_Opt_Rec.Bsc_Kpi_Id
1550: , p_group_id => l_Anal_Opt_Rec.Bsc_Analysis_Group_Id
1551: , p_parent_option_Id => NVL(l_Parent_Opt_Id, 0)
1552: , p_grand_parent_option_Id => NVL(l_Gra_Parent_Opt_Id, 0)

Line 1592: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options ';

1588: WHEN NO_DATA_FOUND THEN
1589: ROLLBACK TO DeleteBSCAnaOptPVT;
1590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1591: IF (x_msg_data IS NOT NULL) THEN
1592: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options ';
1593: ELSE
1594: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options ';
1595: END IF;
1596: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1594: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options ';

1590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1591: IF (x_msg_data IS NOT NULL) THEN
1592: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options ';
1593: ELSE
1594: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options ';
1595: END IF;
1596: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1597: RAISE;
1598: WHEN OTHERS THEN

Line 1602: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options ';

1598: WHEN OTHERS THEN
1599: ROLLBACK TO DeleteBSCAnaOptPVT;
1600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1601: IF (x_msg_data IS NOT NULL) THEN
1602: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options ';
1603: ELSE
1604: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options ';
1605: END IF;
1606: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1604: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options ';

1600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1601: IF (x_msg_data IS NOT NULL) THEN
1602: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options ';
1603: ELSE
1604: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options ';
1605: END IF;
1606: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1607: RAISE;
1608: END Delete_Analysis_Options;

Line 1767: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Measures ';

1763: WHEN NO_DATA_FOUND THEN
1764: ROLLBACK TO CreateBSCAnaMeasPVT;
1765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1766: IF (x_msg_data IS NOT NULL) THEN
1767: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Measures ';
1768: ELSE
1769: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Measures ';
1770: END IF;
1771: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1769: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Measures ';

1765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1766: IF (x_msg_data IS NOT NULL) THEN
1767: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Measures ';
1768: ELSE
1769: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Measures ';
1770: END IF;
1771: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1772: RAISE;
1773: WHEN OTHERS THEN

Line 1777: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Measures ';

1773: WHEN OTHERS THEN
1774: ROLLBACK TO CreateBSCAnaMeasPVT;
1775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1776: IF (x_msg_data IS NOT NULL) THEN
1777: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Measures ';
1778: ELSE
1779: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Measures ';
1780: END IF;
1781: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1779: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Measures ';

1775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1776: IF (x_msg_data IS NOT NULL) THEN
1777: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Measures ';
1778: ELSE
1779: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Create_Analysis_Measures ';
1780: END IF;
1781: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1782: RAISE;
1783: end Create_Analysis_Measures;

Line 1903: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Retrieve_Analysis_Measures ';

1899: RAISE FND_API.G_EXC_ERROR;
1900: WHEN OTHERS THEN
1901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1902: IF (x_msg_data IS NOT NULL) THEN
1903: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Retrieve_Analysis_Measures ';
1904: ELSE
1905: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Retrieve_Analysis_Measures ';
1906: END IF;
1907: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1905: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Retrieve_Analysis_Measures ';

1901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1902: IF (x_msg_data IS NOT NULL) THEN
1903: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Retrieve_Analysis_Measures ';
1904: ELSE
1905: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Retrieve_Analysis_Measures ';
1906: END IF;
1907: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1908: RAISE;
1909: end Retrieve_Analysis_Measures;

Line 2179: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Measures ';

2175: WHEN NO_DATA_FOUND THEN
2176: ROLLBACK TO UpdateBSCAnaMeasPVT;
2177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2178: IF (x_msg_data IS NOT NULL) THEN
2179: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Measures ';
2180: ELSE
2181: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Measures ';
2182: END IF;
2183: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 2181: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Measures ';

2177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2178: IF (x_msg_data IS NOT NULL) THEN
2179: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Measures ';
2180: ELSE
2181: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Measures ';
2182: END IF;
2183: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
2184: RAISE;
2185: WHEN OTHERS THEN

Line 2189: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Measures ';

2185: WHEN OTHERS THEN
2186: ROLLBACK TO UpdateBSCAnaMeasPVT;
2187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2188: IF (x_msg_data IS NOT NULL) THEN
2189: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Measures ';
2190: ELSE
2191: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Measures ';
2192: END IF;
2193: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 2191: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Measures ';

2187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2188: IF (x_msg_data IS NOT NULL) THEN
2189: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Measures ';
2190: ELSE
2191: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Update_Analysis_Measures ';
2192: END IF;
2193: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2194: RAISE;
2195: end Update_Analysis_Measures;

Line 2574: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Measures ';

2570: END IF;
2571: ROLLBACK TO DeleteBSCAnaMeasPVT;
2572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2573: IF (x_msg_data IS NOT NULL) THEN
2574: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Measures ';
2575: ELSE
2576: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Measures ';
2577: END IF;
2578: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 2576: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Measures ';

2572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2573: IF (x_msg_data IS NOT NULL) THEN
2574: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Measures ';
2575: ELSE
2576: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Measures ';
2577: END IF;
2578: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
2579: RAISE;
2580: WHEN OTHERS THEN

Line 2590: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Measures ';

2586: END IF;
2587: ROLLBACK TO DeleteBSCAnaMeasPVT;
2588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2589: IF (x_msg_data IS NOT NULL) THEN
2590: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Measures ';
2591: ELSE
2592: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Measures ';
2593: END IF;
2594: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 2592: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Measures ';

2588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2589: IF (x_msg_data IS NOT NULL) THEN
2590: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Measures ';
2591: ELSE
2592: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Measures ';
2593: END IF;
2594: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2595: RAISE;
2596: END Delete_Analysis_Measures;

Line 2699: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Option ';

2695: RAISE;
2696: WHEN NO_DATA_FOUND THEN
2697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2698: IF (x_msg_data IS NOT NULL) THEN
2699: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Option ';
2700: ELSE
2701: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Option ';
2702: END IF;
2703: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 2701: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Option ';

2697: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2698: IF (x_msg_data IS NOT NULL) THEN
2699: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Option ';
2700: ELSE
2701: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Option ';
2702: END IF;
2703: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
2704: RAISE;
2705: WHEN OTHERS THEN

Line 2708: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Option ';

2704: RAISE;
2705: WHEN OTHERS THEN
2706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2707: IF (x_msg_data IS NOT NULL) THEN
2708: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Option ';
2709: ELSE
2710: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Option ';
2711: END IF;
2712: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 2710: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Option ';

2706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2707: IF (x_msg_data IS NOT NULL) THEN
2708: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Option ';
2709: ELSE
2710: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Option ';
2711: END IF;
2712: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
2713: RAISE;
2714: end Delete_Analysis_Option;

Line 2923: BSC_ANALYSIS_OPTION_PVT.Initialize_Anal_Opt_Tbl

2919:
2920:
2921: --BSC_D_NOT_DELETE_AO_DEPEN
2922:
2923: BSC_ANALYSIS_OPTION_PVT.Initialize_Anal_Opt_Tbl
2924: (
2925: p_Kpi_id => p_Kpi_id
2926: ,p_Anal_Opt_Tbl => p_Anal_Opt_Tbl
2927: ,p_max_group_count => p_max_group_count

Line 2952: BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options

2948: l_Anal_Opt_Rec.Bsc_Analysis_Option_Id := l_Anal_Det_Opt_Tbl(l_count).Bsc_Option_Id ;
2949: l_Anal_Opt_Rec.Bsc_Parent_Option_Id := l_Anal_Det_Opt_Tbl(l_count).Bsc_Parent_Option_Id ;
2950: l_Anal_Opt_Rec.Bsc_Grandparent_Option_Id := l_Anal_Det_Opt_Tbl(l_count).Bsc_Grandparent_Option_Id;
2951:
2952: BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options
2953: ( p_commit => FND_API.G_FALSE
2954: , p_Anal_Opt_Rec => l_Anal_Opt_Rec
2955: , x_return_status => x_return_status
2956: , x_msg_count => x_msg_count

Line 2973: BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options

2969: l_Anal_Opt_Rec.Bsc_Analysis_Option_Id := l_Anal_Det_Opt_Tbl(l_count -1).Bsc_Option_Id ;
2970: l_Anal_Opt_Rec.Bsc_Parent_Option_Id := l_Anal_Det_Opt_Tbl(l_count -1).Bsc_Parent_Option_Id ;
2971: l_Anal_Opt_Rec.Bsc_Grandparent_Option_Id := l_Anal_Det_Opt_Tbl(l_count -1).Bsc_Grandparent_Option_Id;
2972:
2973: BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options
2974: ( p_commit => FND_API.G_FALSE
2975: , p_Anal_Opt_Rec => l_Anal_Opt_Rec
2976: , x_return_status => x_return_status
2977: , x_msg_count => x_msg_count

Line 2987: BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options

2983: l_Anal_Opt_Rec.Bsc_Analysis_Option_Id := l_Anal_Det_Opt_Tbl(l_count -2).Bsc_Option_Id ;
2984: l_Anal_Opt_Rec.Bsc_Parent_Option_Id := l_Anal_Det_Opt_Tbl(l_count -2).Bsc_Parent_Option_Id ;
2985: l_Anal_Opt_Rec.Bsc_Grandparent_Option_Id := l_Anal_Det_Opt_Tbl(l_count -2).Bsc_Grandparent_Option_Id;
2986:
2987: BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options
2988: ( p_commit => FND_API.G_FALSE
2989: , p_Anal_Opt_Rec => l_Anal_Opt_Rec
2990: , x_return_status => x_return_status
2991: , x_msg_count => x_msg_count

Line 3006: BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options

3002: l_Anal_Opt_Rec.Bsc_Analysis_Option_Id := l_Anal_Det_Opt_Tbl(l_count -2).Bsc_Option_Id ;
3003: l_Anal_Opt_Rec.Bsc_Parent_Option_Id := l_Anal_Det_Opt_Tbl(l_count -2).Bsc_Parent_Option_Id ;
3004: l_Anal_Opt_Rec.Bsc_Grandparent_Option_Id := l_Anal_Det_Opt_Tbl(l_count -2).Bsc_Grandparent_Option_Id;
3005:
3006: BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options
3007: ( p_commit => FND_API.G_FALSE
3008: , p_Anal_Opt_Rec => l_Anal_Opt_Rec
3009: , x_return_status => x_return_status
3010: , x_msg_count => x_msg_count

Line 3025: BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options

3021: l_Anal_Opt_Rec.Bsc_Analysis_Option_Id := l_Anal_Det_Opt_Tbl(l_count -1).Bsc_Option_Id ;
3022: l_Anal_Opt_Rec.Bsc_Parent_Option_Id := l_Anal_Det_Opt_Tbl(l_count -1).Bsc_Parent_Option_Id ;
3023: l_Anal_Opt_Rec.Bsc_Grandparent_Option_Id := l_Anal_Det_Opt_Tbl(l_count -1).Bsc_Grandparent_Option_Id;
3024:
3025: BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options
3026: ( p_commit => FND_API.G_FALSE
3027: , p_Anal_Opt_Rec => l_Anal_Opt_Rec
3028: , x_return_status => x_return_status
3029: , x_msg_count => x_msg_count

Line 3041: BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options

3037: l_Anal_Opt_Rec.Bsc_Analysis_Group_Id := l_count -2;
3038: l_Anal_Opt_Rec.Bsc_Analysis_Option_Id := l_Anal_Det_Opt_Tbl(l_count -2).Bsc_Option_Id ;
3039: l_Anal_Opt_Rec.Bsc_Parent_Option_Id := l_Anal_Det_Opt_Tbl(l_count -2).Bsc_Parent_Option_Id ;
3040: l_Anal_Opt_Rec.Bsc_Grandparent_Option_Id := l_Anal_Det_Opt_Tbl(l_count -2).Bsc_Grandparent_Option_Id;
3041: BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options
3042: ( p_commit => FND_API.G_FALSE
3043: , p_Anal_Opt_Rec => l_Anal_Opt_Rec
3044: , x_return_status => x_return_status
3045: , x_msg_count => x_msg_count

Line 3055: BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options

3051: l_Anal_Opt_Rec.Bsc_Analysis_Group_Id := l_count;
3052: l_Anal_Opt_Rec.Bsc_Analysis_Option_Id := l_Anal_Det_Opt_Tbl(l_count).Bsc_Option_Id ;
3053: l_Anal_Opt_Rec.Bsc_Parent_Option_Id := l_Anal_Det_Opt_Tbl(l_count).Bsc_Parent_Option_Id ;
3054: l_Anal_Opt_Rec.Bsc_Grandparent_Option_Id := l_Anal_Det_Opt_Tbl(l_count).Bsc_Grandparent_Option_Id;
3055: BSC_ANALYSIS_OPTION_PVT.Delete_Analysis_Options
3056: ( p_commit => FND_API.G_FALSE
3057: , p_Anal_Opt_Rec => l_Anal_Opt_Rec
3058: , x_return_status => x_return_status
3059: , x_msg_count => x_msg_count

Line 3088: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Delete_Ana_Opt_Mult_Groups ';

3084: WHEN NO_DATA_FOUND THEN
3085: ROLLBACK TO DeleteBSCAnaOptMultGroups;
3086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3087: IF (x_msg_data IS NOT NULL) THEN
3088: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Delete_Ana_Opt_Mult_Groups ';
3089: ELSE
3090: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Delete_Ana_Opt_Mult_Groups ';
3091: END IF;
3092: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 3090: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Delete_Ana_Opt_Mult_Groups ';

3086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3087: IF (x_msg_data IS NOT NULL) THEN
3088: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Delete_Ana_Opt_Mult_Groups ';
3089: ELSE
3090: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Delete_Ana_Opt_Mult_Groups ';
3091: END IF;
3092: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
3093: RAISE;
3094: WHEN OTHERS THEN

Line 3098: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Delete_Ana_Opt_Mult_Groups ';

3094: WHEN OTHERS THEN
3095: ROLLBACK TO DeleteBSCAnaOptMultGroups;
3096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3097: IF (x_msg_data IS NOT NULL) THEN
3098: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Delete_Ana_Opt_Mult_Groups ';
3099: ELSE
3100: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Delete_Ana_Opt_Mult_Groups ';
3101: END IF;
3102: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 3100: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Delete_Ana_Opt_Mult_Groups ';

3096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3097: IF (x_msg_data IS NOT NULL) THEN
3098: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Delete_Ana_Opt_Mult_Groups ';
3099: ELSE
3100: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Delete_Ana_Opt_Mult_Groups ';
3101: END IF;
3102: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
3103: RAISE;
3104: END Delete_Ana_Opt_Mult_Groups;

Line 3131: BSC_ANALYSIS_OPTION_PVT.Store_Anal_Opt_Grp_Count(p_kpi_id, l_Anal_Grp_Opt_Tbl);

3127: l_Anal_Opt_Tbl := p_Anal_Opt_Tbl;
3128: FOR table_index in 0..l_Anal_Grp_Opt_Tbl.COUNT-1 LOOP
3129: l_Anal_Grp_Opt_Tbl.DELETE(table_index);
3130: END LOOP;
3131: BSC_ANALYSIS_OPTION_PVT.Store_Anal_Opt_Grp_Count(p_kpi_id, l_Anal_Grp_Opt_Tbl);
3132:
3133: l_old_group_count := l_Anal_Opt_Tbl.COUNT;
3134: l_new_group_count := l_Anal_Grp_Opt_Tbl.COUNT;
3135:

Line 3190: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Synch_Kpi_Anal_Group ';

3186: WHEN NO_DATA_FOUND THEN
3187: ROLLBACK TO BSCSynchKpiAnalGroup;
3188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3189: IF (x_msg_data IS NOT NULL) THEN
3190: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Synch_Kpi_Anal_Group ';
3191: ELSE
3192: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Synch_Kpi_Anal_Group ';
3193: END IF;
3194: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 3192: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Synch_Kpi_Anal_Group ';

3188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3189: IF (x_msg_data IS NOT NULL) THEN
3190: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Synch_Kpi_Anal_Group ';
3191: ELSE
3192: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Synch_Kpi_Anal_Group ';
3193: END IF;
3194: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
3195: RAISE;
3196: WHEN OTHERS THEN

Line 3200: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Synch_Kpi_Anal_Group ';

3196: WHEN OTHERS THEN
3197: ROLLBACK TO BSCSynchKpiAnalGroup;
3198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3199: IF (x_msg_data IS NOT NULL) THEN
3200: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Synch_Kpi_Anal_Group ';
3201: ELSE
3202: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Synch_Kpi_Anal_Group ';
3203: END IF;
3204: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 3202: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Synch_Kpi_Anal_Group ';

3198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3199: IF (x_msg_data IS NOT NULL) THEN
3200: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Synch_Kpi_Anal_Group ';
3201: ELSE
3202: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Synch_Kpi_Anal_Group ';
3203: END IF;
3204: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
3205: RAISE;
3206: END Synch_Kpi_Anal_Group;

Line 3273: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Refresh_Short_Names ';

3269: WHEN NO_DATA_FOUND THEN
3270: ROLLBACK TO AORefreshShortNamesPVT;
3271: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3272: IF (x_msg_data IS NOT NULL) THEN
3273: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Refresh_Short_Names ';
3274: ELSE
3275: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Refresh_Short_Names ';
3276: END IF;
3277: WHEN OTHERS THEN

Line 3275: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Refresh_Short_Names ';

3271: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3272: IF (x_msg_data IS NOT NULL) THEN
3273: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Refresh_Short_Names ';
3274: ELSE
3275: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Refresh_Short_Names ';
3276: END IF;
3277: WHEN OTHERS THEN
3278: ROLLBACK TO AORefreshShortNamesPVT;
3279: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3281: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Refresh_Short_Names ';

3277: WHEN OTHERS THEN
3278: ROLLBACK TO AORefreshShortNamesPVT;
3279: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3280: IF (x_msg_data IS NOT NULL) THEN
3281: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Refresh_Short_Names ';
3282: ELSE
3283: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Refresh_Short_Names ';
3284: END IF;
3285:

Line 3283: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Refresh_Short_Names ';

3279: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
3280: IF (x_msg_data IS NOT NULL) THEN
3281: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Refresh_Short_Names ';
3282: ELSE
3283: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Refresh_Short_Names ';
3284: END IF;
3285:
3286: END Refresh_Short_Names;
3287:

Line 3514: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.checkMeasure ';

3510: IF (c_KpiName%ISOPEN) THEN
3511: CLOSE c_KpiMeasure;
3512: END IF;
3513: IF (x_msg_data IS NOT NULL) THEN
3514: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.checkMeasure ';
3515: ELSE
3516: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.CheckMeasure ';
3517: END IF;
3518: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 3516: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.CheckMeasure ';

3512: END IF;
3513: IF (x_msg_data IS NOT NULL) THEN
3514: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.checkMeasure ';
3515: ELSE
3516: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.CheckMeasure ';
3517: END IF;
3518: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
3519: RAISE;
3520: WHEN OTHERS THEN

Line 3529: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.checkMeasure ';

3525: IF (c_KpiName%ISOPEN) THEN
3526: CLOSE c_KpiMeasure;
3527: END IF;
3528: IF (x_msg_data IS NOT NULL) THEN
3529: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.checkMeasure ';
3530: ELSE
3531: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.checkMeasure ';
3532: END IF;
3533: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 3531: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.checkMeasure ';

3527: END IF;
3528: IF (x_msg_data IS NOT NULL) THEN
3529: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.checkMeasure ';
3530: ELSE
3531: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.checkMeasure ';
3532: END IF;
3533: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
3534: RAISE;
3535: END Validate_Custom_Measure;

Line 3736: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Delete_Data_Series ';

3732: END IF;
3733: ROLLBACK TO DeleteBSCDataSeriesPVT;
3734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3735: IF (x_msg_data IS NOT NULL) THEN
3736: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Delete_Data_Series ';
3737: ELSE
3738: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Delete_Data_Series ';
3739: END IF;
3740: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 3738: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Delete_Data_Series ';

3734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3735: IF (x_msg_data IS NOT NULL) THEN
3736: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Delete_Data_Series ';
3737: ELSE
3738: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Delete_Data_Series ';
3739: END IF;
3740: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
3741: RAISE;
3742:

Line 3868: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Swap_Data_Series_Id ';

3864: , p_data => x_msg_data
3865: );
3866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3867: IF (x_msg_data IS NOT NULL) THEN
3868: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Swap_Data_Series_Id ';
3869: ELSE
3870: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Swap_Data_Series_Id ';
3871: END IF;
3872: RAISE;

Line 3870: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Swap_Data_Series_Id ';

3866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3867: IF (x_msg_data IS NOT NULL) THEN
3868: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Swap_Data_Series_Id ';
3869: ELSE
3870: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Swap_Data_Series_Id ';
3871: END IF;
3872: RAISE;
3873: WHEN OTHERS THEN
3874: IF (c_Data_Series%ISOPEN) THEN

Line 3880: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Swap_Data_Series_Id ';

3876: END IF;
3877: ROLLBACK TO SwapDataSeriesPVT;
3878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3879: IF (x_msg_data IS NOT NULL) THEN
3880: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Swap_Data_Series_Id ';
3881: ELSE
3882: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Swap_Data_Series_Id ';
3883: END IF;
3884: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 3882: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Swap_Data_Series_Id ';

3878: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3879: IF (x_msg_data IS NOT NULL) THEN
3880: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Swap_Data_Series_Id ';
3881: ELSE
3882: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Swap_Data_Series_Id ';
3883: END IF;
3884: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
3885: RAISE;
3886:

Line 4072: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Cascade_Series_Default_Value ';

4068: WHEN NO_DATA_FOUND THEN
4069: ROLLBACK TO CascadedSeriesPVT;
4070: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
4071: IF (x_msg_data IS NOT NULL) THEN
4072: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Cascade_Series_Default_Value ';
4073: ELSE
4074: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Cascade_Series_Default_Value ';
4075: END IF;
4076: RAISE;

Line 4074: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Cascade_Series_Default_Value ';

4070: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
4071: IF (x_msg_data IS NOT NULL) THEN
4072: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Cascade_Series_Default_Value ';
4073: ELSE
4074: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Cascade_Series_Default_Value ';
4075: END IF;
4076: RAISE;
4077: WHEN OTHERS THEN
4078: ROLLBACK TO CascadedSeriesPVT;

Line 4081: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Cascade_Series_Default_Value ';

4077: WHEN OTHERS THEN
4078: ROLLBACK TO CascadedSeriesPVT;
4079: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
4080: IF (x_msg_data IS NOT NULL) THEN
4081: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Cascade_Series_Default_Value ';
4082: ELSE
4083: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Cascade_Series_Default_Value ';
4084: END IF;
4085: RAISE;

Line 4083: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Cascade_Series_Default_Value ';

4079: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
4080: IF (x_msg_data IS NOT NULL) THEN
4081: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Cascade_Series_Default_Value ';
4082: ELSE
4083: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Cascade_Series_Default_Value ';
4084: END IF;
4085: RAISE;
4086: END Cascade_Series_Default_Value;
4087:

Line 4191: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Cascade_Data_Src_Values ';

4187: WHEN NO_DATA_FOUND THEN
4188: ROLLBACK TO CascadedDataSrcPVT;
4189: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
4190: IF (x_msg_data IS NOT NULL) THEN
4191: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Cascade_Data_Src_Values ';
4192: ELSE
4193: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Cascade_Data_Src_Values ';
4194: END IF;
4195: RAISE;

Line 4193: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Cascade_Data_Src_Values ';

4189: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
4190: IF (x_msg_data IS NOT NULL) THEN
4191: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Cascade_Data_Src_Values ';
4192: ELSE
4193: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Cascade_Data_Src_Values ';
4194: END IF;
4195: RAISE;
4196: WHEN OTHERS THEN
4197: ROLLBACK TO CascadedDataSrcPVT;

Line 4200: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Cascade_Data_Src_Values ';

4196: WHEN OTHERS THEN
4197: ROLLBACK TO CascadedDataSrcPVT;
4198: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
4199: IF (x_msg_data IS NOT NULL) THEN
4200: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Cascade_Data_Src_Values ';
4201: ELSE
4202: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Cascade_Data_Src_Values ';
4203: END IF;
4204: RAISE;

Line 4202: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Cascade_Data_Src_Values ';

4198: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
4199: IF (x_msg_data IS NOT NULL) THEN
4200: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Cascade_Data_Src_Values ';
4201: ELSE
4202: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Cascade_Data_Src_Values ';
4203: END IF;
4204: RAISE;
4205: END Cascade_Data_Src_Values;
4206:

Line 4299: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Set_Default_Analysis_Option ';

4295: WHEN OTHERS THEN
4296: ROLLBACK TO SetDftAnalOption;
4297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4298: IF (x_msg_data IS NOT NULL) THEN
4299: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Set_Default_Analysis_Option ';
4300: ELSE
4301: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Set_Default_Analysis_Option ';
4302: END IF;
4303: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 4301: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Set_Default_Analysis_Option ';

4297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4298: IF (x_msg_data IS NOT NULL) THEN
4299: x_msg_data := x_msg_data||' -> BSC_ANALYSIS_OPTION_PVT.Set_Default_Analysis_Option ';
4300: ELSE
4301: x_msg_data := SQLERRM||' at BSC_ANALYSIS_OPTION_PVT.Set_Default_Analysis_Option ';
4302: END IF;
4303: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
4304: RAISE;
4305:

Line 4312: end BSC_ANALYSIS_OPTION_PVT;

4308:
4309: /************************************************************************************
4310: ************************************************************************************/
4311:
4312: end BSC_ANALYSIS_OPTION_PVT;