APPS.INV_PICK_RELEASE_PVT dependencies on FND_PROFILE

Line 48: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

44: l_debug NUMBER;
45:
46: BEGIN
47: IF is_debug IS NULL THEN
48: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
49: If l_debug = 1 Then
50: is_debug := TRUE;
51: Else
52: is_debug := FALSE;

Line 63: g_use_backorder_cache := NVL(FND_PROFILE.VALUE('INV_BACKORDER_CACHE'),2);

59:
60: -- Check whether backorder caching is turned off
61: -- Bug 6997809, the profile value when No is 2, so changing 0 to 2.
62: IF g_use_backorder_cache IS NULL THEN
63: g_use_backorder_cache := NVL(FND_PROFILE.VALUE('INV_BACKORDER_CACHE'),2);
64: END IF;
65:
66: -- Bug 6997809, the profile value when No is 2, so changing 0 to 2.
67: IF g_use_backorder_cache = 2 THEN

Line 168: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

164:
165: BEGIN
166:
167: IF is_debug IS NULL THEN
168: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
169: If l_debug = 1 Then
170: is_debug := TRUE;
171: Else
172: is_debug := FALSE;

Line 197: AND NVL(fnd_profile.VALUE('WSH_OVERPICK_ENABLED'), 'N') = 'Y') THEN

193: x_max_tolerance := 0;
194: x_min_tolerance := 0;
195:
196: ELSIF (l_move_order_type = inv_globals.g_move_order_pick_wave
197: AND NVL(fnd_profile.VALUE('WSH_OVERPICK_ENABLED'), 'N') = 'Y') THEN
198:
199: OPEN c_detail_info;
200: FETCH c_detail_info INTO l_detail_info;
201: --l_found_flag := c_detail_info%FOUND;

Line 299: g_honor_pick_from := NVL(FND_PROFILE.VALUE('WSH_HONOR_PICK_FROM'),'N');

295: -- To avoid the problem of excess reservations, the lines for which the
296: -- from sub on the reservation does not match will not be passed from
297: -- shipping. See 4529693 for further details
298: IF g_honor_pick_from IS NULL THEN
299: g_honor_pick_from := NVL(FND_PROFILE.VALUE('WSH_HONOR_PICK_FROM'),'N');
300: END IF;
301: l_mo_from_sub := p_mo_line_rec.from_subinventory_code;
302: IF l_mo_from_sub IS NOT NULL THEN
303: IF l_mo_from_sub <> nvl(p_res_rec.subinventory_code,l_mo_from_sub) THEN

Line 1693: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1689: l_return_value BOOLEAN;
1690: l_to_subinventory VARCHAR2(10);
1691: BEGIN
1692: IF is_debug IS NULL THEN
1693: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1694: If l_debug = 1 Then
1695: is_debug := TRUE;
1696: Else
1697: is_debug := FALSE;

Line 2073: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2069:
2070:
2071: BEGIN
2072: IF is_debug IS NULL THEN
2073: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2074: If l_debug = 1 Then
2075: is_debug := TRUE;
2076: Else
2077: is_debug := FALSE;