DBA Data[Home] [Help]

APPS.CZ_OM_ATP_CALLBACK dependencies on MFG_LOOKUPS

Line 612: -- table mfg_lookups.

608: || l_msg_count, fnd_log.LEVEL_PROCEDURE);
609:
610: -- For expected errors, ATP populates the error_code for each record in atp_rec_typ.
611: -- The error_code is defined by the lookup_type 'MTL_DEMAND_INTERFACE_ERRORS' in the
612: -- table mfg_lookups.
613: -- Display error messages in ATP notification window by selecting 'meaning' for the given error_codes
614: -- bug 2737013 fix: retrieve any possible error message even when the return status is success
615: IF l_return_status = FND_API.G_RET_STS_ERROR OR l_return_status = FND_API.G_RET_STS_SUCCESS THEN
616: l_error_msg_count := g_atp_rec.error_code.COUNT;

Line 633: FROM mfg_lookups

629: OR g_atp_rec.error_code(i) = 0 then
630: l_atp_rec.message(i) := NULL;
631: else
632: SELECT meaning INTO l_atp_rec.message(i)
633: FROM mfg_lookups
634: WHERE lookup_type = 'MTL_DEMAND_INTERFACE_ERRORS'
635: AND lookup_code = g_atp_rec.error_code(i);
636: end if;
637: cz_utils.log_report('cz_om_atp_callback', 'call_atp', l_ndebug,