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 284: x_return_status := OKL_API.G_RET_STS_SUCCESS;

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

Line 286: l_return_status := OKL_API.START_ACTIVITY(

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

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

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

Line 296: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

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

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

Line 298: RAISE OKL_API.G_EXCEPTION_ERROR;

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

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

598: ,p_source_table => 'OKL_TXL_AP_INV_LNS_B'
599: ,x_tax_det_rec => lx_tax_det_rec);
600:
601:
602: IF (x_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
603: l_tax_call_success_flag := 'N';
604: 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);
605: --start| 20-Sep-2007 cklee -- Fixed error message display issue for tax call |
606: FOR j in 1..x_msg_count

Line 776: WHEN OKL_API.G_EXCEPTION_ERROR THEN

772:
773: ------------------------------------------------------------
774: -- Exception handling
775: ------------------------------------------------------------
776: WHEN OKL_API.G_EXCEPTION_ERROR THEN
777: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
778: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
779: p_api_name => l_api_name,
780: p_pkg_name => G_PKG_NAME,

Line 778: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

774: -- Exception handling
775: ------------------------------------------------------------
776: WHEN OKL_API.G_EXCEPTION_ERROR THEN
777: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
778: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
779: p_api_name => l_api_name,
780: p_pkg_name => G_PKG_NAME,
781: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
782: x_msg_count => x_msg_count,

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

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

Line 786: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

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

Line 788: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

784: p_api_type => '_PVT');
785:
786: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
787: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
788: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
789: p_api_name => l_api_name,
790: p_pkg_name => G_PKG_NAME,
791: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
792: x_msg_count => x_msg_count,

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

787: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
788: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
789: p_api_name => l_api_name,
790: p_pkg_name => G_PKG_NAME,
791: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
792: x_msg_count => x_msg_count,
793: x_msg_data => x_msg_data,
794: p_api_type => '_PVT');
795:

Line 798: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

794: p_api_type => '_PVT');
795:
796: WHEN OTHERS THEN
797: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '*=> ERROR: '||SQLERRM);
798: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
799: p_api_name => l_api_name,
800: p_pkg_name => G_PKG_NAME,
801: p_exc_name => 'OTHERS',
802: x_msg_count => x_msg_count,