APPS.WMS_UNLOAD_UTILS_PVT dependencies on FND_PROFILE

Line 118: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

114: SELECT serial_transaction_temp_id
115: FROM mtl_transaction_lots_temp
116: WHERE transaction_temp_id = p_temp_id;
117:
118: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
119:
120: BEGIN
121: IF (l_debug = 1) THEN
122: mydebug(' in unload_task ');

Line 935: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

931: )
932: ORDER BY dummy_sort;
933:
934:
935: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
936: l_parent_deleted BOOLEAN := FALSE;
937: l_dum_sort NUMBER;
938: -- Added for 14699845 (Flexible Lot Allocation)
939: l_allocate_lot_flag VARCHAR2(1);

Line 1469: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

1465: , p_org_id IN NUMBER
1466: , p_is_bulk_task IN VARCHAR2 DEFAULT 'N'
1467: ) IS
1468:
1469: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1470: BEGIN
1471: IF ( l_debug = 1 ) THEN
1472: mydebug('FlexibleLotAlloc: In clean_LS_Flexible_unload');
1473: mydebug('FlexibleLotAlloc: Cleaning up the Lots if Lot Allocation is turned OFF');

Line 1515: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

1511: , p_org_id IN NUMBER
1512: , p_temp_id IN NUMBER)
1513: IS
1514: l_reserved_lot VARCHAR2(80);
1515: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1516: BEGIN
1517: x_return_status := fnd_api.g_ret_sts_success;
1518: BEGIN
1519: