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.EAM_FORECAST_PVT dependencies on FND_API

Line 33: p_commit IN VARCHAR2 := FND_API.G_FALSE,

29: ----------------------------------------------------------------------------
30:
31: PROCEDURE Get_HistoricalCosts (
32: p_api_version IN NUMBER,
33: p_commit IN VARCHAR2 := FND_API.G_FALSE,
34: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36: p_debug IN VARCHAR2 ,
37:

Line 34: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

30:
31: PROCEDURE Get_HistoricalCosts (
32: p_api_version IN NUMBER,
33: p_commit IN VARCHAR2 := FND_API.G_FALSE,
34: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36: p_debug IN VARCHAR2 ,
37:
38: p_forecast_id IN NUMBER,

Line 35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

31: PROCEDURE Get_HistoricalCosts (
32: p_api_version IN NUMBER,
33: p_commit IN VARCHAR2 := FND_API.G_FALSE,
34: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
35: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
36: p_debug IN VARCHAR2 ,
37:
38: p_forecast_id IN NUMBER,
39: p_organization_id IN NUMBER,

Line 178: IF NOT fnd_api.compatible_api_call (

174:
175: -------------------------------------------------------------------------
176: -- standard call to check for call compatibility
177: -------------------------------------------------------------------------
178: IF NOT fnd_api.compatible_api_call (
179: l_api_version,
180: p_api_version,
181: l_api_name,
182: G_PKG_NAME ) then

Line 184: RAISE fnd_api.g_exc_unexpected_error;

180: p_api_version,
181: l_api_name,
182: G_PKG_NAME ) then
183:
184: RAISE fnd_api.g_exc_unexpected_error;
185:
186: END IF;
187:
188: ---------------------------------------------------------------------------

Line 192: IF FND_API.to_Boolean(p_init_msg_list) THEN

188: ---------------------------------------------------------------------------
189: -- Initialize message list if p_init_msg_list is set to TRUE
190: ---------------------------------------------------------------------------
191:
192: IF FND_API.to_Boolean(p_init_msg_list) THEN
193: FND_MSG_PUB.initialize;
194: END IF;
195:
196:

Line 202: x_return_status := fnd_api.g_ret_sts_success;

198: -- initialize api return status to success
199: -------------------------------------------------------------------------
200:
201: l_stmt_num := 10;
202: x_return_status := fnd_api.g_ret_sts_success;
203:
204:
205: -------------------------------------------------------------------------
206: /*-- Determine the dates for the periods of interest

Line 300: WHEN fnd_api.g_exc_error THEN

296: p_data => x_msg_data );
297:
298: EXCEPTION
299:
300: WHEN fnd_api.g_exc_error THEN
301: x_return_status := fnd_api.g_ret_sts_error;
302:
303: -- Get message count and data
304: fnd_msg_pub.count_and_get

Line 301: x_return_status := fnd_api.g_ret_sts_error;

297:
298: EXCEPTION
299:
300: WHEN fnd_api.g_exc_error THEN
301: x_return_status := fnd_api.g_ret_sts_error;
302:
303: -- Get message count and data
304: fnd_msg_pub.count_and_get
305: ( p_count => x_msg_count

Line 309: WHEN fnd_api.g_exc_unexpected_error THEN

305: ( p_count => x_msg_count
306: , p_data => x_msg_data
307: );
308: --
309: WHEN fnd_api.g_exc_unexpected_error THEN
310: x_return_status := fnd_api.g_ret_sts_unexp_error ;
311:
312: -- Get message count and data
313: fnd_msg_pub.count_and_get

Line 310: x_return_status := fnd_api.g_ret_sts_unexp_error ;

306: , p_data => x_msg_data
307: );
308: --
309: WHEN fnd_api.g_exc_unexpected_error THEN
310: x_return_status := fnd_api.g_ret_sts_unexp_error ;
311:
312: -- Get message count and data
313: fnd_msg_pub.count_and_get
314: ( p_count => x_msg_count

Line 319: x_return_status := fnd_api.g_ret_sts_unexp_error ;

315: , p_data => x_msg_data
316: );
317:
318: WHEN OTHERS THEN
319: x_return_status := fnd_api.g_ret_sts_unexp_error ;
320: --
321: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
322: THEN
323: fnd_msg_pub.add_exc_msg

Line 434: p_commit => FND_API.G_TRUE,

430: commit;
431:
432: Extract_Forecast(
433: p_api_version => 1.0,
434: p_commit => FND_API.G_TRUE,
435: p_debug => 'N',
436:
437: p_forecast_id => p_forecast_id,
438: x_return_status => l_return_status,

Line 1031: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1027: -- TODO: OA needs to update the forecast criteria with the request id
1028:
1029: PROCEDURE Extract_Forecast(
1030: p_api_version IN NUMBER,
1031: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1032: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1033: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1034: p_debug IN VARCHAR2 ,
1035: p_forecast_id IN eam_forecasts.forecast_id%TYPE,

Line 1032: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1028:
1029: PROCEDURE Extract_Forecast(
1030: p_api_version IN NUMBER,
1031: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1032: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1033: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1034: p_debug IN VARCHAR2 ,
1035: p_forecast_id IN eam_forecasts.forecast_id%TYPE,
1036: x_return_status OUT NOCOPY VARCHAR2 ,

Line 1033: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1029: PROCEDURE Extract_Forecast(
1030: p_api_version IN NUMBER,
1031: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1032: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1033: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1034: p_debug IN VARCHAR2 ,
1035: p_forecast_id IN eam_forecasts.forecast_id%TYPE,
1036: x_return_status OUT NOCOPY VARCHAR2 ,
1037: x_msg_count OUT NOCOPY NUMBER ,

Line 1054: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

1050: begin
1051: -- Standard Start of API savepoint
1052: SAVEPOINT Extract_Forecast_PVT;
1053: -- Standard call to check for call compatibility.
1054: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1055: p_api_version ,
1056: l_api_name ,
1057: G_PKG_NAME
1058: )

Line 1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1056: l_api_name ,
1057: G_PKG_NAME
1058: )
1059: THEN
1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1061: END IF;
1062:
1063: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1064: FND_MSG_PUB.initialize;

Line 1063: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1059: THEN
1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1061: END IF;
1062:
1063: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1064: FND_MSG_PUB.initialize;
1065: END IF;
1066: -- Initialize API return status to success
1067: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1067: x_return_status := FND_API.G_RET_STS_SUCCESS;

1063: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1064: FND_MSG_PUB.initialize;
1065: END IF;
1066: -- Initialize API return status to success
1067: x_return_status := FND_API.G_RET_STS_SUCCESS;
1068:
1069: SELECT * INTO v_forecast_rec
1070: FROM eam_forecasts
1071: WHERE forecast_id = p_forecast_id;

Line 1159: IF FND_API.To_Boolean( p_commit ) THEN

1155: p_forecast_id);
1156:
1157:
1158: -- Standard check of p_commit.
1159: IF FND_API.To_Boolean( p_commit ) THEN
1160: COMMIT WORK;
1161: END IF;
1162:
1163: -- Standard call to get message count and if count is 1, get message info.

Line 1173: x_return_status := FND_API.G_RET_STS_ERROR ;

1169:
1170: EXCEPTION
1171: WHEN no_data_found THEN
1172: ROLLBACK TO Extract_Forecast_PVT;
1173: x_return_status := FND_API.G_RET_STS_ERROR ;
1174: FND_MSG_PUB.Count_And_Get
1175: ( p_count => x_msg_count ,
1176: p_data => x_msg_data
1177: );

Line 1180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1176: p_data => x_msg_data
1177: );
1178: WHEN OTHERS THEN
1179: ROLLBACK TO Extract_Forecast_PVT;
1180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1181: IF FND_MSG_PUB.Check_Msg_Level
1182: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1183: THEN
1184: FND_MSG_PUB.Add_Exc_Msg

Line 1201: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1197:
1198: -- Body definition (see forward declaration for more info)
1199: PROCEDURE extract_historical_forecast(
1200: p_api_version IN NUMBER,
1201: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1203: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1204: p_debug IN VARCHAR2 ,
1205:

Line 1202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1198: -- Body definition (see forward declaration for more info)
1199: PROCEDURE extract_historical_forecast(
1200: p_api_version IN NUMBER,
1201: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1203: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1204: p_debug IN VARCHAR2 ,
1205:
1206: p_forecast_rec IN eam_forecasts%ROWTYPE,

Line 1203: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1199: PROCEDURE extract_historical_forecast(
1200: p_api_version IN NUMBER,
1201: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1202: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1203: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1204: p_debug IN VARCHAR2 ,
1205:
1206: p_forecast_rec IN eam_forecasts%ROWTYPE,
1207:

Line 1380: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1376:
1377: -- Body definition (see forward declaration for more info)
1378: PROCEDURE extract_future_forecast (
1379: p_api_version IN NUMBER,
1380: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1381: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1382: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1383: p_debug IN VARCHAR2 ,
1384:

Line 1381: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1377: -- Body definition (see forward declaration for more info)
1378: PROCEDURE extract_future_forecast (
1379: p_api_version IN NUMBER,
1380: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1381: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1382: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1383: p_debug IN VARCHAR2 ,
1384:
1385: p_forecast_rec IN eam_forecasts%ROWTYPE,

Line 1382: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1378: PROCEDURE extract_future_forecast (
1379: p_api_version IN NUMBER,
1380: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1381: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1382: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1383: p_debug IN VARCHAR2 ,
1384:
1385: p_forecast_rec IN eam_forecasts%ROWTYPE,
1386:

Line 1508: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1504: END extract_future_forecast;
1505:
1506: PROCEDURE extract_autonomous_forecast(
1507: p_api_version IN NUMBER,
1508: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1509: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1510: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1511: p_debug IN VARCHAR2 ,
1512:

Line 1509: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1505:
1506: PROCEDURE extract_autonomous_forecast(
1507: p_api_version IN NUMBER,
1508: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1509: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1510: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1511: p_debug IN VARCHAR2 ,
1512:
1513: p_forecast_rec IN eam_forecasts%ROWTYPE,

Line 1510: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1506: PROCEDURE extract_autonomous_forecast(
1507: p_api_version IN NUMBER,
1508: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1509: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1510: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1511: p_debug IN VARCHAR2 ,
1512:
1513: p_forecast_rec IN eam_forecasts%ROWTYPE,
1514:

Line 1693: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1689:
1690:
1691: PROCEDURE Copy_WDJ_To_Forecast (
1692: p_api_version IN NUMBER,
1693: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1694: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1695: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1696: p_debug IN VARCHAR2 ,
1697:

Line 1694: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1690:
1691: PROCEDURE Copy_WDJ_To_Forecast (
1692: p_api_version IN NUMBER,
1693: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1694: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1695: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1696: p_debug IN VARCHAR2 ,
1697:
1698: p_forecast_rec IN eam_forecasts%ROWTYPE,

Line 1695: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1691: PROCEDURE Copy_WDJ_To_Forecast (
1692: p_api_version IN NUMBER,
1693: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1694: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1695: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1696: p_debug IN VARCHAR2 ,
1697:
1698: p_forecast_rec IN eam_forecasts%ROWTYPE,
1699: p_wip_id_table IN wo_table_type,

Line 1814: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1810: END Copy_WDJ_To_Forecast;
1811:
1812: PROCEDURE Copy_WDJ_To_Forecast_auto (
1813: p_api_version IN NUMBER,
1814: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1815: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1816: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1817: p_debug IN VARCHAR2 ,
1818:

Line 1815: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1811:
1812: PROCEDURE Copy_WDJ_To_Forecast_auto (
1813: p_api_version IN NUMBER,
1814: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1815: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1816: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1817: p_debug IN VARCHAR2 ,
1818:
1819: p_forecast_rec IN eam_forecasts%ROWTYPE,

Line 1816: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1812: PROCEDURE Copy_WDJ_To_Forecast_auto (
1813: p_api_version IN NUMBER,
1814: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1815: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1816: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1817: p_debug IN VARCHAR2 ,
1818:
1819: p_forecast_rec IN eam_forecasts%ROWTYPE,
1820: p_wip_id_table IN wo_table_type,

Line 2021: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2017: END insert_into_wdj_auto;
2018: */
2019: PROCEDURE Copy_CEBBA_To_Forecast_auto (
2020: p_api_version IN NUMBER,
2021: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2022: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2023: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2024: p_debug IN VARCHAR2 ,
2025:

Line 2022: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2018: */
2019: PROCEDURE Copy_CEBBA_To_Forecast_auto (
2020: p_api_version IN NUMBER,
2021: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2022: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2023: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2024: p_debug IN VARCHAR2 ,
2025:
2026: p_forecast_rec IN eam_forecasts%ROWTYPE,

Line 2023: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2019: PROCEDURE Copy_CEBBA_To_Forecast_auto (
2020: p_api_version IN NUMBER,
2021: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2022: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2023: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2024: p_debug IN VARCHAR2 ,
2025:
2026: p_forecast_rec IN eam_forecasts%ROWTYPE,
2027: p_wip_id_table IN wo_table_type,

Line 2091: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2087:
2088:
2089: PROCEDURE Copy_WOR_To_Forecast (
2090: p_api_version IN NUMBER,
2091: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2092: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2093: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2094: p_debug IN VARCHAR2 ,
2095:

Line 2092: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2088:
2089: PROCEDURE Copy_WOR_To_Forecast (
2090: p_api_version IN NUMBER,
2091: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2092: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2093: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2094: p_debug IN VARCHAR2 ,
2095:
2096: p_forecast_rec IN eam_forecasts%ROWTYPE,

Line 2093: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2089: PROCEDURE Copy_WOR_To_Forecast (
2090: p_api_version IN NUMBER,
2091: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2092: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2093: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2094: p_debug IN VARCHAR2 ,
2095:
2096: p_forecast_rec IN eam_forecasts%ROWTYPE,
2097: p_wip_id_table IN wo_table_type,

Line 2180: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2176:
2177:
2178: PROCEDURE Copy_WRO_To_Forecast (
2179: p_api_version IN NUMBER,
2180: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2181: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2183: p_debug IN VARCHAR2 ,
2184:

Line 2181: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2177:
2178: PROCEDURE Copy_WRO_To_Forecast (
2179: p_api_version IN NUMBER,
2180: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2181: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2183: p_debug IN VARCHAR2 ,
2184:
2185: p_forecast_rec IN eam_forecasts%ROWTYPE,

Line 2182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2178: PROCEDURE Copy_WRO_To_Forecast (
2179: p_api_version IN NUMBER,
2180: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2181: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2182: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2183: p_debug IN VARCHAR2 ,
2184:
2185: p_forecast_rec IN eam_forecasts%ROWTYPE,
2186: p_wip_id_table IN wo_table_type,

Line 2276: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2272:
2273:
2274: PROCEDURE Copy_WO_To_Forecast (
2275: p_api_version IN NUMBER,
2276: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2277: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2278: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2279: p_debug IN VARCHAR2 ,
2280:

Line 2277: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2273:
2274: PROCEDURE Copy_WO_To_Forecast (
2275: p_api_version IN NUMBER,
2276: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2277: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2278: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2279: p_debug IN VARCHAR2 ,
2280:
2281: p_forecast_rec IN eam_forecasts%ROWTYPE,

Line 2278: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2274: PROCEDURE Copy_WO_To_Forecast (
2275: p_api_version IN NUMBER,
2276: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2277: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2278: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2279: p_debug IN VARCHAR2 ,
2280:
2281: p_forecast_rec IN eam_forecasts%ROWTYPE,
2282: p_wip_id_table IN wo_table_type,

Line 2363: x_return_status := FND_API.G_RET_STS_ERROR ;

2359: EXCEPTION
2360:
2361: WHEN no_data_found THEN
2362: --ROLLBACK TO Extract_Forecast_PVT;
2363: x_return_status := FND_API.G_RET_STS_ERROR ;
2364: FND_MSG_PUB.Count_And_Get
2365: ( p_count => x_msg_count ,
2366: p_data => x_msg_data
2367: );

Line 2368: RAISE FND_API.G_EXC_ERROR;

2364: FND_MSG_PUB.Count_And_Get
2365: ( p_count => x_msg_count ,
2366: p_data => x_msg_data
2367: );
2368: RAISE FND_API.G_EXC_ERROR;
2369: WHEN OTHERS THEN
2370: debug('EXCEPTION');
2371: --ROLLBACK TO Extract_Forecast_PVT;
2372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2368: RAISE FND_API.G_EXC_ERROR;
2369: WHEN OTHERS THEN
2370: debug('EXCEPTION');
2371: --ROLLBACK TO Extract_Forecast_PVT;
2372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2373: IF FND_MSG_PUB.Check_Msg_Level
2374: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2375: THEN
2376: FND_MSG_PUB.Add_Exc_Msg

Line 2386: RAISE FND_API.G_EXC_ERROR;

2382: FND_MSG_PUB.Count_And_Get
2383: ( p_count => x_msg_count ,
2384: p_data => x_msg_data
2385: );
2386: RAISE FND_API.G_EXC_ERROR;
2387:
2388:
2389: END Copy_WO_To_Forecast;
2390:

Line 2394: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2390:
2391:
2392: PROCEDURE Copy_CEBBA_To_Forecast (
2393: p_api_version IN NUMBER,
2394: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2395: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2396: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2397: p_debug IN VARCHAR2 ,
2398:

Line 2395: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2391:
2392: PROCEDURE Copy_CEBBA_To_Forecast (
2393: p_api_version IN NUMBER,
2394: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2395: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2396: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2397: p_debug IN VARCHAR2 ,
2398:
2399: p_forecast_rec IN eam_forecasts%ROWTYPE,

Line 2396: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2392: PROCEDURE Copy_CEBBA_To_Forecast (
2393: p_api_version IN NUMBER,
2394: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2395: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2396: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2397: p_debug IN VARCHAR2 ,
2398:
2399: p_forecast_rec IN eam_forecasts%ROWTYPE,
2400: p_wip_id_table IN wo_table_type,

Line 2568: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2564: END Copy_CEBBA_To_Forecast;
2565:
2566: PROCEDURE Copy_WEDI_To_Forecast (
2567: p_api_version IN NUMBER,
2568: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2569: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2570: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2571: p_debug IN VARCHAR2 ,
2572:

Line 2569: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2565:
2566: PROCEDURE Copy_WEDI_To_Forecast (
2567: p_api_version IN NUMBER,
2568: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2569: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2570: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2571: p_debug IN VARCHAR2 ,
2572:
2573: p_forecast_rec IN eam_forecasts%ROWTYPE,

Line 2570: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2566: PROCEDURE Copy_WEDI_To_Forecast (
2567: p_api_version IN NUMBER,
2568: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2569: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2570: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2571: p_debug IN VARCHAR2 ,
2572:
2573: p_forecast_rec IN eam_forecasts%ROWTYPE,
2574: p_wip_id_table IN wo_table_type,