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_WCS_DEVICE_GRP dependencies on FND_API

Line 40: x_return_status := FND_API.G_RET_STS_ERROR;

36: l_device_id NUMBER := -1; -- Returned by get_device_info API
37: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
38: PRAGMA AUTONOMOUS_TRANSACTION;
39: BEGIN
40: x_return_status := FND_API.G_RET_STS_ERROR;
41:
42: IF (l_debug = 1) THEN
43: log
44: (p_device_id, 'In DEVICE_SIGN_ON. Calling WMS_Task_Dispatch_Device.get_device_info with params...');

Line 67: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

63: x_subinventory => x_subinventory,
64: p_emp_id => p_employee_id,
65: x_signed_onto_wrk_stn => x_signon_wrk_stn);
66:
67: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
68: RAISE fnd_api.g_exc_unexpected_error;
69: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
70: RAISE fnd_api.g_exc_error;
71: ELSIF x_return_status = 'A' THEN

Line 68: RAISE fnd_api.g_exc_unexpected_error;

64: p_emp_id => p_employee_id,
65: x_signed_onto_wrk_stn => x_signon_wrk_stn);
66:
67: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
68: RAISE fnd_api.g_exc_unexpected_error;
69: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
70: RAISE fnd_api.g_exc_error;
71: ELSIF x_return_status = 'A' THEN
72: IF (l_debug = 1) THEN

Line 69: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

65: x_signed_onto_wrk_stn => x_signon_wrk_stn);
66:
67: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
68: RAISE fnd_api.g_exc_unexpected_error;
69: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
70: RAISE fnd_api.g_exc_error;
71: ELSIF x_return_status = 'A' THEN
72: IF (l_debug = 1) THEN
73: log

Line 70: RAISE fnd_api.g_exc_error;

66:
67: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
68: RAISE fnd_api.g_exc_unexpected_error;
69: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
70: RAISE fnd_api.g_exc_error;
71: ELSIF x_return_status = 'A' THEN
72: IF (l_debug = 1) THEN
73: log
74: (p_device_id, 'Device already signed on. l_device_id='

Line 96: x_return_status := fnd_api.g_ret_sts_error;

92:
93: fnd_message.set_name('WMS', 'WMS_DEVICE_ALREADY_SIGNED');
94: fnd_message.set_token('DEVICE_DESC', x_device_desc);
95: fnd_msg_pub.ADD;
96: x_return_status := fnd_api.g_ret_sts_error;
97: RAISE fnd_api.G_EXC_ERROR;
98:
99: END IF;
100:

Line 97: RAISE fnd_api.G_EXC_ERROR;

93: fnd_message.set_name('WMS', 'WMS_DEVICE_ALREADY_SIGNED');
94: fnd_message.set_token('DEVICE_DESC', x_device_desc);
95: fnd_msg_pub.ADD;
96: x_return_status := fnd_api.g_ret_sts_error;
97: RAISE fnd_api.G_EXC_ERROR;
98:
99: END IF;
100:
101: IF (l_debug = 1) THEN

Line 128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

124: --Commit for Autonmous transaction
125: COMMIT;
126: EXCEPTION
127: WHEN OTHERS THEN
128: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
129: IF (l_debug = 1) THEN
130: log
131: (p_device_id, 'Unexpected error in DEVICE_SIGN_ON : '||SQLERRM);
132: END IF;

Line 146: x_return_status := FND_API.G_RET_STS_ERROR;

142: IS
143: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
144: PRAGMA AUTONOMOUS_TRANSACTION;
145: BEGIN
146: x_return_status := FND_API.G_RET_STS_ERROR;
147:
148: IF (l_debug = 1) THEN
149: log
150: (NULL, 'In DEVICE_SIGN_OFF. Calling WMS_Task_Dispatch_Device.cleanup_device_and_tasks with params...');

Line 166: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

162: x_return_status => x_return_status,
163: x_msg_count => x_msg_count,
164: x_msg_data => x_msg_data);
165:
166: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
167: RAISE fnd_api.g_exc_unexpected_error;
168: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
169: RAISE fnd_api.g_exc_error;
170: END IF;

Line 167: RAISE fnd_api.g_exc_unexpected_error;

163: x_msg_count => x_msg_count,
164: x_msg_data => x_msg_data);
165:
166: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
167: RAISE fnd_api.g_exc_unexpected_error;
168: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
169: RAISE fnd_api.g_exc_error;
170: END IF;
171:

Line 168: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

164: x_msg_data => x_msg_data);
165:
166: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
167: RAISE fnd_api.g_exc_unexpected_error;
168: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
169: RAISE fnd_api.g_exc_error;
170: END IF;
171:
172: IF (l_debug = 1) THEN

Line 169: RAISE fnd_api.g_exc_error;

165:
166: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
167: RAISE fnd_api.g_exc_unexpected_error;
168: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
169: RAISE fnd_api.g_exc_error;
170: END IF;
171:
172: IF (l_debug = 1) THEN
173: log

Line 182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

178: --Autonomous transaction commit
179: COMMIT;
180: EXCEPTION
181: WHEN OTHERS THEN
182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
183: IF (l_debug = 1) THEN
184: log
185: (NULL, 'Unexpected error in DEVICE_SIGN_OFF : '||SQLERRM);
186: END IF;

Line 202: x_return_status := FND_API.G_RET_STS_ERROR;

198: IS
199: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
200: PRAGMA AUTONOMOUS_TRANSACTION;
201: BEGIN
202: x_return_status := FND_API.G_RET_STS_ERROR;
203:
204: IF (l_debug = 1) THEN
205: log
206: (NULL, 'In SINGLE_DEVICE_SIGN_OFF. Calling overloaded WMS_Task_Dispatch_Device.cleanup_device_and_tasks with params...');

Line 225: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

221: x_return_status => x_return_status,
222: x_msg_count => x_msg_count,
223: x_msg_data => x_msg_data);
224:
225: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
226: RAISE fnd_api.g_exc_unexpected_error;
227: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
228: RAISE fnd_api.g_exc_error;
229: END IF;

Line 226: RAISE fnd_api.g_exc_unexpected_error;

222: x_msg_count => x_msg_count,
223: x_msg_data => x_msg_data);
224:
225: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
226: RAISE fnd_api.g_exc_unexpected_error;
227: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
228: RAISE fnd_api.g_exc_error;
229: END IF;
230:

Line 227: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

223: x_msg_data => x_msg_data);
224:
225: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
226: RAISE fnd_api.g_exc_unexpected_error;
227: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
228: RAISE fnd_api.g_exc_error;
229: END IF;
230:
231: IF (l_debug = 1) THEN

Line 228: RAISE fnd_api.g_exc_error;

224:
225: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
226: RAISE fnd_api.g_exc_unexpected_error;
227: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
228: RAISE fnd_api.g_exc_error;
229: END IF;
230:
231: IF (l_debug = 1) THEN
232: log

Line 241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

237: --Autonomous transaction commit
238: COMMIT;
239: EXCEPTION
240: WHEN OTHERS THEN
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: IF (l_debug = 1) THEN
243: log
244: (NULL, 'Unexpected error in SINGLE_DEVICE_SIGN_OFF : '||SQLERRM);
245: END IF;

Line 252: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,

248:
249: --Wrapper call on WMS_Device_Integration_PVT.device_request - overloaded
250: --WMS-OPM
251: PROCEDURE DEVICE_REQUEST(
252: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
253: p_bus_event IN NUMBER,
254: p_call_ctx IN VARCHAR2 ,
255: p_task_trx_id IN NUMBER := NULL,
256: p_org_id IN NUMBER := NULL,

Line 277: x_return_status := FND_API.G_RET_STS_ERROR;

273: )
274: IS
275: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
276: BEGIN
277: x_return_status := FND_API.G_RET_STS_ERROR;
278:
279: IF (l_debug = 1) THEN
280: log
281: (p_device_id, 'In DEVICE_REQUEST. Calling WMS_Device_Integration_PVT.DEVICE_REQUEST with params...');

Line 339: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

335: x_msg_data => x_msg_data,
336: p_request_id => p_request_id,
337: p_device_id => p_device_id);
338:
339: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
340: RAISE fnd_api.g_exc_unexpected_error;
341: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
342: RAISE fnd_api.g_exc_error;
343: END IF;

Line 340: RAISE fnd_api.g_exc_unexpected_error;

336: p_request_id => p_request_id,
337: p_device_id => p_device_id);
338:
339: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
340: RAISE fnd_api.g_exc_unexpected_error;
341: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
342: RAISE fnd_api.g_exc_error;
343: END IF;
344:

Line 341: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

337: p_device_id => p_device_id);
338:
339: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
340: RAISE fnd_api.g_exc_unexpected_error;
341: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
342: RAISE fnd_api.g_exc_error;
343: END IF;
344:
345: IF (l_debug = 1) THEN

Line 342: RAISE fnd_api.g_exc_error;

338:
339: IF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
340: RAISE fnd_api.g_exc_unexpected_error;
341: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
342: RAISE fnd_api.g_exc_error;
343: END IF;
344:
345: IF (l_debug = 1) THEN
346: log

Line 360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

356: END IF;
357:
358: EXCEPTION
359: WHEN OTHERS THEN
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361: IF (l_debug = 1) THEN
362: log
363: (p_device_id, 'Unexpected error in wms_device_integration_pvt.device_request : '||SQLERRM);
364: END IF;

Line 407: x_return_status := fnd_api.g_ret_sts_success;

403: l_successful_row_cnt NUMBER;
404: l_request_id NUMBER;
405: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
406: BEGIN
407: x_return_status := fnd_api.g_ret_sts_success;
408: IF l_debug >= 1 THEN
409: LOG(p_device_id, 'In WMS_WCS_DEVICE_GRP.PROCESS_RESPONSE for p_request_id='
410: ||p_request_id);
411: END IF;

Line 487: x_return_status := fnd_api.g_ret_sts_unexp_error;

483: );
484: END IF;
485: EXCEPTION
486: WHEN OTHERS THEN
487: x_return_status := fnd_api.g_ret_sts_unexp_error;
488: fnd_msg_pub.count_and_get (p_count => x_msg_count,
489: p_data => x_msg_data);
490: END PROCESS_RESPONSE;
491:

Line 527: , p_init_msg_list => fnd_api.g_false

523: END IF;
524:
525: wms_workflow_wrappers.wf_wrapper(
526: p_api_version => 1.0
527: , p_init_msg_list => fnd_api.g_false
528: , p_commit => fnd_api.g_false
529: , x_return_status => l_return_status
530: , x_msg_count => l_msg_count
531: , x_msg_data => l_msg_data

Line 528: , p_commit => fnd_api.g_false

524:
525: wms_workflow_wrappers.wf_wrapper(
526: p_api_version => 1.0
527: , p_init_msg_list => fnd_api.g_false
528: , p_commit => fnd_api.g_false
529: , x_return_status => l_return_status
530: , x_msg_count => l_msg_count
531: , x_msg_data => l_msg_data
532: , p_org_id => p_response_record.organization_id

Line 546: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

542: LOG(p_device_id ,'After Calling wf_wrapper. l_return_status is '
543: ||l_return_status);
544: END IF;
545:
546: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
547: IF (l_debug > 0) THEN
548: LOG(p_device_id ,'Error calling wf_wrapper');
549: END IF;
550: RAISE fnd_api.g_exc_unexpected_error;

Line 550: RAISE fnd_api.g_exc_unexpected_error;

546: IF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
547: IF (l_debug > 0) THEN
548: LOG(p_device_id ,'Error calling wf_wrapper');
549: END IF;
550: RAISE fnd_api.g_exc_unexpected_error;
551: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
552: IF (l_debug > 0) THEN
553: LOG(p_device_id ,'Error calling wf_wrapper');
554: END IF;

Line 551: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN

547: IF (l_debug > 0) THEN
548: LOG(p_device_id ,'Error calling wf_wrapper');
549: END IF;
550: RAISE fnd_api.g_exc_unexpected_error;
551: ELSIF l_return_status = fnd_api.g_ret_sts_error THEN
552: IF (l_debug > 0) THEN
553: LOG(p_device_id ,'Error calling wf_wrapper');
554: END IF;
555: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');

Line 557: RAISE fnd_api.g_exc_error;

553: LOG(p_device_id ,'Error calling wf_wrapper');
554: END IF;
555: fnd_message.set_name('WMS', 'WMS_WORK_FLOW_FAIL');
556: fnd_msg_pub.ADD;
557: RAISE fnd_api.g_exc_error;
558: END IF;
559: END IF;
560: --Autonomous transaction commit
561: COMMIT;

Line 564: l_return_status := fnd_api.g_ret_sts_unexp_error;

560: --Autonomous transaction commit
561: COMMIT;
562: EXCEPTION
563: WHEN OTHERS THEN
564: l_return_status := fnd_api.g_ret_sts_unexp_error;
565: IF (l_debug > 0) THEN
566: LOG(p_device_id ,'Call_Workflow failed'||SQLERRM);
567: END IF;
568: fnd_msg_pub.count_and_get(p_count => l_msg_count,