APPS.INV_PICK_RELEASE_PUB dependencies on FND_PROFILE

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

368: SELECT wct.transaction_temp_id
369: FROM wms_cartonization_temp wct
370: WHERE wct.parent_line_id = wct.transaction_temp_id; -- only parent lines
371:
372: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
373:
374: BEGIN
375: IF (l_debug = 1) THEN
376: print_debug('get pick slip number for move order header '||p_move_order_header_id,

Line 831: l_do_cartonization number := NVL(FND_PROFILE.VALUE('WMS_ASSIGN_TASK_TYPE'),1); --added for Bug3237702

827: l_quantity2_delivered NUMBER;
828: l_backup_id NUMBER;
829: l_current_header_id NUMBER := NULL;
830: l_return_value BOOLEAN := TRUE;
831: l_do_cartonization number := NVL(FND_PROFILE.VALUE('WMS_ASSIGN_TASK_TYPE'),1); --added for Bug3237702
832:
833:
834: TYPE quantity_tree_tbl_type is TABLE OF NUMBER
835: INDEX BY BINARY_INTEGER;

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

959: BEGIN
960: -- because the debug profile rarely changes, only check it once per
961: -- session, instead of once per batch
962: IF is_debug IS NULL THEN
963: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
964: if l_debug = 1 then
965: is_debug := TRUE;
966: else
967: is_debug := FALSE;

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

3460: -- The return status of APIs called
3461: -- within this API.
3462: l_api_error_code NUMBER; -- The error code of APIs called within
3463: -- this API.
3464: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3465: BEGIN
3466: -- Set savepoint for this API
3467: SAVEPOINT Reserve_Unconfirmed_Qty_PUB;
3468:

Line 3707: l_do_cartonization number := NVL(FND_PROFILE.VALUE('WMS_ASSIGN_TASK_TYPE'),1);

3703:
3704: l_print_mode VARCHAR(1);
3705: l_debug NUMBER;
3706: l_api_return_status VARCHAR2(1);
3707: l_do_cartonization number := NVL(FND_PROFILE.VALUE('WMS_ASSIGN_TASK_TYPE'),1);
3708:
3709: BEGIN
3710: -- Set savepoint for this API
3711: SAVEPOINT PR_Call_cartonization;

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

3712:
3713: -- because the debug profile rarely changes, only check it once per
3714: -- session, instead of once per batch
3715: IF is_debug IS NULL THEN
3716: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3717: if l_debug = 1 then
3718: is_debug := TRUE;
3719: else
3720: is_debug := FALSE;