[Home] [Help]
143:
144: x_complete_rec := p_act_forecast_rec;
145:
146: -- Insert Mode
147: IF ((p_validation_mode = JTF_PLSQL_API.g_create) OR (p_validation_mode = JTF_PLSQL_API.g_update)) THEN
148:
149: IF p_act_forecast_rec.forecast_calendar IS NULL THEN
150: x_complete_rec.forecast_calendar := 'NONE';
151: END IF;
268:
269: Default_ActForecast
270: ( p_init_msg_list => p_init_msg_list,
271: p_act_forecast_rec => p_act_forecast_rec,
272: p_validation_mode => JTF_PLSQL_API.g_create,
273: x_complete_rec => l_act_forecast_rec,
274: x_return_status => l_return_status,
275: x_msg_count => x_msg_count,
276: x_msg_data => x_msg_data ) ;
635:
636: Default_ActForecast
637: ( p_init_msg_list => p_init_msg_list,
638: p_act_forecast_rec => p_act_forecast_rec,
639: p_validation_mode => JTF_PLSQL_API.G_UPDATE,
640: x_complete_rec => l_act_forecast_rec,
641: x_return_status => l_return_status,
642: x_msg_count => x_msg_count,
643: x_msg_data => x_msg_data ) ;
662: END IF;
663:
664:
665:
666: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
667: IF (OZF_DEBUG_HIGH_ON) THEN
668:
669: OZF_Utility_PVT.debug_message(l_full_name ||' 1 ' || l_act_forecast_rec.forecast_id);
670: END IF;
669: OZF_Utility_PVT.debug_message(l_full_name ||' 1 ' || l_act_forecast_rec.forecast_id);
670: END IF;
671: Validate_ActFcst_Items(
672: p_act_forecast_rec => l_act_forecast_rec,
673: p_validation_mode => JTF_PLSQL_API.g_update,
674: x_return_status => l_return_status
675: );
676: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
677: RAISE FND_API.g_exc_unexpected_error;
691: Complete_ActFcst_Rec(p_act_forecast_rec => l_temp_act_forecast_rec,
692: x_complete_fcst_rec => l_act_forecast_rec);
693:
694:
695: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
696:
697: Validate_ActFcst_Rec(
698: p_act_forecast_rec => p_act_forecast_rec,
699: p_complete_fcst_rec => l_act_forecast_rec,
1251:
1252: END IF;
1253:
1254: -- Validate required items in the record.
1255: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1256:
1257: Validate_ActFcst_Items(
1258: p_act_forecast_rec => p_act_forecast_rec,
1259: p_validation_mode => JTF_PLSQL_API.g_create,
1255: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1256:
1257: Validate_ActFcst_Items(
1258: p_act_forecast_rec => p_act_forecast_rec,
1259: p_validation_mode => JTF_PLSQL_API.g_create,
1260: x_return_status => l_return_status
1261: );
1262:
1263: -- If any errors happen abort API.
1275: OZF_Utility_PVT.debug_message(l_full_name||': check record');
1276:
1277: END IF;
1278:
1279: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1280: Validate_ActFcst_Rec(
1281: p_act_forecast_rec => p_act_forecast_rec,
1282: p_complete_fcst_rec => NULL,
1283: x_return_status => l_return_status
1796:
1797:
1798: PROCEDURE Check_ActFcst_UK_Items(
1799: p_act_forecast_rec IN act_forecast_rec_type,
1800: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
1801: x_return_status OUT NOCOPY VARCHAR2
1802: )
1803: IS
1804: l_where_clause VARCHAR2(2000); -- Used By Check_Uniqueness
1809:
1810: -- For Create_ActForecast, check if a Forecast already exists
1811: -- For the given object
1812:
1813: IF p_validation_mode = JTF_PLSQL_API.g_create
1814: THEN
1815:
1816: l_where_clause := ' arc_act_fcast_used_by = '||p_act_forecast_rec.arc_act_fcast_used_by ;
1817: l_where_clause := l_where_clause ||
2078: -- End of comments.
2079:
2080: PROCEDURE Validate_ActFcst_Items (
2081: p_act_forecast_rec IN act_forecast_rec_type,
2082: p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create,
2083: x_return_status OUT NOCOPY VARCHAR2
2084: )
2085: IS
2086: BEGIN