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.CE_CSH_FCST_POP dependencies on FND_MESSAGE

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

168: days_to < min_col OR
169: days_to > max_col)
170: THEN
171:
172: FND_MESSAGE.set_name ('CE','CE_FC_COLUMN_NOT_IN_RANGE');
173: FND_MESSAGE.set_token('COLUMN', col_num);
174: error_msg := FND_MESSAGE.GET;
175: CE_FORECAST_ERRORS_PKG.insert_row(
176: CE_CASH_FCST.G_forecast_id,

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

169: days_to > max_col)
170: THEN
171:
172: FND_MESSAGE.set_name ('CE','CE_FC_COLUMN_NOT_IN_RANGE');
173: FND_MESSAGE.set_token('COLUMN', col_num);
174: error_msg := FND_MESSAGE.GET;
175: CE_FORECAST_ERRORS_PKG.insert_row(
176: CE_CASH_FCST.G_forecast_id,
177: CE_CASH_FCST.G_rp_forecast_header_id,

Line 174: error_msg := FND_MESSAGE.GET;

170: THEN
171:
172: FND_MESSAGE.set_name ('CE','CE_FC_COLUMN_NOT_IN_RANGE');
173: FND_MESSAGE.set_token('COLUMN', col_num);
174: error_msg := FND_MESSAGE.GET;
175: CE_FORECAST_ERRORS_PKG.insert_row(
176: CE_CASH_FCST.G_forecast_id,
177: CE_CASH_FCST.G_rp_forecast_header_id,
178: CE_CASH_FCST.G_forecast_row_id,'CE_FC_COLUMN_NOT_IN_RANGE',

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

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');
1507: FND_MESSAGE.set_token('FROM_CURR', l_bank_acc_curr);
1508: FND_MESSAGE.set_token('TO_CURR', CE_CASH_FCST.G_rp_forecast_currency);
1509: FND_MESSAGE.set_token('BANK_ACCOUNT_NAME', l_bank_acc_name);
1510: error_msg := FND_MESSAGE.get;

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

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');
1507: FND_MESSAGE.set_token('FROM_CURR', l_bank_acc_curr);
1508: FND_MESSAGE.set_token('TO_CURR', CE_CASH_FCST.G_rp_forecast_currency);
1509: FND_MESSAGE.set_token('BANK_ACCOUNT_NAME', l_bank_acc_name);
1510: error_msg := FND_MESSAGE.get;
1511: CE_FORECAST_ERRORS_PKG.insert_row(

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

1504: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
1505:
1506: FND_MESSAGE.set_name('CE', 'CE_FC_NO_BANK_EXCH_RATE');
1507: FND_MESSAGE.set_token('FROM_CURR', l_bank_acc_curr);
1508: FND_MESSAGE.set_token('TO_CURR', CE_CASH_FCST.G_rp_forecast_currency);
1509: FND_MESSAGE.set_token('BANK_ACCOUNT_NAME', l_bank_acc_name);
1510: error_msg := FND_MESSAGE.get;
1511: CE_FORECAST_ERRORS_PKG.insert_row(
1512: CE_CASH_FCST.G_forecast_id,

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

1505:
1506: FND_MESSAGE.set_name('CE', 'CE_FC_NO_BANK_EXCH_RATE');
1507: FND_MESSAGE.set_token('FROM_CURR', l_bank_acc_curr);
1508: FND_MESSAGE.set_token('TO_CURR', CE_CASH_FCST.G_rp_forecast_currency);
1509: FND_MESSAGE.set_token('BANK_ACCOUNT_NAME', l_bank_acc_name);
1510: error_msg := FND_MESSAGE.get;
1511: CE_FORECAST_ERRORS_PKG.insert_row(
1512: CE_CASH_FCST.G_forecast_id,
1513: CE_CASH_FCST.G_rp_forecast_header_id,

Line 1510: error_msg := FND_MESSAGE.get;

1506: FND_MESSAGE.set_name('CE', 'CE_FC_NO_BANK_EXCH_RATE');
1507: FND_MESSAGE.set_token('FROM_CURR', l_bank_acc_curr);
1508: FND_MESSAGE.set_token('TO_CURR', CE_CASH_FCST.G_rp_forecast_currency);
1509: FND_MESSAGE.set_token('BANK_ACCOUNT_NAME', l_bank_acc_name);
1510: error_msg := FND_MESSAGE.get;
1511: CE_FORECAST_ERRORS_PKG.insert_row(
1512: CE_CASH_FCST.G_forecast_id,
1513: CE_CASH_FCST.G_rp_forecast_header_id,
1514: CE_CASH_FCST.G_forecast_row_id,

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

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');
1537: FND_MESSAGE.set_token('BANK_ACCOUNT_NAME', l_bank_acc_name);
1538: error_msg := FND_MESSAGE.get;
1539: CE_FORECAST_ERRORS_PKG.insert_row(
1540: CE_CASH_FCST.G_forecast_id,

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

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');
1537: FND_MESSAGE.set_token('BANK_ACCOUNT_NAME', l_bank_acc_name);
1538: error_msg := FND_MESSAGE.get;
1539: CE_FORECAST_ERRORS_PKG.insert_row(
1540: CE_CASH_FCST.G_forecast_id,
1541: CE_CASH_FCST.G_rp_forecast_header_id,

Line 1538: error_msg := FND_MESSAGE.get;

1534: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
1535:
1536: FND_MESSAGE.set_name('CE', 'CE_FC_PD_OD_OVERLAP');
1537: FND_MESSAGE.set_token('BANK_ACCOUNT_NAME', l_bank_acc_name);
1538: error_msg := FND_MESSAGE.get;
1539: CE_FORECAST_ERRORS_PKG.insert_row(
1540: CE_CASH_FCST.G_forecast_id,
1541: CE_CASH_FCST.G_rp_forecast_header_id,
1542: CE_CASH_FCST.G_forecast_row_id,

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

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');
1636: FND_MESSAGE.set_token('BANK_ACCOUNT_NAME', l_bank_acc_name);
1637: error_msg := FND_MESSAGE.get;
1638: CE_FORECAST_ERRORS_PKG.insert_row(
1639: CE_CASH_FCST.G_forecast_id,

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

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');
1636: FND_MESSAGE.set_token('BANK_ACCOUNT_NAME', l_bank_acc_name);
1637: error_msg := FND_MESSAGE.get;
1638: CE_FORECAST_ERRORS_PKG.insert_row(
1639: CE_CASH_FCST.G_forecast_id,
1640: CE_CASH_FCST.G_rp_forecast_header_id,

Line 1637: error_msg := FND_MESSAGE.get;

1633: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
1634:
1635: FND_MESSAGE.set_name('CE', 'CE_FC_NO_BANK_BALANCE');
1636: FND_MESSAGE.set_token('BANK_ACCOUNT_NAME', l_bank_acc_name);
1637: error_msg := FND_MESSAGE.get;
1638: CE_FORECAST_ERRORS_PKG.insert_row(
1639: CE_CASH_FCST.G_forecast_id,
1640: CE_CASH_FCST.G_rp_forecast_header_id,
1641: CE_CASH_FCST.G_forecast_row_id,

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

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');
1742: FND_MESSAGE.set_token('FROM_CURR', p_sub_acct.currency_code);
1743: FND_MESSAGE.set_token('TO_CURR', CE_CASH_FCST.G_rp_forecast_currency);
1744: FND_MESSAGE.set_token('ACCOUNT_NUMBER', p_sub_acct.account_number);
1745: error_msg := FND_MESSAGE.get;

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

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');
1742: FND_MESSAGE.set_token('FROM_CURR', p_sub_acct.currency_code);
1743: FND_MESSAGE.set_token('TO_CURR', CE_CASH_FCST.G_rp_forecast_currency);
1744: FND_MESSAGE.set_token('ACCOUNT_NUMBER', p_sub_acct.account_number);
1745: error_msg := FND_MESSAGE.get;
1746: CE_FORECAST_ERRORS_PKG.insert_row(

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

1739: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
1740:
1741: FND_MESSAGE.set_name('CE', 'CE_FC_NO_SUB_EXCH_RATE');
1742: FND_MESSAGE.set_token('FROM_CURR', p_sub_acct.currency_code);
1743: FND_MESSAGE.set_token('TO_CURR', CE_CASH_FCST.G_rp_forecast_currency);
1744: FND_MESSAGE.set_token('ACCOUNT_NUMBER', p_sub_acct.account_number);
1745: error_msg := FND_MESSAGE.get;
1746: CE_FORECAST_ERRORS_PKG.insert_row(
1747: CE_CASH_FCST.G_forecast_id,

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

1740:
1741: FND_MESSAGE.set_name('CE', 'CE_FC_NO_SUB_EXCH_RATE');
1742: FND_MESSAGE.set_token('FROM_CURR', p_sub_acct.currency_code);
1743: FND_MESSAGE.set_token('TO_CURR', CE_CASH_FCST.G_rp_forecast_currency);
1744: FND_MESSAGE.set_token('ACCOUNT_NUMBER', p_sub_acct.account_number);
1745: error_msg := FND_MESSAGE.get;
1746: CE_FORECAST_ERRORS_PKG.insert_row(
1747: CE_CASH_FCST.G_forecast_id,
1748: CE_CASH_FCST.G_rp_forecast_header_id,

Line 1745: error_msg := FND_MESSAGE.get;

1741: FND_MESSAGE.set_name('CE', 'CE_FC_NO_SUB_EXCH_RATE');
1742: FND_MESSAGE.set_token('FROM_CURR', p_sub_acct.currency_code);
1743: FND_MESSAGE.set_token('TO_CURR', CE_CASH_FCST.G_rp_forecast_currency);
1744: FND_MESSAGE.set_token('ACCOUNT_NUMBER', p_sub_acct.account_number);
1745: error_msg := FND_MESSAGE.get;
1746: CE_FORECAST_ERRORS_PKG.insert_row(
1747: CE_CASH_FCST.G_forecast_id,
1748: CE_CASH_FCST.G_rp_forecast_header_id,
1749: CE_CASH_FCST.G_forecast_row_id,

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

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');
1898: error_msg := FND_MESSAGE.get;
1899: CE_FORECAST_ERRORS_PKG.insert_row(
1900: CE_CASH_FCST.G_forecast_id,
1901: CE_CASH_FCST.G_rp_forecast_header_id,

Line 1898: error_msg := FND_MESSAGE.get;

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');
1898: error_msg := FND_MESSAGE.get;
1899: CE_FORECAST_ERRORS_PKG.insert_row(
1900: CE_CASH_FCST.G_forecast_id,
1901: CE_CASH_FCST.G_rp_forecast_header_id,
1902: CE_CASH_FCST.G_forecast_row_id,

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

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');
2494: error_msg := FND_MESSAGE.get;
2495: CE_FORECAST_ERRORS_PKG.insert_row(
2496: CE_CASH_FCST.G_forecast_id,
2497: CE_CASH_FCST.G_rp_forecast_header_id,

Line 2494: error_msg := FND_MESSAGE.get;

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');
2494: error_msg := FND_MESSAGE.get;
2495: CE_FORECAST_ERRORS_PKG.insert_row(
2496: CE_CASH_FCST.G_forecast_id,
2497: CE_CASH_FCST.G_rp_forecast_header_id,
2498: CE_CASH_FCST.G_forecast_row_id,

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

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');
2845: error_msg := FND_MESSAGE.get;
2846: CE_FORECAST_ERRORS_PKG.insert_row(
2847: CE_CASH_FCST.G_forecast_id,
2848: CE_CASH_FCST.G_rp_forecast_header_id,

Line 2845: error_msg := FND_MESSAGE.get;

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');
2845: error_msg := FND_MESSAGE.get;
2846: CE_FORECAST_ERRORS_PKG.insert_row(
2847: CE_CASH_FCST.G_forecast_id,
2848: CE_CASH_FCST.G_rp_forecast_header_id,
2849: CE_CASH_FCST.G_forecast_row_id,

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

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');
3364: error_msg := FND_MESSAGE.get;
3365: CE_FORECAST_ERRORS_PKG.insert_row(
3366: CE_CASH_FCST.G_forecast_id,
3367: CE_CASH_FCST.G_rp_forecast_header_id,

Line 3364: error_msg := FND_MESSAGE.get;

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');
3364: error_msg := FND_MESSAGE.get;
3365: CE_FORECAST_ERRORS_PKG.insert_row(
3366: CE_CASH_FCST.G_forecast_id,
3367: CE_CASH_FCST.G_rp_forecast_header_id,
3368: CE_CASH_FCST.G_forecast_row_id,

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

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');
3510: error_msg := FND_MESSAGE.get;
3511: CE_FORECAST_ERRORS_PKG.insert_row(
3512: CE_CASH_FCST.G_forecast_id,
3513: CE_CASH_FCST.G_rp_forecast_header_id,

Line 3510: error_msg := FND_MESSAGE.get;

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');
3510: error_msg := FND_MESSAGE.get;
3511: CE_FORECAST_ERRORS_PKG.insert_row(
3512: CE_CASH_FCST.G_forecast_id,
3513: CE_CASH_FCST.G_rp_forecast_header_id,
3514: CE_CASH_FCST.G_forecast_row_id,

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

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');
3673: error_msg := FND_MESSAGE.get;
3674: CE_FORECAST_ERRORS_PKG.insert_row(
3675: CE_CASH_FCST.G_forecast_id,
3676: CE_CASH_FCST.G_rp_forecast_header_id,

Line 3673: error_msg := FND_MESSAGE.get;

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');
3673: error_msg := FND_MESSAGE.get;
3674: CE_FORECAST_ERRORS_PKG.insert_row(
3675: CE_CASH_FCST.G_forecast_id,
3676: CE_CASH_FCST.G_rp_forecast_header_id,
3677: CE_CASH_FCST.G_forecast_row_id,

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

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');
3816: error_msg := FND_MESSAGE.get;
3817: CE_FORECAST_ERRORS_PKG.insert_row(
3818: CE_CASH_FCST.G_forecast_id,
3819: CE_CASH_FCST.G_rp_forecast_header_id,

Line 3816: error_msg := FND_MESSAGE.get;

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');
3816: error_msg := FND_MESSAGE.get;
3817: CE_FORECAST_ERRORS_PKG.insert_row(
3818: CE_CASH_FCST.G_forecast_id,
3819: CE_CASH_FCST.G_rp_forecast_header_id,
3820: CE_CASH_FCST.G_forecast_row_id,

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

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');
4072: error_msg := FND_MESSAGE.get;
4073: CE_FORECAST_ERRORS_PKG.insert_row(
4074: CE_CASH_FCST.G_forecast_id,
4075: CE_CASH_FCST.G_rp_forecast_header_id,

Line 4072: error_msg := FND_MESSAGE.get;

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');
4072: error_msg := FND_MESSAGE.get;
4073: CE_FORECAST_ERRORS_PKG.insert_row(
4074: CE_CASH_FCST.G_forecast_id,
4075: CE_CASH_FCST.G_rp_forecast_header_id,
4076: CE_CASH_FCST.G_forecast_row_id,

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

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');
4196: error_msg := FND_MESSAGE.get;
4197: CE_FORECAST_ERRORS_PKG.insert_row(
4198: CE_CASH_FCST.G_forecast_id,
4199: CE_CASH_FCST.G_rp_forecast_header_id,

Line 4196: error_msg := FND_MESSAGE.get;

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');
4196: error_msg := FND_MESSAGE.get;
4197: CE_FORECAST_ERRORS_PKG.insert_row(
4198: CE_CASH_FCST.G_forecast_id,
4199: CE_CASH_FCST.G_rp_forecast_header_id,
4200: CE_CASH_FCST.G_forecast_row_id,

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

5355:
5356: EXCEPTION
5357: WHEN NO_DATA_FOUND THEN
5358: cep_standard.debug('EXCEPTION:Build_Remote_Query - View def not found');
5359: FND_MESSAGE.set_name('CE','CE_FC_EXT_SOURCE_UNDEFINED');
5360: FND_MESSAGE.set_token('EXT_TYPE', CE_CASH_FCST.G_external_source_type);
5361: error_msg := FND_MESSAGE.get;
5362: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,
5363: CE_CASH_FCST.G_forecast_row_id, 'CE_FC_EXT_SOURCE_UNDEFINED', error_msg);

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

5356: EXCEPTION
5357: WHEN NO_DATA_FOUND THEN
5358: cep_standard.debug('EXCEPTION:Build_Remote_Query - View def not found');
5359: FND_MESSAGE.set_name('CE','CE_FC_EXT_SOURCE_UNDEFINED');
5360: FND_MESSAGE.set_token('EXT_TYPE', CE_CASH_FCST.G_external_source_type);
5361: error_msg := FND_MESSAGE.get;
5362: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,
5363: CE_CASH_FCST.G_forecast_row_id, 'CE_FC_EXT_SOURCE_UNDEFINED', error_msg);
5364: RETURN;

Line 5361: error_msg := FND_MESSAGE.get;

5357: WHEN NO_DATA_FOUND THEN
5358: cep_standard.debug('EXCEPTION:Build_Remote_Query - View def not found');
5359: FND_MESSAGE.set_name('CE','CE_FC_EXT_SOURCE_UNDEFINED');
5360: FND_MESSAGE.set_token('EXT_TYPE', CE_CASH_FCST.G_external_source_type);
5361: error_msg := FND_MESSAGE.get;
5362: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,
5363: CE_CASH_FCST.G_forecast_row_id, 'CE_FC_EXT_SOURCE_UNDEFINED', error_msg);
5364: RETURN;
5365: END;

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

5496: END LOOP;
5497: CE_CSH_FCST_POP.Zero_Fill_Cells;
5498: ELSIF( error_code = -1 )THEN
5499: cep_standard.debug(''Remote error: missing view'');
5500: FND_MESSAGE.set_name(''CE'', ''CE_FC_RMT_MISSING_VIEW_EXPT'');
5501: error_msg := FND_MESSAGE.get;
5502: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,
5503: CE_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_MISSING_VIEW_EXPT'', error_msg);
5504: return;

Line 5501: error_msg := FND_MESSAGE.get;

5497: CE_CSH_FCST_POP.Zero_Fill_Cells;
5498: ELSIF( error_code = -1 )THEN
5499: cep_standard.debug(''Remote error: missing view'');
5500: FND_MESSAGE.set_name(''CE'', ''CE_FC_RMT_MISSING_VIEW_EXPT'');
5501: error_msg := FND_MESSAGE.get;
5502: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,
5503: CE_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_MISSING_VIEW_EXPT'', error_msg);
5504: return;
5505: ELSIF( error_code = -2 )THEN

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

5503: CE_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_MISSING_VIEW_EXPT'', error_msg);
5504: return;
5505: ELSIF( error_code = -2 )THEN
5506: cep_standard.debug(''Remote error: invalid view'');
5507: FND_MESSAGE.set_name(''CE'', ''CE_FC_RMT_INVALID_VIEW_EXPT'');
5508: error_msg := FND_MESSAGE.get;
5509: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,
5510: CE_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_INVALID_VIEW_EXPT'', error_msg);
5511: return;

Line 5508: error_msg := FND_MESSAGE.get;

5504: return;
5505: ELSIF( error_code = -2 )THEN
5506: cep_standard.debug(''Remote error: invalid view'');
5507: FND_MESSAGE.set_name(''CE'', ''CE_FC_RMT_INVALID_VIEW_EXPT'');
5508: error_msg := FND_MESSAGE.get;
5509: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,
5510: CE_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_INVALID_VIEW_EXPT'', error_msg);
5511: return;
5512: ELSIF( error_code = -3 )THEN

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

5510: CE_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_INVALID_VIEW_EXPT'', error_msg);
5511: return;
5512: ELSIF( error_code = -3 )THEN
5513: cep_standard.debug(''Remote error: others'');
5514: FND_MESSAGE.set_name(''CE'', ''CE_FC_RMT_EXCEPTION'');
5515: error_msg := FND_MESSAGE.get;
5516: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,
5517: CE_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_EXCEPTION'', error_msg);
5518: return;

Line 5515: error_msg := FND_MESSAGE.get;

5511: return;
5512: ELSIF( error_code = -3 )THEN
5513: cep_standard.debug(''Remote error: others'');
5514: FND_MESSAGE.set_name(''CE'', ''CE_FC_RMT_EXCEPTION'');
5515: error_msg := FND_MESSAGE.get;
5516: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,
5517: CE_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_EXCEPTION'', error_msg);
5518: return;
5519: END IF;

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

5529: clear_aging_buckets;
5530: IF DBMS_SQL.is_open(cursor_id) THEN
5531: DBMS_SQL.close_cursor(cursor_id);
5532: END IF;
5533: FND_MESSAGE.set_name('CE', 'CE_FC_RMT_DB_EXCEPTION');
5534: error_msg := FND_MESSAGE.get;
5535: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,
5536: CE_CASH_FCST.G_forecast_row_id, 'CE_FC_RMT_DB_EXCEPTION', error_msg);
5537: return;

Line 5534: error_msg := FND_MESSAGE.get;

5530: IF DBMS_SQL.is_open(cursor_id) THEN
5531: DBMS_SQL.close_cursor(cursor_id);
5532: END IF;
5533: FND_MESSAGE.set_name('CE', 'CE_FC_RMT_DB_EXCEPTION');
5534: error_msg := FND_MESSAGE.get;
5535: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,
5536: CE_CASH_FCST.G_forecast_row_id, 'CE_FC_RMT_DB_EXCEPTION', error_msg);
5537: return;
5538: END;

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

5543: EXCEPTION
5544: WHEN OTHERS THEN
5545: clear_aging_buckets;
5546: cep_standard.debug('EXCEPTION:Build_Remote_Query');
5547: FND_MESSAGE.set_name('CE', 'CE_FC_RMT_EXCEPTION');
5548: error_msg := FND_MESSAGE.get;
5549: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,
5550: CE_CASH_FCST.G_forecast_row_id, 'CE_FC_RMT_EXCEPTION', error_msg);
5551: END Build_Remote_Query;

Line 5548: error_msg := FND_MESSAGE.get;

5544: WHEN OTHERS THEN
5545: clear_aging_buckets;
5546: cep_standard.debug('EXCEPTION:Build_Remote_Query');
5547: FND_MESSAGE.set_name('CE', 'CE_FC_RMT_EXCEPTION');
5548: error_msg := FND_MESSAGE.get;
5549: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,
5550: CE_CASH_FCST.G_forecast_row_id, 'CE_FC_RMT_EXCEPTION', error_msg);
5551: END Build_Remote_Query;
5552:

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

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');
5633: error_msg := FND_MESSAGE.GET;
5634: CE_FORECAST_ERRORS_PKG.insert_row(
5635: CE_CASH_FCST.G_forecast_id,
5636: CE_CASH_FCST.G_rp_forecast_header_id,

Line 5633: error_msg := FND_MESSAGE.GET;

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');
5633: error_msg := FND_MESSAGE.GET;
5634: CE_FORECAST_ERRORS_PKG.insert_row(
5635: CE_CASH_FCST.G_forecast_id,
5636: CE_CASH_FCST.G_rp_forecast_header_id,
5637: CE_CASH_FCST.G_forecast_row_id,

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

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');
5653: error_msg := FND_MESSAGE.GET;
5654: CE_FORECAST_ERRORS_PKG.insert_row(
5655: CE_CASH_FCST.G_forecast_id,
5656: CE_CASH_FCST.G_rp_forecast_header_id,

Line 5653: error_msg := FND_MESSAGE.GET;

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');
5653: error_msg := FND_MESSAGE.GET;
5654: CE_FORECAST_ERRORS_PKG.insert_row(
5655: CE_CASH_FCST.G_forecast_id,
5656: CE_CASH_FCST.G_rp_forecast_header_id,
5657: CE_CASH_FCST.G_forecast_row_id,

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

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');
5673: error_msg := FND_MESSAGE.GET;
5674: CE_FORECAST_ERRORS_PKG.insert_row(
5675: CE_CASH_FCST.G_forecast_id,
5676: CE_CASH_FCST.G_rp_forecast_header_id,

Line 5673: error_msg := FND_MESSAGE.GET;

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');
5673: error_msg := FND_MESSAGE.GET;
5674: CE_FORECAST_ERRORS_PKG.insert_row(
5675: CE_CASH_FCST.G_forecast_id,
5676: CE_CASH_FCST.G_rp_forecast_header_id,
5677: CE_CASH_FCST.G_forecast_row_id,