APPS.OKC_DOCLIST_PUB dependencies on OKC_API

Line 78: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN

74: ,x_return_status => x_return_status
75: ,x_msg_count => x_msg_count
76: ,x_msg_data => x_msg_data );
77:
78: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
79: RAISE okc_api.g_exception_unexpected_error;
80: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
81: RAISE okc_api.g_exception_error;
82: END IF;

Line 79: RAISE okc_api.g_exception_unexpected_error;

75: ,x_msg_count => x_msg_count
76: ,x_msg_data => x_msg_data );
77:
78: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
79: RAISE okc_api.g_exception_unexpected_error;
80: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
81: RAISE okc_api.g_exception_error;
82: END IF;
83:

Line 80: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN

76: ,x_msg_data => x_msg_data );
77:
78: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
79: RAISE okc_api.g_exception_unexpected_error;
80: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
81: RAISE okc_api.g_exception_error;
82: END IF;
83:
84: COMMIT;

Line 81: RAISE okc_api.g_exception_error;

77:
78: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
79: RAISE okc_api.g_exception_unexpected_error;
80: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
81: RAISE okc_api.g_exception_error;
82: END IF;
83:
84: COMMIT;
85:

Line 87: WHEN okc_api.g_exception_error THEN

83:
84: COMMIT;
85:
86: EXCEPTION
87: WHEN okc_api.g_exception_error THEN
88: x_return_status := okc_api.handle_exceptions (
89: p_api_name => l_api_name
90: ,p_pkg_name => g_package_name
91: ,p_exc_name => 'OKC_API.g_ret_sts_error'

Line 88: x_return_status := okc_api.handle_exceptions (

84: COMMIT;
85:
86: EXCEPTION
87: WHEN okc_api.g_exception_error THEN
88: x_return_status := okc_api.handle_exceptions (
89: p_api_name => l_api_name
90: ,p_pkg_name => g_package_name
91: ,p_exc_name => 'OKC_API.g_ret_sts_error'
92: ,x_msg_count => x_msg_count

Line 91: ,p_exc_name => 'OKC_API.g_ret_sts_error'

87: WHEN okc_api.g_exception_error THEN
88: x_return_status := okc_api.handle_exceptions (
89: p_api_name => l_api_name
90: ,p_pkg_name => g_package_name
91: ,p_exc_name => 'OKC_API.g_ret_sts_error'
92: ,x_msg_count => x_msg_count
93: ,x_msg_data => x_msg_data
94: ,p_api_type => '_PUB' );
95:

Line 96: WHEN okc_api.g_exception_unexpected_error THEN

92: ,x_msg_count => x_msg_count
93: ,x_msg_data => x_msg_data
94: ,p_api_type => '_PUB' );
95:
96: WHEN okc_api.g_exception_unexpected_error THEN
97: x_return_status := okc_api.handle_exceptions (
98: p_api_name => l_api_name
99: ,p_pkg_name => g_package_name
100: ,p_exc_name => 'OKC_API.g_ret_sts_unexp_error'

Line 97: x_return_status := okc_api.handle_exceptions (

93: ,x_msg_data => x_msg_data
94: ,p_api_type => '_PUB' );
95:
96: WHEN okc_api.g_exception_unexpected_error THEN
97: x_return_status := okc_api.handle_exceptions (
98: p_api_name => l_api_name
99: ,p_pkg_name => g_package_name
100: ,p_exc_name => 'OKC_API.g_ret_sts_unexp_error'
101: ,x_msg_count => x_msg_count

Line 100: ,p_exc_name => 'OKC_API.g_ret_sts_unexp_error'

96: WHEN okc_api.g_exception_unexpected_error THEN
97: x_return_status := okc_api.handle_exceptions (
98: p_api_name => l_api_name
99: ,p_pkg_name => g_package_name
100: ,p_exc_name => 'OKC_API.g_ret_sts_unexp_error'
101: ,x_msg_count => x_msg_count
102: ,x_msg_data => x_msg_data
103: ,p_api_type => '_PUB' );
104: WHEN OTHERS THEN

Line 105: x_return_status := okc_api.handle_exceptions (

101: ,x_msg_count => x_msg_count
102: ,x_msg_data => x_msg_data
103: ,p_api_type => '_PUB' );
104: WHEN OTHERS THEN
105: x_return_status := okc_api.handle_exceptions (
106: p_api_name => l_api_name
107: ,p_pkg_name => g_package_name
108: ,p_exc_name => 'OTHERS'
109: ,x_msg_count => x_msg_count

Line 159: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN

155: ,x_return_status => x_return_status
156: ,x_msg_count => x_msg_count
157: ,x_msg_data => x_msg_data );
158:
159: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
160: RAISE okc_api.g_exception_unexpected_error;
161: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
162: RAISE okc_api.g_exception_error;
163: END IF;

Line 160: RAISE okc_api.g_exception_unexpected_error;

156: ,x_msg_count => x_msg_count
157: ,x_msg_data => x_msg_data );
158:
159: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
160: RAISE okc_api.g_exception_unexpected_error;
161: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
162: RAISE okc_api.g_exception_error;
163: END IF;
164:

Line 161: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN

157: ,x_msg_data => x_msg_data );
158:
159: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
160: RAISE okc_api.g_exception_unexpected_error;
161: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
162: RAISE okc_api.g_exception_error;
163: END IF;
164:
165: COMMIT;

Line 162: RAISE okc_api.g_exception_error;

158:
159: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
160: RAISE okc_api.g_exception_unexpected_error;
161: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
162: RAISE okc_api.g_exception_error;
163: END IF;
164:
165: COMMIT;
166:

Line 168: WHEN okc_api.g_exception_error THEN

164:
165: COMMIT;
166:
167: EXCEPTION
168: WHEN okc_api.g_exception_error THEN
169: x_return_status := okc_api.handle_exceptions (
170: p_api_name => l_api_name
171: ,p_pkg_name => g_package_name
172: ,p_exc_name => 'OKC_API.g_ret_sts_error'

Line 169: x_return_status := okc_api.handle_exceptions (

165: COMMIT;
166:
167: EXCEPTION
168: WHEN okc_api.g_exception_error THEN
169: x_return_status := okc_api.handle_exceptions (
170: p_api_name => l_api_name
171: ,p_pkg_name => g_package_name
172: ,p_exc_name => 'OKC_API.g_ret_sts_error'
173: ,x_msg_count => x_msg_count

Line 172: ,p_exc_name => 'OKC_API.g_ret_sts_error'

168: WHEN okc_api.g_exception_error THEN
169: x_return_status := okc_api.handle_exceptions (
170: p_api_name => l_api_name
171: ,p_pkg_name => g_package_name
172: ,p_exc_name => 'OKC_API.g_ret_sts_error'
173: ,x_msg_count => x_msg_count
174: ,x_msg_data => x_msg_data
175: ,p_api_type => '_PUB' );
176:

Line 177: WHEN okc_api.g_exception_unexpected_error THEN

173: ,x_msg_count => x_msg_count
174: ,x_msg_data => x_msg_data
175: ,p_api_type => '_PUB' );
176:
177: WHEN okc_api.g_exception_unexpected_error THEN
178: x_return_status := okc_api.handle_exceptions (
179: p_api_name => l_api_name
180: ,p_pkg_name => g_package_name
181: ,p_exc_name => 'OKC_API.g_ret_sts_unexp_error'

Line 178: x_return_status := okc_api.handle_exceptions (

174: ,x_msg_data => x_msg_data
175: ,p_api_type => '_PUB' );
176:
177: WHEN okc_api.g_exception_unexpected_error THEN
178: x_return_status := okc_api.handle_exceptions (
179: p_api_name => l_api_name
180: ,p_pkg_name => g_package_name
181: ,p_exc_name => 'OKC_API.g_ret_sts_unexp_error'
182: ,x_msg_count => x_msg_count

Line 181: ,p_exc_name => 'OKC_API.g_ret_sts_unexp_error'

177: WHEN okc_api.g_exception_unexpected_error THEN
178: x_return_status := okc_api.handle_exceptions (
179: p_api_name => l_api_name
180: ,p_pkg_name => g_package_name
181: ,p_exc_name => 'OKC_API.g_ret_sts_unexp_error'
182: ,x_msg_count => x_msg_count
183: ,x_msg_data => x_msg_data
184: ,p_api_type => '_PUB' );
185: WHEN OTHERS THEN

Line 186: x_return_status := okc_api.handle_exceptions (

182: ,x_msg_count => x_msg_count
183: ,x_msg_data => x_msg_data
184: ,p_api_type => '_PUB' );
185: WHEN OTHERS THEN
186: x_return_status := okc_api.handle_exceptions (
187: p_api_name => l_api_name
188: ,p_pkg_name => g_package_name
189: ,p_exc_name => 'OTHERS'
190: ,x_msg_count => x_msg_count

Line 230: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN

226: ,x_return_status => x_return_status
227: ,x_msg_count => x_msg_count
228: ,x_msg_data => x_msg_data);
229:
230: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
231: RAISE okc_api.g_exception_unexpected_error;
232: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
233: RAISE okc_api.g_exception_error;
234: END IF;

Line 231: RAISE okc_api.g_exception_unexpected_error;

227: ,x_msg_count => x_msg_count
228: ,x_msg_data => x_msg_data);
229:
230: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
231: RAISE okc_api.g_exception_unexpected_error;
232: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
233: RAISE okc_api.g_exception_error;
234: END IF;
235:

Line 232: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN

228: ,x_msg_data => x_msg_data);
229:
230: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
231: RAISE okc_api.g_exception_unexpected_error;
232: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
233: RAISE okc_api.g_exception_error;
234: END IF;
235:
236: COMMIT;

Line 233: RAISE okc_api.g_exception_error;

229:
230: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
231: RAISE okc_api.g_exception_unexpected_error;
232: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
233: RAISE okc_api.g_exception_error;
234: END IF;
235:
236: COMMIT;
237:

Line 239: WHEN okc_api.g_exception_error THEN

235:
236: COMMIT;
237:
238: EXCEPTION
239: WHEN okc_api.g_exception_error THEN
240: x_return_status := okc_api.handle_exceptions (
241: p_api_name => l_api_name
242: ,p_pkg_name => g_package_name
243: ,p_exc_name => 'OKC_API.g_ret_sts_error'

Line 240: x_return_status := okc_api.handle_exceptions (

236: COMMIT;
237:
238: EXCEPTION
239: WHEN okc_api.g_exception_error THEN
240: x_return_status := okc_api.handle_exceptions (
241: p_api_name => l_api_name
242: ,p_pkg_name => g_package_name
243: ,p_exc_name => 'OKC_API.g_ret_sts_error'
244: ,x_msg_count => x_msg_count

Line 243: ,p_exc_name => 'OKC_API.g_ret_sts_error'

239: WHEN okc_api.g_exception_error THEN
240: x_return_status := okc_api.handle_exceptions (
241: p_api_name => l_api_name
242: ,p_pkg_name => g_package_name
243: ,p_exc_name => 'OKC_API.g_ret_sts_error'
244: ,x_msg_count => x_msg_count
245: ,x_msg_data => x_msg_data
246: ,p_api_type => '_PVT' );
247:

Line 248: WHEN okc_api.g_exception_unexpected_error THEN

244: ,x_msg_count => x_msg_count
245: ,x_msg_data => x_msg_data
246: ,p_api_type => '_PVT' );
247:
248: WHEN okc_api.g_exception_unexpected_error THEN
249: x_return_status := okc_api.handle_exceptions (
250: p_api_name => l_api_name
251: ,p_pkg_name => g_package_name
252: ,p_exc_name => 'OKC_API.g_ret_sts_unexp_error'

Line 249: x_return_status := okc_api.handle_exceptions (

245: ,x_msg_data => x_msg_data
246: ,p_api_type => '_PVT' );
247:
248: WHEN okc_api.g_exception_unexpected_error THEN
249: x_return_status := okc_api.handle_exceptions (
250: p_api_name => l_api_name
251: ,p_pkg_name => g_package_name
252: ,p_exc_name => 'OKC_API.g_ret_sts_unexp_error'
253: ,x_msg_count => x_msg_count

Line 252: ,p_exc_name => 'OKC_API.g_ret_sts_unexp_error'

248: WHEN okc_api.g_exception_unexpected_error THEN
249: x_return_status := okc_api.handle_exceptions (
250: p_api_name => l_api_name
251: ,p_pkg_name => g_package_name
252: ,p_exc_name => 'OKC_API.g_ret_sts_unexp_error'
253: ,x_msg_count => x_msg_count
254: ,x_msg_data => x_msg_data
255: ,p_api_type => '_PVT' );
256: WHEN OTHERS THEN

Line 257: x_return_status := okc_api.handle_exceptions (

253: ,x_msg_count => x_msg_count
254: ,x_msg_data => x_msg_data
255: ,p_api_type => '_PVT' );
256: WHEN OTHERS THEN
257: x_return_status := okc_api.handle_exceptions (
258: p_api_name => l_api_name
259: ,p_pkg_name => g_package_name
260: ,p_exc_name => 'OTHERS'
261: ,x_msg_count => x_msg_count