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_PUB dependencies on BSC_KPI_MEASURE_PROPS_PUB

Line 1: PACKAGE BODY BSC_KPI_MEASURE_PROPS_PUB AS

1: PACKAGE BODY BSC_KPI_MEASURE_PROPS_PUB AS
2: /* $Header: BSCPKMPB.pls 120.3 2008/04/24 06:34:34 bijain noship $ */
3:
4:
5: FUNCTION get_shared_obj_kpi_measure (

Line 78: , p_kpi_measure_rec IN BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec

74: /************************************************************************************
75: ************************************************************************************/
76: PROCEDURE Create_Kpi_Measure_Props (
77: p_commit IN VARCHAR2 := FND_API.G_FALSE
78: , p_kpi_measure_rec IN BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec
79: , p_cascade_shared IN BOOLEAN := TRUE
80: , x_return_status OUT NOCOPY VARCHAR2
81: , x_msg_count OUT NOCOPY NUMBER
82: , x_msg_data OUT NOCOPY VARCHAR2

Line 92: l_kpi_measure_rec BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec;

88: WHERE source_indicator = p_indicator
89: AND share_flag = 2 -- shared objective.
90: AND prototype_flag <> 2;
91:
92: l_kpi_measure_rec BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec;
93: l_kpi_measure_id NUMBER;
94:
95: BEGIN
96:

Line 171: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Create_Kpi_Measure_Props ';

167: WHEN NO_DATA_FOUND THEN
168: ROLLBACK TO BscKpiMeasurePub_Create;
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
170: IF (x_msg_data IS NOT NULL) THEN
171: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Create_Kpi_Measure_Props ';
172: ELSE
173: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Create_Kpi_Measure_Props ';
174: END IF;
175: WHEN OTHERS THEN

Line 173: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Create_Kpi_Measure_Props ';

169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
170: IF (x_msg_data IS NOT NULL) THEN
171: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Create_Kpi_Measure_Props ';
172: ELSE
173: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Create_Kpi_Measure_Props ';
174: END IF;
175: WHEN OTHERS THEN
176: ROLLBACK TO BscKpiMeasurePub_Create;
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 179: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Create_Kpi_Measure_Props ';

175: WHEN OTHERS THEN
176: ROLLBACK TO BscKpiMeasurePub_Create;
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: IF (x_msg_data IS NOT NULL) THEN
179: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Create_Kpi_Measure_Props ';
180: ELSE
181: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Create_Kpi_Measure_Props ';
182: END IF;
183: END Create_Kpi_Measure_Props;

Line 181: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Create_Kpi_Measure_Props ';

177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: IF (x_msg_data IS NOT NULL) THEN
179: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Create_Kpi_Measure_Props ';
180: ELSE
181: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Create_Kpi_Measure_Props ';
182: END IF;
183: END Create_Kpi_Measure_Props;
184:
185: /************************************************************************************

Line 204: l_kpi_measure_rec BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec;

200: WHERE source_indicator = p_indicator
201: AND share_flag = 2 -- shared objective.
202: AND prototype_flag <> 2;
203:
204: l_kpi_measure_rec BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec;
205: l_kpi_measure_id NUMBER;
206: l_short_name VARCHAR2(30);
207: l_config_type BSC_KPIS_B.CONFIG_TYPE%TYPE;
208: BEGIN

Line 311: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Create_Default_Kpi_Meas_Props ';

307: WHEN NO_DATA_FOUND THEN
308: ROLLBACK TO BscKpiMeasurePub_CreateDef;
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_PUB.Create_Default_Kpi_Meas_Props ';
312: ELSE
313: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Create_Default_Kpi_Meas_Props ';
314: END IF;
315: WHEN OTHERS THEN

Line 313: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Create_Default_Kpi_Meas_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_PUB.Create_Default_Kpi_Meas_Props ';
312: ELSE
313: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Create_Default_Kpi_Meas_Props ';
314: END IF;
315: WHEN OTHERS THEN
316: ROLLBACK TO BscKpiMeasurePub_CreateDef;
317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 319: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Create_Default_Kpi_Meas_Props ';

315: WHEN OTHERS THEN
316: ROLLBACK TO BscKpiMeasurePub_CreateDef;
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_PUB.Create_Default_Kpi_Meas_Props ';
320: ELSE
321: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Create_Default_Kpi_Meas_Props ';
322: END IF;
323: END Create_Default_Kpi_Meas_Props;

Line 321: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Create_Default_Kpi_Meas_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_PUB.Create_Default_Kpi_Meas_Props ';
320: ELSE
321: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Create_Default_Kpi_Meas_Props ';
322: END IF;
323: END Create_Default_Kpi_Meas_Props;
324:
325: /************************************************************************************

Line 329: , p_kpi_measure_rec IN BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec

325: /************************************************************************************
326: ************************************************************************************/
327: PROCEDURE Update_Kpi_Measure_Props (
328: p_commit IN VARCHAR2 := FND_API.G_FALSE
329: , p_kpi_measure_rec IN BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec
330: , p_cascade_shared IN BOOLEAN := TRUE
331: , x_return_status OUT NOCOPY VARCHAR2
332: , x_msg_count OUT NOCOPY NUMBER
333: , x_msg_data OUT NOCOPY VARCHAR2

Line 343: l_kpi_measure_rec BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec;

339: WHERE source_indicator = p_indicator
340: AND share_flag = 2 -- shared objective.
341: AND prototype_flag <> 2;
342:
343: l_kpi_measure_rec BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec;
344: l_kpi_measure_id NUMBER;
345:
346: BEGIN
347:

Line 421: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props ';

417: WHEN NO_DATA_FOUND THEN
418: ROLLBACK TO BscKpiMeasurePub_Update;
419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
420: IF (x_msg_data IS NOT NULL) THEN
421: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props ';
422: ELSE
423: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props ';
424: END IF;
425: WHEN OTHERS THEN

Line 423: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props ';

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

Line 429: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props ';

425: WHEN OTHERS THEN
426: ROLLBACK TO BscKpiMeasurePub_Update;
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: IF (x_msg_data IS NOT NULL) THEN
429: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props ';
430: ELSE
431: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props ';
432: END IF;
433: END Update_Kpi_Measure_Props;

Line 431: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props ';

427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: IF (x_msg_data IS NOT NULL) THEN
429: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props ';
430: ELSE
431: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props ';
432: END IF;
433: END Update_Kpi_Measure_Props;
434:
435: /************************************************************************************

Line 531: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Kpi_Measure_Props ';

527: WHEN NO_DATA_FOUND THEN
528: ROLLBACK TO BscKpiMeasurePub_Delete;
529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
530: IF (x_msg_data IS NOT NULL) THEN
531: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Kpi_Measure_Props ';
532: ELSE
533: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Kpi_Measure_Props ';
534: END IF;
535: WHEN OTHERS THEN

Line 533: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Kpi_Measure_Props ';

529: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
530: IF (x_msg_data IS NOT NULL) THEN
531: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Kpi_Measure_Props ';
532: ELSE
533: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Kpi_Measure_Props ';
534: END IF;
535: WHEN OTHERS THEN
536: ROLLBACK TO BscKpiMeasurePub_Delete;
537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 539: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Kpi_Measure_Props ';

535: WHEN OTHERS THEN
536: ROLLBACK TO BscKpiMeasurePub_Delete;
537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
538: IF (x_msg_data IS NOT NULL) THEN
539: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Kpi_Measure_Props ';
540: ELSE
541: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Kpi_Measure_Props ';
542: END IF;
543: END Delete_Kpi_Measure_Props;

Line 541: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Kpi_Measure_Props ';

537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
538: IF (x_msg_data IS NOT NULL) THEN
539: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Kpi_Measure_Props ';
540: ELSE
541: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Kpi_Measure_Props ';
542: END IF;
543: END Delete_Kpi_Measure_Props;
544:
545: /************************************************************************************

Line 627: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';

623: WHEN NO_DATA_FOUND THEN
624: ROLLBACK TO BscKpiMeasurePub_DeleteAll;
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626: IF (x_msg_data IS NOT NULL) THEN
627: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
628: ELSE
629: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
630: END IF;
631: WHEN OTHERS THEN

Line 629: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';

625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626: IF (x_msg_data IS NOT NULL) THEN
627: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
628: ELSE
629: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
630: END IF;
631: WHEN OTHERS THEN
632: ROLLBACK TO BscKpiMeasurePub_DeleteAll;
633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 635: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';

631: WHEN OTHERS THEN
632: ROLLBACK TO BscKpiMeasurePub_DeleteAll;
633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
634: IF (x_msg_data IS NOT NULL) THEN
635: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
636: ELSE
637: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
638: END IF;
639: END Delete_Obj_Kpi_Measure_Props;

Line 637: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';

633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
634: IF (x_msg_data IS NOT NULL) THEN
635: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
636: ELSE
637: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
638: END IF;
639: END Delete_Obj_Kpi_Measure_Props;
640:
641: /************************************************************************************

Line 646: , x_kpi_measure_rec OUT NOCOPY BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec

642: ************************************************************************************/
643: PROCEDURE Retrieve_Kpi_Measure_Props (
644: p_objective_id IN NUMBER
645: , p_kpi_measure_id IN NUMBER
646: , x_kpi_measure_rec OUT NOCOPY BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec
647: , x_return_status OUT NOCOPY VARCHAR2
648: , x_msg_count OUT NOCOPY NUMBER
649: , x_msg_data OUT NOCOPY VARCHAR2
650: )

Line 693: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';

689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
690: WHEN NO_DATA_FOUND THEN
691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
692: IF (x_msg_data IS NOT NULL) THEN
693: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
694: ELSE
695: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
696: END IF;
697: WHEN OTHERS THEN

Line 695: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';

691: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
692: IF (x_msg_data IS NOT NULL) THEN
693: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
694: ELSE
695: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
696: END IF;
697: WHEN OTHERS THEN
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699: IF (x_msg_data IS NOT NULL) THEN

Line 700: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';

696: END IF;
697: WHEN OTHERS THEN
698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699: IF (x_msg_data IS NOT NULL) THEN
700: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
701: ELSE
702: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
703: END IF;
704: END Retrieve_Kpi_Measure_Props;

Line 702: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';

698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
699: IF (x_msg_data IS NOT NULL) THEN
700: x_msg_data := x_msg_data || ' -> BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
701: ELSE
702: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
703: END IF;
704: END Retrieve_Kpi_Measure_Props;
705:
706: END BSC_KPI_MEASURE_PROPS_PUB;

Line 706: END BSC_KPI_MEASURE_PROPS_PUB;

702: x_msg_data := SQLERRM || ' at BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props ';
703: END IF;
704: END Retrieve_Kpi_Measure_Props;
705:
706: END BSC_KPI_MEASURE_PROPS_PUB;