1: PACKAGE BODY BSC_KPI_MEASURE_PROPS_PVT AS
2: /* $Header: BSCVKMPB.pls 120.1.12000000.1 2007/07/17 07:44:45 appldev noship $ */
3:
4: /************************************************************************************
5: ************************************************************************************/
102: WHEN NO_DATA_FOUND THEN
103: ROLLBACK TO BscKpiMeasurePvt_Create;
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105: IF (x_msg_data IS NOT NULL) THEN
106: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Create_Kpi_Measure_Props ';
107: ELSE
108: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Create_Kpi_Measure_Props ';
109: END IF;
110: WHEN OTHERS THEN
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105: IF (x_msg_data IS NOT NULL) THEN
106: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Create_Kpi_Measure_Props ';
107: ELSE
108: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Create_Kpi_Measure_Props ';
109: END IF;
110: WHEN OTHERS THEN
111: ROLLBACK TO BscKpiMeasurePvt_Create;
112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
110: WHEN OTHERS THEN
111: ROLLBACK TO BscKpiMeasurePvt_Create;
112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
113: IF (x_msg_data IS NOT NULL) THEN
114: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Create_Kpi_Measure_Props ';
115: ELSE
116: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Create_Kpi_Measure_Props ';
117: END IF;
118: END Create_Kpi_Measure_Props;
112: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
113: IF (x_msg_data IS NOT NULL) THEN
114: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Create_Kpi_Measure_Props ';
115: ELSE
116: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Create_Kpi_Measure_Props ';
117: END IF;
118: END Create_Kpi_Measure_Props;
119:
120: /************************************************************************************
233: WHEN NO_DATA_FOUND THEN
234: ROLLBACK TO BscKpiMeasurePvt_Update;
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236: IF (x_msg_data IS NOT NULL) THEN
237: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Update_Kpi_Measure_Props ';
238: ELSE
239: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Update_Kpi_Measure_Props ';
240: END IF;
241: WHEN OTHERS THEN
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236: IF (x_msg_data IS NOT NULL) THEN
237: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Update_Kpi_Measure_Props ';
238: ELSE
239: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Update_Kpi_Measure_Props ';
240: END IF;
241: WHEN OTHERS THEN
242: ROLLBACK TO BscKpiMeasurePvt_Update;
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
241: WHEN OTHERS THEN
242: ROLLBACK TO BscKpiMeasurePvt_Update;
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
244: IF (x_msg_data IS NOT NULL) THEN
245: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Update_Kpi_Measure_Props ';
246: ELSE
247: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Update_Kpi_Measure_Props ';
248: END IF;
249: END Update_Kpi_Measure_Props;
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
244: IF (x_msg_data IS NOT NULL) THEN
245: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Update_Kpi_Measure_Props ';
246: ELSE
247: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Update_Kpi_Measure_Props ';
248: END IF;
249: END Update_Kpi_Measure_Props;
250:
251: /************************************************************************************
307: WHEN NO_DATA_FOUND THEN
308: ROLLBACK TO BscKpiMeasurePvt_Delete;
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
310: IF (x_msg_data IS NOT NULL) THEN
311: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Delete_Kpi_Measure_Props ';
312: ELSE
313: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Delete_Kpi_Measure_Props ';
314: END IF;
315: WHEN OTHERS THEN
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
310: IF (x_msg_data IS NOT NULL) THEN
311: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Delete_Kpi_Measure_Props ';
312: ELSE
313: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Delete_Kpi_Measure_Props ';
314: END IF;
315: WHEN OTHERS THEN
316: ROLLBACK TO BscKpiMeasurePvt_Delete;
317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
315: WHEN OTHERS THEN
316: ROLLBACK TO BscKpiMeasurePvt_Delete;
317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
318: IF (x_msg_data IS NOT NULL) THEN
319: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Delete_Kpi_Measure_Props ';
320: ELSE
321: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Delete_Kpi_Measure_Props ';
322: END IF;
323: END Delete_Kpi_Measure_Props;
317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
318: IF (x_msg_data IS NOT NULL) THEN
319: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Delete_Kpi_Measure_Props ';
320: ELSE
321: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Delete_Kpi_Measure_Props ';
322: END IF;
323: END Delete_Kpi_Measure_Props;
324:
325: /************************************************************************************
375: WHEN NO_DATA_FOUND THEN
376: ROLLBACK TO BscKpiMeasurePvt_DeleteAll;
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378: IF (x_msg_data IS NOT NULL) THEN
379: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Delete_Obj_Kpi_Measure_Props ';
380: ELSE
381: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Delete_Obj_Kpi_Measure_Props ';
382: END IF;
383: WHEN OTHERS THEN
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378: IF (x_msg_data IS NOT NULL) THEN
379: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Delete_Obj_Kpi_Measure_Props ';
380: ELSE
381: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Delete_Obj_Kpi_Measure_Props ';
382: END IF;
383: WHEN OTHERS THEN
384: ROLLBACK TO BscKpiMeasurePvt_DeleteAll;
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
383: WHEN OTHERS THEN
384: ROLLBACK TO BscKpiMeasurePvt_DeleteAll;
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: IF (x_msg_data IS NOT NULL) THEN
387: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Delete_Obj_Kpi_Measure_Props ';
388: ELSE
389: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Delete_Obj_Kpi_Measure_Props ';
390: END IF;
391: END Delete_Obj_Kpi_Measure_Props;
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: IF (x_msg_data IS NOT NULL) THEN
387: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Delete_Obj_Kpi_Measure_Props ';
388: ELSE
389: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Delete_Obj_Kpi_Measure_Props ';
390: END IF;
391: END Delete_Obj_Kpi_Measure_Props;
392:
393: /************************************************************************************
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
471: WHEN NO_DATA_FOUND THEN
472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
473: IF (x_msg_data IS NOT NULL) THEN
474: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Retrieve_Kpi_Measure_Props ';
475: ELSE
476: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Retrieve_Kpi_Measure_Props ';
477: END IF;
478: WHEN OTHERS THEN
472: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
473: IF (x_msg_data IS NOT NULL) THEN
474: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Retrieve_Kpi_Measure_Props ';
475: ELSE
476: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Retrieve_Kpi_Measure_Props ';
477: END IF;
478: WHEN OTHERS THEN
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
480: IF (x_msg_data IS NOT NULL) THEN
477: END IF;
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_KPI_MEASURE_PROPS_PVT.Retrieve_Kpi_Measure_Props ';
482: ELSE
483: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Retrieve_Kpi_Measure_Props ';
484: END IF;
485: END Retrieve_Kpi_Measure_Props;
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_KPI_MEASURE_PROPS_PVT.Retrieve_Kpi_Measure_Props ';
482: ELSE
483: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Retrieve_Kpi_Measure_Props ';
484: END IF;
485: END Retrieve_Kpi_Measure_Props;
486:
487: END BSC_KPI_MEASURE_PROPS_PVT;
483: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Retrieve_Kpi_Measure_Props ';
484: END IF;
485: END Retrieve_Kpi_Measure_Props;
486:
487: END BSC_KPI_MEASURE_PROPS_PVT;