DBA Data[Home] [Help]

APPS.BSC_KPI_MEASURE_WEIGHTS_PVT dependencies on BSC_KPI_MEASURE_WEIGHTS_PVT

Line 1: PACKAGE BODY BSC_KPI_MEASURE_WEIGHTS_PVT AS

1: PACKAGE BODY BSC_KPI_MEASURE_WEIGHTS_PVT AS
2: /* $Header: BSCVKMWB.pls 120.0.12000000.1 2007/07/17 07:44:49 appldev noship $ */
3:
4: /************************************************************************************
5: ************************************************************************************/

Line 82: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Create_Kpi_Measure_Weights ';

78: WHEN NO_DATA_FOUND THEN
79: ROLLBACK TO BscKpiMeasureWeightPvt_Create;
80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
81: IF (x_msg_data IS NOT NULL) THEN
82: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Create_Kpi_Measure_Weights ';
83: ELSE
84: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Create_Kpi_Measure_Weights ';
85: END IF;
86: WHEN OTHERS THEN

Line 84: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Create_Kpi_Measure_Weights ';

80: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
81: IF (x_msg_data IS NOT NULL) THEN
82: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Create_Kpi_Measure_Weights ';
83: ELSE
84: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Create_Kpi_Measure_Weights ';
85: END IF;
86: WHEN OTHERS THEN
87: ROLLBACK TO BscKpiMeasureWeightPvt_Create;
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 90: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Create_Kpi_Measure_Weights ';

86: WHEN OTHERS THEN
87: ROLLBACK TO BscKpiMeasureWeightPvt_Create;
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
89: IF (x_msg_data IS NOT NULL) THEN
90: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Create_Kpi_Measure_Weights ';
91: ELSE
92: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Create_Kpi_Measure_Weights ';
93: END IF;
94: END Create_Kpi_Measure_Weights;

Line 92: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Create_Kpi_Measure_Weights ';

88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
89: IF (x_msg_data IS NOT NULL) THEN
90: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Create_Kpi_Measure_Weights ';
91: ELSE
92: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Create_Kpi_Measure_Weights ';
93: END IF;
94: END Create_Kpi_Measure_Weights;
95:
96: /************************************************************************************

Line 191: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Update_Kpi_Measure_Weights ';

187: WHEN NO_DATA_FOUND THEN
188: ROLLBACK TO BscKpiMeasureWeightPvt_Update;
189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
190: IF (x_msg_data IS NOT NULL) THEN
191: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Update_Kpi_Measure_Weights ';
192: ELSE
193: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Update_Kpi_Measure_Weights ';
194: END IF;
195: WHEN OTHERS THEN

Line 193: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Update_Kpi_Measure_Weights ';

189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
190: IF (x_msg_data IS NOT NULL) THEN
191: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Update_Kpi_Measure_Weights ';
192: ELSE
193: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Update_Kpi_Measure_Weights ';
194: END IF;
195: WHEN OTHERS THEN
196: ROLLBACK TO BscKpiMeasureWeightPvt_Update;
197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 199: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Update_Kpi_Measure_Weights ';

195: WHEN OTHERS THEN
196: ROLLBACK TO BscKpiMeasureWeightPvt_Update;
197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
198: IF (x_msg_data IS NOT NULL) THEN
199: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Update_Kpi_Measure_Weights ';
200: ELSE
201: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Update_Kpi_Measure_Weights ';
202: END IF;
203: END Update_Kpi_Measure_Weights;

Line 201: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Update_Kpi_Measure_Weights ';

197: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
198: IF (x_msg_data IS NOT NULL) THEN
199: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Update_Kpi_Measure_Weights ';
200: ELSE
201: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Update_Kpi_Measure_Weights ';
202: END IF;
203: END Update_Kpi_Measure_Weights;
204:
205: /************************************************************************************

Line 265: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Del_Kpi_Measure_Weights ';

261: WHEN NO_DATA_FOUND THEN
262: ROLLBACK TO BscKpiMeasureWeightPvt_Delete;
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: IF (x_msg_data IS NOT NULL) THEN
265: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Del_Kpi_Measure_Weights ';
266: ELSE
267: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Del_Kpi_Measure_Weights ';
268: END IF;
269: WHEN OTHERS THEN

Line 267: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Del_Kpi_Measure_Weights ';

263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: IF (x_msg_data IS NOT NULL) THEN
265: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Del_Kpi_Measure_Weights ';
266: ELSE
267: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Del_Kpi_Measure_Weights ';
268: END IF;
269: WHEN OTHERS THEN
270: ROLLBACK TO BscKpiMeasureWeightPvt_Delete;
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 273: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Del_Kpi_Measure_Weights ';

269: WHEN OTHERS THEN
270: ROLLBACK TO BscKpiMeasureWeightPvt_Delete;
271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
272: IF (x_msg_data IS NOT NULL) THEN
273: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Del_Kpi_Measure_Weights ';
274: ELSE
275: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Del_Kpi_Measure_Weights ';
276: END IF;
277: END Del_Kpi_Measure_Weights;

Line 275: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Del_Kpi_Measure_Weights ';

271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
272: IF (x_msg_data IS NOT NULL) THEN
273: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Del_Kpi_Measure_Weights ';
274: ELSE
275: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Del_Kpi_Measure_Weights ';
276: END IF;
277: END Del_Kpi_Measure_Weights;
278:
279: /************************************************************************************

Line 333: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Del_Obj_Kpi_Measure_Weights ';

329: WHEN NO_DATA_FOUND THEN
330: ROLLBACK TO BscKpiMeasureWeightPvt_DelAll;
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
332: IF (x_msg_data IS NOT NULL) THEN
333: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Del_Obj_Kpi_Measure_Weights ';
334: ELSE
335: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Del_Obj_Kpi_Measure_Weights ';
336: END IF;
337: WHEN OTHERS THEN

Line 335: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Del_Obj_Kpi_Measure_Weights ';

331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
332: IF (x_msg_data IS NOT NULL) THEN
333: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Del_Obj_Kpi_Measure_Weights ';
334: ELSE
335: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Del_Obj_Kpi_Measure_Weights ';
336: END IF;
337: WHEN OTHERS THEN
338: ROLLBACK TO BscKpiMeasureWeightPvt_DelAll;
339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 341: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Del_Obj_Kpi_Measure_Weights ';

337: WHEN OTHERS THEN
338: ROLLBACK TO BscKpiMeasureWeightPvt_DelAll;
339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
340: IF (x_msg_data IS NOT NULL) THEN
341: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Del_Obj_Kpi_Measure_Weights ';
342: ELSE
343: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Del_Obj_Kpi_Measure_Weights ';
344: END IF;
345: END Del_Obj_Kpi_Measure_Weights;

Line 343: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Del_Obj_Kpi_Measure_Weights ';

339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
340: IF (x_msg_data IS NOT NULL) THEN
341: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Del_Obj_Kpi_Measure_Weights ';
342: ELSE
343: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Del_Obj_Kpi_Measure_Weights ';
344: END IF;
345: END Del_Obj_Kpi_Measure_Weights;
346:
347: /************************************************************************************

Line 416: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Retrieve_Kpi_Measure_Weights ';

412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
413: WHEN NO_DATA_FOUND THEN
414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
415: IF (x_msg_data IS NOT NULL) THEN
416: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Retrieve_Kpi_Measure_Weights ';
417: ELSE
418: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Retrieve_Kpi_Measure_Weights ';
419: END IF;
420: WHEN OTHERS THEN

Line 418: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Retrieve_Kpi_Measure_Weights ';

414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
415: IF (x_msg_data IS NOT NULL) THEN
416: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Retrieve_Kpi_Measure_Weights ';
417: ELSE
418: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Retrieve_Kpi_Measure_Weights ';
419: END IF;
420: WHEN OTHERS THEN
421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
422: IF (x_msg_data IS NOT NULL) THEN

Line 423: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Retrieve_Kpi_Measure_Weights ';

419: END IF;
420: WHEN OTHERS THEN
421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
422: IF (x_msg_data IS NOT NULL) THEN
423: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Retrieve_Kpi_Measure_Weights ';
424: ELSE
425: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Retrieve_Kpi_Measure_Weights ';
426: END IF;
427: END Retrieve_Kpi_Measure_Weights;

Line 425: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Retrieve_Kpi_Measure_Weights ';

421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
422: IF (x_msg_data IS NOT NULL) THEN
423: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PVT.Retrieve_Kpi_Measure_Weights ';
424: ELSE
425: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Retrieve_Kpi_Measure_Weights ';
426: END IF;
427: END Retrieve_Kpi_Measure_Weights;
428:
429: END BSC_KPI_MEASURE_WEIGHTS_PVT;

Line 429: END BSC_KPI_MEASURE_WEIGHTS_PVT;

425: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PVT.Retrieve_Kpi_Measure_Weights ';
426: END IF;
427: END Retrieve_Kpi_Measure_Weights;
428:
429: END BSC_KPI_MEASURE_WEIGHTS_PVT;