eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_DOCLIST_PVT dependencies on OKC_API

Line 51: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;

47: l_api_name VARCHAR2(20) := 'PROCESS_ROW';
48: l_dups_deleted NUMBER := 0;
49: l_fifos_deleted NUMBER := 0;
50:
51: l_return_status VARCHAR2(1) := okc_api.g_ret_sts_success;
52: l_msg_count NUMBER := 0;
53: l_msg_data VARCHAR2(2000);
54: bin_rec ubl_csr_type%ROWTYPE;
55: id_tab id_table_type;

Line 64: x_return_status := OKC_API.start_activity (

60:
61: --
62: -- Start the logical activity...
63: --
64: x_return_status := OKC_API.start_activity (
65: P_API_NAME => l_api_name
66: ,P_INIT_MSG_LIST => g_init_msg_list
67: ,P_API_TYPE => '_PVT'
68: ,X_RETURN_STATUS => x_return_status );

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

66: ,P_INIT_MSG_LIST => g_init_msg_list
67: ,P_API_TYPE => '_PVT'
68: ,X_RETURN_STATUS => x_return_status );
69:
70: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
71: RAISE okc_api.g_exception_unexpected_error;
72: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
73: RAISE okc_api.g_exception_error;
74: END IF;

Line 71: RAISE okc_api.g_exception_unexpected_error;

67: ,P_API_TYPE => '_PVT'
68: ,X_RETURN_STATUS => x_return_status );
69:
70: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
71: RAISE okc_api.g_exception_unexpected_error;
72: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
73: RAISE okc_api.g_exception_error;
74: END IF;
75:

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

68: ,X_RETURN_STATUS => x_return_status );
69:
70: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
71: RAISE okc_api.g_exception_unexpected_error;
72: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
73: RAISE okc_api.g_exception_error;
74: END IF;
75:
76: --

Line 73: RAISE okc_api.g_exception_error;

69:
70: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
71: RAISE okc_api.g_exception_unexpected_error;
72: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
73: RAISE okc_api.g_exception_error;
74: END IF;
75:
76: --
77: -- validate the record before calling insert

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

83: ,x_msg_count => l_msg_count
84: ,x_msg_data => l_msg_data
85: ,p_ubnv_rec => g_ubl_recin);
86:
87: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
88: RAISE okc_api.g_exception_unexpected_error;
89: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
90: RAISE okc_api.g_exception_error;
91: END IF;

Line 88: RAISE okc_api.g_exception_unexpected_error;

84: ,x_msg_data => l_msg_data
85: ,p_ubnv_rec => g_ubl_recin);
86:
87: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
88: RAISE okc_api.g_exception_unexpected_error;
89: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
90: RAISE okc_api.g_exception_error;
91: END IF;
92:

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

85: ,p_ubnv_rec => g_ubl_recin);
86:
87: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
88: RAISE okc_api.g_exception_unexpected_error;
89: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
90: RAISE okc_api.g_exception_error;
91: END IF;
92:
93: --

Line 90: RAISE okc_api.g_exception_error;

86:
87: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
88: RAISE okc_api.g_exception_unexpected_error;
89: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
90: RAISE okc_api.g_exception_error;
91: END IF;
92:
93: --
94: -- insert if OK

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

101: ,x_msg_data => x_msg_data
102: ,p_ubnv_rec => g_ubl_recin
103: ,x_ubnv_rec => g_ubl_recout );
104:
105: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
106: RAISE okc_api.g_exception_unexpected_error;
107: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
108: RAISE okc_api.g_exception_error;
109: END IF;

Line 106: RAISE okc_api.g_exception_unexpected_error;

102: ,p_ubnv_rec => g_ubl_recin
103: ,x_ubnv_rec => g_ubl_recout );
104:
105: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
106: RAISE okc_api.g_exception_unexpected_error;
107: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
108: RAISE okc_api.g_exception_error;
109: END IF;
110: --*********Entire logic Modified by MKS

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

103: ,x_ubnv_rec => g_ubl_recout );
104:
105: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
106: RAISE okc_api.g_exception_unexpected_error;
107: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
108: RAISE okc_api.g_exception_error;
109: END IF;
110: --*********Entire logic Modified by MKS
111: --

Line 108: RAISE okc_api.g_exception_error;

104:
105: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
106: RAISE okc_api.g_exception_unexpected_error;
107: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
108: RAISE okc_api.g_exception_error;
109: END IF;
110: --*********Entire logic Modified by MKS
111: --
112: -- check if a duplicate has been inserted. Duplicate is same contract, same type, same user

Line 125: x_return_status := okc_api.g_ret_sts_success;

121: EXIT WHEN ubl_csr_type%NOTFOUND;
122: i := i+1;
123: END LOOP;
124: CLOSE ubl_csr_type;
125: x_return_status := okc_api.g_ret_sts_success;
126: l_dups_deleted := 0;
127: l_fifos_deleted := 0;
128: i := 0;
129:

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

138: delete_entry ( p_ubl_id => id_tab(i)
139: ,x_return_status => x_return_status
140: ,x_msg_count => x_msg_count
141: ,x_msg_data => x_msg_data);
142: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
143: RAISE okc_api.g_exception_unexpected_error;
144: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
145: RAISE okc_api.g_exception_error;
146: END IF;

Line 143: RAISE okc_api.g_exception_unexpected_error;

139: ,x_return_status => x_return_status
140: ,x_msg_count => x_msg_count
141: ,x_msg_data => x_msg_data);
142: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
143: RAISE okc_api.g_exception_unexpected_error;
144: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
145: RAISE okc_api.g_exception_error;
146: END IF;
147: l_dups_deleted := l_dups_deleted + 1;

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

140: ,x_msg_count => x_msg_count
141: ,x_msg_data => x_msg_data);
142: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
143: RAISE okc_api.g_exception_unexpected_error;
144: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
145: RAISE okc_api.g_exception_error;
146: END IF;
147: l_dups_deleted := l_dups_deleted + 1;
148: id_tab.DELETE(i);

Line 145: RAISE okc_api.g_exception_error;

141: ,x_msg_data => x_msg_data);
142: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
143: RAISE okc_api.g_exception_unexpected_error;
144: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
145: RAISE okc_api.g_exception_error;
146: END IF;
147: l_dups_deleted := l_dups_deleted + 1;
148: id_tab.DELETE(i);
149: cid_tab.DELETE(i);

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

163: delete_entry ( p_ubl_id => id_tab(id_tab.FIRST)
164: ,x_return_status => x_return_status
165: ,x_msg_count => x_msg_count
166: ,x_msg_data => x_msg_data);
167: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
168: RAISE okc_api.g_exception_unexpected_error;
169: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
170: RAISE okc_api.g_exception_error;
171: END IF;

Line 168: RAISE okc_api.g_exception_unexpected_error;

164: ,x_return_status => x_return_status
165: ,x_msg_count => x_msg_count
166: ,x_msg_data => x_msg_data);
167: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
168: RAISE okc_api.g_exception_unexpected_error;
169: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
170: RAISE okc_api.g_exception_error;
171: END IF;
172: -- l_fifos_deleted := l_fifos_deleted + 1;

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

165: ,x_msg_count => x_msg_count
166: ,x_msg_data => x_msg_data);
167: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
168: RAISE okc_api.g_exception_unexpected_error;
169: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
170: RAISE okc_api.g_exception_error;
171: END IF;
172: -- l_fifos_deleted := l_fifos_deleted + 1;
173: -- END IF;

Line 170: RAISE okc_api.g_exception_error;

166: ,x_msg_data => x_msg_data);
167: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
168: RAISE okc_api.g_exception_unexpected_error;
169: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
170: RAISE okc_api.g_exception_error;
171: END IF;
172: -- l_fifos_deleted := l_fifos_deleted + 1;
173: -- END IF;
174: -- END LOOP;

Line 183: okc_api.end_activity (

179: --********* End of Mod
180: --
181: -- close the activity
182: --
183: okc_api.end_activity (
184: x_msg_count => x_msg_count
185: ,x_msg_data => x_msg_data);
186:
187:

Line 189: WHEN okc_api.g_exception_error THEN

185: ,x_msg_data => x_msg_data);
186:
187:
188: EXCEPTION
189: WHEN okc_api.g_exception_error THEN
190: IF ubl_csr_type%ISOPEN THEN
191: close ubl_csr_type;
192: END IF;
193: x_return_status := okc_api.handle_exceptions (

Line 193: x_return_status := okc_api.handle_exceptions (

189: WHEN okc_api.g_exception_error THEN
190: IF ubl_csr_type%ISOPEN THEN
191: close ubl_csr_type;
192: END IF;
193: x_return_status := okc_api.handle_exceptions (
194: p_api_name => l_api_name
195: ,p_pkg_name => g_package_name
196: ,p_exc_name => 'OKC_API.g_ret_sts_error'
197: ,x_msg_count => x_msg_count

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

192: END IF;
193: x_return_status := okc_api.handle_exceptions (
194: p_api_name => l_api_name
195: ,p_pkg_name => g_package_name
196: ,p_exc_name => 'OKC_API.g_ret_sts_error'
197: ,x_msg_count => x_msg_count
198: ,x_msg_data => x_msg_data
199: ,p_api_type => '_PVT' );
200:

Line 201: WHEN okc_api.g_exception_unexpected_error THEN

197: ,x_msg_count => x_msg_count
198: ,x_msg_data => x_msg_data
199: ,p_api_type => '_PVT' );
200:
201: WHEN okc_api.g_exception_unexpected_error THEN
202: IF ubl_csr_type%ISOPEN THEN
203: close ubl_csr_type;
204: END IF;
205: x_return_status := okc_api.handle_exceptions (

Line 205: x_return_status := okc_api.handle_exceptions (

201: WHEN okc_api.g_exception_unexpected_error THEN
202: IF ubl_csr_type%ISOPEN THEN
203: close ubl_csr_type;
204: END IF;
205: x_return_status := okc_api.handle_exceptions (
206: p_api_name => l_api_name
207: ,p_pkg_name => g_package_name
208: ,p_exc_name => 'OKC_API.g_ret_sts_unexp_error'
209: ,x_msg_count => x_msg_count

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

204: END IF;
205: x_return_status := okc_api.handle_exceptions (
206: p_api_name => l_api_name
207: ,p_pkg_name => g_package_name
208: ,p_exc_name => 'OKC_API.g_ret_sts_unexp_error'
209: ,x_msg_count => x_msg_count
210: ,x_msg_data => x_msg_data
211: ,p_api_type => '_PVT' );
212: WHEN OTHERS THEN

Line 216: x_return_status := okc_api.handle_exceptions (

212: WHEN OTHERS THEN
213: IF ubl_csr_type%ISOPEN THEN
214: close ubl_csr_type;
215: END IF;
216: x_return_status := okc_api.handle_exceptions (
217: p_api_name => l_api_name
218: ,p_pkg_name => g_package_name
219: ,p_exc_name => 'OTHERS'
220: ,x_msg_count => x_msg_count

Line 272: x_return_status := okc_api.g_ret_sts_success;

268: g_ubl_recin.bin_type := g_recent_type;
269: g_ubl_recin.created_by := 0;
270: g_ubl_recin.creation_date := null;
271:
272: x_return_status := okc_api.g_ret_sts_success;
273: Process_row (
274: row_type => 'RECENT'
275: ,x_return_status => x_return_status
276: ,x_msg_count => x_msg_count

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

275: ,x_return_status => x_return_status
276: ,x_msg_count => x_msg_count
277: ,x_msg_data => x_msg_data );
278:
279: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
280: RAISE okc_api.g_exception_unexpected_error;
281: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
282: RAISE okc_api.g_exception_error;
283: END IF;

Line 280: RAISE okc_api.g_exception_unexpected_error;

276: ,x_msg_count => x_msg_count
277: ,x_msg_data => x_msg_data );
278:
279: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
280: RAISE okc_api.g_exception_unexpected_error;
281: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
282: RAISE okc_api.g_exception_error;
283: END IF;
284:

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

277: ,x_msg_data => x_msg_data );
278:
279: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
280: RAISE okc_api.g_exception_unexpected_error;
281: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
282: RAISE okc_api.g_exception_error;
283: END IF;
284:
285: COMMIT;

Line 282: RAISE okc_api.g_exception_error;

278:
279: IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
280: RAISE okc_api.g_exception_unexpected_error;
281: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
282: RAISE okc_api.g_exception_error;
283: END IF;
284:
285: COMMIT;
286:

Line 288: WHEN okc_api.g_exception_error THEN

284:
285: COMMIT;
286:
287: EXCEPTION
288: WHEN okc_api.g_exception_error THEN
289: x_return_status := okc_api.handle_exceptions (
290: p_api_name => l_api_name
291: ,p_pkg_name => g_package_name
292: ,p_exc_name => 'OKC_API.g_ret_sts_error'

Line 289: x_return_status := okc_api.handle_exceptions (

285: COMMIT;
286:
287: EXCEPTION
288: WHEN okc_api.g_exception_error THEN
289: x_return_status := okc_api.handle_exceptions (
290: p_api_name => l_api_name
291: ,p_pkg_name => g_package_name
292: ,p_exc_name => 'OKC_API.g_ret_sts_error'
293: ,x_msg_count => x_msg_count

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

288: WHEN okc_api.g_exception_error THEN
289: x_return_status := okc_api.handle_exceptions (
290: p_api_name => l_api_name
291: ,p_pkg_name => g_package_name
292: ,p_exc_name => 'OKC_API.g_ret_sts_error'
293: ,x_msg_count => x_msg_count
294: ,x_msg_data => x_msg_data
295: ,p_api_type => '_PVT' );
296:

Line 297: WHEN okc_api.g_exception_unexpected_error THEN

293: ,x_msg_count => x_msg_count
294: ,x_msg_data => x_msg_data
295: ,p_api_type => '_PVT' );
296:
297: WHEN okc_api.g_exception_unexpected_error THEN
298: x_return_status := okc_api.handle_exceptions (
299: p_api_name => l_api_name
300: ,p_pkg_name => g_package_name
301: ,p_exc_name => 'OKC_API.g_ret_sts_unexp_error'

Line 298: x_return_status := okc_api.handle_exceptions (

294: ,x_msg_data => x_msg_data
295: ,p_api_type => '_PVT' );
296:
297: WHEN okc_api.g_exception_unexpected_error THEN
298: x_return_status := okc_api.handle_exceptions (
299: p_api_name => l_api_name
300: ,p_pkg_name => g_package_name
301: ,p_exc_name => 'OKC_API.g_ret_sts_unexp_error'
302: ,x_msg_count => x_msg_count

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

297: WHEN okc_api.g_exception_unexpected_error THEN
298: x_return_status := okc_api.handle_exceptions (
299: p_api_name => l_api_name
300: ,p_pkg_name => g_package_name
301: ,p_exc_name => 'OKC_API.g_ret_sts_unexp_error'
302: ,x_msg_count => x_msg_count
303: ,x_msg_data => x_msg_data
304: ,p_api_type => '_PVT' );
305: WHEN OTHERS THEN

Line 306: x_return_status := okc_api.handle_exceptions (

302: ,x_msg_count => x_msg_count
303: ,x_msg_data => x_msg_data
304: ,p_api_type => '_PVT' );
305: WHEN OTHERS THEN
306: x_return_status := okc_api.handle_exceptions (
307: p_api_name => l_api_name
308: ,p_pkg_name => g_package_name
309: ,p_exc_name => 'OTHERS'
310: ,x_msg_count => x_msg_count

Line 359: x_return_status := okc_api.g_ret_sts_success;

355: g_ubl_recin.bin_type := g_bookmark_type;
356: g_ubl_recin.created_by := 0;
357: g_ubl_recin.creation_date := null;
358:
359: x_return_status := okc_api.g_ret_sts_success;
360: process_row (
361: row_type => 'BOOKMARK'
362: ,x_return_status => x_return_status
363: ,x_msg_count => x_msg_count

Line 366: /* IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN

362: ,x_return_status => x_return_status
363: ,x_msg_count => x_msg_count
364: ,x_msg_data => x_msg_data);
365:
366: /* IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
367: RAISE okc_api.g_exception_unexpected_error;
368: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
369: RAISE okc_api.g_exception_error;
370: END IF;

Line 367: RAISE okc_api.g_exception_unexpected_error;

363: ,x_msg_count => x_msg_count
364: ,x_msg_data => x_msg_data);
365:
366: /* IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
367: RAISE okc_api.g_exception_unexpected_error;
368: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
369: RAISE okc_api.g_exception_error;
370: END IF;
371: */

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

364: ,x_msg_data => x_msg_data);
365:
366: /* IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
367: RAISE okc_api.g_exception_unexpected_error;
368: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
369: RAISE okc_api.g_exception_error;
370: END IF;
371: */
372:

Line 369: RAISE okc_api.g_exception_error;

365:
366: /* IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
367: RAISE okc_api.g_exception_unexpected_error;
368: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
369: RAISE okc_api.g_exception_error;
370: END IF;
371: */
372:
373: IF (x_return_status = okc_api.g_ret_sts_success) THEN

Line 373: IF (x_return_status = okc_api.g_ret_sts_success) THEN

369: RAISE okc_api.g_exception_error;
370: END IF;
371: */
372:
373: IF (x_return_status = okc_api.g_ret_sts_success) THEN
374: COMMIT;
375: END IF;
376:
377: EXCEPTION

Line 378: WHEN okc_api.g_exception_error THEN

374: COMMIT;
375: END IF;
376:
377: EXCEPTION
378: WHEN okc_api.g_exception_error THEN
379: x_return_status := okc_api.handle_exceptions (
380: p_api_name => l_api_name
381: ,p_pkg_name => g_package_name
382: ,p_exc_name => 'OKC_API.g_ret_sts_error'

Line 379: x_return_status := okc_api.handle_exceptions (

375: END IF;
376:
377: EXCEPTION
378: WHEN okc_api.g_exception_error THEN
379: x_return_status := okc_api.handle_exceptions (
380: p_api_name => l_api_name
381: ,p_pkg_name => g_package_name
382: ,p_exc_name => 'OKC_API.g_ret_sts_error'
383: ,x_msg_count => x_msg_count

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

378: WHEN okc_api.g_exception_error THEN
379: x_return_status := okc_api.handle_exceptions (
380: p_api_name => l_api_name
381: ,p_pkg_name => g_package_name
382: ,p_exc_name => 'OKC_API.g_ret_sts_error'
383: ,x_msg_count => x_msg_count
384: ,x_msg_data => x_msg_data
385: ,p_api_type => '_PVT' );
386:

Line 387: WHEN okc_api.g_exception_unexpected_error THEN

383: ,x_msg_count => x_msg_count
384: ,x_msg_data => x_msg_data
385: ,p_api_type => '_PVT' );
386:
387: WHEN okc_api.g_exception_unexpected_error THEN
388: x_return_status := okc_api.handle_exceptions (
389: p_api_name => l_api_name
390: ,p_pkg_name => g_package_name
391: ,p_exc_name => 'OKC_API.g_ret_sts_unexp_error'

Line 388: x_return_status := okc_api.handle_exceptions (

384: ,x_msg_data => x_msg_data
385: ,p_api_type => '_PVT' );
386:
387: WHEN okc_api.g_exception_unexpected_error THEN
388: x_return_status := okc_api.handle_exceptions (
389: p_api_name => l_api_name
390: ,p_pkg_name => g_package_name
391: ,p_exc_name => 'OKC_API.g_ret_sts_unexp_error'
392: ,x_msg_count => x_msg_count

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

387: WHEN okc_api.g_exception_unexpected_error THEN
388: x_return_status := okc_api.handle_exceptions (
389: p_api_name => l_api_name
390: ,p_pkg_name => g_package_name
391: ,p_exc_name => 'OKC_API.g_ret_sts_unexp_error'
392: ,x_msg_count => x_msg_count
393: ,x_msg_data => x_msg_data
394: ,p_api_type => '_PVT' );
395: WHEN OTHERS THEN

Line 396: x_return_status := okc_api.handle_exceptions (

392: ,x_msg_count => x_msg_count
393: ,x_msg_data => x_msg_data
394: ,p_api_type => '_PVT' );
395: WHEN OTHERS THEN
396: x_return_status := okc_api.handle_exceptions (
397: p_api_name => l_api_name
398: ,p_pkg_name => g_package_name
399: ,p_exc_name => 'OTHERS'
400: ,x_msg_count => x_msg_count

Line 451: /* IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN

447: ,x_msg_count => x_msg_count
448: ,x_msg_data => x_msg_data
449: ,p_ubnv_rec => g_ubl_recin );
450:
451: /* IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
452: RAISE okc_api.g_exception_unexpected_error;
453: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
454: RAISE okc_api.g_exception_error;
455: END IF;

Line 452: RAISE okc_api.g_exception_unexpected_error;

448: ,x_msg_data => x_msg_data
449: ,p_ubnv_rec => g_ubl_recin );
450:
451: /* IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
452: RAISE okc_api.g_exception_unexpected_error;
453: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
454: RAISE okc_api.g_exception_error;
455: END IF;
456: */

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

449: ,p_ubnv_rec => g_ubl_recin );
450:
451: /* IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
452: RAISE okc_api.g_exception_unexpected_error;
453: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
454: RAISE okc_api.g_exception_error;
455: END IF;
456: */
457: IF (x_return_status = okc_api.g_ret_sts_success) THEN

Line 454: RAISE okc_api.g_exception_error;

450:
451: /* IF (x_return_status = okc_api.g_ret_sts_unexp_error) THEN
452: RAISE okc_api.g_exception_unexpected_error;
453: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
454: RAISE okc_api.g_exception_error;
455: END IF;
456: */
457: IF (x_return_status = okc_api.g_ret_sts_success) THEN
458: COMMIT;

Line 457: IF (x_return_status = okc_api.g_ret_sts_success) THEN

453: ELSIF (x_return_status = okc_api.g_ret_sts_error) THEN
454: RAISE okc_api.g_exception_error;
455: END IF;
456: */
457: IF (x_return_status = okc_api.g_ret_sts_success) THEN
458: COMMIT;
459: END IF;
460:
461: EXCEPTION

Line 462: WHEN okc_api.g_exception_error THEN

458: COMMIT;
459: END IF;
460:
461: EXCEPTION
462: WHEN okc_api.g_exception_error THEN
463: x_return_status := okc_api.handle_exceptions (
464: p_api_name => l_api_name
465: ,p_pkg_name => g_package_name
466: ,p_exc_name => 'OKC_API.g_ret_sts_error'

Line 463: x_return_status := okc_api.handle_exceptions (

459: END IF;
460:
461: EXCEPTION
462: WHEN okc_api.g_exception_error THEN
463: x_return_status := okc_api.handle_exceptions (
464: p_api_name => l_api_name
465: ,p_pkg_name => g_package_name
466: ,p_exc_name => 'OKC_API.g_ret_sts_error'
467: ,x_msg_count => x_msg_count

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

462: WHEN okc_api.g_exception_error THEN
463: x_return_status := okc_api.handle_exceptions (
464: p_api_name => l_api_name
465: ,p_pkg_name => g_package_name
466: ,p_exc_name => 'OKC_API.g_ret_sts_error'
467: ,x_msg_count => x_msg_count
468: ,x_msg_data => x_msg_data
469: ,p_api_type => '_PVT' );
470:

Line 471: WHEN okc_api.g_exception_unexpected_error THEN

467: ,x_msg_count => x_msg_count
468: ,x_msg_data => x_msg_data
469: ,p_api_type => '_PVT' );
470:
471: WHEN okc_api.g_exception_unexpected_error THEN
472: x_return_status := okc_api.handle_exceptions (
473: p_api_name => l_api_name
474: ,p_pkg_name => g_package_name
475: ,p_exc_name => 'OKC_API.g_ret_sts_unexp_error'

Line 472: x_return_status := okc_api.handle_exceptions (

468: ,x_msg_data => x_msg_data
469: ,p_api_type => '_PVT' );
470:
471: WHEN okc_api.g_exception_unexpected_error THEN
472: x_return_status := okc_api.handle_exceptions (
473: p_api_name => l_api_name
474: ,p_pkg_name => g_package_name
475: ,p_exc_name => 'OKC_API.g_ret_sts_unexp_error'
476: ,x_msg_count => x_msg_count

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

471: WHEN okc_api.g_exception_unexpected_error THEN
472: x_return_status := okc_api.handle_exceptions (
473: p_api_name => l_api_name
474: ,p_pkg_name => g_package_name
475: ,p_exc_name => 'OKC_API.g_ret_sts_unexp_error'
476: ,x_msg_count => x_msg_count
477: ,x_msg_data => x_msg_data
478: ,p_api_type => '_PVT' );
479: WHEN OTHERS THEN

Line 480: x_return_status := okc_api.handle_exceptions (

476: ,x_msg_count => x_msg_count
477: ,x_msg_data => x_msg_data
478: ,p_api_type => '_PVT' );
479: WHEN OTHERS THEN
480: x_return_status := okc_api.handle_exceptions (
481: p_api_name => l_api_name
482: ,p_pkg_name => g_package_name
483: ,p_exc_name => 'OTHERS'
484: ,x_msg_count => x_msg_count