eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_INVESTOR_INVOICE_DISB_PVT dependencies on OKL_API

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

511: WHERE cle_id = p_fee_line_id;
512:
513: l_api_version CONSTANT NUMBER := 1;
514: l_api_name CONSTANT VARCHAR2(30) := 'okl_investor_fee_disb';
515: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
516:
517: l_pay_to_id NUMBER;
518: l_pay_site_id NUMBER;
519: l_payment_term_id okl_trx_ap_invoices_v.ippt_id%TYPE;

Line 549: x_return_status := OKL_API.G_RET_STS_SUCCESS;

545:
546: ------------------------------------------------------------
547: -- Start Processing
548: ------------------------------------------------------------
549: x_return_status := OKL_API.G_RET_STS_SUCCESS;
550:
551: l_return_status := OKL_API.START_ACTIVITY(
552: p_api_name => l_api_name,
553: p_pkg_name => g_pkg_name,

Line 551: l_return_status := OKL_API.START_ACTIVITY(

547: -- Start Processing
548: ------------------------------------------------------------
549: x_return_status := OKL_API.G_RET_STS_SUCCESS;
550:
551: l_return_status := OKL_API.START_ACTIVITY(
552: p_api_name => l_api_name,
553: p_pkg_name => g_pkg_name,
554: p_init_msg_list => p_init_msg_list,
555: l_api_version => l_api_version,

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

556: p_api_version => p_api_version,
557: p_api_type => '_PVT',
558: x_return_status => l_return_status);
559:
560: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
561: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
562: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
563: RAISE OKL_API.G_EXCEPTION_ERROR;
564: END IF;

Line 561: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

557: p_api_type => '_PVT',
558: x_return_status => l_return_status);
559:
560: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
561: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
562: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
563: RAISE OKL_API.G_EXCEPTION_ERROR;
564: END IF;
565:

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

558: x_return_status => l_return_status);
559:
560: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
561: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
562: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
563: RAISE OKL_API.G_EXCEPTION_ERROR;
564: END IF;
565:
566: -- Get Investor Agreement details

Line 563: RAISE OKL_API.G_EXCEPTION_ERROR;

559:
560: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
561: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
562: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
563: RAISE OKL_API.G_EXCEPTION_ERROR;
564: END IF;
565:
566: -- Get Investor Agreement details
567: OPEN ia_info_csr;

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

703: ,p_tplv_tbl => i_tplv_tbl
704: ,x_tapv_rec => r_tapv_rec
705: ,x_tplv_tbl => r_tplv_tbl);
706:
707: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
708: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
709: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
710: RAISE OKL_API.G_EXCEPTION_ERROR;
711: END IF;

Line 708: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

704: ,x_tapv_rec => r_tapv_rec
705: ,x_tplv_tbl => r_tplv_tbl);
706:
707: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
708: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
709: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
710: RAISE OKL_API.G_EXCEPTION_ERROR;
711: END IF;
712:

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

705: ,x_tplv_tbl => r_tplv_tbl);
706:
707: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
708: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
709: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
710: RAISE OKL_API.G_EXCEPTION_ERROR;
711: END IF;
712:
713: END IF;

Line 710: RAISE OKL_API.G_EXCEPTION_ERROR;

706:
707: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
708: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
709: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
710: RAISE OKL_API.G_EXCEPTION_ERROR;
711: END IF;
712:
713: END IF;
714: END LOOP;

Line 722: Okl_Api.END_ACTIVITY (

718: -- End Processing
719: ------------------------------------------------------------
720: x_return_status := l_return_status;
721:
722: Okl_Api.END_ACTIVITY (
723: x_msg_count => x_msg_count,
724: x_msg_data => x_msg_data);
725:
726: EXCEPTION

Line 731: WHEN OKL_API.G_EXCEPTION_ERROR THEN

727: ------------------------------------------------------------
728: -- Exception handling
729: ------------------------------------------------------------
730:
731: WHEN OKL_API.G_EXCEPTION_ERROR THEN
732: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' ERROR 1: '||SQLERRM);
733: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
734: p_api_name => l_api_name,
735: p_pkg_name => G_PKG_NAME,

Line 733: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

729: ------------------------------------------------------------
730:
731: WHEN OKL_API.G_EXCEPTION_ERROR THEN
732: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' ERROR 1: '||SQLERRM);
733: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
734: p_api_name => l_api_name,
735: p_pkg_name => G_PKG_NAME,
736: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
737: x_msg_count => x_msg_count,

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

732: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' ERROR 1: '||SQLERRM);
733: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
734: p_api_name => l_api_name,
735: p_pkg_name => G_PKG_NAME,
736: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
737: x_msg_count => x_msg_count,
738: x_msg_data => x_msg_data,
739: p_api_type => '_PVT');
740:

Line 741: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

737: x_msg_count => x_msg_count,
738: x_msg_data => x_msg_data,
739: p_api_type => '_PVT');
740:
741: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
742: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' ERROR 2: '||SQLERRM);
743: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
744: p_api_name => l_api_name,
745: p_pkg_name => G_PKG_NAME,

Line 743: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

739: p_api_type => '_PVT');
740:
741: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
742: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' ERROR 2: '||SQLERRM);
743: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
744: p_api_name => l_api_name,
745: p_pkg_name => G_PKG_NAME,
746: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
747: x_msg_count => x_msg_count,

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

742: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' ERROR 2: '||SQLERRM);
743: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
744: p_api_name => l_api_name,
745: p_pkg_name => G_PKG_NAME,
746: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
747: x_msg_count => x_msg_count,
748: x_msg_data => x_msg_data,
749: p_api_type => '_PVT');
750:

Line 753: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

749: p_api_type => '_PVT');
750:
751: WHEN OTHERS THEN
752: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' ERROR 3: '||SQLERRM);
753: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
754: p_api_name => l_api_name,
755: p_pkg_name => G_PKG_NAME,
756: p_exc_name => 'OTHERS',
757: x_msg_count => x_msg_count,

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

774: -- Declare Variables required by APIs
775: ------------------------------------------------------------
776: l_api_version CONSTANT NUMBER := 1;
777: l_api_name CONSTANT VARCHAR2(30) := 'OKL_INVESTOR_DISBURSEMENT';
778: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
779:
780: -----------------------------------------------------------------
781: -- To pick up Investor Invoice Stream elements
782: -----------------------------------------------------------------

Line 1437: x_return_status := OKL_API.G_RET_STS_SUCCESS;

1433: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, '=====*** START PROCEDURE OKL_INVESTOR_DISBURSEMENT ***=====');
1434:
1435: --dbms_output.PUT_LINE ('=====*** START PROCEDURE OKL_INVESTOR_DISBURSEMENT ***=====');
1436:
1437: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1438:
1439: l_return_status := OKL_API.START_ACTIVITY(
1440: p_api_name => l_api_name,
1441: p_pkg_name => g_pkg_name,

Line 1439: l_return_status := OKL_API.START_ACTIVITY(

1435: --dbms_output.PUT_LINE ('=====*** START PROCEDURE OKL_INVESTOR_DISBURSEMENT ***=====');
1436:
1437: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1438:
1439: l_return_status := OKL_API.START_ACTIVITY(
1440: p_api_name => l_api_name,
1441: p_pkg_name => g_pkg_name,
1442: p_init_msg_list => p_init_msg_list,
1443: l_api_version => l_api_version,

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

1444: p_api_version => p_api_version,
1445: p_api_type => '_PVT',
1446: x_return_status => l_return_status);
1447:
1448: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1449: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1450: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1451: RAISE OKL_API.G_EXCEPTION_ERROR;
1452: END IF;

Line 1449: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1445: p_api_type => '_PVT',
1446: x_return_status => l_return_status);
1447:
1448: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1449: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1450: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1451: RAISE OKL_API.G_EXCEPTION_ERROR;
1452: END IF;
1453:

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

1446: x_return_status => l_return_status);
1447:
1448: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1449: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1450: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1451: RAISE OKL_API.G_EXCEPTION_ERROR;
1452: END IF;
1453:
1454: ------------------------------------

Line 1451: RAISE OKL_API.G_EXCEPTION_ERROR;

1447:
1448: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1449: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1450: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
1451: RAISE OKL_API.G_EXCEPTION_ERROR;
1452: END IF;
1453:
1454: ------------------------------------
1455: -- Initialize Variables

Line 1965: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1961: ,x_tapv_rec => r_tapv_rec
1962: ,x_tplv_tbl => r_tplv_tbl);
1963:
1964: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ### 26 ### ');
1965: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1966: l_error_status := 'E';
1967: l_error_message := l_error_message||'Error creating Investor Disbursement Transactions. ';
1968: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Error creating Investor Disbursement Transactions.');
1969: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 1969: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

1965: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1966: l_error_status := 'E';
1967: l_error_message := l_error_message||'Error creating Investor Disbursement Transactions. ';
1968: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Error creating Investor Disbursement Transactions.');
1969: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
1970: l_error_status := 'E';
1971: l_error_message := l_error_message||'Error creating Investor Disbursement Transactions ';
1972: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Error creating Investor Disbursement Transactions.');
1973: ELSIF (x_return_status = 'S') THEN

Line 2180: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2176: ,x_tapv_rec => r_tapv_rec
2177: ,x_tplv_tbl => r_tplv_tbl);
2178:
2179: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' ### 32 ### ');
2180: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2181: l_error_status := 'E';
2182: l_error_message := l_error_message||'Error creating Investor Disbursement Transactions. ';
2183: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Error creating Investor Disbursement Transactions.');
2184: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

Line 2184: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN

2180: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2181: l_error_status := 'E';
2182: l_error_message := l_error_message||'Error creating Investor Disbursement Transactions. ';
2183: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Error creating Investor Disbursement Transactions.');
2184: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2185: l_error_status := 'E';
2186: l_error_message := l_error_message||'Error creating Investor Disbursement Transactions ';
2187: FND_FILE.PUT_LINE (FND_FILE.OUTPUT, ' Error creating Investor Disbursement Transactions.');
2188: ELSIF (x_return_status = 'S') THEN

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

2495: x_msg_data => x_msg_data,
2496: p_investor_agreement => p_investor_agreement,
2497: p_to_date => p_to_date);
2498:
2499: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2500: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2501: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2502: RAISE OKL_API.G_EXCEPTION_ERROR;
2503: END IF;

Line 2500: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

2496: p_investor_agreement => p_investor_agreement,
2497: p_to_date => p_to_date);
2498:
2499: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2500: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2501: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2502: RAISE OKL_API.G_EXCEPTION_ERROR;
2503: END IF;
2504: -- gboomina added for Bug 6788005 - End

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

2497: p_to_date => p_to_date);
2498:
2499: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2500: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2501: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2502: RAISE OKL_API.G_EXCEPTION_ERROR;
2503: END IF;
2504: -- gboomina added for Bug 6788005 - End
2505:

Line 2502: RAISE OKL_API.G_EXCEPTION_ERROR;

2498:
2499: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2500: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2501: ELSIF (l_return_status = OKL_API.G_RET_STS_ERROR) THEN
2502: RAISE OKL_API.G_EXCEPTION_ERROR;
2503: END IF;
2504: -- gboomina added for Bug 6788005 - End
2505:
2506: ------------------------------------------------------------

Line 2510: Okl_Api.END_ACTIVITY (

2506: ------------------------------------------------------------
2507: -- End processing
2508: ------------------------------------------------------------
2509:
2510: Okl_Api.END_ACTIVITY (
2511: x_msg_count => x_msg_count,
2512: x_msg_data => x_msg_data);
2513:
2514:

Line 2524: WHEN OKL_API.G_EXCEPTION_ERROR THEN

2520: ------------------------------------------------------------
2521: -- Exception handling
2522: ------------------------------------------------------------
2523:
2524: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2525: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' ERROR 1: '||SQLERRM);
2526: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2527: p_api_name => l_api_name,
2528: p_pkg_name => G_PKG_NAME,

Line 2526: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

2522: ------------------------------------------------------------
2523:
2524: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2525: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' ERROR 1: '||SQLERRM);
2526: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2527: p_api_name => l_api_name,
2528: p_pkg_name => G_PKG_NAME,
2529: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2530: x_msg_count => x_msg_count,

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

2525: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' ERROR 1: '||SQLERRM);
2526: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2527: p_api_name => l_api_name,
2528: p_pkg_name => G_PKG_NAME,
2529: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
2530: x_msg_count => x_msg_count,
2531: x_msg_data => x_msg_data,
2532: p_api_type => '_PVT');
2533:

Line 2534: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2530: x_msg_count => x_msg_count,
2531: x_msg_data => x_msg_data,
2532: p_api_type => '_PVT');
2533:
2534: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2535: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' ERROR 2: '||SQLERRM);
2536: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2537: p_api_name => l_api_name,
2538: p_pkg_name => G_PKG_NAME,

Line 2536: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

2532: p_api_type => '_PVT');
2533:
2534: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2535: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' ERROR 2: '||SQLERRM);
2536: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2537: p_api_name => l_api_name,
2538: p_pkg_name => G_PKG_NAME,
2539: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2540: x_msg_count => x_msg_count,

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

2535: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' ERROR 2: '||SQLERRM);
2536: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2537: p_api_name => l_api_name,
2538: p_pkg_name => G_PKG_NAME,
2539: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
2540: x_msg_count => x_msg_count,
2541: x_msg_data => x_msg_data,
2542: p_api_type => '_PVT');
2543:

Line 2546: x_return_status := OKL_API.HANDLE_EXCEPTIONS (

2542: p_api_type => '_PVT');
2543:
2544: WHEN OTHERS THEN
2545: FND_FILE.PUT_LINE (FND_FILE.OUTPUT,' ERROR 3: '||SQLERRM);
2546: x_return_status := OKL_API.HANDLE_EXCEPTIONS (
2547: p_api_name => l_api_name,
2548: p_pkg_name => G_PKG_NAME,
2549: p_exc_name => 'OTHERS',
2550: x_msg_count => x_msg_count,