3: -------------------------------------------------------------------------------------------------
4: -- GLOBAL MESSAGE CONSTANTS
5: -------------------------------------------------------------------------------------------------
6: G_INVALID_CRITERIA CONSTANT VARCHAR2(200) := 'OKL_LLA_INVALID_CRITERIA';
7: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
8: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
9: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
4: -- GLOBAL MESSAGE CONSTANTS
5: -------------------------------------------------------------------------------------------------
6: G_INVALID_CRITERIA CONSTANT VARCHAR2(200) := 'OKL_LLA_INVALID_CRITERIA';
7: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
8: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
9: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
5: -------------------------------------------------------------------------------------------------
6: G_INVALID_CRITERIA CONSTANT VARCHAR2(200) := 'OKL_LLA_INVALID_CRITERIA';
7: G_FND_APP CONSTANT VARCHAR2(200) := OKL_API.G_FND_APP;
8: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKL_API.G_INVALID_VALUE;
9: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKL_API.G_COL_NAME_TOKEN;
10: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_CONTRACTS_UNEXP_ERROR';
11: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
12: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
13: -------------------------------------------------------------------------------------------------
29: -------------------------------------------------------------------------------------------------
30: -- GLOBAL VARIABLES
31: -------------------------------------------------------------------------------------------------
32: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_DEAL_ASSET_PVT';
33: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
34: -------------------------------------------------------------------------------------------------
35:
36: FUNCTION get_fee_service_name(
37: p_chr_id IN NUMBER,
151: END;
152:
153: PROCEDURE load_payment_header(
154: p_api_version IN NUMBER,
155: p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
156: x_return_status OUT NOCOPY VARCHAR2,
157: x_msg_count OUT NOCOPY NUMBER,
158: x_msg_data OUT NOCOPY VARCHAR2,
159: p_chr_id IN NUMBER,
203: l_asset_number OKC_K_LINES_TL.name%TYPE;
204: l_asset_description OKC_K_LINES_TL.item_description%TYPE;
205:
206: BEGIN
207: x_return_status := OKL_API.G_RET_STS_SUCCESS;
208: -- Call start_activity to create savepoint, check compatibility and initialize message list
209: x_return_status := OKL_API.START_ACTIVITY(
210: p_api_name => l_api_name,
211: p_pkg_name => g_pkg_name,
205:
206: BEGIN
207: x_return_status := OKL_API.G_RET_STS_SUCCESS;
208: -- Call start_activity to create savepoint, check compatibility and initialize message list
209: x_return_status := OKL_API.START_ACTIVITY(
210: p_api_name => l_api_name,
211: p_pkg_name => g_pkg_name,
212: p_init_msg_list => p_init_msg_list,
213: l_api_version => l_api_version,
215: p_api_type => g_api_type,
216: x_return_status => x_return_status);
217:
218: -- check if activity started successfully
219: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
220: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
221: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
222: RAISE OKL_API.G_EXCEPTION_ERROR;
223: END IF;
216: x_return_status => x_return_status);
217:
218: -- check if activity started successfully
219: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
220: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
221: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
222: RAISE OKL_API.G_EXCEPTION_ERROR;
223: END IF;
224:
217:
218: -- check if activity started successfully
219: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
220: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
221: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
222: RAISE OKL_API.G_EXCEPTION_ERROR;
223: END IF;
224:
225: l_service_fee_cle_id := NULL;
218: -- check if activity started successfully
219: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
220: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
221: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
222: RAISE OKL_API.G_EXCEPTION_ERROR;
223: END IF;
224:
225: l_service_fee_cle_id := NULL;
226: l_service_fee_name := NULL;
276: x_asset_cle_id := l_asset_cle_id;
277: x_asset_number := l_asset_number;
278: x_asset_description := l_asset_description;
279:
280: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
281:
282: EXCEPTION
283: WHEN OKL_API.G_EXCEPTION_ERROR THEN
284: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
279:
280: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
281:
282: EXCEPTION
283: WHEN OKL_API.G_EXCEPTION_ERROR THEN
284: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
285: p_api_name => l_api_name,
286: p_pkg_name => g_pkg_name,
287: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
280: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
281:
282: EXCEPTION
283: WHEN OKL_API.G_EXCEPTION_ERROR THEN
284: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
285: p_api_name => l_api_name,
286: p_pkg_name => g_pkg_name,
287: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
288: x_msg_count => x_msg_count,
283: WHEN OKL_API.G_EXCEPTION_ERROR THEN
284: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
285: p_api_name => l_api_name,
286: p_pkg_name => g_pkg_name,
287: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
288: x_msg_count => x_msg_count,
289: x_msg_data => x_msg_data,
290: p_api_type => g_api_type);
291:
288: x_msg_count => x_msg_count,
289: x_msg_data => x_msg_data,
290: p_api_type => g_api_type);
291:
292: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
293: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
294: p_api_name => l_api_name,
295: p_pkg_name => g_pkg_name,
296: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
289: x_msg_data => x_msg_data,
290: p_api_type => g_api_type);
291:
292: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
293: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
294: p_api_name => l_api_name,
295: p_pkg_name => g_pkg_name,
296: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
297: x_msg_count => x_msg_count,
292: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
293: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
294: p_api_name => l_api_name,
295: p_pkg_name => g_pkg_name,
296: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
297: x_msg_count => x_msg_count,
298: x_msg_data => x_msg_data,
299: p_api_type => g_api_type);
300:
298: x_msg_data => x_msg_data,
299: p_api_type => g_api_type);
300:
301: WHEN OTHERS THEN
302: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
303: p_api_name => l_api_name,
304: p_pkg_name => g_pkg_name,
305: p_exc_name => 'OTHERS',
306: x_msg_count => x_msg_count,