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 54: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

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

Line 57: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

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

Line 137: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE

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

Line 138: ,p_commit_flag IN VARCHAR2 DEFAULT OKL_API.G_TRUE

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

Line 140: ,p_chk_approval_limits IN VARCHAR2 DEFAULT OKL_API.G_TRUE

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

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

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

Line 176: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

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

Line 179: IF x_return_status <> Okl_Api.G_RET_STS_SUCCESS THEN

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

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

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