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.XTR_CSH_FCST_POP dependencies on CE_CASH_FCST

Line 845: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;

841: xtr_debug_pkg.debug('row_id = ' || to_char(XTR_CASH_FCST.G_forecast_row_id));
842: END IF;
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(

Line 850: 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',
854: error_msg);

Line 851: CE_CASH_FCST.G_rp_forecast_header_id,

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',
854: error_msg);
855: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 852: CE_CASH_FCST.G_forecast_row_id,

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',
854: error_msg);
855: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
856: xtr_debug_pkg.debug('EXCEPTION: No history data found for APP');

Line 1104: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;

1100: END IF;
1101:
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(

Line 1109: 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',
1113: error_msg);

Line 1110: CE_CASH_FCST.G_rp_forecast_header_id,

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',
1113: error_msg);
1114: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 1111: CE_CASH_FCST.G_forecast_row_id,

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',
1113: error_msg);
1114: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1115: xtr_debug_pkg.debug('EXCEPTION: No history data found for ARR');

Line 1216: WHERE forecast_id = CE_CASH_FCST.G_forecast_id;

1212: xtr_debug_pkg.debug('row_id = ' || to_char(XTR_CASH_FCST.G_forecast_row_id));
1213: END IF;
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(

Line 1221: 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',
1225: error_msg);

Line 1222: CE_CASH_FCST.G_rp_forecast_header_id,

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',
1225: error_msg);
1226: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

Line 1223: CE_CASH_FCST.G_forecast_row_id,

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',
1225: error_msg);
1226: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
1227: xtr_debug_pkg.debug('EXCEPTION: No Payroll historical data found');