339: -- Get the profile option of the distance stuff to
340: -- see what region level we should be searching for
341: --
342: IF l_debug_on THEN
343: WSH_DEBUG_SV.logmsg(l_module_name,'getting the distance profile valie fnd_profile.get(FTE_DISTANCE_LVL)');
344: END IF;
345:
346: fnd_profile.get('FTE_DISTANCE_LVL',l_distance_profile);
347:
342: IF l_debug_on THEN
343: WSH_DEBUG_SV.logmsg(l_module_name,'getting the distance profile valie fnd_profile.get(FTE_DISTANCE_LVL)');
344: END IF;
345:
346: fnd_profile.get('FTE_DISTANCE_LVL',l_distance_profile);
347:
348: IF l_debug_on THEN
349: WSH_DEBUG_SV.log(l_module_name,'fnd_profile.get(FTE_DISTANCE_LVL)= ',l_distance_profile);
350: END IF;
345:
346: fnd_profile.get('FTE_DISTANCE_LVL',l_distance_profile);
347:
348: IF l_debug_on THEN
349: WSH_DEBUG_SV.log(l_module_name,'fnd_profile.get(FTE_DISTANCE_LVL)= ',l_distance_profile);
350: END IF;
351:
352: IF (l_distance_profile is null) THEN
353: --