eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_CREATE_KLE_PVT dependencies on OKC_API

Line 150: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

146: WHEN OTHERS THEN
147: IF c_check_dup_serial_num%ISOPEN THEN
148: CLOSE c_check_dup_serial_num;
149: END IF;
150: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
151: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
152: p_msg_name => g_unexpected_error,
153: p_token1 => g_sqlcode_token,
154: p_token1_value => sqlcode,

Line 171: x_return_status := OKC_API.G_RET_STS_ERROR;

167: BEGIN
168: OPEN c_instance_no_ib;
169: FETCH c_instance_no_ib INTO x_instance_number_ib;
170: IF (c_instance_no_ib%NOTFOUND) Then
171: x_return_status := OKC_API.G_RET_STS_ERROR;
172: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
173: p_msg_name => g_unexpected_error,
174: p_token1 => g_sqlcode_token,
175: p_token1_value => sqlcode,

Line 186: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

182: WHEN OTHERS THEN
183: IF c_instance_no_ib%ISOPEN THEN
184: CLOSE c_instance_no_ib;
185: END IF;
186: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
187: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
188: p_msg_name => g_unexpected_error,
189: p_token1 => g_sqlcode_token,
190: p_token1_value => sqlcode,

Line 247: x_return_status := OKC_API.G_RET_STS_ERROR;

243: BEGIN
244: OPEN c_asset_no;
245: FETCH c_asset_no INTO x_asset_number;
246: IF (c_asset_no%NOTFOUND) THEN
247: x_return_status := OKC_API.G_RET_STS_ERROR;
248: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
249: p_msg_name => g_unexpected_error,
250: p_token1 => g_sqlcode_token,
251: p_token1_value => sqlcode,

Line 287: x_return_status := OKC_API.G_RET_STS_ERROR;

283: ln_dummy3 = 1 THEN
284: OPEN c_asset_no;
285: FETCH c_asset_no INTO x_asset_number;
286: IF (c_asset_no%NOTFOUND) THEN
287: x_return_status := OKC_API.G_RET_STS_ERROR;
288: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
289: p_msg_name => g_unexpected_error,
290: p_token1 => g_sqlcode_token,
291: p_token1_value => sqlcode,

Line 316: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

312: END IF;
313: IF c_okx_assets_v%ISOPEN THEN
314: CLOSE c_okx_assets_v;
315: END IF;
316: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
317: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
318: p_msg_name => g_unexpected_error,
319: p_token1 => g_sqlcode_token,
320: p_token1_value => sqlcode,

Line 10310: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

10306: -------------------------------------------------------------------------------------------------------
10307: ---------------------------- Main Process for Creation of Add on Line ---------------------------------
10308: -------------------------------------------------------------------------------------------------------
10309: PROCEDURE create_add_on_line(p_api_version IN NUMBER,
10310: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
10311: x_return_status OUT NOCOPY VARCHAR2,
10312: x_msg_count OUT NOCOPY NUMBER,
10313: x_msg_data OUT NOCOPY VARCHAR2,
10314: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

Line 10595: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

10591: ---------------------------- Main Process for Update of Add on Line ---------------------------------
10592: -------------------------------------------------------------------------------------------------------
10593: PROCEDURE update_add_on_line(
10594: p_api_version IN NUMBER,
10595: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
10596: x_return_status OUT NOCOPY VARCHAR2,
10597: x_msg_count OUT NOCOPY NUMBER,
10598: x_msg_data OUT NOCOPY VARCHAR2,
10599: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

Line 10849: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

10845: ---------------------------- Main Process for Delete of Add on Line -----------------------------------
10846: -------------------------------------------------------------------------------------------------------
10847: PROCEDURE delete_add_on_line(
10848: p_api_version IN NUMBER,
10849: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
10850: x_return_status OUT NOCOPY VARCHAR2,
10851: x_msg_count OUT NOCOPY NUMBER,
10852: x_msg_data OUT NOCOPY VARCHAR2,
10853: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

Line 11653: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

11649: ------------------------ Main Process for Create Party Roles-----------------------------------
11650: -----------------------------------------------------------------------------------------------
11651: PROCEDURE Create_party_roles_rec(
11652: p_api_version IN NUMBER,
11653: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
11654: x_return_status OUT NOCOPY VARCHAR2,
11655: x_msg_count OUT NOCOPY NUMBER,
11656: x_msg_data OUT NOCOPY VARCHAR2,
11657: p_cplv_rec IN cplv_rec_type,

Line 11854: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

11850: ------------------------ Main Process for Update Party Roles-----------------------------------
11851: -----------------------------------------------------------------------------------------------
11852: PROCEDURE Update_party_roles_rec(
11853: p_api_version IN NUMBER,
11854: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
11855: x_return_status OUT NOCOPY VARCHAR2,
11856: x_msg_count OUT NOCOPY NUMBER,
11857: x_msg_data OUT NOCOPY VARCHAR2,
11858: p_cplv_rec IN cplv_rec_type,

Line 12119: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

12115: p_api_version => p_api_version,
12116: p_api_type => '_PVT',
12117: x_return_status => x_return_status);
12118: -- Check if activity started successfully
12119: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
12120: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
12121: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
12122: RAISE Okc_Api.G_EXCEPTION_ERROR;
12123: END IF;

Line 12120: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

12116: p_api_type => '_PVT',
12117: x_return_status => x_return_status);
12118: -- Check if activity started successfully
12119: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
12120: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
12121: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
12122: RAISE Okc_Api.G_EXCEPTION_ERROR;
12123: END IF;
12124:

Line 12122: RAISE Okc_Api.G_EXCEPTION_ERROR;

12118: -- Check if activity started successfully
12119: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
12120: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
12121: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
12122: RAISE Okc_Api.G_EXCEPTION_ERROR;
12123: END IF;
12124:
12125: --check with cursor
12126: l_off_lease_trx_exists := 'N';

Line 12430: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

12426: --Bug# 3533936 : Process for release Assets
12427: -------------------------------------------
12428: PROCEDURE Create_release_asset_line
12429: (p_api_version IN NUMBER,
12430: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
12431: x_return_status OUT NOCOPY VARCHAR2,
12432: x_msg_count OUT NOCOPY NUMBER,
12433: x_msg_data OUT NOCOPY VARCHAR2,
12434: p_asset_id IN VARCHAR2,

Line 12766: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

12762: p_api_version => p_api_version,
12763: p_api_type => '_PVT',
12764: x_return_status => x_return_status);
12765: -- Check if activity started successfully
12766: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
12767: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
12768: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
12769: RAISE Okc_Api.G_EXCEPTION_ERROR;
12770: END IF;

Line 12767: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

12763: p_api_type => '_PVT',
12764: x_return_status => x_return_status);
12765: -- Check if activity started successfully
12766: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
12767: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
12768: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
12769: RAISE Okc_Api.G_EXCEPTION_ERROR;
12770: END IF;
12771:

Line 12769: RAISE Okc_Api.G_EXCEPTION_ERROR;

12765: -- Check if activity started successfully
12766: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
12767: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
12768: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
12769: RAISE Okc_Api.G_EXCEPTION_ERROR;
12770: END IF;
12771:
12772: --------------------------------
12773: --Bug# 3783518 : Check if it is a rebook. New asset should not be added on rebook of a rlease asset contract

Line 12787: x_return_status := OKC_API.G_RET_STS_ERROR;

12783: If l_rbk_yn = 'Y' then
12784: OKL_API.set_message(
12785: p_app_name => G_APP_NAME,
12786: p_msg_name => 'OKL_REL_ASSET_RBK_NEW_AST_ADD');
12787: x_return_status := OKC_API.G_RET_STS_ERROR;
12788: RAISE OKL_API.G_EXCEPTION_ERROR;
12789:
12790: End If;
12791: ------------------

Line 12814: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

12810: x_msg_count => x_msg_count,
12811: x_msg_data => x_msg_data,
12812: p_asset_id => p_asset_id,
12813: x_pending_trx_yn => l_pending_trx_yn);
12814: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
12815: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
12816: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
12817: RAISE Okc_Api.G_EXCEPTION_ERROR;
12818: END IF;

Line 12815: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

12811: x_msg_data => x_msg_data,
12812: p_asset_id => p_asset_id,
12813: x_pending_trx_yn => l_pending_trx_yn);
12814: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
12815: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
12816: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
12817: RAISE Okc_Api.G_EXCEPTION_ERROR;
12818: END IF;
12819:

Line 12817: RAISE Okc_Api.G_EXCEPTION_ERROR;

12813: x_pending_trx_yn => l_pending_trx_yn);
12814: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
12815: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
12816: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
12817: RAISE Okc_Api.G_EXCEPTION_ERROR;
12818: END IF;
12819:
12820: If l_pending_trx_yn = 'Y' then
12821:

Line 12834: x_return_status := OKC_API.G_RET_STS_ERROR;

12830: p_app_name => G_APP_NAME,
12831: p_msg_name => 'OKL_LA_OFF_LEASE_TRX',
12832: p_token1 => 'ASSET_NUMBER',
12833: p_token1_value => l_asset_number);
12834: x_return_status := OKC_API.G_RET_STS_ERROR;
12835: RAISE OKL_API.G_EXCEPTION_ERROR;
12836:
12837: End If;
12838:

Line 12880: RAISE Okl_Api.G_EXCEPTION_ERROR; -- rmunjulu bug 6805958 changed to OKL_API from OKC_API

12876: p_token2 => 'ASSET_NUMBER',
12877: p_token2_value => l_asset_number,
12878: p_token3 => 'CONTRACT_START_DATE',
12879: p_token3_value => l_k_start_date);
12880: RAISE Okl_Api.G_EXCEPTION_ERROR; -- rmunjulu bug 6805958 changed to OKL_API from OKC_API
12881: End If;
12882:
12883: --Bug# 6328924
12884: If (l_hdr_rec.legal_entity_id <> l_orig_ast_rec.legal_entity_id) then

Line 13201: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

13197: x_msg_data => x_msg_data,
13198: p_talv_rec => l_talv_rec,
13199: x_talv_rec => lx_talv_rec);
13200:
13201: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13202: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13203: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13204: RAISE Okc_Api.G_EXCEPTION_ERROR;
13205: END IF;

Line 13202: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

13198: p_talv_rec => l_talv_rec,
13199: x_talv_rec => lx_talv_rec);
13200:
13201: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13202: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13203: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13204: RAISE Okc_Api.G_EXCEPTION_ERROR;
13205: END IF;
13206: END IF;

Line 13204: RAISE Okc_Api.G_EXCEPTION_ERROR;

13200:
13201: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13202: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13203: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13204: RAISE Okc_Api.G_EXCEPTION_ERROR;
13205: END IF;
13206: END IF;
13207: --BUG# :END 3569441
13208:

Line 13342: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

13338: x_msg_data => x_msg_data,
13339: p_adpv_rec => l_txdv_rec,
13340: x_adpv_rec => lx_txdv_rec);
13341:
13342: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13343: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13344: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13345: RAISE Okc_Api.G_EXCEPTION_ERROR;
13346: END IF;

Line 13343: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

13339: p_adpv_rec => l_txdv_rec,
13340: x_adpv_rec => lx_txdv_rec);
13341:
13342: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13343: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13344: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13345: RAISE Okc_Api.G_EXCEPTION_ERROR;
13346: END IF;
13347: END IF;

Line 13345: RAISE Okc_Api.G_EXCEPTION_ERROR;

13341:
13342: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13343: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13344: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13345: RAISE Okc_Api.G_EXCEPTION_ERROR;
13346: END IF;
13347: END IF;
13348: End Loop;
13349: Close l_taxbook_csr;

Line 13375: OKC_API.set_message(

13371: Open town_rul_csr(pchrid => p_chr_id);
13372: Fetch town_rul_csr into l_town_rul,
13373: l_town_rul_id;
13374: If town_rul_csr%NOTFOUND Then
13375: OKC_API.set_message(
13376: p_app_name => G_APP_NAME,
13377: p_msg_name => G_REQUIRED_VALUE,
13378: p_token1 => G_COL_NAME_TOKEN,
13379: p_token1_value => 'Tax Owner');

Line 13380: x_return_status := OKC_API.G_RET_STS_ERROR;

13376: p_app_name => G_APP_NAME,
13377: p_msg_name => G_REQUIRED_VALUE,
13378: p_token1 => G_COL_NAME_TOKEN,
13379: p_token1_value => 'Tax Owner');
13380: x_return_status := OKC_API.G_RET_STS_ERROR;
13381: RAISE OKL_API.G_EXCEPTION_ERROR;
13382: Else
13383: l_tax_owner := rtrim(ltrim(l_town_rul,' '),' ');
13384: End If;

Line 13492: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

13488: x_msg_data => x_msg_data,
13489: p_adpv_rec => l_mg_txdv_rec,
13490: x_adpv_rec => lx_mg_txdv_rec);
13491:
13492: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13493: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13494: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13495: RAISE Okc_Api.G_EXCEPTION_ERROR;
13496: END IF;

Line 13493: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

13489: p_adpv_rec => l_mg_txdv_rec,
13490: x_adpv_rec => lx_mg_txdv_rec);
13491:
13492: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13493: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13494: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13495: RAISE Okc_Api.G_EXCEPTION_ERROR;
13496: END IF;
13497: End If; -- if multi gaap asset book is not doen

Line 13495: RAISE Okc_Api.G_EXCEPTION_ERROR;

13491:
13492: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13493: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13494: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13495: RAISE Okc_Api.G_EXCEPTION_ERROR;
13496: END IF;
13497: End If; -- if multi gaap asset book is not doen
13498: End If; --If l_mutigaap_yn
13499: x_cle_id:= l_new_finasst_id;

Line 13538: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

13534: --called from release asset line
13535: ---------------------------------------------------------
13536: PROCEDURE copy_updated_asset_components
13537: (p_api_version IN NUMBER,
13538: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
13539: x_return_status OUT NOCOPY VARCHAR2,
13540: x_msg_count OUT NOCOPY NUMBER,
13541: x_msg_data OUT NOCOPY VARCHAR2,
13542: p_cle_id IN NUMBER,

Line 13707: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

13703: p_api_version => p_api_version,
13704: p_api_type => '_PVT',
13705: x_return_status => x_return_status);
13706: -- Check if activity started successfully
13707: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13708: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13709: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13710: RAISE Okc_Api.G_EXCEPTION_ERROR;
13711: END IF;

Line 13708: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

13704: p_api_type => '_PVT',
13705: x_return_status => x_return_status);
13706: -- Check if activity started successfully
13707: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13708: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13709: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13710: RAISE Okc_Api.G_EXCEPTION_ERROR;
13711: END IF;
13712:

Line 13710: RAISE Okc_Api.G_EXCEPTION_ERROR;

13706: -- Check if activity started successfully
13707: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13708: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13709: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13710: RAISE Okc_Api.G_EXCEPTION_ERROR;
13711: END IF;
13712:
13713: --1. Copy rules from old line to new line
13714: open l_rgp_csr(p_orig_cle_id => p_orig_cle_id,

Line 13729: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

13725: p_rgp_id => l_rgp_id,
13726: p_cle_id => p_cle_id,
13727: p_to_template_yn => 'N',
13728: x_rgp_id => lx_rgp_id);
13729: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13730: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13731: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13732: RAISE Okc_Api.G_EXCEPTION_ERROR;
13733: END IF;

Line 13730: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

13726: p_cle_id => p_cle_id,
13727: p_to_template_yn => 'N',
13728: x_rgp_id => lx_rgp_id);
13729: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13730: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13731: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13732: RAISE Okc_Api.G_EXCEPTION_ERROR;
13733: END IF;
13734: End Loop;

Line 13732: RAISE Okc_Api.G_EXCEPTION_ERROR;

13728: x_rgp_id => lx_rgp_id);
13729: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13730: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13731: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13732: RAISE Okc_Api.G_EXCEPTION_ERROR;
13733: END IF;
13734: End Loop;
13735: close l_rgp_csr;
13736:

Line 13753: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

13749: p_cpl_id => l_cpl_rec.id,
13750: p_cle_id => p_cle_id,
13751: p_rle_code => l_cpl_rec.rle_code,
13752: x_cpl_id => lx_cpl_id);
13753: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13754: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13755: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13756: RAISE Okc_Api.G_EXCEPTION_ERROR;
13757: END IF;

Line 13754: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

13750: p_cle_id => p_cle_id,
13751: p_rle_code => l_cpl_rec.rle_code,
13752: x_cpl_id => lx_cpl_id);
13753: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13754: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13755: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13756: RAISE Okc_Api.G_EXCEPTION_ERROR;
13757: END IF;
13758: End Loop;

Line 13756: RAISE Okc_Api.G_EXCEPTION_ERROR;

13752: x_cpl_id => lx_cpl_id);
13753: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13754: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13755: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13756: RAISE Okc_Api.G_EXCEPTION_ERROR;
13757: END IF;
13758: End Loop;
13759: close l_cpl_csr;
13760:

Line 13777: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

13773: x_msg_count => x_msg_count,
13774: x_msg_data => x_msg_data,
13775: p_cimv_rec => l_cimv_rec,
13776: x_cimv_rec => lx_cimv_rec);
13777: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13778: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13779: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13780: RAISE Okc_Api.G_EXCEPTION_ERROR;
13781: END IF;

Line 13778: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

13774: x_msg_data => x_msg_data,
13775: p_cimv_rec => l_cimv_rec,
13776: x_cimv_rec => lx_cimv_rec);
13777: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13778: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13779: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13780: RAISE Okc_Api.G_EXCEPTION_ERROR;
13781: END IF;
13782: End Loop;

Line 13780: RAISE Okc_Api.G_EXCEPTION_ERROR;

13776: x_cimv_rec => lx_cimv_rec);
13777: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13778: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13779: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13780: RAISE Okc_Api.G_EXCEPTION_ERROR;
13781: END IF;
13782: End Loop;
13783: Close l_lnk_ast_csr;
13784:

Line 13803: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

13799: x_msg_count => x_msg_count,
13800: x_msg_data => x_msg_data,
13801: p_rulv_rec => l_rulv_rec,
13802: x_rulv_rec => lx_rulv_rec);
13803: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13804: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13805: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13806: RAISE Okc_Api.G_EXCEPTION_ERROR;
13807: END IF;

Line 13804: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

13800: x_msg_data => x_msg_data,
13801: p_rulv_rec => l_rulv_rec,
13802: x_rulv_rec => lx_rulv_rec);
13803: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13804: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13805: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13806: RAISE Okc_Api.G_EXCEPTION_ERROR;
13807: END IF;
13808: End Loop;

Line 13806: RAISE Okc_Api.G_EXCEPTION_ERROR;

13802: x_rulv_rec => lx_rulv_rec);
13803: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13804: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13805: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13806: RAISE Okc_Api.G_EXCEPTION_ERROR;
13807: END IF;
13808: End Loop;
13809: Close l_slh_csr;
13810:

Line 13835: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

13831: x_msg_count => x_msg_count,
13832: x_msg_data => x_msg_data,
13833: p_asb_rec => l_asb_rec,
13834: x_asb_rec => lx_asb_rec);
13835: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13836: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13837: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13838: RAISE Okc_Api.G_EXCEPTION_ERROR;
13839: END IF;

Line 13836: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

13832: x_msg_data => x_msg_data,
13833: p_asb_rec => l_asb_rec,
13834: x_asb_rec => lx_asb_rec);
13835: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13836: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13837: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13838: RAISE Okc_Api.G_EXCEPTION_ERROR;
13839: END IF;
13840:

Line 13838: RAISE Okc_Api.G_EXCEPTION_ERROR;

13834: x_asb_rec => lx_asb_rec);
13835: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13836: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13837: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13838: RAISE Okc_Api.G_EXCEPTION_ERROR;
13839: END IF;
13840:
13841: --update link to party payment details
13842: Open l_subrfnd_csr(p_cpl_id => l_subsidy_rec.cpl_id);

Line 13857: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

13853: x_msg_count => x_msg_count,
13854: x_msg_data => x_msg_data,
13855: p_srfvv_rec => l_srfvv_rec,
13856: x_srfvv_rec => lx_srfvv_rec);
13857: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13858: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13859: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13860: RAISE Okc_Api.G_EXCEPTION_ERROR;
13861: END IF;

Line 13858: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

13854: x_msg_data => x_msg_data,
13855: p_srfvv_rec => l_srfvv_rec,
13856: x_srfvv_rec => lx_srfvv_rec);
13857: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13858: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13859: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13860: RAISE Okc_Api.G_EXCEPTION_ERROR;
13861: END IF;
13862: End If;

Line 13860: RAISE Okc_Api.G_EXCEPTION_ERROR;

13856: x_srfvv_rec => lx_srfvv_rec);
13857: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13858: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13859: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13860: RAISE Okc_Api.G_EXCEPTION_ERROR;
13861: END IF;
13862: End If;
13863: Close l_subrfnd_csr;
13864: End Loop;

Line 13905: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

13901: -----------------------------------------------------
13902:
13903: PROCEDURE update_release_asset_line
13904: (p_api_version IN NUMBER,
13905: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
13906: x_return_status OUT NOCOPY VARCHAR2,
13907: x_msg_count OUT NOCOPY NUMBER,
13908: x_msg_data OUT NOCOPY VARCHAR2,
13909: p_asset_id IN VARCHAR2,

Line 13985: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

13981: p_api_version => p_api_version,
13982: p_api_type => '_PVT',
13983: x_return_status => x_return_status);
13984: -- Check if activity started successfully
13985: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13986: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13987: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13988: RAISE Okc_Api.G_EXCEPTION_ERROR;
13989: END IF;

Line 13986: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

13982: p_api_type => '_PVT',
13983: x_return_status => x_return_status);
13984: -- Check if activity started successfully
13985: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13986: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13987: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13988: RAISE Okc_Api.G_EXCEPTION_ERROR;
13989: END IF;
13990:

Line 13988: RAISE Okc_Api.G_EXCEPTION_ERROR;

13984: -- Check if activity started successfully
13985: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
13986: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
13987: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
13988: RAISE Okc_Api.G_EXCEPTION_ERROR;
13989: END IF;
13990:
13991: --------------------
13992: --Bug# 3783518

Line 14008: x_return_status := OKC_API.G_RET_STS_ERROR;

14004: --raise error : can not add new asset on a rebook
14005: OKL_API.set_message(
14006: p_app_name => G_APP_NAME,
14007: p_msg_name => 'OKL_REL_ASSET_RBK_NEW_AST_ADD');
14008: x_return_status := OKC_API.G_RET_STS_ERROR;
14009: RAISE OKL_API.G_EXCEPTION_ERROR;
14010: ElsIf l_rbk_ast_change_yn = 'N' then
14011: x_cle_id := p_clev_fin_id;
14012:

Line 14027: RAISE Okc_Api.G_EXCEPTION_ERROR;

14023: If l_cim_fa_csr%NOTFOUND then
14024: --raise error : invalid line information
14025: OKL_API.set_message(p_app_name => G_APP_NAME,
14026: p_msg_name => 'OKL_LLA_LINE_RECORD');
14027: RAISE Okc_Api.G_EXCEPTION_ERROR;
14028: End If;
14029: close l_cim_fa_csr;
14030: If nvl(p_asset_id,OKL_API.G_MISS_CHAR) = nvl(l_asset_id,OKL_API.G_MISS_CHAR) then
14031: x_cle_id := p_clev_fin_id;

Line 14131: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

14127: --asset line
14128: --------------------------------------------------------
14129: PROCEDURE Resolve_Residual_Value(
14130: p_api_version IN NUMBER,
14131: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
14132: x_return_status OUT NOCOPY VARCHAR2,
14133: x_msg_count OUT NOCOPY NUMBER,
14134: x_msg_data OUT NOCOPY VARCHAR2,
14135: p_asset_number IN VARCHAR2,

Line 14189: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

14185: p_api_version => p_api_version,
14186: p_api_type => '_PVT',
14187: x_return_status => x_return_status);
14188: -- Check if activity started successfully
14189: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14190: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14191: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14192: RAISE Okc_Api.G_EXCEPTION_ERROR;
14193: END IF;

Line 14190: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

14186: p_api_type => '_PVT',
14187: x_return_status => x_return_status);
14188: -- Check if activity started successfully
14189: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14190: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14191: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14192: RAISE Okc_Api.G_EXCEPTION_ERROR;
14193: END IF;
14194:

Line 14192: RAISE Okc_Api.G_EXCEPTION_ERROR;

14188: -- Check if activity started successfully
14189: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14190: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14191: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14192: RAISE Okc_Api.G_EXCEPTION_ERROR;
14193: END IF;
14194:
14195: --Bug# 4631549
14196: If nvl(p_call_mode,okl_api.g_miss_char) = 'RELEASE_CONTRACT' then

Line 14209: RAISE Okc_Api.G_EXCEPTION_ERROR;

14205: If l_modelline_csr%NOTFOUND then
14206: --raise errorr: invliad line information
14207: OKL_API.set_message(p_app_name => G_APP_NAME,
14208: p_msg_name => 'OKL_LLA_LINE_RECORD');
14209: RAISE Okc_Api.G_EXCEPTION_ERROR;
14210: End If;
14211: Close l_modelline_csr;
14212:
14213: IF (p_klev_fin_rec.residual_percentage IS NOT NULL OR

Line 14370: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

14366: --provided for modifiable columns during Release
14367: ----------------------------------------------------
14368: PROCEDURE Modify_Release_Asset_Line(
14369: p_api_version IN NUMBER,
14370: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
14371: x_return_status OUT NOCOPY VARCHAR2,
14372: x_msg_count OUT NOCOPY NUMBER,
14373: x_msg_data OUT NOCOPY VARCHAR2,
14374: p_clev_fin_rec IN clev_rec_type,

Line 14564: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

14560: p_api_version => p_api_version,
14561: p_api_type => '_PVT',
14562: x_return_status => x_return_status);
14563: -- Check if activity started successfully
14564: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14565: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14566: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14567: RAISE Okc_Api.G_EXCEPTION_ERROR;
14568: END IF;

Line 14565: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

14561: p_api_type => '_PVT',
14562: x_return_status => x_return_status);
14563: -- Check if activity started successfully
14564: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14565: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14566: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14567: RAISE Okc_Api.G_EXCEPTION_ERROR;
14568: END IF;
14569: -- akrangan Bug# 5362977 start

Line 14567: RAISE Okc_Api.G_EXCEPTION_ERROR;

14563: -- Check if activity started successfully
14564: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14565: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14566: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14567: RAISE Okc_Api.G_EXCEPTION_ERROR;
14568: END IF;
14569: -- akrangan Bug# 5362977 start
14570: l_rbk_khr := '?';
14571: OPEN l_chk_rbk_csr (p_chr_id => p_clev_fin_rec.dnz_chr_id);

Line 14648: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

14644: p_klev_tbl => l_klev_price_tbl,
14645: x_clev_tbl => lx_clev_price_tbl,
14646: x_klev_tbl => lx_klev_price_tbl);
14647:
14648: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14649: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14650: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14651: RAISE Okc_Api.G_EXCEPTION_ERROR;
14652: END IF;

Line 14649: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

14645: x_clev_tbl => lx_clev_price_tbl,
14646: x_klev_tbl => lx_klev_price_tbl);
14647:
14648: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14649: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14650: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14651: RAISE Okc_Api.G_EXCEPTION_ERROR;
14652: END IF;
14653:

Line 14651: RAISE Okc_Api.G_EXCEPTION_ERROR;

14647:
14648: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14649: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14650: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14651: RAISE Okc_Api.G_EXCEPTION_ERROR;
14652: END IF;
14653:
14654: --Bug# 4631549
14655: If nvl(p_call_mode,okl_api.g_miss_char) = 'RELEASE_ASSET' then

Line 14705: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

14701: p_klev_rec => l_klev_fin_rec,
14702: x_clev_rec => l_rel_ast_clev_fin_rec,
14703: x_klev_rec => l_rel_ast_klev_fin_rec);
14704:
14705: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14706: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14707: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14708: RAISE Okc_Api.G_EXCEPTION_ERROR;
14709: END IF;

Line 14706: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

14702: x_clev_rec => l_rel_ast_clev_fin_rec,
14703: x_klev_rec => l_rel_ast_klev_fin_rec);
14704:
14705: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14706: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14707: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14708: RAISE Okc_Api.G_EXCEPTION_ERROR;
14709: END IF;
14710: --Bug#5601721 -- end

Line 14708: RAISE Okc_Api.G_EXCEPTION_ERROR;

14704:
14705: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14706: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14707: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14708: RAISE Okc_Api.G_EXCEPTION_ERROR;
14709: END IF;
14710: --Bug#5601721 -- end
14711:
14712: --Bug# 4631549

Line 14753: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

14749: p_klev_rec => l_klev_fin_rec,
14750: x_clev_rec => l_rel_ast_clev_fin_rec,
14751: x_klev_rec => l_rel_ast_klev_fin_rec);
14752:
14753: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14754: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14755: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14756: RAISE Okc_Api.G_EXCEPTION_ERROR;
14757: END IF;

Line 14754: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

14750: x_clev_rec => l_rel_ast_clev_fin_rec,
14751: x_klev_rec => l_rel_ast_klev_fin_rec);
14752:
14753: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14754: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14755: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14756: RAISE Okc_Api.G_EXCEPTION_ERROR;
14757: END IF;
14758: -- akrangan Bug# 5362977 start

Line 14756: RAISE Okc_Api.G_EXCEPTION_ERROR;

14752:
14753: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14754: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14755: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14756: RAISE Okc_Api.G_EXCEPTION_ERROR;
14757: END IF;
14758: -- akrangan Bug# 5362977 start
14759: IF l_rbk_khr = '!' THEN
14760: l_clev_fa_rec.id := p_clev_fa_rec.id;

Line 14776: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

14772: p_klev_rec => l_klev_fa_rec,
14773: x_clev_rec => lx_clev_fa_rec,
14774: x_klev_rec => lx_klev_fa_rec);
14775:
14776: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14777: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14778: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14779: RAISE Okc_Api.G_EXCEPTION_ERROR;
14780: END IF;

Line 14777: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

14773: x_clev_rec => lx_clev_fa_rec,
14774: x_klev_rec => lx_klev_fa_rec);
14775:
14776: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14777: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14778: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14779: RAISE Okc_Api.G_EXCEPTION_ERROR;
14780: END IF;
14781:

Line 14779: RAISE Okc_Api.G_EXCEPTION_ERROR;

14775:
14776: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14777: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14778: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14779: RAISE Okc_Api.G_EXCEPTION_ERROR;
14780: END IF;
14781:
14782: x_return_status := get_rec_cimv(p_clev_model_rec.id,
14783: p_clev_fin_rec.dnz_chr_id,

Line 14810: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

14806: x_msg_data => x_msg_data,
14807: p_cimv_rec => l_cimv_model_rec,
14808: x_cimv_rec => x_cimv_model_rec);
14809:
14810: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14811: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14812: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14813: RAISE Okc_Api.G_EXCEPTION_ERROR;
14814: END IF;

Line 14811: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

14807: p_cimv_rec => l_cimv_model_rec,
14808: x_cimv_rec => x_cimv_model_rec);
14809:
14810: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14811: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14812: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14813: RAISE Okc_Api.G_EXCEPTION_ERROR;
14814: END IF;
14815:

Line 14813: RAISE Okc_Api.G_EXCEPTION_ERROR;

14809:
14810: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14811: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14812: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14813: RAISE Okc_Api.G_EXCEPTION_ERROR;
14814: END IF;
14815:
14816: END IF;
14817: --akrangan Bug# 5362977 end

Line 14828: RAISE Okc_Api.G_EXCEPTION_ERROR;

14824: If l_fa_csr%NOTFOUND then
14825: --raise error:invalid line information
14826: OKL_API.set_message(p_app_name => G_APP_NAME,
14827: p_msg_name => 'OKL_LLA_LINE_RECORD');
14828: RAISE Okc_Api.G_EXCEPTION_ERROR;
14829: End If;
14830: close l_fa_csr;
14831:
14832: l_talv_fa_rec.id := l_fa_rec.id;

Line 14856: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

14852: x_msg_data => x_msg_data,
14853: p_talv_rec => l_talv_fa_rec,
14854: x_talv_rec => l_rel_ast_talv_rec);
14855:
14856: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14857: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14858: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14859: RAISE Okc_Api.G_EXCEPTION_ERROR;
14860: END IF;

Line 14857: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

14853: p_talv_rec => l_talv_fa_rec,
14854: x_talv_rec => l_rel_ast_talv_rec);
14855:
14856: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14857: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14858: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14859: RAISE Okc_Api.G_EXCEPTION_ERROR;
14860: END IF;
14861:

Line 14859: RAISE Okc_Api.G_EXCEPTION_ERROR;

14855:
14856: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14857: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14858: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14859: RAISE Okc_Api.G_EXCEPTION_ERROR;
14860: END IF;
14861:
14862: --3. update modifiable parameters on IB transaction line
14863: i := 0;

Line 14909: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

14905: x_msg_data => x_msg_data,
14906: p_iipv_tbl => l_itiv_ib_tbl,
14907: x_iipv_tbl => l_rel_ast_itiv_ib_tbl);
14908:
14909: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14910: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14911: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14912: RAISE Okc_Api.G_EXCEPTION_ERROR;
14913: END IF;

Line 14910: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

14906: p_iipv_tbl => l_itiv_ib_tbl,
14907: x_iipv_tbl => l_rel_ast_itiv_ib_tbl);
14908:
14909: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14910: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14911: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14912: RAISE Okc_Api.G_EXCEPTION_ERROR;
14913: END IF;
14914: End If;

Line 14912: RAISE Okc_Api.G_EXCEPTION_ERROR;

14908:
14909: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14910: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14911: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14912: RAISE Okc_Api.G_EXCEPTION_ERROR;
14913: END IF;
14914: End If;
14915:
14916: --------------------------------------------------

Line 14933: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

14929: p_call_mode => p_call_mode,
14930: x_clev_fin_rec => x_clev_fin_rec,
14931: x_klev_fin_rec => x_klev_fin_rec);
14932:
14933: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14934: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14935: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14936: RAISE Okc_Api.G_EXCEPTION_ERROR;
14937: END IF;

Line 14934: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

14930: x_clev_fin_rec => x_clev_fin_rec,
14931: x_klev_fin_rec => x_klev_fin_rec);
14932:
14933: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14934: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14935: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14936: RAISE Okc_Api.G_EXCEPTION_ERROR;
14937: END IF;
14938:

Line 14936: RAISE Okc_Api.G_EXCEPTION_ERROR;

14932:
14933: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
14934: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14935: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
14936: RAISE Okc_Api.G_EXCEPTION_ERROR;
14937: END IF;
14938:
14939: -------------------------------------------
14940: --Get all the lines

Line 14954: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

14950: OKL_API.set_message(p_app_name => G_APP_NAME,
14951: p_msg_name => G_FETCHING_INFO,
14952: p_token1 => G_REC_NAME_TOKEN,
14953: p_token1_value => 'OKC_K_LINES_V Record');
14954: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14955: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
14956: OKL_API.set_message(p_app_name => G_APP_NAME,
14957: p_msg_name => G_FETCHING_INFO,
14958: p_token1 => G_REC_NAME_TOKEN,

Line 14960: RAISE Okc_Api.G_EXCEPTION_ERROR;

14956: OKL_API.set_message(p_app_name => G_APP_NAME,
14957: p_msg_name => G_FETCHING_INFO,
14958: p_token1 => G_REC_NAME_TOKEN,
14959: p_token1_value => 'OKC_K_LINES_V Record');
14960: RAISE Okc_Api.G_EXCEPTION_ERROR;
14961: END IF;
14962: x_return_status := get_rec_klev(l_lines_rec.id,
14963: lx_klev_rec);
14964: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 14969: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

14965: OKL_API.set_message(p_app_name => G_APP_NAME,
14966: p_msg_name => G_FETCHING_INFO,
14967: p_token1 => G_REC_NAME_TOKEN,
14968: p_token1_value => 'OKL_K_LINES_V Record');
14969: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
14970: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
14971: OKL_API.set_message(p_app_name => G_APP_NAME,
14972: p_msg_name => G_FETCHING_INFO,
14973: p_token1 => G_REC_NAME_TOKEN,

Line 14975: RAISE Okc_Api.G_EXCEPTION_ERROR;

14971: OKL_API.set_message(p_app_name => G_APP_NAME,
14972: p_msg_name => G_FETCHING_INFO,
14973: p_token1 => G_REC_NAME_TOKEN,
14974: p_token1_value => 'OKL_K_LINES_V Record');
14975: RAISE Okc_Api.G_EXCEPTION_ERROR;
14976: END IF;
14977:
14978: Open l_lty_csr(p_lse_id => l_lines_rec.lse_id);
14979: Fetch l_lty_csr into l_lty_code;

Line 15032: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

15028: --------------------- Main Process for All Lines Line Creation---------------------------------
15029: -----------------------------------------------------------------------------------------------
15030: PROCEDURE Create_all_line(
15031: p_api_version IN NUMBER,
15032: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
15033: x_return_status OUT NOCOPY VARCHAR2,
15034: x_msg_count OUT NOCOPY NUMBER,
15035: x_msg_data OUT NOCOPY VARCHAR2,
15036: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

Line 16114: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

16110: --------------------- Main Process for All Lines Line Updating---------------------------------
16111: -----------------------------------------------------------------------------------------------
16112: PROCEDURE Update_all_line(
16113: p_api_version IN NUMBER,
16114: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
16115: x_return_status OUT NOCOPY VARCHAR2,
16116: x_msg_count OUT NOCOPY NUMBER,
16117: x_msg_data OUT NOCOPY VARCHAR2,
16118: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

Line 17813: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

17809: ----------------- Main Process for Creation of instance and Install base line ------------------------
17810: -------------------------------------------------------------------------------------------------------
17811: PROCEDURE create_ints_ib_line(
17812: p_api_version IN NUMBER,
17813: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
17814: x_return_status OUT NOCOPY VARCHAR2,
17815: x_msg_count OUT NOCOPY NUMBER,
17816: x_msg_data OUT NOCOPY VARCHAR2,
17817: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

Line 18848: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

18844: ----------------- Main Process for Updating of instance and Install base line ------------------------
18845: -------------------------------------------------------------------------------------------------------
18846: PROCEDURE update_ints_ib_line(
18847: p_api_version IN NUMBER,
18848: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
18849: x_return_status OUT NOCOPY VARCHAR2,
18850: x_msg_count OUT NOCOPY NUMBER,
18851: x_msg_data OUT NOCOPY VARCHAR2,
18852: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,

Line 19761: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

19757: ----------------- Main Process for Deletion of instance and Install base line ------------------------
19758: -------------------------------------------------------------------------------------------------------
19759: PROCEDURE delete_ints_ib_line(
19760: p_api_version IN NUMBER,
19761: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
19762: x_return_status OUT NOCOPY VARCHAR2,
19763: x_msg_count OUT NOCOPY NUMBER,
19764: x_msg_data OUT NOCOPY VARCHAR2,
19765: P_new_yn IN OKL_TXL_ASSETS_V.USED_ASSET_YN%TYPE,