349: WHERE gsb.set_of_books_id = G_set_of_books_id;
350:
351: IF (calendar <> G_rp_calendar_name) THEN
352: valid_period := FALSE;
353: FND_MESSAGE.set_name('CE', 'CE_FC_INVALID_PERIOD_SET_NAME');
354: FND_MESSAGE.set_token('SOB_NAME', sob_name);
355: error_msg := fnd_message.get;
356: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
357: xtr_debug_pkg.debug(error_msg);
350:
351: IF (calendar <> G_rp_calendar_name) THEN
352: valid_period := FALSE;
353: FND_MESSAGE.set_name('CE', 'CE_FC_INVALID_PERIOD_SET_NAME');
354: FND_MESSAGE.set_token('SOB_NAME', sob_name);
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;
351: IF (calendar <> G_rp_calendar_name) THEN
352: valid_period := FALSE;
353: FND_MESSAGE.set_name('CE', 'CE_FC_INVALID_PERIOD_SET_NAME');
354: FND_MESSAGE.set_token('SOB_NAME', sob_name);
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,
366: EXIT WHEN sob_c%NOTFOUND or sob_c%NOTFOUND IS NULL;
367:
368: IF (calendar <> G_rp_calendar_name) THEN
369: valid_period := FALSE;
370: FND_MESSAGE.set_name('CE', 'CE_FC_INVALID_PERIOD_SET_NAME');
371: FND_MESSAGE.set_token('SOB_NAME', sob_name);
372: error_msg := fnd_message.get;
373: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
374: xtr_debug_pkg.debug(error_msg);
367:
368: IF (calendar <> G_rp_calendar_name) THEN
369: valid_period := FALSE;
370: FND_MESSAGE.set_name('CE', 'CE_FC_INVALID_PERIOD_SET_NAME');
371: FND_MESSAGE.set_token('SOB_NAME', sob_name);
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;
368: IF (calendar <> G_rp_calendar_name) THEN
369: valid_period := FALSE;
370: FND_MESSAGE.set_name('CE', 'CE_FC_INVALID_PERIOD_SET_NAME');
371: FND_MESSAGE.set_token('SOB_NAME', sob_name);
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,