1: PACKAGE BODY BSC_KPI_COLOR_PROPERTIES_PUB AS
2: /* $Header: BSCPKCPB.pls 120.2.12000000.1 2007/07/17 07:44:02 appldev noship $ */
3:
4:
5: /************************************************************************************
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
99: WHEN NO_DATA_FOUND THEN
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
101: IF (x_msg_data IS NOT NULL) THEN
102: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Update_Kpi_Color_Properties ';
103: ELSE
104: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Update_Kpi_Color_Properties ';
105: END IF;
106: WHEN OTHERS THEN
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
101: IF (x_msg_data IS NOT NULL) THEN
102: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Update_Kpi_Color_Properties ';
103: ELSE
104: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Update_Kpi_Color_Properties ';
105: END IF;
106: WHEN OTHERS THEN
107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
108: IF (x_msg_data IS NOT NULL) THEN
105: END IF;
106: WHEN OTHERS THEN
107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
108: IF (x_msg_data IS NOT NULL) THEN
109: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Update_Kpi_Color_Properties ';
110: ELSE
111: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Update_Kpi_Color_Properties ';
112: END IF;
113:
107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
108: IF (x_msg_data IS NOT NULL) THEN
109: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Update_Kpi_Color_Properties ';
110: ELSE
111: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Update_Kpi_Color_Properties ';
112: END IF;
113:
114: END Update_Kpi_Color_Properties;
115:
224: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
225: WHEN NO_DATA_FOUND THEN
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
227: IF (x_msg_data IS NOT NULL) THEN
228: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Update_Obj_Color_Properties ';
229: ELSE
230: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Update_Obj_Color_Properties ';
231: END IF;
232: WHEN OTHERS THEN
226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
227: IF (x_msg_data IS NOT NULL) THEN
228: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Update_Obj_Color_Properties ';
229: ELSE
230: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Update_Obj_Color_Properties ';
231: END IF;
232: WHEN OTHERS THEN
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
234: IF (x_msg_data IS NOT NULL) THEN
231: END IF;
232: WHEN OTHERS THEN
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
234: IF (x_msg_data IS NOT NULL) THEN
235: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Update_Obj_Color_Properties ';
236: ELSE
237: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Update_Obj_Color_Properties ';
238: END IF;
239:
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
234: IF (x_msg_data IS NOT NULL) THEN
235: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Update_Obj_Color_Properties ';
236: ELSE
237: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Update_Obj_Color_Properties ';
238: END IF;
239:
240:
241: END Update_Obj_Color_Properties;
355: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
356: WHEN NO_DATA_FOUND THEN
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358: IF (x_msg_data IS NOT NULL) THEN
359: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Create_Update_Kpi_Measure_Weights ';
360: ELSE
361: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Create_Update_Kpi_Measure_Weights ';
362: END IF;
363: WHEN OTHERS THEN
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358: IF (x_msg_data IS NOT NULL) THEN
359: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Create_Update_Kpi_Measure_Weights ';
360: ELSE
361: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Create_Update_Kpi_Measure_Weights ';
362: END IF;
363: WHEN OTHERS THEN
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
365: IF (x_msg_data IS NOT NULL) THEN
362: END IF;
363: WHEN OTHERS THEN
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
365: IF (x_msg_data IS NOT NULL) THEN
366: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Create_Update_Kpi_Measure_Weights ';
367: ELSE
368: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Create_Update_Kpi_Measure_Weights ';
369: END IF;
370:
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
365: IF (x_msg_data IS NOT NULL) THEN
366: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Create_Update_Kpi_Measure_Weights ';
367: ELSE
368: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Create_Update_Kpi_Measure_Weights ';
369: END IF;
370:
371: END Create_Update_Kpi_Mes_Weights;
372:
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: WHEN NO_DATA_FOUND THEN
436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
437: IF (x_msg_data IS NOT NULL) THEN
438: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change ';
439: ELSE
440: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change ';
441: END IF;
442: WHEN OTHERS THEN
436: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
437: IF (x_msg_data IS NOT NULL) THEN
438: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change ';
439: ELSE
440: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change ';
441: END IF;
442: WHEN OTHERS THEN
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: IF (x_msg_data IS NOT NULL) THEN
441: END IF;
442: WHEN OTHERS THEN
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: IF (x_msg_data IS NOT NULL) THEN
445: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change ';
446: ELSE
447: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change ';
448: END IF;
449:
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: IF (x_msg_data IS NOT NULL) THEN
445: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change ';
446: ELSE
447: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change ';
448: END IF;
449:
450: END Obj_Prototype_Flag_Change;
451:
527: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
528: WHEN NO_DATA_FOUND THEN
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_COLOR_PROPERTIES_PUB.Kpi_Prototype_Flag_Change ';
532: ELSE
533: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Kpi_Prototype_Flag_Change ';
534: END IF;
535: WHEN OTHERS THEN
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_COLOR_PROPERTIES_PUB.Kpi_Prototype_Flag_Change ';
532: ELSE
533: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Kpi_Prototype_Flag_Change ';
534: END IF;
535: WHEN OTHERS THEN
536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
537: IF (x_msg_data IS NOT NULL) THEN
534: END IF;
535: WHEN OTHERS THEN
536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
537: IF (x_msg_data IS NOT NULL) THEN
538: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Kpi_Prototype_Flag_Change ';
539: ELSE
540: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Kpi_Prototype_Flag_Change ';
541: END IF;
542:
536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
537: IF (x_msg_data IS NOT NULL) THEN
538: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Kpi_Prototype_Flag_Change ';
539: ELSE
540: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Kpi_Prototype_Flag_Change ';
541: END IF;
542:
543: END Kpi_Prototype_Flag_Change;
544:
625: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
626: WHEN NO_DATA_FOUND THEN
627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
628: IF (x_msg_data IS NOT NULL) THEN
629: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change ';
630: ELSE
631: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change ';
632: END IF;
633: WHEN OTHERS THEN
627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
628: IF (x_msg_data IS NOT NULL) THEN
629: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change ';
630: ELSE
631: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change ';
632: END IF;
633: WHEN OTHERS THEN
634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
635: IF (x_msg_data IS NOT NULL) THEN
632: END IF;
633: WHEN OTHERS THEN
634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
635: IF (x_msg_data IS NOT NULL) THEN
636: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change ';
637: ELSE
638: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change ';
639: END IF;
640:
634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
635: IF (x_msg_data IS NOT NULL) THEN
636: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change ';
637: ELSE
638: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change ';
639: END IF;
640:
641: END Change_Prototype_Flag;
642:
729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
730: WHEN NO_DATA_FOUND THEN
731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
732: IF (x_msg_data IS NOT NULL) THEN
733: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Save_Disable_Color_Of_Kpi ';
734: ELSE
735: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Save_Disable_Color_Of_Kpi ';
736: END IF;
737: WHEN OTHERS THEN
731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
732: IF (x_msg_data IS NOT NULL) THEN
733: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Save_Disable_Color_Of_Kpi ';
734: ELSE
735: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Save_Disable_Color_Of_Kpi ';
736: END IF;
737: WHEN OTHERS THEN
738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
739: IF (x_msg_data IS NOT NULL) THEN
736: END IF;
737: WHEN OTHERS THEN
738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
739: IF (x_msg_data IS NOT NULL) THEN
740: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Save_Disable_Color_Of_Kpi ';
741: ELSE
742: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Save_Disable_Color_Of_Kpi ';
743: END IF;
744:
738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
739: IF (x_msg_data IS NOT NULL) THEN
740: x_msg_data := x_msg_data || ' -> BSC_KPI_COLOR_PROPERTIES_PUB.Save_Disable_Color_Of_Kpi ';
741: ELSE
742: x_msg_data := SQLERRM || ' at BSC_KPI_COLOR_PROPERTIES_PUB.Save_Disable_Color_Of_Kpi ';
743: END IF;
744:
745: END Save_Disable_Color_Of_Kpi;
746:
744:
745: END Save_Disable_Color_Of_Kpi;
746:
747:
748: END BSC_KPI_COLOR_PROPERTIES_PUB;