7803: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
7804: RAISE OKL_API.G_EXCEPTION_ERROR;
7805: END IF;
7806: --srsreeni Bug6011651 starts
7807: OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx(
7808: p_api_version => l_api_version,
7809: p_init_msg_list => p_init_msg_list,
7810: x_return_status => x_return_status,
7811: x_msg_count => x_msg_count,
7810: x_return_status => x_return_status,
7811: x_msg_count => x_msg_count,
7812: x_msg_data => x_msg_data,
7813: p_khr_id => l_chr_id,
7814: p_prog_short_name => OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT,
7815: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE);
7816: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
7817: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7818: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
7811: x_msg_count => x_msg_count,
7812: x_msg_data => x_msg_data,
7813: p_khr_id => l_chr_id,
7814: p_prog_short_name => OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT,
7815: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE);
7816: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
7817: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7818: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
7819: RAISE OKL_API.G_EXCEPTION_ERROR;
7862: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
7863: RAISE OKL_API.G_EXCEPTION_ERROR;
7864: END IF;
7865: --srsreeni Bug6011651 starts
7866: OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx(
7867: p_api_version => l_api_version,
7868: p_init_msg_list => p_init_msg_list,
7869: x_return_status => x_return_status,
7870: x_msg_count => x_msg_count,
7869: x_return_status => x_return_status,
7870: x_msg_count => x_msg_count,
7871: x_msg_data => x_msg_data,
7872: p_khr_id => l_chr_id,
7873: p_prog_short_name => OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT,
7874: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE);
7875: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
7876: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7877: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
7870: x_msg_count => x_msg_count,
7871: x_msg_data => x_msg_data,
7872: p_khr_id => l_chr_id,
7873: p_prog_short_name => OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT,
7874: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE);
7875: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
7876: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
7877: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
7878: RAISE OKL_API.G_EXCEPTION_ERROR;
19950:
19951: Exception
19952: when OKL_API.G_EXCEPTION_ERROR then
19953: --srsreeni bug6011651 starts
19954: OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx(
19955: p_api_version => p_api_version,
19956: p_init_msg_list => p_init_msg_list,
19957: x_return_status => x_return_status,
19958: x_msg_count => x_msg_count,
19957: x_return_status => x_return_status,
19958: x_msg_count => x_msg_count,
19959: x_msg_data => x_msg_data,
19960: p_khr_id => p_chr_id,
19961: p_prog_short_name => OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT,
19962: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
19963: --srsreeni bug6011651 ends
19964: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
19965: p_api_name => l_api_name,
19958: x_msg_count => x_msg_count,
19959: x_msg_data => x_msg_data,
19960: p_khr_id => p_chr_id,
19961: p_prog_short_name => OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT,
19962: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
19963: --srsreeni bug6011651 ends
19964: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
19965: p_api_name => l_api_name,
19966: p_pkg_name => g_pkg_name,
19970: p_api_type => g_api_type);
19971:
19972: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
19973: --srsreeni bug6011651 starts
19974: OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx(
19975: p_api_version => p_api_version,
19976: p_init_msg_list => p_init_msg_list,
19977: x_return_status => x_return_status,
19978: x_msg_count => x_msg_count,
19977: x_return_status => x_return_status,
19978: x_msg_count => x_msg_count,
19979: x_msg_data => x_msg_data,
19980: p_khr_id => p_chr_id,
19981: p_prog_short_name => OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT,
19982: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
19983: --srsreeni bug6011651 ends
19984: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
19985: p_api_name => l_api_name,
19978: x_msg_count => x_msg_count,
19979: x_msg_data => x_msg_data,
19980: p_khr_id => p_chr_id,
19981: p_prog_short_name => OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT,
19982: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
19983: --srsreeni bug6011651 ends
19984: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
19985: p_api_name => l_api_name,
19986: p_pkg_name => g_pkg_name,
19990: p_api_type => g_api_type);
19991:
19992: when OTHERS then
19993: --srsreeni bug6011651 starts
19994: OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx(
19995: p_api_version => p_api_version,
19996: p_init_msg_list => p_init_msg_list,
19997: x_return_status => x_return_status,
19998: x_msg_count => x_msg_count,
19997: x_return_status => x_return_status,
19998: x_msg_count => x_msg_count,
19999: x_msg_data => x_msg_data,
20000: p_khr_id => p_chr_id,
20001: p_prog_short_name => OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT,
20002: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
20003: --srsreeni bug6011651 ends
20004: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
20005: p_api_name => l_api_name,
19998: x_msg_count => x_msg_count,
19999: x_msg_data => x_msg_data,
20000: p_khr_id => p_chr_id,
20001: p_prog_short_name => OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT,
20002: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_ERROR);
20003: --srsreeni bug6011651 ends
20004: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
20005: p_api_name => l_api_name,
20006: p_pkg_name => g_pkg_name,
20558: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
20559: RAISE OKL_API.G_EXCEPTION_ERROR;
20560: END IF;
20561:
20562: OKL_BOOK_CONTROLLER_PVT.update_book_controller_trx(
20563: p_api_version => l_api_version,
20564: p_init_msg_list => p_init_msg_list,
20565: x_return_status => x_return_status,
20566: x_msg_count => x_msg_count,
20565: x_return_status => x_return_status,
20566: x_msg_count => x_msg_count,
20567: x_msg_data => x_msg_data,
20568: p_khr_id => p_khr_id,
20569: p_prog_short_name => OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT,
20570: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE);
20571:
20572: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
20573: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
20566: x_msg_count => x_msg_count,
20567: x_msg_data => x_msg_data,
20568: p_khr_id => p_khr_id,
20569: p_prog_short_name => OKL_BOOK_CONTROLLER_PVT.G_PRICE_CONTRACT,
20570: p_progress_status => OKL_BOOK_CONTROLLER_PVT.G_PROG_STS_COMPLETE);
20571:
20572: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
20573: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
20574: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN