APPS.GMO_DVC_INTG_PVT dependencies on FND_LOG

Line 36: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

32: open c_get_device_details;
33: fetch c_get_device_details into l_device_name;
34: close c_get_device_details;
35:
36: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
37:
38: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_LOCK_DEVICE_MSG');
39: FND_MESSAGE.SET_TOKEN('DEVICE_ID',P_DEVICE_ID);
40: FND_MESSAGE.SET_TOKEN('DEVICE_NAME',l_device_name);

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 72: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

68: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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:

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 90: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

86: IS PRAGMA AUTONOMOUS_TRANSACTION;
87:
88: BEGIN
89:
90: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
91:
92: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_UNLOCK_DEVICE_MSG');
93: FND_MESSAGE.SET_TOKEN('DEVICE_ID',P_DEVICE_ID);
94: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);

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 120: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

116: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
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:

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 187: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

183: IF (l_cleanup_to_date IS NULL) THEN
184: l_cleanup_to_date := sysdate -2;
185: END IF;
186:
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);

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 200: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

196: WHERE CREATION_DATE < l_cleanup_to_date );
197:
198: DELETE FROM GMO_DEVICE_REQUESTS_T WHERE CREATION_DATE < l_cleanup_to_date;
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;

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 215: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

211: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
212: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
213: FND_MSG_PUB.ADD;
214: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
215: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
216: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_dvc_intg_grp.temp_data_cleanup', FALSE);
217: end if;
218: END TEMP_DATA_CLEANUP;
219:

Line 216: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_dvc_intg_grp.temp_data_cleanup', FALSE);

212: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
213: FND_MSG_PUB.ADD;
214: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
215: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
216: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_dvc_intg_grp.temp_data_cleanup', FALSE);
217: end if;
218: END TEMP_DATA_CLEANUP;
219:
220: -- Internal procedure to insert the device response component for a request

Line 263: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

259: and RESP_COMP_CODE = P_RESP_COMP_CODE;
260:
261: END IF;
262:
263: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
264: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_REQUEST_COMP_OPRN_MSG');
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);

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 277: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

273:
274: EXCEPTION
275: WHEN OTHERS THEN
276: ROLLBACK;
277: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
278: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_REQUEST_COMP_OPRN_ERR');
279: FND_MESSAGE.SET_TOKEN('ACTION', P_ACTION);
280: FND_MESSAGE.SET_TOKEN('REQUEST_ID',P_REQUEST_ID);
281: FND_MESSAGE.SET_TOKEN('COMPONENT',P_RESP_COMP_CODE);

Line 283: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_dvc_intg_grp.post_response', FALSE);

279: FND_MESSAGE.SET_TOKEN('ACTION', P_ACTION);
280: FND_MESSAGE.SET_TOKEN('REQUEST_ID',P_REQUEST_ID);
281: FND_MESSAGE.SET_TOKEN('COMPONENT',P_RESP_COMP_CODE);
282: FND_MESSAGE.SET_TOKEN('COMPONENT_VALUE',P_RESP_COMP_CODE_VALUE);
283: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_dvc_intg_grp.post_response', FALSE);
284: end if;
285: RAISE;
286: END;
287:

Line 320: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

316: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
317: WHERE REQUEST_ID = P_REQUEST_ID AND DEVICE_ID = P_DEVICE_ID;
318: END IF;
319:
320: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
321: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_REQUEST_OPRN_MSG');
322: FND_MESSAGE.SET_TOKEN('ACTION', P_ACTION);
323: FND_MESSAGE.SET_TOKEN('REQUEST_ID',P_REQUEST_ID);
324: FND_MESSAGE.SET_TOKEN('DEVICE_ID',P_DEVICE_ID);

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 335: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

331:
332: EXCEPTION
333: WHEN OTHERS THEN
334: ROLLBACK;
335: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
336: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_REQUEST_OPRN_ERR');
337: FND_MESSAGE.SET_TOKEN('ACTION', P_ACTION);
338: FND_MESSAGE.SET_TOKEN('REQUEST_ID',P_REQUEST_ID);
339: FND_MESSAGE.SET_TOKEN('DEVICE_ID',P_DEVICE_ID);

Line 342: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_dvc_intg_grp.post_request', FALSE);

338: FND_MESSAGE.SET_TOKEN('REQUEST_ID',P_REQUEST_ID);
339: FND_MESSAGE.SET_TOKEN('DEVICE_ID',P_DEVICE_ID);
340: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
341: FND_MESSAGE.SET_TOKEN('DEVICE_STATUS',P_DEVICE_STATUS);
342: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_dvc_intg_grp.post_request', FALSE);
343: end if;
344: RAISE;
345: END;
346:

Line 402: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

398: l_msg_component.extend;
399: l_counter := l_counter + 1;
400: l_msg_component(l_counter) := l_response_code;
401:
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);

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 413: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

409: l_msg_component.extend;
410: l_counter := l_counter + 1;
411: l_msg_component(l_counter) := l_response_uom;
412:
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);

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 523: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

519: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_PARAM_MAP_ERR');
520: FND_MESSAGE.SET_TOKEN('PARAMS',l_param_error);
521: FND_MSG_PUB.ADD;
522: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
523: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
524: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);
525: end if;
526: -- APP_EXCEPTION.RAISE_EXCEPTION;
527: WHEN L_UOM_MISMATCH_ERR THEN

Line 524: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);

520: FND_MESSAGE.SET_TOKEN('PARAMS',l_param_error);
521: FND_MSG_PUB.ADD;
522: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
523: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
524: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);
525: end if;
526: -- APP_EXCEPTION.RAISE_EXCEPTION;
527: WHEN L_UOM_MISMATCH_ERR THEN
528: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 533: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

529: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_PARAM_UOM_MISMATCH_ERR');
530: FND_MESSAGE.SET_TOKEN('PARAMS',l_param_error);
531: FND_MSG_PUB.ADD;
532: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
533: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
534: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);
535: end if;
536: -- APP_EXCEPTION.RAISE_EXCEPTION;
537: WHEN OTHERS THEN

Line 534: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);

530: FND_MESSAGE.SET_TOKEN('PARAMS',l_param_error);
531: FND_MSG_PUB.ADD;
532: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
533: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
534: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);
535: end if;
536: -- APP_EXCEPTION.RAISE_EXCEPTION;
537: WHEN OTHERS THEN
538: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

Line 544: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

540: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
541: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
542: FND_MSG_PUB.ADD;
543: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
544: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
545: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_dvc_intg_grp.batchstep_material_available', FALSE);
546: end if;
547: -- APP_EXCEPTION.RAISE_EXCEPTION;
548: END READ_DEVICE;

Line 545: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_dvc_intg_grp.batchstep_material_available', FALSE);

541: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
542: FND_MSG_PUB.ADD;
543: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
544: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
545: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_dvc_intg_grp.batchstep_material_available', FALSE);
546: end if;
547: -- APP_EXCEPTION.RAISE_EXCEPTION;
548: END READ_DEVICE;
549:

Line 606: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

602:
603:
604:
605: BEGIN
606: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
607:
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);

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 622: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

618: END IF;
619:
620: l_wcs_enabled := WMS_WCS_DEVICE_GRP.IS_WCS_ENABLED (P_ORGANIZATION_ID);
621:
622: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
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);

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 646: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

642: open c_get_device_details;
643: fetch c_get_device_details into l_output_method, l_output_method_id, l_device_name, l_subinventory;
644: close c_get_device_details;
645:
646: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
647:
648: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_OUTPUT_METHOD_MSG');
649: FND_MESSAGE.SET_TOKEN('DEVICE_ID',P_DEVICE_ID);
650: FND_MESSAGE.SET_TOKEN('DEVICE',l_device_name);

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 662: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

658: if (l_output_method_id <> '2') then
659: raise l_device_op_method_err;
660: end if;
661:
662: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
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);

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 715: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

711: FOR I IN 1..P_MSG_COMPONENT.count LOOP
712: POST_RESPONSE (P_ACTION => ACTION_INSERT_RESPONSE, P_REQUEST_ID => l_request_id, P_RESP_COMP_CODE => P_MSG_COMPONENT(I), P_RESP_COMP_CODE_VALUE => '');
713: END LOOP;
714:
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);

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 737: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

733: if (l_profile_value is not null) then
734: l_timeout_profile_value := to_number(l_profile_value);
735: end if;
736:
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);

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 757: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

753:
754: if (l_response_status is not null) then
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:

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 766: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

762: IF (l_response_status <> FND_API.G_RET_STS_SUCCESS) THEN
763: RAISE L_DEVICE_RESPONSE_ERR;
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;

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 810: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

806: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
807: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_NO_MSG_COMP_ERR');
808: FND_MSG_PUB.ADD;
809: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
810: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
811: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);
812: end if;
813: -- APP_EXCEPTION.RAISE_EXCEPTION;
814: WHEN L_WCS_DISABLED_ERR THEN

Line 811: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);

807: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_NO_MSG_COMP_ERR');
808: FND_MSG_PUB.ADD;
809: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
810: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
811: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);
812: end if;
813: -- APP_EXCEPTION.RAISE_EXCEPTION;
814: WHEN L_WCS_DISABLED_ERR THEN
815: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 820: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

816: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_WCS_DISABLED_ORG_ERR');
817: FND_MESSAGE.SET_TOKEN('ORGN',L_ORG_CODE);
818: FND_MSG_PUB.ADD;
819: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
820: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
821: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);
822: end if;
823: -- APP_EXCEPTION.RAISE_EXCEPTION;
824: WHEN L_DEVICE_OP_METHOD_ERR THEN

Line 821: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);

817: FND_MESSAGE.SET_TOKEN('ORGN',L_ORG_CODE);
818: FND_MSG_PUB.ADD;
819: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
820: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
821: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);
822: end if;
823: -- APP_EXCEPTION.RAISE_EXCEPTION;
824: WHEN L_DEVICE_OP_METHOD_ERR THEN
825: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 830: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

826: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_OUTPUT_METHOD_ERR');
827: FND_MESSAGE.SET_TOKEN('DEVICE',L_DEVICE_NAME);
828: FND_MSG_PUB.ADD;
829: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
830: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
831: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);
832: end if;
833: -- APP_EXCEPTION.RAISE_EXCEPTION;
834: WHEN L_LOCK_DEVICE_ERR THEN

Line 831: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);

827: FND_MESSAGE.SET_TOKEN('DEVICE',L_DEVICE_NAME);
828: FND_MSG_PUB.ADD;
829: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
830: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
831: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);
832: end if;
833: -- APP_EXCEPTION.RAISE_EXCEPTION;
834: WHEN L_LOCK_DEVICE_ERR THEN
835: if (l_is_device_locked = true) then

Line 844: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

840: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_LOCK_DEVICE_ERR');
841: FND_MESSAGE.SET_TOKEN('DEVICE',L_DEVICE_NAME);
842: FND_MSG_PUB.ADD;
843: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
844: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
845: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);
846: end if;
847: -- APP_EXCEPTION.RAISE_EXCEPTION;
848: WHEN l_device_subinv_err THEN

Line 845: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);

841: FND_MESSAGE.SET_TOKEN('DEVICE',L_DEVICE_NAME);
842: FND_MSG_PUB.ADD;
843: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
844: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
845: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);
846: end if;
847: -- APP_EXCEPTION.RAISE_EXCEPTION;
848: WHEN l_device_subinv_err THEN
849: if (l_is_device_locked = true) then

Line 858: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

854: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_SUBINV_DEVICE_ERR');
855: FND_MESSAGE.SET_TOKEN('DEVICE',L_DEVICE_NAME);
856: FND_MSG_PUB.ADD;
857: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
858: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
859: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);
860: end if;
861: -- APP_EXCEPTION.RAISE_EXCEPTION;
862: WHEN L_READ_DEVICE_ERR THEN

Line 859: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);

855: FND_MESSAGE.SET_TOKEN('DEVICE',L_DEVICE_NAME);
856: FND_MSG_PUB.ADD;
857: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
858: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
859: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);
860: end if;
861: -- APP_EXCEPTION.RAISE_EXCEPTION;
862: WHEN L_READ_DEVICE_ERR THEN
863: if (l_is_device_locked = true) then

Line 872: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

868: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_READ_DEVICE_ERR');
869: FND_MESSAGE.SET_TOKEN('DEVICE',L_DEVICE_NAME);
870: FND_MSG_PUB.ADD;
871: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
872: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
873: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);
874: end if;
875: -- APP_EXCEPTION.RAISE_EXCEPTION;
876: WHEN L_TIMEOUT_ERR THEN

Line 873: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);

869: FND_MESSAGE.SET_TOKEN('DEVICE',L_DEVICE_NAME);
870: FND_MSG_PUB.ADD;
871: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
872: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
873: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);
874: end if;
875: -- APP_EXCEPTION.RAISE_EXCEPTION;
876: WHEN L_TIMEOUT_ERR THEN
877: if (l_is_device_locked = true) then

Line 886: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

882: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_READ_TIMEOUT_ERR');
883: FND_MESSAGE.SET_TOKEN('DEVICE',L_DEVICE_NAME);
884: FND_MSG_PUB.ADD;
885: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
886: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
887: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);
888: end if;
889: -- APP_EXCEPTION.RAISE_EXCEPTION;
890: WHEN L_DEVICE_RESPONSE_ERR THEN

Line 887: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);

883: FND_MESSAGE.SET_TOKEN('DEVICE',L_DEVICE_NAME);
884: FND_MSG_PUB.ADD;
885: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
886: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
887: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);
888: end if;
889: -- APP_EXCEPTION.RAISE_EXCEPTION;
890: WHEN L_DEVICE_RESPONSE_ERR THEN
891: if (l_is_device_locked = true) then

Line 900: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

896: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_RESPONSE_ERR');
897: FND_MESSAGE.SET_TOKEN('DEVICE',L_DEVICE_NAME);
898: FND_MSG_PUB.ADD;
899: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
900: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
901: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);
902: end if;
903: -- APP_EXCEPTION.RAISE_EXCEPTION;
904: WHEN L_UNLOCK_DEVICE_ERR THEN

Line 901: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);

897: FND_MESSAGE.SET_TOKEN('DEVICE',L_DEVICE_NAME);
898: FND_MSG_PUB.ADD;
899: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
900: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
901: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);
902: end if;
903: -- APP_EXCEPTION.RAISE_EXCEPTION;
904: WHEN L_UNLOCK_DEVICE_ERR THEN
905: if (l_is_device_locked = true) then

Line 914: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

910: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_UNLOCK_DEVICE_ERR');
911: FND_MESSAGE.SET_TOKEN('DEVICE',L_DEVICE_NAME);
912: FND_MSG_PUB.ADD;
913: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
914: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
915: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);
916: end if;
917: -- APP_EXCEPTION.RAISE_EXCEPTION;
918: WHEN OTHERS THEN

Line 915: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);

911: FND_MESSAGE.SET_TOKEN('DEVICE',L_DEVICE_NAME);
912: FND_MSG_PUB.ADD;
913: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
914: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
915: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);
916: end if;
917: -- APP_EXCEPTION.RAISE_EXCEPTION;
918: WHEN OTHERS THEN
919: if (l_is_device_locked = true) then

Line 929: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

925: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
926: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
927: FND_MSG_PUB.ADD;
928: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
929: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
930: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);
931: end if;
932: -- APP_EXCEPTION.RAISE_EXCEPTION;
933: END READ_DEVICE;

Line 930: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);

926: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
927: FND_MSG_PUB.ADD;
928: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
929: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
930: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_dvc_intg_grp.read_device', FALSE);
931: end if;
932: -- APP_EXCEPTION.RAISE_EXCEPTION;
933: END READ_DEVICE;
934:

Line 951: if (FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

947: l_request_not_found_err exception;
948:
949: BEGIN
950:
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);

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 1035: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1031: FND_MESSAGE.SET_TOKEN('REQUEST_ID',P_REQUEST_ID);
1032: FND_MESSAGE.SET_TOKEN('DEVICE_ID',P_DEVICE_ID);
1033: FND_MSG_PUB.ADD;
1034: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1035: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1036: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.process_device_response', FALSE);
1037: end if;
1038: WHEN OTHERS THEN
1039: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1036: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.process_device_response', FALSE);

1032: FND_MESSAGE.SET_TOKEN('DEVICE_ID',P_DEVICE_ID);
1033: FND_MSG_PUB.ADD;
1034: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1035: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1036: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_dvc_intg_grp.process_device_response', FALSE);
1037: end if;
1038: WHEN OTHERS THEN
1039: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
1040: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_UNEXPECTED_DB_ERR');

Line 1045: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

1041: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1042: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1043: FND_MSG_PUB.ADD;
1044: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1045: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
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:

Line 1046: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_dvc_intg_grp.process_device_response', FALSE);

1042: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1043: FND_MSG_PUB.ADD;
1044: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
1045: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
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;