APPS.OKL_OA_DATA_INTEGRITY dependencies on OKL_API

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

15: x_return_status OUT NOCOPY VARCHAR2,
16: p_chr_id IN NUMBER
17: ) IS
18:
19: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
20: l_dummy VARCHAR2(1) := '?';
21: l_count NUMBER := 0;
22: l_row_notfound BOOLEAN;
23: l_token VARCHAR2(2000);

Line 36: x_return_status := OKL_API.G_RET_STS_SUCCESS;

32:
33: BEGIN
34:
35: -- initialize return status
36: x_return_status := OKL_API.G_RET_STS_SUCCESS;
37:
38: IF x_return_status = OKL_API.G_RET_STS_SUCCESS THEN
39: OKL_API.set_message(
40: p_app_name => G_APP_NAME,

Line 38: IF x_return_status = OKL_API.G_RET_STS_SUCCESS THEN

34:
35: -- initialize return status
36: x_return_status := OKL_API.G_RET_STS_SUCCESS;
37:
38: IF x_return_status = OKL_API.G_RET_STS_SUCCESS THEN
39: OKL_API.set_message(
40: p_app_name => G_APP_NAME,
41: p_msg_name => G_QA_SUCCESS);
42: END IF;

Line 39: OKL_API.set_message(

35: -- initialize return status
36: x_return_status := OKL_API.G_RET_STS_SUCCESS;
37:
38: IF x_return_status = OKL_API.G_RET_STS_SUCCESS THEN
39: OKL_API.set_message(
40: p_app_name => G_APP_NAME,
41: p_msg_name => G_QA_SUCCESS);
42: END IF;
43:

Line 53: OKL_API.SET_MESSAGE(

49: NULL;
50:
51: WHEN OTHERS THEN
52: -- store SQL error message on message stack
53: OKL_API.SET_MESSAGE(
54: p_app_name => G_APP_NAME,
55: p_msg_name => G_UNEXPECTED_ERROR,
56: p_token1 => G_SQLCODE_TOKEN,
57: p_token1_value => SQLCODE,

Line 61: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

57: p_token1_value => SQLCODE,
58: p_token2 => G_SQLERRM_TOKEN,
59: p_token2_value => SQLERRM);
60: -- notify caller of an error as UNEXPETED error
61: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
62: -- verify that cursor was closed
63:
64: END check_functional_constraints;
65: