APPS.OKL_PAY_INVOICES_TRANS_PVT dependencies on OKL_API

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

22: v_description ap_invoices_interface.description%type;
23:
24: l_api_version CONSTANT NUMBER := 1;
25: l_api_name CONSTANT VARCHAR2(30) := 'TRANSFER';
26: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
27: l_self_bill_invnum VARCHAR2(150);
28: l_contract_number VARCHAR2(120);
29: l_vendor_id po_vendor_sites_all.vendor_id%TYPE;
30: l_amount_includes_tax_flag po_vendor_sites_all.amount_includes_tax_flag%TYPE;

Line 281: x_return_status := OKL_API.G_RET_STS_SUCCESS;

277: ------------------------------------------------------------
278: -- Start processing
279: ------------------------------------------------------------
280:
281: x_return_status := OKL_API.G_RET_STS_SUCCESS;
282:
283: l_return_status := OKL_API.START_ACTIVITY(
284: p_api_name => l_api_name,
285: p_pkg_name => g_pkg_name,

Line 283: l_return_status := OKL_API.START_ACTIVITY(

279: ------------------------------------------------------------
280:
281: x_return_status := OKL_API.G_RET_STS_SUCCESS;
282:
283: l_return_status := OKL_API.START_ACTIVITY(
284: p_api_name => l_api_name,
285: p_pkg_name => g_pkg_name,
286: p_init_msg_list => p_init_msg_list,
287: l_api_version => l_api_version,

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

288: p_api_version => p_api_version,
289: p_api_type => '_PVT',
290: x_return_status => l_return_status);
291:
292: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
293: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
294: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
295: RAISE OKL_API.G_EXCEPTION_ERROR;
296: END IF;

Line 293: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

289: p_api_type => '_PVT',
290: x_return_status => l_return_status);
291:
292: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
293: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
294: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
295: RAISE OKL_API.G_EXCEPTION_ERROR;
296: END IF;
297: /*rkuttiya 02-Feb-2007

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

290: x_return_status => l_return_status);
291:
292: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
293: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
294: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
295: RAISE OKL_API.G_EXCEPTION_ERROR;
296: END IF;
297: /*rkuttiya 02-Feb-2007
298: Start Changes*/

Line 295: RAISE OKL_API.G_EXCEPTION_ERROR;

291:
292: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
293: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
294: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
295: RAISE OKL_API.G_EXCEPTION_ERROR;
296: END IF;
297: /*rkuttiya 02-Feb-2007
298: Start Changes*/
299:

Line 591: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

587: ,p_source_table => 'OKL_TXL_AP_INV_LNS_B'
588: ,x_tax_det_rec => lx_tax_det_rec);
589:
590:
591: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
592: l_tax_call_success_flag := 'N';
593: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, 'Tax call failed for invoice line id: ' || r_invoice_lines.invoice_line_id || ' of invoice id: ' || r_invoice_hdr.invoice_id);
594: --start| 20-Sep-2007 cklee -- Fixed error message display issue for tax call |
595: FOR j in 1..x_msg_count

Line 763: WHEN OKL_API.G_EXCEPTION_ERROR THEN

759:
760: ------------------------------------------------------------
761: -- Exception handling
762: ------------------------------------------------------------
763: WHEN OKL_API.G_EXCEPTION_ERROR THEN
764: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
765: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
766: p_api_name => l_api_name,
767: p_pkg_name => G_PKG_NAME,

Line 765: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

761: -- Exception handling
762: ------------------------------------------------------------
763: WHEN OKL_API.G_EXCEPTION_ERROR THEN
764: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
765: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
766: p_api_name => l_api_name,
767: p_pkg_name => G_PKG_NAME,
768: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
769: x_msg_count => x_msg_count,

Line 768: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

764: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
765: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
766: p_api_name => l_api_name,
767: p_pkg_name => G_PKG_NAME,
768: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
769: x_msg_count => x_msg_count,
770: x_msg_data => x_msg_data,
771: p_api_type => '_PVT');
772:

Line 773: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

769: x_msg_count => x_msg_count,
770: x_msg_data => x_msg_data,
771: p_api_type => '_PVT');
772:
773: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
774: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
775: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
776: p_api_name => l_api_name,
777: p_pkg_name => G_PKG_NAME,

Line 775: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

771: p_api_type => '_PVT');
772:
773: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
774: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
775: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
776: p_api_name => l_api_name,
777: p_pkg_name => G_PKG_NAME,
778: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
779: x_msg_count => x_msg_count,

Line 778: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

774: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
775: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
776: p_api_name => l_api_name,
777: p_pkg_name => G_PKG_NAME,
778: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
779: x_msg_count => x_msg_count,
780: x_msg_data => x_msg_data,
781: p_api_type => '_PVT');
782:

Line 785: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

781: p_api_type => '_PVT');
782:
783: WHEN OTHERS THEN
784: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
785: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
786: p_api_name => l_api_name,
787: p_pkg_name => G_PKG_NAME,
788: p_exc_name => 'OTHERS',
789: x_msg_count => x_msg_count,