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 CE_FORECAST_ERRORS_PKG

Line 166: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id,CE_CASH_FCST.G_rp_forecast_header_id,

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:
170: IF( col_num = 0 AND days_to < min_col ) THEN

Line 1442: CE_FORECAST_ERRORS_PKG.insert_row(

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,
1446: 'CE_FC_NO_BANK_EXCH_RATE',

Line 1470: CE_FORECAST_ERRORS_PKG.insert_row(

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,
1474: 'CE_FC_PD_OD_OVERLAP',

Line 1569: CE_FORECAST_ERRORS_PKG.insert_row(

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,
1573: 'CE_FC_NO_BANK_BALANCE',

Line 1677: CE_FORECAST_ERRORS_PKG.insert_row(

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,
1681: 'CE_FC_NO_SUB_EXCH_RATE',

Line 1830: CE_FORECAST_ERRORS_PKG.insert_row(

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,
1834: 'CE_NO_HIST_START_PERIOD',

Line 2419: CE_FORECAST_ERRORS_PKG.insert_row(

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,
2423: 'CE_NO_HIST_START_PERIOD',

Line 2770: CE_FORECAST_ERRORS_PKG.insert_row(

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,
2774: 'CE_NO_HIST_START_PERIOD',

Line 3289: CE_FORECAST_ERRORS_PKG.insert_row(

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,
3293: 'CE_FC_POP_NO_END_DATE',

Line 3435: CE_FORECAST_ERRORS_PKG.insert_row(

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,
3439: 'CE_FC_POP_NO_END_DATE',

Line 3598: CE_FORECAST_ERRORS_PKG.insert_row(

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,
3602: 'CE_FC_POP_NO_END_DATE',

Line 3741: CE_FORECAST_ERRORS_PKG.insert_row(

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,
3745: 'CE_FC_POP_NO_END_DATE',

Line 3997: CE_FORECAST_ERRORS_PKG.insert_row(

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,
4001: 'CE_FC_POR_NO_END_DATE',

Line 4121: CE_FORECAST_ERRORS_PKG.insert_row(

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,
4125: 'CE_FC_POR_NO_END_DATE',

Line 5211: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,

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;
5215:

Line 5351: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,

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
5355: cep_standard.debug(''Remote error: invalid view'');

Line 5358: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,

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
5362: cep_standard.debug(''Remote error: others'');

Line 5365: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,

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;
5369: end; ';

Line 5384: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,

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;
5388:

Line 5398: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id, CE_CASH_FCST.G_rp_forecast_header_id,

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:
5402:

Line 5466: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id,

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);
5470: END IF;

Line 5480: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id,

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);
5484: END IF;

Line 5494: CE_FORECAST_ERRORS_PKG.insert_row(CE_CASH_FCST.G_forecast_id,

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);
5498: END IF;