49: l_wms_installed VARCHAR2(10);
50: l_lot_exp_date DATE;
51: l_serial_prefix VARCHAR2(30);
52:
53: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
54: BEGIN
55: IF (fnd_profile.defined('TRANSACTION_DATE')) THEN
56: v_profile_value := TO_NUMBER(fnd_profile.value('TRANSACTION_DATE'));
57:
51: l_serial_prefix VARCHAR2(30);
52:
53: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
54: BEGIN
55: IF (fnd_profile.defined('TRANSACTION_DATE')) THEN
56: v_profile_value := TO_NUMBER(fnd_profile.value('TRANSACTION_DATE'));
57:
58: -- Profile value of:
59: -- 1 = Any open period
52:
53: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
54: BEGIN
55: IF (fnd_profile.defined('TRANSACTION_DATE')) THEN
56: v_profile_value := TO_NUMBER(fnd_profile.value('TRANSACTION_DATE'));
57:
58: -- Profile value of:
59: -- 1 = Any open period
60: -- 2 = No past date