DBA Data[Home] [Help]

APPS.OKL_CURE_REQ_AMT_PVT dependencies on OKC_API

Line 32: x_return_status := OKC_API.START_ACTIVITY(

28: BEGIN
29:
30: okl_debug_pub.logmessage('OKL_CURE_REQ_AMT_PVT: update_cure_request : START');
31:
32: x_return_status := OKC_API.START_ACTIVITY(
33: p_api_name => l_api_name,
34: p_pkg_name => g_pkg_name,
35: p_init_msg_list => p_init_msg_list,
36: l_api_version => l_api_version,

Line 42: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

38: p_api_type => g_api_type,
39: x_return_status => x_return_status);
40:
41: -- check if activity started successfully
42: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
43: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
44: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
45: raise OKC_API.G_EXCEPTION_ERROR;
46: End If;

Line 43: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

39: x_return_status => x_return_status);
40:
41: -- check if activity started successfully
42: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
43: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
44: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
45: raise OKC_API.G_EXCEPTION_ERROR;
46: End If;
47:

Line 44: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

40:
41: -- check if activity started successfully
42: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
43: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
44: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
45: raise OKC_API.G_EXCEPTION_ERROR;
46: End If;
47:
48:

Line 45: raise OKC_API.G_EXCEPTION_ERROR;

41: -- check if activity started successfully
42: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
43: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
44: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
45: raise OKC_API.G_EXCEPTION_ERROR;
46: End If;
47:
48:
49: If (p_cure_req_tbl.COUNT > 0) Then

Line 75: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

71: if(l_obj_vers_no is not null) Then
72: lp_camv_tbl(i).object_version_number := l_obj_vers_no;
73: End If;
74:
75: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
76: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
77: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
78: raise OKC_API.G_EXCEPTION_ERROR;
79: End If;

Line 76: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

72: lp_camv_tbl(i).object_version_number := l_obj_vers_no;
73: End If;
74:
75: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
76: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
77: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
78: raise OKC_API.G_EXCEPTION_ERROR;
79: End If;
80:

Line 77: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

73: End If;
74:
75: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
76: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
77: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
78: raise OKC_API.G_EXCEPTION_ERROR;
79: End If;
80:
81: EXIT WHEN (i = p_cure_req_tbl.LAST);

Line 78: raise OKC_API.G_EXCEPTION_ERROR;

74:
75: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
76: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
77: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
78: raise OKC_API.G_EXCEPTION_ERROR;
79: End If;
80:
81: EXIT WHEN (i = p_cure_req_tbl.LAST);
82: i := p_cure_req_tbl.NEXT(i);

Line 97: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

93: );
94:
95: okl_debug_pub.logmessage('OKL_CURE_REQ_AMT_PVT: update_cure_request : okl_cure_amounts_pub.update_cure_amounts : '||x_return_status);
96:
97: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
98: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
99: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
100: raise OKC_API.G_EXCEPTION_ERROR;
101: End If;

Line 98: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

94:
95: okl_debug_pub.logmessage('OKL_CURE_REQ_AMT_PVT: update_cure_request : okl_cure_amounts_pub.update_cure_amounts : '||x_return_status);
96:
97: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
98: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
99: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
100: raise OKC_API.G_EXCEPTION_ERROR;
101: End If;
102:

Line 99: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

95: okl_debug_pub.logmessage('OKL_CURE_REQ_AMT_PVT: update_cure_request : okl_cure_amounts_pub.update_cure_amounts : '||x_return_status);
96:
97: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
98: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
99: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
100: raise OKC_API.G_EXCEPTION_ERROR;
101: End If;
102:
103: End If;

Line 100: raise OKC_API.G_EXCEPTION_ERROR;

96:
97: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
98: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
99: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
100: raise OKC_API.G_EXCEPTION_ERROR;
101: End If;
102:
103: End If;
104:

Line 105: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

101: End If;
102:
103: End If;
104:
105: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
106:
107: okl_debug_pub.logmessage('OKL_CURE_REQ_AMT_PVT: update_cure_request : END');
108:
109: EXCEPTION

Line 110: when OKC_API.G_EXCEPTION_ERROR then

106:
107: okl_debug_pub.logmessage('OKL_CURE_REQ_AMT_PVT: update_cure_request : END');
108:
109: EXCEPTION
110: when OKC_API.G_EXCEPTION_ERROR then
111: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
112: p_api_name => l_api_name,
113: p_pkg_name => g_pkg_name,
114: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 111: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

107: okl_debug_pub.logmessage('OKL_CURE_REQ_AMT_PVT: update_cure_request : END');
108:
109: EXCEPTION
110: when OKC_API.G_EXCEPTION_ERROR then
111: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
112: p_api_name => l_api_name,
113: p_pkg_name => g_pkg_name,
114: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
115: x_msg_count => x_msg_count,

Line 114: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

110: when OKC_API.G_EXCEPTION_ERROR then
111: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
112: p_api_name => l_api_name,
113: p_pkg_name => g_pkg_name,
114: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
115: x_msg_count => x_msg_count,
116: x_msg_data => x_msg_data,
117: p_api_type => g_api_type);
118:

Line 119: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

115: x_msg_count => x_msg_count,
116: x_msg_data => x_msg_data,
117: p_api_type => g_api_type);
118:
119: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
120: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
121: p_api_name => l_api_name,
122: p_pkg_name => g_pkg_name,
123: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 120: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

116: x_msg_data => x_msg_data,
117: p_api_type => g_api_type);
118:
119: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
120: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
121: p_api_name => l_api_name,
122: p_pkg_name => g_pkg_name,
123: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
124: x_msg_count => x_msg_count,

Line 123: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

119: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
120: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
121: p_api_name => l_api_name,
122: p_pkg_name => g_pkg_name,
123: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
124: x_msg_count => x_msg_count,
125: x_msg_data => x_msg_data,
126: p_api_type => g_api_type);
127:

Line 129: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

125: x_msg_data => x_msg_data,
126: p_api_type => g_api_type);
127:
128: when OTHERS then
129: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
130: p_api_name => l_api_name,
131: p_pkg_name => g_pkg_name,
132: p_exc_name => 'OTHERS',
133: x_msg_count => x_msg_count,

Line 187: x_return_status := OKC_API.START_ACTIVITY(

183: okl_debug_pub.logmessage('OKL_CURE_REQ_AMT_PVT: update_cure_request : START');
184: okl_debug_pub.logmessage('OKL_CURE_REQ_AMT_PVT: update_cure_request : p_vendor_id : '|| p_vendor_id);
185: okl_debug_pub.logmessage('OKL_CURE_REQ_AMT_PVT: update_cure_request : p_cure_report_id : '|| p_cure_report_id);
186:
187: x_return_status := OKC_API.START_ACTIVITY(
188: p_api_name => l_api_name,
189: p_pkg_name => g_pkg_name,
190: p_init_msg_list => p_init_msg_list,
191: l_api_version => l_api_version,

Line 197: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

193: p_api_type => g_api_type,
194: x_return_status => x_return_status);
195:
196: -- check if activity started successfully
197: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
198: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
199: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
200: raise OKC_API.G_EXCEPTION_ERROR;
201: End If;

Line 198: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

194: x_return_status => x_return_status);
195:
196: -- check if activity started successfully
197: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
198: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
199: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
200: raise OKC_API.G_EXCEPTION_ERROR;
201: End If;
202: --dkagrawa added the following start

Line 199: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

195:
196: -- check if activity started successfully
197: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
198: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
199: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
200: raise OKC_API.G_EXCEPTION_ERROR;
201: End If;
202: --dkagrawa added the following start
203: OPEN c_get_contract_count(p_cure_report_id);

Line 200: raise OKC_API.G_EXCEPTION_ERROR;

196: -- check if activity started successfully
197: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
198: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
199: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
200: raise OKC_API.G_EXCEPTION_ERROR;
201: End If;
202: --dkagrawa added the following start
203: OPEN c_get_contract_count(p_cure_report_id);
204: FETCH c_get_contract_count INTO l_count;

Line 207: x_return_status := OKC_API.G_RET_STS_ERROR;

203: OPEN c_get_contract_count(p_cure_report_id);
204: FETCH c_get_contract_count INTO l_count;
205: CLOSE c_get_contract_count;
206: IF (l_count = 0) THEN
207: x_return_status := OKC_API.G_RET_STS_ERROR;
208: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
209: p_msg_name => 'OKL_CURE_REQ_CONTRACTS');
210: RAISE OKC_API.G_EXCEPTION_ERROR;
211: END IF;

Line 210: RAISE OKC_API.G_EXCEPTION_ERROR;

206: IF (l_count = 0) THEN
207: x_return_status := OKC_API.G_RET_STS_ERROR;
208: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
209: p_msg_name => 'OKL_CURE_REQ_CONTRACTS');
210: RAISE OKC_API.G_EXCEPTION_ERROR;
211: END IF;
212: --dkagrawa end
213: /*
214: lp_crtv_rec.cure_report_id := p_cure_report_id;

Line 233: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

229: x_msg_data => x_msg_data,
230: p_crtv_rec => lp_crtv_rec,
231: x_crtv_rec => lx_crtv_rec
232: );
233: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
234: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
235: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
236: raise OKC_API.G_EXCEPTION_ERROR;
237: End If;

Line 234: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

230: p_crtv_rec => lp_crtv_rec,
231: x_crtv_rec => lx_crtv_rec
232: );
233: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
234: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
235: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
236: raise OKC_API.G_EXCEPTION_ERROR;
237: End If;
238: */

Line 235: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

231: x_crtv_rec => lx_crtv_rec
232: );
233: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
234: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
235: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
236: raise OKC_API.G_EXCEPTION_ERROR;
237: End If;
238: */
239: okl_cure_wf.approve_cure_reports

Line 236: raise OKC_API.G_EXCEPTION_ERROR;

232: );
233: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
234: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
235: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
236: raise OKC_API.G_EXCEPTION_ERROR;
237: End If;
238: */
239: okl_cure_wf.approve_cure_reports
240: ( p_api_version => p_api_version

Line 241: ,p_init_msg_list => OKC_API.G_TRUE

237: End If;
238: */
239: okl_cure_wf.approve_cure_reports
240: ( p_api_version => p_api_version
241: ,p_init_msg_list => OKC_API.G_TRUE
242: ,p_commit => OKC_API.G_FALSE
243: ,p_report_id => p_cure_report_id
244: ,x_return_status => x_return_status
245: ,x_msg_count => x_msg_count

Line 242: ,p_commit => OKC_API.G_FALSE

238: */
239: okl_cure_wf.approve_cure_reports
240: ( p_api_version => p_api_version
241: ,p_init_msg_list => OKC_API.G_TRUE
242: ,p_commit => OKC_API.G_FALSE
243: ,p_report_id => p_cure_report_id
244: ,x_return_status => x_return_status
245: ,x_msg_count => x_msg_count
246: ,x_msg_data => x_msg_data );

Line 250: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

246: ,x_msg_data => x_msg_data );
247:
248: okl_debug_pub.logmessage('OKL_CURE_REQ_AMT_PVT: update_cure_request : okl_cure_wf.approve_cure_reports : '|| x_return_status);
249:
250: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
251: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
252: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
253: raise OKC_API.G_EXCEPTION_ERROR;
254: End If;

Line 251: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

247:
248: okl_debug_pub.logmessage('OKL_CURE_REQ_AMT_PVT: update_cure_request : okl_cure_wf.approve_cure_reports : '|| x_return_status);
249:
250: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
251: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
252: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
253: raise OKC_API.G_EXCEPTION_ERROR;
254: End If;
255:

Line 252: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

248: okl_debug_pub.logmessage('OKL_CURE_REQ_AMT_PVT: update_cure_request : okl_cure_wf.approve_cure_reports : '|| x_return_status);
249:
250: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
251: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
252: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
253: raise OKC_API.G_EXCEPTION_ERROR;
254: End If;
255:
256: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

Line 253: raise OKC_API.G_EXCEPTION_ERROR;

249:
250: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
251: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
252: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
253: raise OKC_API.G_EXCEPTION_ERROR;
254: End If;
255:
256: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
257:

Line 256: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

252: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
253: raise OKC_API.G_EXCEPTION_ERROR;
254: End If;
255:
256: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
257:
258: okl_debug_pub.logmessage('OKL_CURE_REQ_AMT_PVT: update_cure_request : END');
259:
260: EXCEPTION

Line 261: when OKC_API.G_EXCEPTION_ERROR then

257:
258: okl_debug_pub.logmessage('OKL_CURE_REQ_AMT_PVT: update_cure_request : END');
259:
260: EXCEPTION
261: when OKC_API.G_EXCEPTION_ERROR then
262: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
263: p_api_name => l_api_name,
264: p_pkg_name => g_pkg_name,
265: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 262: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

258: okl_debug_pub.logmessage('OKL_CURE_REQ_AMT_PVT: update_cure_request : END');
259:
260: EXCEPTION
261: when OKC_API.G_EXCEPTION_ERROR then
262: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
263: p_api_name => l_api_name,
264: p_pkg_name => g_pkg_name,
265: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
266: x_msg_count => x_msg_count,

Line 265: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

261: when OKC_API.G_EXCEPTION_ERROR then
262: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
263: p_api_name => l_api_name,
264: p_pkg_name => g_pkg_name,
265: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
266: x_msg_count => x_msg_count,
267: x_msg_data => x_msg_data,
268: p_api_type => g_api_type);
269:

Line 270: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

266: x_msg_count => x_msg_count,
267: x_msg_data => x_msg_data,
268: p_api_type => g_api_type);
269:
270: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
271: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
272: p_api_name => l_api_name,
273: p_pkg_name => g_pkg_name,
274: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 271: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

267: x_msg_data => x_msg_data,
268: p_api_type => g_api_type);
269:
270: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
271: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
272: p_api_name => l_api_name,
273: p_pkg_name => g_pkg_name,
274: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
275: x_msg_count => x_msg_count,

Line 274: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

270: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
271: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
272: p_api_name => l_api_name,
273: p_pkg_name => g_pkg_name,
274: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
275: x_msg_count => x_msg_count,
276: x_msg_data => x_msg_data,
277: p_api_type => g_api_type);
278:

Line 280: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

276: x_msg_data => x_msg_data,
277: p_api_type => g_api_type);
278:
279: when OTHERS then
280: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
281: p_api_name => l_api_name,
282: p_pkg_name => g_pkg_name,
283: p_exc_name => 'OTHERS',
284: x_msg_count => x_msg_count,