DBA Data[Home] [Help]

APPS.OKL_BPD_ADVANCED_CASH_APP_PVT dependencies on OKC_API

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

3282:
3283: l_ar_inv_tbl OKL_BPD_ADVANCED_BILLING_PVT.ar_inv_tbl_type DEFAULT p_ar_inv_tbl;
3284:
3285: l_api_version NUMBER := 1.0;
3286: l_init_msg_list VARCHAR2(1) := Okc_Api.g_false;
3287: l_return_status VARCHAR2(1);
3288: l_msg_count NUMBER;
3289: l_msg_data VARCHAR2(2000);
3290: l_api_name CONSTANT VARCHAR2(30) := 'AR_advance_receipt';

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

3456:
3457: IF c_get_gl_date%NOTFOUND THEN
3458: CLOSE c_get_gl_date;
3459:
3460: OKC_API.set_message( p_app_name => G_APP_NAME,
3461: p_msg_name =>'OKL_BPD_GL_PERIOD_ERROR',
3462: p_token1 => 'TRX_DATE',
3463: p_token1_value => TRUNC(SYSDATE));
3464:

Line 3465: l_return_status := OKC_API.G_RET_STS_ERROR;

3461: p_msg_name =>'OKL_BPD_GL_PERIOD_ERROR',
3462: p_token1 => 'TRX_DATE',
3463: p_token1_value => TRUNC(SYSDATE));
3464:
3465: l_return_status := OKC_API.G_RET_STS_ERROR;
3466: RAISE G_EXCEPTION_HALT_VALIDATION;
3467: END IF;
3468: CLOSE c_get_gl_date;
3469:

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

3536: FETCH c_get_gl_date INTO l_inv_gl_date, l_counter;
3537:
3538: IF c_get_gl_date%NOTFOUND THEN
3539: CLOSE c_get_gl_date;
3540: OKC_API.set_message( p_app_name => G_APP_NAME,
3541: p_msg_name =>'OKL_BPD_GL_PERIOD_ERROR',
3542: p_token1 => 'TRX_DATE',
3543: p_token1_value => l_apply_date);
3544:

Line 3545: l_return_status := OKC_API.G_RET_STS_ERROR;

3541: p_msg_name =>'OKL_BPD_GL_PERIOD_ERROR',
3542: p_token1 => 'TRX_DATE',
3543: p_token1_value => l_apply_date);
3544:
3545: l_return_status := OKC_API.G_RET_STS_ERROR;
3546: RAISE G_EXCEPTION_HALT_VALIDATION;
3547: END IF;
3548: CLOSE c_get_gl_date;
3549: -- varao 14-Feb-2006 bug 5032427 end

Line 3637: x_return_status := OKC_API.G_RET_STS_ERROR;

3633:
3634: EXCEPTION
3635:
3636: WHEN G_EXCEPTION_HALT_VALIDATION THEN
3637: x_return_status := OKC_API.G_RET_STS_ERROR;
3638:
3639:
3640: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3641: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 3641: x_return_status := OKC_API.HANDLE_EXCEPTIONS

3637: x_return_status := OKC_API.G_RET_STS_ERROR;
3638:
3639:
3640: WHEN OKL_API.G_EXCEPTION_ERROR THEN
3641: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3642: (
3643: l_api_name,
3644: G_PKG_NAME,
3645: OKL_API.G_RET_STS_ERROR,

Line 3651: x_return_status := OKC_API.HANDLE_EXCEPTIONS

3647: x_msg_data,
3648: '_PVT'
3649: );
3650: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
3651: x_return_status := OKC_API.HANDLE_EXCEPTIONS
3652: (
3653: l_api_name,
3654: G_PKG_NAME,
3655: OKL_API.G_RET_STS_UNEXP_ERROR,

Line 3662: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

3658: '_PVT'
3659: );
3660:
3661: WHEN OTHERS THEN
3662: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3663: Okl_api.set_message( p_app_name => g_app_name
3664: , p_msg_name => g_unexpected_error
3665: , p_token1 => g_sqlcode_token
3666: , p_token1_value => SQLCODE