DBA Data[Home] [Help]

APPS.CE_CSH_FCST_POP dependencies on CE_FORECAST_ERRORS_PKG

Line 175: CE_FORECAST_ERRORS_PKG.insert_row(

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',
179: error_msg);

Line 1511: CE_FORECAST_ERRORS_PKG.insert_row(

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

Line 1539: CE_FORECAST_ERRORS_PKG.insert_row(

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

Line 1638: CE_FORECAST_ERRORS_PKG.insert_row(

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

Line 1746: CE_FORECAST_ERRORS_PKG.insert_row(

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

Line 1899: CE_FORECAST_ERRORS_PKG.insert_row(

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

Line 2495: CE_FORECAST_ERRORS_PKG.insert_row(

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

Line 2846: CE_FORECAST_ERRORS_PKG.insert_row(

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

Line 3365: CE_FORECAST_ERRORS_PKG.insert_row(

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

Line 3511: CE_FORECAST_ERRORS_PKG.insert_row(

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

Line 3674: CE_FORECAST_ERRORS_PKG.insert_row(

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

Line 3817: CE_FORECAST_ERRORS_PKG.insert_row(

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

Line 4073: CE_FORECAST_ERRORS_PKG.insert_row(

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

Line 4197: CE_FORECAST_ERRORS_PKG.insert_row(

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 5634: CE_FORECAST_ERRORS_PKG.insert_row(

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,
5638: 'CE_FC_NO_PROJECT_RANGE',

Line 5654: CE_FORECAST_ERRORS_PKG.insert_row(

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,
5658: 'CE_FC_NO_PROJECT_RANGE',

Line 5674: CE_FORECAST_ERRORS_PKG.insert_row(

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,
5678: 'CE_FC_NO_PROJECT_RANGE',