8:
9: PROCEDURE print_debug(p_err_msg VARCHAR2,
10: p_level NUMBER DEFAULT 4)
11: IS
12: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
13: BEGIN
14:
15: IF (l_debug = 1) THEN
16: inv_mobile_helper_functions.tracelog
1354: l_api_name CONSTANT VARCHAR2(30) := 'matching_logic';
1355:
1356: l_progress VARCHAR2(5) := '10';
1357:
1358: l_print_debug NUMBER := nvl(fnd_profile.value('INV_DEBUG_TRACE'), 2);
1359:
1360: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1361:
1362: --New variables for FP-J Lot/Serial Support
1356: l_progress VARCHAR2(5) := '10';
1357:
1358: l_print_debug NUMBER := nvl(fnd_profile.value('INV_DEBUG_TRACE'), 2);
1359:
1360: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1361:
1362: --New variables for FP-J Lot/Serial Support
1363: l_lot_number_to_match mtl_lot_numbers.lot_number%TYPE;
1364: l_lpn_id_to_match NUMBER;
1387: x_return_status := fnd_api.g_ret_sts_success;
1388:
1389: SAVEPOINT rcv_transactions_sa;
1390:
1391: l_allow_routing_override := fnd_profile.value('OVERRIDE_ROUTING');
1392: IF l_allow_routing_override IS NULL THEN
1393: l_allow_routing_override := 'N';
1394: end IF;
1395: