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.BIS_MEASURE_PVT dependencies on BIS_UTILITIES_PVT

Line 367: BIS_UTILITIES_PVT.Add_Error_Message

363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
364: --added last two params
365:
366: l_error_tbl := x_error_tbl;
367: BIS_UTILITIES_PVT.Add_Error_Message
368: ( p_error_msg_id => SQLCODE
369: , p_error_description => SQLERRM
370: , p_error_proc_name => G_PKG_NAME||'.Create_Indicator_Dimension'
371: , p_error_table => l_error_tbl

Line 499: BIS_UTILITIES_PVT.Add_Error_Message

495: when others then
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
497: --added last two params
498: l_error_tbl := x_error_tbl;
499: BIS_UTILITIES_PVT.Add_Error_Message
500: ( p_error_msg_id => SQLCODE
501: , p_error_description => SQLERRM
502: , p_error_proc_name => G_PKG_NAME||'.Create_Indicator_Dimension'
503: , p_error_table => l_error_tbl

Line 735: BIS_UTILITIES_PVT.Add_Error_Message

731: when others then
732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
733: --added last two params
734: l_error_tbl := x_error_tbl;
735: BIS_UTILITIES_PVT.Add_Error_Message
736: ( p_error_msg_id => SQLCODE
737: , p_error_description => SQLERRM
738: , p_error_proc_name => G_PKG_NAME||'.Create_Indicator_Dimension'
739: , p_error_table => l_error_tbl

Line 754: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Measure_ID);

750: IS
751: BEGIN
752:
753: x_measure_rec.Measure_ID :=
754: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Measure_ID);
755: x_measure_rec.Measure_Short_Name :=
756: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Measure_Short_Name);
757: x_measure_rec.Measure_Name :=
758: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Measure_Name);

Line 756: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Measure_Short_Name);

752:
753: x_measure_rec.Measure_ID :=
754: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Measure_ID);
755: x_measure_rec.Measure_Short_Name :=
756: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Measure_Short_Name);
757: x_measure_rec.Measure_Name :=
758: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Measure_Name);
759: x_measure_rec.Description :=
760: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Description);

Line 758: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Measure_Name);

754: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Measure_ID);
755: x_measure_rec.Measure_Short_Name :=
756: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Measure_Short_Name);
757: x_measure_rec.Measure_Name :=
758: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Measure_Name);
759: x_measure_rec.Description :=
760: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Description);
761: x_measure_rec.Dimension1_ID :=
762: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension1_ID);

Line 760: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Description);

756: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Measure_Short_Name);
757: x_measure_rec.Measure_Name :=
758: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Measure_Name);
759: x_measure_rec.Description :=
760: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Description);
761: x_measure_rec.Dimension1_ID :=
762: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension1_ID);
763: x_measure_rec.Dimension1_Short_Name :=
764: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension1_Short_Name);

Line 762: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension1_ID);

758: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Measure_Name);
759: x_measure_rec.Description :=
760: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Description);
761: x_measure_rec.Dimension1_ID :=
762: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension1_ID);
763: x_measure_rec.Dimension1_Short_Name :=
764: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension1_Short_Name);
765: x_measure_rec.Dimension1_Name :=
766: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension1_Name);

Line 764: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension1_Short_Name);

760: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Description);
761: x_measure_rec.Dimension1_ID :=
762: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension1_ID);
763: x_measure_rec.Dimension1_Short_Name :=
764: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension1_Short_Name);
765: x_measure_rec.Dimension1_Name :=
766: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension1_Name);
767: x_measure_rec.Dimension2_ID :=
768: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension2_ID);

Line 766: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension1_Name);

762: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension1_ID);
763: x_measure_rec.Dimension1_Short_Name :=
764: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension1_Short_Name);
765: x_measure_rec.Dimension1_Name :=
766: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension1_Name);
767: x_measure_rec.Dimension2_ID :=
768: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension2_ID);
769: x_measure_rec.Dimension2_Short_Name :=
770: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension2_Short_Name);

Line 768: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension2_ID);

764: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension1_Short_Name);
765: x_measure_rec.Dimension1_Name :=
766: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension1_Name);
767: x_measure_rec.Dimension2_ID :=
768: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension2_ID);
769: x_measure_rec.Dimension2_Short_Name :=
770: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension2_Short_Name);
771: x_measure_rec.Dimension2_Name :=
772: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension2_Name);

Line 770: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension2_Short_Name);

766: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension1_Name);
767: x_measure_rec.Dimension2_ID :=
768: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension2_ID);
769: x_measure_rec.Dimension2_Short_Name :=
770: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension2_Short_Name);
771: x_measure_rec.Dimension2_Name :=
772: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension2_Name);
773: x_measure_rec.Dimension3_ID :=
774: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension3_ID);

Line 772: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension2_Name);

768: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension2_ID);
769: x_measure_rec.Dimension2_Short_Name :=
770: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension2_Short_Name);
771: x_measure_rec.Dimension2_Name :=
772: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension2_Name);
773: x_measure_rec.Dimension3_ID :=
774: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension3_ID);
775: x_measure_rec.Dimension3_Short_Name :=
776: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension3_Short_Name);

Line 774: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension3_ID);

770: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension2_Short_Name);
771: x_measure_rec.Dimension2_Name :=
772: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension2_Name);
773: x_measure_rec.Dimension3_ID :=
774: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension3_ID);
775: x_measure_rec.Dimension3_Short_Name :=
776: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension3_Short_Name);
777: x_measure_rec.Dimension3_Name :=
778: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension3_Name);

Line 776: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension3_Short_Name);

772: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension2_Name);
773: x_measure_rec.Dimension3_ID :=
774: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension3_ID);
775: x_measure_rec.Dimension3_Short_Name :=
776: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension3_Short_Name);
777: x_measure_rec.Dimension3_Name :=
778: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension3_Name);
779: x_measure_rec.Dimension4_ID :=
780: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension4_ID);

Line 778: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension3_Name);

774: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension3_ID);
775: x_measure_rec.Dimension3_Short_Name :=
776: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension3_Short_Name);
777: x_measure_rec.Dimension3_Name :=
778: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension3_Name);
779: x_measure_rec.Dimension4_ID :=
780: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension4_ID);
781: x_measure_rec.Dimension4_Short_Name :=
782: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension4_Short_Name);

Line 780: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension4_ID);

776: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension3_Short_Name);
777: x_measure_rec.Dimension3_Name :=
778: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension3_Name);
779: x_measure_rec.Dimension4_ID :=
780: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension4_ID);
781: x_measure_rec.Dimension4_Short_Name :=
782: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension4_Short_Name);
783: x_measure_rec.Dimension4_Name :=
784: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension4_Name);

Line 782: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension4_Short_Name);

778: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension3_Name);
779: x_measure_rec.Dimension4_ID :=
780: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension4_ID);
781: x_measure_rec.Dimension4_Short_Name :=
782: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension4_Short_Name);
783: x_measure_rec.Dimension4_Name :=
784: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension4_Name);
785: x_measure_rec.Dimension5_ID :=
786: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension5_ID);

Line 784: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension4_Name);

780: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension4_ID);
781: x_measure_rec.Dimension4_Short_Name :=
782: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension4_Short_Name);
783: x_measure_rec.Dimension4_Name :=
784: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension4_Name);
785: x_measure_rec.Dimension5_ID :=
786: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension5_ID);
787: x_measure_rec.Dimension5_Short_Name :=
788: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension5_Short_Name);

Line 786: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension5_ID);

782: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension4_Short_Name);
783: x_measure_rec.Dimension4_Name :=
784: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension4_Name);
785: x_measure_rec.Dimension5_ID :=
786: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension5_ID);
787: x_measure_rec.Dimension5_Short_Name :=
788: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension5_Short_Name);
789: x_measure_rec.Dimension5_Name :=
790: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension5_Name);

Line 788: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension5_Short_Name);

784: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension4_Name);
785: x_measure_rec.Dimension5_ID :=
786: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension5_ID);
787: x_measure_rec.Dimension5_Short_Name :=
788: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension5_Short_Name);
789: x_measure_rec.Dimension5_Name :=
790: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension5_Name);
791: x_measure_rec.Dimension6_ID :=
792: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension6_ID);

Line 790: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension5_Name);

786: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension5_ID);
787: x_measure_rec.Dimension5_Short_Name :=
788: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension5_Short_Name);
789: x_measure_rec.Dimension5_Name :=
790: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension5_Name);
791: x_measure_rec.Dimension6_ID :=
792: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension6_ID);
793: x_measure_rec.Dimension6_Short_Name :=
794: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension6_Short_Name);

Line 792: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension6_ID);

788: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension5_Short_Name);
789: x_measure_rec.Dimension5_Name :=
790: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension5_Name);
791: x_measure_rec.Dimension6_ID :=
792: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension6_ID);
793: x_measure_rec.Dimension6_Short_Name :=
794: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension6_Short_Name);
795: x_measure_rec.Dimension6_Name :=
796: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension6_Name);

Line 794: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension6_Short_Name);

790: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension5_Name);
791: x_measure_rec.Dimension6_ID :=
792: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension6_ID);
793: x_measure_rec.Dimension6_Short_Name :=
794: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension6_Short_Name);
795: x_measure_rec.Dimension6_Name :=
796: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension6_Name);
797: x_measure_rec.Dimension7_ID :=
798: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension7_ID);

Line 796: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension6_Name);

792: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension6_ID);
793: x_measure_rec.Dimension6_Short_Name :=
794: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension6_Short_Name);
795: x_measure_rec.Dimension6_Name :=
796: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension6_Name);
797: x_measure_rec.Dimension7_ID :=
798: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension7_ID);
799: x_measure_rec.Dimension7_Short_Name :=
800: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension7_Short_Name);

Line 798: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension7_ID);

794: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension6_Short_Name);
795: x_measure_rec.Dimension6_Name :=
796: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension6_Name);
797: x_measure_rec.Dimension7_ID :=
798: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension7_ID);
799: x_measure_rec.Dimension7_Short_Name :=
800: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension7_Short_Name);
801: x_measure_rec.Dimension7_Name :=
802: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension7_Name);

Line 800: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension7_Short_Name);

796: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension6_Name);
797: x_measure_rec.Dimension7_ID :=
798: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension7_ID);
799: x_measure_rec.Dimension7_Short_Name :=
800: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension7_Short_Name);
801: x_measure_rec.Dimension7_Name :=
802: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension7_Name);
803: x_measure_rec.Unit_Of_Measure_Class :=
804: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Unit_Of_Measure_Class);

Line 802: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension7_Name);

798: BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Dimension7_ID);
799: x_measure_rec.Dimension7_Short_Name :=
800: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension7_Short_Name);
801: x_measure_rec.Dimension7_Name :=
802: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension7_Name);
803: x_measure_rec.Unit_Of_Measure_Class :=
804: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Unit_Of_Measure_Class);
805: -- Fix for 1850860 starts here
806: x_measure_rec.Actual_Data_Source_Type :=

Line 804: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Unit_Of_Measure_Class);

800: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension7_Short_Name);
801: x_measure_rec.Dimension7_Name :=
802: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dimension7_Name);
803: x_measure_rec.Unit_Of_Measure_Class :=
804: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Unit_Of_Measure_Class);
805: -- Fix for 1850860 starts here
806: x_measure_rec.Actual_Data_Source_Type :=
807: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Actual_Data_Source_Type);
808: x_measure_rec.Actual_Data_Source :=

Line 807: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Actual_Data_Source_Type);

803: x_measure_rec.Unit_Of_Measure_Class :=
804: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Unit_Of_Measure_Class);
805: -- Fix for 1850860 starts here
806: x_measure_rec.Actual_Data_Source_Type :=
807: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Actual_Data_Source_Type);
808: x_measure_rec.Actual_Data_Source :=
809: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Actual_Data_Source);
810: x_measure_rec.Function_Name :=
811: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Function_Name);

Line 809: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Actual_Data_Source);

805: -- Fix for 1850860 starts here
806: x_measure_rec.Actual_Data_Source_Type :=
807: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Actual_Data_Source_Type);
808: x_measure_rec.Actual_Data_Source :=
809: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Actual_Data_Source);
810: x_measure_rec.Function_Name :=
811: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Function_Name);
812: x_measure_rec.Comparison_Source :=
813: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Comparison_Source);

Line 811: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Function_Name);

807: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Actual_Data_Source_Type);
808: x_measure_rec.Actual_Data_Source :=
809: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Actual_Data_Source);
810: x_measure_rec.Function_Name :=
811: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Function_Name);
812: x_measure_rec.Comparison_Source :=
813: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Comparison_Source);
814: x_measure_rec.Increase_In_Measure :=
815: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Increase_In_Measure);

Line 813: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Comparison_Source);

809: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Actual_Data_Source);
810: x_measure_rec.Function_Name :=
811: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Function_Name);
812: x_measure_rec.Comparison_Source :=
813: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Comparison_Source);
814: x_measure_rec.Increase_In_Measure :=
815: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Increase_In_Measure);
816: -- Fix for 1850860 ends here
817: -- 2440739

Line 815: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Increase_In_Measure);

811: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Function_Name);
812: x_measure_rec.Comparison_Source :=
813: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Comparison_Source);
814: x_measure_rec.Increase_In_Measure :=
815: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Increase_In_Measure);
816: -- Fix for 1850860 ends here
817: -- 2440739
818: x_measure_rec.Enable_Link :=
819: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Enable_Link);

Line 819: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Enable_Link);

815: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Increase_In_Measure);
816: -- Fix for 1850860 ends here
817: -- 2440739
818: x_measure_rec.Enable_Link :=
819: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Enable_Link);
820: --Enhancement 3865711
821: x_measure_rec.Obsolete :=
822: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Obsolete);
823: x_measure_rec.Measure_Type :=

Line 822: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Obsolete);

818: x_measure_rec.Enable_Link :=
819: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Enable_Link);
820: --Enhancement 3865711
821: x_measure_rec.Obsolete :=
822: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Obsolete);
823: x_measure_rec.Measure_Type :=
824: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Measure_Type);
825: x_measure_rec.Application_Id :=
826: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Application_Id); --2465354

Line 824: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Measure_Type);

820: --Enhancement 3865711
821: x_measure_rec.Obsolete :=
822: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Obsolete);
823: x_measure_rec.Measure_Type :=
824: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Measure_Type);
825: x_measure_rec.Application_Id :=
826: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Application_Id); --2465354
827:
828: -- mdamle 4/23/2003 - PMD - Measure Definer

Line 826: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Application_Id); --2465354

822: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Obsolete);
823: x_measure_rec.Measure_Type :=
824: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Measure_Type);
825: x_measure_rec.Application_Id :=
826: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Application_Id); --2465354
827:
828: -- mdamle 4/23/2003 - PMD - Measure Definer
829: x_measure_rec.Dataset_id :=
830: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dataset_Id); --2465354

Line 830: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dataset_Id); --2465354

826: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Application_Id); --2465354
827:
828: -- mdamle 4/23/2003 - PMD - Measure Definer
829: x_measure_rec.Dataset_id :=
830: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dataset_Id); --2465354
831:
832: -- rpenneru 12/21/2004 - Functional Area Short Name
833: x_measure_rec.Func_Area_Short_Name := BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Func_Area_Short_Name);
834:

Line 833: x_measure_rec.Func_Area_Short_Name := BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Func_Area_Short_Name);

829: x_measure_rec.Dataset_id :=
830: BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Dataset_Id); --2465354
831:
832: -- rpenneru 12/21/2004 - Functional Area Short Name
833: x_measure_rec.Func_Area_Short_Name := BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Func_Area_Short_Name);
834:
835: x_measure_rec.Created_By := BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Created_By);
836: x_measure_rec.Creation_Date := BIS_UTILITIES_PVT.CheckMissDate(p_measure_rec.Creation_Date);
837: x_measure_rec.Last_Updated_By := BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Last_Updated_By);

Line 835: x_measure_rec.Created_By := BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Created_By);

831:
832: -- rpenneru 12/21/2004 - Functional Area Short Name
833: x_measure_rec.Func_Area_Short_Name := BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Func_Area_Short_Name);
834:
835: x_measure_rec.Created_By := BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Created_By);
836: x_measure_rec.Creation_Date := BIS_UTILITIES_PVT.CheckMissDate(p_measure_rec.Creation_Date);
837: x_measure_rec.Last_Updated_By := BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Last_Updated_By);
838: x_measure_rec.Last_Update_Date := BIS_UTILITIES_PVT.CheckMissDate(p_measure_rec.Last_Update_Date);
839: x_measure_rec.Last_Update_Login := BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Last_Update_Login);

Line 836: x_measure_rec.Creation_Date := BIS_UTILITIES_PVT.CheckMissDate(p_measure_rec.Creation_Date);

832: -- rpenneru 12/21/2004 - Functional Area Short Name
833: x_measure_rec.Func_Area_Short_Name := BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Func_Area_Short_Name);
834:
835: x_measure_rec.Created_By := BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Created_By);
836: x_measure_rec.Creation_Date := BIS_UTILITIES_PVT.CheckMissDate(p_measure_rec.Creation_Date);
837: x_measure_rec.Last_Updated_By := BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Last_Updated_By);
838: x_measure_rec.Last_Update_Date := BIS_UTILITIES_PVT.CheckMissDate(p_measure_rec.Last_Update_Date);
839: x_measure_rec.Last_Update_Login := BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Last_Update_Login);
840:

Line 837: x_measure_rec.Last_Updated_By := BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Last_Updated_By);

833: x_measure_rec.Func_Area_Short_Name := BIS_UTILITIES_PVT.CheckMissChar(p_measure_rec.Func_Area_Short_Name);
834:
835: x_measure_rec.Created_By := BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Created_By);
836: x_measure_rec.Creation_Date := BIS_UTILITIES_PVT.CheckMissDate(p_measure_rec.Creation_Date);
837: x_measure_rec.Last_Updated_By := BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Last_Updated_By);
838: x_measure_rec.Last_Update_Date := BIS_UTILITIES_PVT.CheckMissDate(p_measure_rec.Last_Update_Date);
839: x_measure_rec.Last_Update_Login := BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Last_Update_Login);
840:
841: END SetNULL;

Line 838: x_measure_rec.Last_Update_Date := BIS_UTILITIES_PVT.CheckMissDate(p_measure_rec.Last_Update_Date);

834:
835: x_measure_rec.Created_By := BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Created_By);
836: x_measure_rec.Creation_Date := BIS_UTILITIES_PVT.CheckMissDate(p_measure_rec.Creation_Date);
837: x_measure_rec.Last_Updated_By := BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Last_Updated_By);
838: x_measure_rec.Last_Update_Date := BIS_UTILITIES_PVT.CheckMissDate(p_measure_rec.Last_Update_Date);
839: x_measure_rec.Last_Update_Login := BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Last_Update_Login);
840:
841: END SetNULL;
842:

Line 839: x_measure_rec.Last_Update_Login := BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Last_Update_Login);

835: x_measure_rec.Created_By := BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Created_By);
836: x_measure_rec.Creation_Date := BIS_UTILITIES_PVT.CheckMissDate(p_measure_rec.Creation_Date);
837: x_measure_rec.Last_Updated_By := BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Last_Updated_By);
838: x_measure_rec.Last_Update_Date := BIS_UTILITIES_PVT.CheckMissDate(p_measure_rec.Last_Update_Date);
839: x_measure_rec.Last_Update_Login := BIS_UTILITIES_PVT.CheckMissNum(p_measure_rec.Last_Update_Login);
840:
841: END SetNULL;
842:
843: -- creates one Measure, with the dimensions sequenced in the order

Line 871: -- BIS_UTILITIES_PVT.Add_Error_Message

867: --EXCEPTION
868: -- when others then
869: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
870: -- -- added last two params
871: -- BIS_UTILITIES_PVT.Add_Error_Message
872: -- ( p_error_msg_id => SQLCODE
873: -- , p_error_description => SQLERRM
874: -- , p_error_proc_name => G_PKG_NAME||'.Create_Measure'
875: -- , p_error_table => x_error_tbl

Line 951: BIS_UTILITIES_PVT.Add_Error_Message

947: l_Measure_Id := Get_Measure_Id_From_Short_Name(p_measure_rec);
948:
949: if (l_measure_id is NOT NULL) then
950: l_error_tbl := x_error_tbl;
951: BIS_UTILITIES_PVT.Add_Error_Message
952: ( p_error_msg_name => 'BIS_MEASURE_SHORT_NAME_UNIQUE'
953: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
954: , p_error_proc_name => G_PKG_NAME||'.Create_Measure'
955: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 966: BIS_UTILITIES_PVT.Add_Error_Message

962:
963: -- mdamle 07/18/2003 - Allow enable_link = Y only if function_name is not null
964: if (p_measure_rec.function_name is null and p_measure_rec.enable_link = 'Y') then
965: l_error_tbl := x_error_tbl;
966: BIS_UTILITIES_PVT.Add_Error_Message
967: ( p_error_msg_name => 'BIS_PMF_ENABLE_LINK_ERR'
968: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
969: , p_error_proc_name => G_PKG_NAME||'.Create_Measure'
970: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 983: BIS_UTILITIES_PVT.Add_Error_Message

979: -- mdamle 07/18/2003 - Check if measure is being mapped to a source
980: -- that's already mapped to another measure.
981: if isSourceColumnMappedAlready(p_Measure_rec, l_Mapped_measure) then
982: l_error_tbl := x_error_tbl;
983: BIS_UTILITIES_PVT.Add_Error_Message
984: ( p_error_msg_name => 'BIS_PMF_SOURCE_MAPPING_ERR'
985: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
986: , p_error_proc_name => G_PKG_NAME||'.Create_Measure'
987: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 1000: BIS_UTILITIES_PVT.Add_Error_Message

996:
997: --sawu: 9/2/04: need to validate compare-to column also for bug#3859267
998: if isCompareColumnMappedAlready(p_Measure_rec, l_Mapped_measure) then
999: l_error_tbl := x_error_tbl;
1000: BIS_UTILITIES_PVT.Add_Error_Message
1001: ( p_error_msg_name => 'BIS_PMF_COLUMN_MAPPING_ERR'
1002: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1003: , p_error_proc_name => G_PKG_NAME||'.Create_Measure'
1004: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 1173: BIS_UTILITIES_PVT.Add_Error_Message

1169: when others then
1170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1171: --added last two params
1172: l_error_tbl := x_error_tbl;
1173: BIS_UTILITIES_PVT.Add_Error_Message
1174: ( p_error_msg_id => SQLCODE
1175: , p_error_description => SQLERRM
1176: , p_error_proc_name => G_PKG_NAME||'.Create_Measure'
1177: , p_error_table => l_error_tbl

Line 1280: BIS_UTILITIES_PVT.Add_Error_Message

1276: l_Measure_Id := Get_Measure_Id_From_Short_Name(p_measure_rec);
1277:
1278: if (l_measure_id is NOT NULL) then
1279: l_error_tbl := x_error_tbl;
1280: BIS_UTILITIES_PVT.Add_Error_Message
1281: ( p_error_msg_name => 'BIS_MEASURE_SHORT_NAME_UNIQUE'
1282: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1283: , p_error_proc_name => G_PKG_NAME||'.Create_Measure'
1284: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 1466: BIS_UTILITIES_PVT.Add_Error_Message

1462: when others then
1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1464: --added last two params
1465: l_error_tbl := x_error_tbl;
1466: BIS_UTILITIES_PVT.Add_Error_Message
1467: ( p_error_msg_id => SQLCODE
1468: , p_error_description => SQLERRM
1469: , p_error_proc_name => G_PKG_NAME||'.Create_Measure'
1470: , p_error_table => l_error_tbl

Line 1545: BIS_UTILITIES_PVT.Add_Error_Message

1541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1542: IF cr_all_measures%ISOPEN THEN CLOSE cr_all_measures; END IF;
1543: --added last two params
1544: l_error_tbl := x_error_tbl;
1545: BIS_UTILITIES_PVT.Add_Error_Message
1546: ( p_error_msg_id => SQLCODE
1547: , p_error_description => SQLERRM
1548: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Measures'
1549: , p_error_table => l_error_tbl

Line 1838: BIS_UTILITIES_PVT.Add_Error_Message

1834: WHEN NO_DATA_FOUND THEN
1835: x_return_status := FND_API.G_RET_STS_ERROR ;
1836: --added the error message
1837: l_error_tbl := x_error_tbl;
1838: BIS_UTILITIES_PVT.Add_Error_Message
1839: ( p_error_msg_name => 'BIS_INVALID_MEASURE_VALUE'
1840: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
1841: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Measure'
1842: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 1857: BIS_UTILITIES_PVT.Add_Error_Message

1853: when others then
1854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1855: --added last two params
1856: l_error_tbl := x_error_tbl;
1857: BIS_UTILITIES_PVT.Add_Error_Message
1858: ( p_error_msg_id => SQLCODE
1859: , p_error_description => SQLERRM
1860: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Measure'
1861: , p_error_table => l_error_tbl

Line 1915: BIS_UTILITIES_PVT.Add_Error_Message

1911: when others then
1912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1913: --added last two params
1914: l_error_tbl := x_error_tbl;
1915: BIS_UTILITIES_PVT.Add_Error_Message
1916: ( p_error_msg_id => SQLCODE
1917: , p_error_description => SQLERRM
1918: , p_error_proc_name => G_PKG_NAME||'.Update_Indicator_Dimension'
1919: , p_error_table => l_error_tbl

Line 2208: IF ( bis_utilities_pvt.Value_Not_Missing

2204: j := 1;
2205:
2206: FOR i IN 1..7 LOOP -- Dimensions ab_de_f become abdef__
2207:
2208: IF ( bis_utilities_pvt.Value_Not_Missing
2209: (p_value => l_dim_tbl(i).Dimension_id ) = FND_API.G_TRUE ) THEN
2210:
2211: l_arranged_dim_tbl(j).Dimension_id := l_dim_tbl(i).Dimension_id;
2212: j := j+1;

Line 2245: IF ( bis_utilities_pvt.Value_Missing

2241: ( p_number IN NUMBER )
2242: RETURN NUMBER IS
2243: BEGIN
2244:
2245: IF ( bis_utilities_pvt.Value_Missing
2246: (p_value => p_number ) = FND_API.G_TRUE ) THEN
2247: RETURN NULL;
2248: ELSE
2249: RETURN p_number;

Line 2263: IF ( bis_utilities_pvt.Value_Missing

2259: ( p_varchar2 IN VARCHAR2 )
2260: RETURN VARCHAR2 IS
2261: BEGIN
2262:
2263: IF ( bis_utilities_pvt.Value_Missing
2264: (p_value => p_varchar2 ) = FND_API.G_TRUE ) THEN
2265: RETURN NULL;
2266: ELSE
2267: RETURN p_varchar2;

Line 2487: BIS_UTILITIES_PVT.Add_Error_Message

2483: when others then
2484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2485: --added last two params
2486: l_error_tbl := x_error_tbl;
2487: BIS_UTILITIES_PVT.Add_Error_Message
2488: ( p_error_msg_id => SQLCODE
2489: , p_error_description => SQLERRM
2490: , p_error_proc_name => G_PKG_NAME||'.Update_Measure'
2491: , p_error_table => l_error_tbl

Line 2555: BIS_UTILITIES_PVT.Add_Error_Message

2551:
2552: -- mdamle 07/18/2003 - Allow enable_link = Y only if function_name is not null
2553: if (p_measure_rec.function_name is null and p_measure_rec.enable_link = 'Y') then
2554: l_error_tbl := x_error_tbl;
2555: BIS_UTILITIES_PVT.Add_Error_Message
2556: ( p_error_msg_name => 'BIS_PMF_ENABLE_LINK_ERR'
2557: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2558: , p_error_proc_name => G_PKG_NAME||'.Update_Measure'
2559: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 2573: BIS_UTILITIES_PVT.Add_Error_Message

2569: -- that's already mapped to another measure.
2570: if isSourceColumnMappedAlready(p_Measure_rec, l_Mapped_measure) then
2571: l_error_tbl := x_error_tbl;
2572:
2573: BIS_UTILITIES_PVT.Add_Error_Message
2574: ( p_error_msg_name => 'BIS_PMF_SOURCE_MAPPING_ERR'
2575: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2576: , p_error_proc_name => G_PKG_NAME||'.Update_Measure'
2577: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 2589: BIS_UTILITIES_PVT.Add_Error_Message

2585:
2586: --sawu: 9/2/04: need to validate compare-to column also for bug#3859267
2587: if isCompareColumnMappedAlready(p_Measure_rec, l_Mapped_measure) then
2588: l_error_tbl := x_error_tbl;
2589: BIS_UTILITIES_PVT.Add_Error_Message
2590: ( p_error_msg_name => 'BIS_PMF_COLUMN_MAPPING_ERR'
2591: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2592: , p_error_proc_name => G_PKG_NAME||'.Update_Measure'
2593: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 2612: BIS_UTILITIES_PVT.Add_Error_Message

2608: if (p_Measure_Rec.Measure_Id is NULL or l_measure_id <> p_Measure_Rec.Measure_Id) then
2609: --added last two params
2610: --changed error message-used to be 'BIS_MEASURE_SHORT_NAME_UNIQUE'
2611: l_error_tbl := x_error_tbl;
2612: BIS_UTILITIES_PVT.Add_Error_Message
2613: ( p_error_msg_name => 'BIS_INVALID_MEASURE_VALUE'
2614: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2615: , p_error_proc_name => G_PKG_NAME||'.Update_Measure'
2616: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 2646: BIS_UTILITIES_PVT.Add_Error_Message

2642: NVL(l_Measure_Rec_Orig.dimension7_id,7) <> NVL(p_Measure_Rec.dimension7_id,7)
2643: )
2644: ) THEN
2645: l_error_tbl := x_error_tbl;
2646: BIS_UTILITIES_PVT.Add_Error_Message
2647: ( p_error_msg_name => 'BIS_NO_DIMENSION_CHANGE'
2648: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2649: , p_error_proc_name => G_PKG_NAME||'.Update_Measure'
2650: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 2792: BIS_UTILITIES_PVT.Add_Error_Message

2788: when others then
2789: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2790: --added last two params
2791: l_error_tbl := x_error_tbl;
2792: BIS_UTILITIES_PVT.Add_Error_Message
2793: ( p_error_msg_id => SQLCODE
2794: , p_error_description => SQLERRM
2795: , p_error_proc_name => G_PKG_NAME||'.Update_Measure'
2796: , p_error_table => l_error_tbl

Line 2885: BIS_UTILITIES_PVT.Add_Error_Message

2881: if (p_Measure_Rec.Measure_Id is NULL or l_measure_id <> p_Measure_Rec.Measure_Id) then
2882: --added last two params
2883: --changed error message-used to be 'BIS_MEASURE_SHORT_NAME_UNIQUE'
2884: l_error_tbl := x_error_tbl;
2885: BIS_UTILITIES_PVT.Add_Error_Message
2886: ( p_error_msg_name => 'BIS_INVALID_MEASURE_VALUE'
2887: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2888: , p_error_proc_name => G_PKG_NAME||'.Update_Measure'
2889: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 2916: BIS_UTILITIES_PVT.Add_Error_Message

2912: NVL(l_Measure_Rec_Orig.dimension7_id,7) <> NVL(p_Measure_Rec.dimension7_id,7)
2913: )
2914: ) THEN
2915: l_error_tbl := x_error_tbl;
2916: BIS_UTILITIES_PVT.Add_Error_Message
2917: ( p_error_msg_name => 'BIS_NO_DIMENSION_CHANGE'
2918: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
2919: , p_error_proc_name => G_PKG_NAME||'.Update_Measure'
2920: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 3025: BIS_UTILITIES_PVT.Add_Error_Message

3021: when others then
3022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3023: --added last two params
3024: l_error_tbl := x_error_tbl;
3025: BIS_UTILITIES_PVT.Add_Error_Message
3026: ( p_error_msg_id => SQLCODE
3027: , p_error_description => SQLERRM
3028: , p_error_proc_name => G_PKG_NAME||'.Update_Measure'
3029: , p_error_table => l_error_tbl

Line 3066: BIS_UTILITIES_PVT.Add_Error_Message

3062: );
3063: if (l_count > 0) then
3064: --added last two params
3065: l_error_tbl := x_error_tbl;
3066: BIS_UTILITIES_PVT.Add_Error_Message
3067: ( p_error_msg_name => 'BIS_NO_DELETE_MEASURE'
3068: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3069: , p_error_proc_name => G_PKG_NAME||'.Delete_Measure'
3070: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 3083: BIS_UTILITIES_PVT.Add_Error_Message

3079: select count(1) into l_dcount from bis_application_measures
3080: where indicator_id = p_Measure_Rec.Measure_Id;
3081: IF(l_dcount = 0) then
3082: l_error_tbl := x_error_tbl ;
3083: BIS_UTILITIES_PVT.Add_Error_Message
3084: ( p_error_msg_name => 'BIS_INVALID_MEASURE_VALUE'
3085: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3086: , p_error_proc_name => G_PKG_NAME||'.Delete_Measure'
3087: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 3132: BIS_UTILITIES_PVT.Add_Error_Message

3128: when others then
3129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3130: --added last two params
3131: l_error_tbl := x_error_tbl;
3132: BIS_UTILITIES_PVT.Add_Error_Message
3133: ( p_error_msg_id => SQLCODE
3134: , p_error_description => SQLERRM
3135: , p_error_proc_name => G_PKG_NAME||'.Delete_Measure'
3136: , p_error_table => l_error_tbl

Line 3171: BIS_UTILITIES_PVT.Add_Error_Message

3167: when others then
3168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3169: --added last two params
3170: l_error_tbl := x_error_tbl;
3171: BIS_UTILITIES_PVT.Add_Error_Message
3172: ( p_error_msg_id => SQLCODE
3173: , p_error_description => SQLERRM
3174: , p_error_proc_name => G_PKG_NAME||'.Translate_Measure'
3175: , p_error_table => l_error_tbl

Line 3231: BIS_UTILITIES_PVT.Add_Error_Message

3227: if (l_measure_rec_Orig.measure_id is NOT NULL) then
3228: if (l_measure_rec_Orig.measure_id <> p_Measure_Rec.Measure_Id) then
3229: --added last two params
3230: l_error_tbl := x_error_tbl;
3231: BIS_UTILITIES_PVT.Add_Error_Message
3232: ( p_error_msg_name => 'BIS_MEASURE_SHORT_NAME_UNIQUE'
3233: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3234: , p_error_proc_name => G_PKG_NAME||'.Translate_Measure'
3235: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 3287: BIS_UTILITIES_PVT.Add_Error_Message

3283: when others then
3284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3285: --added last two params
3286: l_error_tbl := x_error_tbl;
3287: BIS_UTILITIES_PVT.Add_Error_Message
3288: ( p_error_msg_id => SQLCODE
3289: , p_error_description => SQLERRM
3290: , p_error_proc_name => G_PKG_NAME||'.Translate_Measure'
3291: , p_error_table => l_error_tbl

Line 3329: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

3325: --when FND_API.G_EXC_ERROR then
3326: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
3327: l_error := FND_API.G_TRUE;
3328: l_error_Tbl_p := x_error_Tbl;
3329: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
3330: , l_error_Tbl
3331: , x_error_tbl
3332: );
3333: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3350: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

3346: --when FND_API.G_EXC_ERROR then
3347: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
3348: l_error := FND_API.G_TRUE;
3349: l_error_Tbl_p := x_error_Tbl;
3350: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
3351: , l_error_Tbl
3352: , x_error_tbl
3353: );
3354: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3371: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

3367: -- when FND_API.G_EXC_ERROR then
3368: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
3369: l_error := FND_API.G_TRUE;
3370: l_error_Tbl_p := x_error_Tbl;
3371: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
3372: , l_error_Tbl
3373: , x_error_tbl
3374: );
3375: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3392: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

3388: --when FND_API.G_EXC_ERROR then
3389: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
3390: l_error := FND_API.G_TRUE;
3391: l_error_Tbl_p := x_error_Tbl;
3392: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
3393: , l_error_Tbl
3394: , x_error_tbl
3395: );
3396: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3414: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

3410: -- when FND_API.G_EXC_ERROR then
3411: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
3412: l_error := FND_API.G_TRUE;
3413: l_error_Tbl_p := x_error_Tbl;
3414: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
3415: , l_error_Tbl
3416: , x_error_tbl
3417: );
3418: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3435: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

3431: --when FND_API.G_EXC_ERROR then
3432: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
3433: l_error := FND_API.G_TRUE;
3434: l_error_Tbl_p := x_error_Tbl;
3435: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
3436: , l_error_Tbl
3437: , x_error_tbl
3438: );
3439: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3456: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

3452: --when FND_API.G_EXC_ERROR then
3453: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
3454: l_error := FND_API.G_TRUE;
3455: l_error_Tbl_p := x_error_Tbl;
3456: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
3457: , l_error_Tbl
3458: , x_error_tbl
3459: );
3460: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3478: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

3474: --when FND_API.G_EXC_ERROR then
3475: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
3476: l_error := FND_API.G_TRUE;
3477: l_error_Tbl_p := x_error_Tbl;
3478: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
3479: , l_error_Tbl
3480: , x_error_tbl
3481: );
3482: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3499: BIS_UTILITIES_PVT.Add_Error_Message

3495: end if;
3496:
3497: if (l_region_code is not null and l_source_column is null) then
3498: l_error_tbl := x_error_tbl;
3499: BIS_UTILITIES_PVT.Add_Error_Message
3500: ( p_error_msg_name => 'BIS_SOURCE_COLUMN_ERR_TXT'
3501: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3502: , p_error_proc_name => G_PKG_NAME||'.Create_Measure'
3503: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 3525: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

3521: --when FND_API.G_EXC_ERROR then
3522: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
3523: l_error := FND_API.G_TRUE;
3524: l_error_Tbl_p := x_error_Tbl;
3525: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
3526: , l_error_Tbl
3527: , x_error_tbl
3528: );
3529: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3546: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

3542: --when FND_API.G_EXC_ERROR then
3543: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
3544: l_error := FND_API.G_TRUE;
3545: l_error_Tbl_p := x_error_Tbl;
3546: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
3547: , l_error_Tbl
3548: , x_error_tbl
3549: );
3550: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3567: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

3563: --when FND_API.G_EXC_ERROR then
3564: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
3565: l_error := FND_API.G_TRUE;
3566: l_error_Tbl_p := x_error_Tbl;
3567: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
3568: , l_error_Tbl
3569: , x_error_tbl
3570: );
3571: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3589: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

3585: --when FND_API.G_EXC_ERROR then
3586: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
3587: l_error := FND_API.G_TRUE;
3588: l_error_Tbl_p := x_error_Tbl;
3589: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
3590: , l_error_Tbl
3591: , x_error_tbl
3592: );
3593: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3609: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

3605: );
3606: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
3607: l_error := FND_API.G_TRUE;
3608: l_error_Tbl_p := x_error_Tbl;
3609: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
3610: , l_error_Tbl
3611: , x_error_tbl
3612: );
3613: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3631: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

3627: );
3628: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) then
3629: l_error := FND_API.G_TRUE;
3630: l_error_Tbl_p := x_error_Tbl;
3631: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
3632: , l_error_Tbl
3633: , x_error_tbl
3634: );
3635: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3650: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

3646: );
3647: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3648: l_error := FND_API.G_TRUE;
3649: l_error_Tbl_p := x_error_Tbl;
3650: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
3651: , l_error_Tbl
3652: , x_error_tbl
3653: );
3654: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3669: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p

3665: );
3666: IF(x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
3667: l_error := FND_API.G_TRUE;
3668: l_error_Tbl_p := x_error_Tbl;
3669: BIS_UTILITIES_PVT.concatenateErrorTables( l_error_Tbl_p
3670: , l_error_Tbl
3671: , x_error_tbl
3672: );
3673: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3696: BIS_UTILITIES_PVT.Add_Error_Message

3692: when others then
3693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3694: --added last two params
3695: l_error_Tbl := x_error_tbl;
3696: BIS_UTILITIES_PVT.Add_Error_Message
3697: ( p_error_msg_id => SQLCODE
3698: , p_error_description => SQLERRM
3699: , p_error_proc_name => G_PKG_NAME||'.Validate_Measure'
3700: , p_error_table => l_error_Tbl

Line 3745: l_convert := BIS_UTILITIES_PVT.Convert_to_ID

3741: end if;
3742: END;
3743: end if;
3744:
3745: l_convert := BIS_UTILITIES_PVT.Convert_to_ID
3746: ( x_Measure_Rec.Dimension1_ID
3747: , x_Measure_Rec.Dimension1_Short_Name
3748: , x_Measure_Rec.Dimension1_Name
3749: );

Line 3771: l_convert := BIS_UTILITIES_PVT.Convert_to_ID

3767: end if;
3768: END;
3769: end if;
3770:
3771: l_convert := BIS_UTILITIES_PVT.Convert_to_ID
3772: ( x_Measure_Rec.Dimension2_ID
3773: , x_Measure_Rec.Dimension2_Short_Name
3774: , x_Measure_Rec.Dimension2_Name
3775: );

Line 3796: l_convert := BIS_UTILITIES_PVT.Convert_to_ID

3792: end if;
3793: END;
3794: end if;
3795:
3796: l_convert := BIS_UTILITIES_PVT.Convert_to_ID
3797: ( x_Measure_Rec.Dimension3_ID
3798: , x_Measure_Rec.Dimension3_Short_Name
3799: , x_Measure_Rec.Dimension3_Name
3800: );

Line 3821: l_convert := BIS_UTILITIES_PVT.Convert_to_ID

3817: end if;
3818: END;
3819: end if;
3820:
3821: l_convert := BIS_UTILITIES_PVT.Convert_to_ID
3822: ( x_Measure_Rec.Dimension4_ID
3823: , x_Measure_Rec.Dimension4_Short_Name
3824: , x_Measure_Rec.Dimension4_Name
3825: );

Line 3846: l_convert := BIS_UTILITIES_PVT.Convert_to_ID

3842: end if;
3843: END;
3844: end if;
3845:
3846: l_convert := BIS_UTILITIES_PVT.Convert_to_ID
3847: ( x_Measure_Rec.Dimension5_ID
3848: , x_Measure_Rec.Dimension5_Short_Name
3849: , x_Measure_Rec.Dimension5_Name
3850: );

Line 3871: l_convert := BIS_UTILITIES_PVT.Convert_to_ID

3867: end if;
3868: END;
3869: end if;
3870:
3871: l_convert := BIS_UTILITIES_PVT.Convert_to_ID
3872: ( x_Measure_Rec.Dimension6_ID
3873: , x_Measure_Rec.Dimension6_Short_Name
3874: , x_Measure_Rec.Dimension6_Name
3875: );

Line 3896: l_convert := BIS_UTILITIES_PVT.Convert_to_ID

3892: end if;
3893: END;
3894: end if;
3895:
3896: l_convert := BIS_UTILITIES_PVT.Convert_to_ID
3897: ( x_Measure_Rec.Dimension7_ID
3898: , x_Measure_Rec.Dimension7_Short_Name
3899: , x_Measure_Rec.Dimension7_Name
3900: );

Line 3936: BIS_UTILITIES_PVT.Add_Error_Message

3932: when others then
3933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3934: --added last two params
3935: l_error_tbl := x_error_tbl;
3936: BIS_UTILITIES_PVT.Add_Error_Message
3937: ( p_error_msg_id => SQLCODE
3938: , p_error_description => SQLERRM
3939: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'
3940: , p_error_table => l_error_tbl

Line 3974: BIS_UTILITIES_PVT.Add_Error_Message

3970: else
3971: -- POLPULATE ERROR TABLE
3972: --added last two params
3973: l_error_tbl := x_error_tbl;
3974: BIS_UTILITIES_PVT.Add_Error_Message
3975: ( p_error_msg_name => 'BIS_NAME_SHORT_NAME_MISSING'
3976: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
3977: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'
3978: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 4001: BIS_UTILITIES_PVT.Add_Error_Message

3997: when others then
3998: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3999: --added last two params
4000: l_error_tbl := x_error_tbl;
4001: BIS_UTILITIES_PVT.Add_Error_Message
4002: ( p_error_msg_id => SQLCODE
4003: , p_error_description => SQLERRM
4004: , p_error_proc_name => G_PKG_NAME||'.Value_ID_Conversion'
4005: , p_error_table => l_error_tbl

Line 4043: BIS_UTILITIES_PVT.Add_Error_Message

4039: , x_error_Tbl
4040: );
4041: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4042: l_error_tbl := x_error_tbl;
4043: BIS_UTILITIES_PVT.Add_Error_Message
4044: ( p_error_msg_name => 'BIS_INVALID_MEASURE_VALUE'
4045: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
4046: , p_error_proc_name => G_PKG_NAME||'.Measure_Value_ID_Conversion'
4047: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 4070: BIS_UTILITIES_PVT.Add_Error_Message

4066: when others then
4067: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4068: --added last two params
4069: l_error_tbl := x_error_tbl;
4070: BIS_UTILITIES_PVT.Add_Error_Message
4071: ( p_error_msg_id => SQLCODE
4072: , p_error_description => SQLERRM
4073: , p_error_proc_name => G_PKG_NAME||'.Measure_Value_ID_Conversion'
4074: , p_error_table => l_error_tbl

Line 4097: l_convert := BIS_UTILITIES_PVT.Convert_to_ID

4093: BEGIN
4094: x_return_status := FND_API.G_RET_STS_SUCCESS;
4095: x_Measure_Rec := p_Measure_Rec;
4096:
4097: l_convert := BIS_UTILITIES_PVT.Convert_to_ID
4098: ( x_Measure_Rec.Dimension1_ID
4099: , x_Measure_Rec.Dimension1_Short_Name
4100: , x_Measure_Rec.Dimension1_Name
4101: );

Line 4119: BIS_UTILITIES_PVT.Add_Error_Message

4115: -- WHEN FND_API.G_EXC_ERROR then
4116: -- NULL;
4117: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4118: l_error_tbl := x_error_tbl;
4119: BIS_UTILITIES_PVT.Add_Error_Message
4120: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_VALUE'
4121: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
4122: , p_error_proc_name => G_PKG_NAME||'.Dimension_Value_ID_Conversion'
4123: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 4132: l_convert := BIS_UTILITIES_PVT.Convert_to_ID

4128: end if;
4129: END;
4130: end if;
4131:
4132: l_convert := BIS_UTILITIES_PVT.Convert_to_ID
4133: ( x_Measure_Rec.Dimension2_ID
4134: , x_Measure_Rec.Dimension2_Short_Name
4135: , x_Measure_Rec.Dimension2_Name
4136: );

Line 4153: BIS_UTILITIES_PVT.Add_Error_Message

4149: -- WHEN FND_API.G_EXC_ERROR then
4150: -- NULL;
4151: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4152: l_error_tbl := x_error_tbl;
4153: BIS_UTILITIES_PVT.Add_Error_Message
4154: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_VALUE'
4155: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
4156: , p_error_proc_name => G_PKG_NAME||'.Dimension_Value_ID_Conversion'
4157: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 4166: l_convert := BIS_UTILITIES_PVT.Convert_to_ID

4162: end if;
4163: END;
4164: end if;
4165:
4166: l_convert := BIS_UTILITIES_PVT.Convert_to_ID
4167: ( x_Measure_Rec.Dimension3_ID
4168: , x_Measure_Rec.Dimension3_Short_Name
4169: , x_Measure_Rec.Dimension3_Name
4170: );

Line 4187: BIS_UTILITIES_PVT.Add_Error_Message

4183: -- WHEN FND_API.G_EXC_ERROR then
4184: -- NULL;
4185: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4186: l_error_tbl := x_error_tbl;
4187: BIS_UTILITIES_PVT.Add_Error_Message
4188: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_VALUE'
4189: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
4190: , p_error_proc_name => G_PKG_NAME||'.Dimension_Value_ID_Conversion'
4191: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 4200: l_convert := BIS_UTILITIES_PVT.Convert_to_ID

4196: end if;
4197: END;
4198: end if;
4199:
4200: l_convert := BIS_UTILITIES_PVT.Convert_to_ID
4201: ( x_Measure_Rec.Dimension4_ID
4202: , x_Measure_Rec.Dimension4_Short_Name
4203: , x_Measure_Rec.Dimension4_Name
4204: );

Line 4221: BIS_UTILITIES_PVT.Add_Error_Message

4217: -- WHEN FND_API.G_EXC_ERROR then
4218: -- NULL;
4219: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4220: l_error_tbl := x_error_tbl;
4221: BIS_UTILITIES_PVT.Add_Error_Message
4222: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_VALUE'
4223: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
4224: , p_error_proc_name => G_PKG_NAME||'.Dimension_Value_ID_Conversion'
4225: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 4234: l_convert := BIS_UTILITIES_PVT.Convert_to_ID

4230: end if;
4231: END;
4232: end if;
4233:
4234: l_convert := BIS_UTILITIES_PVT.Convert_to_ID
4235: ( x_Measure_Rec.Dimension5_ID
4236: , x_Measure_Rec.Dimension5_Short_Name
4237: , x_Measure_Rec.Dimension5_Name
4238: );

Line 4255: BIS_UTILITIES_PVT.Add_Error_Message

4251: -- WHEN FND_API.G_EXC_ERROR then
4252: -- NULL;
4253: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4254: l_error_tbl := x_error_tbl;
4255: BIS_UTILITIES_PVT.Add_Error_Message
4256: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_VALUE'
4257: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
4258: , p_error_proc_name => G_PKG_NAME||'.Dimension_Value_ID_Conversion'
4259: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 4268: l_convert := BIS_UTILITIES_PVT.Convert_to_ID

4264: end if;
4265: END;
4266: end if;
4267:
4268: l_convert := BIS_UTILITIES_PVT.Convert_to_ID
4269: ( x_Measure_Rec.Dimension6_ID
4270: , x_Measure_Rec.Dimension6_Short_Name
4271: , x_Measure_Rec.Dimension6_Name
4272: );

Line 4289: BIS_UTILITIES_PVT.Add_Error_Message

4285: -- WHEN FND_API.G_EXC_ERROR then
4286: -- NULL;
4287: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4288: l_error_tbl := x_error_tbl;
4289: BIS_UTILITIES_PVT.Add_Error_Message
4290: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_VALUE'
4291: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
4292: , p_error_proc_name => G_PKG_NAME||'.Dimension_Value_ID_Conversion'
4293: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 4302: l_convert := BIS_UTILITIES_PVT.Convert_to_ID

4298: end if;
4299: END;
4300: end if;
4301:
4302: l_convert := BIS_UTILITIES_PVT.Convert_to_ID
4303: ( x_Measure_Rec.Dimension7_ID
4304: , x_Measure_Rec.Dimension7_Short_Name
4305: , x_Measure_Rec.Dimension7_Name
4306: );

Line 4323: BIS_UTILITIES_PVT.Add_Error_Message

4319: -- WHEN FND_API.G_EXC_ERROR then
4320: -- NULL;
4321: if x_return_status <> FND_API.G_RET_STS_SUCCESS then
4322: l_error_tbl := x_error_tbl;
4323: BIS_UTILITIES_PVT.Add_Error_Message
4324: ( p_error_msg_name => 'BIS_INVALID_DIMENSION_VALUE'
4325: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
4326: , p_error_proc_name => G_PKG_NAME||'.Dimension_Value_ID_Conversion'
4327: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 4350: BIS_UTILITIES_PVT.Add_Error_Message

4346: when others then
4347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4348: --added last two params
4349: l_error_tbl := x_error_tbl;
4350: BIS_UTILITIES_PVT.Add_Error_Message
4351: ( p_error_msg_id => SQLCODE
4352: , p_error_description => SQLERRM
4353: , p_error_proc_name => G_PKG_NAME||'.Dimension_Value_ID_Conversion'
4354: , p_error_table => l_error_tbl

Line 4407: BIS_UTILITIES_PVT.Add_Error_Message

4403: end loop;
4404:
4405: if (i = 0) then
4406: l_error_tbl := x_error_tbl;
4407: BIS_UTILITIES_PVT.Add_Error_Message
4408: ( p_error_msg_name => 'BIS_INVALID_MEASURE_VALUE'
4409: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
4410: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Measure_Dimensions'
4411: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 4439: BIS_UTILITIES_PVT.Add_Error_Message

4435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4436: IF ind_dim%ISOPEN THEN CLOSE ind_dim; END IF;
4437: --added last two params
4438: l_error_tbl := x_error_tbl;
4439: BIS_UTILITIES_PVT.Add_Error_Message
4440: ( p_error_msg_id => SQLCODE
4441: , p_error_description => SQLERRM
4442: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Measure_Dimensions'
4443: , p_error_table => l_error_tbl

Line 4480: BIS_UTILITIES_PVT.Add_Error_Message

4476: EXCEPTION
4477: WHEN NO_DATA_FOUND THEN
4478: --added this message
4479: l_error_tbl := x_error_tbl;
4480: BIS_UTILITIES_PVT.Add_Error_Message
4481: ( p_error_msg_name => 'BIS_INVALID_MEASURE_VALUE'
4482: , p_error_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR
4483: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Last_Update_Date'
4484: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 4501: BIS_UTILITIES_PVT.Add_Error_Message

4497: WHEN OTHERS THEN
4498: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
4499: --added last two params
4500: l_error_tbl := x_error_tbl;
4501: BIS_UTILITIES_PVT.Add_Error_Message
4502: ( p_error_msg_id => SQLCODE
4503: , p_error_description => SQLERRM
4504: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Last_Update_Date'
4505: , p_error_table => l_error_tbl

Line 4539: l_form_date := TO_DATE(p_timestamp, BIS_UTILITIES_PVT.G_DATE_FORMAT);

4535: , x_return_status => x_return_status
4536: , x_error_Tbl => x_error_Tbl
4537: );
4538: IF(p_timestamp IS NOT NULL) THEN
4539: l_form_date := TO_DATE(p_timestamp, BIS_UTILITIES_PVT.G_DATE_FORMAT);
4540: IF(l_form_date = l_last_update_date) THEN
4541: x_return_status := FND_API.G_TRUE;
4542: ELSE
4543: x_return_status := FND_API.G_FALSE;

Line 4562: BIS_UTILITIES_PVT.Add_Error_Message

4558: WHEN OTHERS THEN
4559: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
4560: --added last two params
4561: l_error_tbl := x_error_tbl;
4562: BIS_UTILITIES_PVT.Add_Error_Message
4563: ( p_error_msg_id => SQLCODE
4564: , p_error_description => SQLERRM
4565: , p_error_proc_name => G_PKG_NAME||'.Lock_Record'
4566: , p_error_table => l_error_tbl

Line 4639: BIS_UTILITIES_PVT.Add_Error_Message

4635: when others then
4636: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4637: --added last two params
4638: l_error_tbl := x_error_tbl;
4639: BIS_UTILITIES_PVT.Add_Error_Message
4640: ( p_error_msg_id => SQLCODE
4641: , p_error_description => SQLERRM
4642: , p_error_proc_name => G_PKG_NAME||'.Create_Application_Measure'
4643: , p_error_table => l_error_tbl

Line 4699: BIS_UTILITIES_PVT.Add_Error_Message

4695: when others then
4696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4697: --added last two params
4698: l_error_tbl := x_error_tbl;
4699: BIS_UTILITIES_PVT.Add_Error_Message
4700: ( p_error_msg_id => SQLCODE
4701: , p_error_description => SQLERRM
4702: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Application_Measures'
4703: , p_error_table => l_error_tbl

Line 4753: BIS_UTILITIES_PVT.Add_Error_Message

4749: when others then
4750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4751: --added last two params
4752: l_error_tbl := x_error_tbl;
4753: BIS_UTILITIES_PVT.Add_Error_Message
4754: ( p_error_msg_id => SQLCODE
4755: , p_error_description => SQLERRM
4756: , p_error_proc_name => G_PKG_NAME||'.Update_Application_Measure'
4757: , p_error_table => l_error_tbl

Line 4804: BIS_UTILITIES_PVT.Add_Error_Message

4800: when others then
4801: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4802: --added last two params
4803: l_error_tbl := x_error_tbl;
4804: BIS_UTILITIES_PVT.Add_Error_Message
4805: ( p_error_msg_id => SQLCODE
4806: , p_error_description => SQLERRM
4807: , p_error_proc_name => G_PKG_NAME||'.Delete_Application_Measure'
4808: , p_error_table => l_error_tbl

Line 4861: BIS_UTILITIES_PVT.Add_Error_Message

4857: when others then
4858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4859: --added last two params
4860: l_error_tbl := x_error_tbl;
4861: BIS_UTILITIES_PVT.Add_Error_Message
4862: ( p_error_msg_id => SQLCODE
4863: , p_error_description => SQLERRM
4864: , p_error_proc_name => G_PKG_NAME||'.Delete_Application_Measure'
4865: , p_error_table => l_error_tbl

Line 4910: BIS_UTILITIES_PVT.Add_Error_Message

4906: when others then
4907: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4908: --added last two params
4909: l_error_tbl := x_error_tbl;
4910: BIS_UTILITIES_PVT.Add_Error_Message
4911: ( p_error_msg_id => SQLCODE
4912: , p_error_description => SQLERRM
4913: , p_error_proc_name => G_PKG_NAME||'.Lock_Record'
4914: , p_error_table => l_error_tbl

Line 4959: BIS_UTILITIES_PVT.Add_Error_Message

4955: when others then
4956: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
4957: --added last two params
4958: l_error_tbl := x_error_tbl;
4959: BIS_UTILITIES_PVT.Add_Error_Message
4960: ( p_error_msg_id => SQLCODE
4961: , p_error_description => SQLERRM
4962: , p_error_proc_name => G_PKG_NAME||'.Retrieve_Last_Update_Date'
4963: , p_error_table => l_error_tbl

Line 5274: BIS_UTILITIES_PVT.Add_Error_Message

5270: ROLLBACK TO TransMeasByLangPvt;
5271: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5272: --added last two params
5273: l_error_tbl := x_error_tbl;
5274: BIS_UTILITIES_PVT.Add_Error_Message
5275: ( p_error_msg_id => SQLCODE
5276: , p_error_description => SQLERRM
5277: , p_error_proc_name => G_PKG_NAME||'.Translate_Measure_by_lang'
5278: , p_error_table => l_error_tbl

Line 5414: BIS_UTILITIES_PVT.Add_Error_Message

5410: );
5411:
5412: IF (l_return_status IS NOT NULL AND l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
5413: l_error_tbl := x_error_tbl;
5414: BIS_UTILITIES_PVT.Add_Error_Message
5415: ( p_error_msg_id => NULL
5416: , p_error_description => l_Msg_Data
5417: , p_error_proc_name => G_PKG_NAME||'.Create_Measure'
5418: , p_error_type => BIS_UTILITIES_PUB.G_ERROR

Line 5438: BIS_UTILITIES_PVT.Add_Error_Message

5434: when others then
5435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
5436: --added last two params
5437: l_error_tbl := x_error_tbl;
5438: BIS_UTILITIES_PVT.Add_Error_Message
5439: ( p_error_msg_id => SQLCODE
5440: , p_error_description => SQLERRM
5441: , p_error_proc_name => G_PKG_NAME||'.Translate_Measure_by_lang'
5442: , p_error_table => l_error_tbl