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

Line 47: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;

43: l_sty_id NUMBER;
44: l_product_id NUMBER;
45: l_amount NUMBER := 0;
46:
47: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
48: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
49: l_msg_count NUMBER;
50: l_msg_data VARCHAR2(2000);
51:

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

44: l_product_id NUMBER;
45: l_amount NUMBER := 0;
46:
47: l_init_msg_list VARCHAR2(1) := OKL_API.G_FALSE;
48: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
49: l_msg_count NUMBER;
50: l_msg_data VARCHAR2(2000);
51:
52: -- Code added by HKPATEL for billing transaction

Line 174: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

170: -- Bug 3940088
171:
172: Okl_Streams_Util.get_primary_stream_type(p_khr_id,'PREFUNDING_INTEREST_PAYMENT',l_return_status,l_sty_id);
173:
174: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
175: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
176: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
177: RAISE OKL_API.G_EXCEPTION_ERROR;
178: END IF;

Line 175: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

171:
172: Okl_Streams_Util.get_primary_stream_type(p_khr_id,'PREFUNDING_INTEREST_PAYMENT',l_return_status,l_sty_id);
173:
174: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
175: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
176: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
177: RAISE OKL_API.G_EXCEPTION_ERROR;
178: END IF;
179:

Line 176: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

172: Okl_Streams_Util.get_primary_stream_type(p_khr_id,'PREFUNDING_INTEREST_PAYMENT',l_return_status,l_sty_id);
173:
174: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
175: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
176: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
177: RAISE OKL_API.G_EXCEPTION_ERROR;
178: END IF;
179:
180: -- Fetch the functional currency

Line 177: RAISE OKL_API.G_EXCEPTION_ERROR;

173:
174: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
175: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
176: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
177: RAISE OKL_API.G_EXCEPTION_ERROR;
178: END IF;
179:
180: -- Fetch the functional currency
181: l_functional_currency := OKL_ACCOUNTING_UTIL.GET_FUNC_CURR_CODE;

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

222: ELSE
223: OPEN contract_num_csr(p_khr_id);
224: FETCH contract_num_csr INTO l_cntrct_number;
225: CLOSE contract_num_csr;
226: Okl_Api.set_message(p_app_name => g_app_name,
227: p_msg_name => 'OKL_LE_NOT_EXIST_CNTRCT',
228: p_token1 => 'CONTRACT_NUMBER',
229: p_token1_value => l_cntrct_number);
230: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 230: RAISE OKL_API.G_EXCEPTION_ERROR;

226: Okl_Api.set_message(p_app_name => g_app_name,
227: p_msg_name => 'OKL_LE_NOT_EXIST_CNTRCT',
228: p_token1 => 'CONTRACT_NUMBER',
229: p_token1_value => l_cntrct_number);
230: RAISE OKL_API.G_EXCEPTION_ERROR;
231: END IF;
232:
233: i_taiv_rec.try_id := l_try_id;
234: i_taiv_rec.khr_id := p_khr_id;

Line 276: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

272: x_msg_data => l_msg_data,
273: p_taiv_rec => i_taiv_rec,
274: x_taiv_rec => r_taiv_rec);
275:
276: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
277: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
278: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
279: RAISE OKL_API.G_EXCEPTION_ERROR;
280: END IF;

Line 277: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

273: p_taiv_rec => i_taiv_rec,
274: x_taiv_rec => r_taiv_rec);
275:
276: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
277: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
278: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
279: RAISE OKL_API.G_EXCEPTION_ERROR;
280: END IF;
281:

Line 278: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

274: x_taiv_rec => r_taiv_rec);
275:
276: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
277: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
278: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
279: RAISE OKL_API.G_EXCEPTION_ERROR;
280: END IF;
281:
282: ----------------------------------------------------------------------------------

Line 279: RAISE OKL_API.G_EXCEPTION_ERROR;

275:
276: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
277: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
278: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
279: RAISE OKL_API.G_EXCEPTION_ERROR;
280: END IF;
281:
282: ----------------------------------------------------------------------------------
283: -- Prepare Invoice Line

Line 304: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

300: x_msg_data => l_msg_data,
301: p_tilv_rec => i_tilv_rec,
302: x_tilv_rec => r_tilv_rec);
303:
304: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
305: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
306: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
307: RAISE OKL_API.G_EXCEPTION_ERROR;
308: END IF;

Line 305: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

301: p_tilv_rec => i_tilv_rec,
302: x_tilv_rec => r_tilv_rec);
303:
304: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
305: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
306: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
307: RAISE OKL_API.G_EXCEPTION_ERROR;
308: END IF;
309:

Line 306: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

302: x_tilv_rec => r_tilv_rec);
303:
304: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
305: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
306: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
307: RAISE OKL_API.G_EXCEPTION_ERROR;
308: END IF;
309:
310: IF(IS_DEBUG_PROCEDURE_ON) THEN

Line 307: RAISE OKL_API.G_EXCEPTION_ERROR;

303:
304: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
305: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
306: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
307: RAISE OKL_API.G_EXCEPTION_ERROR;
308: END IF;
309:
310: IF(IS_DEBUG_PROCEDURE_ON) THEN
311: BEGIN

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

326: -- Commented code ends here - HKPATEL
327:
328: -- End of wraper code generated automatically by Debug code generator for OKL_TRX_CONTRACTS_PUB.create_trx_contracts
329:
330: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
331:
332: l_khrv_rec_in.ID := p_khr_id;
333: l_khrv_rec_in.DATE_LAST_INTERIM_INTEREST_CAL := p_calc_date;
334: l_chrv_rec_in.ID := p_khr_id;

Line 347: p_restricted_update => OKL_API.G_TRUE,

343: p_init_msg_list => l_init_msg_list,
344: x_return_status => l_return_status,
345: x_msg_count => l_msg_count,
346: x_msg_data => l_msg_data,
347: p_restricted_update => OKL_API.G_TRUE,
348: p_chrv_rec => l_chrv_rec_in,
349: p_khrv_rec => l_khrv_rec_in,
350: p_edit_mode => 'N',
351: x_chrv_rec => l_chrv_rec_out,

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

358: END;
359: END IF;
360: -- End of wraper code generated automatically by Debug code generator for OKL_CONTRACT_PUB.update_contract_header
361:
362: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
363:
364: -- get scs_code
365: FOR x IN scs_code_csr
366: LOOP

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

366: LOOP
367: l_scs_code := x.scs_code;
368: END LOOP;
369: IF l_scs_code IS NULL THEN
370: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SCS_CODE');
371: RAISE OKL_API.G_EXCEPTION_ERROR;
372: END IF;
373:
374: --Bug 4622198.

Line 371: RAISE OKL_API.G_EXCEPTION_ERROR;

367: l_scs_code := x.scs_code;
368: END LOOP;
369: IF l_scs_code IS NULL THEN
370: OKL_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'SCS_CODE');
371: RAISE OKL_API.G_EXCEPTION_ERROR;
372: END IF;
373:
374: --Bug 4622198.
375: OKL_SECURITIZATION_PVT.check_khr_ia_associated(

Line 389: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN

385: ,x_inv_acct_code => l_inv_acct_code
386: );
387:
388: -- store the highest degree of error
389: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
390: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
391: -- need to leave
392: Okl_Api.set_message(p_app_name => g_app_name,
393: p_msg_name => 'OKL_ACC_SEC_PVT_ERROR');

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

386: );
387:
388: -- store the highest degree of error
389: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
390: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
391: -- need to leave
392: Okl_Api.set_message(p_app_name => g_app_name,
393: p_msg_name => 'OKL_ACC_SEC_PVT_ERROR');
394: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

388: -- store the highest degree of error
389: IF (x_return_status <> Okl_Api.G_RET_STS_SUCCESS) THEN
390: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
391: -- need to leave
392: Okl_Api.set_message(p_app_name => g_app_name,
393: p_msg_name => 'OKL_ACC_SEC_PVT_ERROR');
394: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
395: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
396: Okl_Api.set_message(p_app_name => g_app_name,

Line 394: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

390: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
391: -- need to leave
392: Okl_Api.set_message(p_app_name => g_app_name,
393: p_msg_name => 'OKL_ACC_SEC_PVT_ERROR');
394: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
395: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
396: Okl_Api.set_message(p_app_name => g_app_name,
397: p_msg_name => 'OKL_ACC_SEC_PVT_ERROR');
398: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 395: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN

391: -- need to leave
392: Okl_Api.set_message(p_app_name => g_app_name,
393: p_msg_name => 'OKL_ACC_SEC_PVT_ERROR');
394: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
395: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
396: Okl_Api.set_message(p_app_name => g_app_name,
397: p_msg_name => 'OKL_ACC_SEC_PVT_ERROR');
398: RAISE OKL_API.G_EXCEPTION_ERROR;
399: END IF;

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

392: Okl_Api.set_message(p_app_name => g_app_name,
393: p_msg_name => 'OKL_ACC_SEC_PVT_ERROR');
394: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
395: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
396: Okl_Api.set_message(p_app_name => g_app_name,
397: p_msg_name => 'OKL_ACC_SEC_PVT_ERROR');
398: RAISE OKL_API.G_EXCEPTION_ERROR;
399: END IF;
400: END IF;

Line 398: RAISE OKL_API.G_EXCEPTION_ERROR;

394: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
395: ELSIF (x_return_Status = Okl_Api.G_RET_STS_ERROR) THEN
396: Okl_Api.set_message(p_app_name => g_app_name,
397: p_msg_name => 'OKL_ACC_SEC_PVT_ERROR');
398: RAISE OKL_API.G_EXCEPTION_ERROR;
399: END IF;
400: END IF;
401:
402: l_tmpl_identify_rec.product_id := p_product_id;

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

635: l_interest_rate NUMBER := 0;
636: l_khr_id NUMBER := 0;
637: l_no_of_days_in_year VARCHAR2(450);
638: -- gboomina Bug 4900213 - Added - Start
639: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
640: -- though l_no_of_days_in_month is not used, need to pass this to OKL_PRICING_UTILS_PVT.get_day_convention method.
641: l_no_of_days_in_month VARCHAR2(450);
642: -- gboomina Bug 4900213 - Added - End
643:

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

678: FETCH cont_csr INTO l_khr_id;
679: IF (cont_csr%NOTFOUND) THEN
680: -- Abort the process.
681: IF (p_mode = 'ONLINE') THEN
682: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
683: p_msg_name => 'OKL_CNTR_NO_INVALID',
684: p_token1 => 'CONTRACT_NUMBER',
685: p_token1_value => p_contract_number);
686: ELSE

Line 693: RAISE OKL_API.G_EXCEPTION_ERROR;

689:
690: END IF;
691:
692: CLOSE cont_csr;
693: RAISE OKL_API.G_EXCEPTION_ERROR;
694: END IF;
695: CLOSE cont_csr;
696:
697: -- Find out number of days in Year

Line 706: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

702: x_days_in_month => l_no_of_days_in_month,
703: x_days_in_year => l_no_of_days_in_year,
704: x_return_status => l_return_status);
705:
706: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
707: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
708: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
709: RAISE OKL_API.G_EXCEPTION_ERROR;
710: END IF;

Line 707: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

703: x_days_in_year => l_no_of_days_in_year,
704: x_return_status => l_return_status);
705:
706: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
707: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
708: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
709: RAISE OKL_API.G_EXCEPTION_ERROR;
710: END IF;
711:

Line 708: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

704: x_return_status => l_return_status);
705:
706: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
707: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
708: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
709: RAISE OKL_API.G_EXCEPTION_ERROR;
710: END IF;
711:
712: IF l_no_of_days_in_year IS NULL THEN

Line 709: RAISE OKL_API.G_EXCEPTION_ERROR;

705:
706: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
707: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
708: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
709: RAISE OKL_API.G_EXCEPTION_ERROR;
710: END IF;
711:
712: IF l_no_of_days_in_year IS NULL THEN
713: IF (p_mode = 'ONLINE') THEN

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

710: END IF;
711:
712: IF l_no_of_days_in_year IS NULL THEN
713: IF (p_mode = 'ONLINE') THEN
714: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
715: p_msg_name => 'OKL_DAYS_IN_YEAR_NOT_FOUND');
716: ELSE
717: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error : Could not get Number of Days in Year');
718: END IF;

Line 719: RAISE OKL_API.G_EXCEPTION_ERROR;

715: p_msg_name => 'OKL_DAYS_IN_YEAR_NOT_FOUND');
716: ELSE
717: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error : Could not get Number of Days in Year');
718: END IF;
719: RAISE OKL_API.G_EXCEPTION_ERROR;
720: END IF;
721: -- gboomina bug 4900213 - End
722:
723: -- Find out the interest Name.

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

725: FETCH indx_csr INTO l_name;
726: IF (indx_csr%NOTFOUND) THEN
727: -- Cannot Continue. Must Stop
728: IF (p_mode = 'ONLINE') THEN
729: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
730: p_msg_name => 'OKL_INTR_NAME_NOT_FOUND');
731: ELSE
732: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error : Could not get Interest Rate '
733: || 'Name in the Rules');

Line 737: RAISE OKL_API.G_EXCEPTION_ERROR;

733: || 'Name in the Rules');
734:
735: END IF;
736: CLOSE indx_csr;
737: RAISE OKL_API.G_EXCEPTION_ERROR;
738: END IF;
739: CLOSE indx_csr;
740:
741: l_prev_start_date := p_start_date;

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

748: OPEN int_max_csr(l_name, change_rec.change_date - 1);
749: FETCH int_max_csr INTO l_interest_rate;
750: IF (int_max_csr%NOTFOUND) THEN
751: IF (p_mode = 'ONLINE') THEN
752: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
753: p_msg_name => 'OKL_INTR_RATE_NOT_FOUND',
754: p_token1 => 'INTR_DATE',
755: p_token1_value => to_char(change_rec.change_date - 1,'DD-MM-YY'));
756: ELSE

Line 762: RAISE OKL_API.G_EXCEPTION_ERROR;

758: to_char(change_rec.change_date-1,'DD-MON-YY'));
759: END IF;
760:
761: CLOSE int_max_csr;
762: RAISE OKL_API.G_EXCEPTION_ERROR;
763:
764: END IF;
765:
766: CLOSE int_max_csr;

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

780: OPEN int_max_csr(l_name, p_end_date);
781: FETCH int_max_csr INTO l_interest_rate;
782: IF (int_max_csr%NOTFOUND) THEN
783: IF (p_mode = 'ONLINE') THEN
784: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
785: p_msg_name => 'OKL_INTR_RATE_NOT_FOUND',
786: p_token1 => 'INTR_DATE',
787: p_token1_value => to_char(p_end_date,'DD-MM-YY'));
788: ELSE

Line 794: RAISE OKL_API.G_EXCEPTION_ERROR;

790: to_char(p_end_date,'DD-MON-YY'));
791: END IF;
792:
793: CLOSE int_max_csr;
794: RAISE OKL_API.G_EXCEPTION_ERROR;
795: END IF;
796:
797: CLOSE int_max_csr;
798:

Line 810: x_return_status := OKL_API.G_RET_STS_SUCCESS;

806:
807: l_total_interest := nvl(l_total_interest,0) + nvl(l_temp_interest,0);
808:
809: x_amount := l_total_interest;
810: x_return_status := OKL_API.G_RET_STS_SUCCESS;
811:
812: EXCEPTION
813: WHEN OKL_API.G_EXCEPTION_ERROR THEN
814: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 813: WHEN OKL_API.G_EXCEPTION_ERROR THEN

809: x_amount := l_total_interest;
810: x_return_status := OKL_API.G_RET_STS_SUCCESS;
811:
812: EXCEPTION
813: WHEN OKL_API.G_EXCEPTION_ERROR THEN
814: x_return_status := OKL_API.G_RET_STS_ERROR;
815: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
816: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
817: WHEN OTHERS THEN

Line 814: x_return_status := OKL_API.G_RET_STS_ERROR;

810: x_return_status := OKL_API.G_RET_STS_SUCCESS;
811:
812: EXCEPTION
813: WHEN OKL_API.G_EXCEPTION_ERROR THEN
814: x_return_status := OKL_API.G_RET_STS_ERROR;
815: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
816: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
817: WHEN OTHERS THEN
818: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 815: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

811:
812: EXCEPTION
813: WHEN OKL_API.G_EXCEPTION_ERROR THEN
814: x_return_status := OKL_API.G_RET_STS_ERROR;
815: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
816: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
817: WHEN OTHERS THEN
818: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
819:

Line 816: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

812: EXCEPTION
813: WHEN OKL_API.G_EXCEPTION_ERROR THEN
814: x_return_status := OKL_API.G_RET_STS_ERROR;
815: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
816: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
817: WHEN OTHERS THEN
818: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
819:
820: END CALC_INTEREST;

Line 818: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

814: x_return_status := OKL_API.G_RET_STS_ERROR;
815: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
816: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
817: WHEN OTHERS THEN
818: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
819:
820: END CALC_INTEREST;
821:
822:

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

825: p_retcode OUT NOCOPY NUMBER,
826: p_calc_upto IN VARCHAR2)
827: IS
828: l_api_name CONSTANT VARCHAR2(40) := 'CALC_INTEREST_PERD';
829: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
830: l_init_msg_list VARCHAR2(1);
831: l_msg_data VARCHAR2(2000);
832: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
833:

Line 832: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

828: l_api_name CONSTANT VARCHAR2(40) := 'CALC_INTEREST_PERD';
829: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
830: l_init_msg_list VARCHAR2(1);
831: l_msg_data VARCHAR2(2000);
832: l_overall_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
833:
834: l_api_version CONSTANT NUMBER := 1.0;
835: p_api_version CONSTANT NUMBER := 1.0;
836: l_row_count NUMBER;

Line 943: RAISE OKL_API.G_EXCEPTION_ERROR;

939:
940: IF (l_start_date IS NULL) THEN
941:
942: FND_FILE.PUT_LINE(FND_FILE.LOG, 'The Period ' || l_period_name || ' is Invalid');
943: RAISE OKL_API.G_EXCEPTION_ERROR;
944:
945: END IF;
946:
947: FOR cont_head_rec IN cont_head_csr

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

986:
987: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Total amount calculated was ' || l_amount);
988: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Interest Calculation was made upto ' || l_end_date);
989:
990: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
991:
992: SAVEPOINT CREATE_TRX_ACCT;
993:
994: CREATE_TRX_ACCT(p_khr_id => cont_head_rec.khr_id,

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

998: x_source_id => l_source_id,
999: x_return_status => l_return_status);
1000:
1001:
1002: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1003: l_count := l_count + 1;
1004: COMMIT WORK;
1005: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Interest Successfully Calculated. ' ||
1006: 'Total Amount was ' || OKL_ACCOUNTING_UTIL.ROUND_AMOUNT(p_amount => l_amount,

Line 1063: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

1059: FND_FILE.PUT_LINE(FND_FILE.LOG, '***Successful End of Interest Calculation Process***');
1060:
1061: EXCEPTION
1062:
1063: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
1064:
1065: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Interest Calculation Process Aborted');
1066: Okl_Accounting_Util.GET_ERROR_MESSAGE(l_error_msg_rec);
1067: IF (l_error_msg_rec.COUNT > 0) THEN

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

1102:
1103: IS
1104:
1105: l_api_name CONSTANT VARCHAR2(40) := 'CALC_INTEREST_ACTIVATE';
1106: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
1107: l_captl_flag VARCHAR2(1);
1108: l_init_msg_list VARCHAR2(1);
1109: l_msg_data VARCHAR2(2000);
1110:

Line 1214: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1210: --Bug 4899328 - End of Changes
1211:
1212: BEGIN
1213:
1214: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1215: G_PKG_NAME,
1216: p_init_msg_list,
1217: l_api_version,
1218: p_api_version,

Line 1222: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1218: p_api_version,
1219: '_PVT',
1220: x_return_status);
1221:
1222: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1223: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1224: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1225: RAISE OKL_API.G_EXCEPTION_ERROR;
1226: END IF;

Line 1223: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1219: '_PVT',
1220: x_return_status);
1221:
1222: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1223: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1224: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1225: RAISE OKL_API.G_EXCEPTION_ERROR;
1226: END IF;
1227:

Line 1224: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1220: x_return_status);
1221:
1222: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1223: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1224: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1225: RAISE OKL_API.G_EXCEPTION_ERROR;
1226: END IF;
1227:
1228:

Line 1225: RAISE OKL_API.G_EXCEPTION_ERROR;

1221:
1222: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1223: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1224: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1225: RAISE OKL_API.G_EXCEPTION_ERROR;
1226: END IF;
1227:
1228:
1229: -- First Get the last calculation Date

Line 1236: OKL_API.set_message('OKC', G_INVALID_VALUE, G_COL_NAME_TOKEN,'CONTRACT_NUMBER');

1232: FETCH cont_head_csr INTO l_last_calc_date,
1233: l_product_id,
1234: l_khr_id;
1235: IF (cont_head_csr%NOTFOUND) THEN
1236: OKL_API.set_message('OKC', G_INVALID_VALUE, G_COL_NAME_TOKEN,'CONTRACT_NUMBER');
1237: CLOSE cont_head_csr;
1238: RAISE OKL_API.G_EXCEPTION_ERROR;
1239: END IF;
1240:

Line 1238: RAISE OKL_API.G_EXCEPTION_ERROR;

1234: l_khr_id;
1235: IF (cont_head_csr%NOTFOUND) THEN
1236: OKL_API.set_message('OKC', G_INVALID_VALUE, G_COL_NAME_TOKEN,'CONTRACT_NUMBER');
1237: CLOSE cont_head_csr;
1238: RAISE OKL_API.G_EXCEPTION_ERROR;
1239: END IF;
1240:
1241: CLOSE cont_head_csr;
1242:

Line 1266: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1262: p_mode => 'ONLINE',
1263: x_amount => l_amount,
1264: x_return_status => l_return_status);
1265:
1266: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1267: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1268: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1269: RAISE OKL_API.G_EXCEPTION_ERROR;
1270: END IF;

Line 1267: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1263: x_amount => l_amount,
1264: x_return_status => l_return_status);
1265:
1266: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1267: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1268: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1269: RAISE OKL_API.G_EXCEPTION_ERROR;
1270: END IF;
1271: ELSE

Line 1268: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1264: x_return_status => l_return_status);
1265:
1266: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1267: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1268: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1269: RAISE OKL_API.G_EXCEPTION_ERROR;
1270: END IF;
1271: ELSE
1272: l_amount := 0;

Line 1269: RAISE OKL_API.G_EXCEPTION_ERROR;

1265:
1266: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1267: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1268: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1269: RAISE OKL_API.G_EXCEPTION_ERROR;
1270: END IF;
1271: ELSE
1272: l_amount := 0;
1273:

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

1280: FETCH captl_csr INTO l_captl_flag;
1281: IF (captl_csr%NOTFOUND) THEN
1282: /*
1283: Changed by HKPATEL for bug 3589126
1284: OKL_API.SET_MESSAGE(p_app_name => g_app_name,
1285: p_msg_name => 'OKL_CAPTL_INFO_NOT_FOUND',
1286: p_token1 => 'CONTRACT_NUMBER',
1287: p_token1_value => p_contract_number);
1288: */

Line 1292: --RAISE OKL_API.G_EXCEPTION_ERROR;

1288: */
1289: l_captl_flag := 'N';
1290: --CLOSE captl_csr;
1291:
1292: --RAISE OKL_API.G_EXCEPTION_ERROR;
1293: END IF;
1294:
1295: CLOSE captl_csr;
1296:

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

1354: x_amount := l_amount;
1355: x_source_id := l_source_id;
1356: x_return_status := l_return_status;
1357:
1358: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1359:
1360: EXCEPTION
1361:
1362: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 1362: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1358: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1359:
1360: EXCEPTION
1361:
1362: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1363: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1364: (
1365: l_api_name,
1366: G_PKG_NAME,

Line 1363: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1359:
1360: EXCEPTION
1361:
1362: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1363: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1364: (
1365: l_api_name,
1366: G_PKG_NAME,
1367: 'OKL_API.G_RET_STS_ERROR',

Line 1367: 'OKL_API.G_RET_STS_ERROR',

1363: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1364: (
1365: l_api_name,
1366: G_PKG_NAME,
1367: 'OKL_API.G_RET_STS_ERROR',
1368: x_msg_count,
1369: x_msg_data,
1370: '_PVT'
1371: );

Line 1372: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1368: x_msg_count,
1369: x_msg_data,
1370: '_PVT'
1371: );
1372: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1373: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1374: (
1375: l_api_name,
1376: G_PKG_NAME,

Line 1373: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1369: x_msg_data,
1370: '_PVT'
1371: );
1372: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1373: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1374: (
1375: l_api_name,
1376: G_PKG_NAME,
1377: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1377: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1373: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1374: (
1375: l_api_name,
1376: G_PKG_NAME,
1377: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1378: x_msg_count,
1379: x_msg_data,
1380: '_PVT'
1381: );

Line 1383: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1379: x_msg_data,
1380: '_PVT'
1381: );
1382: WHEN OTHERS THEN
1383: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1384: (
1385: l_api_name,
1386: G_PKG_NAME,
1387: 'OTHERS',

Line 1409: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

1405: RETURN NUMBER IS
1406:
1407: l_api_version CONSTANT NUMBER := 1.0;
1408: l_api_name CONSTANT VARCHAR2(30) := 'SUBMIT_CALCULATE_INTEREST';
1409: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1410: l_init_msg_list VARCHAR2(20) DEFAULT Okl_Api.G_FALSE;
1411: l_msg_count NUMBER;
1412: l_msg_data VARCHAR2(2000);
1413: x_request_id NUMBER;

Line 1410: l_init_msg_list VARCHAR2(20) DEFAULT Okl_Api.G_FALSE;

1406:
1407: l_api_version CONSTANT NUMBER := 1.0;
1408: l_api_name CONSTANT VARCHAR2(30) := 'SUBMIT_CALCULATE_INTEREST';
1409: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
1410: l_init_msg_list VARCHAR2(20) DEFAULT Okl_Api.G_FALSE;
1411: l_msg_count NUMBER;
1412: l_msg_data VARCHAR2(2000);
1413: x_request_id NUMBER;
1414:

Line 1417: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1413: x_request_id NUMBER;
1414:
1415: BEGIN
1416:
1417: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1418:
1419: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1420: G_PKG_NAME,
1421: p_init_msg_list,

Line 1419: l_return_status := OKL_API.START_ACTIVITY(l_api_name,

1415: BEGIN
1416:
1417: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1418:
1419: l_return_status := OKL_API.START_ACTIVITY(l_api_name,
1420: G_PKG_NAME,
1421: p_init_msg_list,
1422: l_api_version,
1423: p_api_version,

Line 1426: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1422: l_api_version,
1423: p_api_version,
1424: '_PVT',
1425: x_return_status);
1426: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1427: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1428: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1429: RAISE OKL_API.G_EXCEPTION_ERROR;
1430: END IF;

Line 1427: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1423: p_api_version,
1424: '_PVT',
1425: x_return_status);
1426: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1427: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1428: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1429: RAISE OKL_API.G_EXCEPTION_ERROR;
1430: END IF;
1431:

Line 1428: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN

1424: '_PVT',
1425: x_return_status);
1426: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1427: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1428: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1429: RAISE OKL_API.G_EXCEPTION_ERROR;
1430: END IF;
1431:
1432:

Line 1429: RAISE OKL_API.G_EXCEPTION_ERROR;

1425: x_return_status);
1426: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1427: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1428: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1429: RAISE OKL_API.G_EXCEPTION_ERROR;
1430: END IF;
1431:
1432:
1433: -- check for period name before submitting the request.

Line 1434: IF (p_period_name IS NULL) OR (p_period_name = Okl_Api.G_MISS_CHAR) THEN

1430: END IF;
1431:
1432:
1433: -- check for period name before submitting the request.
1434: IF (p_period_name IS NULL) OR (p_period_name = Okl_Api.G_MISS_CHAR) THEN
1435: OKL_API.set_message('OKC', G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Period Name');
1436: RAISE Okl_Api.G_EXCEPTION_ERROR;
1437: END IF;
1438:

Line 1435: OKL_API.set_message('OKC', G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Period Name');

1431:
1432:
1433: -- check for period name before submitting the request.
1434: IF (p_period_name IS NULL) OR (p_period_name = Okl_Api.G_MISS_CHAR) THEN
1435: OKL_API.set_message('OKC', G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Period Name');
1436: RAISE Okl_Api.G_EXCEPTION_ERROR;
1437: END IF;
1438:
1439: -- Submit Concurrent Program Request for interest calculation

Line 1436: RAISE Okl_Api.G_EXCEPTION_ERROR;

1432:
1433: -- check for period name before submitting the request.
1434: IF (p_period_name IS NULL) OR (p_period_name = Okl_Api.G_MISS_CHAR) THEN
1435: OKL_API.set_message('OKC', G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'Period Name');
1436: RAISE Okl_Api.G_EXCEPTION_ERROR;
1437: END IF;
1438:
1439: -- Submit Concurrent Program Request for interest calculation
1440:

Line 1449: OKL_API.set_message(p_app_name => 'OFA',

1445: argument1 => p_period_name);
1446:
1447: IF (x_request_id = 0) THEN
1448:
1449: OKL_API.set_message(p_app_name => 'OFA',
1450: p_msg_name => 'FA_DEPRN_TAX_ERROR',
1451: p_token1 => 'REQUEST_ID',
1452: p_token1_value => x_request_id);
1453: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 1453: RAISE OKL_API.G_EXCEPTION_ERROR;

1449: OKL_API.set_message(p_app_name => 'OFA',
1450: p_msg_name => 'FA_DEPRN_TAX_ERROR',
1451: p_token1 => 'REQUEST_ID',
1452: p_token1_value => x_request_id);
1453: RAISE OKL_API.G_EXCEPTION_ERROR;
1454:
1455: END IF;
1456:
1457: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

1453: RAISE OKL_API.G_EXCEPTION_ERROR;
1454:
1455: END IF;
1456:
1457: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1458:
1459: RETURN x_request_id;
1460:
1461: EXCEPTION

Line 1462: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1458:
1459: RETURN x_request_id;
1460:
1461: EXCEPTION
1462: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1463: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1464: (
1465: l_api_name,
1466: G_PKG_NAME,

Line 1463: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1459: RETURN x_request_id;
1460:
1461: EXCEPTION
1462: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1463: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1464: (
1465: l_api_name,
1466: G_PKG_NAME,
1467: 'OKL_API.G_RET_STS_ERROR',

Line 1467: 'OKL_API.G_RET_STS_ERROR',

1463: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1464: (
1465: l_api_name,
1466: G_PKG_NAME,
1467: 'OKL_API.G_RET_STS_ERROR',
1468: x_msg_count,
1469: x_msg_data,
1470: '_PVT'
1471: );

Line 1473: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1469: x_msg_data,
1470: '_PVT'
1471: );
1472: RETURN x_request_id;
1473: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1474: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1475: (
1476: l_api_name,
1477: G_PKG_NAME,

Line 1474: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1470: '_PVT'
1471: );
1472: RETURN x_request_id;
1473: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1474: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1475: (
1476: l_api_name,
1477: G_PKG_NAME,
1478: 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 1478: 'OKL_API.G_RET_STS_UNEXP_ERROR',

1474: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1475: (
1476: l_api_name,
1477: G_PKG_NAME,
1478: 'OKL_API.G_RET_STS_UNEXP_ERROR',
1479: x_msg_count,
1480: x_msg_data,
1481: '_PVT'
1482: );

Line 1485: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1481: '_PVT'
1482: );
1483: RETURN x_request_id;
1484: WHEN OTHERS THEN
1485: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1486: (
1487: l_api_name,
1488: G_PKG_NAME,
1489: 'OTHERS',