DBA Data[Home] [Help]

APPS.OKL_UPDT_CASH_DTLS dependencies on OKC_API

Line 9: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

5: -- PROCEDURE update_cash_details
6: ---------------------------------------------------------------------------
7:
8: PROCEDURE update_cash_details ( p_api_version IN NUMBER
9: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
10: ,x_return_status OUT NOCOPY VARCHAR2
11: ,x_msg_count OUT NOCOPY NUMBER
12: ,x_msg_data OUT NOCOPY VARCHAR2
13: ,p_strm_tbl IN okl_cash_dtls_tbl_type

Line 50: l_init_msg_list VARCHAR2(1) := Okc_Api.g_false;

46: i NUMBER DEFAULT NULL;
47: j NUMBER DEFAULT NULL;
48:
49: l_api_version NUMBER := 1.0;
50: l_init_msg_list VARCHAR2(1) := Okc_Api.g_false;
51: l_return_status VARCHAR2(1);
52: l_msg_count NUMBER;
53: l_msg_data VARCHAR2(2000);
54:

Line 147: x_return_status := OKC_API.G_RET_STS_ERROR;

143:
144: IF l_strm_tbl.COUNT = 0 THEN
145:
146: -- Message Text: no allocation required ...
147: x_return_status := OKC_API.G_RET_STS_ERROR;
148: OKC_API.set_message( p_app_name => G_APP_NAME,
149: p_msg_name =>'OKL_BPD_NO_ALLOC_REQ');
150:
151: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 148: OKC_API.set_message( p_app_name => G_APP_NAME,

144: IF l_strm_tbl.COUNT = 0 THEN
145:
146: -- Message Text: no allocation required ...
147: x_return_status := OKC_API.G_RET_STS_ERROR;
148: OKC_API.set_message( p_app_name => G_APP_NAME,
149: p_msg_name =>'OKL_BPD_NO_ALLOC_REQ');
150:
151: RAISE G_EXCEPTION_HALT_VALIDATION;
152:

Line 247: x_return_status := OKC_API.G_RET_STS_ERROR;

243: END LOOP;
244:
245: IF l_func_rcpt_amount < l_total_amount_applied THEN -- in functional currency ...
246: -- Message Text: the amount applied must be equal or less than receipt amount
247: x_return_status := OKC_API.G_RET_STS_ERROR;
248: OKC_API.set_message( p_app_name => G_APP_NAME,
249: p_msg_name =>'OKL_BPD_RCPT_ALLOC_ERR');
250:
251: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 248: OKC_API.set_message( p_app_name => G_APP_NAME,

244:
245: IF l_func_rcpt_amount < l_total_amount_applied THEN -- in functional currency ...
246: -- Message Text: the amount applied must be equal or less than receipt amount
247: x_return_status := OKC_API.G_RET_STS_ERROR;
248: OKC_API.set_message( p_app_name => G_APP_NAME,
249: p_msg_name =>'OKL_BPD_RCPT_ALLOC_ERR');
250:
251: RAISE G_EXCEPTION_HALT_VALIDATION;
252: END IF;

Line 494: x_return_status := OKC_API.G_RET_STS_ERROR;

490:
491: EXCEPTION
492:
493: WHEN G_EXCEPTION_HALT_VALIDATION THEN
494: x_return_status := OKC_API.G_RET_STS_ERROR;
495:
496:
497: WHEN OKC_API.G_EXCEPTION_ERROR THEN
498: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 497: WHEN OKC_API.G_EXCEPTION_ERROR THEN

493: WHEN G_EXCEPTION_HALT_VALIDATION THEN
494: x_return_status := OKC_API.G_RET_STS_ERROR;
495:
496:
497: WHEN OKC_API.G_EXCEPTION_ERROR THEN
498: x_return_status := OKC_API.HANDLE_EXCEPTIONS
499: (
500: l_api_name,
501: G_PKG_NAME,

Line 498: x_return_status := OKC_API.HANDLE_EXCEPTIONS

494: x_return_status := OKC_API.G_RET_STS_ERROR;
495:
496:
497: WHEN OKC_API.G_EXCEPTION_ERROR THEN
498: x_return_status := OKC_API.HANDLE_EXCEPTIONS
499: (
500: l_api_name,
501: G_PKG_NAME,
502: 'OKC_API.G_RET_STS_ERROR',

Line 502: 'OKC_API.G_RET_STS_ERROR',

498: x_return_status := OKC_API.HANDLE_EXCEPTIONS
499: (
500: l_api_name,
501: G_PKG_NAME,
502: 'OKC_API.G_RET_STS_ERROR',
503: x_msg_count,
504: x_msg_data,
505: '_PVT'
506: );