DBA Data[Home] [Help]

APPS.CE_CSH_FCST_POP dependencies on FND_MESSAGE

Line 163: FND_MESSAGE.set_name ('CE','CE_FC_COLUMN_NOT_IN_RANGE');

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);

Line 164: FND_MESSAGE.set_token('COLUMN', col_num);

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;

Line 165: error_msg := FND_MESSAGE.GET;

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:

Line 1437: FND_MESSAGE.set_name('CE', 'CE_FC_NO_BANK_EXCH_RATE');

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;

Line 1438: FND_MESSAGE.set_token('FROM_CURR', l_bank_acc_curr);

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(

Line 1439: FND_MESSAGE.set_token('TO_CURR', CE_CASH_FCST.G_rp_forecast_currency);

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,

Line 1440: FND_MESSAGE.set_token('BANK_ACCOUNT_NAME', l_bank_acc_name);

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,

Line 1441: error_msg := FND_MESSAGE.get;

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,

Line 1467: FND_MESSAGE.set_name('CE', 'CE_FC_PD_OD_OVERLAP');

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,

Line 1468: FND_MESSAGE.set_token('BANK_ACCOUNT_NAME', l_bank_acc_name);

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,

Line 1469: error_msg := FND_MESSAGE.get;

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,

Line 1566: FND_MESSAGE.set_name('CE', 'CE_FC_NO_BANK_BALANCE');

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,

Line 1567: FND_MESSAGE.set_token('BANK_ACCOUNT_NAME', l_bank_acc_name);

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,

Line 1568: error_msg := FND_MESSAGE.get;

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,

Line 1672: FND_MESSAGE.set_name('CE', 'CE_FC_NO_SUB_EXCH_RATE');

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;

Line 1673: FND_MESSAGE.set_token('FROM_CURR', p_sub_acct.currency_code);

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(

Line 1674: FND_MESSAGE.set_token('TO_CURR', CE_CASH_FCST.G_rp_forecast_currency);

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,

Line 1675: FND_MESSAGE.set_token('ACCOUNT_NUMBER', p_sub_acct.account_number);

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,

Line 1676: error_msg := FND_MESSAGE.get;

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,

Line 1828: FND_MESSAGE.set_name('CE', 'CE_NO_HIST_START_PERIOD');

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,

Line 1829: error_msg := FND_MESSAGE.get;

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,

Line 2417: FND_MESSAGE.set_name('CE', 'CE_NO_HIST_START_PERIOD');

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,

Line 2418: error_msg := FND_MESSAGE.get;

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,

Line 2768: FND_MESSAGE.set_name('CE', 'CE_NO_HIST_START_PERIOD');

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,

Line 2769: error_msg := FND_MESSAGE.get;

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,

Line 3287: FND_MESSAGE.set_name('CE', 'CE_FC_POP_NO_END_DATE');

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,

Line 3288: error_msg := FND_MESSAGE.get;

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,

Line 3433: FND_MESSAGE.set_name('CE', 'CE_FC_POP_NO_END_DATE');

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,

Line 3434: error_msg := FND_MESSAGE.get;

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,

Line 3596: FND_MESSAGE.set_name('CE', 'CE_FC_POP_NO_END_DATE');

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,

Line 3597: error_msg := FND_MESSAGE.get;

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,

Line 3739: FND_MESSAGE.set_name('CE', 'CE_FC_POP_NO_END_DATE');

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,

Line 3740: error_msg := FND_MESSAGE.get;

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,

Line 3995: FND_MESSAGE.set_name('CE', 'CE_FC_POR_NO_END_DATE');

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,

Line 3996: error_msg := FND_MESSAGE.get;

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,

Line 4119: FND_MESSAGE.set_name('CE', 'CE_FC_POR_NO_END_DATE');

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,

Line 4120: error_msg := FND_MESSAGE.get;

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,

Line 5208: FND_MESSAGE.set_name('CE','CE_FC_EXT_SOURCE_UNDEFINED');

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);

Line 5209: FND_MESSAGE.set_token('EXT_TYPE', CE_CASH_FCST.G_external_source_type);

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;

Line 5210: error_msg := FND_MESSAGE.get;

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;

Line 5349: FND_MESSAGE.set_name(''CE'', ''CE_FC_RMT_MISSING_VIEW_EXPT'');

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;

Line 5350: error_msg := FND_MESSAGE.get;

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

Line 5356: FND_MESSAGE.set_name(''CE'', ''CE_FC_RMT_INVALID_VIEW_EXPT'');

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;

Line 5357: error_msg := FND_MESSAGE.get;

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

Line 5363: FND_MESSAGE.set_name(''CE'', ''CE_FC_RMT_EXCEPTION'');

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;

Line 5364: error_msg := FND_MESSAGE.get;

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;

Line 5382: FND_MESSAGE.set_name('CE', 'CE_FC_RMT_DB_EXCEPTION');

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;

Line 5383: error_msg := FND_MESSAGE.get;

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;

Line 5396: FND_MESSAGE.set_name('CE', 'CE_FC_RMT_EXCEPTION');

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;

Line 5397: error_msg := FND_MESSAGE.get;

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:

Line 5464: FND_MESSAGE.set_name ('CE','CE_FC_NO_PROJECT_RANGE');

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,

Line 5465: error_msg := FND_MESSAGE.GET;

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);

Line 5478: FND_MESSAGE.set_name ('CE','CE_FC_NO_PROJECT_RANGE');

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,

Line 5479: error_msg := FND_MESSAGE.GET;

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);

Line 5492: FND_MESSAGE.set_name ('CE','CE_FC_NO_PROJECT_RANGE');

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,

Line 5493: error_msg := FND_MESSAGE.GET;

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);