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_API

Line 66: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

62: COMMIT;
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;

Line 114: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

110: COMMIT;
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;

Line 141: P_INIT_MSG_LIST => fnd_api.g_false,

137:
138: BEGIN
139: WMS_WCS_DEVICE_GRP.DEVICE_REQUEST
140: (
141: P_INIT_MSG_LIST => fnd_api.g_false,
142: P_BUS_EVENT => P_BUS_EVENT,
143: P_CALL_CTX => 'U',
144: P_TASK_TRX_ID => NULL,
145: P_ORG_ID => P_ORG_ID,

Line 206: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

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

Line 209: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 313: RESPONSE_STATUS = FND_API.G_RET_STS_SUCCESS,

309:
310: ELSIF (P_ACTION = ACTION_UPDATE_DEVICE_RESPONSE) then
311: -- update process_device_response
312: UPDATE GMO_DEVICE_REQUESTS_T SET
313: RESPONSE_STATUS = FND_API.G_RET_STS_SUCCESS,
314: LAST_UPDATE_DATE = sysdate,
315: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
316: LAST_UPDATED_BY = FND_GLOBAL.USER_ID
317: WHERE REQUEST_ID = P_REQUEST_ID AND DEVICE_ID = P_DEVICE_ID;

Line 459: IF (X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS) THEN

455:
456: X_PARAMETER_UOM := fnd_table_of_varchar2_255();
457: X_PARAMETER_VALUE := fnd_table_of_varchar2_255();
458:
459: IF (X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS) THEN
460:
461: l_uom_counter := 0;
462: l_value_counter := 0;
463:

Line 518: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

Line 528: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

Line 538: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 683: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

679: X_SUBINVENTORY => l_subinventory,
680: X_RETURN_STATUS => l_return_status,
681: X_MSG_COUNT => l_msg_count,
682: X_MSG_DATA => l_msg_data);
683: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
684: RAISE L_LOCK_DEVICE_ERR;
685: end if;
686: end if;
687:

Line 725: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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;
724:
725: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
726: RAISE l_read_device_err;
727: end if;
728:
729: L_DEVICE_REQUEST_END := FALSE;

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

Line 786: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

782: P_ORGANIZATION_ID => P_ORGANIZATION_ID,
783: X_RETURN_STATUS => l_return_status,
784: X_MSG_COUNT => l_msg_count,
785: X_MSG_DATA => l_msg_data);
786: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
787: RAISE L_UNLOCK_DEVICE_ERR;
788: end if;
789: end if;
790:

Line 802: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

798: X_VALUE(K) := l_response_value;
799:
800: END LOOP;
801:
802: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
803:
804: EXCEPTION
805: WHEN L_NO_MSG_COMPONENTS_ERR THEN
806: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 806: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

Line 815: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

Line 825: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

Line 839: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

835: if (l_is_device_locked = true) then
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);

Line 853: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

849: if (l_is_device_locked = true) then
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);

Line 867: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

863: if (l_is_device_locked = true) then
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);

Line 881: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

877: if (l_is_device_locked = true) then
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);

Line 895: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

891: if (l_is_device_locked = true) then
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);

Line 909: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

905: if (l_is_device_locked = true) then
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);

Line 923: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

919: if (l_is_device_locked = true) then
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;

Line 1025: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

1021:
1022: -- update process_device_response
1023: POST_REQUEST (P_ACTION => ACTION_UPDATE_DEVICE_RESPONSE, P_REQUEST_ID => P_REQUEST_ID, P_DEVICE_ID => P_DEVICE_ID , P_REQUESTER => FND_GLOBAL.USER_ID , P_DEVICE_STATUS => '');
1024:
1025: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
1026:
1027: EXCEPTION
1028: WHEN L_REQUEST_NOT_FOUND_ERR THEN
1029: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 1029: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

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

Line 1039: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

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');
1041: FND_MESSAGE.SET_TOKEN('ERROR_TEXT',SQLERRM);
1042: FND_MESSAGE.SET_TOKEN('ERROR_CODE',SQLCODE);
1043: FND_MSG_PUB.ADD;