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_WEIGHTS_PUB dependencies on BSC_KPI_MEASURE_WEIGHTS_PUB

Line 1: PACKAGE BODY BSC_KPI_MEASURE_WEIGHTS_PUB AS

1: PACKAGE BODY BSC_KPI_MEASURE_WEIGHTS_PUB AS
2: /* $Header: BSCPKMWB.pls 120.0.12000000.1 2007/07/17 07:44:09 appldev noship $ */
3:
4: /************************************************************************************
5: ************************************************************************************/

Line 8: , p_kpi_measure_weights_rec IN BSC_KPI_MEASURE_WEIGHTS_PUB.kpi_measure_weights_rec

4: /************************************************************************************
5: ************************************************************************************/
6: PROCEDURE Create_Kpi_Measure_Weights (
7: p_commit IN VARCHAR2 := FND_API.G_FALSE
8: , p_kpi_measure_weights_rec IN BSC_KPI_MEASURE_WEIGHTS_PUB.kpi_measure_weights_rec
9: , p_cascade_shared IN BOOLEAN := TRUE
10: , x_return_status OUT NOCOPY VARCHAR2
11: , x_msg_count OUT NOCOPY NUMBER
12: , x_msg_data OUT NOCOPY VARCHAR2

Line 22: l_kpi_measure_weights_rec BSC_KPI_MEASURE_WEIGHTS_PUB.kpi_measure_weights_rec;

18: WHERE source_indicator = p_indicator
19: AND share_flag = 2 -- shared objective.
20: AND prototype_flag <> 2;
21:
22: l_kpi_measure_weights_rec BSC_KPI_MEASURE_WEIGHTS_PUB.kpi_measure_weights_rec;
23: l_kpi_measure_id NUMBER;
24:
25: BEGIN
26:

Line 100: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PUB.Create_Kpi_Measure_Weights ';

96: WHEN NO_DATA_FOUND THEN
97: ROLLBACK TO BscKpiMeasureWeightPub_Create;
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
99: IF (x_msg_data IS NOT NULL) THEN
100: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PUB.Create_Kpi_Measure_Weights ';
101: ELSE
102: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Create_Kpi_Measure_Weights ';
103: END IF;
104: WHEN OTHERS THEN

Line 102: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Create_Kpi_Measure_Weights ';

98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
99: IF (x_msg_data IS NOT NULL) THEN
100: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PUB.Create_Kpi_Measure_Weights ';
101: ELSE
102: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Create_Kpi_Measure_Weights ';
103: END IF;
104: WHEN OTHERS THEN
105: ROLLBACK TO BscKpiMeasureWeightPub_Create;
106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 108: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PUB.Create_Kpi_Measure_Weights ';

104: WHEN OTHERS THEN
105: ROLLBACK TO BscKpiMeasureWeightPub_Create;
106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
107: IF (x_msg_data IS NOT NULL) THEN
108: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PUB.Create_Kpi_Measure_Weights ';
109: ELSE
110: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Create_Kpi_Measure_Weights ';
111: END IF;
112: END Create_Kpi_Measure_Weights;

Line 110: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Create_Kpi_Measure_Weights ';

106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
107: IF (x_msg_data IS NOT NULL) THEN
108: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PUB.Create_Kpi_Measure_Weights ';
109: ELSE
110: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Create_Kpi_Measure_Weights ';
111: END IF;
112: END Create_Kpi_Measure_Weights;
113:
114: /************************************************************************************

Line 118: , p_kpi_measure_weights_rec IN BSC_KPI_MEASURE_WEIGHTS_PUB.kpi_measure_weights_rec

114: /************************************************************************************
115: ************************************************************************************/
116: PROCEDURE Update_Kpi_Measure_Weights (
117: p_commit IN VARCHAR2 := FND_API.G_FALSE
118: , p_kpi_measure_weights_rec IN BSC_KPI_MEASURE_WEIGHTS_PUB.kpi_measure_weights_rec
119: , p_cascade_shared IN BOOLEAN := TRUE
120: , x_return_status OUT NOCOPY VARCHAR2
121: , x_msg_count OUT NOCOPY NUMBER
122: , x_msg_data OUT NOCOPY VARCHAR2

Line 132: l_kpi_measure_weights_rec BSC_KPI_MEASURE_WEIGHTS_PUB.kpi_measure_weights_rec;

128: WHERE source_indicator = p_indicator
129: AND share_flag = 2 -- shared objective.
130: AND prototype_flag <> 2;
131:
132: l_kpi_measure_weights_rec BSC_KPI_MEASURE_WEIGHTS_PUB.kpi_measure_weights_rec;
133: l_kpi_measure_id NUMBER;
134: BEGIN
135:
136: FND_MSG_PUB.Initialize;

Line 209: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PUB.Update_Kpi_Measure_Weights ';

205: WHEN NO_DATA_FOUND THEN
206: ROLLBACK TO BscKpiMeasureWeightPub_Update;
207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
208: IF (x_msg_data IS NOT NULL) THEN
209: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PUB.Update_Kpi_Measure_Weights ';
210: ELSE
211: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Update_Kpi_Measure_Weights ';
212: END IF;
213: WHEN OTHERS THEN

Line 211: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Update_Kpi_Measure_Weights ';

207: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
208: IF (x_msg_data IS NOT NULL) THEN
209: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PUB.Update_Kpi_Measure_Weights ';
210: ELSE
211: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Update_Kpi_Measure_Weights ';
212: END IF;
213: WHEN OTHERS THEN
214: ROLLBACK TO BscKpiMeasureWeightPub_Update;
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 217: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PUB.Update_Kpi_Measure_Weights ';

213: WHEN OTHERS THEN
214: ROLLBACK TO BscKpiMeasureWeightPub_Update;
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
216: IF (x_msg_data IS NOT NULL) THEN
217: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PUB.Update_Kpi_Measure_Weights ';
218: ELSE
219: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Update_Kpi_Measure_Weights ';
220: END IF;
221: END Update_Kpi_Measure_Weights;

Line 219: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Update_Kpi_Measure_Weights ';

215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
216: IF (x_msg_data IS NOT NULL) THEN
217: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PUB.Update_Kpi_Measure_Weights ';
218: ELSE
219: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Update_Kpi_Measure_Weights ';
220: END IF;
221: END Update_Kpi_Measure_Weights;
222:
223: /************************************************************************************

Line 319: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PUB.Del_Kpi_Measure_Weights ';

315: WHEN NO_DATA_FOUND THEN
316: ROLLBACK TO BscKpiMeasureWeightPub_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_WEIGHTS_PUB.Del_Kpi_Measure_Weights ';
320: ELSE
321: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Del_Kpi_Measure_Weights ';
322: END IF;
323: WHEN OTHERS THEN

Line 321: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Del_Kpi_Measure_Weights ';

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_WEIGHTS_PUB.Del_Kpi_Measure_Weights ';
320: ELSE
321: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Del_Kpi_Measure_Weights ';
322: END IF;
323: WHEN OTHERS THEN
324: ROLLBACK TO BscKpiMeasureWeightPub_Delete;
325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 327: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PUB.Del_Kpi_Measure_Weights ';

323: WHEN OTHERS THEN
324: ROLLBACK TO BscKpiMeasureWeightPub_Delete;
325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
326: IF (x_msg_data IS NOT NULL) THEN
327: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PUB.Del_Kpi_Measure_Weights ';
328: ELSE
329: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Del_Kpi_Measure_Weights ';
330: END IF;
331: END Del_Kpi_Measure_Weights;

Line 329: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Del_Kpi_Measure_Weights ';

325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
326: IF (x_msg_data IS NOT NULL) THEN
327: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PUB.Del_Kpi_Measure_Weights ';
328: ELSE
329: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Del_Kpi_Measure_Weights ';
330: END IF;
331: END Del_Kpi_Measure_Weights;
332:
333: /************************************************************************************

Line 415: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PUB.Del_Obj_Kpi_Measure_Weights ';

411: WHEN NO_DATA_FOUND THEN
412: ROLLBACK TO BscKpiMeasureWeightPub_DelAll;
413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
414: IF (x_msg_data IS NOT NULL) THEN
415: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PUB.Del_Obj_Kpi_Measure_Weights ';
416: ELSE
417: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Del_Obj_Kpi_Measure_Weights ';
418: END IF;
419: WHEN OTHERS THEN

Line 417: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Del_Obj_Kpi_Measure_Weights ';

413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
414: IF (x_msg_data IS NOT NULL) THEN
415: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PUB.Del_Obj_Kpi_Measure_Weights ';
416: ELSE
417: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Del_Obj_Kpi_Measure_Weights ';
418: END IF;
419: WHEN OTHERS THEN
420: ROLLBACK TO BscKpiMeasureWeightPub_DelAll;
421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 423: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PUB.Del_Obj_Kpi_Measure_Weights ';

419: WHEN OTHERS THEN
420: ROLLBACK TO BscKpiMeasureWeightPub_DelAll;
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_PUB.Del_Obj_Kpi_Measure_Weights ';
424: ELSE
425: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Del_Obj_Kpi_Measure_Weights ';
426: END IF;
427: END Del_Obj_Kpi_Measure_Weights;

Line 425: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Del_Obj_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_PUB.Del_Obj_Kpi_Measure_Weights ';
424: ELSE
425: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Del_Obj_Kpi_Measure_Weights ';
426: END IF;
427: END Del_Obj_Kpi_Measure_Weights;
428:
429: /************************************************************************************

Line 434: , x_kpi_measure_weights_rec OUT NOCOPY BSC_KPI_MEASURE_WEIGHTS_PUB.kpi_measure_weights_rec

430: ************************************************************************************/
431: PROCEDURE Retrieve_Kpi_Measure_Weights (
432: p_objective_id IN NUMBER
433: , p_kpi_measure_id IN NUMBER
434: , x_kpi_measure_weights_rec OUT NOCOPY BSC_KPI_MEASURE_WEIGHTS_PUB.kpi_measure_weights_rec
435: , x_return_status OUT NOCOPY VARCHAR2
436: , x_msg_count OUT NOCOPY NUMBER
437: , x_msg_data OUT NOCOPY VARCHAR2
438: )

Line 481: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PUB.Retrieve_Kpi_Measure_Weights ';

477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: WHEN NO_DATA_FOUND 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_WEIGHTS_PUB.Retrieve_Kpi_Measure_Weights ';
482: ELSE
483: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Retrieve_Kpi_Measure_Weights ';
484: END IF;
485: WHEN OTHERS THEN

Line 483: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Retrieve_Kpi_Measure_Weights ';

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_WEIGHTS_PUB.Retrieve_Kpi_Measure_Weights ';
482: ELSE
483: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Retrieve_Kpi_Measure_Weights ';
484: END IF;
485: WHEN OTHERS THEN
486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
487: IF (x_msg_data IS NOT NULL) THEN

Line 488: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PUB.Retrieve_Kpi_Measure_Weights ';

484: END IF;
485: WHEN OTHERS THEN
486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
487: IF (x_msg_data IS NOT NULL) THEN
488: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PUB.Retrieve_Kpi_Measure_Weights ';
489: ELSE
490: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Retrieve_Kpi_Measure_Weights ';
491: END IF;
492: END Retrieve_Kpi_Measure_Weights;

Line 490: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Retrieve_Kpi_Measure_Weights ';

486: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
487: IF (x_msg_data IS NOT NULL) THEN
488: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_WEIGHTS_PUB.Retrieve_Kpi_Measure_Weights ';
489: ELSE
490: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Retrieve_Kpi_Measure_Weights ';
491: END IF;
492: END Retrieve_Kpi_Measure_Weights;
493:
494: END BSC_KPI_MEASURE_WEIGHTS_PUB;

Line 494: END BSC_KPI_MEASURE_WEIGHTS_PUB;

490: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_WEIGHTS_PUB.Retrieve_Kpi_Measure_Weights ';
491: END IF;
492: END Retrieve_Kpi_Measure_Weights;
493:
494: END BSC_KPI_MEASURE_WEIGHTS_PUB;