[Home] [Help]
1498:
1499: cep_standard.debug('<
1501: WHEN NO_DATA_FOUND THEN
1502: UPDATE ce_forecasts
1503: SET error_status = 'X'
1504: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
1505:
1506: FND_MESSAGE.set_name('CE', 'CE_FC_NO_BANK_EXCH_RATE');
1528:
1529: -- If overdue and prior-day overlap, issue warning
1530: IF (l_balance_date < l_fc_start_date AND
1531: CE_CASH_FCST.G_overdue_transactions = 'INCLUDE') THEN
1532: UPDATE ce_forecasts
1533: SET error_status = 'X'
1534: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
1535:
1536: FND_MESSAGE.set_name('CE', 'CE_FC_PD_OD_OVERLAP');
1627: l_opening_balance := 0;
1628: l_prior_day_cflow := 0;
1629: l_balance_date := null;
1630:
1631: UPDATE ce_forecasts
1632: SET error_status = 'X'
1633: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
1634:
1635: FND_MESSAGE.set_name('CE', 'CE_FC_NO_BANK_BALANCE');
1733:
1734: cep_standard.debug('<
1736: WHEN NO_DATA_FOUND THEN
1737: UPDATE ce_forecasts
1738: SET error_status = 'X'
1739: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
1740:
1741: FND_MESSAGE.set_name('CE', 'CE_FC_NO_SUB_EXCH_RATE');
1889: EXCEPTION
1890: When NO_DATA_FOUND Then
1891: cep_standard.debug('row_id = ' || to_char(CE_CASH_FCST.G_forecast_row_id));
1892:
1893: UPDATE ce_forecasts
1894: SET error_status = 'E'
1895: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
1896:
1897: FND_MESSAGE.set_name('CE', 'CE_NO_HIST_START_PERIOD');
2485: EXCEPTION
2486: When NO_DATA_FOUND Then
2487: cep_standard.debug('row_id = ' || to_char(CE_CASH_FCST.G_forecast_row_id));
2488:
2489: UPDATE ce_forecasts
2490: SET error_status = 'E'
2491: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
2492:
2493: FND_MESSAGE.set_name('CE', 'CE_NO_HIST_START_PERIOD');
2836: EXCEPTION
2837: When NO_DATA_FOUND Then
2838: cep_standard.debug('row_id = ' || to_char(CE_CASH_FCST.G_forecast_row_id));
2839:
2840: UPDATE ce_forecasts
2841: SET error_status = 'E'
2842: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
2843:
2844: FND_MESSAGE.set_name('CE', 'CE_NO_HIST_START_PERIOD');
3355:
3356: IF (l_amount <> 0) THEN
3357: IF (C_req_rec.trx_end_date IS NULL and error_flag = FALSE) THEN
3358:
3359: UPDATE ce_forecasts
3360: SET error_status = 'X'
3361: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
3362:
3363: FND_MESSAGE.set_name('CE', 'CE_FC_POP_NO_END_DATE');
3501:
3502: IF (l_amount <> 0) THEN
3503: IF (C_req_rec.trx_end_date IS NULL and error_flag = FALSE) THEN
3504:
3505: UPDATE ce_forecasts
3506: SET error_status = 'X'
3507: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
3508:
3509: FND_MESSAGE.set_name('CE', 'CE_FC_POP_NO_END_DATE');
3664:
3665: IF (l_amount <> 0) THEN
3666: IF (C_req_rec.trx_end_date IS NULL and error_flag = FALSE) THEN
3667:
3668: UPDATE ce_forecasts
3669: SET error_status = 'X'
3670: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
3671:
3672: FND_MESSAGE.set_name('CE', 'CE_FC_POP_NO_END_DATE');
3807:
3808: IF (l_amount <> 0) THEN
3809: IF (C_req_rec.trx_end_date IS NULL and error_flag = FALSE) THEN
3810:
3811: UPDATE ce_forecasts
3812: SET error_status = 'X'
3813: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
3814:
3815: FND_MESSAGE.set_name('CE', 'CE_FC_POP_NO_END_DATE');
4063:
4064: IF (l_amount <> 0) THEN
4065: IF (C_req_rec.trx_end_date IS NULL and error_flag = FALSE) THEN
4066:
4067: UPDATE ce_forecasts
4068: SET error_status = 'X'
4069: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
4070:
4071: FND_MESSAGE.set_name('CE', 'CE_FC_POR_NO_END_DATE');
4187:
4188: IF (l_amount <> 0) THEN
4189: IF (C_req_rec.trx_end_date IS NULL and error_flag = FALSE) THEN
4190:
4191: UPDATE ce_forecasts
4192: SET error_status = 'X'
4193: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
4194:
4195: FND_MESSAGE.set_name('CE', 'CE_FC_POR_NO_END_DATE');
5624: IF (CE_CASH_FCST.G_rp_project_id IS NOT NULL)
5625: THEN
5626: Build_PA_Trx_Query;
5627: ELSE
5628: UPDATE ce_forecasts
5629: SET error_status = 'X'
5630: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
5631:
5632: FND_MESSAGE.set_name ('CE','CE_FC_NO_PROJECT_RANGE');
5644: IF (CE_CASH_FCST.G_rp_project_id IS NOT NULL)
5645: THEN
5646: Build_PA_Budget_Query;
5647: ELSE
5648: UPDATE ce_forecasts
5649: SET error_status = 'X'
5650: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
5651:
5652: FND_MESSAGE.set_name ('CE','CE_FC_NO_PROJECT_RANGE');
5664: IF (CE_CASH_FCST.G_rp_project_id IS NOT NULL)
5665: THEN
5666: Build_PA_Billing_Query;
5667: ELSE
5668: UPDATE ce_forecasts
5669: SET error_status = 'X'
5670: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
5671:
5672: FND_MESSAGE.set_name ('CE','CE_FC_NO_PROJECT_RANGE');