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

Line 58: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SCS_CODE');

54: l_scs_code := x.scs_code;
55: END LOOP;
56:
57: IF l_scs_code IS NULL THEN
58: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SCS_CODE');
59: RAISE OKL_API.G_EXCEPTION_ERROR;
60: END IF;
61:
62: OKL_SECURITIZATION_PVT.check_khr_ia_associated(

Line 59: RAISE OKL_API.G_EXCEPTION_ERROR;

55: END LOOP;
56:
57: IF l_scs_code IS NULL THEN
58: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SCS_CODE');
59: RAISE OKL_API.G_EXCEPTION_ERROR;
60: END IF;
61:
62: OKL_SECURITIZATION_PVT.check_khr_ia_associated(
63: p_api_version => 1.0

Line 76: IF (l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

72: ,x_inv_acct_code => x_inv_acct_code
73: );
74:
75: -- store the highest degree of error
76: IF (l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
77: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
78: -- need to leave
79: Okl_Api.set_message(p_app_name => g_app_name,
80: p_msg_name => 'OKL_ACC_SEC_PVT_ERROR');

Line 77: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN

73: );
74:
75: -- store the highest degree of error
76: IF (l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
77: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
78: -- need to leave
79: Okl_Api.set_message(p_app_name => g_app_name,
80: p_msg_name => 'OKL_ACC_SEC_PVT_ERROR');
81: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 79: Okl_Api.set_message(p_app_name => g_app_name,

75: -- store the highest degree of error
76: IF (l_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
77: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
78: -- need to leave
79: Okl_Api.set_message(p_app_name => g_app_name,
80: p_msg_name => 'OKL_ACC_SEC_PVT_ERROR');
81: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
82: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
83: Okl_Api.set_message(p_app_name => g_app_name,

Line 81: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

77: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
78: -- need to leave
79: Okl_Api.set_message(p_app_name => g_app_name,
80: p_msg_name => 'OKL_ACC_SEC_PVT_ERROR');
81: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
82: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
83: Okl_Api.set_message(p_app_name => g_app_name,
84: p_msg_name => 'OKL_ACC_SEC_PVT_ERROR');
85: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 82: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN

78: -- need to leave
79: Okl_Api.set_message(p_app_name => g_app_name,
80: p_msg_name => 'OKL_ACC_SEC_PVT_ERROR');
81: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
82: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
83: Okl_Api.set_message(p_app_name => g_app_name,
84: p_msg_name => 'OKL_ACC_SEC_PVT_ERROR');
85: RAISE OKL_API.G_EXCEPTION_ERROR;
86: END IF;

Line 83: Okl_Api.set_message(p_app_name => g_app_name,

79: Okl_Api.set_message(p_app_name => g_app_name,
80: p_msg_name => 'OKL_ACC_SEC_PVT_ERROR');
81: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
82: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
83: Okl_Api.set_message(p_app_name => g_app_name,
84: p_msg_name => 'OKL_ACC_SEC_PVT_ERROR');
85: RAISE OKL_API.G_EXCEPTION_ERROR;
86: END IF;
87: END IF;

Line 85: RAISE OKL_API.G_EXCEPTION_ERROR;

81: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
82: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
83: Okl_Api.set_message(p_app_name => g_app_name,
84: p_msg_name => 'OKL_ACC_SEC_PVT_ERROR');
85: RAISE OKL_API.G_EXCEPTION_ERROR;
86: END IF;
87: END IF;
88:
89: END get_special_acct_codes;

Line 199: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

195: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call okl_trx_ar_invoices_pub.insert_trx_ar_invoices ');
196: END;
197: END IF;
198:
199: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
200: x_return_status := l_return_status;
201: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
202: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
203: x_return_status := l_return_status;

Line 201: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

197: END IF;
198:
199: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
200: x_return_status := l_return_status;
201: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
202: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
203: x_return_status := l_return_status;
204: RAISE OKL_API.G_EXCEPTION_ERROR;
205: END IF;

Line 202: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

198:
199: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
200: x_return_status := l_return_status;
201: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
202: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
203: x_return_status := l_return_status;
204: RAISE OKL_API.G_EXCEPTION_ERROR;
205: END IF;
206:

Line 204: RAISE OKL_API.G_EXCEPTION_ERROR;

200: x_return_status := l_return_status;
201: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
202: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
203: x_return_status := l_return_status;
204: RAISE OKL_API.G_EXCEPTION_ERROR;
205: END IF;
206:
207:
208:

Line 252: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

248: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call okl_txl_ar_inv_lns_pub.insert_txl_ar_inv_lns ');
249: END;
250: END IF;
251:
252: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
253: x_return_status := l_return_status;
254: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
255: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
256: x_return_status := l_return_status;

Line 254: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

250: END IF;
251:
252: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
253: x_return_status := l_return_status;
254: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
255: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
256: x_return_status := l_return_status;
257: RAISE OKL_API.G_EXCEPTION_ERROR;
258: END IF;

Line 255: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

251:
252: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
253: x_return_status := l_return_status;
254: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
255: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
256: x_return_status := l_return_status;
257: RAISE OKL_API.G_EXCEPTION_ERROR;
258: END IF;
259:

Line 257: RAISE OKL_API.G_EXCEPTION_ERROR;

253: x_return_status := l_return_status;
254: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
255: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
256: x_return_status := l_return_status;
257: RAISE OKL_API.G_EXCEPTION_ERROR;
258: END IF;
259:
260:
261:

Line 298: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

294: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRIPXB.pls call okl_acc_call_pub.create_acc_trans ');
295: END;
296: END IF;
297: -- End of Debug for okl_acc_call_pub.create_acc_trans
298: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
299: x_return_status := l_return_status;
300: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
301: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
302: x_return_status := l_return_status;

Line 300: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

296: END IF;
297: -- End of Debug for okl_acc_call_pub.create_acc_trans
298: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
299: x_return_status := l_return_status;
300: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
301: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
302: x_return_status := l_return_status;
303: RAISE OKL_API.G_EXCEPTION_ERROR;
304: END IF;

Line 301: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

297: -- End of Debug for okl_acc_call_pub.create_acc_trans
298: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
299: x_return_status := l_return_status;
300: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
301: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
302: x_return_status := l_return_status;
303: RAISE OKL_API.G_EXCEPTION_ERROR;
304: END IF;
305:

Line 303: RAISE OKL_API.G_EXCEPTION_ERROR;

299: x_return_status := l_return_status;
300: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
301: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
302: x_return_status := l_return_status;
303: RAISE OKL_API.G_EXCEPTION_ERROR;
304: END IF;
305:
306: */ -- 5897792 End
307:

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

342: x_taiv_rec => lx_taiv_rec,
343: x_tilv_tbl => lx_tilv_tbl,
344: x_tldv_tbl => lx_tldv_tbl);
345:
346: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
347: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
348: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
349: RAISE OKL_API.G_EXCEPTION_ERROR;
350: END IF;

Line 347: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

343: x_tilv_tbl => lx_tilv_tbl,
344: x_tldv_tbl => lx_tldv_tbl);
345:
346: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
347: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
348: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
349: RAISE OKL_API.G_EXCEPTION_ERROR;
350: END IF;
351:

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

344: x_tldv_tbl => lx_tldv_tbl);
345:
346: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
347: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
348: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
349: RAISE OKL_API.G_EXCEPTION_ERROR;
350: END IF;
351:
352: -- 5897792 Start End

Line 349: RAISE OKL_API.G_EXCEPTION_ERROR;

345:
346: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
347: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
348: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
349: RAISE OKL_API.G_EXCEPTION_ERROR;
350: END IF;
351:
352: -- 5897792 Start End
353:

Line 418: OKL_API.set_message(G_APP_NAME,

414: OPEN okc_k_status_csr(p_khr_id);
415: FETCH okc_k_status_csr INTO x_contract_status ;
416: IF(okc_k_status_csr%NOTFOUND) THEN
417: -- store SQL error message on message stack for caller
418: OKL_API.set_message(G_APP_NAME,
419: G_INVALID_CONTRACT
420: );
421: CLOSE okc_k_status_csr ;
422: l_return_status := OKC_API.G_RET_STS_ERROR;

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

608: dbseqid => lx_dbseqid);
609:
610: EXCEPTION
611: WHEN OTHERS THEN
612: OKL_API.Set_Message(p_app_name => OKL_API.G_APP_NAME,
613: p_msg_name => 'OKL_UNEXPECTED_ERROR',
614: p_token1 => 'OKL_SQLCODE',
615: p_token1_value => SQLCODE,
616: p_token2 => 'OKL_SQLERRM',

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

955: dbseqid => lx_dbseqid);
956:
957: EXCEPTION
958: WHEN OTHERS THEN
959: OKL_API.Set_Message(p_app_name => OKL_API.G_APP_NAME,
960: p_msg_name => 'OKL_UNEXPECTED_ERROR',
961: p_token1 => 'OKL_SQLCODE',
962: p_token1_value => SQLCODE,
963: p_token2 => 'OKL_SQLERRM',

Line 1236: p_init_msg_list => OKL_API.G_FALSE,

1232: END IF;
1233: on_account_credit_memo
1234: (
1235: p_api_version => l_api_version,
1236: p_init_msg_list => OKL_API.G_FALSE,
1237: p_try_id => l_trx_type,
1238: p_khr_id => p_ipyv_rec.khr_id,
1239: p_kle_id =>p_ipyv_rec.kle_id ,
1240: p_ipy_id =>p_ipyv_rec.ID ,

Line 1856: p_init_msg_list => OKL_API.G_FALSE,

1852: END if ;
1853: CLOSE c_trx_type;
1854: -- Call API to create Debit Memo
1855: insert_ap_request(p_api_version => l_api_version,
1856: p_init_msg_list => OKL_API.G_FALSE,
1857: x_return_status => l_return_status,
1858: x_msg_count =>x_msg_count,
1859: x_msg_data => x_msg_data,
1860: p_tap_id => l_tra_id,

Line 1910: p_init_msg_list => OKL_API.G_FALSE,

1906: END if ;
1907: CLOSE c_trx_type ;
1908:
1909: insert_ap_request(p_api_version => l_api_version,
1910: p_init_msg_list => OKL_API.G_FALSE,
1911: x_return_status => l_return_status,
1912: x_msg_count =>x_msg_count,
1913: x_msg_data => x_msg_data,
1914: p_tap_id => l_tra_id,

Line 3130: p_init_msg_list => OKL_API.G_FALSE,

3126: CLOSE c_trx_type;
3127:
3128: -- Call API to create Debit Memo
3129: insert_ap_request(p_api_version => l_api_version,
3130: p_init_msg_list => OKL_API.G_FALSE,
3131: x_return_status => l_return_status,
3132: x_msg_count =>x_msg_count,
3133: x_msg_data => x_msg_data,
3134: p_tap_id => l_tra_id,

Line 3184: p_init_msg_list => OKL_API.G_FALSE,

3180: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug call insert_ap_request');
3181: END;
3182: END IF;
3183: insert_ap_request(p_api_version => l_api_version,
3184: p_init_msg_list => OKL_API.G_FALSE,
3185: x_return_status => l_return_status,
3186: x_msg_count =>x_msg_count,
3187: x_msg_data => x_msg_data,
3188: p_tap_id => l_tra_id,

Line 3798: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN

3794: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,
3795: 'INSURANCE_INCOME_ACCRUAL',
3796: l_return_status,
3797: l_inc_sty_id_rep);
3798: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
3799: l_sob_id := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID(
3800: p_representation_type => 'SECONDARY');
3801: l_gl_date := OKL_ACCOUNTING_UTIL.get_valid_gl_date(p_gl_date => l_ipyv_rec.CANCELLATION_DATE, p_ledger_id => l_sob_id); --MGAAP 7263041
3802: l_ins_acc_adj := fnd_message.get_string('OKL','OKL_INS_INC_ACC_ADJ');

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

3846: END;
3847: END IF;
3848:
3849:
3850: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3851: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3852: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3853: RAISE Okl_Api.G_EXCEPTION_ERROR;
3854: END IF;

Line 3851: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

3847: END IF;
3848:
3849:
3850: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3851: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3852: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3853: RAISE Okl_Api.G_EXCEPTION_ERROR;
3854: END IF;
3855:

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

3848:
3849:
3850: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3851: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3852: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3853: RAISE Okl_Api.G_EXCEPTION_ERROR;
3854: END IF;
3855:
3856: END IF;

Line 3853: RAISE Okl_Api.G_EXCEPTION_ERROR;

3849:
3850: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3851: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3852: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3853: RAISE Okl_Api.G_EXCEPTION_ERROR;
3854: END IF;
3855:
3856: END IF;
3857: END IF;

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

3870: x_msg_data,
3871: '_PROCESS'
3872: );
3873: WHEN OTHERS THEN
3874: OKL_API.Set_Message(p_app_name => OKL_API.G_APP_NAME,
3875: p_msg_name => 'OKL_UNEXPECTED_ERROR',
3876: p_token1 => 'OKL_SQLCODE',
3877: p_token1_value => SQLCODE,
3878: p_token2 => 'OKL_SQLERRM',

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

4509: x_msg_data,
4510: '_PROCESS'
4511: );
4512: WHEN OTHERS THEN
4513: OKL_API.Set_Message(p_app_name => OKL_API.G_APP_NAME,
4514: p_msg_name => 'OKL_UNEXPECTED_ERROR',
4515: p_token1 => 'OKL_SQLCODE',
4516: p_token1_value => SQLCODE,
4517: p_token2 => 'OKL_SQLERRM',

Line 4567: x_return_status := OKL_API.G_RET_STS_SUCCESS;

4563: lx_tldv_tbl okl_tld_pvt.tldv_tbl_type;
4564: -- Bug 8810880 End
4565:
4566: BEGIN
4567: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4568: l_return_status := OKL_API.START_ACTIVITY(
4569: p_api_name => l_api_name,
4570: p_pkg_name => g_pkg_name,
4571: p_init_msg_list => p_init_msg_list,

Line 4568: l_return_status := OKL_API.START_ACTIVITY(

4564: -- Bug 8810880 End
4565:
4566: BEGIN
4567: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4568: l_return_status := OKL_API.START_ACTIVITY(
4569: p_api_name => l_api_name,
4570: p_pkg_name => g_pkg_name,
4571: p_init_msg_list => p_init_msg_list,
4572: l_api_version => l_api_version,

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

4642: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug call Okl_Internal_Billing_Pvt.create_billing_trx');
4643: END;
4644: END IF;
4645:
4646: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4647: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4648: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4649: RAISE OKL_API.G_EXCEPTION_ERROR;
4650: END IF;

Line 4647: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

4643: END;
4644: END IF;
4645:
4646: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4647: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4648: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4649: RAISE OKL_API.G_EXCEPTION_ERROR;
4650: END IF;
4651:

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

4644: END IF;
4645:
4646: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4647: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4648: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4649: RAISE OKL_API.G_EXCEPTION_ERROR;
4650: END IF;
4651:
4652: -- Bug 8810880 End

Line 4649: RAISE OKL_API.G_EXCEPTION_ERROR;

4645:
4646: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
4647: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
4648: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
4649: RAISE OKL_API.G_EXCEPTION_ERROR;
4650: END IF;
4651:
4652: -- Bug 8810880 End
4653:

Line 4654: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);

4650: END IF;
4651:
4652: -- Bug 8810880 End
4653:
4654: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
4655: EXCEPTION
4656: WHEN OKC_API.G_EXCEPTION_ERROR THEN
4657: x_return_status := OKC_API.HANDLE_EXCEPTIONS
4658: (

Line 4837: p_init_msg_list => OKL_API.G_FALSE,

4833: --- Creating credit memo
4834: on_account_credit_memo
4835: (
4836: p_api_version => l_api_version,
4837: p_init_msg_list => OKL_API.G_FALSE,
4838: p_try_id => l_trx_type,
4839: p_khr_id => l_ipyv_rec.khr_id,
4840: p_kle_id => l_ipyv_rec.kle_id,
4841: p_ipy_id => l_ipyv_rec.id,

Line 5595: OKL_API.set_message(G_APP_NAME,

5591: OPEN okc_k_status_csr(p_khr_id);
5592: FETCH okc_k_status_csr INTO l_contract_status ;
5593: IF(okc_k_status_csr%NOTFOUND) THEN
5594: -- store SQL error message on message stack for caller
5595: OKL_API.set_message(G_APP_NAME,
5596: G_INVALID_CONTRACT
5597: );
5598: IF okc_k_status_csr%ISOPEN THEN
5599: CLOSE okc_k_status_csr;

Line 5615: OKL_API.set_message(G_APP_NAME,G_INVALID_CONTRACT

5611: -- 3745151 Removing error as it is not needed
5612: /*
5613: IF(c_okl_ins_quote%NOTFOUND) THEN
5614: -- store SQL error message on message stack for caller
5615: OKL_API.set_message(G_APP_NAME,G_INVALID_CONTRACT
5616: );
5617: IF c_okl_ins_quote%ISOPEN THEN
5618: CLOSE c_okl_ins_quote;
5619: END IF;

Line 5767: OKL_API.set_message(G_APP_NAME, 'OKL_INS_CLAIMS_EXIST',

5763: FETCH get_chr_number into l_contract_number;
5764: close get_chr_number;
5765:
5766: FOR chk_claims_rec IN chk_claims(p_khr_id,p_trx_date) LOOP
5767: OKL_API.set_message(G_APP_NAME, 'OKL_INS_CLAIMS_EXIST',
5768: 'CONTRACT_NUM',l_contract_number,
5769: 'CLAIM_DATE',l_claim_date);
5770:
5771: END LOOP;

Line 7184: p_init_msg_list => OKL_API.G_FALSE,

7180: --bug 3923601
7181: on_account_credit_memo
7182: (
7183: p_api_version => l_api_version,
7184: p_init_msg_list => OKL_API.G_FALSE,
7185: p_try_id => l_trx_type,
7186: p_khr_id => p_contract_id,
7187: p_kle_id => p_contract_line,
7188: p_ipy_id => l_policy_id,