DBA Data[Home] [Help]

APPS.BSC_KPI_MEASURE_PROPS_PVT dependencies on BSC_KPI_MEASURE_PROPS_PVT

Line 1: PACKAGE BODY BSC_KPI_MEASURE_PROPS_PVT AS

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: ************************************************************************************/

Line 106: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Create_Kpi_Measure_Props ';

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

Line 108: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Create_Kpi_Measure_Props ';

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;

Line 114: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Create_Kpi_Measure_Props ';

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;

Line 116: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.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: /************************************************************************************

Line 237: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Update_Kpi_Measure_Props ';

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

Line 239: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Update_Kpi_Measure_Props ';

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;

Line 245: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Update_Kpi_Measure_Props ';

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;

Line 247: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.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: /************************************************************************************

Line 311: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Delete_Kpi_Measure_Props ';

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

Line 313: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Delete_Kpi_Measure_Props ';

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;

Line 319: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Delete_Kpi_Measure_Props ';

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;

Line 321: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.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: /************************************************************************************

Line 379: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Delete_Obj_Kpi_Measure_Props ';

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

Line 381: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Delete_Obj_Kpi_Measure_Props ';

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;

Line 387: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Delete_Obj_Kpi_Measure_Props ';

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;

Line 389: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.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: /************************************************************************************

Line 474: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PVT.Retrieve_Kpi_Measure_Props ';

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

Line 476: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.Retrieve_Kpi_Measure_Props ';

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

Line 481: x_msg_data := x_msg_data || ' -> 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
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;

Line 483: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PVT.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;

Line 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;