4: -- Global Variables
5: G_DEBUG NUMBER := 1;
6: G_INIT_NUMBER NUMBER := -9999;
7: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_SERVICE_INTEGRATION_PUB';
8: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
9: G_API_TYPE CONSTANT VARCHAR2(4) := '_PUB';
10:
11: ------------------------------------------------------------------------------
12: -- PROCEDURE create_link_service_line
59:
60: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
61: okl_service_integration_pvt.create_link_service_line(
62: p_api_version => 1.0,
63: p_init_msg_list => OKL_API.G_FALSE,
64: x_return_status => x_return_status,
65: x_msg_count => x_msg_count,
66: x_msg_data => x_msg_data,
67: p_okl_chr_id => p_okl_chr_id,
78: END IF;
79:
80: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
81:
82: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
83: x_msg_data => x_msg_data);
84:
85: EXCEPTION
86:
180: END IF;
181:
182: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
183:
184: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
185: x_msg_data => x_msg_data);
186:
187: EXCEPTION
188:
282: END IF;
283:
284: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
285:
286: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
287: x_msg_data => x_msg_data);
288:
289: EXCEPTION
290: when OKC_API.G_EXCEPTION_ERROR then
362: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
363:
364: okl_service_integration_pvt.delete_service_line(
365: p_api_version => p_api_version,
366: p_init_msg_list => OKL_API.G_FALSE,
367: x_return_status => x_return_status,
368: x_msg_count => x_msg_count,
369: x_msg_data => x_msg_data,
370: p_clev_rec => p_clev_rec,
378: END IF;
379:
380: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
381:
382: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
383: x_msg_data => x_msg_data);
384:
385: EXCEPTION
386: when OKC_API.G_EXCEPTION_ERROR then
464: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
465:
466: okl_service_integration_pvt.update_service_line(
467: p_api_version => p_api_version,
468: p_init_msg_list => OKL_API.G_TRUE,
469: x_return_status => x_return_status,
470: x_msg_count => x_msg_count,
471: x_msg_data => x_msg_data,
472: p_okl_chr_id => p_okl_chr_id,
485: END IF;
486:
487: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
488:
489: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
490: x_msg_data => x_msg_data);
491:
492: EXCEPTION
493: when OKC_API.G_EXCEPTION_ERROR then
583: END IF;
584:
585: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
586:
587: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
588: x_msg_data => x_msg_data);
589:
590: EXCEPTION
591: when OKC_API.G_EXCEPTION_ERROR then
680: END IF;
681:
682: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
683:
684: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
685: x_msg_data => x_msg_data);
686:
687: EXCEPTION
688: when OKC_API.G_EXCEPTION_ERROR then
765: END IF;
766:
767: OKL_SERVICE_INTEGRATION_PVT.CREATE_COV_ASSET_LINE (
768: p_api_version => p_api_version,
769: p_init_msg_list => OKL_API.G_FALSE,
770: x_return_status => x_return_status,
771: x_msg_count => x_msg_count,
772: x_msg_data => x_msg_data,
773: p_clev_tbl => p_clev_tbl,
784: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
785: raise OKC_API.G_EXCEPTION_ERROR;
786: END IF;
787:
788: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
789: x_msg_data => x_msg_data);
790:
791: EXCEPTION
792: when OKC_API.G_EXCEPTION_ERROR then
868: END IF;
869:
870: OKL_SERVICE_INTEGRATION_PVT.UPDATE_COV_ASSET_LINE (
871: p_api_version => p_api_version,
872: p_init_msg_list => OKL_API.G_FALSE,
873: x_return_status => x_return_status,
874: x_msg_count => x_msg_count,
875: x_msg_data => x_msg_data,
876: p_clev_tbl => p_clev_tbl,
887: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
888: raise OKC_API.G_EXCEPTION_ERROR;
889: END IF;
890:
891: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
892: x_msg_data => x_msg_data);
893:
894: EXCEPTION
895: when OKC_API.G_EXCEPTION_ERROR then
982: END IF;
983:
984: --************************************************
985:
986: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
987: x_msg_data => x_msg_data);
988:
989: EXCEPTION
990: when OKC_API.G_EXCEPTION_ERROR then