DBA Data[Home] [Help]

APPS.BSC_KPI_SERIES_PUB dependencies on BSC_KPI_SERIES_PUB

Line 1: PACKAGE BODY BSC_KPI_SERIES_PUB as

1: PACKAGE BODY BSC_KPI_SERIES_PUB as
2: /* $Header: BSCPSERB.pls 120.1.12000000.2 2007/07/27 10:04:25 akoduri noship $ */
3:
4:
5: /************************************************************************************

Line 147: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Check_Color_Props ';

143: WHEN NO_DATA_FOUND THEN
144: ROLLBACK TO Check_Color_Props_PUB;
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146: IF (x_msg_data IS NOT NULL) THEN
147: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Check_Color_Props ';
148: ELSE
149: x_msg_data := SQLERRM||'BSC_KPI_SERIES_PUB.Check_Color_Props ';
150: END IF;
151: WHEN OTHERS THEN

Line 149: x_msg_data := SQLERRM||'BSC_KPI_SERIES_PUB.Check_Color_Props ';

145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146: IF (x_msg_data IS NOT NULL) THEN
147: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Check_Color_Props ';
148: ELSE
149: x_msg_data := SQLERRM||'BSC_KPI_SERIES_PUB.Check_Color_Props ';
150: END IF;
151: WHEN OTHERS THEN
152: ROLLBACK TO Check_Color_Props_PUB;
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 155: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Check_Color_Props ';

151: WHEN OTHERS THEN
152: ROLLBACK TO Check_Color_Props_PUB;
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
154: IF (x_msg_data IS NOT NULL) THEN
155: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Check_Color_Props ';
156: ELSE
157: x_msg_data := SQLERRM||' at BSC_KPI_SERIES_PUB.Check_Color_Props ';
158: END IF;
159: END Check_Color_Props;

Line 157: x_msg_data := SQLERRM||' at BSC_KPI_SERIES_PUB.Check_Color_Props ';

153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
154: IF (x_msg_data IS NOT NULL) THEN
155: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Check_Color_Props ';
156: ELSE
157: x_msg_data := SQLERRM||' at BSC_KPI_SERIES_PUB.Check_Color_Props ';
158: END IF;
159: END Check_Color_Props;
160:
161: /************************************************************************************

Line 304: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Save_Default_Calculation ';

300: WHEN NO_DATA_FOUND THEN
301: ROLLBACK TO Save_Default_Calculation_PUB;
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303: IF (x_msg_data IS NOT NULL) THEN
304: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Save_Default_Calculation ';
305: ELSE
306: x_msg_data := SQLERRM||'BSC_KPI_SERIES_PUB.Save_Default_Calculation ';
307: END IF;
308: WHEN OTHERS THEN

Line 306: x_msg_data := SQLERRM||'BSC_KPI_SERIES_PUB.Save_Default_Calculation ';

302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303: IF (x_msg_data IS NOT NULL) THEN
304: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Save_Default_Calculation ';
305: ELSE
306: x_msg_data := SQLERRM||'BSC_KPI_SERIES_PUB.Save_Default_Calculation ';
307: END IF;
308: WHEN OTHERS THEN
309: ROLLBACK TO Save_Default_Calculation_PUB;
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 312: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Save_Default_Calculation ';

308: WHEN OTHERS THEN
309: ROLLBACK TO Save_Default_Calculation_PUB;
310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
311: IF (x_msg_data IS NOT NULL) THEN
312: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Save_Default_Calculation ';
313: ELSE
314: x_msg_data := SQLERRM||' at BSC_KPI_SERIES_PUB.Save_Default_Calculation ';
315: END IF;
316: END Save_Default_Calculation;

Line 314: x_msg_data := SQLERRM||' at BSC_KPI_SERIES_PUB.Save_Default_Calculation ';

310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
311: IF (x_msg_data IS NOT NULL) THEN
312: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Save_Default_Calculation ';
313: ELSE
314: x_msg_data := SQLERRM||' at BSC_KPI_SERIES_PUB.Save_Default_Calculation ';
315: END IF;
316: END Save_Default_Calculation;
317:
318: /************************************************************************************

Line 472: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Update_Color_Structure_Flags ';

468: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
469: WHEN OTHERS THEN
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
471: IF (x_msg_data IS NOT NULL) THEN
472: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Update_Color_Structure_Flags ';
473: ELSE
474: x_msg_data := SQLERRM||' at BSC_KPI_SERIES_PUB.Update_Color_Structure_Flags ';
475: END IF;
476: END Update_Color_Structure_Flags;

Line 474: x_msg_data := SQLERRM||' at BSC_KPI_SERIES_PUB.Update_Color_Structure_Flags ';

470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
471: IF (x_msg_data IS NOT NULL) THEN
472: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Update_Color_Structure_Flags ';
473: ELSE
474: x_msg_data := SQLERRM||' at BSC_KPI_SERIES_PUB.Update_Color_Structure_Flags ';
475: END IF;
476: END Update_Color_Structure_Flags;
477:
478: /************************************************************************************

Line 740: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Create_Analysis_Measure_UI ';

736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
737: WHEN NO_DATA_FOUND THEN
738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
739: IF (x_msg_data IS NOT NULL) THEN
740: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Create_Analysis_Measure_UI ';
741: ELSE
742: x_msg_data := SQLERRM||'BSC_KPI_SERIES_PUB.Create_Analysis_Measure_UI ';
743: END IF;
744: WHEN OTHERS THEN

Line 742: x_msg_data := SQLERRM||'BSC_KPI_SERIES_PUB.Create_Analysis_Measure_UI ';

738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
739: IF (x_msg_data IS NOT NULL) THEN
740: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Create_Analysis_Measure_UI ';
741: ELSE
742: x_msg_data := SQLERRM||'BSC_KPI_SERIES_PUB.Create_Analysis_Measure_UI ';
743: END IF;
744: WHEN OTHERS THEN
745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
746: IF (x_msg_data IS NOT NULL) THEN

Line 747: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Create_Analysis_Measure_UI ';

743: END IF;
744: WHEN OTHERS THEN
745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
746: IF (x_msg_data IS NOT NULL) THEN
747: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Create_Analysis_Measure_UI ';
748: ELSE
749: x_msg_data := SQLERRM||' at BSC_KPI_SERIES_PUB.Create_Analysis_Measure_UI ';
750: END IF;
751: END Create_Analysis_Measure_UI;

Line 749: x_msg_data := SQLERRM||' at BSC_KPI_SERIES_PUB.Create_Analysis_Measure_UI ';

745: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
746: IF (x_msg_data IS NOT NULL) THEN
747: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Create_Analysis_Measure_UI ';
748: ELSE
749: x_msg_data := SQLERRM||' at BSC_KPI_SERIES_PUB.Create_Analysis_Measure_UI ';
750: END IF;
751: END Create_Analysis_Measure_UI;
752:
753: /************************************************************************************

Line 1047: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Update_Analysis_Measure_UI ';

1043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1044: WHEN NO_DATA_FOUND THEN
1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1046: IF (x_msg_data IS NOT NULL) THEN
1047: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Update_Analysis_Measure_UI ';
1048: ELSE
1049: x_msg_data := SQLERRM||'BSC_KPI_SERIES_PUB.Update_Analysis_Measure_UI ';
1050: END IF;
1051: WHEN OTHERS THEN

Line 1049: x_msg_data := SQLERRM||'BSC_KPI_SERIES_PUB.Update_Analysis_Measure_UI ';

1045: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1046: IF (x_msg_data IS NOT NULL) THEN
1047: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Update_Analysis_Measure_UI ';
1048: ELSE
1049: x_msg_data := SQLERRM||'BSC_KPI_SERIES_PUB.Update_Analysis_Measure_UI ';
1050: END IF;
1051: WHEN OTHERS THEN
1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1053: IF (x_msg_data IS NOT NULL) THEN

Line 1054: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Update_Analysis_Measure_UI ';

1050: END IF;
1051: WHEN OTHERS THEN
1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1053: IF (x_msg_data IS NOT NULL) THEN
1054: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Update_Analysis_Measure_UI ';
1055: ELSE
1056: x_msg_data := SQLERRM||' at BSC_KPI_SERIES_PUB.Update_Analysis_Measure_UI ';
1057: END IF;
1058: END Update_Analysis_Measure_UI;

Line 1056: x_msg_data := SQLERRM||' at BSC_KPI_SERIES_PUB.Update_Analysis_Measure_UI ';

1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1053: IF (x_msg_data IS NOT NULL) THEN
1054: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Update_Analysis_Measure_UI ';
1055: ELSE
1056: x_msg_data := SQLERRM||' at BSC_KPI_SERIES_PUB.Update_Analysis_Measure_UI ';
1057: END IF;
1058: END Update_Analysis_Measure_UI;
1059:
1060: /************************************************************************************

Line 1250: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Delete_Analysis_Measure_UI ';

1246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1247: WHEN NO_DATA_FOUND THEN
1248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1249: IF (x_msg_data IS NOT NULL) THEN
1250: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Delete_Analysis_Measure_UI ';
1251: ELSE
1252: x_msg_data := SQLERRM||'BSC_KPI_SERIES_PUB.Delete_Analysis_Measure_UI ';
1253: END IF;
1254: WHEN OTHERS THEN

Line 1252: x_msg_data := SQLERRM||'BSC_KPI_SERIES_PUB.Delete_Analysis_Measure_UI ';

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

Line 1257: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Delete_Analysis_Measure_UI ';

1253: END IF;
1254: WHEN OTHERS THEN
1255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1256: IF (x_msg_data IS NOT NULL) THEN
1257: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Delete_Analysis_Measure_UI ';
1258: ELSE
1259: x_msg_data := SQLERRM||' at BSC_KPI_SERIES_PUB.Delete_Analysis_Measure_UI ';
1260: END IF;
1261: END Delete_Analysis_Measure_UI;

Line 1259: x_msg_data := SQLERRM||' at BSC_KPI_SERIES_PUB.Delete_Analysis_Measure_UI ';

1255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1256: IF (x_msg_data IS NOT NULL) THEN
1257: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Delete_Analysis_Measure_UI ';
1258: ELSE
1259: x_msg_data := SQLERRM||' at BSC_KPI_SERIES_PUB.Delete_Analysis_Measure_UI ';
1260: END IF;
1261: END Delete_Analysis_Measure_UI;
1262:
1263: /************************************************************************************

Line 1349: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Populate_Kpi_Series_Colors ';

1345: WHEN NO_DATA_FOUND THEN
1346: ROLLBACK TO Pop_Kpi_Series_PUB;
1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1348: IF (x_msg_data IS NOT NULL) THEN
1349: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Populate_Kpi_Series_Colors ';
1350: ELSE
1351: x_msg_data := SQLERRM||'BSC_KPI_SERIES_PUB.Populate_Kpi_Series_Colors ';
1352: END IF;
1353: WHEN OTHERS THEN

Line 1351: x_msg_data := SQLERRM||'BSC_KPI_SERIES_PUB.Populate_Kpi_Series_Colors ';

1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1348: IF (x_msg_data IS NOT NULL) THEN
1349: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Populate_Kpi_Series_Colors ';
1350: ELSE
1351: x_msg_data := SQLERRM||'BSC_KPI_SERIES_PUB.Populate_Kpi_Series_Colors ';
1352: END IF;
1353: WHEN OTHERS THEN
1354: ROLLBACK TO Pop_Kpi_Series_PUB;
1355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1357: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Populate_Kpi_Series_Colors ';

1353: WHEN OTHERS THEN
1354: ROLLBACK TO Pop_Kpi_Series_PUB;
1355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1356: IF (x_msg_data IS NOT NULL) THEN
1357: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Populate_Kpi_Series_Colors ';
1358: ELSE
1359: x_msg_data := SQLERRM||' at BSC_KPI_SERIES_PUB.Populate_Kpi_Series_Colors ';
1360: END IF;
1361: END Populate_Kpi_Series_Colors;

Line 1359: x_msg_data := SQLERRM||' at BSC_KPI_SERIES_PUB.Populate_Kpi_Series_Colors ';

1355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1356: IF (x_msg_data IS NOT NULL) THEN
1357: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Populate_Kpi_Series_Colors ';
1358: ELSE
1359: x_msg_data := SQLERRM||' at BSC_KPI_SERIES_PUB.Populate_Kpi_Series_Colors ';
1360: END IF;
1361: END Populate_Kpi_Series_Colors;
1362:
1363: /************************************************************************************

Line 1420: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Delete_Kpi_Series_Colors ';

1416: WHEN NO_DATA_FOUND THEN
1417: ROLLBACK TO Delete_Kpi_SeriesColor_PUB;
1418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1419: IF (x_msg_data IS NOT NULL) THEN
1420: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Delete_Kpi_Series_Colors ';
1421: ELSE
1422: x_msg_data := SQLERRM||'BSC_KPI_SERIES_PUB.Delete_Kpi_Series_Colors ';
1423: END IF;
1424: WHEN OTHERS THEN

Line 1422: x_msg_data := SQLERRM||'BSC_KPI_SERIES_PUB.Delete_Kpi_Series_Colors ';

1418: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1419: IF (x_msg_data IS NOT NULL) THEN
1420: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Delete_Kpi_Series_Colors ';
1421: ELSE
1422: x_msg_data := SQLERRM||'BSC_KPI_SERIES_PUB.Delete_Kpi_Series_Colors ';
1423: END IF;
1424: WHEN OTHERS THEN
1425: ROLLBACK TO Delete_Kpi_SeriesColor_PUB;
1426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1428: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Delete_Kpi_Series_Colors ';

1424: WHEN OTHERS THEN
1425: ROLLBACK TO Delete_Kpi_SeriesColor_PUB;
1426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1427: IF (x_msg_data IS NOT NULL) THEN
1428: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Delete_Kpi_Series_Colors ';
1429: ELSE
1430: x_msg_data := SQLERRM||' at BSC_KPI_SERIES_PUB.Delete_Kpi_Series_Colors ';
1431: END IF;
1432:

Line 1430: x_msg_data := SQLERRM||' at BSC_KPI_SERIES_PUB.Delete_Kpi_Series_Colors ';

1426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1427: IF (x_msg_data IS NOT NULL) THEN
1428: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Delete_Kpi_Series_Colors ';
1429: ELSE
1430: x_msg_data := SQLERRM||' at BSC_KPI_SERIES_PUB.Delete_Kpi_Series_Colors ';
1431: END IF;
1432:
1433: END Delete_Kpi_Series_Colors;
1434:

Line 1721: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Check_Series_Structure_Change ';

1717: x_return_status := FND_API.G_RET_STS_ERROR;
1718: WHEN OTHERS THEN
1719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1720: IF (x_msg_data IS NOT NULL) THEN
1721: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Check_Series_Structure_Change ';
1722: ELSE
1723: x_msg_data := SQLERRM||'BSC_KPI_SERIES_PUB.Check_Series_Structure_Change ';
1724: END IF;
1725: END Check_Series_Structure_Change;

Line 1723: x_msg_data := SQLERRM||'BSC_KPI_SERIES_PUB.Check_Series_Structure_Change ';

1719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1720: IF (x_msg_data IS NOT NULL) THEN
1721: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Check_Series_Structure_Change ';
1722: ELSE
1723: x_msg_data := SQLERRM||'BSC_KPI_SERIES_PUB.Check_Series_Structure_Change ';
1724: END IF;
1725: END Check_Series_Structure_Change;
1726:
1727: /************************************************************************************

Line 1803: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Update_Kpi_Time_Stamp ';

1799: WHEN OTHERS THEN
1800: ROLLBACK TO ObjKpiTimeStampPUB;
1801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1802: IF (x_msg_data IS NOT NULL) THEN
1803: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Update_Kpi_Time_Stamp ';
1804: ELSE
1805: x_msg_data := SQLERRM||' at BSC_KPI_SERIES_PUB.Update_Kpi_Time_Stamp ';
1806: END IF;
1807: END Update_Kpi_Time_Stamp;

Line 1805: x_msg_data := SQLERRM||' at BSC_KPI_SERIES_PUB.Update_Kpi_Time_Stamp ';

1801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1802: IF (x_msg_data IS NOT NULL) THEN
1803: x_msg_data := x_msg_data||' ->BSC_KPI_SERIES_PUB.Update_Kpi_Time_Stamp ';
1804: ELSE
1805: x_msg_data := SQLERRM||' at BSC_KPI_SERIES_PUB.Update_Kpi_Time_Stamp ';
1806: END IF;
1807: END Update_Kpi_Time_Stamp;
1808:
1809: END BSC_KPI_SERIES_PUB;

Line 1809: END BSC_KPI_SERIES_PUB;

1805: x_msg_data := SQLERRM||' at BSC_KPI_SERIES_PUB.Update_Kpi_Time_Stamp ';
1806: END IF;
1807: END Update_Kpi_Time_Stamp;
1808:
1809: END BSC_KPI_SERIES_PUB;