APPS.OKL_AM_INTEGRATION_PUB dependencies on OKL_API

Line 27: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

23: x_msg_data OUT NOCOPY VARCHAR2) IS
24:
25: lp_source_trx_id NUMBER := p_source_trx_id;
26: lp_khr_id NUMBER := p_khr_id;
27: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
28: l_program_name CONSTANT VARCHAR2(61) := 'cancel_termination_quotes';
29: l_api_name CONSTANT VARCHAR2(61) := G_PKG_NAME||'.'||l_program_name;
30:
31: -- rmunjulu 4508497

Line 46: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

42: p_source => lp_source, -- rmunjulu 4508497
43: x_return_status => l_return_status,
44: x_msg_count => x_msg_count,
45: x_msg_data => x_msg_data);
46: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
47: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
48: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
49: RAISE OKL_API.G_EXCEPTION_ERROR;
50: END IF;

Line 47: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

43: x_return_status => l_return_status,
44: x_msg_count => x_msg_count,
45: x_msg_data => x_msg_data);
46: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
47: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
48: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
49: RAISE OKL_API.G_EXCEPTION_ERROR;
50: END IF;
51:

Line 48: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

44: x_msg_count => x_msg_count,
45: x_msg_data => x_msg_data);
46: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
47: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
48: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
49: RAISE OKL_API.G_EXCEPTION_ERROR;
50: END IF;
51:
52: x_return_status := G_RET_STS_SUCCESS;

Line 49: RAISE OKL_API.G_EXCEPTION_ERROR;

45: x_msg_data => x_msg_data);
46: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
47: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
48: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
49: RAISE OKL_API.G_EXCEPTION_ERROR;
50: END IF;
51:
52: x_return_status := G_RET_STS_SUCCESS;
53:

Line 56: WHEN OKL_API.G_EXCEPTION_ERROR THEN

52: x_return_status := G_RET_STS_SUCCESS;
53:
54: EXCEPTION
55:
56: WHEN OKL_API.G_EXCEPTION_ERROR THEN
57: ROLLBACK TO l_program_name;
58: x_return_status := G_RET_STS_ERROR;
59:
60: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 60: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

56: WHEN OKL_API.G_EXCEPTION_ERROR THEN
57: ROLLBACK TO l_program_name;
58: x_return_status := G_RET_STS_ERROR;
59:
60: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
61: ROLLBACK TO l_program_name;
62: x_return_status := G_RET_STS_UNEXP_ERROR;
63:
64: WHEN OTHERS THEN

Line 65: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

61: ROLLBACK TO l_program_name;
62: x_return_status := G_RET_STS_UNEXP_ERROR;
63:
64: WHEN OTHERS THEN
65: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
66: p_msg_name => G_DB_ERROR,
67: p_token1 => G_PROG_NAME_TOKEN,
68: p_token1_value => l_api_name,
69: p_token2 => G_SQLCODE_TOKEN,