APPS.OKL_ACTIVATE_CONTRACT_PUB dependencies on OKL_API

Line 22: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

18: l_sty_id NUMBER;
19:
20: BEGIN
21:
22: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
23:
24: OPEN pry_sty_csr;
25: FETCH pry_sty_csr INTO l_sty_id;
26: IF pry_sty_csr%NOTFOUND THEN

Line 27: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

23:
24: OPEN pry_sty_csr;
25: FETCH pry_sty_csr INTO l_sty_id;
26: IF pry_sty_csr%NOTFOUND THEN
27: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
28: p_msg_name => 'OKL_NO_PRY_STY_FOUND',
29: p_token1 => 'PURPOSE',
30: p_token1_value => p_stream_type_purpose);
31: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 31: RAISE Okl_Api.G_EXCEPTION_ERROR;

27: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
28: p_msg_name => 'OKL_NO_PRY_STY_FOUND',
29: p_token1 => 'PURPOSE',
30: p_token1_value => p_stream_type_purpose);
31: RAISE Okl_Api.G_EXCEPTION_ERROR;
32: END IF;
33: CLOSE pry_sty_csr;
34:
35: x_sty_id := l_sty_id;

Line 38: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

34:
35: x_sty_id := l_sty_id;
36:
37: EXCEPTION
38: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
39: IF pry_sty_csr%ISOPEN THEN
40: CLOSE pry_sty_csr;
41: END IF;
42: x_return_status := Okl_Api.G_RET_STS_ERROR ;

Line 42: x_return_status := Okl_Api.G_RET_STS_ERROR ;

38: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
39: IF pry_sty_csr%ISOPEN THEN
40: CLOSE pry_sty_csr;
41: END IF;
42: x_return_status := Okl_Api.G_RET_STS_ERROR ;
43:
44: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
45: IF pry_sty_csr%ISOPEN THEN
46: CLOSE pry_sty_csr;

Line 44: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

40: CLOSE pry_sty_csr;
41: END IF;
42: x_return_status := Okl_Api.G_RET_STS_ERROR ;
43:
44: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
45: IF pry_sty_csr%ISOPEN THEN
46: CLOSE pry_sty_csr;
47: END IF;
48: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 48: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

44: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
45: IF pry_sty_csr%ISOPEN THEN
46: CLOSE pry_sty_csr;
47: END IF;
48: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
49:
50: WHEN OTHERS THEN
51: IF pry_sty_csr%ISOPEN THEN
52: CLOSE pry_sty_csr;

Line 54: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

50: WHEN OTHERS THEN
51: IF pry_sty_csr%ISOPEN THEN
52: CLOSE pry_sty_csr;
53: END IF;
54: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
55: --DBMS_OUTPUT.PUT_LINE(SQLERRM);
56:
57: END get_stream_id;
58:

Line 70: -- OUT Parameter x_return_status - will return OKL_API.G_RET_STS_SUCCESS or

66: -- IN Parameters -
67: -- IN Parameters -
68: -- p_rbk_chr_id - contract id of rebook copy contract
69: -- p_orig_chr_id - contract id of original contract
70: -- OUT Parameter x_return_status - will return OKL_API.G_RET_STS_SUCCESS or
71: -- OKL_API.G_RET_STS_ERROR
72: --
73: -- 03-Jul-2009 rpillay Bug# 8652738: Modified API to only validate
74: -- if an add-on has been deleted during rebook.

Line 71: -- OKL_API.G_RET_STS_ERROR

67: -- IN Parameters -
68: -- p_rbk_chr_id - contract id of rebook copy contract
69: -- p_orig_chr_id - contract id of original contract
70: -- OUT Parameter x_return_status - will return OKL_API.G_RET_STS_SUCCESS or
71: -- OKL_API.G_RET_STS_ERROR
72: --
73: -- 03-Jul-2009 rpillay Bug# 8652738: Modified API to only validate
74: -- if an add-on has been deleted during rebook.
75: -- Addition and Update of Add-on and Update of

Line 84: l_return_status varchar2(1) default OKL_API.G_RET_STS_SUCCESS;

80: Procedure Is_Rebook_Supported (p_rbk_chr_id IN NUMBER,
81: p_orig_chr_id IN NUMBER,
82: x_return_status OUT NOCOPY VARCHAR2) is
83:
84: l_return_status varchar2(1) default OKL_API.G_RET_STS_SUCCESS;
85:
86: l_asset_number okc_k_lines_tl.name%TYPE default NULL;
87:
88: ------------------------------------------------------

Line 139: x_return_status := OKL_API.G_RET_STS_SUCCESS;

135:
136: l_unsupported_rebook_modfn EXCEPTION;
137:
138: begin
139: x_return_status := OKL_API.G_RET_STS_SUCCESS;
140:
141: l_asset_number := NULL;
142:
143: --4.0 check if new addon has been deleted

Line 152: If nvl(l_asset_number,OKL_API.G_MISS_CHAR) <> OKL_API.G_MISS_CHAR then

148: NULL;
149: End If;
150: Close l_deleted_Addon_csr;
151:
152: If nvl(l_asset_number,OKL_API.G_MISS_CHAR) <> OKL_API.G_MISS_CHAR then
153: OKL_API.set_message(
154: p_app_name => G_APP_NAME,
155: p_msg_name => 'OKL_REBOOK_UNSUPPORTED_MODFN'
156: );

Line 153: OKL_API.set_message(

149: End If;
150: Close l_deleted_Addon_csr;
151:
152: If nvl(l_asset_number,OKL_API.G_MISS_CHAR) <> OKL_API.G_MISS_CHAR then
153: OKL_API.set_message(
154: p_app_name => G_APP_NAME,
155: p_msg_name => 'OKL_REBOOK_UNSUPPORTED_MODFN'
156: );
157: raise l_unsupported_rebook_modfn;

Line 165: x_return_status := OKL_API.G_RET_STS_ERROR;

161: When l_unsupported_rebook_modfn then
162: If l_deleted_addon_csr%ISOPEN then
163: close l_deleted_addon_csr;
164: End If;
165: x_return_status := OKL_API.G_RET_STS_ERROR;
166: When OTHERS then
167: If l_deleted_addon_csr%ISOPEN then
168: close l_deleted_addon_csr;
169: End If;

Line 170: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

166: When OTHERS then
167: If l_deleted_addon_csr%ISOPEN then
168: close l_deleted_addon_csr;
169: End If;
170: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
171:
172: End Is_Rebook_Supported;
173: --Bug# 3310972
174: --------------------------------------------------------------------------------

Line 189: l_return_status varchar2(1) default OKL_API.G_RET_STS_SUCCESS;

185: --End of Comments
186: --------------------------------------------------------------------------------
187: Procedure Validate_bill_To(p_chr_id IN Number,
188: x_return_status OUT NOCOPY VARCHAR2) is
189: l_return_status varchar2(1) default OKL_API.G_RET_STS_SUCCESS;
190:
191: --cursor to fetch rule values for customer account and bill to at
192: --contract level and contract line level
193:

Line 228: l_return_status varchar2(1) default OKL_API.G_RET_STS_SUCCESS;

224:
225: --Local function to determine whether BTO is active
226: Function is_bto_active(p_bto_id IN Varchar2,
227: p_custacct_id IN Varchar2) return Varchar2 is
228: l_return_status varchar2(1) default OKL_API.G_RET_STS_SUCCESS;
229:
230: --cursor to find BTO status
231: Cursor l_bto_sts_csr(btoid IN NUMBER,
232: custacctid IN NUMBER) is

Line 251: l_return_status := OKL_API.G_RET_STS_SUCCESS;

247:
248:
249: Begin
250: ----
251: l_return_status := OKL_API.G_RET_STS_SUCCESS;
252: l_bto_status := 'I'; -- inactive
253:
254: l_bto_id := to_number(p_bto_id);
255: l_custacct_id := to_number(p_custacct_id);

Line 266: l_return_status := OKL_API.G_RET_STS_ERROR;

262: End If;
263: close l_bto_sts_csr;
264:
265: if l_bto_status = 'I' then
266: l_return_status := OKL_API.G_RET_STS_ERROR;
267: end if;
268: Return(l_return_status);
269:
270: exception

Line 275: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

271: when others then
272: if l_bto_sts_csr%ISOPEN then
273: close l_bto_sts_csr;
274: end if;
275: l_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
276: return(l_return_status);
277: end is_bto_active;
278:
279: Begin

Line 281: l_return_status := OKL_API.G_RET_STS_SUCCESS;

277: end is_bto_active;
278:
279: Begin
280: -----
281: l_return_status := OKL_API.G_RET_STS_SUCCESS;
282:
283: --fetch contract customer account at contract header level
284: open l_chrb_csr(ChrId => p_chr_id);
285: Fetch l_chrb_csr into l_bto_id,l_custacct_id;

Line 294: If l_return_status = OKL_API.G_RET_STS_ERROR then

290:
291: --check if bto is active at contract header level
292: l_return_status := is_bto_active(p_bto_id => l_bto_id,
293: p_custacct_id => l_custacct_id);
294: If l_return_status = OKL_API.G_RET_STS_ERROR then
295: --set error message
296: OKL_API.set_message(
297: p_app_name => G_APP_NAME,
298: p_msg_name => 'OKL_QA_INVALID_BILLTO'

Line 296: OKL_API.set_message(

292: l_return_status := is_bto_active(p_bto_id => l_bto_id,
293: p_custacct_id => l_custacct_id);
294: If l_return_status = OKL_API.G_RET_STS_ERROR then
295: --set error message
296: OKL_API.set_message(
297: p_app_name => G_APP_NAME,
298: p_msg_name => 'OKL_QA_INVALID_BILLTO'
299: );
300: Elsif l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then

Line 300: Elsif l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then

296: OKL_API.set_message(
297: p_app_name => G_APP_NAME,
298: p_msg_name => 'OKL_QA_INVALID_BILLTO'
299: );
300: Elsif l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
301: Null;
302: End If;
303:
304:

Line 305: If l_return_status = OKL_API.G_RET_STS_SUCCESS then

301: Null;
302: End If;
303:
304:
305: If l_return_status = OKL_API.G_RET_STS_SUCCESS then
306: --fetch bill to at contract line level
307: open l_cleb_csr(ChrId => p_chr_id);
308: Loop
309: Fetch l_cleb_csr into l_bto_id;

Line 314: If l_return_status = OKL_API.G_RET_STS_ERROR then

310: Exit when l_cleb_csr%NOTFOUND;
311: --check if bto is active at contract line level
312: l_return_status := is_bto_active(p_bto_id => l_bto_id,
313: p_custacct_id => l_custacct_id);
314: If l_return_status = OKL_API.G_RET_STS_ERROR then
315: --set error message
316: OKL_API.set_message(
317: p_app_name => G_APP_NAME,
318: p_msg_name => 'OKL_QA_INVALID_BILLTO'

Line 316: OKL_API.set_message(

312: l_return_status := is_bto_active(p_bto_id => l_bto_id,
313: p_custacct_id => l_custacct_id);
314: If l_return_status = OKL_API.G_RET_STS_ERROR then
315: --set error message
316: OKL_API.set_message(
317: p_app_name => G_APP_NAME,
318: p_msg_name => 'OKL_QA_INVALID_BILLTO'
319: );
320: Exit;

Line 321: Elsif l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then

317: p_app_name => G_APP_NAME,
318: p_msg_name => 'OKL_QA_INVALID_BILLTO'
319: );
320: Exit;
321: Elsif l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
322: Exit;
323: End If;
324: End Loop;
325: Close l_cleb_csr;

Line 329: If l_return_status = OKL_API.G_RET_STS_SUCCESS then

325: Close l_cleb_csr;
326: End If;
327:
328:
329: If l_return_status = OKL_API.G_RET_STS_SUCCESS then
330: --fetch bill to and cust account at vendor billing setup level
331: open l_cplb_csr(ChrId => p_chr_id);
332: Loop
333: Fetch l_cplb_csr into l_bto_id,l_custacct_id;

Line 339: If l_return_status = OKL_API.G_RET_STS_ERROR then

335: --check if bto is active at vendor billing setup level
336: If l_bto_id is not null and l_custacct_id is not null then
337: l_return_status := is_bto_active(p_bto_id => l_bto_id,
338: p_custacct_id => l_custacct_id);
339: If l_return_status = OKL_API.G_RET_STS_ERROR then
340: --set error message
341: OKL_API.set_message(
342: p_app_name => G_APP_NAME,
343: p_msg_name => 'OKL_QA_INVALID_BILLTO'

Line 341: OKL_API.set_message(

337: l_return_status := is_bto_active(p_bto_id => l_bto_id,
338: p_custacct_id => l_custacct_id);
339: If l_return_status = OKL_API.G_RET_STS_ERROR then
340: --set error message
341: OKL_API.set_message(
342: p_app_name => G_APP_NAME,
343: p_msg_name => 'OKL_QA_INVALID_BILLTO'
344: );
345: Exit;

Line 346: Elsif l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then

342: p_app_name => G_APP_NAME,
343: p_msg_name => 'OKL_QA_INVALID_BILLTO'
344: );
345: Exit;
346: Elsif l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR then
347: Exit;
348: End If;
349: End If;
350: End Loop;

Line 368: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

364: If l_cplb_csr%ISOPEN then
365: close l_cplb_csr;
366: End If;
367:
368: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
369: ----
370: End Validate_Bill_To;
371: --Bug# 2953906 end
372:

Line 383: -- OUT Parameter x_return_status - will return OKL_API.G_RET_STS_SUCCESS or

379: --
380: -- IN Parameters -
381: -- p_rbk_chr_id - contract id of rebook copy contract
382: -- p_orig_chr_id - contract id of original contract
383: -- OUT Parameter x_return_status - will return OKL_API.G_RET_STS_SUCCESS or
384: -- OKL_API.G_RET_STS_ERROR
385: --End of Comments
386: --------------------------------------------------------------------------------
387: PROCEDURE Validate_Rebook_Date

Line 384: -- OKL_API.G_RET_STS_ERROR

380: -- IN Parameters -
381: -- p_rbk_chr_id - contract id of rebook copy contract
382: -- p_orig_chr_id - contract id of original contract
383: -- OUT Parameter x_return_status - will return OKL_API.G_RET_STS_SUCCESS or
384: -- OKL_API.G_RET_STS_ERROR
385: --End of Comments
386: --------------------------------------------------------------------------------
387: PROCEDURE Validate_Rebook_Date
388: (p_api_version IN NUMBER,

Line 397: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

393: p_rbk_chr_id IN NUMBER,
394: p_orig_chr_id IN NUMBER,
395: p_rebook_date IN DATE) IS
396:
397: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
398: l_api_name CONSTANT VARCHAR2(30) := 'Validate_Rebook_Date';
399: l_api_version CONSTANT NUMBER := 1.0;
400:
401: CURSOR chr_csr(p_chr_id NUMBER) IS

Line 440: OKL_API.SET_MESSAGE(p_app_name => g_app_name,

436: exit when cle_csr%NOTFOUND;
437:
438: if l_cle_rec.rbk_price_unit <> l_cle_rec.orig_price_unit then
439: close cle_csr;
440: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
441: p_msg_name => 'OKL_LLA_VALIDATE_UNIT_COST_CHG'
442: );
443: RAISE OKL_API.G_EXCEPTION_ERROR;
444: end if;

Line 443: RAISE OKL_API.G_EXCEPTION_ERROR;

439: close cle_csr;
440: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
441: p_msg_name => 'OKL_LLA_VALIDATE_UNIT_COST_CHG'
442: );
443: RAISE OKL_API.G_EXCEPTION_ERROR;
444: end if;
445: end loop;
446: close cle_csr;
447: end if;

Line 450: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

446: close cle_csr;
447: end if;
448:
449: EXCEPTION
450: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
451: x_return_status := OKL_API.G_RET_STS_ERROR;
452: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
453: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
454: WHEN OTHERS THEN

Line 451: x_return_status := OKL_API.G_RET_STS_ERROR;

447: end if;
448:
449: EXCEPTION
450: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
451: x_return_status := OKL_API.G_RET_STS_ERROR;
452: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
453: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
454: WHEN OTHERS THEN
455: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

Line 452: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

448:
449: EXCEPTION
450: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
451: x_return_status := OKL_API.G_RET_STS_ERROR;
452: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
453: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
454: WHEN OTHERS THEN
455: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
456: END Validate_Rebook_Date;

Line 453: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

449: EXCEPTION
450: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
451: x_return_status := OKL_API.G_RET_STS_ERROR;
452: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
453: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
454: WHEN OTHERS THEN
455: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
456: END Validate_Rebook_Date;
457: --Bug# 3783518: end

Line 455: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

451: x_return_status := OKL_API.G_RET_STS_ERROR;
452: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
453: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
454: WHEN OTHERS THEN
455: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
456: END Validate_Rebook_Date;
457: --Bug# 3783518: end
458:
459: --------------------------------------------------------------------------------

Line 480: l_return_status VARCHAR2(1) DEFAULT Okl_Api.G_RET_STS_SUCCESS;

476: x_msg_data OUT NOCOPY VARCHAR2,
477: p_chrv_id IN NUMBER,
478: p_call_mode IN VARCHAR2) IS
479:
480: l_return_status VARCHAR2(1) DEFAULT Okl_Api.G_RET_STS_SUCCESS;
481: l_api_name CONSTANT VARCHAR2(30) := 'ACTIVATE_CONTRACT';
482: l_api_version CONSTANT NUMBER := 1.0;
483:
484: l_cimv_tbl_fa Okl_Activate_Asset_Pub.cimv_tbl_type;

Line 489: l_commit VARCHAR2(1) := Okl_Api.G_FALSE;

485: l_cimv_tbl_ib Okl_Activate_Ib_Pub.cimv_tbl_type;
486: l_tcnv_rec Okl_Trx_Contracts_Pvt.tcnv_rec_type;
487: l_service_chr_id Number;
488:
489: l_commit VARCHAR2(1) := Okl_Api.G_FALSE;
490: l_transaction_type VARCHAR2(256) default 'Booking';
491: l_draft_yn VARCHAR2(1) := Okl_Api.G_FALSE;
492:
493: --Bug#2835070

Line 491: l_draft_yn VARCHAR2(1) := Okl_Api.G_FALSE;

487: l_service_chr_id Number;
488:
489: l_commit VARCHAR2(1) := Okl_Api.G_FALSE;
490: l_transaction_type VARCHAR2(256) default 'Booking';
491: l_draft_yn VARCHAR2(1) := Okl_Api.G_FALSE;
492:
493: --Bug#2835070
494: --cursor to check if the contract is rebooked contract
495: cursor l_chk_rbk_csr(p_chr_id IN NUMBER) is

Line 715: l_subsidy_exists varchar2(1) default OKL_API.G_FALSE;

711: --Bug#2522439 End
712:
713: --Bug#3143522 : Subsidies enhancement
714:
715: l_subsidy_exists varchar2(1) default OKL_API.G_FALSE;
716:
717: -- cursor to find subsidies which have expired (if any)
718: -- sjalasut. modified cursor to remove " and nvl(subb.effective_to_date,sysdate)+nvl(subb.expire_after_days,0) < sysdate "
719: -- from the cursor to make the cursor re-usable for subsidy pools enhancement, also added subsidy_id column

Line 761: l_subsidy_valid_status varchar2(1) default OKL_API.G_RET_STS_SUCCESS;

757: and lseb_asst.lty_code = 'FREE_FORM1'
758: and cleb_asst.sts_code <> 'ABANDONED';
759:
760: l_subsidy_rec l_subsidy_csr%ROWTYPE;
761: l_subsidy_valid_status varchar2(1) default OKL_API.G_RET_STS_SUCCESS;
762:
763: -- Start : Bug 6050165 : prasjain
764: --cursor to check subsidy applicability at line dates
765: cursor l_cle_csr (p_subsidy_id in number,

Line 877: x_return_status := Okl_Api.G_RET_STS_SUCCESS;

873: --Bug# 16511024 , End
874: --ndani - 14-Mar-2013, End - Rebook accounting fix
875:
876: BEGIN
877: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
878: -- Call start_activity to create savepoint, check compatibility
879: -- and initialize message list
880: l_return_status := Okl_Api.START_ACTIVITY(
881: p_api_name => l_api_name,

Line 880: l_return_status := Okl_Api.START_ACTIVITY(

876: BEGIN
877: x_return_status := Okl_Api.G_RET_STS_SUCCESS;
878: -- Call start_activity to create savepoint, check compatibility
879: -- and initialize message list
880: l_return_status := Okl_Api.START_ACTIVITY(
881: p_api_name => l_api_name,
882: p_pkg_name => g_pkg_name,
883: p_init_msg_list => p_init_msg_list,
884: l_api_version => l_api_version,

Line 891: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

887: x_return_status => x_return_status);
888: -- Check if activity started successfully
889: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
890: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
891: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
892: RAISE Okc_Api.G_EXCEPTION_ERROR;
893: END IF;
894:
895: okl_debug_pub.logmessage('In Activate_contract: p_chrv_id =' || p_chrv_id);

Line 966: IF nvl(l_mass_rbk_date,OKL_API.G_MISS_DATE) = OKL_API.G_MISS_DATE then

962:
963: IF l_mass_rbk_khr = '!' THEN
964: --do mass rebook processing
965: --bug# 3156924 :
966: IF nvl(l_mass_rbk_date,OKL_API.G_MISS_DATE) = OKL_API.G_MISS_DATE then
967: l_mass_rbk_date := sysdate;
968: End IF;
969: --Bug# 3156924
970:

Line 972: l_subsidy_exists := OKL_API.G_FALSE;

968: End IF;
969: --Bug# 3156924
970:
971: -- Start : Bug 6050165 : prasjain
972: l_subsidy_exists := OKL_API.G_FALSE;
973: okl_subsidy_process_pvt.is_contract_subsidized
974: (p_api_version => p_api_version,
975: p_init_msg_list => p_init_msg_list,
976: x_return_status => x_return_status,

Line 981: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

977: x_msg_count => x_msg_count,
978: x_msg_data => x_msg_data,
979: p_chr_id => p_chrv_id,
980: x_subsidized => l_subsidy_exists);
981: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
982: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
983: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
984: RAISE Okl_Api.G_EXCEPTION_ERROR;
985: END IF;

Line 982: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

978: x_msg_data => x_msg_data,
979: p_chr_id => p_chrv_id,
980: x_subsidized => l_subsidy_exists);
981: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
982: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
983: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
984: RAISE Okl_Api.G_EXCEPTION_ERROR;
985: END IF;
986:

Line 983: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

979: p_chr_id => p_chrv_id,
980: x_subsidized => l_subsidy_exists);
981: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
982: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
983: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
984: RAISE Okl_Api.G_EXCEPTION_ERROR;
985: END IF;
986:
987: IF l_subsidy_exists = OKL_API.G_TRUE THEN

Line 984: RAISE Okl_Api.G_EXCEPTION_ERROR;

980: x_subsidized => l_subsidy_exists);
981: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
982: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
983: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
984: RAISE Okl_Api.G_EXCEPTION_ERROR;
985: END IF;
986:
987: IF l_subsidy_exists = OKL_API.G_TRUE THEN
988: l_subsidy_valid_status := OKL_API.G_RET_STS_SUCCESS;

Line 987: IF l_subsidy_exists = OKL_API.G_TRUE THEN

983: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
984: RAISE Okl_Api.G_EXCEPTION_ERROR;
985: END IF;
986:
987: IF l_subsidy_exists = OKL_API.G_TRUE THEN
988: l_subsidy_valid_status := OKL_API.G_RET_STS_SUCCESS;
989: OPEN l_subsidy_csr (p_chr_id => p_chrv_id);
990: LOOP
991: FETCH l_subsidy_csr INTO l_subsidy_rec;

Line 988: l_subsidy_valid_status := OKL_API.G_RET_STS_SUCCESS;

984: RAISE Okl_Api.G_EXCEPTION_ERROR;
985: END IF;
986:
987: IF l_subsidy_exists = OKL_API.G_TRUE THEN
988: l_subsidy_valid_status := OKL_API.G_RET_STS_SUCCESS;
989: OPEN l_subsidy_csr (p_chr_id => p_chrv_id);
990: LOOP
991: FETCH l_subsidy_csr INTO l_subsidy_rec;
992: EXIT WHEN l_subsidy_csr%NOTFOUND;

Line 1003: Okl_Api.set_message(

999: End If;
1000: close l_cle_csr;
1001:
1002: If (l_applicable = 'N') then
1003: Okl_Api.set_message(
1004: p_app_name => G_APP_NAME,
1005: p_msg_name => 'OKL_SUBSIDY_CRITERIA_MATCH',
1006: p_token1 => 'SUBSIDY_NAME',
1007: p_token1_value => l_subsidy_rec.subsidy_name,

Line 1010: l_subsidy_valid_status := OKL_API.G_RET_STS_ERROR;

1006: p_token1 => 'SUBSIDY_NAME',
1007: p_token1_value => l_subsidy_rec.subsidy_name,
1008: p_token2 => 'ASSET_NUMBER',
1009: p_token2_value => l_subsidy_rec.asset_number);
1010: l_subsidy_valid_status := OKL_API.G_RET_STS_ERROR;
1011: end if;
1012: end loop;
1013: IF (l_subsidy_valid_status = Okl_Api.G_RET_STS_ERROR) THEN
1014: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1013: IF (l_subsidy_valid_status = Okl_Api.G_RET_STS_ERROR) THEN

1009: p_token2_value => l_subsidy_rec.asset_number);
1010: l_subsidy_valid_status := OKL_API.G_RET_STS_ERROR;
1011: end if;
1012: end loop;
1013: IF (l_subsidy_valid_status = Okl_Api.G_RET_STS_ERROR) THEN
1014: RAISE Okl_Api.G_EXCEPTION_ERROR;
1015: end if;
1016: end if;
1017: -- End : Bug 6050165 : prasjain

Line 1014: RAISE Okl_Api.G_EXCEPTION_ERROR;

1010: l_subsidy_valid_status := OKL_API.G_RET_STS_ERROR;
1011: end if;
1012: end loop;
1013: IF (l_subsidy_valid_status = Okl_Api.G_RET_STS_ERROR) THEN
1014: RAISE Okl_Api.G_EXCEPTION_ERROR;
1015: end if;
1016: end if;
1017: -- End : Bug 6050165 : prasjain
1018:

Line 1033: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1029: x_msg_count => x_msg_count,
1030: x_msg_data => x_msg_data,
1031: p_rbk_chr_id => p_chrv_id);
1032: --dbms_output.put_line('Gone in for rebook. '||x_return_status);
1033: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1034: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1035: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1036: RAISE Okl_Api.G_EXCEPTION_ERROR;
1037: END IF;

Line 1034: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1030: x_msg_data => x_msg_data,
1031: p_rbk_chr_id => p_chrv_id);
1032: --dbms_output.put_line('Gone in for rebook. '||x_return_status);
1033: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1034: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1035: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1036: RAISE Okl_Api.G_EXCEPTION_ERROR;
1037: END IF;
1038:

Line 1035: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1031: p_rbk_chr_id => p_chrv_id);
1032: --dbms_output.put_line('Gone in for rebook. '||x_return_status);
1033: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1034: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1035: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1036: RAISE Okl_Api.G_EXCEPTION_ERROR;
1037: END IF;
1038:
1039: -- dedey, Bug#4264314

Line 1036: RAISE Okl_Api.G_EXCEPTION_ERROR;

1032: --dbms_output.put_line('Gone in for rebook. '||x_return_status);
1033: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1034: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1035: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1036: RAISE Okl_Api.G_EXCEPTION_ERROR;
1037: END IF;
1038:
1039: -- dedey, Bug#4264314
1040: OKL_CONTRACT_REBOOK_PVT.create_billing_adjustment(

Line 1051: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1047: p_orig_khr_id => p_chrv_id,
1048: p_trx_id => l_mass_rbk_trx_id,
1049: p_trx_date => sysdate); -- 4583578 passing sysdate instead of rebook date
1050:
1051: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1052: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1053: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1054: RAISE Okl_Api.G_EXCEPTION_ERROR;
1055: END IF;

Line 1052: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1048: p_trx_id => l_mass_rbk_trx_id,
1049: p_trx_date => sysdate); -- 4583578 passing sysdate instead of rebook date
1050:
1051: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1052: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1053: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1054: RAISE Okl_Api.G_EXCEPTION_ERROR;
1055: END IF;
1056: -- dedey, Bug#4264314

Line 1053: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1049: p_trx_date => sysdate); -- 4583578 passing sysdate instead of rebook date
1050:
1051: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1052: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1053: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1054: RAISE Okl_Api.G_EXCEPTION_ERROR;
1055: END IF;
1056: -- dedey, Bug#4264314
1057:

Line 1054: RAISE Okl_Api.G_EXCEPTION_ERROR;

1050:
1051: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1052: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1053: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1054: RAISE Okl_Api.G_EXCEPTION_ERROR;
1055: END IF;
1056: -- dedey, Bug#4264314
1057:
1058: -- 4542290

Line 1105: p_memo_yn => okl_api.g_true,

1101: --Bug# 3156924
1102: --p_transaction_date => sysdate,
1103: p_transaction_date => l_mass_rbk_date,
1104: p_draft_yn => l_draft_yn,
1105: p_memo_yn => okl_api.g_true,
1106: x_return_status => x_return_status,
1107: x_msg_count => x_msg_count,
1108: x_msg_data => x_msg_data);
1109:

Line 1110: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1106: x_return_status => x_return_status,
1107: x_msg_count => x_msg_count,
1108: x_msg_data => x_msg_data);
1109:
1110: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1111: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1112: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1113: RAISE Okl_Api.G_EXCEPTION_ERROR;
1114: END IF;

Line 1111: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1107: x_msg_count => x_msg_count,
1108: x_msg_data => x_msg_data);
1109:
1110: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1111: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1112: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1113: RAISE Okl_Api.G_EXCEPTION_ERROR;
1114: END IF;
1115:

Line 1112: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1108: x_msg_data => x_msg_data);
1109:
1110: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1111: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1112: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1113: RAISE Okl_Api.G_EXCEPTION_ERROR;
1114: END IF;
1115:
1116: --ndani - 20-Mar-2013, Start - Mass Rebook accounting fix

Line 1113: RAISE Okl_Api.G_EXCEPTION_ERROR;

1109:
1110: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1111: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1112: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1113: RAISE Okl_Api.G_EXCEPTION_ERROR;
1114: END IF;
1115:
1116: --ndani - 20-Mar-2013, Start - Mass Rebook accounting fix
1117: --Bug# 16526329 : Accounting Booking : Booking to make two accounting calls for reversal of

Line 1134: p_memo_yn => okl_api.g_true,

1130: --Bug# 3156924
1131: --p_transaction_date => sysdate,
1132: p_transaction_date => l_mass_rbk_date,
1133: p_draft_yn => l_draft_yn,
1134: p_memo_yn => okl_api.g_true,
1135: x_return_status => x_return_status,
1136: x_msg_count => x_msg_count,
1137: x_msg_data => x_msg_data);
1138:

Line 1139: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1135: x_return_status => x_return_status,
1136: x_msg_count => x_msg_count,
1137: x_msg_data => x_msg_data);
1138:
1139: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1140: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1141: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1142: RAISE Okl_Api.G_EXCEPTION_ERROR;
1143: END IF;

Line 1140: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1136: x_msg_count => x_msg_count,
1137: x_msg_data => x_msg_data);
1138:
1139: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1140: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1141: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1142: RAISE Okl_Api.G_EXCEPTION_ERROR;
1143: END IF;
1144:

Line 1141: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1137: x_msg_data => x_msg_data);
1138:
1139: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1140: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1141: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1142: RAISE Okl_Api.G_EXCEPTION_ERROR;
1143: END IF;
1144:
1145: END IF;

Line 1142: RAISE Okl_Api.G_EXCEPTION_ERROR;

1138:
1139: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1140: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1141: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1142: RAISE Okl_Api.G_EXCEPTION_ERROR;
1143: END IF;
1144:
1145: END IF;
1146: --Bug# 16526329 , End

Line 1169: p_init_msg_list => Okl_Api.G_FALSE,

1165: --remove upfront tax call for rebook
1166: /*
1167: okl_la_sales_tax_pvt.process_sales_tax(
1168: p_api_version => p_api_version,
1169: p_init_msg_list => Okl_Api.G_FALSE,
1170: p_commit => Okl_Api.G_FALSE,
1171: p_contract_id => l_orig_khr_id,
1172: p_transaction_type => 'Mass-Rebook',
1173: p_transaction_id => l_mass_rbk_trx_id,

Line 1170: p_commit => Okl_Api.G_FALSE,

1166: /*
1167: okl_la_sales_tax_pvt.process_sales_tax(
1168: p_api_version => p_api_version,
1169: p_init_msg_list => Okl_Api.G_FALSE,
1170: p_commit => Okl_Api.G_FALSE,
1171: p_contract_id => l_orig_khr_id,
1172: p_transaction_type => 'Mass-Rebook',
1173: p_transaction_id => l_mass_rbk_trx_id,
1174: p_transaction_date => l_mass_rbk_date,

Line 1180: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1176: x_return_status => x_return_status,
1177: x_msg_count => x_msg_count,
1178: x_msg_data => x_msg_data);
1179:
1180: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1181: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1182: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1183: RAISE Okl_Api.G_EXCEPTION_ERROR;
1184: END IF;

Line 1181: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1177: x_msg_count => x_msg_count,
1178: x_msg_data => x_msg_data);
1179:
1180: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1181: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1182: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1183: RAISE Okl_Api.G_EXCEPTION_ERROR;
1184: END IF;
1185: -- Sales Tax Project changes Bug: 4622963 - END

Line 1182: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1178: x_msg_data => x_msg_data);
1179:
1180: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1181: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1182: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1183: RAISE Okl_Api.G_EXCEPTION_ERROR;
1184: END IF;
1185: -- Sales Tax Project changes Bug: 4622963 - END
1186: */

Line 1183: RAISE Okl_Api.G_EXCEPTION_ERROR;

1179:
1180: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1181: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1182: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1183: RAISE Okl_Api.G_EXCEPTION_ERROR;
1184: END IF;
1185: -- Sales Tax Project changes Bug: 4622963 - END
1186: */
1187: --akrangan end

Line 1204: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1200: p_orig_khr_id => p_chrv_id,
1201: p_trx_id => l_mass_rbk_trx_id,
1202: p_trx_date => sysdate); -- 4583578 passing sysdate instead of rebook date
1203:
1204: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1205: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1206: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1207: RAISE Okl_Api.G_EXCEPTION_ERROR;
1208: END IF;

Line 1205: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1201: p_trx_id => l_mass_rbk_trx_id,
1202: p_trx_date => sysdate); -- 4583578 passing sysdate instead of rebook date
1203:
1204: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1205: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1206: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1207: RAISE Okl_Api.G_EXCEPTION_ERROR;
1208: END IF;
1209: */

Line 1206: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1202: p_trx_date => sysdate); -- 4583578 passing sysdate instead of rebook date
1203:
1204: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1205: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1206: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1207: RAISE Okl_Api.G_EXCEPTION_ERROR;
1208: END IF;
1209: */
1210: -- dedey,Bug#4264314

Line 1207: RAISE Okl_Api.G_EXCEPTION_ERROR;

1203:
1204: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1205: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1206: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1207: RAISE Okl_Api.G_EXCEPTION_ERROR;
1208: END IF;
1209: */
1210: -- dedey,Bug#4264314
1211:

Line 1229: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1225: p_orig_khr_id => p_chrv_id,
1226: p_trx_id => l_mass_rbk_trx_id,
1227: p_trx_date => l_mass_rbk_date);
1228:
1229: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1230: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1231: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1232: RAISE Okl_Api.G_EXCEPTION_ERROR;
1233: END IF;

Line 1230: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1226: p_trx_id => l_mass_rbk_trx_id,
1227: p_trx_date => l_mass_rbk_date);
1228:
1229: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1230: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1231: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1232: RAISE Okl_Api.G_EXCEPTION_ERROR;
1233: END IF;
1234: */

Line 1231: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1227: p_trx_date => l_mass_rbk_date);
1228:
1229: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1230: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1231: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1232: RAISE Okl_Api.G_EXCEPTION_ERROR;
1233: END IF;
1234: */
1235:

Line 1232: RAISE Okl_Api.G_EXCEPTION_ERROR;

1228:
1229: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1230: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1231: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1232: RAISE Okl_Api.G_EXCEPTION_ERROR;
1233: END IF;
1234: */
1235:
1236: --Bug# 4212626

Line 1250: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1246: x_return_status => x_return_status,
1247: x_msg_count => x_msg_count,
1248: x_msg_data => x_msg_data);
1249:
1250: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1251: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1252: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1253: RAISE Okl_Api.G_EXCEPTION_ERROR;
1254: END IF;

Line 1251: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1247: x_msg_count => x_msg_count,
1248: x_msg_data => x_msg_data);
1249:
1250: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1251: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1252: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1253: RAISE Okl_Api.G_EXCEPTION_ERROR;
1254: END IF;
1255: */

Line 1252: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1248: x_msg_data => x_msg_data);
1249:
1250: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1251: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1252: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1253: RAISE Okl_Api.G_EXCEPTION_ERROR;
1254: END IF;
1255: */
1256:

Line 1253: RAISE Okl_Api.G_EXCEPTION_ERROR;

1249:
1250: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1251: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1252: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1253: RAISE Okl_Api.G_EXCEPTION_ERROR;
1254: END IF;
1255: */
1256:
1257: ELSIF l_rbk_khr = '!' THEN

Line 1265: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1261: Is_Rebook_Supported(p_rbk_chr_id => p_chrv_id,
1262: p_orig_chr_id => l_orig_khr_id,
1263: x_return_status => x_return_status);
1264:
1265: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1266: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1267: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1268: RAISE Okl_Api.G_EXCEPTION_ERROR;
1269: END IF;

Line 1266: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1262: p_orig_chr_id => l_orig_khr_id,
1263: x_return_status => x_return_status);
1264:
1265: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1266: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1267: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1268: RAISE Okl_Api.G_EXCEPTION_ERROR;
1269: END IF;
1270: --Bug#: End.

Line 1267: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1263: x_return_status => x_return_status);
1264:
1265: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1266: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1267: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1268: RAISE Okl_Api.G_EXCEPTION_ERROR;
1269: END IF;
1270: --Bug#: End.
1271:

Line 1268: RAISE Okl_Api.G_EXCEPTION_ERROR;

1264:
1265: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1266: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1267: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1268: RAISE Okl_Api.G_EXCEPTION_ERROR;
1269: END IF;
1270: --Bug#: End.
1271:
1272: -- 02-Mar-09 sechawla bug 8370324 : removed the following validation

Line 1285: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1281: x_msg_data => x_msg_data,
1282: p_rbk_chr_id => p_chrv_id,
1283: p_orig_chr_id => l_orig_khr_id,
1284: p_rebook_date => l_rebook_date);
1285: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1286: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1287: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1288: RAISE Okl_Api.G_EXCEPTION_ERROR;
1289: END IF;

Line 1286: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1282: p_rbk_chr_id => p_chrv_id,
1283: p_orig_chr_id => l_orig_khr_id,
1284: p_rebook_date => l_rebook_date);
1285: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1286: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1287: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1288: RAISE Okl_Api.G_EXCEPTION_ERROR;
1289: END IF;
1290: --Bug# 3783518: End

Line 1287: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1283: p_orig_chr_id => l_orig_khr_id,
1284: p_rebook_date => l_rebook_date);
1285: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1286: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1287: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1288: RAISE Okl_Api.G_EXCEPTION_ERROR;
1289: END IF;
1290: --Bug# 3783518: End
1291: */

Line 1288: RAISE Okl_Api.G_EXCEPTION_ERROR;

1284: p_rebook_date => l_rebook_date);
1285: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1286: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1287: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1288: RAISE Okl_Api.G_EXCEPTION_ERROR;
1289: END IF;
1290: --Bug# 3783518: End
1291: */
1292:

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

1300: x_msg_data => x_msg_data,
1301: p_chr_id => l_orig_khr_id,
1302: p_rbk_chr_id => p_chrv_id);
1303:
1304: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1305: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1306: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1307: RAISE OKL_API.G_EXCEPTION_ERROR;
1308: END IF;

Line 1305: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1301: p_chr_id => l_orig_khr_id,
1302: p_rbk_chr_id => p_chrv_id);
1303:
1304: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1305: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1306: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1307: RAISE OKL_API.G_EXCEPTION_ERROR;
1308: END IF;
1309:

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

1302: p_rbk_chr_id => p_chrv_id);
1303:
1304: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1305: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1306: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1307: RAISE OKL_API.G_EXCEPTION_ERROR;
1308: END IF;
1309:
1310: --Start : Bug 6050165 : prasjain

Line 1307: RAISE OKL_API.G_EXCEPTION_ERROR;

1303:
1304: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1305: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1306: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1307: RAISE OKL_API.G_EXCEPTION_ERROR;
1308: END IF;
1309:
1310: --Start : Bug 6050165 : prasjain
1311: l_subsidy_exists := OKL_API.G_FALSE;

Line 1311: l_subsidy_exists := OKL_API.G_FALSE;

1307: RAISE OKL_API.G_EXCEPTION_ERROR;
1308: END IF;
1309:
1310: --Start : Bug 6050165 : prasjain
1311: l_subsidy_exists := OKL_API.G_FALSE;
1312: okl_subsidy_process_pvt.is_contract_subsidized
1313: (p_api_version => p_api_version,
1314: p_init_msg_list => p_init_msg_list,
1315: x_return_status => x_return_status,

Line 1320: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1316: x_msg_count => x_msg_count,
1317: x_msg_data => x_msg_data,
1318: p_chr_id => p_chrv_id,
1319: x_subsidized => l_subsidy_exists);
1320: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1321: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1322: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1323: RAISE Okl_Api.G_EXCEPTION_ERROR;
1324: END IF;

Line 1321: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1317: x_msg_data => x_msg_data,
1318: p_chr_id => p_chrv_id,
1319: x_subsidized => l_subsidy_exists);
1320: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1321: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1322: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1323: RAISE Okl_Api.G_EXCEPTION_ERROR;
1324: END IF;
1325:

Line 1322: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1318: p_chr_id => p_chrv_id,
1319: x_subsidized => l_subsidy_exists);
1320: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1321: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1322: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1323: RAISE Okl_Api.G_EXCEPTION_ERROR;
1324: END IF;
1325:
1326: IF l_subsidy_exists = OKL_API.G_TRUE THEN

Line 1323: RAISE Okl_Api.G_EXCEPTION_ERROR;

1319: x_subsidized => l_subsidy_exists);
1320: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1321: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1322: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1323: RAISE Okl_Api.G_EXCEPTION_ERROR;
1324: END IF;
1325:
1326: IF l_subsidy_exists = OKL_API.G_TRUE THEN
1327: l_subsidy_valid_status := OKL_API.G_RET_STS_SUCCESS;

Line 1326: IF l_subsidy_exists = OKL_API.G_TRUE THEN

1322: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1323: RAISE Okl_Api.G_EXCEPTION_ERROR;
1324: END IF;
1325:
1326: IF l_subsidy_exists = OKL_API.G_TRUE THEN
1327: l_subsidy_valid_status := OKL_API.G_RET_STS_SUCCESS;
1328: OPEN l_subsidy_csr (p_chr_id => p_chrv_id);
1329: LOOP
1330: FETCH l_subsidy_csr INTO l_subsidy_rec;

Line 1327: l_subsidy_valid_status := OKL_API.G_RET_STS_SUCCESS;

1323: RAISE Okl_Api.G_EXCEPTION_ERROR;
1324: END IF;
1325:
1326: IF l_subsidy_exists = OKL_API.G_TRUE THEN
1327: l_subsidy_valid_status := OKL_API.G_RET_STS_SUCCESS;
1328: OPEN l_subsidy_csr (p_chr_id => p_chrv_id);
1329: LOOP
1330: FETCH l_subsidy_csr INTO l_subsidy_rec;
1331: EXIT WHEN l_subsidy_csr%NOTFOUND;

Line 1342: Okl_Api.set_message(

1338: End If;
1339: close l_cle_csr;
1340:
1341: If (l_applicable = 'N') then
1342: Okl_Api.set_message(
1343: p_app_name => G_APP_NAME,
1344: p_msg_name => 'OKL_SUBSIDY_CRITERIA_MATCH',
1345: p_token1 => 'SUBSIDY_NAME',
1346: p_token1_value => l_subsidy_rec.subsidy_name,

Line 1349: l_subsidy_valid_status := OKL_API.G_RET_STS_ERROR;

1345: p_token1 => 'SUBSIDY_NAME',
1346: p_token1_value => l_subsidy_rec.subsidy_name,
1347: p_token2 => 'ASSET_NUMBER',
1348: p_token2_value => l_subsidy_rec.asset_number);
1349: l_subsidy_valid_status := OKL_API.G_RET_STS_ERROR;
1350: end if;
1351: end loop;
1352: IF (l_subsidy_valid_status = Okl_Api.G_RET_STS_ERROR) THEN
1353: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1352: IF (l_subsidy_valid_status = Okl_Api.G_RET_STS_ERROR) THEN

1348: p_token2_value => l_subsidy_rec.asset_number);
1349: l_subsidy_valid_status := OKL_API.G_RET_STS_ERROR;
1350: end if;
1351: end loop;
1352: IF (l_subsidy_valid_status = Okl_Api.G_RET_STS_ERROR) THEN
1353: RAISE Okl_Api.G_EXCEPTION_ERROR;
1354: end if;
1355: end if;
1356: --End : Bug 6050165 : prasjain

Line 1353: RAISE Okl_Api.G_EXCEPTION_ERROR;

1349: l_subsidy_valid_status := OKL_API.G_RET_STS_ERROR;
1350: end if;
1351: end loop;
1352: IF (l_subsidy_valid_status = Okl_Api.G_RET_STS_ERROR) THEN
1353: RAISE Okl_Api.G_EXCEPTION_ERROR;
1354: end if;
1355: end if;
1356: --End : Bug 6050165 : prasjain
1357:

Line 1382: okl_api.set_message(p_app_name => g_app_name,

1378: x_return_status => x_return_status,
1379: x_sty_id => l_sty_id
1380: );
1381: IF x_return_status <> 'S' THEN
1382: okl_api.set_message(p_app_name => g_app_name,
1383: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR',
1384: p_token1 => 'STREAM_NAME',
1385: p_token1_value => 'RENT');
1386: RAISE okl_api.g_exception_error;

Line 1386: RAISE okl_api.g_exception_error;

1382: okl_api.set_message(p_app_name => g_app_name,
1383: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR',
1384: p_token1 => 'STREAM_NAME',
1385: p_token1_value => 'RENT');
1386: RAISE okl_api.g_exception_error;
1387: END IF;
1388:
1389: l_max_bill_date := NULL;
1390: OPEN max_bill_date_csr(p_stm_id => l_sty_id );

Line 1412: okl_api.set_message(p_app_name => g_app_name,

1408: x_return_status => x_return_status,
1409: x_sty_id => l_sty_id
1410: );
1411: IF x_return_status <> 'S' THEN
1412: okl_api.set_message(p_app_name => g_app_name,
1413: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR',
1414: p_token1 => 'STREAM_NAME',
1415: p_token1_value => l_stream_name);
1416: RAISE okl_api.g_exception_error;

Line 1416: RAISE okl_api.g_exception_error;

1412: okl_api.set_message(p_app_name => g_app_name,
1413: p_msg_name => 'OKL_AGN_STRM_TYPE_ERROR',
1414: p_token1 => 'STREAM_NAME',
1415: p_token1_value => l_stream_name);
1416: RAISE okl_api.g_exception_error;
1417: END IF;
1418:
1419: l_max_bill_date := NULL;
1420: OPEN max_bill_date_csr(p_stm_id => l_sty_id );

Line 1443: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1439: p_trx_id => l_transaction_id,
1440: p_trx_date => sysdate); -- 4583578 passing sysdate instead of rebook date
1441: --4542290 p_trx_date => l_rebook_date);
1442:
1443: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1444: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1445: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1446: RAISE Okl_Api.G_EXCEPTION_ERROR;
1447: END IF;

Line 1444: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1440: p_trx_date => sysdate); -- 4583578 passing sysdate instead of rebook date
1441: --4542290 p_trx_date => l_rebook_date);
1442:
1443: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1444: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1445: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1446: RAISE Okl_Api.G_EXCEPTION_ERROR;
1447: END IF;
1448:

Line 1445: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1441: --4542290 p_trx_date => l_rebook_date);
1442:
1443: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1444: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1445: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1446: RAISE Okl_Api.G_EXCEPTION_ERROR;
1447: END IF;
1448:
1449: -- dedey,Bug#4264314

Line 1446: RAISE Okl_Api.G_EXCEPTION_ERROR;

1442:
1443: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1444: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1445: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1446: RAISE Okl_Api.G_EXCEPTION_ERROR;
1447: END IF;
1448:
1449: -- dedey,Bug#4264314
1450: /*

Line 1479: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1475: p_trx_date => sysdate, -- 4583578 passing sysdate instead of rebook_date
1476: x_accrual_rec => l_accrual_rec,
1477: x_stream_tbl => l_stream_tbl);
1478:
1479: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1480: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1481: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1482: RAISE Okl_Api.G_EXCEPTION_ERROR;
1483: END IF;

Line 1480: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1476: x_accrual_rec => l_accrual_rec,
1477: x_stream_tbl => l_stream_tbl);
1478:
1479: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1480: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1481: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1482: RAISE Okl_Api.G_EXCEPTION_ERROR;
1483: END IF;
1484:

Line 1481: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1477: x_stream_tbl => l_stream_tbl);
1478:
1479: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1480: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1481: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1482: RAISE Okl_Api.G_EXCEPTION_ERROR;
1483: END IF;
1484:
1485: IF (l_stream_tbl.COUNT > 0) THEN -- Call adjustment when required, dedey

Line 1482: RAISE Okl_Api.G_EXCEPTION_ERROR;

1478:
1479: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1480: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1481: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1482: RAISE Okl_Api.G_EXCEPTION_ERROR;
1483: END IF;
1484:
1485: IF (l_stream_tbl.COUNT > 0) THEN -- Call adjustment when required, dedey
1486: OKL_GENERATE_ACCRUALS_PVT.ADJUST_ACCRUALS (

Line 1498: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1494: x_trx_tbl => lx_trxnum_tbl,
1495: p_accrual_rec => l_accrual_rec,
1496: p_stream_tbl => l_stream_tbl);
1497:
1498: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1499: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1500: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1501: RAISE Okl_Api.G_EXCEPTION_ERROR;
1502: END IF;

Line 1499: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1495: p_accrual_rec => l_accrual_rec,
1496: p_stream_tbl => l_stream_tbl);
1497:
1498: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1499: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1500: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1501: RAISE Okl_Api.G_EXCEPTION_ERROR;
1502: END IF;
1503:

Line 1500: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1496: p_stream_tbl => l_stream_tbl);
1497:
1498: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1499: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1500: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1501: RAISE Okl_Api.G_EXCEPTION_ERROR;
1502: END IF;
1503:
1504: END IF; -- l_stream_tbl.COUNT > 0

Line 1501: RAISE Okl_Api.G_EXCEPTION_ERROR;

1497:
1498: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1499: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1500: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1501: RAISE Okl_Api.G_EXCEPTION_ERROR;
1502: END IF;
1503:
1504: END IF; -- l_stream_tbl.COUNT > 0
1505:

Line 1523: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1519: x_accrual_rec => l_accrual_rec,
1520: x_stream_tbl => l_stream_tbl);
1521:
1522: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
1523: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1524: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
1525: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1526: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1527: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;

Line 1525: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1521:
1522: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
1523: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1524: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
1525: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1526: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1527: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
1528: RAISE Okl_Api.G_EXCEPTION_ERROR;
1529: END IF;

Line 1526: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1522: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
1523: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1524: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
1525: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1526: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1527: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
1528: RAISE Okl_Api.G_EXCEPTION_ERROR;
1529: END IF;
1530:

Line 1528: RAISE Okl_Api.G_EXCEPTION_ERROR;

1524: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
1525: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1526: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1527: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
1528: RAISE Okl_Api.G_EXCEPTION_ERROR;
1529: END IF;
1530:
1531: IF (l_stream_tbl.COUNT > 0) THEN -- Call adjustment when required, dedey
1532: --l_accrual_rec.trx_number := lx_trx_number;

Line 1548: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1544: p_representation_type => 'SECONDARY');
1545:
1546: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
1547:
1548: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1549: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1550: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1551: RAISE Okl_Api.G_EXCEPTION_ERROR;
1552: END IF;

Line 1549: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1545:
1546: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
1547:
1548: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1549: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1550: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1551: RAISE Okl_Api.G_EXCEPTION_ERROR;
1552: END IF;
1553:

Line 1550: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1546: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;
1547:
1548: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1549: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1550: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1551: RAISE Okl_Api.G_EXCEPTION_ERROR;
1552: END IF;
1553:
1554: END IF; -- l_stream_tbl.COUNT > 0

Line 1551: RAISE Okl_Api.G_EXCEPTION_ERROR;

1547:
1548: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1549: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1550: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1551: RAISE Okl_Api.G_EXCEPTION_ERROR;
1552: END IF;
1553:
1554: END IF; -- l_stream_tbl.COUNT > 0
1555: OKL_STREAMS_SEC_PVT.RESET_REPO_STREAMS;

Line 1571: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1567: x_msg_data => x_msg_data,
1568: p_rebook_chr_id => p_chrv_id
1569: );
1570: --dbms_output.put_line('Hey 1 first call: '||x_return_status);
1571: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1572: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1573: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1574: RAISE Okl_Api.G_EXCEPTION_ERROR;
1575: END IF;

Line 1572: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1568: p_rebook_chr_id => p_chrv_id
1569: );
1570: --dbms_output.put_line('Hey 1 first call: '||x_return_status);
1571: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1572: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1573: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1574: RAISE Okl_Api.G_EXCEPTION_ERROR;
1575: END IF;
1576:

Line 1573: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1569: );
1570: --dbms_output.put_line('Hey 1 first call: '||x_return_status);
1571: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1572: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1573: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1574: RAISE Okl_Api.G_EXCEPTION_ERROR;
1575: END IF;
1576:
1577:

Line 1574: RAISE Okl_Api.G_EXCEPTION_ERROR;

1570: --dbms_output.put_line('Hey 1 first call: '||x_return_status);
1571: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1572: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1573: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1574: RAISE Okl_Api.G_EXCEPTION_ERROR;
1575: END IF;
1576:
1577:
1578: --dbms_output.put_line('Status1 BEFORE call: '||x_return_status);

Line 1594: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1590: --dbms_output.put_line('Status1: '||x_return_status);
1591:
1592: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1593: --dbms_output.put_line('Status2: '||x_return_status);
1594: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1595: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1596: --dbms_output.put_line('Status3: '||x_return_status);
1597: RAISE Okl_Api.G_EXCEPTION_ERROR;
1598: END IF;

Line 1597: RAISE Okl_Api.G_EXCEPTION_ERROR;

1593: --dbms_output.put_line('Status2: '||x_return_status);
1594: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1595: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1596: --dbms_output.put_line('Status3: '||x_return_status);
1597: RAISE Okl_Api.G_EXCEPTION_ERROR;
1598: END IF;
1599: --dbms_output.put_line('Status4: '||x_return_status);
1600:
1601: --call rebook api

Line 1609: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1605: x_return_status => x_return_status,
1606: x_msg_count => x_msg_count,
1607: x_msg_data => x_msg_data,
1608: p_rbk_chr_id => p_chrv_id);
1609: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1610: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1611: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1612: RAISE Okl_Api.G_EXCEPTION_ERROR;
1613: END IF;

Line 1610: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1606: x_msg_count => x_msg_count,
1607: x_msg_data => x_msg_data,
1608: p_rbk_chr_id => p_chrv_id);
1609: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1610: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1611: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1612: RAISE Okl_Api.G_EXCEPTION_ERROR;
1613: END IF;
1614:

Line 1611: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1607: x_msg_data => x_msg_data,
1608: p_rbk_chr_id => p_chrv_id);
1609: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1610: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1611: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1612: RAISE Okl_Api.G_EXCEPTION_ERROR;
1613: END IF;
1614:
1615: ---------------------------------------------------------------------------------------

Line 1612: RAISE Okl_Api.G_EXCEPTION_ERROR;

1608: p_rbk_chr_id => p_chrv_id);
1609: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1610: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1611: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1612: RAISE Okl_Api.G_EXCEPTION_ERROR;
1613: END IF;
1614:
1615: ---------------------------------------------------------------------------------------
1616: --Bug# 3143522: Subsidies enhancement : Create billing transaction for 'BILL' subsidies

Line 1618: l_subsidy_exists := OKL_API.G_FALSE;

1614:
1615: ---------------------------------------------------------------------------------------
1616: --Bug# 3143522: Subsidies enhancement : Create billing transaction for 'BILL' subsidies
1617: ---------------------------------------------------------------------------------------
1618: l_subsidy_exists := OKL_API.G_FALSE;
1619: okl_subsidy_process_pvt.is_contract_subsidized
1620: (p_api_version => p_api_version,
1621: p_init_msg_list => p_init_msg_list,
1622: x_return_status => x_return_status,

Line 1627: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1623: x_msg_count => x_msg_count,
1624: x_msg_data => x_msg_data,
1625: p_chr_id => p_chrv_id,
1626: x_subsidized => l_subsidy_exists);
1627: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1628: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1629: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1630: RAISE Okl_Api.G_EXCEPTION_ERROR;
1631: END IF;

Line 1628: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1624: x_msg_data => x_msg_data,
1625: p_chr_id => p_chrv_id,
1626: x_subsidized => l_subsidy_exists);
1627: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1628: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1629: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1630: RAISE Okl_Api.G_EXCEPTION_ERROR;
1631: END IF;
1632:

Line 1629: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1625: p_chr_id => p_chrv_id,
1626: x_subsidized => l_subsidy_exists);
1627: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1628: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1629: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1630: RAISE Okl_Api.G_EXCEPTION_ERROR;
1631: END IF;
1632:
1633: If l_subsidy_exists = OKL_API.G_FALSE Then

Line 1630: RAISE Okl_Api.G_EXCEPTION_ERROR;

1626: x_subsidized => l_subsidy_exists);
1627: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1628: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1629: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1630: RAISE Okl_Api.G_EXCEPTION_ERROR;
1631: END IF;
1632:
1633: If l_subsidy_exists = OKL_API.G_FALSE Then
1634: okl_subsidy_process_pvt.is_contract_subsidized

Line 1633: If l_subsidy_exists = OKL_API.G_FALSE Then

1629: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1630: RAISE Okl_Api.G_EXCEPTION_ERROR;
1631: END IF;
1632:
1633: If l_subsidy_exists = OKL_API.G_FALSE Then
1634: okl_subsidy_process_pvt.is_contract_subsidized
1635: (p_api_version => p_api_version,
1636: p_init_msg_list => p_init_msg_list,
1637: x_return_status => x_return_status,

Line 1642: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1638: x_msg_count => x_msg_count,
1639: x_msg_data => x_msg_data,
1640: p_chr_id => l_orig_khr_id,
1641: x_subsidized => l_subsidy_exists);
1642: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1643: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1644: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1645: RAISE Okl_Api.G_EXCEPTION_ERROR;
1646: END IF;

Line 1643: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1639: x_msg_data => x_msg_data,
1640: p_chr_id => l_orig_khr_id,
1641: x_subsidized => l_subsidy_exists);
1642: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1643: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1644: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1645: RAISE Okl_Api.G_EXCEPTION_ERROR;
1646: END IF;
1647: Elsif l_subsidy_exists = OKL_API.G_TRUE then

Line 1644: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1640: p_chr_id => l_orig_khr_id,
1641: x_subsidized => l_subsidy_exists);
1642: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1643: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1644: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1645: RAISE Okl_Api.G_EXCEPTION_ERROR;
1646: END IF;
1647: Elsif l_subsidy_exists = OKL_API.G_TRUE then
1648: Null;

Line 1645: RAISE Okl_Api.G_EXCEPTION_ERROR;

1641: x_subsidized => l_subsidy_exists);
1642: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1643: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1644: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1645: RAISE Okl_Api.G_EXCEPTION_ERROR;
1646: END IF;
1647: Elsif l_subsidy_exists = OKL_API.G_TRUE then
1648: Null;
1649: End If;

Line 1647: Elsif l_subsidy_exists = OKL_API.G_TRUE then

1643: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1644: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1645: RAISE Okl_Api.G_EXCEPTION_ERROR;
1646: END IF;
1647: Elsif l_subsidy_exists = OKL_API.G_TRUE then
1648: Null;
1649: End If;
1650:
1651: If l_subsidy_exists = OKL_API.G_TRUE then

Line 1651: If l_subsidy_exists = OKL_API.G_TRUE then

1647: Elsif l_subsidy_exists = OKL_API.G_TRUE then
1648: Null;
1649: End If;
1650:
1651: If l_subsidy_exists = OKL_API.G_TRUE then
1652: -- varangan - Bug#5474059 - Modified - Start
1653: -- Subsidy billing during rebook done before actual
1654: -- synchronization with main contract. This is to ensure that
1655: -- the subsidy amount differences can be used to generate invoices/

Line 1667: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1663: x_msg_count => x_msg_count,
1664: x_msg_data => x_msg_data,
1665: p_chr_id => p_chrv_id);
1666:
1667: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1668: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1669: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1670: RAISE Okl_Api.G_EXCEPTION_ERROR;
1671: END IF;

Line 1668: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1664: x_msg_data => x_msg_data,
1665: p_chr_id => p_chrv_id);
1666:
1667: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1668: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1669: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1670: RAISE Okl_Api.G_EXCEPTION_ERROR;
1671: END IF;
1672: -- varangan - Bug#5474059 - Modified - End

Line 1669: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1665: p_chr_id => p_chrv_id);
1666:
1667: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1668: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1669: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1670: RAISE Okl_Api.G_EXCEPTION_ERROR;
1671: END IF;
1672: -- varangan - Bug#5474059 - Modified - End
1673:

Line 1670: RAISE Okl_Api.G_EXCEPTION_ERROR;

1666:
1667: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1668: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1669: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1670: RAISE Okl_Api.G_EXCEPTION_ERROR;
1671: END IF;
1672: -- varangan - Bug#5474059 - Modified - End
1673:
1674: --do rebook synchronize for subsidies

Line 1684: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1680: x_msg_data => x_msg_data,
1681: p_rbk_chr_id => p_chrv_id,
1682: p_orig_chr_id => l_orig_khr_id);
1683:
1684: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1685: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1686: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1687: RAISE Okl_Api.G_EXCEPTION_ERROR;
1688: END IF;

Line 1685: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1681: p_rbk_chr_id => p_chrv_id,
1682: p_orig_chr_id => l_orig_khr_id);
1683:
1684: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1685: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1686: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1687: RAISE Okl_Api.G_EXCEPTION_ERROR;
1688: END IF;
1689:

Line 1686: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1682: p_orig_chr_id => l_orig_khr_id);
1683:
1684: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1685: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1686: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1687: RAISE Okl_Api.G_EXCEPTION_ERROR;
1688: END IF;
1689:
1690:

Line 1687: RAISE Okl_Api.G_EXCEPTION_ERROR;

1683:
1684: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1685: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1686: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1687: RAISE Okl_Api.G_EXCEPTION_ERROR;
1688: END IF;
1689:
1690:
1691: End If;

Line 1739: p_memo_yn => okl_api.g_true,

1735: p_contract_id => l_orig_khr_id,
1736: p_transaction_type => l_acct_trans_type,
1737: p_transaction_date => l_rebook_date,
1738: p_draft_yn => l_draft_yn,
1739: p_memo_yn => okl_api.g_true,
1740: x_return_status => x_return_status,
1741: x_msg_count => x_msg_count,
1742: x_msg_data => x_msg_data);
1743:

Line 1744: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1740: x_return_status => x_return_status,
1741: x_msg_count => x_msg_count,
1742: x_msg_data => x_msg_data);
1743:
1744: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1745: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1746: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1747: RAISE Okl_Api.G_EXCEPTION_ERROR;
1748: END IF;

Line 1745: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1741: x_msg_count => x_msg_count,
1742: x_msg_data => x_msg_data);
1743:
1744: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1745: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1746: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1747: RAISE Okl_Api.G_EXCEPTION_ERROR;
1748: END IF;
1749:

Line 1746: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1742: x_msg_data => x_msg_data);
1743:
1744: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1745: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1746: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1747: RAISE Okl_Api.G_EXCEPTION_ERROR;
1748: END IF;
1749:
1750: --ndani - 14-Mar-2013, Start - Rebook accounting fix

Line 1747: RAISE Okl_Api.G_EXCEPTION_ERROR;

1743:
1744: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1745: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1746: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1747: RAISE Okl_Api.G_EXCEPTION_ERROR;
1748: END IF;
1749:
1750: --ndani - 14-Mar-2013, Start - Rebook accounting fix
1751: --Bug# 16511024 : Accounting Booking : Booking to make two accounting calls

Line 1766: p_memo_yn => okl_api.g_true,

1762: p_contract_id => l_orig_khr_id,
1763: p_transaction_type => 'Release', -- l_transaction_type
1764: p_transaction_date => l_rebook_date,
1765: p_draft_yn => l_draft_yn,
1766: p_memo_yn => okl_api.g_true,
1767: x_return_status => x_return_status,
1768: x_msg_count => x_msg_count,
1769: x_msg_data => x_msg_data);
1770:

Line 1771: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1767: x_return_status => x_return_status,
1768: x_msg_count => x_msg_count,
1769: x_msg_data => x_msg_data);
1770:
1771: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1772: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1773: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1774: RAISE Okl_Api.G_EXCEPTION_ERROR;
1775: END IF;

Line 1772: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1768: x_msg_count => x_msg_count,
1769: x_msg_data => x_msg_data);
1770:
1771: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1772: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1773: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1774: RAISE Okl_Api.G_EXCEPTION_ERROR;
1775: END IF;
1776:

Line 1773: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1769: x_msg_data => x_msg_data);
1770:
1771: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1772: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1773: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1774: RAISE Okl_Api.G_EXCEPTION_ERROR;
1775: END IF;
1776:
1777: END IF;

Line 1774: RAISE Okl_Api.G_EXCEPTION_ERROR;

1770:
1771: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1772: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1773: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1774: RAISE Okl_Api.G_EXCEPTION_ERROR;
1775: END IF;
1776:
1777: END IF;
1778: --Bug# 16511024 , End

Line 1788: p_init_msg_list => Okl_Api.G_FALSE,

1784:
1785: -- Sales Tax Project changes Bug: 4622963 - START
1786: okl_la_sales_tax_pvt.process_sales_tax(
1787: p_api_version => p_api_version,
1788: p_init_msg_list => Okl_Api.G_FALSE,
1789: p_commit => Okl_Api.G_FALSE,
1790: p_contract_id => l_orig_khr_id,
1791: p_transaction_type => 'Rebook',
1792: p_transaction_id => l_transaction_id,

Line 1789: p_commit => Okl_Api.G_FALSE,

1785: -- Sales Tax Project changes Bug: 4622963 - START
1786: okl_la_sales_tax_pvt.process_sales_tax(
1787: p_api_version => p_api_version,
1788: p_init_msg_list => Okl_Api.G_FALSE,
1789: p_commit => Okl_Api.G_FALSE,
1790: p_contract_id => l_orig_khr_id,
1791: p_transaction_type => 'Rebook',
1792: p_transaction_id => l_transaction_id,
1793: p_transaction_date => l_rebook_date,

Line 1799: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1795: x_return_status => x_return_status,
1796: x_msg_count => x_msg_count,
1797: x_msg_data => x_msg_data);
1798:
1799: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1800: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1801: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1802: RAISE Okl_Api.G_EXCEPTION_ERROR;
1803: END IF;

Line 1800: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1796: x_msg_count => x_msg_count,
1797: x_msg_data => x_msg_data);
1798:
1799: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1800: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1801: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1802: RAISE Okl_Api.G_EXCEPTION_ERROR;
1803: END IF;
1804: -- Sales Tax Project changes Bug: 4622963 - END

Line 1801: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1797: x_msg_data => x_msg_data);
1798:
1799: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1800: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1801: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1802: RAISE Okl_Api.G_EXCEPTION_ERROR;
1803: END IF;
1804: -- Sales Tax Project changes Bug: 4622963 - END
1805:

Line 1802: RAISE Okl_Api.G_EXCEPTION_ERROR;

1798:
1799: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1800: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1801: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1802: RAISE Okl_Api.G_EXCEPTION_ERROR;
1803: END IF;
1804: -- Sales Tax Project changes Bug: 4622963 - END
1805:
1806: --Bug# 4212626

Line 1822: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1818: x_return_status => x_return_status,
1819: x_msg_count => x_msg_count,
1820: x_msg_data => x_msg_data);
1821:
1822: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1823: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1824: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1825: RAISE Okl_Api.G_EXCEPTION_ERROR;
1826: END IF;

Line 1823: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1819: x_msg_count => x_msg_count,
1820: x_msg_data => x_msg_data);
1821:
1822: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1823: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1824: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1825: RAISE Okl_Api.G_EXCEPTION_ERROR;
1826: END IF;
1827: */

Line 1824: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1820: x_msg_data => x_msg_data);
1821:
1822: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1823: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1824: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1825: RAISE Okl_Api.G_EXCEPTION_ERROR;
1826: END IF;
1827: */
1828:

Line 1825: RAISE Okl_Api.G_EXCEPTION_ERROR;

1821:
1822: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1823: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1824: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1825: RAISE Okl_Api.G_EXCEPTION_ERROR;
1826: END IF;
1827: */
1828:
1829: --Bug#5955320

Line 1833: p_init_msg_list => OKL_API.G_FALSE,

1829: --Bug#5955320
1830: --call insurance API
1831: OKL_INSURANCE_POLICIES_PUB.cancel_create_policies(
1832: p_api_version => p_api_version,
1833: p_init_msg_list => OKL_API.G_FALSE,
1834: x_return_status => x_return_status,
1835: x_msg_count => x_msg_count,
1836: x_msg_data => x_msg_data,
1837: p_khr_id => l_orig_khr_id,

Line 1842: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1838: p_cancellation_date => l_rebook_date,
1839: p_transaction_id => l_transaction_id,
1840: x_ignore_flag => l_ignore_flag);
1841:
1842: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1843: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1844: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1845: If (l_ignore_flag = OKL_API.G_FALSE) then
1846: RAISE Okl_Api.G_EXCEPTION_ERROR;

Line 1843: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1839: p_transaction_id => l_transaction_id,
1840: x_ignore_flag => l_ignore_flag);
1841:
1842: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1843: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1844: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1845: If (l_ignore_flag = OKL_API.G_FALSE) then
1846: RAISE Okl_Api.G_EXCEPTION_ERROR;
1847: End If;

Line 1844: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1840: x_ignore_flag => l_ignore_flag);
1841:
1842: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1843: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1844: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1845: If (l_ignore_flag = OKL_API.G_FALSE) then
1846: RAISE Okl_Api.G_EXCEPTION_ERROR;
1847: End If;
1848: END IF;

Line 1845: If (l_ignore_flag = OKL_API.G_FALSE) then

1841:
1842: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1843: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1844: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1845: If (l_ignore_flag = OKL_API.G_FALSE) then
1846: RAISE Okl_Api.G_EXCEPTION_ERROR;
1847: End If;
1848: END IF;
1849:

Line 1846: RAISE Okl_Api.G_EXCEPTION_ERROR;

1842: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1843: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1844: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1845: If (l_ignore_flag = OKL_API.G_FALSE) then
1846: RAISE Okl_Api.G_EXCEPTION_ERROR;
1847: End If;
1848: END IF;
1849:
1850: --Bug#3278666 : 11.5.10 call Asset management API to invalidate all valid quotes

Line 1860: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1856: x_msg_data => x_msg_data,
1857: p_khr_id => l_orig_khr_id,
1858: p_source_trx_id => NULL
1859: );
1860: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1861: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1862: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1863: RAISE Okl_Api.G_EXCEPTION_ERROR;
1864: END IF;

Line 1861: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1857: p_khr_id => l_orig_khr_id,
1858: p_source_trx_id => NULL
1859: );
1860: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1861: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1862: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1863: RAISE Okl_Api.G_EXCEPTION_ERROR;
1864: END IF;
1865: --Bug# 3278666 : 11.5.10 call Asset management API to invalidate all valid quotes

Line 1862: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1858: p_source_trx_id => NULL
1859: );
1860: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1861: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1862: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1863: RAISE Okl_Api.G_EXCEPTION_ERROR;
1864: END IF;
1865: --Bug# 3278666 : 11.5.10 call Asset management API to invalidate all valid quotes
1866:

Line 1863: RAISE Okl_Api.G_EXCEPTION_ERROR;

1859: );
1860: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1861: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1862: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1863: RAISE Okl_Api.G_EXCEPTION_ERROR;
1864: END IF;
1865: --Bug# 3278666 : 11.5.10 call Asset management API to invalidate all valid quotes
1866:
1867: -- PPD

Line 1879: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1875: ,x_msg_data => x_msg_data
1876: ,p_khr_id => l_orig_khr_id
1877: );
1878:
1879: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1880: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1881: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1882: RAISE Okl_Api.G_EXCEPTION_ERROR;
1883: END IF;

Line 1880: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1876: ,p_khr_id => l_orig_khr_id
1877: );
1878:
1879: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1880: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1881: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1882: RAISE Okl_Api.G_EXCEPTION_ERROR;
1883: END IF;
1884: -- End PPD Cancel

Line 1881: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1877: );
1878:
1879: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1880: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1881: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1882: RAISE Okl_Api.G_EXCEPTION_ERROR;
1883: END IF;
1884: -- End PPD Cancel
1885:

Line 1882: RAISE Okl_Api.G_EXCEPTION_ERROR;

1878:
1879: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1880: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1881: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1882: RAISE Okl_Api.G_EXCEPTION_ERROR;
1883: END IF;
1884: -- End PPD Cancel
1885:
1886: --update transaction status

Line 1897: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1893: p_chr_id => p_chrv_id,
1894: p_status => 'PROCESSED',
1895: x_tcnv_rec => l_tcnv_rec
1896: );
1897: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1898: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1899: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1900: RAISE Okl_Api.G_EXCEPTION_ERROR;
1901: END IF;

Line 1898: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1894: p_status => 'PROCESSED',
1895: x_tcnv_rec => l_tcnv_rec
1896: );
1897: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1898: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1899: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1900: RAISE Okl_Api.G_EXCEPTION_ERROR;
1901: END IF;
1902:

Line 1899: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1895: x_tcnv_rec => l_tcnv_rec
1896: );
1897: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1898: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1899: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1900: RAISE Okl_Api.G_EXCEPTION_ERROR;
1901: END IF;
1902:
1903: -- snarasip

Line 1900: RAISE Okl_Api.G_EXCEPTION_ERROR;

1896: );
1897: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1898: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1899: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1900: RAISE Okl_Api.G_EXCEPTION_ERROR;
1901: END IF;
1902:
1903: -- snarasip
1904: -- before the status is abandoned

Line 1932: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1928: p_edit_mode => 'N', -- snarasip Bug# 15992711 7-Mar-2013 ,added edit mode as 'N' to retain contract status
1929: x_rulv_rec => lx_rulv_rec);
1930:
1931:
1932: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1933: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1934: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1935: RAISE Okl_Api.G_EXCEPTION_ERROR;
1936: END IF;

Line 1933: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1929: x_rulv_rec => lx_rulv_rec);
1930:
1931:
1932: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1933: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1934: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1935: RAISE Okl_Api.G_EXCEPTION_ERROR;
1936: END IF;
1937: END IF;

Line 1934: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1930:
1931:
1932: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1933: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1934: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1935: RAISE Okl_Api.G_EXCEPTION_ERROR;
1936: END IF;
1937: END IF;
1938: END IF;

Line 1935: RAISE Okl_Api.G_EXCEPTION_ERROR;

1931:
1932: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1933: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1934: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1935: RAISE Okl_Api.G_EXCEPTION_ERROR;
1936: END IF;
1937: END IF;
1938: END IF;
1939: l_mxd_ast := '?';

Line 1952: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1948: x_msg_count => x_msg_count,
1949: x_msg_data => x_msg_data,
1950: p_khr_status => 'ABANDONED',
1951: p_chr_id => p_chrv_id);
1952: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1953: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1954: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1955: RAISE Okl_Api.G_EXCEPTION_ERROR;
1956: END IF;

Line 1953: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1949: x_msg_data => x_msg_data,
1950: p_khr_status => 'ABANDONED',
1951: p_chr_id => p_chrv_id);
1952: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1953: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1954: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1955: RAISE Okl_Api.G_EXCEPTION_ERROR;
1956: END IF;
1957:

Line 1954: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1950: p_khr_status => 'ABANDONED',
1951: p_chr_id => p_chrv_id);
1952: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1953: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1954: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1955: RAISE Okl_Api.G_EXCEPTION_ERROR;
1956: END IF;
1957:
1958: --cascade status to lines

Line 1955: RAISE Okl_Api.G_EXCEPTION_ERROR;

1951: p_chr_id => p_chrv_id);
1952: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1953: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1954: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1955: RAISE Okl_Api.G_EXCEPTION_ERROR;
1956: END IF;
1957:
1958: --cascade status to lines
1959: okl_contract_status_pub.cascade_lease_status(

Line 1967: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1963: x_msg_count => x_msg_count,
1964: x_msg_data => x_msg_data,
1965: p_chr_id => p_chrv_id);
1966:
1967: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1968: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1969: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1970: RAISE Okl_Api.G_EXCEPTION_ERROR;
1971: END IF;

Line 1968: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1964: x_msg_data => x_msg_data,
1965: p_chr_id => p_chrv_id);
1966:
1967: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1968: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1969: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1970: RAISE Okl_Api.G_EXCEPTION_ERROR;
1971: END IF;
1972:

Line 1969: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1965: p_chr_id => p_chrv_id);
1966:
1967: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1968: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1969: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1970: RAISE Okl_Api.G_EXCEPTION_ERROR;
1971: END IF;
1972:
1973: -- Bug# 6071566 - Added Start

Line 1970: RAISE Okl_Api.G_EXCEPTION_ERROR;

1966:
1967: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1968: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1969: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1970: RAISE Okl_Api.G_EXCEPTION_ERROR;
1971: END IF;
1972:
1973: -- Bug# 6071566 - Added Start
1974: -- Re-assess the earliest stream bill date on contract after rebook to

Line 1990: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

1986: x_msg_count => x_msg_count,
1987: x_msg_data => x_msg_data,
1988: p_chr_id => p_chrv_id);
1989:
1990: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1991: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1992: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1993: RAISE Okl_Api.G_EXCEPTION_ERROR;
1994: END IF;

Line 1991: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1987: x_msg_data => x_msg_data,
1988: p_chr_id => p_chrv_id);
1989:
1990: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1991: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1992: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1993: RAISE Okl_Api.G_EXCEPTION_ERROR;
1994: END IF;
1995:

Line 1992: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

1988: p_chr_id => p_chrv_id);
1989:
1990: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1991: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1992: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1993: RAISE Okl_Api.G_EXCEPTION_ERROR;
1994: END IF;
1995:
1996: ELSIF l_rel_ast = '!' Then

Line 1993: RAISE Okl_Api.G_EXCEPTION_ERROR;

1989:
1990: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
1991: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1992: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
1993: RAISE Okl_Api.G_EXCEPTION_ERROR;
1994: END IF;
1995:
1996: ELSIF l_rel_ast = '!' Then
1997: /*

Line 2009: l_subsidy_exists := OKL_API.G_FALSE;

2005: --Bug# 3143522: Subsidies enhancement : Check for expired subsidies and stop activation
2006: -- Create billing transaction for 'BILL' subsidies
2007: ---------------------------------------------------------------------------------------
2008:
2009: l_subsidy_exists := OKL_API.G_FALSE;
2010: okl_subsidy_process_pvt.is_contract_subsidized
2011: (p_api_version => p_api_version,
2012: p_init_msg_list => p_init_msg_list,
2013: x_return_status => x_return_status,

Line 2018: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2014: x_msg_count => x_msg_count,
2015: x_msg_data => x_msg_data,
2016: p_chr_id => p_chrv_id,
2017: x_subsidized => l_subsidy_exists);
2018: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2019: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2020: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2021: RAISE Okl_Api.G_EXCEPTION_ERROR;
2022: END IF;

Line 2019: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2015: x_msg_data => x_msg_data,
2016: p_chr_id => p_chrv_id,
2017: x_subsidized => l_subsidy_exists);
2018: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2019: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2020: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2021: RAISE Okl_Api.G_EXCEPTION_ERROR;
2022: END IF;
2023:

Line 2020: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2016: p_chr_id => p_chrv_id,
2017: x_subsidized => l_subsidy_exists);
2018: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2019: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2020: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2021: RAISE Okl_Api.G_EXCEPTION_ERROR;
2022: END IF;
2023:
2024: IF l_subsidy_exists = OKL_API.G_TRUE THEN

Line 2021: RAISE Okl_Api.G_EXCEPTION_ERROR;

2017: x_subsidized => l_subsidy_exists);
2018: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2019: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2020: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2021: RAISE Okl_Api.G_EXCEPTION_ERROR;
2022: END IF;
2023:
2024: IF l_subsidy_exists = OKL_API.G_TRUE THEN
2025: ---------------------------------------------------

Line 2024: IF l_subsidy_exists = OKL_API.G_TRUE THEN

2020: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2021: RAISE Okl_Api.G_EXCEPTION_ERROR;
2022: END IF;
2023:
2024: IF l_subsidy_exists = OKL_API.G_TRUE THEN
2025: ---------------------------------------------------
2026: --check if expired subsidies exist for the contract
2027: ---------------------------------------------------
2028: l_subsidy_valid_status := OKL_API.G_RET_STS_SUCCESS;

Line 2028: l_subsidy_valid_status := OKL_API.G_RET_STS_SUCCESS;

2024: IF l_subsidy_exists = OKL_API.G_TRUE THEN
2025: ---------------------------------------------------
2026: --check if expired subsidies exist for the contract
2027: ---------------------------------------------------
2028: l_subsidy_valid_status := OKL_API.G_RET_STS_SUCCESS;
2029: OPEN l_subsidy_csr (p_chr_id => p_chrv_id);
2030: LOOP
2031: FETCH l_subsidy_csr INTO l_subsidy_rec;
2032: EXIT WHEN l_subsidy_csr%NOTFOUND;

Line 2044: Okl_Api.set_message(

2040: End If;
2041: close l_cle_csr;
2042:
2043: If (l_applicable = 'N') then
2044: Okl_Api.set_message(
2045: p_app_name => G_APP_NAME,
2046: p_msg_name => 'OKL_SUBSIDY_CRITERIA_MATCH',
2047: p_token1 => 'SUBSIDY_NAME',
2048: p_token1_value => l_subsidy_rec.subsidy_name,

Line 2051: l_subsidy_valid_status := OKL_API.G_RET_STS_ERROR;

2047: p_token1 => 'SUBSIDY_NAME',
2048: p_token1_value => l_subsidy_rec.subsidy_name,
2049: p_token2 => 'ASSET_NUMBER',
2050: p_token2_value => l_subsidy_rec.asset_number);
2051: l_subsidy_valid_status := OKL_API.G_RET_STS_ERROR;
2052: end if;
2053:
2054: --IF((l_subsidy_rec.effective_to_date + l_subsidy_rec.expire_after_days) < TRUNC(SYSDATE))THEN
2055: if( TRUNC(sysdate) not between TRUNC(l_subsidy_rec.effective_from_date) and

Line 2058: OKL_API.Set_Message(p_app_name => G_APP_NAME,

2054: --IF((l_subsidy_rec.effective_to_date + l_subsidy_rec.expire_after_days) < TRUNC(SYSDATE))THEN
2055: if( TRUNC(sysdate) not between TRUNC(l_subsidy_rec.effective_from_date) and
2056: TRUNC(nvl(l_subsidy_rec.EFFECTIVE_TO_DATE,sysdate) + nvl(l_subsidy_rec.EXPIRE_AFTER_DAYS,0)))then
2057: --shagarg bug 6032336 end
2058: OKL_API.Set_Message(p_app_name => G_APP_NAME,
2059: p_msg_name => 'OKL_SUBSIDY_EXPIRED',
2060: p_token1 => 'SUBSIDY',
2061: p_token1_value => l_subsidy_rec.subsidy_name,
2062: p_token2 => 'ASSET_NUMBER',

Line 2064: l_subsidy_valid_status := OKL_API.G_RET_STS_ERROR;

2060: p_token1 => 'SUBSIDY',
2061: p_token1_value => l_subsidy_rec.subsidy_name,
2062: p_token2 => 'ASSET_NUMBER',
2063: p_token2_value => l_subsidy_rec.asset_number);
2064: l_subsidy_valid_status := OKL_API.G_RET_STS_ERROR;
2065:
2066:
2067:
2068: ELSE

Line 2124: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2120: CLOSE l_subsidy_csr;
2121:
2122: x_return_status := l_subsidy_valid_status;
2123:
2124: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2125: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2126: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2127: RAISE Okl_Api.G_EXCEPTION_ERROR;
2128: END IF;

Line 2125: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2121:
2122: x_return_status := l_subsidy_valid_status;
2123:
2124: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2125: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2126: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2127: RAISE Okl_Api.G_EXCEPTION_ERROR;
2128: END IF;
2129:

Line 2126: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2122: x_return_status := l_subsidy_valid_status;
2123:
2124: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2125: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2126: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2127: RAISE Okl_Api.G_EXCEPTION_ERROR;
2128: END IF;
2129:
2130:

Line 2127: RAISE Okl_Api.G_EXCEPTION_ERROR;

2123:
2124: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2125: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2126: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2127: RAISE Okl_Api.G_EXCEPTION_ERROR;
2128: END IF;
2129:
2130:
2131: --call process API to create Billing transactions for Subsidies ;

Line 2140: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2136: x_msg_count => x_msg_count,
2137: x_msg_data => x_msg_data,
2138: p_chr_id => p_chrv_id);
2139:
2140: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2141: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2142: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2143: RAISE Okl_Api.G_EXCEPTION_ERROR;
2144: END IF;

Line 2141: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2137: x_msg_data => x_msg_data,
2138: p_chr_id => p_chrv_id);
2139:
2140: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2141: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2142: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2143: RAISE Okl_Api.G_EXCEPTION_ERROR;
2144: END IF;
2145: End If;

Line 2142: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2138: p_chr_id => p_chrv_id);
2139:
2140: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2141: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2142: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2143: RAISE Okl_Api.G_EXCEPTION_ERROR;
2144: END IF;
2145: End If;
2146: -------------------------------------------------------------------------

Line 2143: RAISE Okl_Api.G_EXCEPTION_ERROR;

2139:
2140: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2141: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2142: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2143: RAISE Okl_Api.G_EXCEPTION_ERROR;
2144: END IF;
2145: End If;
2146: -------------------------------------------------------------------------
2147: --Bug#i 3143522 : End Subsidies enhancement

Line 2161: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2157: x_msg_count => x_msg_count,
2158: x_msg_data => x_msg_data,
2159: p_rel_chr_id => p_chrv_id);
2160:
2161: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2162: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2163: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2164: RAISE Okl_Api.G_EXCEPTION_ERROR;
2165: END IF;

Line 2162: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2158: x_msg_data => x_msg_data,
2159: p_rel_chr_id => p_chrv_id);
2160:
2161: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2162: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2163: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2164: RAISE Okl_Api.G_EXCEPTION_ERROR;
2165: END IF;
2166:

Line 2163: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2159: p_rel_chr_id => p_chrv_id);
2160:
2161: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2162: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2163: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2164: RAISE Okl_Api.G_EXCEPTION_ERROR;
2165: END IF;
2166:
2167: --Bug# 3533936 :

Line 2164: RAISE Okl_Api.G_EXCEPTION_ERROR;

2160:
2161: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2162: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2163: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2164: RAISE Okl_Api.G_EXCEPTION_ERROR;
2165: END IF;
2166:
2167: --Bug# 3533936 :
2168: --call the install base instance re_lease API

Line 2177: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2173: x_msg_count => x_msg_count,
2174: x_msg_data => x_msg_data,
2175: p_rel_chr_id => p_chrv_id);
2176:
2177: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2178: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2179: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2180: RAISE Okl_Api.G_EXCEPTION_ERROR;
2181: END IF;

Line 2178: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2174: x_msg_data => x_msg_data,
2175: p_rel_chr_id => p_chrv_id);
2176:
2177: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2178: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2179: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2180: RAISE Okl_Api.G_EXCEPTION_ERROR;
2181: END IF;
2182:

Line 2179: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2175: p_rel_chr_id => p_chrv_id);
2176:
2177: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2178: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2179: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2180: RAISE Okl_Api.G_EXCEPTION_ERROR;
2181: END IF;
2182:
2183: --Bug#2522439 Start

Line 2180: RAISE Okl_Api.G_EXCEPTION_ERROR;

2176:
2177: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2178: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2179: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2180: RAISE Okl_Api.G_EXCEPTION_ERROR;
2181: END IF;
2182:
2183: --Bug#2522439 Start
2184: --code added to update status in OKL_ASSET_RETURNS_B

Line 2203: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2199: ,x_msg_data => x_msg_data
2200: ,p_artv_rec => l_artv_rec
2201: ,x_artv_rec => lx_artv_rec);
2202:
2203: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2204: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2205: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2206: RAISE Okl_Api.G_EXCEPTION_ERROR;
2207: END IF;

Line 2204: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2200: ,p_artv_rec => l_artv_rec
2201: ,x_artv_rec => lx_artv_rec);
2202:
2203: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2204: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2205: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2206: RAISE Okl_Api.G_EXCEPTION_ERROR;
2207: END IF;
2208: END LOOP;

Line 2205: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2201: ,x_artv_rec => lx_artv_rec);
2202:
2203: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2204: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2205: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2206: RAISE Okl_Api.G_EXCEPTION_ERROR;
2207: END IF;
2208: END LOOP;
2209: CLOSE l_asr_csr;

Line 2206: RAISE Okl_Api.G_EXCEPTION_ERROR;

2202:
2203: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2204: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2205: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2206: RAISE Okl_Api.G_EXCEPTION_ERROR;
2207: END IF;
2208: END LOOP;
2209: CLOSE l_asr_csr;
2210: --Bug#2522439 End

Line 2228: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2224: p_edit_mode => 'N', -- snarasip Bug# 15992711 7-Mar-2013 ,added edit mode as 'N' to retain contract status
2225: x_rulv_rec => lx_rulv_rec);
2226:
2227:
2228: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2229: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2230: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2231: RAISE Okl_Api.G_EXCEPTION_ERROR;
2232: END IF;

Line 2229: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2225: x_rulv_rec => lx_rulv_rec);
2226:
2227:
2228: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2229: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2230: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2231: RAISE Okl_Api.G_EXCEPTION_ERROR;
2232: END IF;
2233: -- End:update header level re_leased asset flag to 'Y'

Line 2230: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2226:
2227:
2228: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2229: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2230: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2231: RAISE Okl_Api.G_EXCEPTION_ERROR;
2232: END IF;
2233: -- End:update header level re_leased asset flag to 'Y'
2234: --when all the assets on a contract are re-leased

Line 2231: RAISE Okl_Api.G_EXCEPTION_ERROR;

2227:
2228: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2229: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2230: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2231: RAISE Okl_Api.G_EXCEPTION_ERROR;
2232: END IF;
2233: -- End:update header level re_leased asset flag to 'Y'
2234: --when all the assets on a contract are re-leased
2235:

Line 2244: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2240: --check for billto status
2241: Validate_bill_To(p_chr_id => p_chrv_id,
2242: x_return_status => x_return_status);
2243:
2244: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2245: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2246: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2247: RAISE Okl_Api.G_EXCEPTION_ERROR;
2248: END IF;

Line 2245: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2241: Validate_bill_To(p_chr_id => p_chrv_id,
2242: x_return_status => x_return_status);
2243:
2244: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2245: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2246: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2247: RAISE Okl_Api.G_EXCEPTION_ERROR;
2248: END IF;
2249: --bug # 2953906 end.

Line 2246: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2242: x_return_status => x_return_status);
2243:
2244: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2245: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2246: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2247: RAISE Okl_Api.G_EXCEPTION_ERROR;
2248: END IF;
2249: --bug # 2953906 end.
2250:

Line 2247: RAISE Okl_Api.G_EXCEPTION_ERROR;

2243:
2244: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2245: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2246: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2247: RAISE Okl_Api.G_EXCEPTION_ERROR;
2248: END IF;
2249: --bug # 2953906 end.
2250:
2251: -------------------------------------------------------------------------

Line 2281: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2277: p_Activation_date => l_start_date,
2278: x_amount => l_amount,
2279: x_source_id => l_source_id);
2280:
2281: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2282: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2283: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2284: RAISE Okl_Api.G_EXCEPTION_ERROR;
2285: END IF;

Line 2282: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2278: x_amount => l_amount,
2279: x_source_id => l_source_id);
2280:
2281: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2282: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2283: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2284: RAISE Okl_Api.G_EXCEPTION_ERROR;
2285: END IF;
2286: end if;

Line 2283: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2279: x_source_id => l_source_id);
2280:
2281: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2282: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2283: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2284: RAISE Okl_Api.G_EXCEPTION_ERROR;
2285: END IF;
2286: end if;
2287: -- Bug# 3541098 end.

Line 2284: RAISE Okl_Api.G_EXCEPTION_ERROR;

2280:
2281: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2282: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2283: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2284: RAISE Okl_Api.G_EXCEPTION_ERROR;
2285: END IF;
2286: end if;
2287: -- Bug# 3541098 end.
2288:

Line 2295: l_subsidy_exists := OKL_API.G_FALSE;

2291: -- Subsidies enhancement : Check for expired subsidies and stop activation
2292: -- Create billing transaction for 'BILL' subsidies
2293: ---------------------------------------------------------------------------------------
2294:
2295: l_subsidy_exists := OKL_API.G_FALSE;
2296: okl_subsidy_process_pvt.is_contract_subsidized
2297: (p_api_version => p_api_version,
2298: p_init_msg_list => p_init_msg_list,
2299: x_return_status => x_return_status,

Line 2304: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2300: x_msg_count => x_msg_count,
2301: x_msg_data => x_msg_data,
2302: p_chr_id => p_chrv_id,
2303: x_subsidized => l_subsidy_exists);
2304: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2305: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2306: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2307: RAISE Okl_Api.G_EXCEPTION_ERROR;
2308: END IF;

Line 2305: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2301: x_msg_data => x_msg_data,
2302: p_chr_id => p_chrv_id,
2303: x_subsidized => l_subsidy_exists);
2304: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2305: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2306: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2307: RAISE Okl_Api.G_EXCEPTION_ERROR;
2308: END IF;
2309:

Line 2306: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2302: p_chr_id => p_chrv_id,
2303: x_subsidized => l_subsidy_exists);
2304: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2305: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2306: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2307: RAISE Okl_Api.G_EXCEPTION_ERROR;
2308: END IF;
2309:
2310: IF l_subsidy_exists = OKL_API.G_TRUE THEN

Line 2307: RAISE Okl_Api.G_EXCEPTION_ERROR;

2303: x_subsidized => l_subsidy_exists);
2304: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2305: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2306: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2307: RAISE Okl_Api.G_EXCEPTION_ERROR;
2308: END IF;
2309:
2310: IF l_subsidy_exists = OKL_API.G_TRUE THEN
2311: ---------------------------------------------------

Line 2310: IF l_subsidy_exists = OKL_API.G_TRUE THEN

2306: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2307: RAISE Okl_Api.G_EXCEPTION_ERROR;
2308: END IF;
2309:
2310: IF l_subsidy_exists = OKL_API.G_TRUE THEN
2311: ---------------------------------------------------
2312: --check if expired subsidies exist for the contract
2313: ---------------------------------------------------
2314: l_subsidy_valid_status := OKL_API.G_RET_STS_SUCCESS;

Line 2314: l_subsidy_valid_status := OKL_API.G_RET_STS_SUCCESS;

2310: IF l_subsidy_exists = OKL_API.G_TRUE THEN
2311: ---------------------------------------------------
2312: --check if expired subsidies exist for the contract
2313: ---------------------------------------------------
2314: l_subsidy_valid_status := OKL_API.G_RET_STS_SUCCESS;
2315: OPEN l_subsidy_csr (p_chr_id => p_chrv_id);
2316: LOOP
2317: FETCH l_subsidy_csr INTO l_subsidy_rec;
2318: EXIT WHEN l_subsidy_csr%NOTFOUND;

Line 2329: Okl_Api.set_message(

2325: End If;
2326: close l_cle_csr;
2327:
2328: If (l_applicable = 'N') then
2329: Okl_Api.set_message(
2330: p_app_name => G_APP_NAME,
2331: p_msg_name => 'OKL_SUBSIDY_CRITERIA_MATCH',
2332: p_token1 => 'SUBSIDY_NAME',
2333: p_token1_value => l_subsidy_rec.subsidy_name,

Line 2336: l_subsidy_valid_status := OKL_API.G_RET_STS_ERROR;

2332: p_token1 => 'SUBSIDY_NAME',
2333: p_token1_value => l_subsidy_rec.subsidy_name,
2334: p_token2 => 'ASSET_NUMBER',
2335: p_token2_value => l_subsidy_rec.asset_number);
2336: l_subsidy_valid_status := OKL_API.G_RET_STS_ERROR;
2337: end if;
2338:
2339: --IF((l_subsidy_rec.effective_to_date + l_subsidy_rec.expire_after_days) < TRUNC(SYSDATE))THEN
2340: if( TRUNC(sysdate) not between TRUNC(l_subsidy_rec.effective_from_date) and

Line 2342: OKL_API.Set_Message(p_app_name => G_APP_NAME,

2338:
2339: --IF((l_subsidy_rec.effective_to_date + l_subsidy_rec.expire_after_days) < TRUNC(SYSDATE))THEN
2340: if( TRUNC(sysdate) not between TRUNC(l_subsidy_rec.effective_from_date) and
2341: TRUNC(nvl(l_subsidy_rec.EFFECTIVE_TO_DATE,sysdate) + nvl(l_subsidy_rec.EXPIRE_AFTER_DAYS,0)))then
2342: OKL_API.Set_Message(p_app_name => G_APP_NAME,
2343: p_msg_name => 'OKL_SUBSIDY_EXPIRED',
2344: p_token1 => 'SUBSIDY',
2345: p_token1_value => l_subsidy_rec.subsidy_name,
2346: p_token2 => 'ASSET_NUMBER',

Line 2348: l_subsidy_valid_status := OKL_API.G_RET_STS_ERROR;

2344: p_token1 => 'SUBSIDY',
2345: p_token1_value => l_subsidy_rec.subsidy_name,
2346: p_token2 => 'ASSET_NUMBER',
2347: p_token2_value => l_subsidy_rec.asset_number);
2348: l_subsidy_valid_status := OKL_API.G_RET_STS_ERROR;
2349:
2350:
2351:
2352: ELSE

Line 2408: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2404: CLOSE l_subsidy_csr;
2405:
2406: x_return_status := l_subsidy_valid_status;
2407:
2408: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2409: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2410: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2411: RAISE Okl_Api.G_EXCEPTION_ERROR;
2412: END IF;

Line 2409: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2405:
2406: x_return_status := l_subsidy_valid_status;
2407:
2408: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2409: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2410: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2411: RAISE Okl_Api.G_EXCEPTION_ERROR;
2412: END IF;
2413:

Line 2410: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2406: x_return_status := l_subsidy_valid_status;
2407:
2408: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2409: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2410: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2411: RAISE Okl_Api.G_EXCEPTION_ERROR;
2412: END IF;
2413:
2414:

Line 2411: RAISE Okl_Api.G_EXCEPTION_ERROR;

2407:
2408: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2409: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2410: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2411: RAISE Okl_Api.G_EXCEPTION_ERROR;
2412: END IF;
2413:
2414:
2415: --call process API to create Billing transactions for Subsidies ;

Line 2424: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2420: x_msg_count => x_msg_count,
2421: x_msg_data => x_msg_data,
2422: p_chr_id => p_chrv_id);
2423:
2424: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2425: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2426: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2427: RAISE Okl_Api.G_EXCEPTION_ERROR;
2428: END IF;

Line 2425: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2421: x_msg_data => x_msg_data,
2422: p_chr_id => p_chrv_id);
2423:
2424: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2425: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2426: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2427: RAISE Okl_Api.G_EXCEPTION_ERROR;
2428: END IF;
2429: End If;

Line 2426: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2422: p_chr_id => p_chrv_id);
2423:
2424: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2425: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2426: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2427: RAISE Okl_Api.G_EXCEPTION_ERROR;
2428: END IF;
2429: End If;
2430:

Line 2427: RAISE Okl_Api.G_EXCEPTION_ERROR;

2423:
2424: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2425: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2426: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2427: RAISE Okl_Api.G_EXCEPTION_ERROR;
2428: END IF;
2429: End If;
2430:
2431: --call fa activation API

Line 2441: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2437: p_chrv_id => p_chrv_id,
2438: p_call_mode => p_call_mode,
2439: x_cimv_tbl => l_cimv_tbl_fa);
2440:
2441: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2442: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2443: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2444: RAISE Okl_Api.G_EXCEPTION_ERROR;
2445: END IF;

Line 2442: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2438: p_call_mode => p_call_mode,
2439: x_cimv_tbl => l_cimv_tbl_fa);
2440:
2441: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2442: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2443: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2444: RAISE Okl_Api.G_EXCEPTION_ERROR;
2445: END IF;
2446:

Line 2443: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2439: x_cimv_tbl => l_cimv_tbl_fa);
2440:
2441: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2442: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2443: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2444: RAISE Okl_Api.G_EXCEPTION_ERROR;
2445: END IF;
2446:
2447: --Bug# 2726870 : 11.5.9 enhancment Service contracts integration

Line 2444: RAISE Okl_Api.G_EXCEPTION_ERROR;

2440:
2441: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2442: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2443: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2444: RAISE Okl_Api.G_EXCEPTION_ERROR;
2445: END IF;
2446:
2447: --Bug# 2726870 : 11.5.9 enhancment Service contracts integration
2448: --call service integration api :

Line 2457: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2453: x_msg_count => x_msg_count,
2454: x_msg_data => x_msg_data,
2455: p_okl_chr_id => p_chrv_id);
2456:
2457: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2458: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2459: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2460: RAISE Okl_Api.G_EXCEPTION_ERROR;
2461: END IF;

Line 2458: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2454: x_msg_data => x_msg_data,
2455: p_okl_chr_id => p_chrv_id);
2456:
2457: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2458: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2459: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2460: RAISE Okl_Api.G_EXCEPTION_ERROR;
2461: END IF;
2462:

Line 2459: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2455: p_okl_chr_id => p_chrv_id);
2456:
2457: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2458: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2459: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2460: RAISE Okl_Api.G_EXCEPTION_ERROR;
2461: END IF;
2462:
2463: --call ib activation API

Line 2460: RAISE Okl_Api.G_EXCEPTION_ERROR;

2456:
2457: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2458: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2459: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2460: RAISE Okl_Api.G_EXCEPTION_ERROR;
2461: END IF;
2462:
2463: --call ib activation API
2464: Okl_Activate_Ib_Pub.ACTIVATE_IB_INSTANCE(p_api_version => p_api_version,

Line 2473: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2469: p_chrv_id => p_chrv_id,
2470: p_call_mode => p_call_mode,
2471: x_cimv_tbl => l_cimv_tbl_ib);
2472:
2473: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2474: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2475: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2476: RAISE Okl_Api.G_EXCEPTION_ERROR;
2477: END IF;

Line 2474: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2470: p_call_mode => p_call_mode,
2471: x_cimv_tbl => l_cimv_tbl_ib);
2472:
2473: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2474: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2475: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2476: RAISE Okl_Api.G_EXCEPTION_ERROR;
2477: END IF;
2478:

Line 2475: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2471: x_cimv_tbl => l_cimv_tbl_ib);
2472:
2473: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2474: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2475: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2476: RAISE Okl_Api.G_EXCEPTION_ERROR;
2477: END IF;
2478:
2479: --check if usage line is there on the contract

Line 2476: RAISE Okl_Api.G_EXCEPTION_ERROR;

2472:
2473: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2474: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2475: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2476: RAISE Okl_Api.G_EXCEPTION_ERROR;
2477: END IF;
2478:
2479: --check if usage line is there on the contract
2480: l_usage_khr := '?';

Line 2500: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2496: p_chr_id => p_chrv_id,
2497: x_chr_id => l_service_chr_id
2498: );
2499:
2500: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2501: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2502: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2503: RAISE Okl_Api.G_EXCEPTION_ERROR;
2504: END IF;

Line 2501: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2497: x_chr_id => l_service_chr_id
2498: );
2499:
2500: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2501: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2502: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2503: RAISE Okl_Api.G_EXCEPTION_ERROR;
2504: END IF;
2505: End If;

Line 2502: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2498: );
2499:
2500: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2501: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2502: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2503: RAISE Okl_Api.G_EXCEPTION_ERROR;
2504: END IF;
2505: End If;
2506:

Line 2503: RAISE Okl_Api.G_EXCEPTION_ERROR;

2499:
2500: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2501: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2502: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2503: RAISE Okl_Api.G_EXCEPTION_ERROR;
2504: END IF;
2505: End If;
2506:
2507: -- call the asset release api

Line 2516: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2512: x_msg_count => x_msg_count,
2513: x_msg_data => x_msg_data,
2514: p_rel_chr_id => p_chrv_id);
2515:
2516: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2517: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2518: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2519: RAISE Okl_Api.G_EXCEPTION_ERROR;
2520: END IF;

Line 2517: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2513: x_msg_data => x_msg_data,
2514: p_rel_chr_id => p_chrv_id);
2515:
2516: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2517: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2518: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2519: RAISE Okl_Api.G_EXCEPTION_ERROR;
2520: END IF;
2521:

Line 2518: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2514: p_rel_chr_id => p_chrv_id);
2515:
2516: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2517: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2518: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2519: RAISE Okl_Api.G_EXCEPTION_ERROR;
2520: END IF;
2521:
2522: --call the install base instance re_lease API

Line 2519: RAISE Okl_Api.G_EXCEPTION_ERROR;

2515:
2516: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2517: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2518: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2519: RAISE Okl_Api.G_EXCEPTION_ERROR;
2520: END IF;
2521:
2522: --call the install base instance re_lease API
2523: okl_activate_ib_pvt.RELEASE_IB_INSTANCE

Line 2531: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2527: x_msg_count => x_msg_count,
2528: x_msg_data => x_msg_data,
2529: p_rel_chr_id => p_chrv_id);
2530:
2531: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2532: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2533: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2534: RAISE Okl_Api.G_EXCEPTION_ERROR;
2535: END IF;

Line 2532: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2528: x_msg_data => x_msg_data,
2529: p_rel_chr_id => p_chrv_id);
2530:
2531: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2532: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2533: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2534: RAISE Okl_Api.G_EXCEPTION_ERROR;
2535: END IF;
2536:

Line 2533: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2529: p_rel_chr_id => p_chrv_id);
2530:
2531: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2532: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2533: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2534: RAISE Okl_Api.G_EXCEPTION_ERROR;
2535: END IF;
2536:
2537: --code added to update status in OKL_ASSET_RETURNS_B

Line 2534: RAISE Okl_Api.G_EXCEPTION_ERROR;

2530:
2531: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2532: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2533: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2534: RAISE Okl_Api.G_EXCEPTION_ERROR;
2535: END IF;
2536:
2537: --code added to update status in OKL_ASSET_RETURNS_B
2538: --after the release asset transaction has been processed

Line 2556: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2552: ,x_msg_data => x_msg_data
2553: ,p_artv_rec => l_artv_rec
2554: ,x_artv_rec => lx_artv_rec);
2555:
2556: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2557: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2558: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2559: RAISE Okl_Api.G_EXCEPTION_ERROR;
2560: END IF;

Line 2557: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2553: ,p_artv_rec => l_artv_rec
2554: ,x_artv_rec => lx_artv_rec);
2555:
2556: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2557: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2558: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2559: RAISE Okl_Api.G_EXCEPTION_ERROR;
2560: END IF;
2561: END LOOP;

Line 2558: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2554: ,x_artv_rec => lx_artv_rec);
2555:
2556: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2557: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2558: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2559: RAISE Okl_Api.G_EXCEPTION_ERROR;
2560: END IF;
2561: END LOOP;
2562: CLOSE l_asr_csr;

Line 2559: RAISE Okl_Api.G_EXCEPTION_ERROR;

2555:
2556: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2557: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2558: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2559: RAISE Okl_Api.G_EXCEPTION_ERROR;
2560: END IF;
2561: END LOOP;
2562: CLOSE l_asr_csr;
2563: --End:In case of a mixed contract

Line 2571: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2567: --check for billto status
2568: Validate_bill_To(p_chr_id => p_chrv_id,
2569: x_return_status => x_return_status);
2570:
2571: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2572: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2573: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2574: RAISE Okl_Api.G_EXCEPTION_ERROR;
2575: END IF;

Line 2572: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2568: Validate_bill_To(p_chr_id => p_chrv_id,
2569: x_return_status => x_return_status);
2570:
2571: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2572: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2573: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2574: RAISE Okl_Api.G_EXCEPTION_ERROR;
2575: END IF;
2576: --bug # 2953906 end.

Line 2573: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2569: x_return_status => x_return_status);
2570:
2571: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2572: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2573: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2574: RAISE Okl_Api.G_EXCEPTION_ERROR;
2575: END IF;
2576: --bug # 2953906 end.
2577:

Line 2574: RAISE Okl_Api.G_EXCEPTION_ERROR;

2570:
2571: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2572: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2573: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2574: RAISE Okl_Api.G_EXCEPTION_ERROR;
2575: END IF;
2576: --bug # 2953906 end.
2577:
2578: -------------------------------------------------------------------------

Line 2608: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2604: p_Activation_date => l_start_date,
2605: x_amount => l_amount,
2606: x_source_id => l_source_id);
2607:
2608: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2609: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2610: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2611: RAISE Okl_Api.G_EXCEPTION_ERROR;
2612: END IF;

Line 2609: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2605: x_amount => l_amount,
2606: x_source_id => l_source_id);
2607:
2608: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2609: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2610: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2611: RAISE Okl_Api.G_EXCEPTION_ERROR;
2612: END IF;
2613: end if;

Line 2610: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2606: x_source_id => l_source_id);
2607:
2608: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2609: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2610: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2611: RAISE Okl_Api.G_EXCEPTION_ERROR;
2612: END IF;
2613: end if;
2614: -- Bug# 3541098 end.

Line 2611: RAISE Okl_Api.G_EXCEPTION_ERROR;

2607:
2608: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2609: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2610: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2611: RAISE Okl_Api.G_EXCEPTION_ERROR;
2612: END IF;
2613: end if;
2614: -- Bug# 3541098 end.
2615:

Line 2620: l_subsidy_exists := OKL_API.G_FALSE;

2616: ---------------------------------------------------------------------------------------
2617: --Bug# 3143522: Subsidies enhancement : Check for expired subsidies and stop activation
2618: -- Create billing transaction for 'BILL' subsidies
2619: ---------------------------------------------------------------------------------------
2620: l_subsidy_exists := OKL_API.G_FALSE;
2621: okl_subsidy_process_pvt.is_contract_subsidized
2622: (p_api_version => p_api_version,
2623: p_init_msg_list => p_init_msg_list,
2624: x_return_status => x_return_status,

Line 2629: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2625: x_msg_count => x_msg_count,
2626: x_msg_data => x_msg_data,
2627: p_chr_id => p_chrv_id,
2628: x_subsidized => l_subsidy_exists);
2629: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2630: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2631: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2632: RAISE Okl_Api.G_EXCEPTION_ERROR;
2633: END IF;

Line 2630: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2626: x_msg_data => x_msg_data,
2627: p_chr_id => p_chrv_id,
2628: x_subsidized => l_subsidy_exists);
2629: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2630: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2631: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2632: RAISE Okl_Api.G_EXCEPTION_ERROR;
2633: END IF;
2634:

Line 2631: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2627: p_chr_id => p_chrv_id,
2628: x_subsidized => l_subsidy_exists);
2629: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2630: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2631: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2632: RAISE Okl_Api.G_EXCEPTION_ERROR;
2633: END IF;
2634:
2635: IF l_subsidy_exists = OKL_API.G_TRUE THEN

Line 2632: RAISE Okl_Api.G_EXCEPTION_ERROR;

2628: x_subsidized => l_subsidy_exists);
2629: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2630: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2631: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2632: RAISE Okl_Api.G_EXCEPTION_ERROR;
2633: END IF;
2634:
2635: IF l_subsidy_exists = OKL_API.G_TRUE THEN
2636: ---------------------------------------------------

Line 2635: IF l_subsidy_exists = OKL_API.G_TRUE THEN

2631: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2632: RAISE Okl_Api.G_EXCEPTION_ERROR;
2633: END IF;
2634:
2635: IF l_subsidy_exists = OKL_API.G_TRUE THEN
2636: ---------------------------------------------------
2637: --check if expired subsidies exist for the contract
2638: ---------------------------------------------------
2639: l_subsidy_valid_status := OKL_API.G_RET_STS_SUCCESS;

Line 2639: l_subsidy_valid_status := OKL_API.G_RET_STS_SUCCESS;

2635: IF l_subsidy_exists = OKL_API.G_TRUE THEN
2636: ---------------------------------------------------
2637: --check if expired subsidies exist for the contract
2638: ---------------------------------------------------
2639: l_subsidy_valid_status := OKL_API.G_RET_STS_SUCCESS;
2640: OPEN l_subsidy_csr (p_chr_id => p_chrv_id);
2641: LOOP
2642: FETCH l_subsidy_csr INTO l_subsidy_rec;
2643: EXIT WHEN l_subsidy_csr%NOTFOUND;

Line 2655: Okl_Api.set_message(

2651: End If;
2652: close l_cle_csr;
2653:
2654: If (l_applicable = 'N') then
2655: Okl_Api.set_message(
2656: p_app_name => G_APP_NAME,
2657: p_msg_name => 'OKL_SUBSIDY_CRITERIA_MATCH',
2658: p_token1 => 'SUBSIDY_NAME',
2659: p_token1_value => l_subsidy_rec.subsidy_name,

Line 2662: l_subsidy_valid_status := OKL_API.G_RET_STS_ERROR;

2658: p_token1 => 'SUBSIDY_NAME',
2659: p_token1_value => l_subsidy_rec.subsidy_name,
2660: p_token2 => 'ASSET_NUMBER',
2661: p_token2_value => l_subsidy_rec.asset_number);
2662: l_subsidy_valid_status := OKL_API.G_RET_STS_ERROR;
2663: end if;
2664:
2665: --IF((l_subsidy_rec.effective_to_date + l_subsidy_rec.expire_after_days) < TRUNC(SYSDATE))THEN
2666: if( TRUNC(sysdate) not between TRUNC(l_subsidy_rec.effective_from_date) and

Line 2669: OKL_API.Set_Message(p_app_name => G_APP_NAME,

2665: --IF((l_subsidy_rec.effective_to_date + l_subsidy_rec.expire_after_days) < TRUNC(SYSDATE))THEN
2666: if( TRUNC(sysdate) not between TRUNC(l_subsidy_rec.effective_from_date) and
2667: TRUNC(nvl(l_subsidy_rec.EFFECTIVE_TO_DATE,sysdate) + nvl(l_subsidy_rec.EXPIRE_AFTER_DAYS,0)))then
2668: --End : Bug 6050165 : prasjain
2669: OKL_API.Set_Message(p_app_name => G_APP_NAME,
2670: p_msg_name => 'OKL_SUBSIDY_EXPIRED',
2671: p_token1 => 'SUBSIDY',
2672: p_token1_value => l_subsidy_rec.subsidy_name,
2673: p_token2 => 'ASSET_NUMBER',

Line 2675: l_subsidy_valid_status := OKL_API.G_RET_STS_ERROR;

2671: p_token1 => 'SUBSIDY',
2672: p_token1_value => l_subsidy_rec.subsidy_name,
2673: p_token2 => 'ASSET_NUMBER',
2674: p_token2_value => l_subsidy_rec.asset_number);
2675: l_subsidy_valid_status := OKL_API.G_RET_STS_ERROR;
2676: ELSE
2677: /*
2678: * sjalasut added code for subsidy pools enhancement, the subsidy is checked for association
2679: * with the subsidy pool, if associated, the authoring transaction api is invoked for

Line 2732: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2728: CLOSE l_subsidy_csr;
2729:
2730: x_return_status := l_subsidy_valid_status;
2731:
2732: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2733: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2734: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2735: RAISE Okl_Api.G_EXCEPTION_ERROR;
2736: END IF;

Line 2733: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2729:
2730: x_return_status := l_subsidy_valid_status;
2731:
2732: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2733: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2734: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2735: RAISE Okl_Api.G_EXCEPTION_ERROR;
2736: END IF;
2737:

Line 2734: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2730: x_return_status := l_subsidy_valid_status;
2731:
2732: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2733: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2734: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2735: RAISE Okl_Api.G_EXCEPTION_ERROR;
2736: END IF;
2737:
2738:

Line 2735: RAISE Okl_Api.G_EXCEPTION_ERROR;

2731:
2732: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2733: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2734: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2735: RAISE Okl_Api.G_EXCEPTION_ERROR;
2736: END IF;
2737:
2738:
2739:

Line 2750: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2746: x_msg_count => x_msg_count,
2747: x_msg_data => x_msg_data,
2748: p_chr_id => p_chrv_id);
2749:
2750: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2751: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2752: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2753: RAISE Okl_Api.G_EXCEPTION_ERROR;
2754: END IF;

Line 2751: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2747: x_msg_data => x_msg_data,
2748: p_chr_id => p_chrv_id);
2749:
2750: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2751: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2752: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2753: RAISE Okl_Api.G_EXCEPTION_ERROR;
2754: END IF;
2755: End If;

Line 2752: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2748: p_chr_id => p_chrv_id);
2749:
2750: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2751: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2752: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2753: RAISE Okl_Api.G_EXCEPTION_ERROR;
2754: END IF;
2755: End If;
2756: -------------------------------------------------------------------------

Line 2753: RAISE Okl_Api.G_EXCEPTION_ERROR;

2749:
2750: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2751: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2752: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2753: RAISE Okl_Api.G_EXCEPTION_ERROR;
2754: END IF;
2755: End If;
2756: -------------------------------------------------------------------------
2757: --Bug#i 3143522 : End Subsidies enhancement

Line 2770: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2766: p_chrv_id => p_chrv_id,
2767: p_call_mode => p_call_mode,
2768: x_cimv_tbl => l_cimv_tbl_fa);
2769:
2770: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2771: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2772: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2773: RAISE Okl_Api.G_EXCEPTION_ERROR;
2774: END IF;

Line 2771: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2767: p_call_mode => p_call_mode,
2768: x_cimv_tbl => l_cimv_tbl_fa);
2769:
2770: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2771: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2772: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2773: RAISE Okl_Api.G_EXCEPTION_ERROR;
2774: END IF;
2775:

Line 2772: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2768: x_cimv_tbl => l_cimv_tbl_fa);
2769:
2770: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2771: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2772: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2773: RAISE Okl_Api.G_EXCEPTION_ERROR;
2774: END IF;
2775:
2776: --Bug# 2726870 : 11.5.9 enhancment Service contracts integration

Line 2773: RAISE Okl_Api.G_EXCEPTION_ERROR;

2769:
2770: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2771: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2772: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2773: RAISE Okl_Api.G_EXCEPTION_ERROR;
2774: END IF;
2775:
2776: --Bug# 2726870 : 11.5.9 enhancment Service contracts integration
2777: --call service integration api :

Line 2786: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2782: x_msg_count => x_msg_count,
2783: x_msg_data => x_msg_data,
2784: p_okl_chr_id => p_chrv_id);
2785:
2786: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2787: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2788: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2789: RAISE Okl_Api.G_EXCEPTION_ERROR;
2790: END IF;

Line 2787: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2783: x_msg_data => x_msg_data,
2784: p_okl_chr_id => p_chrv_id);
2785:
2786: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2787: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2788: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2789: RAISE Okl_Api.G_EXCEPTION_ERROR;
2790: END IF;
2791:

Line 2788: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2784: p_okl_chr_id => p_chrv_id);
2785:
2786: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2787: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2788: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2789: RAISE Okl_Api.G_EXCEPTION_ERROR;
2790: END IF;
2791:
2792: --call ib activation API

Line 2789: RAISE Okl_Api.G_EXCEPTION_ERROR;

2785:
2786: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2787: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2788: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2789: RAISE Okl_Api.G_EXCEPTION_ERROR;
2790: END IF;
2791:
2792: --call ib activation API
2793: Okl_Activate_Ib_Pub.ACTIVATE_IB_INSTANCE(p_api_version => p_api_version,

Line 2802: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2798: p_chrv_id => p_chrv_id,
2799: p_call_mode => p_call_mode,
2800: x_cimv_tbl => l_cimv_tbl_ib);
2801:
2802: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2803: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2804: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2805: RAISE Okl_Api.G_EXCEPTION_ERROR;
2806: END IF;

Line 2803: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2799: p_call_mode => p_call_mode,
2800: x_cimv_tbl => l_cimv_tbl_ib);
2801:
2802: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2803: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2804: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2805: RAISE Okl_Api.G_EXCEPTION_ERROR;
2806: END IF;
2807:

Line 2804: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2800: x_cimv_tbl => l_cimv_tbl_ib);
2801:
2802: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2803: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2804: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2805: RAISE Okl_Api.G_EXCEPTION_ERROR;
2806: END IF;
2807:
2808: --check if usage line is there on the contract

Line 2805: RAISE Okl_Api.G_EXCEPTION_ERROR;

2801:
2802: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2803: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2804: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2805: RAISE Okl_Api.G_EXCEPTION_ERROR;
2806: END IF;
2807:
2808: --check if usage line is there on the contract
2809: l_usage_khr := '?';

Line 2829: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

2825: p_chr_id => p_chrv_id,
2826: x_chr_id => l_service_chr_id
2827: );
2828:
2829: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2830: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2831: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2832: RAISE Okl_Api.G_EXCEPTION_ERROR;
2833: END IF;

Line 2830: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2826: x_chr_id => l_service_chr_id
2827: );
2828:
2829: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2830: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2831: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2832: RAISE Okl_Api.G_EXCEPTION_ERROR;
2833: END IF;
2834: End If;

Line 2831: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN

2827: );
2828:
2829: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2830: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2831: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2832: RAISE Okl_Api.G_EXCEPTION_ERROR;
2833: END IF;
2834: End If;
2835:

Line 2832: RAISE Okl_Api.G_EXCEPTION_ERROR;

2828:
2829: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
2830: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2831: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
2832: RAISE Okl_Api.G_EXCEPTION_ERROR;
2833: END IF;
2834: End If;
2835:
2836: END IF;

Line 2851: Okl_Api.END_ACTIVITY (x_msg_count,x_msg_data );

2847: okl_streams_util.update_trx_state(l_contract_id, 'BOTH');
2848:
2849: -- end update of okl_stream_trx_data.last_trx_state value
2850:
2851: Okl_Api.END_ACTIVITY (x_msg_count,x_msg_data );
2852:
2853: EXCEPTION
2854: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2855: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(

Line 2854: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

2850:
2851: Okl_Api.END_ACTIVITY (x_msg_count,x_msg_data );
2852:
2853: EXCEPTION
2854: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2855: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(
2856: l_api_name,
2857: G_PKG_NAME,
2858: 'OKL_API.G_RET_STS_ERROR',

Line 2855: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(

2851: Okl_Api.END_ACTIVITY (x_msg_count,x_msg_data );
2852:
2853: EXCEPTION
2854: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2855: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(
2856: l_api_name,
2857: G_PKG_NAME,
2858: 'OKL_API.G_RET_STS_ERROR',
2859: x_msg_count,

Line 2858: 'OKL_API.G_RET_STS_ERROR',

2854: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
2855: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(
2856: l_api_name,
2857: G_PKG_NAME,
2858: 'OKL_API.G_RET_STS_ERROR',
2859: x_msg_count,
2860: x_msg_data,
2861: '_PUB');
2862: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2862: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2858: 'OKL_API.G_RET_STS_ERROR',
2859: x_msg_count,
2860: x_msg_data,
2861: '_PUB');
2862: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2863: --dbms_output.put_line('Unexpected Error Routine');
2864: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS(
2865: l_api_name,
2866: G_PKG_NAME,

Line 2864: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS(

2860: x_msg_data,
2861: '_PUB');
2862: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2863: --dbms_output.put_line('Unexpected Error Routine');
2864: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS(
2865: l_api_name,
2866: G_PKG_NAME,
2867: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
2868: x_msg_count,

Line 2867: 'Okl_Api.G_RET_STS_UNEXP_ERROR',

2863: --dbms_output.put_line('Unexpected Error Routine');
2864: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS(
2865: l_api_name,
2866: G_PKG_NAME,
2867: 'Okl_Api.G_RET_STS_UNEXP_ERROR',
2868: x_msg_count,
2869: x_msg_data,
2870: '_PUB');
2871: --dbms_output.put_line('2 Unexpected Error Routine');

Line 2873: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS(

2869: x_msg_data,
2870: '_PUB');
2871: --dbms_output.put_line('2 Unexpected Error Routine');
2872: WHEN OTHERS THEN
2873: x_return_status :=Okl_Api.HANDLE_EXCEPTIONS(
2874: l_api_name,
2875: G_PKG_NAME,
2876: 'OTHERS',
2877: x_msg_count,