[Home] [Help]
355: error_msg := fnd_message.get;
356: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
357: xtr_debug_pkg.debug(error_msg);
358: END IF;
359: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, G_forecast_row_id,
360: 'CE_FC_INVALID_PERIOD', error_msg);
361: END IF;
362: ELSE
363: open sob_c;
372: error_msg := fnd_message.get;
373: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
374: xtr_debug_pkg.debug(error_msg);
375: END IF;
376: CE_FORECAST_ERRORS_PKG.insert_row(G_forecast_id,G_rp_forecast_header_id, G_forecast_row_id,
377: 'CE_FC_INVALID_PERIOD', error_msg);
378: END IF;
379: END LOOP;
380: END IF;
528: /* AW 1378198
529: DELETE FROM ce_forecasts
530: WHERE forecast_header_id = G_rp_forecast_header_id;
531:
532: DELETE FROM ce_forecast_errors
533: WHERE forecast_header_id = G_rp_forecast_header_id;
534: */
535:
536: INSERT INTO ce_forecasts(
802: IF SQL%FOUND THEN
803: COMMIT;
804: END IF;
805:
806: DELETE FROM ce_forecast_errors
807: WHERE forecast_header_id = G_rp_forecast_header_id;
808: IF SQL%FOUND THEN
809: COMMIT;
810: END IF;