[Home] [Help]
386: -- Do Currency Conversion after defaulting functional currency code
387: Default_ActMetric(
388: p_init_msg_list => p_init_msg_list,
389: --p_act_metric_rec => l_act_metrics_rec,
390: p_validation_mode => Jtf_Plsql_Api.g_create,
391: x_complete_rec => l_act_metrics_rec,
392: x_return_status => l_return_status,
393: x_msg_count => x_msg_count,
394: x_msg_data => x_msg_data
786: -- Do Currency Conversion
787: Default_ActMetric(
788: p_init_msg_list => p_init_msg_list,
789: -- p_act_metric_rec => l_actmet_rec,
790: p_validation_mode => Jtf_Plsql_Api.G_UPDATE,
791: x_complete_rec => l_actmet_rec,
792: x_return_status => l_return_status,
793: x_msg_count => x_msg_count,
794: x_msg_data => x_msg_data ) ;
798: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
799: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
800: END IF;
801:
802: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
803: Validate_ActMetric_items(
804: p_act_metric_rec => l_actmet_rec,
805: p_validation_mode => Jtf_Plsql_Api.g_update,
806: x_return_status => l_return_status
801:
802: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
803: Validate_ActMetric_items(
804: p_act_metric_rec => l_actmet_rec,
805: p_validation_mode => Jtf_Plsql_Api.g_update,
806: x_return_status => l_return_status
807: );
808: IF l_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
809: RAISE Fnd_Api.g_exc_unexpected_error;
815:
816: -- replace g_miss_char/num/date with current column values
817: --Complete_ActMetric_Rec(l_actmet_rec, l_actmet_rec);
818:
819: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_record THEN
820:
821: Validate_ActMetric_Record(
822: p_act_metric_rec => l_actmet_rec,
823: p_complete_rec => l_actmet_rec,
1055: ozf_utility_pvt.debug_message(l_full_name||': Validate items');
1056: END IF;
1057:
1058: -- Validate required items in the record.
1059: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
1060:
1061: Validate_ActMetric_items(
1062: p_act_metric_rec => p_act_metric_rec,
1063: p_validation_mode => Jtf_Plsql_Api.g_create,
1059: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
1060:
1061: Validate_ActMetric_items(
1062: p_act_metric_rec => p_act_metric_rec,
1063: p_validation_mode => Jtf_Plsql_Api.g_create,
1064: x_return_status => l_return_status
1065: );
1066:
1067: -- If any errors happen abort API.
1075: IF (OZF_DEBUG_HIGH_ON) THEN
1076: ozf_utility_pvt.debug_message(l_full_name||': check record');
1077: END IF;
1078:
1079: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_record THEN
1080: Validate_ActMetric_record(
1081: p_act_metric_rec => p_act_metric_rec,
1082: p_complete_rec => NULL,
1083: x_return_status => l_return_status
1295:
1296:
1297: PROCEDURE Check_ActMetric_UK_Items(
1298: p_act_metric_rec IN act_metric_rec_type,
1299: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
1300: x_return_status OUT NOCOPY VARCHAR2
1301: )
1302: IS
1303: l_where_clause VARCHAR2(2000); -- Used By Check_Uniqueness
1325: x_return_status := Fnd_Api.g_ret_sts_success;
1326:
1327: -- For Create_ActMetric2, when activity_metric_id is passed in, we need to
1328: -- check if this activity_metric_id is unique.
1329: IF p_validation_mode = Jtf_Plsql_Api.g_create
1330: AND p_act_metric_rec.activity_metric_id IS NOT NULL
1331: THEN
1332: l_where_clause := ' activity_metric_id = '||p_act_metric_rec.activity_metric_id ;
1333:
1348:
1349: -- check other unique items
1350:
1351: -- Function metrics may only be added once.
1352: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN
1353: l_test := NULL;
1354: OPEN c_check_function(p_act_metric_rec.metric_id,
1355: p_act_metric_rec.arc_act_metric_used_by,
1356: p_act_metric_rec.act_metric_used_by_id,
2023: -- End of comments.
2024:
2025: PROCEDURE Validate_ActMetric_items(
2026: p_act_metric_rec IN act_metric_rec_type,
2027: p_validation_mode IN VARCHAR2 := Jtf_Plsql_Api.g_create,
2028: x_return_status OUT NOCOPY VARCHAR2
2029: )
2030: IS
2031: BEGIN