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

Line 313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

309: END IF;
310: OPEN c_kpi_measure_props_exist(l_kpi_measure_rec.indicator, l_kpi_measure_rec.kpi_measure_id);
311: FETCH c_kpi_measure_props_exist INTO l_kpi_measure_props_exist;
312: IF c_kpi_measure_props_exist%NOTFOUND THEN
313: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
314: END IF;
315: CLOSE c_kpi_measure_props_exist;
316:
317: IF l_kpi_measure_props_exist = 0 THEN

Line 340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

336:
337: l_default_kpi_measure_id := BSC_COLOR_CALC_UTIL.Get_Default_Kpi_Measure_Id(l_kpi_measure_rec.indicator);
338: IF l_default_kpi_measure_id IS NULL THEN
339: x_error_msg := 'l_default_kpi_measure_id is NULL for Objective = ' || l_kpi_measure_rec.indicator || ' ;';
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;
342:
343: IF l_default_kpi_measure_id IS NOT NULL THEN
344: l_kpi_measure_props_rec.disable_color := get_disable_color

Line 364: ( p_commit => FND_API.G_FALSE

360: );
361: END IF;
362:
363: BSC_KPI_MEASURE_PROPS_PUB.Create_Kpi_Measure_Props
364: ( p_commit => FND_API.G_FALSE
365: , p_kpi_measure_rec => l_kpi_measure_props_rec
366: , p_cascade_shared => FALSE
367: , x_return_status => l_return_status
368: , x_msg_count => l_msg_count

Line 371: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

367: , x_return_status => l_return_status
368: , x_msg_count => l_msg_count
369: , x_msg_data => l_msg_data
370: );
371: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
372: x_error_msg := l_msg_data;
373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
374: END IF;
375:

Line 373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

369: , x_msg_data => l_msg_data
370: );
371: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
372: x_error_msg := l_msg_data;
373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
374: END IF;
375:
376: END IF;
377:

Line 441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

437:
438: l_default_kpi_measure_id := BSC_COLOR_CALC_UTIL.Get_Default_Kpi_Measure_Id(l_obj_prototype_flag_rec.objective_id);
439: IF l_default_kpi_measure_id IS NULL THEN
440: x_error_msg := 'l_default_kpi_measure_id is NULL for Objective = ' || l_obj_prototype_flag_rec.objective_id || ' ;';
441: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
442: END IF;
443:
444: -- We will update bsc_kpi_analysis_measures_b.prototype_flag always irrespective of the fact
445: -- that whether this script has run before or not. We cannot check for prototype_flag = NULL

Line 518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

514:
515: l_default_kpi_measure_id := BSC_COLOR_CALC_UTIL.Get_Default_Kpi_Measure_Id(l_obj_default_calc_rec.objective_id);
516: IF l_default_kpi_measure_id IS NULL THEN
517: x_error_msg := 'l_default_kpi_measure_id is NULL for Objective = ' || l_obj_default_calc_rec.objective_id || ' ;';
518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
519: END IF;
520:
521: IF l_default_kpi_measure_id IS NOT NULL THEN
522: UPDATE bsc_kpi_measure_props

Line 572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

568:
569: l_default_kpi_measure_id := BSC_COLOR_CALC_UTIL.Get_Default_Kpi_Measure_Id(l_default_kpi_color.indicator);
570: IF l_default_kpi_measure_id IS NULL THEN
571: x_error_msg := 'l_default_kpi_measure_id is NULL for Objective = ' || l_default_kpi_color.indicator || ' ;';
572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
573: END IF;
574: IF l_default_kpi_measure_id IS NOT NULL THEN
575: UPDATE bsc_sys_kpi_colors
576: SET kpi_measure_id = l_default_kpi_measure_id

Line 626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

622: END IF;
623: OPEN c_obj_colors_count;
624: FETCH c_obj_colors_count INTO l_obj_color_count;
625: IF c_obj_colors_count%NOTFOUND THEN
626: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
627: END IF;
628: CLOSE c_obj_colors_count;
629:
630: IF l_obj_color_count = 0 THEN

Line 638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

634: END IF;
635: OPEN c_kpi_colors_count;
636: FETCH c_kpi_colors_count INTO l_kpi_color_count;
637: IF c_kpi_colors_count%NOTFOUND THEN
638: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
639: END IF;
640: CLOSE c_kpi_colors_count;
641:
642: IF l_kpi_color_count > 0 THEN

Line 721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

717: BEGIN
718:
719: -- Set KPI_Measure_Ids in BSC_KPI_ANALYSIS_MEASURES_B based on sequence
720: IF NOT set_kpi_measure_ids(x_error_msg) THEN
721: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
722: END IF;
723:
724: -- Populate BSC_KPI_MEASURE_PROPS
725: IF NOT set_kpi_measure_props(x_error_msg) THEN

Line 726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

722: END IF;
723:
724: -- Populate BSC_KPI_MEASURE_PROPS
725: IF NOT set_kpi_measure_props(x_error_msg) THEN
726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
727: END IF;
728:
729: -- Set Prototype Flag at KPI level
730: IF NOT set_kpimeasure_prototype_flag(x_error_msg) THEN

Line 731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

727: END IF;
728:
729: -- Set Prototype Flag at KPI level
730: IF NOT set_kpimeasure_prototype_flag(x_error_msg) THEN
731: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
732: END IF;
733:
734: -- Set Default Calculation at KPI level
735: IF NOT set_kpi_measure_default_calc(x_error_msg) THEN

Line 736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

732: END IF;
733:
734: -- Set Default Calculation at KPI level
735: IF NOT set_kpi_measure_default_calc(x_error_msg) THEN
736: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
737: END IF;
738:
739: --COMMIT;
740: RETURN TRUE;

Line 759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

755: BEGIN
756:
757: -- Set BSC_KPIS_B.COLOR_ROLLUP_TYPE as DEFAULT_KPI for all existing Objectives
758: IF NOT set_default_color_rollup(x_error_msg) THEN
759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
760: END IF;
761:
762: -- Set BSC_KPIS_B.PROTOTYPE_COLOR to BSC_SYS_COLORS_B.COLOR_ID instead of G,Y,R,X
763: IF NOT set_obj_prototype_color(x_error_msg) THEN

Line 764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

760: END IF;
761:
762: -- Set BSC_KPIS_B.PROTOTYPE_COLOR to BSC_SYS_COLORS_B.COLOR_ID instead of G,Y,R,X
763: IF NOT set_obj_prototype_color(x_error_msg) THEN
764: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
765: END IF;
766:
767: --COMMIT;
768: RETURN TRUE;

Line 788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

784:
785: -- We need to populate BSC_SYS_KPI_COLORS.KPI_MEASURE_ID with the default KPI for the
786: -- corresponding Objective.
787: IF NOT set_default_kpi_measure_id(x_error_msg) THEN
788: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
789: END IF;
790:
791: -- From BSC_SYS_KPI_COLORS, we need to move all the colors to BSC_SYS_OBJECTIVE_COLORS
792: -- (based on DEFAULT_KPI rollup). We dont actually need to find the default KPI for an Objective.

Line 795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

791: -- From BSC_SYS_KPI_COLORS, we need to move all the colors to BSC_SYS_OBJECTIVE_COLORS
792: -- (based on DEFAULT_KPI rollup). We dont actually need to find the default KPI for an Objective.
793: -- Just simply moving all rows from BSC_SYS_KPI_COLORS to BSC_SYS_OBJECTIVE_COLORS will do.
794: IF NOT set_objective_color(x_error_msg) THEN
795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
796: END IF;
797:
798: --COMMIT;
799: RETURN TRUE;

Line 866: p_commit => FND_API.G_FALSE

862: l_anal_opt_rec.Bsc_Measure_Long_Name := c_calc_meas_rec.name;
863: l_anal_opt_rec.Bsc_Measure_Help := c_calc_meas_rec.description;
864:
865: BSC_ANALYSIS_OPTION_PUB.Create_Data_Series (
866: p_commit => FND_API.G_FALSE
867: , p_anal_opt_rec => l_anal_opt_rec
868: , x_anal_opt_rec => x_anal_opt_rec
869: , x_return_status => x_return_status
870: , x_msg_count => x_msg_count

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

869: , x_return_status => x_return_status
870: , x_msg_count => x_msg_count
871: , x_msg_data => x_error_msg
872: );
873: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
875: END IF;
876:
877: END LOOP;

Line 874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

870: , x_msg_count => x_msg_count
871: , x_msg_data => x_error_msg
872: );
873: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
875: END IF;
876:
877: END LOOP;
878: END IF;

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

1032: ,p_property_value => l_property_value
1033: ,x_return_status => x_return_status
1034: ,x_msg_count => x_msg_count
1035: ,x_msg_data => x_msg_data );
1036: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1038: END IF;
1039: END IF;
1040: IF (p_color_method = 2 OR p_color_method IS NULL) THEN -- Target Met Below plan

Line 1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1033: ,x_return_status => x_return_status
1034: ,x_msg_count => x_msg_count
1035: ,x_msg_data => x_msg_data );
1036: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1038: END IF;
1039: END IF;
1040: IF (p_color_method = 2 OR p_color_method IS NULL) THEN -- Target Met Below plan
1041: l_threshold := threshold_array(1,2,3);

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

1052: ,p_property_value => l_property_value
1053: ,x_return_status => x_return_status
1054: ,x_msg_count => x_msg_count
1055: ,x_msg_data => x_msg_data );
1056: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1058: END IF;
1059: END IF;
1060: IF (p_color_method = 3 OR p_color_method IS NULL) THEN -- Target Met In Between

Line 1057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1053: ,x_return_status => x_return_status
1054: ,x_msg_count => x_msg_count
1055: ,x_msg_data => x_msg_data );
1056: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1057: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1058: END IF;
1059: END IF;
1060: IF (p_color_method = 3 OR p_color_method IS NULL) THEN -- Target Met In Between
1061: l_threshold := threshold_array(1,2,3,4,5);

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

1074: ,p_property_value => l_property_value
1075: ,x_return_status => x_return_status
1076: ,x_msg_count => x_msg_count
1077: ,x_msg_data => x_msg_data );
1078: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1080: END IF;
1081: END IF;
1082: END create_color_thresholds;

Line 1079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1075: ,x_return_status => x_return_status
1076: ,x_msg_count => x_msg_count
1077: ,x_msg_data => x_msg_data );
1078: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1079: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1080: END IF;
1081: END IF;
1082: END create_color_thresholds;
1083:

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

1192:
1193: RETURN TRUE;
1194: EXCEPTION
1195: WHEN OTHERS THEN
1196: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1197: x_error_msg := 'BSC_COLOR_UPGRADE.upgrade_color_thresholds ->' || x_msg_data;
1198: ELSE
1199: x_error_msg := 'BSC_COLOR_UPGRADE.upgrade_color_thresholds -> ' || SQLERRM;
1200: END IF;

Line 1227: ( p_commit => FND_API.G_FALSE

1223:
1224: BEGIN
1225:
1226: BSC_PMF_UI_WRAPPER.Delete_Kpi
1227: ( p_commit => FND_API.G_FALSE
1228: , p_kpi_id => cd.indicator
1229: , x_return_status => l_return_status
1230: , x_msg_count => l_msg_count
1231: , x_msg_data => l_msg_data

Line 1235: IF ((l_return_status IS NOT NULL) AND (l_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN

1231: , x_msg_data => l_msg_data
1232: );
1233:
1234:
1235: IF ((l_return_status IS NOT NULL) AND (l_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
1236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1237: END IF;
1238:
1239: EXCEPTION

Line 1236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1232: );
1233:
1234:
1235: IF ((l_return_status IS NOT NULL) AND (l_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
1236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1237: END IF;
1238:
1239: EXCEPTION
1240: WHEN OTHERS THEN

Line 1257: IF ((l_return_status IS NOT NULL) AND (l_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN

1253: RETURN TRUE;
1254:
1255: EXCEPTION
1256: WHEN OTHERS THEN
1257: IF ((l_return_status IS NOT NULL) AND (l_return_status <> FND_API.G_RET_STS_SUCCESS)) THEN
1258: x_error_msg := 'BSC_COLOR_UPGRADE.upgrade_simulation_objectives ->' || l_msg_data;
1259: ELSE
1260: x_error_msg := 'BSC_COLOR_UPGRADE.upgrade_simulation_objectives -> ' || SQLERRM;
1261: END IF;