172: p_recal_to_date,
173: p_equipment_pk_key,
174: p_plant_pk_key );
175: EXCEPTION
176: WHEN MTH_PROCESS_TXN_PKG.VALIDATION_ERR THEN
177: l_ret_code := 1;
178: mth_util_pkg.log_msg('Exception VALIDATION_ERR in PROCESS_OUTPUT', mth_util_pkg.G_DBG_EXCEPTION);
179: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
180: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
2135: l_err_rows(i).segment_fk||','||l_err_rows(i).user_dim1_fk||','||l_err_rows(i).user_dim2_fk||','||l_err_rows(i).user_dim3_fk||','||
2136: l_err_rows(i).user_dim4_fk||','||l_err_rows(i).user_dim5_fk||','||l_err_rows(i).scrap_reason_code||','||l_err_rows(i).err_code
2137: ,mth_util_pkg.G_DBG_USER_ERROR);
2138: END LOOP;
2139: RAISE MTH_PROCESS_TXN_PKG.VALIDATION_ERR;
2140: END IF;
2141:
2142:
2143: --Insert records into mth_equip_output
2312: mth_util_pkg.log_msg('Exception GAP_IN_RECAL_CSV in RECAL_OUTPUT_FROM_CSV', mth_util_pkg.G_DBG_EXCEPTION);
2313: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
2314: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
2315: RAISE;
2316: WHEN MTH_PROCESS_TXN_PKG.VALIDATION_ERR THEN
2317: --Call logging API and then throw exception
2318: mth_util_pkg.log_msg('Exception VALIDATION_ERR in RECAL_OUTPUT_FROM_CSV', mth_util_pkg.G_DBG_EXCEPTION);
2319: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
2320: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);