DBA Data[Home] [Help]

APPS.OKL_CS_TRANSFER_ASSUMPTION_PVT dependencies on OKC_API

Line 15: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

11:
12:
13: PROCEDURE Create_Requests(
14: p_api_version IN NUMBER,
15: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
16: p_header_tbl IN tcnv_tbl_type,
17: p_add_hdr_tbl IN add_hdr_tbl_type,
18: p_old_line_tbl IN l_before_trf_tbl,
19: p_new_line_tbl IN l_after_trf_tbl,

Line 128: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

124: p_tclv_tbl => l_tclv_tbl,
125: x_tcnv_rec => lx_tcnv_rec,
126: x_tclv_tbl => lx_tclv_tbl);
127:
128: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
129: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
130: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
131: RAISE OKC_API.G_EXCEPTION_ERROR;
132: END IF;

Line 129: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

125: x_tcnv_rec => lx_tcnv_rec,
126: x_tclv_tbl => lx_tclv_tbl);
127:
128: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
129: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
130: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
131: RAISE OKC_API.G_EXCEPTION_ERROR;
132: END IF;
133:

Line 130: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

126: x_tclv_tbl => lx_tclv_tbl);
127:
128: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
129: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
130: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
131: RAISE OKC_API.G_EXCEPTION_ERROR;
132: END IF;
133:
134:

Line 131: RAISE OKC_API.G_EXCEPTION_ERROR;

127:
128: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
129: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
130: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
131: RAISE OKC_API.G_EXCEPTION_ERROR;
132: END IF;
133:
134:
135: --geting the output header record

Line 197: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

193:
194:
195:
196: PROCEDURE Accept_Requests(p_api_version IN NUMBER,
197: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
198: p_header_tbl IN tcnv_tbl_type,
199: p_upd_hdr_tbl IN upd_hdr_tbl_type,
200: p_old_line_tbl IN l_before_trf_tbl,
201: p_new_line_tbl IN l_after_trf_tbl,

Line 272: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

268: p_tclv_tbl => l_tclv_tbl,
269: x_tcnv_rec => lx_tcnv_rec,
270: x_tclv_tbl => lx_tclv_tbl);
271:
272: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
273: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
274: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
275: RAISE OKC_API.G_EXCEPTION_ERROR;
276: END IF;

Line 273: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

269: x_tcnv_rec => lx_tcnv_rec,
270: x_tclv_tbl => lx_tclv_tbl);
271:
272: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
273: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
274: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
275: RAISE OKC_API.G_EXCEPTION_ERROR;
276: END IF;
277:

Line 274: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

270: x_tclv_tbl => lx_tclv_tbl);
271:
272: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
273: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
274: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
275: RAISE OKC_API.G_EXCEPTION_ERROR;
276: END IF;
277:
278:

Line 275: RAISE OKC_API.G_EXCEPTION_ERROR;

271:
272: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
273: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
274: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
275: RAISE OKC_API.G_EXCEPTION_ERROR;
276: END IF;
277:
278:
279: --geting the output header record

Line 344: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

340: END Accept_Requests;
341:
342:
343: PROCEDURE Update_Requests(p_api_version IN NUMBER,
344: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
345: p_header_tbl IN tcnv_tbl_type,
346: p_upd_hdr_tbl IN upd_hdr_tbl_type,
347: p_old_line_tbl IN l_before_trf_tbl,
348: p_new_line_tbl IN l_after_trf_tbl,

Line 413: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

409: x_tcnv_rec => lx_tcnv_rec,
410: x_tclv_tbl => lx_tclv_tbl);
411:
412:
413: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
414: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
415: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
416: RAISE OKC_API.G_EXCEPTION_ERROR;
417: END IF;

Line 414: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

410: x_tclv_tbl => lx_tclv_tbl);
411:
412:
413: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
414: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
415: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
416: RAISE OKC_API.G_EXCEPTION_ERROR;
417: END IF;
418:

Line 415: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

411:
412:
413: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
414: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
415: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
416: RAISE OKC_API.G_EXCEPTION_ERROR;
417: END IF;
418:
419:

Line 416: RAISE OKC_API.G_EXCEPTION_ERROR;

412:
413: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
414: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
415: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
416: RAISE OKC_API.G_EXCEPTION_ERROR;
417: END IF;
418:
419:
420: --geting the output header record

Line 484: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

480:
481: END Update_Requests;
482:
483: PROCEDURE Populate_new_Lessee_details( p_api_version IN NUMBER,
484: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
485: p_request_id IN NUMBER,
486: x_new_lessee_tbl OUT NOCOPY new_lessee_tbl_type,
487: x_return_status OUT NOCOPY VARCHAR2,
488: x_msg_count OUT NOCOPY NUMBER,

Line 771: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

767: '_PUB');
768: END Populate_new_Lessee_details;
769:
770: PROCEDURE Populate_ThirdParty_Insurance( p_api_version IN NUMBER,
771: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
772: p_taa_id IN NUMBER,
773: x_insurance_tbl OUT NOCOPY insurance_tbl_type,
774: x_return_status OUT NOCOPY VARCHAR2,
775: x_msg_count OUT NOCOPY NUMBER,