7: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
8: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLERRM';
9: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLCODE';
10:
11: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
12: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OKL_GENERATE_STREAMS_PUB';
13:
14: ---------------------------------------------------------------------------
15: -- GLOBAL RETURN STATUSES
13:
14: ---------------------------------------------------------------------------
15: -- GLOBAL RETURN STATUSES
16: ---------------------------------------------------------------------------
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
18: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
19: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
20:
21: ---------------------------------------------------------------------------
14: ---------------------------------------------------------------------------
15: -- GLOBAL RETURN STATUSES
16: ---------------------------------------------------------------------------
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
18: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
19: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
20:
21: ---------------------------------------------------------------------------
22: -- GLOBAL EXCEPTION
15: -- GLOBAL RETURN STATUSES
16: ---------------------------------------------------------------------------
17: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
18: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_UNEXP_ERROR;
19: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
20:
21: ---------------------------------------------------------------------------
22: -- GLOBAL EXCEPTION
23: ---------------------------------------------------------------------------
25: G_EXCEPTION_HALT_PROCESSING EXCEPTION;
26: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
27: G_EXCEPTION_ERROR EXCEPTION;
28:
29: G_EXC_NAME_RET_STS_ERR CONSTANT VARCHAR(25) := 'OKL_API.G_RET_STS_ERROR';
30: G_EXC_NAME_RET_STS_UNEXP_ERR CONSTANT VARCHAR(30) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
31: G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
32: G_API_TYPE CONSTANT VARCHAR(4) := '_PUB';
33:
26: G_EXCEPTION_UNEXPECTED_ERROR EXCEPTION;
27: G_EXCEPTION_ERROR EXCEPTION;
28:
29: G_EXC_NAME_RET_STS_ERR CONSTANT VARCHAR(25) := 'OKL_API.G_RET_STS_ERROR';
30: G_EXC_NAME_RET_STS_UNEXP_ERR CONSTANT VARCHAR(30) := 'OKL_API.G_RET_STS_UNEXP_ERROR';
31: G_EXC_NAME_OTHERS CONSTANT VARCHAR2(6) := 'OTHERS';
32: G_API_TYPE CONSTANT VARCHAR(4) := '_PUB';
33:
34: ---------------------------------------------------------------------------