13: G_APP_NAME_OKC CONSTANT VARCHAR2(3) := 'OKC';
14: ----------------------------------------------------------------------------------------
15: -- GLOBAL_MESSAGE_CONSTANTS
16: ----------------------------------------------------------------------------------------
17: G_TRUE CONSTANT VARCHAR2(1) := OKC_API.G_TRUE;
18: G_FALSE CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;
19: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
20: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_ERROR;
21: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_UNEXP_ERROR;
14: ----------------------------------------------------------------------------------------
15: -- GLOBAL_MESSAGE_CONSTANTS
16: ----------------------------------------------------------------------------------------
17: G_TRUE CONSTANT VARCHAR2(1) := OKC_API.G_TRUE;
18: G_FALSE CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;
19: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
20: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_ERROR;
21: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_UNEXP_ERROR;
22: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
15: -- GLOBAL_MESSAGE_CONSTANTS
16: ----------------------------------------------------------------------------------------
17: G_TRUE CONSTANT VARCHAR2(1) := OKC_API.G_TRUE;
18: G_FALSE CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;
19: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
20: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_ERROR;
21: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_UNEXP_ERROR;
22: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
23: G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'SQLerrm';
16: ----------------------------------------------------------------------------------------
17: G_TRUE CONSTANT VARCHAR2(1) := OKC_API.G_TRUE;
18: G_FALSE CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;
19: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
20: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_ERROR;
21: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_UNEXP_ERROR;
22: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
23: G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'SQLerrm';
24: G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'SQLcode';
17: G_TRUE CONSTANT VARCHAR2(1) := OKC_API.G_TRUE;
18: G_FALSE CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;
19: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
20: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_ERROR;
21: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_UNEXP_ERROR;
22: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
23: G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'SQLerrm';
24: G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'SQLcode';
25: G_REQUIRED_VALUE CONSTANT VARCHAR2(30) := OKC_API.G_REQUIRED_VALUE;
21: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKC_API.G_RET_STS_UNEXP_ERROR;
22: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
23: G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'SQLerrm';
24: G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'SQLcode';
25: G_REQUIRED_VALUE CONSTANT VARCHAR2(30) := OKC_API.G_REQUIRED_VALUE;
26: G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := OKC_API.G_COL_NAME_TOKEN;
27: ----------------------------------------------------------------------------------------
28: -- GLOBAL EXCEPTION
29: ----------------------------------------------------------------------------------------
22: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(30) := 'OKC_CONTRACTS_UNEXPECTED_ERROR';
23: G_SQLERRM_TOKEN CONSTANT VARCHAR2(30) := 'SQLerrm';
24: G_SQLCODE_TOKEN CONSTANT VARCHAR2(30) := 'SQLcode';
25: G_REQUIRED_VALUE CONSTANT VARCHAR2(30) := OKC_API.G_REQUIRED_VALUE;
26: G_COL_NAME_TOKEN CONSTANT VARCHAR2(30) := OKC_API.G_COL_NAME_TOKEN;
27: ----------------------------------------------------------------------------------------
28: -- GLOBAL EXCEPTION
29: ----------------------------------------------------------------------------------------
30: G_ERROR EXCEPTION;