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.GMO_DVC_INTG_PVT dependencies on GMO_DVC_INTG_PVT

Line 1: PACKAGE BODY GMO_DVC_INTG_PVT AS

1: PACKAGE BODY GMO_DVC_INTG_PVT AS
2: /* $Header: GMOVDVCB.pls 120.4 2005/10/25 01:02 rahugupt noship $ */
3:
4:
5: -- internal constants used in this package body

Line 44: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.lock_device', FALSE);

40: FND_MESSAGE.SET_TOKEN('DEVICE_NAME',l_device_name);
41: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
42: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',P_ORGANIZATION_ID);
43:
44: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.lock_device', FALSE);
45: end if;
46:
47: -- call the wms api to lock the device
48: WMS_WCS_DEVICE_GRP.DEVICE_SIGN_ON

Line 73: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_dvc_intg_pvt.lock_device', FALSE);

69: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
70: FND_MSG_PUB.ADD;
71: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
72: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
73: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_dvc_intg_pvt.lock_device', FALSE);
74: end if;
75: END LOCK_DEVICE;
76:
77: --This procdeure would unlock the device.

Line 97: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.unlock_device', FALSE);

93: FND_MESSAGE.SET_TOKEN('DEVICE_ID',P_DEVICE_ID);
94: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
95: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',P_ORGANIZATION_ID);
96:
97: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.unlock_device', FALSE);
98: end if;
99:
100: -- call the wms api to unlock the device
101: WMS_WCS_DEVICE_GRP.SINGLE_DEVICE_SIGN_OFF

Line 121: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_dvc_intg_pvt.unlock_device', FALSE);

117: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
118: FND_MSG_PUB.ADD;
119: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
120: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
121: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_dvc_intg_pvt.unlock_device', FALSE);
122: end if;
123: END UNLOCK_DEVICE;
124:
125: -- this is an internal procedure to invoke wms device request api

Line 191: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.temp_data_cleanup', FALSE);

187: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
188:
189: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_CLEANUP_DATA_MSG');
190: FND_MESSAGE.SET_TOKEN('CLEANUP_TO_DATE',P_CLEANUP_TO_DATE);
191: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.temp_data_cleanup', FALSE);
192: end if;
193:
194: DELETE FROM GMO_DEVICE_RESPONSES_T WHERE REQUEST_ID IN
195: (SELECT REQUEST_ID FROM GMO_DEVICE_REQUESTS_T

Line 203: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.temp_data_cleanup', FALSE);

199:
200: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
201:
202: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_CLEANUP_SUCCESS_MSG');
203: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.temp_data_cleanup', FALSE);
204: end if;
205:
206: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
207: EXCEPTION

Line 269: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.post_response', FALSE);

265: FND_MESSAGE.SET_TOKEN('ACTION', P_ACTION);
266: FND_MESSAGE.SET_TOKEN('REQUEST_ID',P_REQUEST_ID);
267: FND_MESSAGE.SET_TOKEN('COMPONENT',P_RESP_COMP_CODE);
268: FND_MESSAGE.SET_TOKEN('COMPONENT_VALUE',P_RESP_COMP_CODE_VALUE);
269: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.post_response', FALSE);
270: end if;
271:
272: commit;
273:

Line 327: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.post_request', FALSE);

323: FND_MESSAGE.SET_TOKEN('REQUEST_ID',P_REQUEST_ID);
324: FND_MESSAGE.SET_TOKEN('DEVICE_ID',P_DEVICE_ID);
325: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
326: FND_MESSAGE.SET_TOKEN('DEVICE_STATUS',P_DEVICE_STATUS);
327: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.post_request', FALSE);
328: end if;
329:
330: commit;
331:

Line 406: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.read_device', FALSE);

402: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
403:
404: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_READ_COMPONENT_MSG');
405: FND_MESSAGE.SET_TOKEN('COMPONENT',l_response_code);
406: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.read_device', FALSE);
407: end if;
408:
409: l_msg_component.extend;
410: l_counter := l_counter + 1;

Line 417: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.read_device', FALSE);

413: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
414:
415: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_READ_COMPONENT_MSG');
416: FND_MESSAGE.SET_TOKEN('COMPONENT',l_response_uom);
417: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.read_device', FALSE);
418: end if;
419:
420: else
421: -- if the parameter has no message components, create the error parameter list

Line 612: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.read_device', FALSE);

608: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_READ_DEVICE_MSG');
609: FND_MESSAGE.SET_TOKEN('DEVICE_ID',P_DEVICE_ID);
610: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',P_ORGANIZATION_ID);
611: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
612: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.read_device', FALSE);
613: end if;
614:
615: -- validate if any message components were passed
616: IF (P_MSG_COMPONENT is null or P_MSG_COMPONENT.COUNT = 0) THEN

Line 627: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.read_device', FALSE);

623:
624: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_WCS_ORG_ENABLED_MSG');
625: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',P_ORGANIZATION_ID);
626: FND_MESSAGE.SET_TOKEN('ENABLED_FLAG',l_wcs_enabled);
627: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.read_device', FALSE);
628: end if;
629:
630: -- check if the organization is wcs enabled
631: -- this is required from wms architecture perspective

Line 654: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.read_device', FALSE);

650: FND_MESSAGE.SET_TOKEN('DEVICE',l_device_name);
651: FND_MESSAGE.SET_TOKEN('OUTPUT_METHOD',l_output_method);
652: FND_MESSAGE.SET_TOKEN('OUTPUT_METHOD_ID',l_output_method_id);
653: FND_MESSAGE.SET_TOKEN('SUBINVENTORY', l_subinventory);
654: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.read_device', FALSE);
655: end if;
656:
657: -- for device response, the output method should always be API (outputmethod id 2).
658: if (l_output_method_id <> '2') then

Line 667: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.read_device', FALSE);

663:
664: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_REQUEST_ID_MSG');
665: FND_MESSAGE.SET_TOKEN('DEVICE_ID',P_DEVICE_ID);
666: FND_MESSAGE.SET_TOKEN('REQUEST_ID',l_request_id);
667: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.read_device', FALSE);
668: end if;
669:
670:
671:

Line 719: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.read_device', FALSE);

715: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
716: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_READ_DEVICE_STATUS_MSG');
717: FND_MESSAGE.SET_TOKEN('DEVICE_ID',P_DEVICE_ID);
718: FND_MESSAGE.SET_TOKEN('DEVICE_STATUS',l_return_status);
719: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.read_device', FALSE);
720: end if;
721:
722: POST_REQUEST (P_ACTION => ACTION_UPDATE_DEVICE_STATUS, P_REQUEST_ID => l_request_id, P_DEVICE_ID => P_DEVICE_ID , P_REQUESTER => P_REQUESTER , P_DEVICE_STATUS => l_return_status);
723: X_DEVICE_STATUS := l_return_status;

Line 741: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.read_device', FALSE);

737: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
738:
739: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_TIMEOUT_VALUE_MSG');
740: FND_MESSAGE.SET_TOKEN('TIMEOUT',l_profile_value);
741: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.read_device', FALSE);
742: end if;
743:
744:
745: -- we will loop till the response is recevied or timeout (based on profile) has reached.

Line 759: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.read_device', FALSE);

755: L_DEVICE_REQUEST_END := TRUE;
756:
757: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
758: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_RESPONSE_RECD_MSG');
759: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.read_device', FALSE);
760: end if;
761:
762: IF (l_response_status <> FND_API.G_RET_STS_SUCCESS) THEN
763: RAISE L_DEVICE_RESPONSE_ERR;

Line 768: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.read_device', FALSE);

764: END IF;
765: elsif (l_timeout_profile_value > -1 and l_request_exec_time > l_timeout_profile_value) then
766: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
767: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_READ_TIMEOUT_MSG');
768: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.read_device', FALSE);
769: end if;
770: L_DEVICE_REQUEST_END := TRUE;
771:
772: raise l_timeout_err;

Line 955: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.read_device', FALSE);

951: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
952: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_PROCESS_RESPONSE_MSG');
953: FND_MESSAGE.SET_TOKEN('REQUEST_ID',P_REQUEST_ID);
954: FND_MESSAGE.SET_TOKEN('DEVICE_ID',P_DEVICE_ID);
955: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.read_device', FALSE);
956: end if;
957:
958: select count(*) into l_count from GMO_DEVICE_REQUESTS_T WHERE REQUEST_ID = P_REQUEST_ID AND DEVICE_ID = P_DEVICE_ID;
959:

Line 1050: END GMO_DVC_INTG_PVT;

1046: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_dvc_intg_grp.process_device_response', FALSE);
1047: end if;
1048: END PROCESS_DEVICE_RESPONSE;
1049:
1050: END GMO_DVC_INTG_PVT;