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 842: l_do_cartonization number := NVL(FND_PROFILE.VALUE('WMS_ASSIGN_TASK_TYPE'),1); --added for Bug3237702

838: l_quantity2_delivered NUMBER;
839: l_backup_id NUMBER;
840: l_current_header_id NUMBER := NULL;
841: l_return_value BOOLEAN := TRUE;
842: l_do_cartonization number := NVL(FND_PROFILE.VALUE('WMS_ASSIGN_TASK_TYPE'),1); --added for Bug3237702
843:
844:
845: TYPE quantity_tree_tbl_type is TABLE OF NUMBER
846: INDEX BY BINARY_INTEGER;

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

1004: BEGIN
1005: -- because the debug profile rarely changes, only check it once per
1006: -- session, instead of once per batch
1007: IF is_debug IS NULL THEN
1008: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1009: if l_debug = 1 then
1010: is_debug := TRUE;
1011: else
1012: is_debug := FALSE;

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

3628: -- The return status of APIs called
3629: -- within this API.
3630: l_api_error_code NUMBER; -- The error code of APIs called within
3631: -- this API.
3632: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3633: BEGIN
3634: -- Set savepoint for this API
3635: SAVEPOINT Reserve_Unconfirmed_Qty_PUB;
3636:

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

3871:
3872: l_print_mode VARCHAR(1);
3873: l_debug NUMBER;
3874: l_api_return_status VARCHAR2(1);
3875: l_do_cartonization number := NVL(FND_PROFILE.VALUE('WMS_ASSIGN_TASK_TYPE'),1);
3876:
3877: BEGIN
3878: -- Set savepoint for this API
3879: SAVEPOINT PR_Call_cartonization;

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

3880:
3881: -- because the debug profile rarely changes, only check it once per
3882: -- session, instead of once per batch
3883: IF is_debug IS NULL THEN
3884: l_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3885: if l_debug = 1 then
3886: is_debug := TRUE;
3887: else
3888: is_debug := FALSE;

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

4075: -- The return status of APIs called
4076: -- within this API.
4077: l_api_error_code NUMBER; -- The error code of APIs called within
4078: -- this API.
4079: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4080: BEGIN
4081: -- Set savepoint for this API
4082: SAVEPOINT Reserve_Unconfirmed_Qty_PUB;
4083: