DBA Data[Home] [Help]

APPS.MTH_PROCESS_OUTPUT_PKG dependencies on MTH_PROCESS_TXN_PKG

Line 176: WHEN MTH_PROCESS_TXN_PKG.VALIDATION_ERR THEN

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);

Line 2139: RAISE MTH_PROCESS_TXN_PKG.VALIDATION_ERR;

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

Line 2316: WHEN MTH_PROCESS_TXN_PKG.VALIDATION_ERR THEN

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);