159: days_from > max_col OR
160: days_to < min_col OR
161: days_to > max_col) THEN
162:
163: FND_MESSAGE.set_name ('CE','CE_FC_COLUMN_NOT_IN_RANGE');
164: FND_MESSAGE.set_token('COLUMN', col_num);
165: error_msg := FND_MESSAGE.GET;
166: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id,CE_CASH_FCST.G_rp_forecast_header_id,
167: CE_CASH_FCST.G_forecast_row_id,'CE_FC_COLUMN_NOT_IN_RANGE', error_msg);
160: days_to < min_col OR
161: days_to > max_col) THEN
162:
163: FND_MESSAGE.set_name ('CE','CE_FC_COLUMN_NOT_IN_RANGE');
164: FND_MESSAGE.set_token('COLUMN', col_num);
165: error_msg := FND_MESSAGE.GET;
166: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id,CE_CASH_FCST.G_rp_forecast_header_id,
167: CE_CASH_FCST.G_forecast_row_id,'CE_FC_COLUMN_NOT_IN_RANGE', error_msg);
168: END IF;
161: days_to > max_col) THEN
162:
163: FND_MESSAGE.set_name ('CE','CE_FC_COLUMN_NOT_IN_RANGE');
164: FND_MESSAGE.set_token('COLUMN', col_num);
165: error_msg := FND_MESSAGE.GET;
166: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id,CE_CASH_FCST.G_rp_forecast_header_id,
167: CE_CASH_FCST.G_forecast_row_id,'CE_FC_COLUMN_NOT_IN_RANGE', error_msg);
168: END IF;
169:
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');
1438: FND_MESSAGE.set_token('FROM_CURR', l_bank_acc_curr);
1439: FND_MESSAGE.set_token('TO_CURR', CE_CASH_FCST.G_rp_forecast_currency);
1440: FND_MESSAGE.set_token('BANK_ACCOUNT_NAME', l_bank_acc_name);
1441: error_msg := FND_MESSAGE.get;
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');
1438: FND_MESSAGE.set_token('FROM_CURR', l_bank_acc_curr);
1439: FND_MESSAGE.set_token('TO_CURR', CE_CASH_FCST.G_rp_forecast_currency);
1440: FND_MESSAGE.set_token('BANK_ACCOUNT_NAME', l_bank_acc_name);
1441: error_msg := FND_MESSAGE.get;
1442: CE_FORECAST_ERRORS_PKG.insert_row(
1435: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
1436:
1437: FND_MESSAGE.set_name('CE', 'CE_FC_NO_BANK_EXCH_RATE');
1438: FND_MESSAGE.set_token('FROM_CURR', l_bank_acc_curr);
1439: FND_MESSAGE.set_token('TO_CURR', CE_CASH_FCST.G_rp_forecast_currency);
1440: FND_MESSAGE.set_token('BANK_ACCOUNT_NAME', l_bank_acc_name);
1441: error_msg := FND_MESSAGE.get;
1442: CE_FORECAST_ERRORS_PKG.insert_row(
1443: CE_CASH_FCST.G_forecast_id,
1436:
1437: FND_MESSAGE.set_name('CE', 'CE_FC_NO_BANK_EXCH_RATE');
1438: FND_MESSAGE.set_token('FROM_CURR', l_bank_acc_curr);
1439: FND_MESSAGE.set_token('TO_CURR', CE_CASH_FCST.G_rp_forecast_currency);
1440: FND_MESSAGE.set_token('BANK_ACCOUNT_NAME', l_bank_acc_name);
1441: error_msg := FND_MESSAGE.get;
1442: CE_FORECAST_ERRORS_PKG.insert_row(
1443: CE_CASH_FCST.G_forecast_id,
1444: CE_CASH_FCST.G_rp_forecast_header_id,
1437: FND_MESSAGE.set_name('CE', 'CE_FC_NO_BANK_EXCH_RATE');
1438: FND_MESSAGE.set_token('FROM_CURR', l_bank_acc_curr);
1439: FND_MESSAGE.set_token('TO_CURR', CE_CASH_FCST.G_rp_forecast_currency);
1440: FND_MESSAGE.set_token('BANK_ACCOUNT_NAME', l_bank_acc_name);
1441: error_msg := FND_MESSAGE.get;
1442: CE_FORECAST_ERRORS_PKG.insert_row(
1443: CE_CASH_FCST.G_forecast_id,
1444: CE_CASH_FCST.G_rp_forecast_header_id,
1445: CE_CASH_FCST.G_forecast_row_id,
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');
1468: FND_MESSAGE.set_token('BANK_ACCOUNT_NAME', l_bank_acc_name);
1469: error_msg := FND_MESSAGE.get;
1470: CE_FORECAST_ERRORS_PKG.insert_row(
1471: CE_CASH_FCST.G_forecast_id,
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');
1468: FND_MESSAGE.set_token('BANK_ACCOUNT_NAME', l_bank_acc_name);
1469: error_msg := FND_MESSAGE.get;
1470: CE_FORECAST_ERRORS_PKG.insert_row(
1471: CE_CASH_FCST.G_forecast_id,
1472: CE_CASH_FCST.G_rp_forecast_header_id,
1465: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
1466:
1467: FND_MESSAGE.set_name('CE', 'CE_FC_PD_OD_OVERLAP');
1468: FND_MESSAGE.set_token('BANK_ACCOUNT_NAME', l_bank_acc_name);
1469: error_msg := FND_MESSAGE.get;
1470: CE_FORECAST_ERRORS_PKG.insert_row(
1471: CE_CASH_FCST.G_forecast_id,
1472: CE_CASH_FCST.G_rp_forecast_header_id,
1473: CE_CASH_FCST.G_forecast_row_id,
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');
1567: FND_MESSAGE.set_token('BANK_ACCOUNT_NAME', l_bank_acc_name);
1568: error_msg := FND_MESSAGE.get;
1569: CE_FORECAST_ERRORS_PKG.insert_row(
1570: CE_CASH_FCST.G_forecast_id,
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');
1567: FND_MESSAGE.set_token('BANK_ACCOUNT_NAME', l_bank_acc_name);
1568: error_msg := FND_MESSAGE.get;
1569: CE_FORECAST_ERRORS_PKG.insert_row(
1570: CE_CASH_FCST.G_forecast_id,
1571: CE_CASH_FCST.G_rp_forecast_header_id,
1564: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
1565:
1566: FND_MESSAGE.set_name('CE', 'CE_FC_NO_BANK_BALANCE');
1567: FND_MESSAGE.set_token('BANK_ACCOUNT_NAME', l_bank_acc_name);
1568: error_msg := FND_MESSAGE.get;
1569: CE_FORECAST_ERRORS_PKG.insert_row(
1570: CE_CASH_FCST.G_forecast_id,
1571: CE_CASH_FCST.G_rp_forecast_header_id,
1572: CE_CASH_FCST.G_forecast_row_id,
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');
1673: FND_MESSAGE.set_token('FROM_CURR', p_sub_acct.currency_code);
1674: FND_MESSAGE.set_token('TO_CURR', CE_CASH_FCST.G_rp_forecast_currency);
1675: FND_MESSAGE.set_token('ACCOUNT_NUMBER', p_sub_acct.account_number);
1676: error_msg := FND_MESSAGE.get;
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');
1673: FND_MESSAGE.set_token('FROM_CURR', p_sub_acct.currency_code);
1674: FND_MESSAGE.set_token('TO_CURR', CE_CASH_FCST.G_rp_forecast_currency);
1675: FND_MESSAGE.set_token('ACCOUNT_NUMBER', p_sub_acct.account_number);
1676: error_msg := FND_MESSAGE.get;
1677: CE_FORECAST_ERRORS_PKG.insert_row(
1670: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
1671:
1672: FND_MESSAGE.set_name('CE', 'CE_FC_NO_SUB_EXCH_RATE');
1673: FND_MESSAGE.set_token('FROM_CURR', p_sub_acct.currency_code);
1674: FND_MESSAGE.set_token('TO_CURR', CE_CASH_FCST.G_rp_forecast_currency);
1675: FND_MESSAGE.set_token('ACCOUNT_NUMBER', p_sub_acct.account_number);
1676: error_msg := FND_MESSAGE.get;
1677: CE_FORECAST_ERRORS_PKG.insert_row(
1678: CE_CASH_FCST.G_forecast_id,
1671:
1672: FND_MESSAGE.set_name('CE', 'CE_FC_NO_SUB_EXCH_RATE');
1673: FND_MESSAGE.set_token('FROM_CURR', p_sub_acct.currency_code);
1674: FND_MESSAGE.set_token('TO_CURR', CE_CASH_FCST.G_rp_forecast_currency);
1675: FND_MESSAGE.set_token('ACCOUNT_NUMBER', p_sub_acct.account_number);
1676: error_msg := FND_MESSAGE.get;
1677: CE_FORECAST_ERRORS_PKG.insert_row(
1678: CE_CASH_FCST.G_forecast_id,
1679: CE_CASH_FCST.G_rp_forecast_header_id,
1672: FND_MESSAGE.set_name('CE', 'CE_FC_NO_SUB_EXCH_RATE');
1673: FND_MESSAGE.set_token('FROM_CURR', p_sub_acct.currency_code);
1674: FND_MESSAGE.set_token('TO_CURR', CE_CASH_FCST.G_rp_forecast_currency);
1675: FND_MESSAGE.set_token('ACCOUNT_NUMBER', p_sub_acct.account_number);
1676: error_msg := FND_MESSAGE.get;
1677: CE_FORECAST_ERRORS_PKG.insert_row(
1678: CE_CASH_FCST.G_forecast_id,
1679: CE_CASH_FCST.G_rp_forecast_header_id,
1680: CE_CASH_FCST.G_forecast_row_id,
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');
1829: error_msg := FND_MESSAGE.get;
1830: CE_FORECAST_ERRORS_PKG.insert_row(
1831: CE_CASH_FCST.G_forecast_id,
1832: CE_CASH_FCST.G_rp_forecast_header_id,
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');
1829: error_msg := FND_MESSAGE.get;
1830: CE_FORECAST_ERRORS_PKG.insert_row(
1831: CE_CASH_FCST.G_forecast_id,
1832: CE_CASH_FCST.G_rp_forecast_header_id,
1833: CE_CASH_FCST.G_forecast_row_id,
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');
2418: error_msg := FND_MESSAGE.get;
2419: CE_FORECAST_ERRORS_PKG.insert_row(
2420: CE_CASH_FCST.G_forecast_id,
2421: CE_CASH_FCST.G_rp_forecast_header_id,
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');
2418: error_msg := FND_MESSAGE.get;
2419: CE_FORECAST_ERRORS_PKG.insert_row(
2420: CE_CASH_FCST.G_forecast_id,
2421: CE_CASH_FCST.G_rp_forecast_header_id,
2422: CE_CASH_FCST.G_forecast_row_id,
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');
2769: error_msg := FND_MESSAGE.get;
2770: CE_FORECAST_ERRORS_PKG.insert_row(
2771: CE_CASH_FCST.G_forecast_id,
2772: CE_CASH_FCST.G_rp_forecast_header_id,
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');
2769: error_msg := FND_MESSAGE.get;
2770: CE_FORECAST_ERRORS_PKG.insert_row(
2771: CE_CASH_FCST.G_forecast_id,
2772: CE_CASH_FCST.G_rp_forecast_header_id,
2773: CE_CASH_FCST.G_forecast_row_id,
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');
3288: error_msg := FND_MESSAGE.get;
3289: CE_FORECAST_ERRORS_PKG.insert_row(
3290: CE_CASH_FCST.G_forecast_id,
3291: CE_CASH_FCST.G_rp_forecast_header_id,
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');
3288: error_msg := FND_MESSAGE.get;
3289: CE_FORECAST_ERRORS_PKG.insert_row(
3290: CE_CASH_FCST.G_forecast_id,
3291: CE_CASH_FCST.G_rp_forecast_header_id,
3292: CE_CASH_FCST.G_forecast_row_id,
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');
3434: error_msg := FND_MESSAGE.get;
3435: CE_FORECAST_ERRORS_PKG.insert_row(
3436: CE_CASH_FCST.G_forecast_id,
3437: CE_CASH_FCST.G_rp_forecast_header_id,
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');
3434: error_msg := FND_MESSAGE.get;
3435: CE_FORECAST_ERRORS_PKG.insert_row(
3436: CE_CASH_FCST.G_forecast_id,
3437: CE_CASH_FCST.G_rp_forecast_header_id,
3438: CE_CASH_FCST.G_forecast_row_id,
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');
3597: error_msg := FND_MESSAGE.get;
3598: CE_FORECAST_ERRORS_PKG.insert_row(
3599: CE_CASH_FCST.G_forecast_id,
3600: CE_CASH_FCST.G_rp_forecast_header_id,
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');
3597: error_msg := FND_MESSAGE.get;
3598: CE_FORECAST_ERRORS_PKG.insert_row(
3599: CE_CASH_FCST.G_forecast_id,
3600: CE_CASH_FCST.G_rp_forecast_header_id,
3601: CE_CASH_FCST.G_forecast_row_id,
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');
3740: error_msg := FND_MESSAGE.get;
3741: CE_FORECAST_ERRORS_PKG.insert_row(
3742: CE_CASH_FCST.G_forecast_id,
3743: CE_CASH_FCST.G_rp_forecast_header_id,
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');
3740: error_msg := FND_MESSAGE.get;
3741: CE_FORECAST_ERRORS_PKG.insert_row(
3742: CE_CASH_FCST.G_forecast_id,
3743: CE_CASH_FCST.G_rp_forecast_header_id,
3744: CE_CASH_FCST.G_forecast_row_id,
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');
3996: error_msg := FND_MESSAGE.get;
3997: CE_FORECAST_ERRORS_PKG.insert_row(
3998: CE_CASH_FCST.G_forecast_id,
3999: CE_CASH_FCST.G_rp_forecast_header_id,
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');
3996: error_msg := FND_MESSAGE.get;
3997: CE_FORECAST_ERRORS_PKG.insert_row(
3998: CE_CASH_FCST.G_forecast_id,
3999: CE_CASH_FCST.G_rp_forecast_header_id,
4000: CE_CASH_FCST.G_forecast_row_id,
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');
4120: error_msg := FND_MESSAGE.get;
4121: CE_FORECAST_ERRORS_PKG.insert_row(
4122: CE_CASH_FCST.G_forecast_id,
4123: CE_CASH_FCST.G_rp_forecast_header_id,
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');
4120: error_msg := FND_MESSAGE.get;
4121: CE_FORECAST_ERRORS_PKG.insert_row(
4122: CE_CASH_FCST.G_forecast_id,
4123: CE_CASH_FCST.G_rp_forecast_header_id,
4124: CE_CASH_FCST.G_forecast_row_id,
5204:
5205: EXCEPTION
5206: WHEN NO_DATA_FOUND THEN
5207: cep_standard.debug('EXCEPTION:Build_Remote_Query - View def not found');
5208: FND_MESSAGE.set_name('CE','CE_FC_EXT_SOURCE_UNDEFINED');
5209: FND_MESSAGE.set_token('EXT_TYPE', CE_CASH_FCST.G_external_source_type);
5210: error_msg := FND_MESSAGE.get;
5211: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,
5212: CE_CASH_FCST.G_forecast_row_id, 'CE_FC_EXT_SOURCE_UNDEFINED', error_msg);
5205: EXCEPTION
5206: WHEN NO_DATA_FOUND THEN
5207: cep_standard.debug('EXCEPTION:Build_Remote_Query - View def not found');
5208: FND_MESSAGE.set_name('CE','CE_FC_EXT_SOURCE_UNDEFINED');
5209: FND_MESSAGE.set_token('EXT_TYPE', CE_CASH_FCST.G_external_source_type);
5210: error_msg := FND_MESSAGE.get;
5211: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,
5212: CE_CASH_FCST.G_forecast_row_id, 'CE_FC_EXT_SOURCE_UNDEFINED', error_msg);
5213: RETURN;
5206: WHEN NO_DATA_FOUND THEN
5207: cep_standard.debug('EXCEPTION:Build_Remote_Query - View def not found');
5208: FND_MESSAGE.set_name('CE','CE_FC_EXT_SOURCE_UNDEFINED');
5209: FND_MESSAGE.set_token('EXT_TYPE', CE_CASH_FCST.G_external_source_type);
5210: error_msg := FND_MESSAGE.get;
5211: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,
5212: CE_CASH_FCST.G_forecast_row_id, 'CE_FC_EXT_SOURCE_UNDEFINED', error_msg);
5213: RETURN;
5214: END;
5345: END LOOP;
5346: CE_CSH_FCST_POP.Zero_Fill_Cells;
5347: ELSIF( error_code = -1 )THEN
5348: cep_standard.debug(''Remote error: missing view'');
5349: FND_MESSAGE.set_name(''CE'', ''CE_FC_RMT_MISSING_VIEW_EXPT'');
5350: error_msg := FND_MESSAGE.get;
5351: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,
5352: CE_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_MISSING_VIEW_EXPT'', error_msg);
5353: return;
5346: CE_CSH_FCST_POP.Zero_Fill_Cells;
5347: ELSIF( error_code = -1 )THEN
5348: cep_standard.debug(''Remote error: missing view'');
5349: FND_MESSAGE.set_name(''CE'', ''CE_FC_RMT_MISSING_VIEW_EXPT'');
5350: error_msg := FND_MESSAGE.get;
5351: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,
5352: CE_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_MISSING_VIEW_EXPT'', error_msg);
5353: return;
5354: ELSIF( error_code = -2 )THEN
5352: CE_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_MISSING_VIEW_EXPT'', error_msg);
5353: return;
5354: ELSIF( error_code = -2 )THEN
5355: cep_standard.debug(''Remote error: invalid view'');
5356: FND_MESSAGE.set_name(''CE'', ''CE_FC_RMT_INVALID_VIEW_EXPT'');
5357: error_msg := FND_MESSAGE.get;
5358: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,
5359: CE_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_INVALID_VIEW_EXPT'', error_msg);
5360: return;
5353: return;
5354: ELSIF( error_code = -2 )THEN
5355: cep_standard.debug(''Remote error: invalid view'');
5356: FND_MESSAGE.set_name(''CE'', ''CE_FC_RMT_INVALID_VIEW_EXPT'');
5357: error_msg := FND_MESSAGE.get;
5358: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,
5359: CE_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_INVALID_VIEW_EXPT'', error_msg);
5360: return;
5361: ELSIF( error_code = -3 )THEN
5359: CE_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_INVALID_VIEW_EXPT'', error_msg);
5360: return;
5361: ELSIF( error_code = -3 )THEN
5362: cep_standard.debug(''Remote error: others'');
5363: FND_MESSAGE.set_name(''CE'', ''CE_FC_RMT_EXCEPTION'');
5364: error_msg := FND_MESSAGE.get;
5365: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,
5366: CE_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_EXCEPTION'', error_msg);
5367: return;
5360: return;
5361: ELSIF( error_code = -3 )THEN
5362: cep_standard.debug(''Remote error: others'');
5363: FND_MESSAGE.set_name(''CE'', ''CE_FC_RMT_EXCEPTION'');
5364: error_msg := FND_MESSAGE.get;
5365: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,
5366: CE_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_EXCEPTION'', error_msg);
5367: return;
5368: END IF;
5378: clear_aging_buckets;
5379: IF DBMS_SQL.is_open(cursor_id) THEN
5380: DBMS_SQL.close_cursor(cursor_id);
5381: END IF;
5382: FND_MESSAGE.set_name('CE', 'CE_FC_RMT_DB_EXCEPTION');
5383: error_msg := FND_MESSAGE.get;
5384: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,
5385: CE_CASH_FCST.G_forecast_row_id, 'CE_FC_RMT_DB_EXCEPTION', error_msg);
5386: return;
5379: IF DBMS_SQL.is_open(cursor_id) THEN
5380: DBMS_SQL.close_cursor(cursor_id);
5381: END IF;
5382: FND_MESSAGE.set_name('CE', 'CE_FC_RMT_DB_EXCEPTION');
5383: error_msg := FND_MESSAGE.get;
5384: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,
5385: CE_CASH_FCST.G_forecast_row_id, 'CE_FC_RMT_DB_EXCEPTION', error_msg);
5386: return;
5387: END;
5392: EXCEPTION
5393: WHEN OTHERS THEN
5394: clear_aging_buckets;
5395: cep_standard.debug('EXCEPTION:Build_Remote_Query');
5396: FND_MESSAGE.set_name('CE', 'CE_FC_RMT_EXCEPTION');
5397: error_msg := FND_MESSAGE.get;
5398: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,
5399: CE_CASH_FCST.G_forecast_row_id, 'CE_FC_RMT_EXCEPTION', error_msg);
5400: END Build_Remote_Query;
5393: WHEN OTHERS THEN
5394: clear_aging_buckets;
5395: cep_standard.debug('EXCEPTION:Build_Remote_Query');
5396: FND_MESSAGE.set_name('CE', 'CE_FC_RMT_EXCEPTION');
5397: error_msg := FND_MESSAGE.get;
5398: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,
5399: CE_CASH_FCST.G_forecast_row_id, 'CE_FC_RMT_EXCEPTION', error_msg);
5400: END Build_Remote_Query;
5401:
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;
5466: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id,
5467: CE_CASH_FCST.G_rp_forecast_header_id,
5468: CE_CASH_FCST.G_forecast_row_id,
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;
5466: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id,
5467: CE_CASH_FCST.G_rp_forecast_header_id,
5468: CE_CASH_FCST.G_forecast_row_id,
5469: 'CE_FC_NO_PROJECT_RANGE', error_msg);
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;
5480: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id,
5481: CE_CASH_FCST.G_rp_forecast_header_id,
5482: CE_CASH_FCST.G_forecast_row_id,
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;
5480: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id,
5481: CE_CASH_FCST.G_rp_forecast_header_id,
5482: CE_CASH_FCST.G_forecast_row_id,
5483: 'CE_FC_NO_PROJECT_RANGE', error_msg);
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;
5494: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id,
5495: CE_CASH_FCST.G_rp_forecast_header_id,
5496: CE_CASH_FCST.G_forecast_row_id,
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;
5494: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id,
5495: CE_CASH_FCST.G_rp_forecast_header_id,
5496: CE_CASH_FCST.G_forecast_row_id,
5497: 'CE_FC_NO_PROJECT_RANGE', error_msg);