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.OKL_CURE_VNDR_RFND_PVT dependencies on OKC_API

Line 45: x_return_status := OKC_API.START_ACTIVITY(

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,

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

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;

Line 56: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

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

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

Line 58: raise OKC_API.G_EXCEPTION_ERROR;

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;

Line 82: x_return_status := OKC_API.g_ret_sts_error;

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;

Line 83: OKC_API.SET_MESSAGE( p_app_name => g_app_name

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;

Line 86: raise OKC_API.G_EXCEPTION_ERROR;

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;

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

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;

Line 111: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

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

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

Line 113: raise OKC_API.G_EXCEPTION_ERROR;

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:

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

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;

Line 146: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

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

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

Line 148: raise OKC_API.G_EXCEPTION_ERROR;

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:

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

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;

Line 164: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

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

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;

Line 166: raise OKC_API.G_EXCEPTION_ERROR;

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:

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

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(

Line 175: when OKC_API.G_EXCEPTION_ERROR then

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',

Line 176: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

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

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:

Line 184: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

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',

Line 185: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

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

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:

Line 194: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

Line 245: x_return_status := OKC_API.START_ACTIVITY(

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,

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

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;

Line 256: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

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

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:

Line 258: raise OKC_API.G_EXCEPTION_ERROR;

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

Line 283: x_return_status := OKC_API.g_ret_sts_error;

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;

Line 284: OKC_API.SET_MESSAGE( p_app_name => g_app_name

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;

Line 287: raise OKC_API.G_EXCEPTION_ERROR;

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;

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

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;

Line 312: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

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

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

Line 314: raise OKC_API.G_EXCEPTION_ERROR;

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:

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

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;

Line 347: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

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

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

Line 349: raise OKC_API.G_EXCEPTION_ERROR;

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:

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

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;

Line 365: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

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

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;

Line 367: raise OKC_API.G_EXCEPTION_ERROR;

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:

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

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(

Line 375: when OKC_API.G_EXCEPTION_ERROR then

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',

Line 376: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

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

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:

Line 384: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

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',

Line 385: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

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

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:

Line 394: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

Line 446: x_return_status := OKC_API.START_ACTIVITY(

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,

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

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;

Line 457: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

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

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

Line 459: raise OKC_API.G_EXCEPTION_ERROR;

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;

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

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;

Line 501: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

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

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

Line 503: raise OKC_API.G_EXCEPTION_ERROR;

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:

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

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;

Line 535: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

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

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

Line 537: raise OKC_API.G_EXCEPTION_ERROR;

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:

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

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;

Line 553: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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:

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

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;

Line 555: raise OKC_API.G_EXCEPTION_ERROR;

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:

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

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(

Line 564: when OKC_API.G_EXCEPTION_ERROR then

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',

Line 565: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

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

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:

Line 573: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

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',

Line 574: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,

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

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:

Line 583: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

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,