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

Line 1: PACKAGE BODY BSC_SIMULATION_VIEW_PUB AS

1: PACKAGE BODY BSC_SIMULATION_VIEW_PUB AS
2: /* $Header: BSCSIMPB.pls 120.3.12000000.1 2007/07/17 07:44:26 appldev noship $ */
3:
4: PROCEDURE Set_Obj_Kpi_Prototype
5: (

Line 73: l_Ak_Null_Tbl BSC_SIMULATION_VIEW_PUB.Bsc_Ak_Region_Items_Tbl_Type ;

69: l_kpi_short_name bis_indicators.short_name%TYPE;
70: l_formula VARCHAR2(32000);
71: l_count NUMBER;
72:
73: l_Ak_Null_Tbl BSC_SIMULATION_VIEW_PUB.Bsc_Ak_Region_Items_Tbl_Type ;
74: l_Ak_NotNull_Tbl BSC_SIMULATION_VIEW_PUB.Bsc_Ak_Region_Items_Tbl_Type ;
75:
76: CURSOR c_meas_null IS
77: SELECT v.attribute_code,

Line 74: l_Ak_NotNull_Tbl BSC_SIMULATION_VIEW_PUB.Bsc_Ak_Region_Items_Tbl_Type ;

70: l_formula VARCHAR2(32000);
71: l_count NUMBER;
72:
73: l_Ak_Null_Tbl BSC_SIMULATION_VIEW_PUB.Bsc_Ak_Region_Items_Tbl_Type ;
74: l_Ak_NotNull_Tbl BSC_SIMULATION_VIEW_PUB.Bsc_Ak_Region_Items_Tbl_Type ;
75:
76: CURSOR c_meas_null IS
77: SELECT v.attribute_code,
78: v.attribute2,

Line 85: AND v.attribute1 =BSC_SIMULATION_VIEW_PUB.c_MEASURE_NO_TARGET

81: FROM ak_region_items_vl v
82: ,bsc_sys_measures b
83: WHERE v.attribute2 =b.short_name
84: AND v.region_code =l_short_name
85: AND v.attribute1 =BSC_SIMULATION_VIEW_PUB.c_MEASURE_NO_TARGET
86: AND v.attribute3 IS NULL
87: ORDER BY v.display_sequence;
88:
89:

Line 99: AND v.attribute1 =BSC_SIMULATION_VIEW_PUB.c_MEASURE_NO_TARGET

95: FROM ak_region_items_vl v
96: ,bsc_sys_measures b
97: WHERE v.attribute2 =b.short_name
98: AND v.region_code =l_short_name
99: AND v.attribute1 =BSC_SIMULATION_VIEW_PUB.c_MEASURE_NO_TARGET
100: AND v.attribute3 IS NOT NULL
101: ORDER BY v.display_sequence;
102:
103: BEGIN

Line 281: ,X_SOURCE_TYPE => BSC_SIMULATION_VIEW_PUB.c_INDICATOR_TYPE

277:
278: BSC_SYS_IMAGES_MAP_PKG.INSERT_ROW
279: (
280: X_ROWID => l_str
281: ,X_SOURCE_TYPE => BSC_SIMULATION_VIEW_PUB.c_INDICATOR_TYPE
282: ,X_SOURCE_CODE => p_obj_id
283: ,X_TYPE => BSC_SIMULATION_VIEW_PUB.c_TYPE
284: ,X_IMAGE_ID => l_next_image_id
285: ,X_CREATION_DATE => SYSDATE

Line 283: ,X_TYPE => BSC_SIMULATION_VIEW_PUB.c_TYPE

279: (
280: X_ROWID => l_str
281: ,X_SOURCE_TYPE => BSC_SIMULATION_VIEW_PUB.c_INDICATOR_TYPE
282: ,X_SOURCE_CODE => p_obj_id
283: ,X_TYPE => BSC_SIMULATION_VIEW_PUB.c_TYPE
284: ,X_IMAGE_ID => l_next_image_id
285: ,X_CREATION_DATE => SYSDATE
286: ,X_CREATED_BY => fnd_global.user_id
287: ,X_LAST_UPDATE_DATE => SYSDATE

Line 338: WHERE bsim.source_type =BSC_SIMULATION_VIEW_PUB.c_INDICATOR_TYPE

334: SELECT COUNT(0)
335: INTO l_count
336: FROM bsc_sys_images bsi,
337: bsc_sys_images_map_vl bsim
338: WHERE bsim.source_type =BSC_SIMULATION_VIEW_PUB.c_INDICATOR_TYPE
339: AND bsim.source_code = p_obj_id
340: AND bsim.type = BSC_SIMULATION_VIEW_PUB.c_TYPE
341: AND bsim.image_id = p_image_id
342: AND bsim.image_id = bsi.image_id;

Line 340: AND bsim.type = BSC_SIMULATION_VIEW_PUB.c_TYPE

336: FROM bsc_sys_images bsi,
337: bsc_sys_images_map_vl bsim
338: WHERE bsim.source_type =BSC_SIMULATION_VIEW_PUB.c_INDICATOR_TYPE
339: AND bsim.source_code = p_obj_id
340: AND bsim.type = BSC_SIMULATION_VIEW_PUB.c_TYPE
341: AND bsim.image_id = p_image_id
342: AND bsim.image_id = bsi.image_id;
343:
344:

Line 351: WHERE source_type =BSC_SIMULATION_VIEW_PUB.c_INDICATOR_TYPE

347:
348: SELECT COUNT(0)
349: INTO l_count
350: FROM bsc_sys_images_map_TL
351: WHERE source_type =BSC_SIMULATION_VIEW_PUB.c_INDICATOR_TYPE
352: AND source_code = p_obj_id
353: AND type = BSC_SIMULATION_VIEW_PUB.c_TYPE
354: AND image_id = p_image_id
355: AND source_lang = USERENV('LANG');

Line 353: AND type = BSC_SIMULATION_VIEW_PUB.c_TYPE

349: INTO l_count
350: FROM bsc_sys_images_map_TL
351: WHERE source_type =BSC_SIMULATION_VIEW_PUB.c_INDICATOR_TYPE
352: AND source_code = p_obj_id
353: AND type = BSC_SIMULATION_VIEW_PUB.c_TYPE
354: AND image_id = p_image_id
355: AND source_lang = USERENV('LANG');
356:
357: IF (l_count > 0) THEN

Line 383: X_SOURCE_TYPE => BSC_SIMULATION_VIEW_PUB.c_INDICATOR_TYPE

379: END;
380:
381: BSC_SYS_IMAGES_MAP_PKG.UPDATE_ROW
382: (
383: X_SOURCE_TYPE => BSC_SIMULATION_VIEW_PUB.c_INDICATOR_TYPE
384: ,X_SOURCE_CODE => p_obj_id
385: ,X_TYPE => BSC_SIMULATION_VIEW_PUB.c_TYPE
386: ,X_IMAGE_ID => p_image_id
387: ,X_CREATION_DATE => SYSDATE

Line 385: ,X_TYPE => BSC_SIMULATION_VIEW_PUB.c_TYPE

381: BSC_SYS_IMAGES_MAP_PKG.UPDATE_ROW
382: (
383: X_SOURCE_TYPE => BSC_SIMULATION_VIEW_PUB.c_INDICATOR_TYPE
384: ,X_SOURCE_CODE => p_obj_id
385: ,X_TYPE => BSC_SIMULATION_VIEW_PUB.c_TYPE
386: ,X_IMAGE_ID => p_image_id
387: ,X_CREATION_DATE => SYSDATE
388: ,X_CREATED_BY => fnd_global.user_id
389: ,X_LAST_UPDATE_DATE => SYSDATE

Line 426: X_SOURCE_TYPE => BSC_SIMULATION_VIEW_PUB.c_INDICATOR_TYPE

422: END;
423:
424: BSC_SYS_IMAGES_MAP_PKG.UPDATE_ROW
425: (
426: X_SOURCE_TYPE => BSC_SIMULATION_VIEW_PUB.c_INDICATOR_TYPE
427: ,X_SOURCE_CODE => p_obj_id
428: ,X_TYPE => BSC_SIMULATION_VIEW_PUB.c_TYPE
429: ,X_IMAGE_ID => p_image_id
430: ,X_CREATION_DATE => SYSDATE

Line 428: ,X_TYPE => BSC_SIMULATION_VIEW_PUB.c_TYPE

424: BSC_SYS_IMAGES_MAP_PKG.UPDATE_ROW
425: (
426: X_SOURCE_TYPE => BSC_SIMULATION_VIEW_PUB.c_INDICATOR_TYPE
427: ,X_SOURCE_CODE => p_obj_id
428: ,X_TYPE => BSC_SIMULATION_VIEW_PUB.c_TYPE
429: ,X_IMAGE_ID => p_image_id
430: ,X_CREATION_DATE => SYSDATE
431: ,X_CREATED_BY => fnd_global.user_id
432: ,X_LAST_UPDATE_DATE => SYSDATE

Line 551: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Get_Objective_Details ';

547: WHEN NO_DATA_FOUND THEN
548: --DBMS_OUTPUT.PUT_LINE('FND_API.NO_DATA_FOUND -->');
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550: IF (x_msg_data IS NOT NULL) THEN
551: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Get_Objective_Details ';
552: ELSE
553: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Get_Objective_Details ';
554: END IF;
555: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 553: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Get_Objective_Details ';

549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550: IF (x_msg_data IS NOT NULL) THEN
551: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Get_Objective_Details ';
552: ELSE
553: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Get_Objective_Details ';
554: END IF;
555: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
556: WHEN OTHERS THEN
557: --DBMS_OUTPUT.PUT_LINE('FND_API.OTHERS -->');

Line 560: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Get_Objective_Details ';

556: WHEN OTHERS THEN
557: --DBMS_OUTPUT.PUT_LINE('FND_API.OTHERS -->');
558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
559: IF (x_msg_data IS NOT NULL) THEN
560: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Get_Objective_Details ';
561: ELSE
562: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Get_Objective_Details ';
563: END IF;
564: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 562: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Get_Objective_Details ';

558: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
559: IF (x_msg_data IS NOT NULL) THEN
560: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Get_Objective_Details ';
561: ELSE
562: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Get_Objective_Details ';
563: END IF;
564: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
565:
566: END Get_Objective_Details;

Line 638: IF(p_SimulateFlag=BSC_SIMULATION_VIEW_PUB.c_NON_SIM_NODE AND p_Node_Id =BSC_SIMULATION_VIEW_PUB.c_DEFAULT_SIM_NODE_ID)THEN

634: FND_MSG_PUB.INITIALIZE;
635: x_return_status := FND_API.G_RET_STS_SUCCESS;
636:
637: l_dataset_id := p_indicator_id;
638: IF(p_SimulateFlag=BSC_SIMULATION_VIEW_PUB.c_NON_SIM_NODE AND p_Node_Id =BSC_SIMULATION_VIEW_PUB.c_DEFAULT_SIM_NODE_ID)THEN
639: l_dataset_id := BSC_BIS_KPI_CRUD_PUB.Get_Dataset_Id(p_Node_Short_Name);
640: END IF;
641:
642: BSC_CUSTOM_VIEW_UI_WRAPPER.add_or_update_measure

Line 691: , p_object_type => BSC_SIMULATION_VIEW_PUB.C_TYPE_MEASURE_COLOR

687: (
688: p_tab_id => p_tab_id
689: , p_tab_view_id => p_tab_view_id
690: , p_object_id => p_color_object_id
691: , p_object_type => BSC_SIMULATION_VIEW_PUB.C_TYPE_MEASURE_COLOR
692: , p_label_text => BSC_SIMULATION_VIEW_PUB.C_MEASURE_COLOR
693: , p_text_flag => p_color_flag
694: , p_font_color => p_font_color
695: , p_font_size => p_font_size

Line 692: , p_label_text => BSC_SIMULATION_VIEW_PUB.C_MEASURE_COLOR

688: p_tab_id => p_tab_id
689: , p_tab_view_id => p_tab_view_id
690: , p_object_id => p_color_object_id
691: , p_object_type => BSC_SIMULATION_VIEW_PUB.C_TYPE_MEASURE_COLOR
692: , p_label_text => BSC_SIMULATION_VIEW_PUB.C_MEASURE_COLOR
693: , p_text_flag => p_color_flag
694: , p_font_color => p_font_color
695: , p_font_size => p_font_size
696: , p_font_style => p_font_style

Line 715: BSC_SIMULATION_VIEW_PUB.add_or_update_sim_node_props

711: END IF;
712:
713: --Now save the node properties
714:
715: BSC_SIMULATION_VIEW_PUB.add_or_update_sim_node_props
716: (
717: p_indicator => p_tab_view_id
718: ,p_Node_Id => l_dataset_id
719: ,p_Node_Name => p_Node_Name

Line 745: BSC_SIMULATION_VIEW_PUB.set_default_node

741: END IF;
742:
743: --Change the default node and set the objective to
744: -- the color change
745: BSC_SIMULATION_VIEW_PUB.set_default_node
746: (
747: p_indicator => p_tab_view_id
748: ,p_default_node => p_default_node
749: ,p_dataset_id => l_dataset_id

Line 758: BSC_SIMULATION_VIEW_PUB.Save_Color_Ranges

754: IF(x_return_status IS NOT NULL AND x_return_status <>FND_API.G_RET_STS_SUCCESS)THEN
755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
756: END IF;
757:
758: BSC_SIMULATION_VIEW_PUB.Save_Color_Ranges
759: (
760: p_indicator => p_tab_view_id
761: ,p_dataset_id => l_dataset_id
762: ,p_color_ranges => p_color_thresholds

Line 774: IF(p_SimulateFlag=BSC_SIMULATION_VIEW_PUB.c_NON_SIM_NODE)THEN

770:
771: --We need to set the color_flag in bsc_kpi_measure_props
772: --
773:
774: IF(p_SimulateFlag=BSC_SIMULATION_VIEW_PUB.c_NON_SIM_NODE)THEN
775:
776: BSC_SIMULATION_VIEW_PVT.Set_Kpi_Color_Method
777: (
778: p_indicator => p_tab_view_id

Line 840: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.add_or_update_measure ';

836: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
837: WHEN NO_DATA_FOUND THEN
838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839: IF (x_msg_data IS NOT NULL) THEN
840: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.add_or_update_measure ';
841: ELSE
842: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.add_or_update_measure ';
843: END IF;
844: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 842: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.add_or_update_measure ';

838: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
839: IF (x_msg_data IS NOT NULL) THEN
840: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.add_or_update_measure ';
841: ELSE
842: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.add_or_update_measure ';
843: END IF;
844: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
845: WHEN OTHERS THEN
846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 848: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.add_or_update_measure ';

844: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
845: WHEN OTHERS THEN
846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
847: IF (x_msg_data IS NOT NULL) THEN
848: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.add_or_update_measure ';
849: ELSE
850: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.add_or_update_measure ';
851: END IF;
852: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 850: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.add_or_update_measure ';

846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
847: IF (x_msg_data IS NOT NULL) THEN
848: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.add_or_update_measure ';
849: ELSE
850: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.add_or_update_measure ';
851: END IF;
852: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
853:
854: END add_or_update_measure;

Line 994: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.set_default_node ';

990: WHEN NO_DATA_FOUND THEN
991:
992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
993: IF (x_msg_data IS NOT NULL) THEN
994: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.set_default_node ';
995: ELSE
996: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.set_default_node ';
997: END IF;
998: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 996: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.set_default_node ';

992: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
993: IF (x_msg_data IS NOT NULL) THEN
994: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.set_default_node ';
995: ELSE
996: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.set_default_node ';
997: END IF;
998: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
999: WHEN OTHERS THEN
1000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1002: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.set_default_node ';

998: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
999: WHEN OTHERS THEN
1000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1001: IF (x_msg_data IS NOT NULL) THEN
1002: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.set_default_node ';
1003: ELSE
1004: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.set_default_node ';
1005: END IF;
1006: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1004: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.set_default_node ';

1000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1001: IF (x_msg_data IS NOT NULL) THEN
1002: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.set_default_node ';
1003: ELSE
1004: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.set_default_node ';
1005: END IF;
1006: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1007: END set_default_node;
1008:

Line 1059: AND property_code =BSC_SIMULATION_VIEW_PUB.c_SIM_NODE_ID;

1055: CURSOR c_default IS
1056: SELECT property_value
1057: FROM bsc_kpi_properties
1058: WHERE indicator = p_obj_Id
1059: AND property_code =BSC_SIMULATION_VIEW_PUB.c_SIM_NODE_ID;
1060:
1061: l_label_cur label_cur%ROWTYPE;
1062:
1063: BEGIN

Line 1146: BSC_SIMULATION_VIEW_PUB.set_default_node

1142: FROM bsc_kpi_tree_nodes_b
1143: WHERE indicator =p_obj_Id;
1144:
1145: IF(l_count=0) THEN
1146: BSC_SIMULATION_VIEW_PUB.set_default_node
1147: (
1148: p_indicator => p_obj_Id
1149: ,p_default_node => 1
1150: ,p_dataset_id => BSC_SIMULATION_VIEW_PUB.c_DEFAULT_DATASET_ID

Line 1150: ,p_dataset_id => BSC_SIMULATION_VIEW_PUB.c_DEFAULT_DATASET_ID

1146: BSC_SIMULATION_VIEW_PUB.set_default_node
1147: (
1148: p_indicator => p_obj_Id
1149: ,p_default_node => 1
1150: ,p_dataset_id => BSC_SIMULATION_VIEW_PUB.c_DEFAULT_DATASET_ID
1151: ,x_return_status => x_return_status
1152: ,x_msg_count => x_msg_count
1153: ,x_msg_data => x_msg_data
1154: );

Line 1185: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.remove_simulation_view_items ';

1181: WHEN NO_DATA_FOUND THEN
1182: ROLLBACK TO removesimviewitems;
1183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1184: IF (x_msg_data IS NOT NULL) THEN
1185: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.remove_simulation_view_items ';
1186: ELSE
1187: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.remove_simulation_view_items ';
1188: END IF;
1189: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1187: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.remove_simulation_view_items ';

1183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1184: IF (x_msg_data IS NOT NULL) THEN
1185: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.remove_simulation_view_items ';
1186: ELSE
1187: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.remove_simulation_view_items ';
1188: END IF;
1189: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1190: WHEN OTHERS THEN
1191: ROLLBACK TO removesimviewitems;

Line 1194: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.remove_simulation_view_items ';

1190: WHEN OTHERS THEN
1191: ROLLBACK TO removesimviewitems;
1192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1193: IF (x_msg_data IS NOT NULL) THEN
1194: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.remove_simulation_view_items ';
1195: ELSE
1196: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.remove_simulation_view_items ';
1197: END IF;
1198: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1196: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.remove_simulation_view_items ';

1192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1193: IF (x_msg_data IS NOT NULL) THEN
1194: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.remove_simulation_view_items ';
1195: ELSE
1196: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.remove_simulation_view_items ';
1197: END IF;
1198: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1199: END remove_simulation_view_items;
1200:

Line 1270: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Duplicate_kpi_metadata ';

1266: WHEN NO_DATA_FOUND THEN
1267: ROLLBACK TO Duplicatekpimetadata;
1268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1269: IF (x_msg_data IS NOT NULL) THEN
1270: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Duplicate_kpi_metadata ';
1271: ELSE
1272: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Duplicate_kpi_metadata ';
1273: END IF;
1274: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1272: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Duplicate_kpi_metadata ';

1268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1269: IF (x_msg_data IS NOT NULL) THEN
1270: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Duplicate_kpi_metadata ';
1271: ELSE
1272: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Duplicate_kpi_metadata ';
1273: END IF;
1274: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1275: WHEN OTHERS THEN
1276: ROLLBACK TO Duplicatekpimetadata;

Line 1279: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Duplicate_kpi_metadata ';

1275: WHEN OTHERS THEN
1276: ROLLBACK TO Duplicatekpimetadata;
1277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1278: IF (x_msg_data IS NOT NULL) THEN
1279: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Duplicate_kpi_metadata ';
1280: ELSE
1281: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Duplicate_kpi_metadata ';
1282: END IF;
1283: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1281: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Duplicate_kpi_metadata ';

1277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1278: IF (x_msg_data IS NOT NULL) THEN
1279: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Duplicate_kpi_metadata ';
1280: ELSE
1281: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Duplicate_kpi_metadata ';
1282: END IF;
1283: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1284:
1285: END Duplicate_kpi_metadata;

Line 1342: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Validate_Name_In_Tab ';

1338: WHEN NO_DATA_FOUND THEN
1339:
1340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1341: IF (x_msg_data IS NOT NULL) THEN
1342: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Validate_Name_In_Tab ';
1343: ELSE
1344: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Validate_Name_In_Tab ';
1345: END IF;
1346: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1344: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Validate_Name_In_Tab ';

1340: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1341: IF (x_msg_data IS NOT NULL) THEN
1342: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Validate_Name_In_Tab ';
1343: ELSE
1344: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Validate_Name_In_Tab ';
1345: END IF;
1346: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1347: WHEN OTHERS THEN
1348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1350: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Validate_Name_In_Tab ';

1346: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1347: WHEN OTHERS THEN
1348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1349: IF (x_msg_data IS NOT NULL) THEN
1350: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Validate_Name_In_Tab ';
1351: ELSE
1352: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Validate_Name_In_Tab ';
1353: END IF;
1354: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1352: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Validate_Name_In_Tab ';

1348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1349: IF (x_msg_data IS NOT NULL) THEN
1350: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Validate_Name_In_Tab ';
1351: ELSE
1352: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Validate_Name_In_Tab ';
1353: END IF;
1354: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1355:
1356:

Line 1409: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Add_Or_Update_YTD ';

1405: WHEN NO_DATA_FOUND THEN
1406:
1407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1408: IF (x_msg_data IS NOT NULL) THEN
1409: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Add_Or_Update_YTD ';
1410: ELSE
1411: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Add_Or_Update_YTD ';
1412: END IF;
1413: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1411: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Add_Or_Update_YTD ';

1407: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1408: IF (x_msg_data IS NOT NULL) THEN
1409: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Add_Or_Update_YTD ';
1410: ELSE
1411: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Add_Or_Update_YTD ';
1412: END IF;
1413: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1414: WHEN OTHERS THEN
1415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1417: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Add_Or_Update_YTD ';

1413: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1414: WHEN OTHERS THEN
1415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1416: IF (x_msg_data IS NOT NULL) THEN
1417: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Add_Or_Update_YTD ';
1418: ELSE
1419: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Add_Or_Update_YTD ';
1420: END IF;
1421: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1419: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Add_Or_Update_YTD ';

1415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1416: IF (x_msg_data IS NOT NULL) THEN
1417: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Add_Or_Update_YTD ';
1418: ELSE
1419: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Add_Or_Update_YTD ';
1420: END IF;
1421: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1422:
1423: END Add_Or_Update_YTD;

Line 1454: l_kpi_measure_id := BSC_SIMULATION_VIEW_PUB.Get_Kpi_Measure_Id

1450: BEGIN
1451: FND_MSG_PUB.INITIALIZE;
1452: x_return_status := FND_API.G_RET_STS_SUCCESS;
1453:
1454: l_kpi_measure_id := BSC_SIMULATION_VIEW_PUB.Get_Kpi_Measure_Id
1455: (
1456: p_indicator => p_indicator
1457: , p_dataset_id => p_dataset_id
1458: );

Line 1474: , p_color_type => BSC_SIMULATION_VIEW_PUB.c_PERCENT_OF_TARGET

1470: (
1471: p_commit => FND_API.G_FALSE
1472: , p_objective_id => p_indicator
1473: , p_kpi_measure_id => l_kpi_measure_id
1474: , p_color_type => BSC_SIMULATION_VIEW_PUB.c_PERCENT_OF_TARGET
1475: , p_threshold_color => p_color_ranges
1476: , p_cascade_shared => TRUE
1477: , p_time_stamp => NULL
1478: , x_return_status => x_return_status

Line 1565: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.set_color_ranges ';

1561: WHEN NO_DATA_FOUND THEN
1562:
1563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1564: IF (x_msg_data IS NOT NULL) THEN
1565: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.set_color_ranges ';
1566: ELSE
1567: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.set_color_ranges ';
1568: END IF;
1569: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1567: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.set_color_ranges ';

1563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1564: IF (x_msg_data IS NOT NULL) THEN
1565: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.set_color_ranges ';
1566: ELSE
1567: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.set_color_ranges ';
1568: END IF;
1569: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1570: WHEN OTHERS THEN
1571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1573: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.set_color_ranges ';

1569: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1570: WHEN OTHERS THEN
1571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1572: IF (x_msg_data IS NOT NULL) THEN
1573: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.set_color_ranges ';
1574: ELSE
1575: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.set_color_ranges ';
1576: END IF;
1577: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1575: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.set_color_ranges ';

1571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1572: IF (x_msg_data IS NOT NULL) THEN
1573: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.set_color_ranges ';
1574: ELSE
1575: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.set_color_ranges ';
1576: END IF;
1577: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1578:
1579: END Save_Color_Ranges;

Line 1648: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.copy_sim_metadata ';

1644: WHEN NO_DATA_FOUND THEN
1645:
1646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1647: IF (x_msg_data IS NOT NULL) THEN
1648: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.copy_sim_metadata ';
1649: ELSE
1650: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.copy_sim_metadata ';
1651: END IF;
1652: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1650: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.copy_sim_metadata ';

1646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1647: IF (x_msg_data IS NOT NULL) THEN
1648: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.copy_sim_metadata ';
1649: ELSE
1650: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.copy_sim_metadata ';
1651: END IF;
1652: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1653: WHEN OTHERS THEN
1654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1656: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.copy_sim_metadata ';

1652: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1653: WHEN OTHERS THEN
1654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1655: IF (x_msg_data IS NOT NULL) THEN
1656: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.copy_sim_metadata ';
1657: ELSE
1658: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.copy_sim_metadata ';
1659: END IF;
1660: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1658: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.copy_sim_metadata ';

1654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1655: IF (x_msg_data IS NOT NULL) THEN
1656: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.copy_sim_metadata ';
1657: ELSE
1658: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.copy_sim_metadata ';
1659: END IF;
1660: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1661:
1662: END copy_sim_metadata;

Line 1755: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Set_Sim_Key_Values ';

1751: WHEN NO_DATA_FOUND THEN
1752:
1753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1754: IF (x_msg_data IS NOT NULL) THEN
1755: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Set_Sim_Key_Values ';
1756: ELSE
1757: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Set_Sim_Key_Values ';
1758: END IF;
1759: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1757: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Set_Sim_Key_Values ';

1753: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1754: IF (x_msg_data IS NOT NULL) THEN
1755: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Set_Sim_Key_Values ';
1756: ELSE
1757: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Set_Sim_Key_Values ';
1758: END IF;
1759: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1760: WHEN OTHERS THEN
1761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1763: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Set_Sim_Key_Values ';

1759: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1760: WHEN OTHERS THEN
1761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1762: IF (x_msg_data IS NOT NULL) THEN
1763: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Set_Sim_Key_Values ';
1764: ELSE
1765: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Set_Sim_Key_Values ';
1766: END IF;
1767: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1765: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Set_Sim_Key_Values ';

1761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1762: IF (x_msg_data IS NOT NULL) THEN
1763: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Set_Sim_Key_Values ';
1764: ELSE
1765: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Set_Sim_Key_Values ';
1766: END IF;
1767: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1768:
1769: END Set_Sim_Key_Values;

Line 1785: AND property_code =BSC_SIMULATION_VIEW_PUB.c_SIM_NODE_ID;

1781: CURSOR c_def_node IS
1782: SELECT property_value
1783: FROM bsc_kpi_properties
1784: WHERE indicator =p_indicator
1785: AND property_code =BSC_SIMULATION_VIEW_PUB.c_SIM_NODE_ID;
1786:
1787: l_count NUMBER;
1788: l_kpi_measure_id bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;
1789:

Line 1794: l_kpi_measure_id := BSC_SIMULATION_VIEW_PUB.Get_Kpi_Measure_Id

1790: BEGIN
1791: FND_MSG_PUB.INITIALIZE;
1792: x_return_status := FND_API.G_RET_STS_SUCCESS;
1793:
1794: l_kpi_measure_id := BSC_SIMULATION_VIEW_PUB.Get_Kpi_Measure_Id
1795: (
1796: p_indicator => p_indicator
1797: , p_dataset_id => p_dataset_id
1798: );

Line 1852: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Set_Obj_Kpi_Prototype ';

1848: WHEN NO_DATA_FOUND THEN
1849:
1850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1851: IF (x_msg_data IS NOT NULL) THEN
1852: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Set_Obj_Kpi_Prototype ';
1853: ELSE
1854: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Set_Obj_Kpi_Prototype ';
1855: END IF;
1856: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);

Line 1854: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Set_Obj_Kpi_Prototype ';

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

Line 1860: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Set_Obj_Kpi_Prototype ';

1856: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1857: WHEN OTHERS THEN
1858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1859: IF (x_msg_data IS NOT NULL) THEN
1860: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Set_Obj_Kpi_Prototype ';
1861: ELSE
1862: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Set_Obj_Kpi_Prototype ';
1863: END IF;
1864: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);

Line 1862: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Set_Obj_Kpi_Prototype ';

1858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1859: IF (x_msg_data IS NOT NULL) THEN
1860: x_msg_data := x_msg_data||' -> BSC_SIMULATION_VIEW_PUB.Set_Obj_Kpi_Prototype ';
1861: ELSE
1862: x_msg_data := SQLERRM||' at BSC_SIMULATION_VIEW_PUB.Set_Obj_Kpi_Prototype ';
1863: END IF;
1864: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1865:
1866: END Set_Obj_Kpi_Prototype;

Line 1868: END BSC_SIMULATION_VIEW_PUB;

1864: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1865:
1866: END Set_Obj_Kpi_Prototype;
1867:
1868: END BSC_SIMULATION_VIEW_PUB;