DBA Data[Home] [Help]

APPS.CE_CSH_FCST_POP dependencies on CE_FORECASTS

Line 1433: UPDATE ce_forecasts

1429:
1430: cep_standard.debug('< 1431: EXCEPTION
1432: WHEN NO_DATA_FOUND THEN
1433: UPDATE ce_forecasts
1434: SET error_status = 'X'
1435: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
1436:
1437: FND_MESSAGE.set_name('CE', 'CE_FC_NO_BANK_EXCH_RATE');

Line 1463: UPDATE ce_forecasts

1459:
1460: -- If overdue and prior-day overlap, issue warning
1461: IF (l_balance_date < l_fc_start_date AND
1462: CE_CASH_FCST.G_overdue_transactions = 'INCLUDE') THEN
1463: UPDATE ce_forecasts
1464: SET error_status = 'X'
1465: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
1466:
1467: FND_MESSAGE.set_name('CE', 'CE_FC_PD_OD_OVERLAP');

Line 1562: UPDATE ce_forecasts

1558: l_opening_balance := 0;
1559: l_prior_day_cflow := 0;
1560: l_balance_date := null;
1561:
1562: UPDATE ce_forecasts
1563: SET error_status = 'X'
1564: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
1565:
1566: FND_MESSAGE.set_name('CE', 'CE_FC_NO_BANK_BALANCE');

Line 1668: UPDATE ce_forecasts

1664:
1665: cep_standard.debug('< 1666: EXCEPTION
1667: WHEN NO_DATA_FOUND THEN
1668: UPDATE ce_forecasts
1669: SET error_status = 'X'
1670: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
1671:
1672: FND_MESSAGE.set_name('CE', 'CE_FC_NO_SUB_EXCH_RATE');

Line 1824: UPDATE ce_forecasts

1820: EXCEPTION
1821: When NO_DATA_FOUND Then
1822: cep_standard.debug('row_id = ' || to_char(CE_CASH_FCST.G_forecast_row_id));
1823:
1824: UPDATE ce_forecasts
1825: SET error_status = 'E'
1826: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
1827:
1828: FND_MESSAGE.set_name('CE', 'CE_NO_HIST_START_PERIOD');

Line 2413: UPDATE ce_forecasts

2409: EXCEPTION
2410: When NO_DATA_FOUND Then
2411: cep_standard.debug('row_id = ' || to_char(CE_CASH_FCST.G_forecast_row_id));
2412:
2413: UPDATE ce_forecasts
2414: SET error_status = 'E'
2415: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
2416:
2417: FND_MESSAGE.set_name('CE', 'CE_NO_HIST_START_PERIOD');

Line 2764: UPDATE ce_forecasts

2760: EXCEPTION
2761: When NO_DATA_FOUND Then
2762: cep_standard.debug('row_id = ' || to_char(CE_CASH_FCST.G_forecast_row_id));
2763:
2764: UPDATE ce_forecasts
2765: SET error_status = 'E'
2766: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
2767:
2768: FND_MESSAGE.set_name('CE', 'CE_NO_HIST_START_PERIOD');

Line 3283: UPDATE ce_forecasts

3279:
3280: IF (l_amount <> 0) THEN
3281: IF (C_req_rec.trx_end_date IS NULL and error_flag = FALSE) THEN
3282:
3283: UPDATE ce_forecasts
3284: SET error_status = 'X'
3285: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
3286:
3287: FND_MESSAGE.set_name('CE', 'CE_FC_POP_NO_END_DATE');

Line 3429: UPDATE ce_forecasts

3425:
3426: IF (l_amount <> 0) THEN
3427: IF (C_req_rec.trx_end_date IS NULL and error_flag = FALSE) THEN
3428:
3429: UPDATE ce_forecasts
3430: SET error_status = 'X'
3431: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
3432:
3433: FND_MESSAGE.set_name('CE', 'CE_FC_POP_NO_END_DATE');

Line 3592: UPDATE ce_forecasts

3588:
3589: IF (l_amount <> 0) THEN
3590: IF (C_req_rec.trx_end_date IS NULL and error_flag = FALSE) THEN
3591:
3592: UPDATE ce_forecasts
3593: SET error_status = 'X'
3594: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
3595:
3596: FND_MESSAGE.set_name('CE', 'CE_FC_POP_NO_END_DATE');

Line 3735: UPDATE ce_forecasts

3731:
3732: IF (l_amount <> 0) THEN
3733: IF (C_req_rec.trx_end_date IS NULL and error_flag = FALSE) THEN
3734:
3735: UPDATE ce_forecasts
3736: SET error_status = 'X'
3737: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
3738:
3739: FND_MESSAGE.set_name('CE', 'CE_FC_POP_NO_END_DATE');

Line 3991: UPDATE ce_forecasts

3987:
3988: IF (l_amount <> 0) THEN
3989: IF (C_req_rec.trx_end_date IS NULL and error_flag = FALSE) THEN
3990:
3991: UPDATE ce_forecasts
3992: SET error_status = 'X'
3993: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
3994:
3995: FND_MESSAGE.set_name('CE', 'CE_FC_POR_NO_END_DATE');

Line 4115: UPDATE ce_forecasts

4111:
4112: IF (l_amount <> 0) THEN
4113: IF (C_req_rec.trx_end_date IS NULL and error_flag = FALSE) THEN
4114:
4115: UPDATE ce_forecasts
4116: SET error_status = 'X'
4117: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
4118:
4119: FND_MESSAGE.set_name('CE', 'CE_FC_POR_NO_END_DATE');

Line 5461: UPDATE ce_forecasts

5457: ELSIF (CE_CASH_FCST.G_trx_type = 'PAT') THEN
5458: IF (CE_CASH_FCST.G_rp_project_id IS NOT NULL) THEN
5459: Build_PA_Trx_Query;
5460: ELSE
5461: UPDATE ce_forecasts
5462: SET error_status = 'X'
5463: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
5464: FND_MESSAGE.set_name ('CE','CE_FC_NO_PROJECT_RANGE');
5465: error_msg := FND_MESSAGE.GET;

Line 5475: UPDATE ce_forecasts

5471: ELSIF (CE_CASH_FCST.G_trx_type in ('PAI', 'PAO')) THEN
5472: IF (CE_CASH_FCST.G_rp_project_id IS NOT NULL) THEN
5473: Build_PA_Budget_Query;
5474: ELSE
5475: UPDATE ce_forecasts
5476: SET error_status = 'X'
5477: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
5478: FND_MESSAGE.set_name ('CE','CE_FC_NO_PROJECT_RANGE');
5479: error_msg := FND_MESSAGE.GET;

Line 5489: UPDATE ce_forecasts

5485: ELSIF (CE_CASH_FCST.G_trx_type = 'PAB') THEN
5486: IF (CE_CASH_FCST.G_rp_project_id IS NOT NULL) THEN
5487: Build_PA_Billing_Query;
5488: ELSE
5489: UPDATE ce_forecasts
5490: SET error_status = 'X'
5491: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
5492: FND_MESSAGE.set_name ('CE','CE_FC_NO_PROJECT_RANGE');
5493: error_msg := FND_MESSAGE.GET;