DBA Data[Home] [Help]

APPS.XTR_CSH_FCST_POP dependencies on FND_MESSAGE

Line 742: FND_MESSAGE.set_name('GL', 'GL_JE_INVALID_CONVERSION_INFO');

738:
739: currency := 'EUR';
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);

Line 743: error_msg := fnd_message.get;

739: currency := 'EUR';
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;

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

843: UPDATE ce_forecasts
844: SET error_status = 'E'
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,

Line 848: error_msg := FND_MESSAGE.get;

844: SET error_status = 'E'
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,

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

1102: UPDATE ce_forecasts
1103: SET error_status = 'E'
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,

Line 1107: error_msg := FND_MESSAGE.get;

1103: SET error_status = 'E'
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,

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

1214: UPDATE ce_forecasts
1215: SET error_status = 'E'
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,

Line 1219: error_msg := FND_MESSAGE.get;

1215: SET error_status = 'E'
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,

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

1483: WHEN NO_DATA_FOUND THEN
1484: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1485: xtr_debug_pkg.debug('EXCEPTION:Build_Remote_Query - View def not found');
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);

Line 1488: FND_MESSAGE.set_token('EXT_TYPE', XTR_CASH_FCST.G_external_source_type);

1484: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1485: xtr_debug_pkg.debug('EXCEPTION:Build_Remote_Query - View def not found');
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;

Line 1489: error_msg := FND_MESSAGE.get;

1485: xtr_debug_pkg.debug('EXCEPTION:Build_Remote_Query - View def not found');
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;

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

1551: ELSIF( error_code = -1 )THEN
1552: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
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;

Line 1556: error_msg := FND_MESSAGE.get;

1552: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
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

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

1560: ELSIF( error_code = -2 )THEN
1561: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
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;

Line 1565: error_msg := FND_MESSAGE.get;

1561: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
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

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

1569: ELSE
1570: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
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;

Line 1574: error_msg := FND_MESSAGE.get;

1570: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
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;

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

1586: WHEN OTHERS THEN
1587: IF DBMS_SQL.is_open(cursor_id) THEN
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;

Line 1591: error_msg := FND_MESSAGE.get;

1587: IF DBMS_SQL.is_open(cursor_id) THEN
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;

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

1600: WHEN OTHERS THEN
1601: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
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;

Line 1605: error_msg := FND_MESSAGE.get;

1601: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
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: