APPS.OKL_CREATE_ADJST_PUB dependencies on OKL_API

Line 22: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

18: | Syed Nizam 29-APR-08 Bug 6727171 -- Modified error handling |
19: +===========================================================================*/
20:
21: PROCEDURE create_adjustments_pub( p_api_version IN NUMBER
22: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
23: ,x_return_status OUT NOCOPY VARCHAR2
24: ,x_msg_count OUT NOCOPY NUMBER
25: ,x_msg_data OUT NOCOPY VARCHAR2
26: ) IS

Line 28: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

24: ,x_msg_count OUT NOCOPY NUMBER
25: ,x_msg_data OUT NOCOPY VARCHAR2
26: ) IS
27:
28: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
29: l_api_version NUMBER := 1;
30: l_init_msg_list VARCHAR2(1);
31: l_msg_count NUMBER;
32: l_msg_data VARCHAR(2000);

Line 56: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

52: );
53:
54: /* Bug 6727171 Start
55:
56: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
57: RAISE G_EXCEPTION_HALT_VALIDATION;
58: ELSE
59: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
60: l_return_status := x_return_status;

Line 59: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

55:
56: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
57: RAISE G_EXCEPTION_HALT_VALIDATION;
58: ELSE
59: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
60: l_return_status := x_return_status;
61: END IF;
62: END IF;
63: Bug 6727171 End */

Line 139: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

135: | Bruno Vaghela 09-OCT-02 Created |
136: +===========================================================================*/
137:
138: PROCEDURE iex_create_adjustments_pub( p_api_version IN NUMBER
139: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
140: ,p_commit_flag IN VARCHAR2 DEFAULT OKL_API.G_TRUE
141: ,p_psl_id IN NUMBER
142: ,p_chk_approval_limits IN VARCHAR2 DEFAULT OKL_API.G_TRUE
143: ,x_new_adj_id OUT NOCOPY NUMBER

Line 140: ,p_commit_flag IN VARCHAR2 DEFAULT OKL_API.G_TRUE

136: +===========================================================================*/
137:
138: PROCEDURE iex_create_adjustments_pub( p_api_version IN NUMBER
139: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
140: ,p_commit_flag IN VARCHAR2 DEFAULT OKL_API.G_TRUE
141: ,p_psl_id IN NUMBER
142: ,p_chk_approval_limits IN VARCHAR2 DEFAULT OKL_API.G_TRUE
143: ,x_new_adj_id OUT NOCOPY NUMBER
144: ,x_return_status OUT NOCOPY VARCHAR2

Line 142: ,p_chk_approval_limits IN VARCHAR2 DEFAULT OKL_API.G_TRUE

138: PROCEDURE iex_create_adjustments_pub( p_api_version IN NUMBER
139: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
140: ,p_commit_flag IN VARCHAR2 DEFAULT OKL_API.G_TRUE
141: ,p_psl_id IN NUMBER
142: ,p_chk_approval_limits IN VARCHAR2 DEFAULT OKL_API.G_TRUE
143: ,x_new_adj_id OUT NOCOPY NUMBER
144: ,x_return_status OUT NOCOPY VARCHAR2
145: ,x_msg_count OUT NOCOPY NUMBER
146: ,x_msg_data OUT NOCOPY VARCHAR2

Line 149: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

145: ,x_msg_count OUT NOCOPY NUMBER
146: ,x_msg_data OUT NOCOPY VARCHAR2
147: ) IS
148:
149: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
150: l_api_version NUMBER := 1;
151: l_init_msg_list VARCHAR2(1);
152: l_msg_count NUMBER;
153: l_msg_data VARCHAR(2000);

Line 178: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

174: ,l_msg_data
175: );
176:
177: /*Bug 6727171 Start
178: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
179: RAISE G_EXCEPTION_HALT_VALIDATION;
180: ELSE
181: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
182: l_return_status := x_return_status;

Line 181: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

177: /*Bug 6727171 Start
178: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
179: RAISE G_EXCEPTION_HALT_VALIDATION;
180: ELSE
181: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN
182: l_return_status := x_return_status;
183: END IF;
184: END IF;
185: Bug 6727171 End */

Line 238: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

234: ,retcode OUT NOCOPY NUMBER )
235: IS
236:
237: l_api_version NUMBER := 1;
238: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
239: l_msg_count NUMBER;
240: l_msg_data VARCHAR2(450);
241: l_init_msg_list VARCHAR2(1);
242: