APPS.WMS_TASK_DISPATCH_DEVICE dependencies on FND_PROFILE

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

11: PROCEDURE mydebug(msg in varchar2)
12: IS
13: l_msg VARCHAR2(5100);
14: l_ts VARCHAR2(30);
15: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
16: BEGIN
17: -- select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual;
18: -- l_msg:=l_ts||' '||msg;
19:

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

37: p_org_id IN NUMBER,
38: x_return_status OUT NOCOPY VARCHAR2) IS
39: l_assign_temp_id number;
40: l_device_status VARCHAR2(400);
41: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
42: l_wcs_enabled VARCHAR2(1);
43: BEGIN
44: x_return_status := FND_API.G_RET_STS_SUCCESS;
45:

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

133: SELECT device_id
134: FROM wms_device_assignment_temp
135: WHERE Employee_Id=p_employee_id
136: AND organization_id=p_org_id;
137: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
138: l_wcs_enabled VARCHAR2(1);
139: BEGIN
140:
141: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

246: FROM wms_device_assignment_temp
247: WHERE Employee_Id=p_employee_id
248: AND organization_id=p_org_id
249: AND device_id = p_device_id;
250: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
251: l_wcs_enabled VARCHAR2(1);
252: BEGIN
253:
254: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

348: x_subinventory OUT NOCOPY VARCHAR2,
349: p_emp_id IN NUMBER,
350: x_signed_onto_wrk_stn OUT NOCOPY VARCHAR2)
351: IS
352: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
353: l_is_device_signed NUMBER := 0;
354: l_device_type_id NUMBER := -1;
355: l_signed_onto_wrk_stn NUMBER;
356: using_asrs_without_wrk_stn EXCEPTION;

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

477: , p_locator_id IN NUMBER
478: ) return NUMBER
479: IS
480: l_device_id NUMBER;
481: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
482: BEGIN
483: SELECT device_id
484: INTO l_device_id
485: FROM (