41: where cure_refund_header_id = l_cure_refund_header_id;
42:
43: BEGIN
44:
45: x_return_status := OKC_API.START_ACTIVITY(
46: p_api_name => l_api_name,
47: p_pkg_name => g_pkg_name,
48: p_init_msg_list => p_init_msg_list,
49: l_api_version => l_api_version,
51: p_api_type => g_api_type,
52: x_return_status => x_return_status);
53:
54: -- check if activity started successfully
55: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
56: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
57: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
58: raise OKC_API.G_EXCEPTION_ERROR;
59: End If;
52: x_return_status => x_return_status);
53:
54: -- check if activity started successfully
55: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
56: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
57: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
58: raise OKC_API.G_EXCEPTION_ERROR;
59: End If;
60:
53:
54: -- check if activity started successfully
55: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
56: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
57: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
58: raise OKC_API.G_EXCEPTION_ERROR;
59: End If;
60:
61: If (p_cure_rfnd_tbl.COUNT > 0) Then
54: -- check if activity started successfully
55: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
56: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
57: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
58: raise OKC_API.G_EXCEPTION_ERROR;
59: End If;
60:
61: If (p_cure_rfnd_tbl.COUNT > 0) Then
62: i := p_cure_rfnd_tbl.FIRST;
78:
79: lp_crfv_tbl(i).disbursement_amount := p_cure_rfnd_tbl(i).received_amount - nvl(p_cure_rfnd_tbl(i).offset_amount,0);
80:
81: If (nvl(p_cure_rfnd_tbl(i).offset_amount,0) > p_cure_rfnd_tbl(i).received_amount) Then
82: x_return_status := OKC_API.g_ret_sts_error;
83: OKC_API.SET_MESSAGE( p_app_name => g_app_name
84: , p_msg_name => 'OKL_CURE_RFND_OFST_CHK'
85: );
86: raise OKC_API.G_EXCEPTION_ERROR;
79: lp_crfv_tbl(i).disbursement_amount := p_cure_rfnd_tbl(i).received_amount - nvl(p_cure_rfnd_tbl(i).offset_amount,0);
80:
81: If (nvl(p_cure_rfnd_tbl(i).offset_amount,0) > p_cure_rfnd_tbl(i).received_amount) Then
82: x_return_status := OKC_API.g_ret_sts_error;
83: OKC_API.SET_MESSAGE( p_app_name => g_app_name
84: , p_msg_name => 'OKL_CURE_RFND_OFST_CHK'
85: );
86: raise OKC_API.G_EXCEPTION_ERROR;
87: End If;
82: x_return_status := OKC_API.g_ret_sts_error;
83: OKC_API.SET_MESSAGE( p_app_name => g_app_name
84: , p_msg_name => 'OKL_CURE_RFND_OFST_CHK'
85: );
86: raise OKC_API.G_EXCEPTION_ERROR;
87: End If;
88:
89: -- refund stage info
90: lp_crsv_tbl(i).cure_refund_stage_id := p_cure_rfnd_tbl(i).cure_refund_stage_id;
106: p_crfv_tbl => lp_crfv_tbl,
107: x_crfv_tbl => lx_crfv_tbl
108: );
109:
110: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
111: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
112: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
113: raise OKC_API.G_EXCEPTION_ERROR;
114: End If;
107: x_crfv_tbl => lx_crfv_tbl
108: );
109:
110: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
111: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
112: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
113: raise OKC_API.G_EXCEPTION_ERROR;
114: End If;
115:
108: );
109:
110: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
111: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
112: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
113: raise OKC_API.G_EXCEPTION_ERROR;
114: End If;
115:
116: -- refund header info
109:
110: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
111: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
112: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
113: raise OKC_API.G_EXCEPTION_ERROR;
114: End If;
115:
116: -- refund header info
117:
141: p_chdv_rec => lp_chdv_rec,
142: x_chdv_rec => lx_chdv_rec
143: );
144:
145: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
146: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
147: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
148: raise OKC_API.G_EXCEPTION_ERROR;
149: End If;
142: x_chdv_rec => lx_chdv_rec
143: );
144:
145: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
146: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
147: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
148: raise OKC_API.G_EXCEPTION_ERROR;
149: End If;
150:
143: );
144:
145: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
146: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
147: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
148: raise OKC_API.G_EXCEPTION_ERROR;
149: End If;
150:
151: -- refund stage info
144:
145: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
146: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
147: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
148: raise OKC_API.G_EXCEPTION_ERROR;
149: End If;
150:
151: -- refund stage info
152:
159: p_crsv_tbl => lp_crsv_tbl,
160: x_crsv_tbl => lx_crsv_tbl
161: );
162:
163: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
164: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
165: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
166: raise OKC_API.G_EXCEPTION_ERROR;
167: End If;
160: x_crsv_tbl => lx_crsv_tbl
161: );
162:
163: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
164: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
165: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
166: raise OKC_API.G_EXCEPTION_ERROR;
167: End If;
168:
161: );
162:
163: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
164: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
165: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
166: raise OKC_API.G_EXCEPTION_ERROR;
167: End If;
168:
169: End If;
162:
163: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
164: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
165: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
166: raise OKC_API.G_EXCEPTION_ERROR;
167: End If;
168:
169: End If;
170:
168:
169: End If;
170:
171:
172: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
173:
174: EXCEPTION
175: when OKC_API.G_EXCEPTION_ERROR then
176: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
171:
172: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
173:
174: EXCEPTION
175: when OKC_API.G_EXCEPTION_ERROR then
176: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
177: p_api_name => l_api_name,
178: p_pkg_name => g_pkg_name,
179: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
172: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
173:
174: EXCEPTION
175: when OKC_API.G_EXCEPTION_ERROR then
176: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
177: p_api_name => l_api_name,
178: p_pkg_name => g_pkg_name,
179: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
180: x_msg_count => x_msg_count,
175: when OKC_API.G_EXCEPTION_ERROR then
176: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
177: p_api_name => l_api_name,
178: p_pkg_name => g_pkg_name,
179: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
180: x_msg_count => x_msg_count,
181: x_msg_data => x_msg_data,
182: p_api_type => g_api_type);
183:
180: x_msg_count => x_msg_count,
181: x_msg_data => x_msg_data,
182: p_api_type => g_api_type);
183:
184: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
185: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
186: p_api_name => l_api_name,
187: p_pkg_name => g_pkg_name,
188: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
181: x_msg_data => x_msg_data,
182: p_api_type => g_api_type);
183:
184: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
185: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
186: p_api_name => l_api_name,
187: p_pkg_name => g_pkg_name,
188: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
189: x_msg_count => x_msg_count,
184: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
185: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
186: p_api_name => l_api_name,
187: p_pkg_name => g_pkg_name,
188: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
189: x_msg_count => x_msg_count,
190: x_msg_data => x_msg_data,
191: p_api_type => g_api_type);
192:
190: x_msg_data => x_msg_data,
191: p_api_type => g_api_type);
192:
193: when OTHERS then
194: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
195: p_api_name => l_api_name,
196: p_pkg_name => g_pkg_name,
197: p_exc_name => 'OTHERS',
198: x_msg_count => x_msg_count,
241: where cure_refund_header_id = l_cure_refund_header_id;
242:
243: BEGIN
244:
245: x_return_status := OKC_API.START_ACTIVITY(
246: p_api_name => l_api_name,
247: p_pkg_name => g_pkg_name,
248: p_init_msg_list => p_init_msg_list,
249: l_api_version => l_api_version,
251: p_api_type => g_api_type,
252: x_return_status => x_return_status);
253:
254: -- check if activity started successfully
255: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
256: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
257: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
258: raise OKC_API.G_EXCEPTION_ERROR;
259: End If;
252: x_return_status => x_return_status);
253:
254: -- check if activity started successfully
255: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
256: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
257: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
258: raise OKC_API.G_EXCEPTION_ERROR;
259: End If;
260:
253:
254: -- check if activity started successfully
255: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
256: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
257: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
258: raise OKC_API.G_EXCEPTION_ERROR;
259: End If;
260:
261:
254: -- check if activity started successfully
255: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
256: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
257: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
258: raise OKC_API.G_EXCEPTION_ERROR;
259: End If;
260:
261:
262: If (p_cure_rfnd_tbl.COUNT > 0) Then
279:
280: lp_crfv_tbl(i).disbursement_amount := p_cure_rfnd_tbl(i).received_amount - nvl(p_cure_rfnd_tbl(i).offset_amount,0);
281:
282: If (nvl(p_cure_rfnd_tbl(i).offset_amount,0) > p_cure_rfnd_tbl(i).received_amount) Then
283: x_return_status := OKC_API.g_ret_sts_error;
284: OKC_API.SET_MESSAGE( p_app_name => g_app_name
285: , p_msg_name => 'OKL_CURE_RFND_OFST_CHK'
286: );
287: raise OKC_API.G_EXCEPTION_ERROR;
280: lp_crfv_tbl(i).disbursement_amount := p_cure_rfnd_tbl(i).received_amount - nvl(p_cure_rfnd_tbl(i).offset_amount,0);
281:
282: If (nvl(p_cure_rfnd_tbl(i).offset_amount,0) > p_cure_rfnd_tbl(i).received_amount) Then
283: x_return_status := OKC_API.g_ret_sts_error;
284: OKC_API.SET_MESSAGE( p_app_name => g_app_name
285: , p_msg_name => 'OKL_CURE_RFND_OFST_CHK'
286: );
287: raise OKC_API.G_EXCEPTION_ERROR;
288: End If;
283: x_return_status := OKC_API.g_ret_sts_error;
284: OKC_API.SET_MESSAGE( p_app_name => g_app_name
285: , p_msg_name => 'OKL_CURE_RFND_OFST_CHK'
286: );
287: raise OKC_API.G_EXCEPTION_ERROR;
288: End If;
289:
290: -- refund stage info
291: lp_crsv_tbl(i).cure_refund_stage_id := p_cure_rfnd_tbl(i).cure_refund_stage_id;
307: p_crfv_tbl => lp_crfv_tbl,
308: x_crfv_tbl => lx_crfv_tbl
309: );
310:
311: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
312: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
313: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
314: raise OKC_API.G_EXCEPTION_ERROR;
315: End If;
308: x_crfv_tbl => lx_crfv_tbl
309: );
310:
311: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
312: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
313: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
314: raise OKC_API.G_EXCEPTION_ERROR;
315: End If;
316:
309: );
310:
311: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
312: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
313: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
314: raise OKC_API.G_EXCEPTION_ERROR;
315: End If;
316:
317: -- refund header info
310:
311: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
312: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
313: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
314: raise OKC_API.G_EXCEPTION_ERROR;
315: End If;
316:
317: -- refund header info
318:
342: p_chdv_rec => lp_chdv_rec,
343: x_chdv_rec => lx_chdv_rec
344: );
345:
346: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
347: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
348: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
349: raise OKC_API.G_EXCEPTION_ERROR;
350: End If;
343: x_chdv_rec => lx_chdv_rec
344: );
345:
346: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
347: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
348: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
349: raise OKC_API.G_EXCEPTION_ERROR;
350: End If;
351:
344: );
345:
346: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
347: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
348: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
349: raise OKC_API.G_EXCEPTION_ERROR;
350: End If;
351:
352: -- refund stage info
345:
346: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
347: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
348: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
349: raise OKC_API.G_EXCEPTION_ERROR;
350: End If;
351:
352: -- refund stage info
353:
360: p_crsv_tbl => lp_crsv_tbl,
361: x_crsv_tbl => lx_crsv_tbl
362: );
363:
364: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
365: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
366: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
367: raise OKC_API.G_EXCEPTION_ERROR;
368: End If;
361: x_crsv_tbl => lx_crsv_tbl
362: );
363:
364: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
365: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
366: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
367: raise OKC_API.G_EXCEPTION_ERROR;
368: End If;
369:
362: );
363:
364: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
365: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
366: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
367: raise OKC_API.G_EXCEPTION_ERROR;
368: End If;
369:
370: End If;
363:
364: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
365: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
366: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
367: raise OKC_API.G_EXCEPTION_ERROR;
368: End If;
369:
370: End If;
371:
368: End If;
369:
370: End If;
371:
372: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
373:
374: EXCEPTION
375: when OKC_API.G_EXCEPTION_ERROR then
376: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
371:
372: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
373:
374: EXCEPTION
375: when OKC_API.G_EXCEPTION_ERROR then
376: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
377: p_api_name => l_api_name,
378: p_pkg_name => g_pkg_name,
379: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
372: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
373:
374: EXCEPTION
375: when OKC_API.G_EXCEPTION_ERROR then
376: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
377: p_api_name => l_api_name,
378: p_pkg_name => g_pkg_name,
379: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
380: x_msg_count => x_msg_count,
375: when OKC_API.G_EXCEPTION_ERROR then
376: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
377: p_api_name => l_api_name,
378: p_pkg_name => g_pkg_name,
379: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
380: x_msg_count => x_msg_count,
381: x_msg_data => x_msg_data,
382: p_api_type => g_api_type);
383:
380: x_msg_count => x_msg_count,
381: x_msg_data => x_msg_data,
382: p_api_type => g_api_type);
383:
384: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
385: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
386: p_api_name => l_api_name,
387: p_pkg_name => g_pkg_name,
388: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
381: x_msg_data => x_msg_data,
382: p_api_type => g_api_type);
383:
384: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
385: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
386: p_api_name => l_api_name,
387: p_pkg_name => g_pkg_name,
388: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
389: x_msg_count => x_msg_count,
384: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
385: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
386: p_api_name => l_api_name,
387: p_pkg_name => g_pkg_name,
388: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
389: x_msg_count => x_msg_count,
390: x_msg_data => x_msg_data,
391: p_api_type => g_api_type);
392:
390: x_msg_data => x_msg_data,
391: p_api_type => g_api_type);
392:
393: when OTHERS then
394: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
395: p_api_name => l_api_name,
396: p_pkg_name => g_pkg_name,
397: p_exc_name => 'OTHERS',
398: x_msg_count => x_msg_count,
442: where cure_refund_header_id = l_cure_refund_header_id;
443:
444: BEGIN
445:
446: x_return_status := OKC_API.START_ACTIVITY(
447: p_api_name => l_api_name,
448: p_pkg_name => g_pkg_name,
449: p_init_msg_list => p_init_msg_list,
450: l_api_version => l_api_version,
452: p_api_type => g_api_type,
453: x_return_status => x_return_status);
454:
455: -- check if activity started successfully
456: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
457: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
458: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
459: raise OKC_API.G_EXCEPTION_ERROR;
460: End If;
453: x_return_status => x_return_status);
454:
455: -- check if activity started successfully
456: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
457: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
458: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
459: raise OKC_API.G_EXCEPTION_ERROR;
460: End If;
461:
454:
455: -- check if activity started successfully
456: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
457: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
458: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
459: raise OKC_API.G_EXCEPTION_ERROR;
460: End If;
461:
462: If (p_cure_rfnd_tbl.COUNT > 0) Then
455: -- check if activity started successfully
456: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
457: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
458: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
459: raise OKC_API.G_EXCEPTION_ERROR;
460: End If;
461:
462: If (p_cure_rfnd_tbl.COUNT > 0) Then
463: i := p_cure_rfnd_tbl.FIRST;
496: x_msg_data => x_msg_data,
497: p_crfv_tbl => lp_crfv_tbl
498: );
499:
500: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
501: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
502: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
503: raise OKC_API.G_EXCEPTION_ERROR;
504: End If;
497: p_crfv_tbl => lp_crfv_tbl
498: );
499:
500: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
501: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
502: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
503: raise OKC_API.G_EXCEPTION_ERROR;
504: End If;
505:
498: );
499:
500: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
501: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
502: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
503: raise OKC_API.G_EXCEPTION_ERROR;
504: End If;
505:
506: -- refund header info
499:
500: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
501: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
502: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
503: raise OKC_API.G_EXCEPTION_ERROR;
504: End If;
505:
506: -- refund header info
507:
530: p_chdv_rec => lp_chdv_rec,
531: x_chdv_rec => lx_chdv_rec
532: );
533:
534: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
535: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
536: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
537: raise OKC_API.G_EXCEPTION_ERROR;
538: End If;
531: x_chdv_rec => lx_chdv_rec
532: );
533:
534: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
535: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
536: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
537: raise OKC_API.G_EXCEPTION_ERROR;
538: End If;
539:
532: );
533:
534: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
535: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
536: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
537: raise OKC_API.G_EXCEPTION_ERROR;
538: End If;
539:
540: -- refund stage info
533:
534: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
535: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
536: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
537: raise OKC_API.G_EXCEPTION_ERROR;
538: End If;
539:
540: -- refund stage info
541:
548: p_crsv_tbl => lp_crsv_tbl,
549: x_crsv_tbl => lx_crsv_tbl
550: );
551:
552: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
553: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
554: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
555: raise OKC_API.G_EXCEPTION_ERROR;
556: End If;
549: x_crsv_tbl => lx_crsv_tbl
550: );
551:
552: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
553: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
554: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
555: raise OKC_API.G_EXCEPTION_ERROR;
556: End If;
557:
550: );
551:
552: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
553: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
554: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
555: raise OKC_API.G_EXCEPTION_ERROR;
556: End If;
557:
558: End If;
551:
552: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
553: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
554: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
555: raise OKC_API.G_EXCEPTION_ERROR;
556: End If;
557:
558: End If;
559:
557:
558: End If;
559:
560:
561: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
562:
563: EXCEPTION
564: when OKC_API.G_EXCEPTION_ERROR then
565: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
560:
561: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
562:
563: EXCEPTION
564: when OKC_API.G_EXCEPTION_ERROR then
565: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
566: p_api_name => l_api_name,
567: p_pkg_name => g_pkg_name,
568: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
561: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
562:
563: EXCEPTION
564: when OKC_API.G_EXCEPTION_ERROR then
565: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
566: p_api_name => l_api_name,
567: p_pkg_name => g_pkg_name,
568: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
569: x_msg_count => x_msg_count,
564: when OKC_API.G_EXCEPTION_ERROR then
565: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
566: p_api_name => l_api_name,
567: p_pkg_name => g_pkg_name,
568: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
569: x_msg_count => x_msg_count,
570: x_msg_data => x_msg_data,
571: p_api_type => g_api_type);
572:
569: x_msg_count => x_msg_count,
570: x_msg_data => x_msg_data,
571: p_api_type => g_api_type);
572:
573: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
574: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
575: p_api_name => l_api_name,
576: p_pkg_name => g_pkg_name,
577: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
570: x_msg_data => x_msg_data,
571: p_api_type => g_api_type);
572:
573: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
574: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
575: p_api_name => l_api_name,
576: p_pkg_name => g_pkg_name,
577: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
578: x_msg_count => x_msg_count,
573: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
574: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
575: p_api_name => l_api_name,
576: p_pkg_name => g_pkg_name,
577: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
578: x_msg_count => x_msg_count,
579: x_msg_data => x_msg_data,
580: p_api_type => g_api_type);
581:
579: x_msg_data => x_msg_data,
580: p_api_type => g_api_type);
581:
582: when OTHERS then
583: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
584: p_api_name => l_api_name,
585: p_pkg_name => g_pkg_name,
586: p_exc_name => 'OTHERS',
587: x_msg_count => x_msg_count,