174: INTO G_USER_NAME
175: FROM fnd_user
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
635: --
636: -- Determine if we need to account for VMI
637: --
638: BEGIN
639: SELECT NVL(fnd_profile.value('PO_VMI_ENABLED'),'N')
640: INTO l_vmi_enabled
641: FROM dual;
642:
643: EXCEPTION
2200: END if;
2201:
2202: IF l_fix_mult > 0
2203: THEN
2204: round_reord_qty := NVL(FND_PROFILE.VALUE('INV_ROUND_REORDER_QTY'), 'Y');
2205: print_debug('round_reord_qty: ' || round_reord_qty, 'get_reord_qty', 9);
2206:
2207: IF round_reord_qty = 'N'
2208: THEN