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_KPI_MEASURE_PROPS_PVT dependencies on BSC_KPI_MEASURE_PROPS

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 8: , p_kpi_measure_rec IN BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec

4: /************************************************************************************
5: ************************************************************************************/
6: PROCEDURE Create_Kpi_Measure_Props (
7: p_commit IN VARCHAR2 := FND_API.G_FALSE
8: , p_kpi_measure_rec IN BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec
9: , x_return_status OUT NOCOPY VARCHAR2
10: , x_msg_count OUT NOCOPY NUMBER
11: , x_msg_data OUT NOCOPY VARCHAR2
12: )

Line 32: FROM bsc_kpi_measure_props

28: FND_MSG_PUB.ADD;
29: RAISE FND_API.G_EXC_ERROR;
30: ELSE
31: SELECT COUNT(1) INTO l_count
32: FROM bsc_kpi_measure_props
33: WHERE indicator = p_kpi_measure_rec.objective_id
34: AND kpi_measure_id = p_kpi_measure_rec.kpi_measure_id;
35: IF (l_count > 0) THEN
36: FND_MESSAGE.SET_NAME('BSC','BSC_OBJ_KPIMEASURE_EXISTS');

Line 44: INSERT INTO bsc_kpi_measure_props

40: RAISE FND_API.G_EXC_ERROR;
41: END IF;
42: END IF;
43:
44: INSERT INTO bsc_kpi_measure_props
45: ( indicator
46: , kpi_measure_id
47: , prototype_color_id
48: , prototype_trend_id

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 124: , p_kpi_measure_rec IN BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec

120: /************************************************************************************
121: ************************************************************************************/
122: PROCEDURE Update_Kpi_Measure_Props (
123: p_commit IN VARCHAR2 := FND_API.G_FALSE
124: , p_kpi_measure_rec IN BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec
125: , x_return_status OUT NOCOPY VARCHAR2
126: , x_msg_count OUT NOCOPY NUMBER
127: , x_msg_data OUT NOCOPY VARCHAR2
128: )

Line 130: l_kpi_measure_rec BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec;

126: , x_msg_count OUT NOCOPY NUMBER
127: , x_msg_data OUT NOCOPY VARCHAR2
128: )
129: IS
130: l_kpi_measure_rec BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec;
131: BEGIN
132: FND_MSG_PUB.Initialize;
133: x_return_status := FND_API.G_RET_STS_SUCCESS;
134:

Line 194: UPDATE bsc_kpi_measure_props

190: ELSE
191: l_kpi_measure_rec.last_update_login := p_kpi_measure_rec.last_update_login;
192: END IF;
193:
194: UPDATE bsc_kpi_measure_props
195: SET prototype_color_id = l_kpi_measure_rec.prototype_color
196: , prototype_trend_id = l_kpi_measure_rec.prototype_trend
197: , color_by_total = l_kpi_measure_rec.color_by_total
198: , disable_color = l_kpi_measure_rec.disable_color

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 278: DELETE FROM bsc_kpi_measure_props

274: FND_MSG_PUB.ADD;
275: RAISE FND_API.G_EXC_ERROR;
276: END IF;
277:
278: DELETE FROM bsc_kpi_measure_props
279: WHERE indicator = p_objective_id
280: AND kpi_measure_id = p_kpi_measure_id;
281:
282: IF (p_commit = FND_API.G_TRUE) THEN

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 347: DELETE FROM bsc_kpi_measure_props

343: FND_MSG_PUB.ADD;
344: RAISE FND_API.G_EXC_ERROR;
345: END IF;
346:
347: DELETE FROM bsc_kpi_measure_props
348: WHERE indicator = p_objective_id;
349:
350: IF (p_commit = FND_API.G_TRUE) THEN
351: COMMIT;

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 398: , x_kpi_measure_rec OUT NOCOPY BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec

394: ************************************************************************************/
395: PROCEDURE Retrieve_Kpi_Measure_Props (
396: p_objective_id IN NUMBER
397: , p_kpi_measure_id IN NUMBER
398: , x_kpi_measure_rec OUT NOCOPY BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec
399: , x_return_status OUT NOCOPY VARCHAR2
400: , x_msg_count OUT NOCOPY NUMBER
401: , x_msg_data OUT NOCOPY VARCHAR2
402: )

Line 448: FROM bsc_kpi_measure_props

444: , x_kpi_measure_rec.created_by
445: , x_kpi_measure_rec.last_update_date
446: , x_kpi_measure_rec.last_updated_by
447: , x_kpi_measure_rec.last_update_login
448: FROM bsc_kpi_measure_props
449: WHERE indicator = p_objective_id
450: AND kpi_measure_id = p_kpi_measure_id;
451:
452: EXCEPTION

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;