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 FND_MESSAGE

Line 38: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_LOCK_DEVICE_MSG');

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);
41: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
42: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',P_ORGANIZATION_ID);

Line 39: FND_MESSAGE.SET_TOKEN('DEVICE_ID',P_DEVICE_ID);

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);
41: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
42: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',P_ORGANIZATION_ID);
43:

Line 40: FND_MESSAGE.SET_TOKEN('DEVICE_NAME',l_device_name);

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

Line 41: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);

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

Line 42: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',P_ORGANIZATION_ID);

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);
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:

Line 67: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_UNEXPECTED_DB_ERR');

63: EXCEPTION
64: WHEN OTHERS THEN
65: ROLLBACK;
66: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
67: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_UNEXPECTED_DB_ERR');
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);

Line 68: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

64: WHEN OTHERS THEN
65: ROLLBACK;
66: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
67: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_UNEXPECTED_DB_ERR');
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

Line 69: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);

65: ROLLBACK;
66: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
67: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_UNEXPECTED_DB_ERR');
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);

Line 92: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_UNLOCK_DEVICE_MSG');

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);
95: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',P_ORGANIZATION_ID);
96:

Line 93: FND_MESSAGE.SET_TOKEN('DEVICE_ID',P_DEVICE_ID);

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

Line 94: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);

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

Line 95: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',P_ORGANIZATION_ID);

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);
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:

Line 115: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_UNEXPECTED_DB_ERR');

111: EXCEPTION
112: WHEN OTHERS THEN
113: ROLLBACK;
114: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
115: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_UNEXPECTED_DB_ERR');
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);

Line 116: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

112: WHEN OTHERS THEN
113: ROLLBACK;
114: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
115: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_UNEXPECTED_DB_ERR');
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

Line 117: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);

113: ROLLBACK;
114: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
115: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_UNEXPECTED_DB_ERR');
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);

Line 189: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_CLEANUP_DATA_MSG');

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);
192: end if;
193:

Line 190: FND_MESSAGE.SET_TOKEN('CLEANUP_TO_DATE',P_CLEANUP_TO_DATE);

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);
192: end if;
193:
194: DELETE FROM GMO_DEVICE_RESPONSES_T WHERE REQUEST_ID IN

Line 202: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_CLEANUP_SUCCESS_MSG');

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;
205:
206: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

Line 210: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_UNEXPECTED_DB_ERR');

206: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
207: EXCEPTION
208: WHEN OTHERS THEN
209: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
210: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_UNEXPECTED_DB_ERR');
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);

Line 211: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

207: EXCEPTION
208: WHEN OTHERS THEN
209: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
210: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_UNEXPECTED_DB_ERR');
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

Line 212: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);

208: WHEN OTHERS THEN
209: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
210: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_UNEXPECTED_DB_ERR');
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);

Line 264: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_REQUEST_COMP_OPRN_MSG');

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);
268: FND_MESSAGE.SET_TOKEN('COMPONENT_VALUE',P_RESP_COMP_CODE_VALUE);

Line 265: FND_MESSAGE.SET_TOKEN('ACTION', P_ACTION);

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

Line 266: FND_MESSAGE.SET_TOKEN('REQUEST_ID',P_REQUEST_ID);

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

Line 267: FND_MESSAGE.SET_TOKEN('COMPONENT',P_RESP_COMP_CODE);

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);
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:

Line 268: FND_MESSAGE.SET_TOKEN('COMPONENT_VALUE',P_RESP_COMP_CODE_VALUE);

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

Line 278: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_REQUEST_COMP_OPRN_ERR');

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);
282: FND_MESSAGE.SET_TOKEN('COMPONENT_VALUE',P_RESP_COMP_CODE_VALUE);

Line 279: FND_MESSAGE.SET_TOKEN('ACTION', P_ACTION);

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

Line 280: FND_MESSAGE.SET_TOKEN('REQUEST_ID',P_REQUEST_ID);

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

Line 281: FND_MESSAGE.SET_TOKEN('COMPONENT',P_RESP_COMP_CODE);

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

Line 282: FND_MESSAGE.SET_TOKEN('COMPONENT_VALUE',P_RESP_COMP_CODE_VALUE);

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

Line 321: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_REQUEST_OPRN_MSG');

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);
325: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);

Line 322: FND_MESSAGE.SET_TOKEN('ACTION', P_ACTION);

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);
325: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
326: FND_MESSAGE.SET_TOKEN('DEVICE_STATUS',P_DEVICE_STATUS);

Line 323: FND_MESSAGE.SET_TOKEN('REQUEST_ID',P_REQUEST_ID);

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

Line 324: FND_MESSAGE.SET_TOKEN('DEVICE_ID',P_DEVICE_ID);

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

Line 325: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);

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);
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:

Line 326: FND_MESSAGE.SET_TOKEN('DEVICE_STATUS',P_DEVICE_STATUS);

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

Line 336: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_REQUEST_OPRN_ERR');

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);
340: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);

Line 337: FND_MESSAGE.SET_TOKEN('ACTION', P_ACTION);

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);
340: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);
341: FND_MESSAGE.SET_TOKEN('DEVICE_STATUS',P_DEVICE_STATUS);

Line 338: FND_MESSAGE.SET_TOKEN('REQUEST_ID',P_REQUEST_ID);

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

Line 339: FND_MESSAGE.SET_TOKEN('DEVICE_ID',P_DEVICE_ID);

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

Line 340: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);

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

Line 341: FND_MESSAGE.SET_TOKEN('DEVICE_STATUS',P_DEVICE_STATUS);

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

Line 404: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_READ_COMPONENT_MSG');

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);
407: end if;
408:

Line 405: FND_MESSAGE.SET_TOKEN('COMPONENT',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);
407: end if;
408:
409: l_msg_component.extend;

Line 415: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_READ_COMPONENT_MSG');

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);
418: end if;
419:

Line 416: FND_MESSAGE.SET_TOKEN('COMPONENT',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);
418: end if;
419:
420: else

Line 519: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_PARAM_MAP_ERR');

515:
516: EXCEPTION
517: WHEN L_PARAMETER_MAP_ERR THEN
518: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
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

Line 520: FND_MESSAGE.SET_TOKEN('PARAMS',l_param_error);

516: EXCEPTION
517: WHEN L_PARAMETER_MAP_ERR THEN
518: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
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);

Line 529: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_PARAM_UOM_MISMATCH_ERR');

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;
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

Line 530: FND_MESSAGE.SET_TOKEN('PARAMS',l_param_error);

526: -- APP_EXCEPTION.RAISE_EXCEPTION;
527: WHEN L_UOM_MISMATCH_ERR THEN
528: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
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);

Line 539: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_UNEXPECTED_DB_ERR');

535: end if;
536: -- APP_EXCEPTION.RAISE_EXCEPTION;
537: WHEN OTHERS THEN
538: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
539: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_UNEXPECTED_DB_ERR');
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);

Line 540: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

536: -- APP_EXCEPTION.RAISE_EXCEPTION;
537: WHEN OTHERS THEN
538: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
539: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_UNEXPECTED_DB_ERR');
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

Line 541: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);

537: WHEN OTHERS THEN
538: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
539: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_UNEXPECTED_DB_ERR');
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);

Line 608: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_READ_DEVICE_MSG');

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

Line 609: FND_MESSAGE.SET_TOKEN('DEVICE_ID',P_DEVICE_ID);

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

Line 610: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',P_ORGANIZATION_ID);

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);
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:

Line 611: FND_MESSAGE.SET_TOKEN('REQUESTER',P_REQUESTER);

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

Line 624: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_WCS_ORG_ENABLED_MSG');

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);
627: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.read_device', FALSE);
628: end if;

Line 625: FND_MESSAGE.SET_TOKEN('ORGANIZATION_ID',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);
627: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.read_device', FALSE);
628: end if;
629:

Line 626: FND_MESSAGE.SET_TOKEN('ENABLED_FLAG',l_wcs_enabled);

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

Line 648: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_OUTPUT_METHOD_MSG');

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);
651: FND_MESSAGE.SET_TOKEN('OUTPUT_METHOD',l_output_method);
652: FND_MESSAGE.SET_TOKEN('OUTPUT_METHOD_ID',l_output_method_id);

Line 649: FND_MESSAGE.SET_TOKEN('DEVICE_ID',P_DEVICE_ID);

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

Line 650: FND_MESSAGE.SET_TOKEN('DEVICE',l_device_name);

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

Line 651: FND_MESSAGE.SET_TOKEN('OUTPUT_METHOD',l_output_method);

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

Line 652: FND_MESSAGE.SET_TOKEN('OUTPUT_METHOD_ID',l_output_method_id);

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);
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:

Line 653: FND_MESSAGE.SET_TOKEN('SUBINVENTORY', l_subinventory);

649: FND_MESSAGE.SET_TOKEN('DEVICE_ID',P_DEVICE_ID);
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).

Line 664: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_REQUEST_ID_MSG');

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);
667: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.read_device', FALSE);
668: end if;

Line 665: FND_MESSAGE.SET_TOKEN('DEVICE_ID',P_DEVICE_ID);

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);
667: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.read_device', FALSE);
668: end if;
669:

Line 666: FND_MESSAGE.SET_TOKEN('REQUEST_ID',l_request_id);

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);
667: FND_LOG.MESSAGE(FND_LOG.LEVEL_EVENT,'gmo.plsql.gmo_dvc_intg_pvt.read_device', FALSE);
668: end if;
669:
670:

Line 716: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_READ_DEVICE_STATUS_MSG');

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);
720: end if;

Line 717: FND_MESSAGE.SET_TOKEN('DEVICE_ID',P_DEVICE_ID);

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);
720: end if;
721:

Line 718: FND_MESSAGE.SET_TOKEN('DEVICE_STATUS',l_return_status);

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

Line 739: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_TIMEOUT_VALUE_MSG');

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);
742: end if;
743:

Line 740: FND_MESSAGE.SET_TOKEN('TIMEOUT',l_profile_value);

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);
742: end if;
743:
744:

Line 758: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_RESPONSE_RECD_MSG');

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

Line 767: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_READ_TIMEOUT_MSG');

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;
771:

Line 807: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_NO_MSG_COMP_ERR');

803:
804: EXCEPTION
805: WHEN L_NO_MSG_COMPONENTS_ERR 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);

Line 816: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_WCS_DISABLED_ORG_ERR');

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;
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

Line 817: FND_MESSAGE.SET_TOKEN('ORGN',L_ORG_CODE);

813: -- APP_EXCEPTION.RAISE_EXCEPTION;
814: WHEN L_WCS_DISABLED_ERR THEN
815: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
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);

Line 826: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_OUTPUT_METHOD_ERR');

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;
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

Line 827: FND_MESSAGE.SET_TOKEN('DEVICE',L_DEVICE_NAME);

823: -- APP_EXCEPTION.RAISE_EXCEPTION;
824: WHEN L_DEVICE_OP_METHOD_ERR THEN
825: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
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);

Line 840: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_LOCK_DEVICE_ERR');

836: UNLOCK_DEVICE(P_DEVICE_ID => P_DEVICE_ID, P_REQUESTER => P_REQUESTER, P_ORGANIZATION_ID => P_ORGANIZATION_ID,
837: X_RETURN_STATUS => l_return_status, X_MSG_COUNT => l_msg_count, X_MSG_DATA => l_msg_data);
838: end if;
839: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
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

Line 841: FND_MESSAGE.SET_TOKEN('DEVICE',L_DEVICE_NAME);

837: X_RETURN_STATUS => l_return_status, X_MSG_COUNT => l_msg_count, X_MSG_DATA => l_msg_data);
838: end if;
839: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
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);

Line 854: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_SUBINV_DEVICE_ERR');

850: UNLOCK_DEVICE(P_DEVICE_ID => P_DEVICE_ID, P_REQUESTER => P_REQUESTER, P_ORGANIZATION_ID => P_ORGANIZATION_ID,
851: X_RETURN_STATUS => l_return_status, X_MSG_COUNT => l_msg_count, X_MSG_DATA => l_msg_data);
852: end if;
853: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
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

Line 855: FND_MESSAGE.SET_TOKEN('DEVICE',L_DEVICE_NAME);

851: X_RETURN_STATUS => l_return_status, X_MSG_COUNT => l_msg_count, X_MSG_DATA => l_msg_data);
852: end if;
853: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
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);

Line 868: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_READ_DEVICE_ERR');

864: UNLOCK_DEVICE(P_DEVICE_ID => P_DEVICE_ID, P_REQUESTER => P_REQUESTER, P_ORGANIZATION_ID => P_ORGANIZATION_ID,
865: X_RETURN_STATUS => l_return_status, X_MSG_COUNT => l_msg_count, X_MSG_DATA => l_msg_data);
866: end if;
867: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
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

Line 869: FND_MESSAGE.SET_TOKEN('DEVICE',L_DEVICE_NAME);

865: X_RETURN_STATUS => l_return_status, X_MSG_COUNT => l_msg_count, X_MSG_DATA => l_msg_data);
866: end if;
867: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
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);

Line 882: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_READ_TIMEOUT_ERR');

878: UNLOCK_DEVICE(P_DEVICE_ID => P_DEVICE_ID, P_REQUESTER => P_REQUESTER, P_ORGANIZATION_ID => P_ORGANIZATION_ID,
879: X_RETURN_STATUS => l_return_status, X_MSG_COUNT => l_msg_count, X_MSG_DATA => l_msg_data);
880: end if;
881: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
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

Line 883: FND_MESSAGE.SET_TOKEN('DEVICE',L_DEVICE_NAME);

879: X_RETURN_STATUS => l_return_status, X_MSG_COUNT => l_msg_count, X_MSG_DATA => l_msg_data);
880: end if;
881: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
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);

Line 896: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_RESPONSE_ERR');

892: UNLOCK_DEVICE(P_DEVICE_ID => P_DEVICE_ID, P_REQUESTER => P_REQUESTER, P_ORGANIZATION_ID => P_ORGANIZATION_ID,
893: X_RETURN_STATUS => l_return_status, X_MSG_COUNT => l_msg_count, X_MSG_DATA => l_msg_data);
894: end if;
895: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
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

Line 897: FND_MESSAGE.SET_TOKEN('DEVICE',L_DEVICE_NAME);

893: X_RETURN_STATUS => l_return_status, X_MSG_COUNT => l_msg_count, X_MSG_DATA => l_msg_data);
894: end if;
895: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
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);

Line 910: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_UNLOCK_DEVICE_ERR');

906: UNLOCK_DEVICE(P_DEVICE_ID => P_DEVICE_ID, P_REQUESTER => P_REQUESTER, P_ORGANIZATION_ID => P_ORGANIZATION_ID,
907: X_RETURN_STATUS => l_return_status, X_MSG_COUNT => l_msg_count, X_MSG_DATA => l_msg_data);
908: end if;
909: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
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

Line 911: FND_MESSAGE.SET_TOKEN('DEVICE',L_DEVICE_NAME);

907: X_RETURN_STATUS => l_return_status, X_MSG_COUNT => l_msg_count, X_MSG_DATA => l_msg_data);
908: end if;
909: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
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);

Line 924: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_UNEXPECTED_DB_ERR');

920: UNLOCK_DEVICE(P_DEVICE_ID => P_DEVICE_ID, P_REQUESTER => P_REQUESTER, P_ORGANIZATION_ID => P_ORGANIZATION_ID,
921: X_RETURN_STATUS => l_return_status, X_MSG_COUNT => l_msg_count, X_MSG_DATA => l_msg_data);
922: end if;
923: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
924: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_UNEXPECTED_DB_ERR');
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);

Line 925: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

921: X_RETURN_STATUS => l_return_status, X_MSG_COUNT => l_msg_count, X_MSG_DATA => l_msg_data);
922: end if;
923: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
924: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_UNEXPECTED_DB_ERR');
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

Line 926: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);

922: end if;
923: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
924: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_UNEXPECTED_DB_ERR');
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);

Line 952: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_PROCESS_RESPONSE_MSG');

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);
956: end if;

Line 953: FND_MESSAGE.SET_TOKEN('REQUEST_ID',P_REQUEST_ID);

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);
956: end if;
957:

Line 954: FND_MESSAGE.SET_TOKEN('DEVICE_ID',P_DEVICE_ID);

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

Line 1030: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_REQUEST_FOR_RESP_ERR');

1026:
1027: EXCEPTION
1028: WHEN L_REQUEST_NOT_FOUND_ERR THEN
1029: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1030: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_REQUEST_FOR_RESP_ERR');
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);

Line 1031: FND_MESSAGE.SET_TOKEN('REQUEST_ID',P_REQUEST_ID);

1027: EXCEPTION
1028: WHEN L_REQUEST_NOT_FOUND_ERR THEN
1029: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1030: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_REQUEST_FOR_RESP_ERR');
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

Line 1032: FND_MESSAGE.SET_TOKEN('DEVICE_ID',P_DEVICE_ID);

1028: WHEN L_REQUEST_NOT_FOUND_ERR THEN
1029: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
1030: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_REQUEST_FOR_RESP_ERR');
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);

Line 1040: FND_MESSAGE.SET_NAME('GMO','GMO_DVC_UNEXPECTED_DB_ERR');

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

Line 1041: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);

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

Line 1042: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);

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