APPS.WMS_CAROUSEL_INTEGRATION_PKG dependencies on FND_PROFILE

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

53: x_status_code OUT NOCOPY VARCHAR2,
54: x_device_status OUT NOCOPY VARCHAR2
55: )
56: IS
57: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
58: BEGIN
59: -- Singing on or off ?
60: x_status_code := FND_API.G_RET_STS_SUCCESS;
61: IF p_sign_on_flag = 'Y'

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

78: --
79: PROCEDURE pipe_listener_loop (p_job IN NUMBER, p_zone IN VARCHAR2, p_device_id in NUMBER, p_pipe_name IN VARCHAR2)
80: IS
81: v_switch VARCHAR2 (16);
82: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
83: PRAGMA AUTONOMOUS_TRANSACTION;
84: BEGIN
85: LOOP
86: -- Get pipe listener switch value

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

125: job_str VARCHAR2 (1024);
126: v_pipename VARCHAR2(50);
127: l_primary_device NUMBER;
128: l_dummy NUMBER;
129: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
130: PRAGMA AUTONOMOUS_TRANSACTION;
131: BEGIN
132: v_pipename := wms_carousel_integration_pvt.get_config_parameter
133: (p_name => 'PIPE_NAME',

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

242: WHERE UPPER (what) LIKE '%WMS_CAROUSEL_INTEGRATION_PKG.PIPE_LISTENER_LOOP%')
243: where pipe_name = nvl(p_pipe_name, pipe_name);
244:
245: v_pipename VARCHAR2(50);
246: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
247: PRAGMA AUTONOMOUS_TRANSACTION;
248: BEGIN
249: IF (p_device_id IS NOT NULL) THEN
250: v_pipename :=

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

285: WHERE UPPER (what) LIKE '%WMS_CAROUSEL_INTEGRATION_PKG.PIPE_LISTENER_LOOP%')
286: where pipe_name = nvl(p_pipe_name, pipe_name);
287:
288: v_pipename VARCHAR2(50) := NULL;
289: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
290: PRAGMA AUTONOMOUS_TRANSACTION;
291: BEGIN
292: IF (p_device_id IS NOT NULL) THEN
293: v_pipename :=

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

326: SELECT job, what
327: FROM user_jobs
328: WHERE UPPER (what) LIKE '%WMS_CAROUSEL_INTEGRATION_PKG.PIPE_LISTENER_LOOP%';
329:
330: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
331: PRAGMA AUTONOMOUS_TRANSACTION;
332: BEGIN
333: -- Remove jobs
334: FOR v_job IN c_pipe_listeners

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

363: --
364: PROCEDURE START_PIPE_LISTENERS(p_device_id IN NUMBER DEFAULT NULL)
365: IS
366: v_pipename VARCHAR2(50);
367: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
368: PRAGMA AUTONOMOUS_TRANSACTION;
369: BEGIN
370: IF (p_device_id IS NULL) THEN
371: -- Switch on all listeners

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

401: --
402: PROCEDURE STOP_PIPE_LISTENERS(p_device_id IN NUMBER DEFAULT NULL)
403: IS
404: v_pipename VARCHAR2(50);
405: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
406: PRAGMA AUTONOMOUS_TRANSACTION;
407: BEGIN
408: IF (p_device_id IS NULL) THEN
409: -- Switch off all listeners

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

447: AND device_id = p_device_id
448: AND PERSON_ID = p_emp_id
449: AND status = 9;
450: l_dummy NUMBER;
451: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
452: PRAGMA AUTONOMOUS_TRANSACTION;
453: BEGIN
454: --wms_carousel_integration_pvt.LOG ( p_device_id, 'In SIGN_OFF_USER Org=' || p_organization_id || ',employee (' || p_emp_id || ') from device_id (' || p_device_id || ')');
455: x_return_status := 'S';