72: WHERE mrl.fact_table = 'MTH_EQUIP_STATUS_SUMMARY'
73: AND meo.last_update_date > mrl.from_date;
74:
75: IF v_output_count > 0 THEN
76: v_msg:=fnd_message.get_string('MTH','MTH_STATUS_NOT_IN_SUMMARY');
77:
78: mth_util_pkg.log_msg(v_msg,mth_util_pkg.G_DBG_EXCEPTION);
79: v_retcode := 2;
80: END IF;
92: IF v_compile_state.Count > 0
93: THEN
94: FOR i IN v_compile_state.FIRST .. v_compile_state.LAST
95: LOOP
96: FND_MESSAGE.SET_TOKEN('MOC_MV_TOKEN',v_compile_state(i));
97: v_msg:=fnd_message.get_string('MTH','MTH_MV_NOT_REFRESHED');
98:
99: mth_util_pkg.log_msg(v_msg,mth_util_pkg.G_DBG_EXCEPTION);
100: v_retcode := 2;
93: THEN
94: FOR i IN v_compile_state.FIRST .. v_compile_state.LAST
95: LOOP
96: FND_MESSAGE.SET_TOKEN('MOC_MV_TOKEN',v_compile_state(i));
97: v_msg:=fnd_message.get_string('MTH','MTH_MV_NOT_REFRESHED');
98:
99: mth_util_pkg.log_msg(v_msg,mth_util_pkg.G_DBG_EXCEPTION);
100: v_retcode := 2;
101: END LOOP;
2427: END IF;
2428:
2429: IF l_count < 1
2430: THEN
2431: v_msg:=fnd_message.get_string('MTH','MTH_SITE_MIS_ERR');
2432: mth_util_pkg.log_msg(v_msg,mth_util_pkg.G_DBG_USER_ERROR);
2433: RAISE SITE_MIS_ERR;
2434: END IF;
2435:
2445: END IF;
2446:
2447: IF l_count < 1
2448: THEN
2449: v_msg:=fnd_message.get_string('MTH','MTH_EQUIP_MIS_ERR');
2450: mth_util_pkg.log_msg(v_msg,mth_util_pkg.G_DBG_USER_ERROR);
2451: RAISE EQUIP_MIS_ERR;
2452: END IF;
2453:
2466: WHERE equipment_pk_key = p_equipment_pk_key),stg.equipment_fk);
2467:
2468: IF(p_min_from_date_csv > p_recal_from_date OR p_max_to_date_csv < p_recal_to_date)
2469: THEN
2470: v_msg:=fnd_message.get_string('MTH','MTH_GAP_IN_RECAL_CSV');
2471: mth_util_pkg.log_msg(v_msg,mth_util_pkg.G_DBG_USER_ERROR);
2472: RAISE GAP_IN_RECAL_CSV;
2473: END IF;
2474: