DBA Data[Home] [Help]

APPS.GMO_WMS_INTEGRATION_GRP dependencies on FND_API

Line 15: -- p_init_msg_list in varchar2 default fnd_api.g_false,

11: -- Function : Process device response
12: -- Pre-reqs : None.
13: -- Parameters :
14: -- IN : p_api_version in number,
15: -- p_init_msg_list in varchar2 default fnd_api.g_false,
16: -- p_commit in varchar2 default fnd_api.g_false,
17: -- p_validation_level in number default fnd_api.g_valid_level_full,
18: -- p_request_id in number
19: -- p_device_id in number

Line 16: -- p_commit in varchar2 default fnd_api.g_false,

12: -- Pre-reqs : None.
13: -- Parameters :
14: -- IN : p_api_version in number,
15: -- p_init_msg_list in varchar2 default fnd_api.g_false,
16: -- p_commit in varchar2 default fnd_api.g_false,
17: -- p_validation_level in number default fnd_api.g_valid_level_full,
18: -- p_request_id in number
19: -- p_device_id in number
20: -- p_param_values_record in wms_wcs_device_grp.msg_component_lookup_type

Line 17: -- p_validation_level in number default fnd_api.g_valid_level_full,

13: -- Parameters :
14: -- IN : p_api_version in number,
15: -- p_init_msg_list in varchar2 default fnd_api.g_false,
16: -- p_commit in varchar2 default fnd_api.g_false,
17: -- p_validation_level in number default fnd_api.g_valid_level_full,
18: -- p_request_id in number
19: -- p_device_id in number
20: -- p_param_values_record in wms_wcs_device_grp.msg_component_lookup_type
21: -- OUT : x_return_status out varchar2

Line 29: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,

25:
26: PROCEDURE PROCESS_DEVICE_RESPONSE (
27:
28: P_API_VERSION IN NUMBER,
29: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
30: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
31: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
32: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
33: X_MSG_COUNT OUT NOCOPY NUMBER,

Line 30: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,

26: PROCEDURE PROCESS_DEVICE_RESPONSE (
27:
28: P_API_VERSION IN NUMBER,
29: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
30: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
31: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
32: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
33: X_MSG_COUNT OUT NOCOPY NUMBER,
34: X_MSG_DATA OUT NOCOPY VARCHAR2,

Line 31: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,

27:
28: P_API_VERSION IN NUMBER,
29: P_INIT_MSG_LIST IN VARCHAR2 DEFAULT FND_API.G_FALSE,
30: P_COMMIT IN VARCHAR2 DEFAULT FND_API.G_FALSE,
31: P_VALIDATION_LEVEL IN NUMBER DEFAULT FND_API.G_VALID_LEVEL_FULL,
32: X_RETURN_STATUS OUT NOCOPY VARCHAR2,
33: X_MSG_COUNT OUT NOCOPY NUMBER,
34: X_MSG_DATA OUT NOCOPY VARCHAR2,
35: P_REQUEST_ID IN NUMBER,

Line 49: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN

45: -- Standard Start of API savepoint
46: SAVEPOINT PROCESS_DEVICE_RESPONSE_GRP;
47:
48: -- Standard call to check for call compatibility.
49: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
52:
53: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

46: SAVEPOINT PROCESS_DEVICE_RESPONSE_GRP;
47:
48: -- Standard call to check for call compatibility.
49: IF NOT FND_API.Compatible_API_Call (l_api_version, p_api_version,l_api_name,G_PKG_NAME) THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
52:
53: -- Initialize message list if p_init_msg_list is set to TRUE.
54: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 54: IF FND_API.to_Boolean( p_init_msg_list ) THEN

50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
52:
53: -- Initialize message list if p_init_msg_list is set to TRUE.
54: IF FND_API.to_Boolean( p_init_msg_list ) THEN
55: FND_MSG_PUB.initialize;
56: END IF;
57:
58: -- Initialize API return status to success

Line 59: x_return_status := FND_API.G_RET_STS_SUCCESS;

55: FND_MSG_PUB.initialize;
56: END IF;
57:
58: -- Initialize API return status to success
59: x_return_status := FND_API.G_RET_STS_SUCCESS;
60:
61: GMO_DVC_INTG_PVT.PROCESS_DEVICE_RESPONSE (
62: P_REQUEST_ID => P_REQUEST_ID ,
63: P_DEVICE_ID => P_DEVICE_ID ,

Line 69: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

65: X_RETURN_STATUS => X_RETURN_STATUS,
66: X_MSG_COUNT => X_MSG_COUNT,
67: X_MSG_DATA => X_MSG_DATA);
68:
69: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
70: IF FND_API.To_Boolean( p_commit ) THEN
71: COMMIT ;
72: END IF;
73: ELSE

Line 70: IF FND_API.To_Boolean( p_commit ) THEN

66: X_MSG_COUNT => X_MSG_COUNT,
67: X_MSG_DATA => X_MSG_DATA);
68:
69: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
70: IF FND_API.To_Boolean( p_commit ) THEN
71: COMMIT ;
72: END IF;
73: ELSE
74: RAISE FND_API.G_EXC_ERROR;

Line 74: RAISE FND_API.G_EXC_ERROR;

70: IF FND_API.To_Boolean( p_commit ) THEN
71: COMMIT ;
72: END IF;
73: ELSE
74: RAISE FND_API.G_EXC_ERROR;
75: END IF;
76:
77: -- Standard call to get message count and if count is 1, get message info.
78: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);

Line 81: WHEN FND_API.G_EXC_ERROR THEN

77: -- Standard call to get message count and if count is 1, get message info.
78: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
79:
80: EXCEPTION
81: WHEN FND_API.G_EXC_ERROR THEN
82: ROLLBACK TO PROCESS_DEVICE_RESPONSE_GRP;
83: x_return_status := FND_API.G_RET_STS_ERROR;
84: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
85: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 83: x_return_status := FND_API.G_RET_STS_ERROR;

79:
80: EXCEPTION
81: WHEN FND_API.G_EXC_ERROR THEN
82: ROLLBACK TO PROCESS_DEVICE_RESPONSE_GRP;
83: x_return_status := FND_API.G_RET_STS_ERROR;
84: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
85: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
86: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_wms_integration_grp.process_device_response', FALSE);
87: end if;

Line 88: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

84: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
85: if (FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
86: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_wms_integration_grp.process_device_response', FALSE);
87: end if;
88: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
89: ROLLBACK TO PROCESS_DEVICE_RESPONSE_GRP;
90: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
91: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
92: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

Line 90: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

86: FND_LOG.MESSAGE(FND_LOG.LEVEL_EXCEPTION,'gmo.plsql.gmo_wms_integration_grp.process_device_response', FALSE);
87: end if;
88: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
89: ROLLBACK TO PROCESS_DEVICE_RESPONSE_GRP;
90: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
91: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);
92: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
93: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_wms_integration_grp.process_device_response', FALSE);
94: end if;

Line 97: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

93: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED,'gmo.plsql.gmo_wms_integration_grp.process_device_response', FALSE);
94: end if;
95: WHEN OTHERS THEN
96: ROLLBACK TO PROCESS_DEVICE_RESPONSE_GRP;
97: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
98: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
99: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_api_name);
100: END IF;
101: FND_MSG_PUB.Count_And_Get (p_count => x_msg_count, p_data => x_msg_data);