176: WHERE user_id = p_user_id;
177:
178: SELECT NVL(fnd_profile.value('INV_DEBUG_TRACE'),'2')
179: INTO l_inv_debug
180: FROM dual;
181:
182: IF l_inv_debug = 1 THEN
183: G_TRACE_ON := TRUE;
184: ELSE
637: --
638: BEGIN
639: SELECT NVL(fnd_profile.value('PO_VMI_ENABLED'),'N')
640: INTO l_vmi_enabled
641: FROM dual;
642:
643: EXCEPTION
644: WHEN OTHERS THEN
645: l_vmi_enabled := 'N';