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.

[Home] [Help]

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 940: OKL_API.Set_Message(p_app_name => OKL_API.G_APP_NAME,

936: dbseqid => lx_dbseqid);
937:
938: EXCEPTION
939: WHEN OTHERS THEN
940: OKL_API.Set_Message(p_app_name => OKL_API.G_APP_NAME,
941: p_msg_name => 'OKL_UNEXPECTED_ERROR',
942: p_token1 => 'OKL_SQLCODE',
943: p_token1_value => SQLCODE,
944: p_token2 => 'OKL_SQLERRM',

Line 1217: p_init_msg_list => OKL_API.G_FALSE,

1213: END IF;
1214: on_account_credit_memo
1215: (
1216: p_api_version => l_api_version,
1217: p_init_msg_list => OKL_API.G_FALSE,
1218: p_try_id => l_trx_type,
1219: p_khr_id => p_ipyv_rec.khr_id,
1220: p_kle_id =>p_ipyv_rec.kle_id ,
1221: p_ipy_id =>p_ipyv_rec.ID ,

Line 1837: p_init_msg_list => OKL_API.G_FALSE,

1833: END if ;
1834: CLOSE c_trx_type;
1835: -- Call API to create Debit Memo
1836: insert_ap_request(p_api_version => l_api_version,
1837: p_init_msg_list => OKL_API.G_FALSE,
1838: x_return_status => l_return_status,
1839: x_msg_count =>x_msg_count,
1840: x_msg_data => x_msg_data,
1841: p_tap_id => l_tra_id,

Line 1891: p_init_msg_list => OKL_API.G_FALSE,

1887: END if ;
1888: CLOSE c_trx_type ;
1889:
1890: insert_ap_request(p_api_version => l_api_version,
1891: p_init_msg_list => OKL_API.G_FALSE,
1892: x_return_status => l_return_status,
1893: x_msg_count =>x_msg_count,
1894: x_msg_data => x_msg_data,
1895: p_tap_id => l_tra_id,

Line 3111: p_init_msg_list => OKL_API.G_FALSE,

3107: CLOSE c_trx_type;
3108:
3109: -- Call API to create Debit Memo
3110: insert_ap_request(p_api_version => l_api_version,
3111: p_init_msg_list => OKL_API.G_FALSE,
3112: x_return_status => l_return_status,
3113: x_msg_count =>x_msg_count,
3114: x_msg_data => x_msg_data,
3115: p_tap_id => l_tra_id,

Line 3165: p_init_msg_list => OKL_API.G_FALSE,

3161: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug call insert_ap_request');
3162: END;
3163: END IF;
3164: insert_ap_request(p_api_version => l_api_version,
3165: p_init_msg_list => OKL_API.G_FALSE,
3166: x_return_status => l_return_status,
3167: x_msg_count =>x_msg_count,
3168: x_msg_data => x_msg_data,
3169: p_tap_id => l_tra_id,

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

3771: OKL_STREAMS_UTIL.get_primary_stream_type_rep(l_ipyv_rec.khr_id,
3772: 'INSURANCE_INCOME_ACCRUAL',
3773: l_return_status,
3774: l_inc_sty_id_rep);
3775: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
3776: l_sob_id := Okl_Accounting_Util.GET_SET_OF_BOOKS_ID(
3777: p_representation_type => 'SECONDARY');
3778: 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
3779: l_ins_acc_adj := fnd_message.get_string('OKL','OKL_INS_INC_ACC_ADJ');

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

3822: END;
3823: END IF;
3824:
3825:
3826: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3827: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3828: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3829: RAISE Okl_Api.G_EXCEPTION_ERROR;
3830: END IF;

Line 3827: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

3823: END IF;
3824:
3825:
3826: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3827: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3828: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3829: RAISE Okl_Api.G_EXCEPTION_ERROR;
3830: END IF;
3831:

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

3824:
3825:
3826: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3827: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3828: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3829: RAISE Okl_Api.G_EXCEPTION_ERROR;
3830: END IF;
3831:
3832: END IF;

Line 3829: RAISE Okl_Api.G_EXCEPTION_ERROR;

3825:
3826: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
3827: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
3828: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN
3829: RAISE Okl_Api.G_EXCEPTION_ERROR;
3830: END IF;
3831:
3832: END IF;
3833: END IF;

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

3846: x_msg_data,
3847: '_PROCESS'
3848: );
3849: WHEN OTHERS THEN
3850: OKL_API.Set_Message(p_app_name => OKL_API.G_APP_NAME,
3851: p_msg_name => 'OKL_UNEXPECTED_ERROR',
3852: p_token1 => 'OKL_SQLCODE',
3853: p_token1_value => SQLCODE,
3854: p_token2 => 'OKL_SQLERRM',

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

4479: x_msg_data,
4480: '_PROCESS'
4481: );
4482: WHEN OTHERS THEN
4483: OKL_API.Set_Message(p_app_name => OKL_API.G_APP_NAME,
4484: p_msg_name => 'OKL_UNEXPECTED_ERROR',
4485: p_token1 => 'OKL_SQLCODE',
4486: p_token1_value => SQLCODE,
4487: p_token2 => 'OKL_SQLERRM',

Line 4528: x_return_status := OKL_API.G_RET_STS_SUCCESS;

4524: SELECT ID
4525: FROM okl_trx_types_tl
4526: WHERE NAME = 'Billing' AND LANGUAGE = 'US';
4527: BEGIN
4528: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4529: l_return_status := OKL_API.START_ACTIVITY(
4530: p_api_name => l_api_name,
4531: p_pkg_name => g_pkg_name,
4532: p_init_msg_list => p_init_msg_list,

Line 4529: l_return_status := OKL_API.START_ACTIVITY(

4525: FROM okl_trx_types_tl
4526: WHERE NAME = 'Billing' AND LANGUAGE = 'US';
4527: BEGIN
4528: x_return_status := OKL_API.G_RET_STS_SUCCESS;
4529: l_return_status := OKL_API.START_ACTIVITY(
4530: p_api_name => l_api_name,
4531: p_pkg_name => g_pkg_name,
4532: p_init_msg_list => p_init_msg_list,
4533: l_api_version => l_api_version,

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

4653: OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug call Okl_Acc_Call_Pub.CREATE_ACC_TRANS');
4654: END;
4655: END IF;
4656: -- End of wraper code generated automatically by Debug code generator for Okl_Acc_Call_Pub.CREATE_ACC_TRANS
4657: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4658: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4659: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4660: RAISE Okl_Api.G_EXCEPTION_ERROR;
4661: END IF;

Line 4658: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;

4654: END;
4655: END IF;
4656: -- End of wraper code generated automatically by Debug code generator for Okl_Acc_Call_Pub.CREATE_ACC_TRANS
4657: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4658: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4659: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4660: RAISE Okl_Api.G_EXCEPTION_ERROR;
4661: END IF;
4662: x_return_status := l_return_status;

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

4655: END IF;
4656: -- End of wraper code generated automatically by Debug code generator for Okl_Acc_Call_Pub.CREATE_ACC_TRANS
4657: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4658: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4659: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4660: RAISE Okl_Api.G_EXCEPTION_ERROR;
4661: END IF;
4662: x_return_status := l_return_status;
4663: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);

Line 4660: RAISE Okl_Api.G_EXCEPTION_ERROR;

4656: -- End of wraper code generated automatically by Debug code generator for Okl_Acc_Call_Pub.CREATE_ACC_TRANS
4657: IF (l_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
4658: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
4659: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4660: RAISE Okl_Api.G_EXCEPTION_ERROR;
4661: END IF;
4662: x_return_status := l_return_status;
4663: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
4664: EXCEPTION

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

4659: ELSIF (l_return_status = Okl_Api.G_RET_STS_ERROR) THEN
4660: RAISE Okl_Api.G_EXCEPTION_ERROR;
4661: END IF;
4662: x_return_status := l_return_status;
4663: OKL_API.END_ACTIVITY (x_msg_count, x_msg_data);
4664: EXCEPTION
4665: WHEN OKC_API.G_EXCEPTION_ERROR THEN
4666: x_return_status := OKC_API.HANDLE_EXCEPTIONS
4667: (

Line 4846: p_init_msg_list => OKL_API.G_FALSE,

4842: --- Creating credit memo
4843: on_account_credit_memo
4844: (
4845: p_api_version => l_api_version,
4846: p_init_msg_list => OKL_API.G_FALSE,
4847: p_try_id => l_trx_type,
4848: p_khr_id => l_ipyv_rec.khr_id,
4849: p_kle_id => l_ipyv_rec.kle_id,
4850: p_ipy_id => l_ipyv_rec.id,

Line 5602: OKL_API.set_message(G_APP_NAME,

5598: OPEN okc_k_status_csr(p_khr_id);
5599: FETCH okc_k_status_csr INTO l_contract_status ;
5600: IF(okc_k_status_csr%NOTFOUND) THEN
5601: -- store SQL error message on message stack for caller
5602: OKL_API.set_message(G_APP_NAME,
5603: G_INVALID_CONTRACT
5604: );
5605: IF okc_k_status_csr%ISOPEN THEN
5606: CLOSE okc_k_status_csr;

Line 5622: OKL_API.set_message(G_APP_NAME,G_INVALID_CONTRACT

5618: -- 3745151 Removing error as it is not needed
5619: /*
5620: IF(c_okl_ins_quote%NOTFOUND) THEN
5621: -- store SQL error message on message stack for caller
5622: OKL_API.set_message(G_APP_NAME,G_INVALID_CONTRACT
5623: );
5624: IF c_okl_ins_quote%ISOPEN THEN
5625: CLOSE c_okl_ins_quote;
5626: END IF;

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

5770: FETCH get_chr_number into l_contract_number;
5771: close get_chr_number;
5772:
5773: FOR chk_claims_rec IN chk_claims(p_khr_id,p_trx_date) LOOP
5774: OKL_API.set_message(G_APP_NAME, 'OKL_INS_CLAIMS_EXIST',
5775: 'CONTRACT_NUM',l_contract_number,
5776: 'CLAIM_DATE',l_claim_date);
5777:
5778: END LOOP;

Line 7191: p_init_msg_list => OKL_API.G_FALSE,

7187: --bug 3923601
7188: on_account_credit_memo
7189: (
7190: p_api_version => l_api_version,
7191: p_init_msg_list => OKL_API.G_FALSE,
7192: p_try_id => l_trx_type,
7193: p_khr_id => p_contract_id,
7194: p_kle_id => p_contract_line,
7195: p_ipy_id => l_policy_id,