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_LA_PROPERTY_TAX_PVT dependencies on OKL_API

Line 51: x_return_status := OKL_API.G_RET_STS_SUCCESS;

47: WHERE id = p_chr_id);
48: -- End 4042157 fmiao 12/03/04 added update_from_contract --
49: BEGIN
50:
51: x_return_status := OKL_API.G_RET_STS_SUCCESS;
52:
53: l_chr_id := p_chr_id;
54: l_cle_id := p_cle_id;
55: -- 4374085

Line 64: x_return_status := OKL_API.START_ACTIVITY (

60: */
61:
62: -- call START_ACTIVITY to create savepoint, check compatibility
63: -- and initialize message list
64: x_return_status := OKL_API.START_ACTIVITY (
65: l_api_name
66: ,p_init_msg_list
67: ,g_api_type
68: ,x_return_status);

Line 71: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

67: ,g_api_type
68: ,x_return_status);
69:
70: -- check if activity started successfully
71: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
72: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
73: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
74: RAISE OKL_API.G_EXCEPTION_ERROR;
75: END IF;

Line 72: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

68: ,x_return_status);
69:
70: -- check if activity started successfully
71: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
72: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
73: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
74: RAISE OKL_API.G_EXCEPTION_ERROR;
75: END IF;
76:

Line 73: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

69:
70: -- check if activity started successfully
71: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
72: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
73: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
74: RAISE OKL_API.G_EXCEPTION_ERROR;
75: END IF;
76:
77: OPEN get_est_prop_tax_info(l_chr_id);

Line 74: RAISE OKL_API.G_EXCEPTION_ERROR;

70: -- check if activity started successfully
71: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
72: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
73: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
74: RAISE OKL_API.G_EXCEPTION_ERROR;
75: END IF;
76:
77: OPEN get_est_prop_tax_info(l_chr_id);
78: FETCH get_est_prop_tax_info into lv_enable_asset_default,

Line 105: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

101: x_msg_data => x_msg_data,
102: p_rgpv_rec => l_rgpv_rec,
103: x_rgpv_rec => lx_rgpv_rec);
104:
105: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
106: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
107: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
108: RAISE OKL_API.G_EXCEPTION_ERROR;
109: END IF;

Line 106: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

102: p_rgpv_rec => l_rgpv_rec,
103: x_rgpv_rec => lx_rgpv_rec);
104:
105: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
106: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
107: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
108: RAISE OKL_API.G_EXCEPTION_ERROR;
109: END IF;
110:

Line 107: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

103: x_rgpv_rec => lx_rgpv_rec);
104:
105: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
106: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
107: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
108: RAISE OKL_API.G_EXCEPTION_ERROR;
109: END IF;
110:
111: l_rgp_id := lx_rgpv_rec.id;

Line 108: RAISE OKL_API.G_EXCEPTION_ERROR;

104:
105: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
106: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
107: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
108: RAISE OKL_API.G_EXCEPTION_ERROR;
109: END IF;
110:
111: l_rgp_id := lx_rgpv_rec.id;
112:

Line 138: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

134: x_msg_count => x_msg_count,
135: x_msg_data => x_msg_data,
136: p_rulv_rec => l_rulv_rec,
137: x_rulv_rec => lx_rulv_rec);
138: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
139: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
140: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
141: RAISE OKL_API.G_EXCEPTION_ERROR;
142: END IF;

Line 139: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

135: x_msg_data => x_msg_data,
136: p_rulv_rec => l_rulv_rec,
137: x_rulv_rec => lx_rulv_rec);
138: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
139: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
140: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
141: RAISE OKL_API.G_EXCEPTION_ERROR;
142: END IF;
143:

Line 140: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

136: p_rulv_rec => l_rulv_rec,
137: x_rulv_rec => lx_rulv_rec);
138: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
139: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
140: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
141: RAISE OKL_API.G_EXCEPTION_ERROR;
142: END IF;
143:
144: -- Start 4042157 fmiao 12/03/04 added update_from_contract --

Line 141: RAISE OKL_API.G_EXCEPTION_ERROR;

137: x_rulv_rec => lx_rulv_rec);
138: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
139: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
140: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
141: RAISE OKL_API.G_EXCEPTION_ERROR;
142: END IF;
143:
144: -- Start 4042157 fmiao 12/03/04 added update_from_contract --
145: l_rulv_rec.rule_information_category := 'LAASTK';

Line 161: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

157: x_msg_count => x_msg_count,
158: x_msg_data => x_msg_data,
159: p_rulv_rec => l_rulv_rec,
160: x_rulv_rec => lx_rulv_rec);
161: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
162: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
163: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
164: RAISE OKL_API.G_EXCEPTION_ERROR;
165: END IF;

Line 162: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

158: x_msg_data => x_msg_data,
159: p_rulv_rec => l_rulv_rec,
160: x_rulv_rec => lx_rulv_rec);
161: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
162: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
163: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
164: RAISE OKL_API.G_EXCEPTION_ERROR;
165: END IF;
166: -- Start 4042157 fmiao 12/03/04 added update_from_contract --

Line 163: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

159: p_rulv_rec => l_rulv_rec,
160: x_rulv_rec => lx_rulv_rec);
161: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
162: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
163: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
164: RAISE OKL_API.G_EXCEPTION_ERROR;
165: END IF;
166: -- Start 4042157 fmiao 12/03/04 added update_from_contract --
167: END IF;

Line 164: RAISE OKL_API.G_EXCEPTION_ERROR;

160: x_rulv_rec => lx_rulv_rec);
161: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
162: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
163: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
164: RAISE OKL_API.G_EXCEPTION_ERROR;
165: END IF;
166: -- Start 4042157 fmiao 12/03/04 added update_from_contract --
167: END IF;
168:

Line 169: OKL_API.END_ACTIVITY (x_msg_count => x_msg_count,

165: END IF;
166: -- Start 4042157 fmiao 12/03/04 added update_from_contract --
167: END IF;
168:
169: OKL_API.END_ACTIVITY (x_msg_count => x_msg_count,
170: x_msg_data => x_msg_data);
171: EXCEPTION
172: WHEN OKL_API.G_EXCEPTION_ERROR THEN
173: IF get_est_prop_tax_info%ISOPEN THEN

Line 172: WHEN OKL_API.G_EXCEPTION_ERROR THEN

168:
169: OKL_API.END_ACTIVITY (x_msg_count => x_msg_count,
170: x_msg_data => x_msg_data);
171: EXCEPTION
172: WHEN OKL_API.G_EXCEPTION_ERROR THEN
173: IF get_est_prop_tax_info%ISOPEN THEN
174: CLOSE get_est_prop_tax_info;
175: END IF;
176: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 176: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

172: WHEN OKL_API.G_EXCEPTION_ERROR THEN
173: IF get_est_prop_tax_info%ISOPEN THEN
174: CLOSE get_est_prop_tax_info;
175: END IF;
176: x_return_status := OKL_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 184: WHEN OKL_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 OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
185: IF get_est_prop_tax_info%ISOPEN THEN
186: CLOSE get_est_prop_tax_info;
187: END IF;
188: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 188: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

184: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
185: IF get_est_prop_tax_info%ISOPEN THEN
186: CLOSE get_est_prop_tax_info;
187: END IF;
188: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
189: p_api_name => l_api_name,
190: p_pkg_name => g_pkg_name,
191: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
192: x_msg_count => x_msg_count,

Line 200: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

196: WHEN OTHERS THEN
197: IF get_est_prop_tax_info%ISOPEN THEN
198: CLOSE get_est_prop_tax_info;
199: END IF;
200: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
201: p_api_name => l_api_name,
202: p_pkg_name => g_pkg_name,
203: p_exc_name => 'OTHERS',
204: x_msg_count => x_msg_count,

Line 248: x_return_status := OKL_API.G_RET_STS_SUCCESS;

244: WHERE id = p_chr_id);
245:
246: BEGIN
247:
248: x_return_status := OKL_API.G_RET_STS_SUCCESS;
249:
250: l_chr_id := p_chr_id;
251:
252: IF okl_context.get_okc_org_id IS NULL THEN

Line 258: x_return_status := OKL_API.START_ACTIVITY (

254: END IF;
255:
256: -- call START_ACTIVITY to create savepoint, check compatibility
257: -- and initialize message list
258: x_return_status := OKL_API.START_ACTIVITY (
259: l_api_name
260: ,p_init_msg_list
261: ,g_api_type
262: ,x_return_status);

Line 265: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

261: ,g_api_type
262: ,x_return_status);
263:
264: -- check if activity started successfully
265: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
266: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
267: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
268: RAISE OKL_API.G_EXCEPTION_ERROR;
269: END IF;

Line 266: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

262: ,x_return_status);
263:
264: -- check if activity started successfully
265: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
266: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
267: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
268: RAISE OKL_API.G_EXCEPTION_ERROR;
269: END IF;
270:

Line 267: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

263:
264: -- check if activity started successfully
265: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
266: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
267: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
268: RAISE OKL_API.G_EXCEPTION_ERROR;
269: END IF;
270:
271: OPEN get_est_prop_tax_info(l_chr_id);

Line 268: RAISE OKL_API.G_EXCEPTION_ERROR;

264: -- check if activity started successfully
265: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
266: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
267: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
268: RAISE OKL_API.G_EXCEPTION_ERROR;
269: END IF;
270:
271: OPEN get_est_prop_tax_info(l_chr_id);
272: FETCH get_est_prop_tax_info into lv_property_tax_applicable,

Line 295: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

291: x_msg_data => x_msg_data,
292: p_rgpv_rec => l_rgpv_rec,
293: x_rgpv_rec => lx_rgpv_rec);
294:
295: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
296: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
297: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
298: RAISE OKL_API.G_EXCEPTION_ERROR;
299: END IF;

Line 296: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

292: p_rgpv_rec => l_rgpv_rec,
293: x_rgpv_rec => lx_rgpv_rec);
294:
295: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
296: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
297: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
298: RAISE OKL_API.G_EXCEPTION_ERROR;
299: END IF;
300:

Line 297: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

293: x_rgpv_rec => lx_rgpv_rec);
294:
295: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
296: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
297: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
298: RAISE OKL_API.G_EXCEPTION_ERROR;
299: END IF;
300:
301: l_rgp_id := lx_rgpv_rec.id;

Line 298: RAISE OKL_API.G_EXCEPTION_ERROR;

294:
295: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
296: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
297: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
298: RAISE OKL_API.G_EXCEPTION_ERROR;
299: END IF;
300:
301: l_rgp_id := lx_rgpv_rec.id;
302:

Line 329: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

325: x_msg_data => x_msg_data,
326: p_rulv_rec => l_rulv_rec,
327: x_rulv_rec => lx_rulv_rec);
328:
329: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
330: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
331: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
332: RAISE OKL_API.G_EXCEPTION_ERROR;
333: END IF;

Line 330: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

326: p_rulv_rec => l_rulv_rec,
327: x_rulv_rec => lx_rulv_rec);
328:
329: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
330: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
331: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
332: RAISE OKL_API.G_EXCEPTION_ERROR;
333: END IF;
334:

Line 331: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

327: x_rulv_rec => lx_rulv_rec);
328:
329: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
330: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
331: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
332: RAISE OKL_API.G_EXCEPTION_ERROR;
333: END IF;
334:
335: OKL_API.END_ACTIVITY (x_msg_count => x_msg_count,

Line 332: RAISE OKL_API.G_EXCEPTION_ERROR;

328:
329: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
330: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
331: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
332: RAISE OKL_API.G_EXCEPTION_ERROR;
333: END IF;
334:
335: OKL_API.END_ACTIVITY (x_msg_count => x_msg_count,
336: x_msg_data => x_msg_data);

Line 335: OKL_API.END_ACTIVITY (x_msg_count => x_msg_count,

331: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
332: RAISE OKL_API.G_EXCEPTION_ERROR;
333: END IF;
334:
335: OKL_API.END_ACTIVITY (x_msg_count => x_msg_count,
336: x_msg_data => x_msg_data);
337: EXCEPTION
338: WHEN OKL_API.G_EXCEPTION_ERROR THEN
339: IF get_est_prop_tax_info%ISOPEN THEN

Line 338: WHEN OKL_API.G_EXCEPTION_ERROR THEN

334:
335: OKL_API.END_ACTIVITY (x_msg_count => x_msg_count,
336: x_msg_data => x_msg_data);
337: EXCEPTION
338: WHEN OKL_API.G_EXCEPTION_ERROR THEN
339: IF get_est_prop_tax_info%ISOPEN THEN
340: CLOSE get_est_prop_tax_info;
341: END IF;
342: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 342: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

338: WHEN OKL_API.G_EXCEPTION_ERROR THEN
339: IF get_est_prop_tax_info%ISOPEN THEN
340: CLOSE get_est_prop_tax_info;
341: END IF;
342: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
343: p_api_name => l_api_name,
344: p_pkg_name => g_pkg_name,
345: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
346: x_msg_count => x_msg_count,

Line 350: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

346: x_msg_count => x_msg_count,
347: x_msg_data => x_msg_data,
348: p_api_type => g_api_type);
349:
350: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
351: IF get_est_prop_tax_info%ISOPEN THEN
352: CLOSE get_est_prop_tax_info;
353: END IF;
354: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 354: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

350: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
351: IF get_est_prop_tax_info%ISOPEN THEN
352: CLOSE get_est_prop_tax_info;
353: END IF;
354: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
355: p_api_name => l_api_name,
356: p_pkg_name => g_pkg_name,
357: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
358: x_msg_count => x_msg_count,

Line 366: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

362: WHEN OTHERS THEN
363: IF get_est_prop_tax_info%ISOPEN THEN
364: CLOSE get_est_prop_tax_info;
365: END IF;
366: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
367: p_api_name => l_api_name,
368: p_pkg_name => g_pkg_name,
369: p_exc_name => 'OTHERS',
370: x_msg_count => x_msg_count,

Line 448: x_return_status := OKL_API.G_RET_STS_SUCCESS;

444: AND rul.rule_information_category = 'LAPRTX';
445:
446: BEGIN
447:
448: x_return_status := OKL_API.G_RET_STS_SUCCESS;
449:
450: IF okl_context.get_okc_org_id IS NULL THEN
451: okl_context.set_okc_org_context(p_chr_id => p_chr_id);
452: END IF;

Line 456: x_return_status := OKL_API.START_ACTIVITY (

452: END IF;
453:
454: -- call START_ACTIVITY to create savepoint, check compatibility
455: -- and initialize message list
456: x_return_status := OKL_API.START_ACTIVITY (
457: l_api_name
458: ,p_init_msg_list
459: ,g_api_type
460: ,x_return_status);

Line 463: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

459: ,g_api_type
460: ,x_return_status);
461:
462: -- check if activity started successfully
463: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
464: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
465: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
466: RAISE OKL_API.G_EXCEPTION_ERROR;
467: END IF;

Line 464: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

460: ,x_return_status);
461:
462: -- check if activity started successfully
463: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
464: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
465: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
466: RAISE OKL_API.G_EXCEPTION_ERROR;
467: END IF;
468:

Line 465: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

461:
462: -- check if activity started successfully
463: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
464: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
465: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
466: RAISE OKL_API.G_EXCEPTION_ERROR;
467: END IF;
468:
469: OPEN get_contract_property_tax_info(p_chr_id);

Line 466: RAISE OKL_API.G_EXCEPTION_ERROR;

462: -- check if activity started successfully
463: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
464: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
465: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
466: RAISE OKL_API.G_EXCEPTION_ERROR;
467: END IF;
468:
469: OPEN get_contract_property_tax_info(p_chr_id);
470: FETCH get_contract_property_tax_info into lv_k_rule_information1,

Line 509: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

505: x_msg_data => x_msg_data,
506: p_rulv_rec => l_rulv_rec,
507: x_rulv_rec => lx_rulv_rec);
508:
509: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
510: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
511: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
512: RAISE OKL_API.G_EXCEPTION_ERROR;
513: END IF;

Line 510: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

506: p_rulv_rec => l_rulv_rec,
507: x_rulv_rec => lx_rulv_rec);
508:
509: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
510: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
511: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
512: RAISE OKL_API.G_EXCEPTION_ERROR;
513: END IF;
514: END IF;

Line 511: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

507: x_rulv_rec => lx_rulv_rec);
508:
509: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
510: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
511: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
512: RAISE OKL_API.G_EXCEPTION_ERROR;
513: END IF;
514: END IF;
515: END LOOP;

Line 512: RAISE OKL_API.G_EXCEPTION_ERROR;

508:
509: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
510: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
511: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
512: RAISE OKL_API.G_EXCEPTION_ERROR;
513: END IF;
514: END IF;
515: END LOOP;
516:

Line 517: OKL_API.END_ACTIVITY (x_msg_count => x_msg_count,

513: END IF;
514: END IF;
515: END LOOP;
516:
517: OKL_API.END_ACTIVITY (x_msg_count => x_msg_count,
518: x_msg_data => x_msg_data);
519: EXCEPTION
520: WHEN OKL_API.G_EXCEPTION_ERROR THEN
521: IF get_contract_property_tax_info%ISOPEN THEN

Line 520: WHEN OKL_API.G_EXCEPTION_ERROR THEN

516:
517: OKL_API.END_ACTIVITY (x_msg_count => x_msg_count,
518: x_msg_data => x_msg_data);
519: EXCEPTION
520: WHEN OKL_API.G_EXCEPTION_ERROR THEN
521: IF get_contract_property_tax_info%ISOPEN THEN
522: CLOSE get_contract_property_tax_info;
523: END IF;
524: IF get_asset_contract_tax_info%ISOPEN THEN

Line 533: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

529: END IF;
530: IF get_asset_property_tax_info%ISOPEN THEN
531: CLOSE get_asset_property_tax_info;
532: END IF;
533: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
534: l_api_name,
535: g_pkg_name,
536: 'OKL_API.G_RET_STS_ERROR',
537: x_msg_count,

Line 536: 'OKL_API.G_RET_STS_ERROR',

532: END IF;
533: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
534: l_api_name,
535: g_pkg_name,
536: 'OKL_API.G_RET_STS_ERROR',
537: x_msg_count,
538: x_msg_data,
539: g_api_type);
540: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 540: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

536: 'OKL_API.G_RET_STS_ERROR',
537: x_msg_count,
538: x_msg_data,
539: g_api_type);
540: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
541: IF get_contract_property_tax_info%ISOPEN THEN
542: CLOSE get_contract_property_tax_info;
543: END IF;
544: IF get_asset_contract_tax_info%ISOPEN THEN

Line 553: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

549: END IF;
550: IF get_asset_property_tax_info%ISOPEN THEN
551: CLOSE get_asset_property_tax_info;
552: END IF;
553: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
554: l_api_name,
555: g_pkg_name,
556: 'OKL_API.G_RET_STS_UNEXP_ERROR',
557: x_msg_count,

Line 556: 'OKL_API.G_RET_STS_UNEXP_ERROR',

552: END IF;
553: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
554: l_api_name,
555: g_pkg_name,
556: 'OKL_API.G_RET_STS_UNEXP_ERROR',
557: x_msg_count,
558: x_msg_data,
559: g_api_type);
560: WHEN OTHERS THEN

Line 573: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(

569: END IF;
570: IF get_asset_property_tax_info%ISOPEN THEN
571: CLOSE get_asset_property_tax_info;
572: END IF;
573: x_return_status :=OKL_API.HANDLE_EXCEPTIONS(
574: l_api_name,
575: g_pkg_name,
576: 'OTHERS',
577: x_msg_count,