APPS.XTR_CSH_FCST_POP dependencies on CE_FORECAST_ERRORS_PKG

Line 744: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id,

740: EXCEPTION
741: WHEN OTHERS THEN
742: FND_MESSAGE.set_name('GL', 'GL_JE_INVALID_CONVERSION_INFO');
743: error_msg := fnd_message.get;
744: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id,
745: XTR_CASH_FCST.G_rp_forecast_header_id, XTR_CASH_FCST.G_forecast_row_id,
746: 'GL_JE_INVALID_CONVERSION_INFO', error_msg);
747: END;
748: END IF;

Line 849: CE_FORECAST_ERRORS_PKG.insert_row(

845: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
846:
847: FND_MESSAGE.set_name('CE', 'CE_NO_HIST_START_PERIOD');
848: error_msg := FND_MESSAGE.get;
849: CE_FORECAST_ERRORS_PKG.insert_row(
850: CE_CASH_FCST.G_forecast_id,
851: CE_CASH_FCST.G_rp_forecast_header_id,
852: CE_CASH_FCST.G_forecast_row_id,
853: 'CE_NO_HIST_START_PERIOD',

Line 1108: CE_FORECAST_ERRORS_PKG.insert_row(

1104: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
1105:
1106: FND_MESSAGE.set_name('CE', 'CE_NO_HIST_START_PERIOD');
1107: error_msg := FND_MESSAGE.get;
1108: CE_FORECAST_ERRORS_PKG.insert_row(
1109: CE_CASH_FCST.G_forecast_id,
1110: CE_CASH_FCST.G_rp_forecast_header_id,
1111: CE_CASH_FCST.G_forecast_row_id,
1112: 'CE_NO_HIST_START_PERIOD',

Line 1220: CE_FORECAST_ERRORS_PKG.insert_row(

1216: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;
1217:
1218: FND_MESSAGE.set_name('CE', 'CE_NO_HIST_START_PERIOD');
1219: error_msg := FND_MESSAGE.get;
1220: CE_FORECAST_ERRORS_PKG.insert_row(
1221: CE_CASH_FCST.G_forecast_id,
1222: CE_CASH_FCST.G_rp_forecast_header_id,
1223: CE_CASH_FCST.G_forecast_row_id,
1224: 'CE_NO_HIST_START_PERIOD',

Line 1490: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,

1486: END IF;
1487: FND_MESSAGE.set_name('CE','CE_FC_EXT_SOURCE_UNDEFINED');
1488: FND_MESSAGE.set_token('EXT_TYPE', XTR_CASH_FCST.G_external_source_type);
1489: error_msg := FND_MESSAGE.get;
1490: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,
1491: XTR_CASH_FCST.G_forecast_row_id, 'CE_FC_EXT_SOURCE_UNDEFINED', error_msg);
1492: RETURN;
1493: END;
1494:

Line 1557: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,

1553: xtr_debug_pkg.debug(''Remote error: missing view'');
1554: END IF;
1555: FND_MESSAGE.set_name(''CE'', ''CE_FC_RMT_MISSING_VIEW_EXPT'');
1556: error_msg := FND_MESSAGE.get;
1557: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,
1558: XTR_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_MISSING_VIEW_EXPT'', error_msg);
1559: return;
1560: ELSIF( error_code = -2 )THEN
1561: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 1566: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,

1562: xtr_debug_pkg.debug(''Remote error: invalid view'');
1563: END IF;
1564: FND_MESSAGE.set_name(''CE'', ''CE_FC_RMT_INVALID_VIEW_EXPT'');
1565: error_msg := FND_MESSAGE.get;
1566: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,
1567: XTR_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_INVALID_VIEW_EXPT'', error_msg);
1568: return;
1569: ELSE
1570: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 1575: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,

1571: xtr_debug_pkg.debug(''Remote error: others'');
1572: END IF;
1573: FND_MESSAGE.set_name(''CE'', ''CE_FC_RMT_EXCEPTION'');
1574: error_msg := FND_MESSAGE.get;
1575: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,
1576: XTR_CASH_FCST.G_forecast_row_id, ''CE_FC_RMT_EXCEPTION'', error_msg);
1577: return;
1578: END IF;
1579: end; ';

Line 1592: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,

1588: DBMS_SQL.close_cursor(cursor_id);
1589: END IF;
1590: FND_MESSAGE.set_name('CE', 'CE_FC_RMT_DB_EXCEPTION');
1591: error_msg := FND_MESSAGE.get;
1592: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,
1593: XTR_CASH_FCST.G_forecast_row_id, 'CE_FC_RMT_DB_EXCEPTION', error_msg);
1594: return;
1595: END;
1596: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 1606: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,

1602: xtr_debug_pkg.debug('EXCEPTION:Build_Remote_Query');
1603: END IF;
1604: FND_MESSAGE.set_name('CE', 'CE_FC_RMT_EXCEPTION');
1605: error_msg := FND_MESSAGE.get;
1606: CE_FORECAST_ERRORS_PKG.insert_row(XTR_CASH_FCST.G_forecast_id, XTR_CASH_FCST.G_rp_forecast_header_id,
1607: XTR_CASH_FCST.G_forecast_row_id, 'CE_FC_RMT_EXCEPTION', error_msg);
1608: END Build_Remote_Query;
1609:
1610: /* ---------------------------------------------------------------------