APPS.MTH_PROCESS_STATUS_PKG dependencies on MTH_PROCESS_TXN_PKG

Line 167: WHEN MTH_PROCESS_TXN_PKG.VALIDATION_ERR THEN

163: p_recal_to_date,
164: p_equipment_pk_key,
165: p_plant_pk_key );
166: EXCEPTION
167: WHEN MTH_PROCESS_TXN_PKG.VALIDATION_ERR THEN
168: l_ret_code := 1;
169: mth_util_pkg.log_msg('Exception VALIDATION_ERR in PROCESS_STATUS', mth_util_pkg.G_DBG_EXCEPTION);
170: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
171: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);

Line 180: WHEN MTH_PROCESS_TXN_PKG.VALIDATION_ERR THEN

176: p_ret_code := l_ret_code;
177: mth_util_pkg.log_msg('PROCESS_STATUS end', mth_util_pkg.G_DBG_PROC_FUN_END);
178:
179: EXCEPTION
180: WHEN MTH_PROCESS_TXN_PKG.VALIDATION_ERR THEN
181: l_ret_code := 1;
182: p_ret_code := l_ret_code;
183: mth_util_pkg.log_msg('Exception VALIDATION_ERR in PROCESS_STATUS', mth_util_pkg.G_DBG_EXCEPTION);
184: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);

Line 3069: RAISE MTH_PROCESS_TXN_PKG.VALIDATION_ERR;

3065: fnd_date.date_to_canonical(l_err_rows(i).to_date)||','||l_err_rows(i).status||','||l_err_rows(i).user_dim1_fk||','||
3066: l_err_rows(i).user_dim2_fk||','||l_err_rows(i).user_dim3_fk||','||l_err_rows(i).user_dim4_fk||','||
3067: l_err_rows(i).user_dim5_fk||','||l_err_rows(i).downtime_reason_code||','||l_err_rows(i).err_code,mth_util_pkg.G_DBG_USER_ERROR);
3068: END LOOP;
3069: RAISE MTH_PROCESS_TXN_PKG.VALIDATION_ERR;
3070: END IF;
3071:
3072: --Insert records into mth_equip_statuses table
3073: INSERT INTO mth_equip_statuses( equipment_fk_key,

Line 3305: WHEN MTH_PROCESS_TXN_PKG.VALIDATION_ERR THEN

3301: mth_util_pkg.log_msg('Exception GAP_IN_RECAL_CSV in RECAL_STATUS_FROM_CSV', mth_util_pkg.G_DBG_EXCEPTION);
3302: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
3303: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);
3304: RAISE;
3305: WHEN MTH_PROCESS_TXN_PKG.VALIDATION_ERR THEN
3306: --Call logging API and then throw exception
3307: mth_util_pkg.log_msg('Exception VALIDATION_ERR in RECAL_STATUS_FROM_CSV', mth_util_pkg.G_DBG_EXCEPTION);
3308: mth_util_pkg.log_msg(substr(sqlerrm,1,300), mth_util_pkg.G_DBG_EXCEPTION);
3309: mth_util_pkg.log_msg(sqlcode, mth_util_pkg.G_DBG_EXCEPTION);