eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_CAROUSEL_INTEGRATION_PKG dependencies on WMS_CAROUSEL_INTEGRATION_PVT

Line 18: wms_carousel_integration_pvt.verify_access

14: -- Verify access
15: x_status_code := 'S';
16:
17: /* we can not really verify access here because we do not know employee_id
18: wms_carousel_integration_pvt.verify_access
19: (
20: p_device_id,
21: p_employee_id,
22: x_status_code,

Line 30: wms_carousel_integration_pvt.process_request (p_request_id,

26: -- Allowed ?
27: IF x_status_code = 'S'
28: THEN
29: -- Process the request
30: wms_carousel_integration_pvt.process_request (p_request_id,
31: x_status_code,
32: x_status_msg,
33: x_device_status
34: );

Line 64: wms_carousel_integration_pvt.LOG (p_device_id, 'Employee (' || p_employee_id || ') logged on');

60: x_status_code := FND_API.G_RET_STS_SUCCESS;
61: IF p_sign_on_flag = 'Y'
62: THEN
63: IF (l_debug > 0) THEN
64: wms_carousel_integration_pvt.LOG (p_device_id, 'Employee (' || p_employee_id || ') logged on');
65: END IF;
66: ELSIF p_sign_on_flag = 'N'
67: THEN
68: IF (l_debug > 0) THEN

Line 69: wms_carousel_integration_pvt.LOG (p_device_id, 'Employee (' || p_employee_id || ') logged off');

65: END IF;
66: ELSIF p_sign_on_flag = 'N'
67: THEN
68: IF (l_debug > 0) THEN
69: wms_carousel_integration_pvt.LOG (p_device_id, 'Employee (' || p_employee_id || ') logged off');
70: END IF;
71: ELSE
72: x_status_code := 'E';
73: x_device_status := 'Invalid p_sing_on_flag';

Line 89: (wms_carousel_integration_pvt.get_config_parameter

85: LOOP
86: -- Get pipe listener switch value
87: v_switch :=
88: NVL
89: (wms_carousel_integration_pvt.get_config_parameter
90: (p_name => 'PIPE_LISTENER_SWITCH',
91: p_sequence_id => p_device_id
92: ),
93: 'OFF'

Line 97: wms_carousel_integration_pvt.LOG

93: 'OFF'
94: );
95: EXIT WHEN v_switch = 'OFF';
96: IF (l_debug > 0) THEN
97: wms_carousel_integration_pvt.LOG
98: ( p_device_id, 'Calling receive_pipe_listener. p_zone='
99: || p_zone
100: || ', p_pipe_name='
101: || p_pipe_name

Line 108: -- wms_carousel_integration_pvt.receive_pipe_listener (p_zone, p_device_id, p_pipe_name);

104: );
105: END IF;
106: -- Call the listener
107: -- Bug# 4666748
108: -- wms_carousel_integration_pvt.receive_pipe_listener (p_zone, p_device_id, p_pipe_name);
109: END LOOP;
110: COMMIT;
111: END;
112:

Line 132: v_pipename := wms_carousel_integration_pvt.get_config_parameter

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',
134: p_sequence_id => p_device_id
135: );
136:

Line 168: wms_carousel_integration_pvt.LOG (p_device_id, 'No PIPE_NAME parameter defined for device ('

164: ,fnd_global.user_id
165: ,fnd_global.login_id
166: );
167: IF (l_debug > 0) THEN
168: wms_carousel_integration_pvt.LOG (p_device_id, 'No PIPE_NAME parameter defined for device ('
169: || p_device_id || ')! Hence created one with value='
170: || v_pipename
171: );
172: END IF;

Line 193: WMS_CAROUSEL_INTEGRATION_PVT.LOG (v_cfg.device_id, 'Job already exists:'

189: FROM user_jobs
190: WHERE UPPER (what) LIKE '%WMS_CAROUSEL_INTEGRATION_PKG.PIPE_LISTENER_LOOP%')
191: where pipe_name = v_pipename;
192: IF (l_debug > 0) THEN
193: WMS_CAROUSEL_INTEGRATION_PVT.LOG (v_cfg.device_id, 'Job already exists:'
194: || ' ID='
195: || v_job
196: || ', Pipe='
197: || v_pipename

Line 220: WMS_CAROUSEL_INTEGRATION_PVT.LOG (v_cfg.device_id, 'New Job Created:'

216:
217: DBMS_JOB.what (v_job, job_str);
218:
219: IF (l_debug > 0) THEN
220: WMS_CAROUSEL_INTEGRATION_PVT.LOG (v_cfg.device_id, 'New Job Created:'
221: || ' ID='
222: || v_job
223: || ', Pipe='
224: || v_pipename

Line 252: (wms_carousel_integration_pvt.get_config_parameter

248: BEGIN
249: IF (p_device_id IS NOT NULL) THEN
250: v_pipename :=
251: NVL
252: (wms_carousel_integration_pvt.get_config_parameter
253: (p_name => 'PIPE_NAME',
254: p_sequence_id => p_device_id
255: ),
256: 'PIPE_NAME_' || p_device_id

Line 265: wms_carousel_integration_pvt.LOG ( p_device_id, 'Job Started:'

261: LOOP
262: -- Start the job
263: DBMS_JOB.broken(v_job.job,false,null);
264: IF (l_debug > 0) THEN
265: wms_carousel_integration_pvt.LOG ( p_device_id, 'Job Started:'
266: || ' ID='
267: || v_job.job
268: || ', Pipe='
269: || v_job.pipe_name

Line 295: (wms_carousel_integration_pvt.get_config_parameter

291: BEGIN
292: IF (p_device_id IS NOT NULL) THEN
293: v_pipename :=
294: NVL
295: (wms_carousel_integration_pvt.get_config_parameter
296: (p_name => 'PIPE_NAME',
297: p_sequence_id => p_device_id
298: ),
299: 'PIPE_NAME_' || p_device_id

Line 308: wms_carousel_integration_pvt.LOG ( p_device_id, 'Job Stopped:'

304: LOOP
305: -- Stop the job
306: DBMS_JOB.broken(v_job.job,true,null);
307: IF (l_debug > 0) THEN
308: wms_carousel_integration_pvt.LOG ( p_device_id, 'Job Stopped:'
309: || ' ID='
310: || v_job.job
311: || ', Pipe='
312: || v_job.pipe_name

Line 339: wms_carousel_integration_pvt.LOG ( NULL, 'Job Removed:'

335: LOOP
336: -- Remove the job
337: DBMS_JOB.remove (v_job.job);
338: IF (l_debug > 0) THEN
339: wms_carousel_integration_pvt.LOG ( NULL, 'Job Removed:'
340: || ' ID='
341: || v_job.job
342: || ', what='
343: || v_job.what

Line 376: wms_carousel_integration_pvt.LOG (null,'All Pipe Listeners Switched ON');

372: UPDATE WMS_CAROUSEL_CONFIGURATION c
373: SET c.CONFIG_VALUE = 'ON'
374: WHERE c.CONFIG_NAME = 'PIPE_LISTENER_SWITCH';
375: IF (l_debug > 0) THEN
376: wms_carousel_integration_pvt.LOG (null,'All Pipe Listeners Switched ON');
377: END IF;
378: ELSE
379: v_pipename :=
380: NVL

Line 381: (wms_carousel_integration_pvt.get_config_parameter

377: END IF;
378: ELSE
379: v_pipename :=
380: NVL
381: (wms_carousel_integration_pvt.get_config_parameter
382: (p_name => 'PIPE_NAME',
383: p_sequence_id => p_device_id
384: ),
385: 'PIPE_NAME_' || p_device_id

Line 393: wms_carousel_integration_pvt.LOG (p_device_id,'Pipe Listener Switched ON: Pipe=IN_' || v_pipename);

389: SET c.CONFIG_VALUE = 'ON'
390: WHERE c.CONFIG_NAME = 'PIPE_LISTENER_SWITCH'
391: AND SEQUENCE_ID IN (SELECT SEQUENCE_ID FROM wms_carousel_configuration WHERE CONFIG_VALUE = v_pipename);
392: IF (l_debug > 0) THEN
393: wms_carousel_integration_pvt.LOG (p_device_id,'Pipe Listener Switched ON: Pipe=IN_' || v_pipename);
394: END IF;
395: END IF;
396: start_job(p_device_id);
397: COMMIT;

Line 414: WMS_CAROUSEL_INTEGRATION_PVT.LOG (null,'All Pipe Listeners Switched OFF');

410: UPDATE WMS_CAROUSEL_CONFIGURATION c
411: SET c.CONFIG_VALUE = 'OFF'
412: WHERE c.CONFIG_NAME = 'PIPE_LISTENER_SWITCH';
413: IF (l_debug > 0) THEN
414: WMS_CAROUSEL_INTEGRATION_PVT.LOG (null,'All Pipe Listeners Switched OFF');
415: END IF;
416: ELSE
417: v_pipename :=
418: NVL

Line 419: (wms_carousel_integration_pvt.get_config_parameter

415: END IF;
416: ELSE
417: v_pipename :=
418: NVL
419: (wms_carousel_integration_pvt.get_config_parameter
420: (p_name => 'PIPE_NAME',
421: p_sequence_id => p_device_id
422: ),
423: 'PIPE_NAME_' || p_device_id

Line 431: WMS_CAROUSEL_INTEGRATION_PVT.LOG (p_device_id,'Pipe Listener Switched OFF: Pipe=IN_' || v_pipename);

427: SET c.CONFIG_VALUE = 'OFF'
428: WHERE c.CONFIG_NAME = 'PIPE_LISTENER_SWITCH'
429: AND SEQUENCE_ID IN (SELECT SEQUENCE_ID FROM WMS_CAROUSEL_CONFIGURATION WHERE CONFIG_VALUE = v_pipename);
430: IF (l_debug > 0) THEN
431: WMS_CAROUSEL_INTEGRATION_PVT.LOG (p_device_id,'Pipe Listener Switched OFF: Pipe=IN_' || v_pipename);
432: END IF;
433: END IF;
434: stop_job(p_device_id);
435: COMMIT;

Line 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 || ')');

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';
456: Open c_tasks;
457: Fetch c_tasks into l_dummy;
458: IF (c_tasks%NOTFOUND) THEN

Line 460: wms_carousel_integration_pvt.LOG ( p_device_id, 'Signing off employee (' || p_emp_id || ') from device_id (' || p_device_id || ')');

456: Open c_tasks;
457: Fetch c_tasks into l_dummy;
458: IF (c_tasks%NOTFOUND) THEN
459: IF (l_debug > 0) THEN
460: wms_carousel_integration_pvt.LOG ( p_device_id, 'Signing off employee (' || p_emp_id || ') from device_id (' || p_device_id || ')');
461: END IF;
462:
463: DELETE FROM wms_device_assignment_temp WHERE device_id = p_device_id and EMPLOYEE_ID = p_emp_id;
464: COMMIT;

Line 467: wms_carousel_integration_pvt.LOG ( p_device_id, 'Failed signing off employee (' || p_emp_id || ') from device_id (' || p_device_id || ')');

463: DELETE FROM wms_device_assignment_temp WHERE device_id = p_device_id and EMPLOYEE_ID = p_emp_id;
464: COMMIT;
465: ELSE
466: IF (l_debug > 0) THEN
467: wms_carousel_integration_pvt.LOG ( p_device_id, 'Failed signing off employee (' || p_emp_id || ') from device_id (' || p_device_id || ')');
468: END IF;
469: x_return_status := 'A';
470: END IF;
471: CLOSE c_tasks;