Line 644: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
640: ) RETURN NUMBER IS
641: x_serial_tag NUMBER := 1;
642: l_hash_value NUMBER;
643: l_txn_type NUMBER; 644: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0); 645: BEGIN
646: IF p_transaction_type_id = 43 THEN
647: l_txn_type := 35;
648: ELSIF p_transaction_type_id = 94 THEN