APPS.OKE_CHECK_HOLD_PKG dependencies on OKE_API

Line 119: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;

115: p_k_line_id IN NUMBER,
116: p_deliverable_id IN NUMBER)
117: RETURN BOOLEAN IS
118:
119: l_return_status VARCHAR2(1) := OKE_API.G_RET_STS_SUCCESS;
120: l_api_name CONSTANT VARCHAR2(30) := 'IS_HOLD';
121: l_api_version CONSTANT NUMBER := 1.0;
122:
123: BEGIN

Line 125: x_return_status := OKE_API.G_RET_STS_SUCCESS;

121: l_api_version CONSTANT NUMBER := 1.0;
122:
123: BEGIN
124:
125: x_return_status := OKE_API.G_RET_STS_SUCCESS;
126: x_msg_count := 0;
127: x_msg_data := NULL;
128: -- call START_ACTIVITY to create savepoint, check compatibility
129: -- and initialize message list

Line 130: l_return_status := OKE_API.START_ACTIVITY(

126: x_msg_count := 0;
127: x_msg_data := NULL;
128: -- call START_ACTIVITY to create savepoint, check compatibility
129: -- and initialize message list
130: l_return_status := OKE_API.START_ACTIVITY(
131: p_api_name => l_api_name,
132: p_pkg_name => g_pkg_name,
133: p_init_msg_list => p_init_msg_list,
134: l_api_version => l_api_version,

Line 140: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then

136: p_api_type => g_api_type,
137: x_return_status => x_return_status);
138:
139: -- check if activity started successfully
140: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
141: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
142: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
143: raise OKE_API.G_EXCEPTION_ERROR;
144: End If;

Line 141: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;

137: x_return_status => x_return_status);
138:
139: -- check if activity started successfully
140: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
141: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
142: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
143: raise OKE_API.G_EXCEPTION_ERROR;
144: End If;
145:

Line 142: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then

138:
139: -- check if activity started successfully
140: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
141: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
142: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
143: raise OKE_API.G_EXCEPTION_ERROR;
144: End If;
145:
146:

Line 143: raise OKE_API.G_EXCEPTION_ERROR;

139: -- check if activity started successfully
140: If (l_return_status = OKE_API.G_RET_STS_UNEXP_ERROR) then
141: raise OKE_API.G_EXCEPTION_UNEXPECTED_ERROR;
142: Elsif (l_return_status = OKE_API.G_RET_STS_ERROR) then
143: raise OKE_API.G_EXCEPTION_ERROR;
144: End If;
145:
146:
147: if (p_hold_level = 'LINE')