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_SIMULATION_VIEW_PVT dependencies on FND_API

Line 180: IF(p_copy_Ak_Tables=FND_API.G_TRUE)THEN

176: x_kpi_metadata_tables(x_Table_Number).table_column := BSC_SIMULATION_VIEW_PVT.C_INDICATOR ;
177: x_kpi_metadata_tables(x_Table_Number).duplicate_data := bsc_utility.YES;
178: x_kpi_metadata_tables(x_Table_Number).mls_table := bsc_utility.YES;
179:
180: IF(p_copy_Ak_Tables=FND_API.G_TRUE)THEN
181:
182: x_Table_Number := x_Table_Number + 1;
183: x_kpi_metadata_tables(x_Table_Number).table_name := 'AK_REGIONS';
184: x_kpi_metadata_tables(x_Table_Number).table_type := BSC_SIMULATION_VIEW_PVT.C_AK_TABLE ;

Line 601: x_return_status := FND_API.G_RET_STS_SUCCESS;

597:
598: BEGIN
599: SAVEPOINT Duplicatekpimetadata;
600: FND_MSG_PUB.INITIALIZE;
601: x_return_status := FND_API.G_RET_STS_SUCCESS;
602:
603:
604: --Need to check if the records already exists for duplicate objective
605: --if yes then don't need to copy any records

Line 618: p_copy_Ak_Tables => FND_API.G_FALSE

614: BSC_APPS.Init_Bsc_Apps;
615:
616: BSC_SIMULATION_VIEW_PVT.Init_Sim_Tables_Array
617: (
618: p_copy_Ak_Tables => FND_API.G_FALSE
619: ,x_Table_Number => l_Table_Number
620: ,x_kpi_metadata_tables => l_kpi_metadata_tables
621: );
622:

Line 720: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN

716: ,x_return_status => x_return_status
717: ,x_msg_count => x_msg_count
718: ,x_msg_data => x_msg_data
719: );
720: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;
723: END IF;
724:

Line 721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

717: ,x_msg_count => x_msg_count
718: ,x_msg_data => x_msg_data
719: );
720: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;
723: END IF;
724:
725: EXCEPTION

Line 726: WHEN FND_API.G_EXC_ERROR THEN

722: END IF;
723: END IF;
724:
725: EXCEPTION
726: WHEN FND_API.G_EXC_ERROR THEN
727: ROLLBACK TO Duplicatekpimetadata;
728: FND_MSG_PUB.Count_And_Get
729: ( p_encoded => FND_API.G_FALSE
730: , p_count => x_msg_count

Line 729: ( p_encoded => FND_API.G_FALSE

725: EXCEPTION
726: WHEN FND_API.G_EXC_ERROR THEN
727: ROLLBACK TO Duplicatekpimetadata;
728: FND_MSG_PUB.Count_And_Get
729: ( p_encoded => FND_API.G_FALSE
730: , p_count => x_msg_count
731: , p_data => x_msg_data
732: );
733: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

Line 733: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

729: ( p_encoded => FND_API.G_FALSE
730: , p_count => x_msg_count
731: , p_data => x_msg_data
732: );
733: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
736: ROLLBACK TO Duplicatekpimetadata;
737: FND_MSG_PUB.Count_And_Get

Line 734: x_return_status := FND_API.G_RET_STS_ERROR;

730: , p_count => x_msg_count
731: , p_data => x_msg_data
732: );
733: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
736: ROLLBACK TO Duplicatekpimetadata;
737: FND_MSG_PUB.Count_And_Get
738: ( p_encoded => FND_API.G_FALSE

Line 735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

731: , p_data => x_msg_data
732: );
733: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
736: ROLLBACK TO Duplicatekpimetadata;
737: FND_MSG_PUB.Count_And_Get
738: ( p_encoded => FND_API.G_FALSE
739: , p_count => x_msg_count

Line 738: ( p_encoded => FND_API.G_FALSE

734: x_return_status := FND_API.G_RET_STS_ERROR;
735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
736: ROLLBACK TO Duplicatekpimetadata;
737: FND_MSG_PUB.Count_And_Get
738: ( p_encoded => FND_API.G_FALSE
739: , p_count => x_msg_count
740: , p_data => x_msg_data
741: );
742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

738: ( p_encoded => FND_API.G_FALSE
739: , p_count => x_msg_count
740: , p_data => x_msg_data
741: );
742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
743: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
744: WHEN NO_DATA_FOUND THEN
745: ROLLBACK TO Duplicatekpimetadata;
746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 743: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

739: , p_count => x_msg_count
740: , p_data => x_msg_data
741: );
742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
743: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
744: WHEN NO_DATA_FOUND THEN
745: ROLLBACK TO Duplicatekpimetadata;
746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
747: IF (x_msg_data IS NOT NULL) THEN

Line 746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

742: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
743: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
744: WHEN NO_DATA_FOUND THEN
745: ROLLBACK TO Duplicatekpimetadata;
746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
747: IF (x_msg_data IS NOT NULL) THEN
748: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Duplicate_kpi_metadata ';
749: ELSE
750: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Duplicate_kpi_metadata ';

Line 755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

751: END IF;
752: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
753: WHEN OTHERS THEN
754: ROLLBACK TO Duplicatekpimetadata;
755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
756: IF (x_msg_data IS NOT NULL) THEN
757: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Duplicate_kpi_metadata ';
758: ELSE
759: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Duplicate_kpi_metadata ';

Line 793: x_return_status := FND_API.G_RET_STS_SUCCESS;

789:
790: BEGIN
791: SAVEPOINT AddOrUpdateYTD;
792: FND_MSG_PUB.INITIALIZE;
793: x_return_status := FND_API.G_RET_STS_SUCCESS;
794:
795: l_YTD :=p_YTD;
796:
797: --We need to check if the record exists in BIS_AK_REGION_EXTENSION table

Line 816: p_commit => FND_API.G_FALSE

812: IF(l_count=0) THEN
813:
814: BIS_REGION_EXTENSION_PVT.CREATE_REGION_EXTN_RECORD
815: (
816: p_commit => FND_API.G_FALSE
817: ,pRegionCode => cd.region_code
818: ,pRegionAppId => cd.region_application_id
819: ,pAttribute16 => NULL
820: ,pAttribute17 => NULL

Line 849: p_commit => FND_API.G_FALSE

845:
846: ELSE
847: BIS_REGION_EXTENSION_PVT.UPDATE_REGION_EXTN_RECORD
848: (
849: p_commit => FND_API.G_FALSE
850: ,pRegionCode => cd.region_code
851: ,pRegionAppId => cd.region_application_id
852: ,pAttribute16 => NULL
853: ,pAttribute17 => NULL

Line 907: WHEN FND_API.G_EXC_ERROR THEN

903: END IF;
904: END LOOP;
905:
906: EXCEPTION
907: WHEN FND_API.G_EXC_ERROR THEN
908: ROLLBACK TO AddOrUpdateYTD;
909: FND_MSG_PUB.Count_And_Get
910: ( p_encoded => FND_API.G_FALSE
911: , p_count => x_msg_count

Line 910: ( p_encoded => FND_API.G_FALSE

906: EXCEPTION
907: WHEN FND_API.G_EXC_ERROR THEN
908: ROLLBACK TO AddOrUpdateYTD;
909: FND_MSG_PUB.Count_And_Get
910: ( p_encoded => FND_API.G_FALSE
911: , p_count => x_msg_count
912: , p_data => x_msg_data
913: );
914: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

Line 914: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

910: ( p_encoded => FND_API.G_FALSE
911: , p_count => x_msg_count
912: , p_data => x_msg_data
913: );
914: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
915: x_return_status := FND_API.G_RET_STS_ERROR;
916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
917: ROLLBACK TO AddOrUpdateYTD;
918: FND_MSG_PUB.Count_And_Get

Line 915: x_return_status := FND_API.G_RET_STS_ERROR;

911: , p_count => x_msg_count
912: , p_data => x_msg_data
913: );
914: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
915: x_return_status := FND_API.G_RET_STS_ERROR;
916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
917: ROLLBACK TO AddOrUpdateYTD;
918: FND_MSG_PUB.Count_And_Get
919: ( p_encoded => FND_API.G_FALSE

Line 916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

912: , p_data => x_msg_data
913: );
914: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
915: x_return_status := FND_API.G_RET_STS_ERROR;
916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
917: ROLLBACK TO AddOrUpdateYTD;
918: FND_MSG_PUB.Count_And_Get
919: ( p_encoded => FND_API.G_FALSE
920: , p_count => x_msg_count

Line 919: ( p_encoded => FND_API.G_FALSE

915: x_return_status := FND_API.G_RET_STS_ERROR;
916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
917: ROLLBACK TO AddOrUpdateYTD;
918: FND_MSG_PUB.Count_And_Get
919: ( p_encoded => FND_API.G_FALSE
920: , p_count => x_msg_count
921: , p_data => x_msg_data
922: );
923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

919: ( p_encoded => FND_API.G_FALSE
920: , p_count => x_msg_count
921: , p_data => x_msg_data
922: );
923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
924: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
925: WHEN NO_DATA_FOUND THEN
926: ROLLBACK TO AddOrUpdateYTD;
927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 924: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

920: , p_count => x_msg_count
921: , p_data => x_msg_data
922: );
923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
924: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
925: WHEN NO_DATA_FOUND THEN
926: ROLLBACK TO AddOrUpdateYTD;
927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
928: IF (x_msg_data IS NOT NULL) THEN

Line 927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

923: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
924: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
925: WHEN NO_DATA_FOUND THEN
926: ROLLBACK TO AddOrUpdateYTD;
927: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
928: IF (x_msg_data IS NOT NULL) THEN
929: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Add_Or_Update_YTD ';
930: ELSE
931: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Add_Or_Update_YTD ';

Line 936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

932: END IF;
933: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
934: WHEN OTHERS THEN
935: ROLLBACK TO AddOrUpdateYTD;
936: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
937: IF (x_msg_data IS NOT NULL) THEN
938: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Add_Or_Update_YTD ';
939: ELSE
940: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Add_Or_Update_YTD ';

Line 961: x_return_status := FND_API.G_RET_STS_SUCCESS;

957: l_kpi_measure_rec BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec;
958: BEGIN
959: SAVEPOINT SetKpiColorFlag;
960: FND_MSG_PUB.INITIALIZE;
961: x_return_status := FND_API.G_RET_STS_SUCCESS;
962:
963: l_kpi_measure_id := BSC_SIMULATION_VIEW_PUB.Get_Kpi_Measure_Id
964: (
965: p_indicator => p_indicator

Line 985: p_commit => FND_API.G_FALSE

981: l_kpi_measure_rec.color_by_total := p_color_by_total;
982:
983:
984: BSC_KPI_MEASURE_PROPS_PUB.Update_Kpi_Measure_Props (
985: p_commit => FND_API.G_FALSE
986: , p_kpi_measure_rec => l_kpi_measure_rec
987: , p_cascade_shared => TRUE
988: , x_return_status => x_return_status
989: , x_msg_count => x_msg_count

Line 993: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS)THEN

989: , x_msg_count => x_msg_count
990: , x_msg_data => x_msg_data
991: );
992:
993: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS)THEN
994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
995: END IF;
996:
997: EXCEPTION

Line 994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

990: , x_msg_data => x_msg_data
991: );
992:
993: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS)THEN
994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
995: END IF;
996:
997: EXCEPTION
998: WHEN FND_API.G_EXC_ERROR THEN

Line 998: WHEN FND_API.G_EXC_ERROR THEN

994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
995: END IF;
996:
997: EXCEPTION
998: WHEN FND_API.G_EXC_ERROR THEN
999: ROLLBACK TO SetKpiColorFlag;
1000: FND_MSG_PUB.Count_And_Get
1001: ( p_encoded => FND_API.G_FALSE
1002: , p_count => x_msg_count

Line 1001: ( p_encoded => FND_API.G_FALSE

997: EXCEPTION
998: WHEN FND_API.G_EXC_ERROR THEN
999: ROLLBACK TO SetKpiColorFlag;
1000: FND_MSG_PUB.Count_And_Get
1001: ( p_encoded => FND_API.G_FALSE
1002: , p_count => x_msg_count
1003: , p_data => x_msg_data
1004: );
1005: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

Line 1005: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

1001: ( p_encoded => FND_API.G_FALSE
1002: , p_count => x_msg_count
1003: , p_data => x_msg_data
1004: );
1005: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1006: x_return_status := FND_API.G_RET_STS_ERROR;
1007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1008: ROLLBACK TO SetKpiColorFlag;
1009: FND_MSG_PUB.Count_And_Get

Line 1006: x_return_status := FND_API.G_RET_STS_ERROR;

1002: , p_count => x_msg_count
1003: , p_data => x_msg_data
1004: );
1005: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1006: x_return_status := FND_API.G_RET_STS_ERROR;
1007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1008: ROLLBACK TO SetKpiColorFlag;
1009: FND_MSG_PUB.Count_And_Get
1010: ( p_encoded => FND_API.G_FALSE

Line 1007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1003: , p_data => x_msg_data
1004: );
1005: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1006: x_return_status := FND_API.G_RET_STS_ERROR;
1007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1008: ROLLBACK TO SetKpiColorFlag;
1009: FND_MSG_PUB.Count_And_Get
1010: ( p_encoded => FND_API.G_FALSE
1011: , p_count => x_msg_count

Line 1010: ( p_encoded => FND_API.G_FALSE

1006: x_return_status := FND_API.G_RET_STS_ERROR;
1007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1008: ROLLBACK TO SetKpiColorFlag;
1009: FND_MSG_PUB.Count_And_Get
1010: ( p_encoded => FND_API.G_FALSE
1011: , p_count => x_msg_count
1012: , p_data => x_msg_data
1013: );
1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1010: ( p_encoded => FND_API.G_FALSE
1011: , p_count => x_msg_count
1012: , p_data => x_msg_data
1013: );
1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1015: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1016: WHEN NO_DATA_FOUND THEN
1017: ROLLBACK TO SetKpiColorFlag;
1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1015: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

1011: , p_count => x_msg_count
1012: , p_data => x_msg_data
1013: );
1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1015: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1016: WHEN NO_DATA_FOUND THEN
1017: ROLLBACK TO SetKpiColorFlag;
1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1019: IF (x_msg_data IS NOT NULL) THEN

Line 1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1014: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1015: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1016: WHEN NO_DATA_FOUND THEN
1017: ROLLBACK TO SetKpiColorFlag;
1018: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1019: IF (x_msg_data IS NOT NULL) THEN
1020: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Set_Kpi_Color_Flag ';
1021: ELSE
1022: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Set_Kpi_Color_Flag ';

Line 1027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1023: END IF;
1024: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1025: WHEN OTHERS THEN
1026: ROLLBACK TO SetKpiColorFlag;
1027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1028: IF (x_msg_data IS NOT NULL) THEN
1029: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Set_Kpi_Color_Flag ';
1030: ELSE
1031: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Set_Kpi_Color_Flag ';

Line 1061: x_return_status := FND_API.G_RET_STS_SUCCESS;

1057:
1058: BEGIN
1059: SAVEPOINT SetKpiColorMethod;
1060: FND_MSG_PUB.INITIALIZE;
1061: x_return_status := FND_API.G_RET_STS_SUCCESS;
1062:
1063: l_count :=0;
1064:
1065: SELECT COUNT(0)

Line 1095: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN

1091: , x_msg_count => x_msg_count
1092: , x_msg_data => x_msg_data
1093: );
1094:
1095: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1097: END IF;
1098:
1099: IF(cd.property_value =p_dataset_id) THEN

Line 1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1092: , x_msg_data => x_msg_data
1093: );
1094:
1095: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1097: END IF;
1098:
1099: IF(cd.property_value =p_dataset_id) THEN
1100: BSC_KPI_COLOR_PROPERTIES_PUB.Obj_Prototype_Flag_Change

Line 1108: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN

1104: , x_return_status => x_return_status
1105: , x_msg_count => x_msg_count
1106: , x_msg_data => x_msg_data
1107: );
1108: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1110: END IF;
1111: END IF;
1112:

Line 1109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1105: , x_msg_count => x_msg_count
1106: , x_msg_data => x_msg_data
1107: );
1108: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1109: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1110: END IF;
1111: END IF;
1112:
1113: END IF;

Line 1118: WHEN FND_API.G_EXC_ERROR THEN

1114: END LOOP;
1115:
1116:
1117: EXCEPTION
1118: WHEN FND_API.G_EXC_ERROR THEN
1119: ROLLBACK TO SetKpiColorMethod;
1120: FND_MSG_PUB.Count_And_Get
1121: ( p_encoded => FND_API.G_FALSE
1122: , p_count => x_msg_count

Line 1121: ( p_encoded => FND_API.G_FALSE

1117: EXCEPTION
1118: WHEN FND_API.G_EXC_ERROR THEN
1119: ROLLBACK TO SetKpiColorMethod;
1120: FND_MSG_PUB.Count_And_Get
1121: ( p_encoded => FND_API.G_FALSE
1122: , p_count => x_msg_count
1123: , p_data => x_msg_data
1124: );
1125: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

Line 1125: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

1121: ( p_encoded => FND_API.G_FALSE
1122: , p_count => x_msg_count
1123: , p_data => x_msg_data
1124: );
1125: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1126: x_return_status := FND_API.G_RET_STS_ERROR;
1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1128: ROLLBACK TO SetKpiColorMethod;
1129: FND_MSG_PUB.Count_And_Get

Line 1126: x_return_status := FND_API.G_RET_STS_ERROR;

1122: , p_count => x_msg_count
1123: , p_data => x_msg_data
1124: );
1125: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1126: x_return_status := FND_API.G_RET_STS_ERROR;
1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1128: ROLLBACK TO SetKpiColorMethod;
1129: FND_MSG_PUB.Count_And_Get
1130: ( p_encoded => FND_API.G_FALSE

Line 1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1123: , p_data => x_msg_data
1124: );
1125: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1126: x_return_status := FND_API.G_RET_STS_ERROR;
1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1128: ROLLBACK TO SetKpiColorMethod;
1129: FND_MSG_PUB.Count_And_Get
1130: ( p_encoded => FND_API.G_FALSE
1131: , p_count => x_msg_count

Line 1130: ( p_encoded => FND_API.G_FALSE

1126: x_return_status := FND_API.G_RET_STS_ERROR;
1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1128: ROLLBACK TO SetKpiColorMethod;
1129: FND_MSG_PUB.Count_And_Get
1130: ( p_encoded => FND_API.G_FALSE
1131: , p_count => x_msg_count
1132: , p_data => x_msg_data
1133: );
1134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1130: ( p_encoded => FND_API.G_FALSE
1131: , p_count => x_msg_count
1132: , p_data => x_msg_data
1133: );
1134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1135: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1136: WHEN NO_DATA_FOUND THEN
1137: ROLLBACK TO SetKpiColorMethod;
1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1135: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

1131: , p_count => x_msg_count
1132: , p_data => x_msg_data
1133: );
1134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1135: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1136: WHEN NO_DATA_FOUND THEN
1137: ROLLBACK TO SetKpiColorMethod;
1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1139: IF (x_msg_data IS NOT NULL) THEN

Line 1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1135: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1136: WHEN NO_DATA_FOUND THEN
1137: ROLLBACK TO SetKpiColorMethod;
1138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1139: IF (x_msg_data IS NOT NULL) THEN
1140: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Set_Kpi_Color_Method ';
1141: ELSE
1142: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Set_Kpi_Color_Method ';

Line 1147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1143: END IF;
1144: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1145: WHEN OTHERS THEN
1146: ROLLBACK TO SetKpiColorMethod;
1147: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1148: IF (x_msg_data IS NOT NULL) THEN
1149: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Set_Kpi_Color_Method ';
1150: ELSE
1151: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Set_Kpi_Color_Method ';

Line 1215: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN

1211: , x_return_status => x_return_status
1212: , x_msg_count => x_msg_count
1213: , x_msg_data => x_msg_data
1214: );
1215: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1217: END IF;
1218:
1219: END IF;

Line 1216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1212: , x_msg_count => x_msg_count
1213: , x_msg_data => x_msg_data
1214: );
1215: IF(x_return_status <>FND_API.G_RET_STS_SUCCESS) THEN
1216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1217: END IF;
1218:
1219: END IF;
1220: END IF;

Line 1223: WHEN FND_API.G_EXC_ERROR THEN

1219: END IF;
1220: END IF;
1221: END IF;
1222: EXCEPTION
1223: WHEN FND_API.G_EXC_ERROR THEN
1224: FND_MSG_PUB.Count_And_Get
1225: ( p_encoded => FND_API.G_FALSE
1226: , p_count => x_msg_count
1227: , p_data => x_msg_data

Line 1225: ( p_encoded => FND_API.G_FALSE

1221: END IF;
1222: EXCEPTION
1223: WHEN FND_API.G_EXC_ERROR THEN
1224: FND_MSG_PUB.Count_And_Get
1225: ( p_encoded => FND_API.G_FALSE
1226: , p_count => x_msg_count
1227: , p_data => x_msg_data
1228: );
1229: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

Line 1229: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

1225: ( p_encoded => FND_API.G_FALSE
1226: , p_count => x_msg_count
1227: , p_data => x_msg_data
1228: );
1229: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1230: x_return_status := FND_API.G_RET_STS_ERROR;
1231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1232: FND_MSG_PUB.Count_And_Get
1233: ( p_encoded => FND_API.G_FALSE

Line 1230: x_return_status := FND_API.G_RET_STS_ERROR;

1226: , p_count => x_msg_count
1227: , p_data => x_msg_data
1228: );
1229: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1230: x_return_status := FND_API.G_RET_STS_ERROR;
1231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1232: FND_MSG_PUB.Count_And_Get
1233: ( p_encoded => FND_API.G_FALSE
1234: , p_count => x_msg_count

Line 1231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1227: , p_data => x_msg_data
1228: );
1229: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1230: x_return_status := FND_API.G_RET_STS_ERROR;
1231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1232: FND_MSG_PUB.Count_And_Get
1233: ( p_encoded => FND_API.G_FALSE
1234: , p_count => x_msg_count
1235: , p_data => x_msg_data

Line 1233: ( p_encoded => FND_API.G_FALSE

1229: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1230: x_return_status := FND_API.G_RET_STS_ERROR;
1231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1232: FND_MSG_PUB.Count_And_Get
1233: ( p_encoded => FND_API.G_FALSE
1234: , p_count => x_msg_count
1235: , p_data => x_msg_data
1236: );
1237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1233: ( p_encoded => FND_API.G_FALSE
1234: , p_count => x_msg_count
1235: , p_data => x_msg_data
1236: );
1237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1238: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1239: WHEN NO_DATA_FOUND THEN
1240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1241: IF (x_msg_data IS NOT NULL) THEN

Line 1238: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

1234: , p_count => x_msg_count
1235: , p_data => x_msg_data
1236: );
1237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1238: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1239: WHEN NO_DATA_FOUND THEN
1240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1241: IF (x_msg_data IS NOT NULL) THEN
1242: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.set_default_node ';

Line 1240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1236: );
1237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1238: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1239: WHEN NO_DATA_FOUND THEN
1240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1241: IF (x_msg_data IS NOT NULL) THEN
1242: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.set_default_node ';
1243: ELSE
1244: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.set_default_node ';

Line 1248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1244: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.set_default_node ';
1245: END IF;
1246: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1247: WHEN OTHERS THEN
1248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1249: IF (x_msg_data IS NOT NULL) THEN
1250: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.set_default_node ';
1251: ELSE
1252: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.set_default_node ';

Line 1285: x_return_status := FND_API.G_RET_STS_SUCCESS;

1281:
1282: BEGIN
1283: SAVEPOINT copysimmetadata;
1284: FND_MSG_PUB.INITIALIZE;
1285: x_return_status := FND_API.G_RET_STS_SUCCESS;
1286:
1287: BSC_APPS.Init_Bsc_Apps;
1288:
1289: BSC_SIMULATION_VIEW_PVT.Init_Sim_Tables_Array

Line 1291: p_copy_Ak_Tables => FND_API.G_TRUE

1287: BSC_APPS.Init_Bsc_Apps;
1288:
1289: BSC_SIMULATION_VIEW_PVT.Init_Sim_Tables_Array
1290: (
1291: p_copy_Ak_Tables => FND_API.G_TRUE
1292: ,x_Table_Number => l_Table_Number
1293: ,x_kpi_metadata_tables => l_kpi_metadata_tables
1294: );
1295:

Line 1370: x_return_status := FND_API.G_RET_STS_SUCCESS;

1366:
1367: BEGIN
1368: SAVEPOINT SetAkFormatId;
1369: FND_MSG_PUB.INITIALIZE;
1370: x_return_status := FND_API.G_RET_STS_SUCCESS;
1371:
1372: FOR cd IN c_ind LOOP
1373:
1374: l_region_code := cd.short_name;

Line 1400: WHEN FND_API.G_EXC_ERROR THEN

1396:
1397: END LOOP;
1398:
1399: EXCEPTION
1400: WHEN FND_API.G_EXC_ERROR THEN
1401: ROLLBACK TO SetAkFormatId;
1402: FND_MSG_PUB.Count_And_Get
1403: ( p_encoded => FND_API.G_FALSE
1404: , p_count => x_msg_count

Line 1403: ( p_encoded => FND_API.G_FALSE

1399: EXCEPTION
1400: WHEN FND_API.G_EXC_ERROR THEN
1401: ROLLBACK TO SetAkFormatId;
1402: FND_MSG_PUB.Count_And_Get
1403: ( p_encoded => FND_API.G_FALSE
1404: , p_count => x_msg_count
1405: , p_data => x_msg_data
1406: );
1407: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

Line 1407: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

1403: ( p_encoded => FND_API.G_FALSE
1404: , p_count => x_msg_count
1405: , p_data => x_msg_data
1406: );
1407: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1408: x_return_status := FND_API.G_RET_STS_ERROR;
1409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1410: ROLLBACK TO SetAkFormatId;
1411: FND_MSG_PUB.Count_And_Get

Line 1408: x_return_status := FND_API.G_RET_STS_ERROR;

1404: , p_count => x_msg_count
1405: , p_data => x_msg_data
1406: );
1407: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1408: x_return_status := FND_API.G_RET_STS_ERROR;
1409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1410: ROLLBACK TO SetAkFormatId;
1411: FND_MSG_PUB.Count_And_Get
1412: ( p_encoded => FND_API.G_FALSE

Line 1409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1405: , p_data => x_msg_data
1406: );
1407: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1408: x_return_status := FND_API.G_RET_STS_ERROR;
1409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1410: ROLLBACK TO SetAkFormatId;
1411: FND_MSG_PUB.Count_And_Get
1412: ( p_encoded => FND_API.G_FALSE
1413: , p_count => x_msg_count

Line 1412: ( p_encoded => FND_API.G_FALSE

1408: x_return_status := FND_API.G_RET_STS_ERROR;
1409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1410: ROLLBACK TO SetAkFormatId;
1411: FND_MSG_PUB.Count_And_Get
1412: ( p_encoded => FND_API.G_FALSE
1413: , p_count => x_msg_count
1414: , p_data => x_msg_data
1415: );
1416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1412: ( p_encoded => FND_API.G_FALSE
1413: , p_count => x_msg_count
1414: , p_data => x_msg_data
1415: );
1416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1417: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1418: WHEN NO_DATA_FOUND THEN
1419: ROLLBACK TO SetAkFormatId;
1420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1417: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

1413: , p_count => x_msg_count
1414: , p_data => x_msg_data
1415: );
1416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1417: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1418: WHEN NO_DATA_FOUND THEN
1419: ROLLBACK TO SetAkFormatId;
1420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1421: IF (x_msg_data IS NOT NULL) THEN

Line 1420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1416: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1417: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1418: WHEN NO_DATA_FOUND THEN
1419: ROLLBACK TO SetAkFormatId;
1420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1421: IF (x_msg_data IS NOT NULL) THEN
1422: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Set_Ak_Format_Id ';
1423: ELSE
1424: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Set_Ak_Format_Id ';

Line 1429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1425: END IF;
1426: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1427: WHEN OTHERS THEN
1428: ROLLBACK TO SetAkFormatId;
1429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1430: IF (x_msg_data IS NOT NULL) THEN
1431: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Set_Ak_Format_Id ';
1432: ELSE
1433: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Set_Ak_Format_Id ';

Line 1477: x_return_status := FND_API.G_RET_STS_SUCCESS;

1473: --flag the objective to the same flag as master
1474: -- also copy the default node value to the shared objective
1475: SAVEPOINT HandleSharedObject;
1476: FND_MSG_PUB.INITIALIZE;
1477: x_return_status := FND_API.G_RET_STS_SUCCESS;
1478: l_count := 0;
1479:
1480: FOR cd IN c_kpi_ids LOOP
1481:

Line 1494: p_commit => FND_API.G_FALSE

1490: l_count := l_count + 1;
1491:
1492: BSC_KPI_PUB.Delete_Sim_Tree_Data
1493: (
1494: p_commit => FND_API.G_FALSE
1495: , p_Bsc_Kpi_Entity_Rec => l_Bsc_Kpi_Entity_Rec
1496: , x_return_status => x_return_status
1497: , x_msg_count => x_msg_count
1498: , x_msg_data => x_msg_data

Line 1501: IF (x_return_status IS NOT NULL AND x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1497: , x_msg_count => x_msg_count
1498: , x_msg_data => x_msg_data
1499: );
1500:
1501: IF (x_return_status IS NOT NULL AND x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1503: END IF;
1504:
1505: END LOOP;

Line 1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1498: , x_msg_data => x_msg_data
1499: );
1500:
1501: IF (x_return_status IS NOT NULL AND x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1502: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1503: END IF;
1504:
1505: END LOOP;
1506:

Line 1515: p_copy_Ak_Tables => FND_API.G_TRUE

1511: BSC_APPS.Init_Bsc_Apps;
1512:
1513: BSC_SIMULATION_VIEW_PVT.Init_Sim_Tables_Array
1514: (
1515: p_copy_Ak_Tables => FND_API.G_TRUE
1516: ,x_Table_Number => l_Table_Number
1517: ,x_kpi_metadata_tables => l_kpi_metadata_tables
1518: );
1519:

Line 1550: ( p_commit => FND_API.G_FALSE

1546: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Secondary_Value := BSC_SIMULATION_VIEW_PUB.C_EMPTY;
1547: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id := l_target_kpi;
1548:
1549: BSC_KPI_PVT.Update_Kpi_Properties
1550: ( p_commit => FND_API.G_FALSE
1551: ,p_Bsc_Kpi_Entity_Rec => l_Bsc_Kpi_Entity_Rec
1552: ,x_return_status => x_return_status
1553: ,x_msg_count => x_msg_count
1554: ,x_msg_data => x_msg_data

Line 1556: IF (x_return_status IS NOT NULL AND x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1552: ,x_return_status => x_return_status
1553: ,x_msg_count => x_msg_count
1554: ,x_msg_data => x_msg_data
1555: );
1556: IF (x_return_status IS NOT NULL AND x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1558: END IF;
1559: END IF;
1560: END LOOP;

Line 1557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1553: ,x_msg_count => x_msg_count
1554: ,x_msg_data => x_msg_data
1555: );
1556: IF (x_return_status IS NOT NULL AND x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1558: END IF;
1559: END IF;
1560: END LOOP;
1561: END IF;

Line 1563: WHEN FND_API.G_EXC_ERROR THEN

1559: END IF;
1560: END LOOP;
1561: END IF;
1562: EXCEPTION
1563: WHEN FND_API.G_EXC_ERROR THEN
1564: ROLLBACK TO HandleSharedObject;
1565: FND_MSG_PUB.Count_And_Get
1566: ( p_encoded => FND_API.G_FALSE
1567: , p_count => x_msg_count

Line 1566: ( p_encoded => FND_API.G_FALSE

1562: EXCEPTION
1563: WHEN FND_API.G_EXC_ERROR THEN
1564: ROLLBACK TO HandleSharedObject;
1565: FND_MSG_PUB.Count_And_Get
1566: ( p_encoded => FND_API.G_FALSE
1567: , p_count => x_msg_count
1568: , p_data => x_msg_data
1569: );
1570: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

Line 1570: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

1566: ( p_encoded => FND_API.G_FALSE
1567: , p_count => x_msg_count
1568: , p_data => x_msg_data
1569: );
1570: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1571: x_return_status := FND_API.G_RET_STS_ERROR;
1572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1573: ROLLBACK TO HandleSharedObject;
1574: FND_MSG_PUB.Count_And_Get

Line 1571: x_return_status := FND_API.G_RET_STS_ERROR;

1567: , p_count => x_msg_count
1568: , p_data => x_msg_data
1569: );
1570: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1571: x_return_status := FND_API.G_RET_STS_ERROR;
1572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1573: ROLLBACK TO HandleSharedObject;
1574: FND_MSG_PUB.Count_And_Get
1575: ( p_encoded => FND_API.G_FALSE

Line 1572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1568: , p_data => x_msg_data
1569: );
1570: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1571: x_return_status := FND_API.G_RET_STS_ERROR;
1572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1573: ROLLBACK TO HandleSharedObject;
1574: FND_MSG_PUB.Count_And_Get
1575: ( p_encoded => FND_API.G_FALSE
1576: , p_count => x_msg_count

Line 1575: ( p_encoded => FND_API.G_FALSE

1571: x_return_status := FND_API.G_RET_STS_ERROR;
1572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1573: ROLLBACK TO HandleSharedObject;
1574: FND_MSG_PUB.Count_And_Get
1575: ( p_encoded => FND_API.G_FALSE
1576: , p_count => x_msg_count
1577: , p_data => x_msg_data
1578: );
1579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1575: ( p_encoded => FND_API.G_FALSE
1576: , p_count => x_msg_count
1577: , p_data => x_msg_data
1578: );
1579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1580: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1581: WHEN NO_DATA_FOUND THEN
1582: ROLLBACK TO HandleSharedObject;
1583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1580: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

1576: , p_count => x_msg_count
1577: , p_data => x_msg_data
1578: );
1579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1580: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1581: WHEN NO_DATA_FOUND THEN
1582: ROLLBACK TO HandleSharedObject;
1583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1584: IF (x_msg_data IS NOT NULL) THEN

Line 1583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1580: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1581: WHEN NO_DATA_FOUND THEN
1582: ROLLBACK TO HandleSharedObject;
1583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1584: IF (x_msg_data IS NOT NULL) THEN
1585: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Handle_Shared_Objectives ';
1586: ELSE
1587: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Handle_Shared_Objectives ';

Line 1592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1588: END IF;
1589: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1590: WHEN OTHERS THEN
1591: ROLLBACK TO HandleSharedObject;
1592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1593: IF (x_msg_data IS NOT NULL) THEN
1594: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Handle_Shared_Objectives ';
1595: ELSE
1596: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Handle_Shared_Objectives ';

Line 1610: p_commit IN VARCHAR2 := FND_API.G_FALSE

1606: -- It will also attach all the chosen dimension objects to this group
1607: ************************************************************************************/
1608:
1609: PROCEDURE Copy_Dimension_Group (
1610: p_commit IN VARCHAR2 := FND_API.G_FALSE
1611: , p_Indicator IN NUMBER
1612: , p_Region_Code IN VARCHAR2
1613: , p_Old_Region_Code IN VARCHAR2
1614: , p_New_Dim_Levels IN FND_TABLE_OF_NUMBER

Line 1651: x_return_status := FND_API.G_RET_STS_SUCCESS;

1647: TABLE(CAST(p_New_Dim_Levels AS FND_TABLE_OF_NUMBER)));
1648:
1649: BEGIN
1650: FND_MSG_PUB.Initialize;
1651: x_return_status := FND_API.G_RET_STS_SUCCESS;
1652:
1653: SAVEPOINT BscSimCopyDimGrp;
1654:
1655: SELECT

Line 1666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1662: short_name = p_Region_Code;
1663:
1664: IF l_Count > 0 THEN
1665: BSC_APPS.Write_Line_Log('Dimension with short Name[ ' ||p_Region_Code||'] already exists' , BSC_APPS.OUTPUT_FILE);
1666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1667: END IF;
1668:
1669: BSC_BIS_DIMENSION_PUB.Create_Dimension (
1670: p_commit => FND_API.G_FALSE

Line 1670: p_commit => FND_API.G_FALSE

1666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1667: END IF;
1668:
1669: BSC_BIS_DIMENSION_PUB.Create_Dimension (
1670: p_commit => FND_API.G_FALSE
1671: ,p_dim_short_name => p_Region_Code
1672: ,p_display_name => p_Region_Code
1673: ,p_description => p_Region_Code
1674: ,p_dim_obj_short_names => NULL

Line 1677: ,p_hide => FND_API.G_TRUE

1673: ,p_description => p_Region_Code
1674: ,p_dim_obj_short_names => NULL
1675: ,p_application_id => 271
1676: ,p_create_view => 1
1677: ,p_hide => FND_API.G_TRUE
1678: ,x_return_status => x_return_status
1679: ,x_msg_count => x_msg_count
1680: ,x_msg_data => x_msg_data
1681: );

Line 1682: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1678: ,x_return_status => x_return_status
1679: ,x_msg_count => x_msg_count
1680: ,x_msg_data => x_msg_data
1681: );
1682: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1684: END IF;
1685:
1686: FOR cd IN c_DimObjShtNames LOOP

Line 1683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1679: ,x_msg_count => x_msg_count
1680: ,x_msg_data => x_msg_data
1681: );
1682: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1683: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1684: END IF;
1685:
1686: FOR cd IN c_DimObjShtNames LOOP
1687: IF l_DimObj_Sht_Names IS NULL THEN

Line 1696: p_commit => FND_API.G_FALSE

1692: END LOOP;
1693: IF LENGTH(l_DimObj_Sht_Names) > 1 THEN
1694:
1695: BSC_BIS_DIMENSION_PUB.Assign_Dimension_Objects (
1696: p_commit => FND_API.G_FALSE
1697: ,p_dim_short_name => p_Region_Code
1698: ,p_dim_obj_short_names => l_DimObj_Sht_Names
1699: ,p_create_view => 1
1700: ,p_Restrict_Dim_Validate => NULL

Line 1705: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1701: ,x_return_status => x_return_status
1702: ,x_msg_count => x_msg_count
1703: ,x_msg_data => x_msg_data
1704: );
1705: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1707: END IF;
1708:
1709: END IF;

Line 1706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1702: ,x_msg_count => x_msg_count
1703: ,x_msg_data => x_msg_data
1704: );
1705: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1706: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1707: END IF;
1708:
1709: END IF;
1710:

Line 1711: IF (p_commit = FND_API.G_TRUE) THEN

1707: END IF;
1708:
1709: END IF;
1710:
1711: IF (p_commit = FND_API.G_TRUE) THEN
1712: COMMIT;
1713: END IF;
1714:
1715: EXCEPTION

Line 1716: WHEN FND_API.G_EXC_ERROR THEN

1712: COMMIT;
1713: END IF;
1714:
1715: EXCEPTION
1716: WHEN FND_API.G_EXC_ERROR THEN
1717: ROLLBACK TO BscSimCopyDimGrp;
1718: IF (x_msg_data IS NULL) THEN
1719: FND_MSG_PUB.Count_And_Get
1720: ( p_encoded => FND_API.G_FALSE

Line 1720: ( p_encoded => FND_API.G_FALSE

1716: WHEN FND_API.G_EXC_ERROR THEN
1717: ROLLBACK TO BscSimCopyDimGrp;
1718: IF (x_msg_data IS NULL) THEN
1719: FND_MSG_PUB.Count_And_Get
1720: ( p_encoded => FND_API.G_FALSE
1721: , p_count => x_msg_count
1722: , p_data => x_msg_data
1723: );
1724: END IF;

Line 1725: x_return_status := FND_API.G_RET_STS_ERROR;

1721: , p_count => x_msg_count
1722: , p_data => x_msg_data
1723: );
1724: END IF;
1725: x_return_status := FND_API.G_RET_STS_ERROR;
1726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1727: ROLLBACK TO BscSimCopyDimGrp;
1728: IF (x_msg_data IS NULL) THEN
1729: FND_MSG_PUB.Count_And_Get

Line 1726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1722: , p_data => x_msg_data
1723: );
1724: END IF;
1725: x_return_status := FND_API.G_RET_STS_ERROR;
1726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1727: ROLLBACK TO BscSimCopyDimGrp;
1728: IF (x_msg_data IS NULL) THEN
1729: FND_MSG_PUB.Count_And_Get
1730: ( p_encoded => FND_API.G_FALSE

Line 1730: ( p_encoded => FND_API.G_FALSE

1726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1727: ROLLBACK TO BscSimCopyDimGrp;
1728: IF (x_msg_data IS NULL) THEN
1729: FND_MSG_PUB.Count_And_Get
1730: ( p_encoded => FND_API.G_FALSE
1731: , p_count => x_msg_count
1732: , p_data => x_msg_data
1733: );
1734: END IF;

Line 1735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1731: , p_count => x_msg_count
1732: , p_data => x_msg_data
1733: );
1734: END IF;
1735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1736: WHEN NO_DATA_FOUND THEN
1737: ROLLBACK TO BscSimCopyDimGrp;
1738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1739: IF (x_msg_data IS NOT NULL) THEN

Line 1738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1734: END IF;
1735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1736: WHEN NO_DATA_FOUND THEN
1737: ROLLBACK TO BscSimCopyDimGrp;
1738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1739: IF (x_msg_data IS NOT NULL) THEN
1740: x_msg_data := x_msg_data || ' ->BSC_SIMULATION_VIEW_PVT.Copy_Dimension_Group ';
1741: ELSE
1742: x_msg_data := SQLERRM || 'at BSC_SIMULATION_VIEW_PVT.Copy_Dimension_Group ';

Line 1746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1742: x_msg_data := SQLERRM || 'at BSC_SIMULATION_VIEW_PVT.Copy_Dimension_Group ';
1743: END IF;
1744: WHEN OTHERS THEN
1745: ROLLBACK TO BscSimCopyDimGrp;
1746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1747: IF (x_msg_data IS NOT NULL) THEN
1748: x_msg_data := x_msg_data || ' ->BSC_SIMULATION_VIEW_PVT.Copy_Dimension_Group ';
1749: ELSE
1750: x_msg_data := SQLERRM || ' at BSC_SIMULATION_VIEW_PVT.Copy_Dimension_Group ';

Line 1785: x_return_status := FND_API.G_RET_STS_SUCCESS;

1781: l_dim_set_id NUMBER :=0;
1782:
1783: BEGIN
1784: FND_MSG_PUB.INITIALIZE;
1785: x_return_status := FND_API.G_RET_STS_SUCCESS;
1786: IF(p_ind_Sht_Name IS NOT NULL)THEN
1787:
1788: FOR cd IN c_form_functions LOOP
1789: l_parameters := cd.parameters;

Line 1822: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS)THEN

1818: , x_msg_count => x_msg_count
1819: , x_msg_data => x_msg_data
1820: );
1821:
1822: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS)THEN
1823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1824: END IF;
1825: END LOOP;
1826: END IF;

Line 1823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1819: , x_msg_data => x_msg_data
1820: );
1821:
1822: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS)THEN
1823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1824: END IF;
1825: END LOOP;
1826: END IF;
1827: END IF;

Line 1830: WHEN FND_API.G_EXC_ERROR THEN

1826: END IF;
1827: END IF;
1828: END IF;
1829: EXCEPTION
1830: WHEN FND_API.G_EXC_ERROR THEN
1831: FND_MSG_PUB.Count_And_Get
1832: ( p_encoded => FND_API.G_FALSE
1833: , p_count => x_msg_count
1834: , p_data => x_msg_data

Line 1832: ( p_encoded => FND_API.G_FALSE

1828: END IF;
1829: EXCEPTION
1830: WHEN FND_API.G_EXC_ERROR THEN
1831: FND_MSG_PUB.Count_And_Get
1832: ( p_encoded => FND_API.G_FALSE
1833: , p_count => x_msg_count
1834: , p_data => x_msg_data
1835: );
1836: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

Line 1836: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

1832: ( p_encoded => FND_API.G_FALSE
1833: , p_count => x_msg_count
1834: , p_data => x_msg_data
1835: );
1836: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1837: x_return_status := FND_API.G_RET_STS_ERROR;
1838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1839: FND_MSG_PUB.Count_And_Get
1840: ( p_encoded => FND_API.G_FALSE

Line 1837: x_return_status := FND_API.G_RET_STS_ERROR;

1833: , p_count => x_msg_count
1834: , p_data => x_msg_data
1835: );
1836: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1837: x_return_status := FND_API.G_RET_STS_ERROR;
1838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1839: FND_MSG_PUB.Count_And_Get
1840: ( p_encoded => FND_API.G_FALSE
1841: , p_count => x_msg_count

Line 1838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1834: , p_data => x_msg_data
1835: );
1836: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1837: x_return_status := FND_API.G_RET_STS_ERROR;
1838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1839: FND_MSG_PUB.Count_And_Get
1840: ( p_encoded => FND_API.G_FALSE
1841: , p_count => x_msg_count
1842: , p_data => x_msg_data

Line 1840: ( p_encoded => FND_API.G_FALSE

1836: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1837: x_return_status := FND_API.G_RET_STS_ERROR;
1838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1839: FND_MSG_PUB.Count_And_Get
1840: ( p_encoded => FND_API.G_FALSE
1841: , p_count => x_msg_count
1842: , p_data => x_msg_data
1843: );
1844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1840: ( p_encoded => FND_API.G_FALSE
1841: , p_count => x_msg_count
1842: , p_data => x_msg_data
1843: );
1844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1845: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1846: WHEN NO_DATA_FOUND THEN
1847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1848: IF (x_msg_data IS NOT NULL) THEN

Line 1845: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

1841: , p_count => x_msg_count
1842: , p_data => x_msg_data
1843: );
1844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1845: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1846: WHEN NO_DATA_FOUND THEN
1847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1848: IF (x_msg_data IS NOT NULL) THEN
1849: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Set_Sim_Key_Values ';

Line 1847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1843: );
1844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1845: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1846: WHEN NO_DATA_FOUND THEN
1847: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1848: IF (x_msg_data IS NOT NULL) THEN
1849: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Set_Sim_Key_Values ';
1850: ELSE
1851: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Set_Sim_Key_Values ';

Line 1855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1851: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Set_Sim_Key_Values ';
1852: END IF;
1853: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1854: WHEN OTHERS THEN
1855: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1856: IF (x_msg_data IS NOT NULL) THEN
1857: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Set_Sim_Key_Values ';
1858: ELSE
1859: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Set_Sim_Key_Values ';