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 1052: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1048: -- TODO: OA needs to update the forecast criteria with the request id
1049:
1050: PROCEDURE Extract_Forecast(
1051: p_api_version IN NUMBER,
1052: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1053: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1054: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1055: p_debug IN VARCHAR2 ,
1056: p_forecast_id IN eam_forecasts.forecast_id%TYPE,

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

1049:
1050: PROCEDURE Extract_Forecast(
1051: p_api_version IN NUMBER,
1052: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1053: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1054: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1055: p_debug IN VARCHAR2 ,
1056: p_forecast_id IN eam_forecasts.forecast_id%TYPE,
1057: x_return_status OUT NOCOPY VARCHAR2 ,

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

1050: PROCEDURE Extract_Forecast(
1051: p_api_version IN NUMBER,
1052: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1053: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1054: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1055: p_debug IN VARCHAR2 ,
1056: p_forecast_id IN eam_forecasts.forecast_id%TYPE,
1057: x_return_status OUT NOCOPY VARCHAR2 ,
1058: x_msg_count OUT NOCOPY NUMBER ,

Line 1075: IF NOT FND_API.Compatible_API_Call ( l_api_version ,

1071: begin
1072: -- Standard Start of API savepoint
1073: SAVEPOINT Extract_Forecast_PVT;
1074: -- Standard call to check for call compatibility.
1075: IF NOT FND_API.Compatible_API_Call ( l_api_version ,
1076: p_api_version ,
1077: l_api_name ,
1078: G_PKG_NAME
1079: )

Line 1081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1077: l_api_name ,
1078: G_PKG_NAME
1079: )
1080: THEN
1081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1082: END IF;
1083:
1084: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1085: FND_MSG_PUB.initialize;

Line 1084: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1080: THEN
1081: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1082: END IF;
1083:
1084: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1085: FND_MSG_PUB.initialize;
1086: END IF;
1087: -- Initialize API return status to success
1088: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1088: x_return_status := FND_API.G_RET_STS_SUCCESS;

1084: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1085: FND_MSG_PUB.initialize;
1086: END IF;
1087: -- Initialize API return status to success
1088: x_return_status := FND_API.G_RET_STS_SUCCESS;
1089:
1090: SELECT * INTO v_forecast_rec
1091: FROM eam_forecasts
1092: WHERE forecast_id = p_forecast_id;

Line 1180: IF FND_API.To_Boolean( p_commit ) THEN

1176: p_forecast_id);
1177:
1178:
1179: -- Standard check of p_commit.
1180: IF FND_API.To_Boolean( p_commit ) THEN
1181: COMMIT WORK;
1182: END IF;
1183:
1184: -- Standard call to get message count and if count is 1, get message info.

Line 1194: x_return_status := FND_API.G_RET_STS_ERROR ;

1190:
1191: EXCEPTION
1192: WHEN no_data_found THEN
1193: ROLLBACK TO Extract_Forecast_PVT;
1194: x_return_status := FND_API.G_RET_STS_ERROR ;
1195: FND_MSG_PUB.Count_And_Get
1196: ( p_count => x_msg_count ,
1197: p_data => x_msg_data
1198: );

Line 1201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1197: p_data => x_msg_data
1198: );
1199: WHEN OTHERS THEN
1200: ROLLBACK TO Extract_Forecast_PVT;
1201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1202: IF FND_MSG_PUB.Check_Msg_Level
1203: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1204: THEN
1205: FND_MSG_PUB.Add_Exc_Msg

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

1218:
1219: -- Body definition (see forward declaration for more info)
1220: PROCEDURE extract_historical_forecast(
1221: p_api_version IN NUMBER,
1222: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1223: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1224: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1225: p_debug IN VARCHAR2 ,
1226:

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

1219: -- Body definition (see forward declaration for more info)
1220: PROCEDURE extract_historical_forecast(
1221: p_api_version IN NUMBER,
1222: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1223: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1224: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1225: p_debug IN VARCHAR2 ,
1226:
1227: p_forecast_rec IN eam_forecasts%ROWTYPE,

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

1220: PROCEDURE extract_historical_forecast(
1221: p_api_version IN NUMBER,
1222: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1223: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1224: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1225: p_debug IN VARCHAR2 ,
1226:
1227: p_forecast_rec IN eam_forecasts%ROWTYPE,
1228:

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

1397:
1398: -- Body definition (see forward declaration for more info)
1399: PROCEDURE extract_future_forecast (
1400: p_api_version IN NUMBER,
1401: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1402: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1403: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1404: p_debug IN VARCHAR2 ,
1405:

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

1398: -- Body definition (see forward declaration for more info)
1399: PROCEDURE extract_future_forecast (
1400: p_api_version IN NUMBER,
1401: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1402: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1403: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1404: p_debug IN VARCHAR2 ,
1405:
1406: p_forecast_rec IN eam_forecasts%ROWTYPE,

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

1399: PROCEDURE extract_future_forecast (
1400: p_api_version IN NUMBER,
1401: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1402: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1403: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1404: p_debug IN VARCHAR2 ,
1405:
1406: p_forecast_rec IN eam_forecasts%ROWTYPE,
1407:

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

1525: END extract_future_forecast;
1526:
1527: PROCEDURE extract_autonomous_forecast(
1528: p_api_version IN NUMBER,
1529: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1530: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1531: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1532: p_debug IN VARCHAR2 ,
1533:

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

1526:
1527: PROCEDURE extract_autonomous_forecast(
1528: p_api_version IN NUMBER,
1529: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1530: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1531: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1532: p_debug IN VARCHAR2 ,
1533:
1534: p_forecast_rec IN eam_forecasts%ROWTYPE,

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

1527: PROCEDURE extract_autonomous_forecast(
1528: p_api_version IN NUMBER,
1529: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1530: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1531: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1532: p_debug IN VARCHAR2 ,
1533:
1534: p_forecast_rec IN eam_forecasts%ROWTYPE,
1535:

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

1710:
1711:
1712: PROCEDURE Copy_WDJ_To_Forecast (
1713: p_api_version IN NUMBER,
1714: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1715: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1716: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1717: p_debug IN VARCHAR2 ,
1718:

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

1711:
1712: PROCEDURE Copy_WDJ_To_Forecast (
1713: p_api_version IN NUMBER,
1714: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1715: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1716: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1717: p_debug IN VARCHAR2 ,
1718:
1719: p_forecast_rec IN eam_forecasts%ROWTYPE,

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

1712: PROCEDURE Copy_WDJ_To_Forecast (
1713: p_api_version IN NUMBER,
1714: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1715: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1716: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1717: p_debug IN VARCHAR2 ,
1718:
1719: p_forecast_rec IN eam_forecasts%ROWTYPE,
1720: p_wip_id_table IN wo_table_type,

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

1831: END Copy_WDJ_To_Forecast;
1832:
1833: PROCEDURE Copy_WDJ_To_Forecast_auto (
1834: p_api_version IN NUMBER,
1835: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1836: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1837: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1838: p_debug IN VARCHAR2 ,
1839:

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

1832:
1833: PROCEDURE Copy_WDJ_To_Forecast_auto (
1834: p_api_version IN NUMBER,
1835: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1836: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1837: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1838: p_debug IN VARCHAR2 ,
1839:
1840: p_forecast_rec IN eam_forecasts%ROWTYPE,

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

1833: PROCEDURE Copy_WDJ_To_Forecast_auto (
1834: p_api_version IN NUMBER,
1835: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1836: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1837: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1838: p_debug IN VARCHAR2 ,
1839:
1840: p_forecast_rec IN eam_forecasts%ROWTYPE,
1841: p_wip_id_table IN wo_table_type,

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

2009: END insert_into_wdj_auto;
2010: */
2011: PROCEDURE Copy_CEBBA_To_Forecast_auto (
2012: p_api_version IN NUMBER,
2013: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2014: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2015: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2016: p_debug IN VARCHAR2 ,
2017:

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

2010: */
2011: PROCEDURE Copy_CEBBA_To_Forecast_auto (
2012: p_api_version IN NUMBER,
2013: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2014: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2015: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2016: p_debug IN VARCHAR2 ,
2017:
2018: p_forecast_rec IN eam_forecasts%ROWTYPE,

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

2011: PROCEDURE Copy_CEBBA_To_Forecast_auto (
2012: p_api_version IN NUMBER,
2013: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2014: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2015: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2016: p_debug IN VARCHAR2 ,
2017:
2018: p_forecast_rec IN eam_forecasts%ROWTYPE,
2019: p_wip_id_table IN wo_table_type,

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

2079:
2080:
2081: PROCEDURE Copy_WOR_To_Forecast (
2082: p_api_version IN NUMBER,
2083: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2084: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2085: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2086: p_debug IN VARCHAR2 ,
2087:

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

2080:
2081: PROCEDURE Copy_WOR_To_Forecast (
2082: p_api_version IN NUMBER,
2083: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2084: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2085: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2086: p_debug IN VARCHAR2 ,
2087:
2088: p_forecast_rec IN eam_forecasts%ROWTYPE,

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

2081: PROCEDURE Copy_WOR_To_Forecast (
2082: p_api_version IN NUMBER,
2083: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2084: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2085: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2086: p_debug IN VARCHAR2 ,
2087:
2088: p_forecast_rec IN eam_forecasts%ROWTYPE,
2089: p_wip_id_table IN wo_table_type,

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

2170: --USAF
2171:
2172: PROCEDURE Copy_WOR_To_Forecast_auto (
2173: p_api_version IN NUMBER,
2174: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2175: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2177: p_debug IN VARCHAR2 ,
2178:

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

2171:
2172: PROCEDURE Copy_WOR_To_Forecast_auto (
2173: p_api_version IN NUMBER,
2174: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2175: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2177: p_debug IN VARCHAR2 ,
2178:
2179: p_forecast_rec IN eam_forecasts%ROWTYPE,

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

2172: PROCEDURE Copy_WOR_To_Forecast_auto (
2173: p_api_version IN NUMBER,
2174: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2175: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2176: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2177: p_debug IN VARCHAR2 ,
2178:
2179: p_forecast_rec IN eam_forecasts%ROWTYPE,
2180: p_wip_id_table IN wo_table_type,

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

2253:
2254:
2255: PROCEDURE Copy_WRO_To_Forecast (
2256: p_api_version IN NUMBER,
2257: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2258: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2259: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2260: p_debug IN VARCHAR2 ,
2261:

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

2254:
2255: PROCEDURE Copy_WRO_To_Forecast (
2256: p_api_version IN NUMBER,
2257: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2258: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2259: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2260: p_debug IN VARCHAR2 ,
2261:
2262: p_forecast_rec IN eam_forecasts%ROWTYPE,

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

2255: PROCEDURE Copy_WRO_To_Forecast (
2256: p_api_version IN NUMBER,
2257: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2258: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2259: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2260: p_debug IN VARCHAR2 ,
2261:
2262: p_forecast_rec IN eam_forecasts%ROWTYPE,
2263: p_wip_id_table IN wo_table_type,

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

2349: --USAF
2350:
2351: PROCEDURE Copy_wro_To_Forecast_auto (
2352: p_api_version IN NUMBER,
2353: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2354: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2355: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2356: p_debug IN VARCHAR2 ,
2357:

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

2350:
2351: PROCEDURE Copy_wro_To_Forecast_auto (
2352: p_api_version IN NUMBER,
2353: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2354: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2355: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2356: p_debug IN VARCHAR2 ,
2357:
2358: p_forecast_rec IN eam_forecasts%ROWTYPE,

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

2351: PROCEDURE Copy_wro_To_Forecast_auto (
2352: p_api_version IN NUMBER,
2353: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2354: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2355: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2356: p_debug IN VARCHAR2 ,
2357:
2358: p_forecast_rec IN eam_forecasts%ROWTYPE,
2359: p_wip_id_table IN wo_table_type,

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

2431:
2432:
2433: PROCEDURE Copy_WO_To_Forecast (
2434: p_api_version IN NUMBER,
2435: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2436: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2437: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2438: p_debug IN VARCHAR2 ,
2439:

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

2432:
2433: PROCEDURE Copy_WO_To_Forecast (
2434: p_api_version IN NUMBER,
2435: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2436: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2437: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2438: p_debug IN VARCHAR2 ,
2439:
2440: p_forecast_rec IN eam_forecasts%ROWTYPE,

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

2433: PROCEDURE Copy_WO_To_Forecast (
2434: p_api_version IN NUMBER,
2435: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2436: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2437: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2438: p_debug IN VARCHAR2 ,
2439:
2440: p_forecast_rec IN eam_forecasts%ROWTYPE,
2441: p_wip_id_table IN wo_table_type,

Line 2522: x_return_status := FND_API.G_RET_STS_ERROR ;

2518: EXCEPTION
2519:
2520: WHEN no_data_found THEN
2521: --ROLLBACK TO Extract_Forecast_PVT;
2522: x_return_status := FND_API.G_RET_STS_ERROR ;
2523: FND_MSG_PUB.Count_And_Get
2524: ( p_count => x_msg_count ,
2525: p_data => x_msg_data
2526: );

Line 2527: RAISE FND_API.G_EXC_ERROR;

2523: FND_MSG_PUB.Count_And_Get
2524: ( p_count => x_msg_count ,
2525: p_data => x_msg_data
2526: );
2527: RAISE FND_API.G_EXC_ERROR;
2528: WHEN OTHERS THEN
2529: debug('EXCEPTION');
2530: --ROLLBACK TO Extract_Forecast_PVT;
2531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 2531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2527: RAISE FND_API.G_EXC_ERROR;
2528: WHEN OTHERS THEN
2529: debug('EXCEPTION');
2530: --ROLLBACK TO Extract_Forecast_PVT;
2531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2532: IF FND_MSG_PUB.Check_Msg_Level
2533: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2534: THEN
2535: FND_MSG_PUB.Add_Exc_Msg

Line 2545: RAISE FND_API.G_EXC_ERROR;

2541: FND_MSG_PUB.Count_And_Get
2542: ( p_count => x_msg_count ,
2543: p_data => x_msg_data
2544: );
2545: RAISE FND_API.G_EXC_ERROR;
2546:
2547:
2548: END Copy_WO_To_Forecast;
2549:

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

2550:
2551: --USAF
2552: PROCEDURE Copy_WO_To_Forecast_auto (
2553: p_api_version IN NUMBER,
2554: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2555: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2556: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2557: p_debug IN VARCHAR2 ,
2558:

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

2551: --USAF
2552: PROCEDURE Copy_WO_To_Forecast_auto (
2553: p_api_version IN NUMBER,
2554: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2555: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2556: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2557: p_debug IN VARCHAR2 ,
2558:
2559: p_forecast_rec IN eam_forecasts%ROWTYPE,

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

2552: PROCEDURE Copy_WO_To_Forecast_auto (
2553: p_api_version IN NUMBER,
2554: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2555: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2556: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2557: p_debug IN VARCHAR2 ,
2558:
2559: p_forecast_rec IN eam_forecasts%ROWTYPE,
2560: p_wip_id_table IN wo_table_type,

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

2631:
2632:
2633: PROCEDURE Copy_CEBBA_To_Forecast (
2634: p_api_version IN NUMBER,
2635: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2636: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2637: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2638: p_debug IN VARCHAR2 ,
2639:

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

2632:
2633: PROCEDURE Copy_CEBBA_To_Forecast (
2634: p_api_version IN NUMBER,
2635: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2636: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2637: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2638: p_debug IN VARCHAR2 ,
2639:
2640: p_forecast_rec IN eam_forecasts%ROWTYPE,

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

2633: PROCEDURE Copy_CEBBA_To_Forecast (
2634: p_api_version IN NUMBER,
2635: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2636: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2637: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2638: p_debug IN VARCHAR2 ,
2639:
2640: p_forecast_rec IN eam_forecasts%ROWTYPE,
2641: p_wip_id_table IN wo_table_type,

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

2805: END Copy_CEBBA_To_Forecast;
2806:
2807: PROCEDURE Copy_WEDI_To_Forecast (
2808: p_api_version IN NUMBER,
2809: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2810: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2811: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2812: p_debug IN VARCHAR2 ,
2813:

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

2806:
2807: PROCEDURE Copy_WEDI_To_Forecast (
2808: p_api_version IN NUMBER,
2809: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2810: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2811: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2812: p_debug IN VARCHAR2 ,
2813:
2814: p_forecast_rec IN eam_forecasts%ROWTYPE,

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

2807: PROCEDURE Copy_WEDI_To_Forecast (
2808: p_api_version IN NUMBER,
2809: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2810: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2811: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2812: p_debug IN VARCHAR2 ,
2813:
2814: p_forecast_rec IN eam_forecasts%ROWTYPE,
2815: p_wip_id_table IN wo_table_type,

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

2877: --USAF
2878:
2879: PROCEDURE Copy_wedi_To_Forecast_auto (
2880: p_api_version IN NUMBER,
2881: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2882: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2883: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2884: p_debug IN VARCHAR2 ,
2885:

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

2878:
2879: PROCEDURE Copy_wedi_To_Forecast_auto (
2880: p_api_version IN NUMBER,
2881: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2882: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2883: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2884: p_debug IN VARCHAR2 ,
2885:
2886: p_forecast_rec IN eam_forecasts%ROWTYPE,

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

2879: PROCEDURE Copy_wedi_To_Forecast_auto (
2880: p_api_version IN NUMBER,
2881: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2882: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2883: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2884: p_debug IN VARCHAR2 ,
2885:
2886: p_forecast_rec IN eam_forecasts%ROWTYPE,
2887: p_wip_id_table IN wo_table_type,