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_PAYMENT_SPLIT_PVT dependencies on OKC_API

Line 102: x_return_status := OKC_API.G_RET_STS_SUCCESS;

98: END IF;
99: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
100: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
101: END IF;
102: x_return_status := OKC_API.G_RET_STS_SUCCESS;
103:
104: l_cap_amount := 0;
105: OPEN cap_csr(p_fin_line_id);
106: FETCH cap_csr INTO l_cap_amount;

Line 148: x_return_status := OKC_API.G_RET_STS_SUCCESS;

144: l_precision FND_CURRENCIES.PRECISION%TYPE;
145:
146: BEGIN
147:
148: x_return_status := OKC_API.G_RET_STS_SUCCESS;
149: OPEN chr_csr(p_chr_id);
150: FETCH chr_csr INTO l_currency_code;
151: IF chr_csr%NOTFOUND THEN
152: okl_api.set_message(

Line 179: x_return_status := OKC_API.G_RET_STS_ERROR;

175: RETURN;
176:
177: EXCEPTION
178: WHEN curr_failed THEN
179: x_return_status := OKC_API.G_RET_STS_ERROR;
180: END get_currency_precision;
181:
182: ------------------------------------------------------------------------------
183: -- PROCEDURE gen_line_rule

Line 247: x_return_status := OKC_API.G_RET_STS_SUCCESS;

243: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
244: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
245: END IF;
246:
247: x_return_status := OKC_API.G_RET_STS_SUCCESS;
248:
249: l_strm_count := p_strm_count + 1;
250:
251: --debug_message('gen, srtm_count 1 :'||l_strm_count);

Line 302: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

298: x_msg_data => x_msg_data,
299: p_fin_line_id => p_cle_id,
300: x_fee_cap_amt => l_fee_line_capital_amount
301: );
302: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
303: x_return_status := OKC_API.G_RET_STS_ERROR;
304: raise rule_failed;
305: END IF;
306:

Line 303: x_return_status := OKC_API.G_RET_STS_ERROR;

299: p_fin_line_id => p_cle_id,
300: x_fee_cap_amt => l_fee_line_capital_amount
301: );
302: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
303: x_return_status := OKC_API.G_RET_STS_ERROR;
304: raise rule_failed;
305: END IF;
306:
307: l_line_capital_amount := NVL(p_fin_line_capital_amount,0) +

Line 322: x_return_status := OKC_API.G_RET_STS_ERROR;

318: RETURN;
319:
320: EXCEPTION
321: WHEN rule_failed THEN
322: x_return_status := OKC_API.G_RET_STS_ERROR;
323: WHEN OTHERS THEN
324: okl_api.set_message(
325: G_APP_NAME,
326: G_UNEXPECTED_ERROR,

Line 332: x_return_status := OKC_API.G_RET_STS_ERROR;

328: SQLCODE,
329: 'OKL_SQLERRM',
330: SQLERRM || ': '||G_PKG_NAME||'.'||l_proc_name
331: );
332: x_return_status := OKC_API.G_RET_STS_ERROR;
333: END gen_line_rule;
334:
335: ------------------------------------------------------------------------------
336: -- PROCEDURE get_total_capital_amount

Line 401: x_return_status := OKC_API.G_RET_STS_SUCCESS;

397: END IF;
398: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
399: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
400: END IF;
401: x_return_status := OKC_API.G_RET_STS_SUCCESS;
402:
403: OPEN fin_cap_csr(p_chr_id);
404: FETCH fin_cap_csr INTO l_fin_amount;
405: IF fin_cap_csr%NOTFOUND THEN

Line 433: x_return_status := OKC_API.G_RET_STS_ERROR;

429: END IF;
430: IF fee_cap_csr%ISOPEN THEN
431: CLOSE fee_cap_csr;
432: END IF;
433: x_return_status := OKC_API.G_RET_STS_ERROR;
434:
435: WHEN OTHERS THEN
436: okl_api.set_message(
437: G_APP_NAME,

Line 444: x_return_status := OKC_API.G_RET_STS_ERROR;

440: SQLCODE,
441: 'OKL_SQLERRM',
442: SQLERRM || ': '||G_PKG_NAME||'.'||l_proc_name
443: );
444: x_return_status := OKC_API.G_RET_STS_ERROR;
445: END get_total_capital_amount;
446:
447: ------------------------------------------------------------------------------
448: -- PROCEDURE generate_line_payments

Line 459: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

455: -- Called By:
456: ------------------------------------------------------------------------------
457: PROCEDURE generate_line_payments(
458: p_api_version IN NUMBER,
459: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
460: x_return_status OUT NOCOPY VARCHAR2,
461: x_msg_count OUT NOCOPY NUMBER,
462: x_msg_data OUT NOCOPY VARCHAR2,
463: p_chr_id IN OKC_K_HEADERS_V.ID%TYPE,

Line 536: x_return_status := OKC_API.G_RET_STS_SUCCESS;

532: IF (G_DEBUG_ENABLED = 'Y') THEN
533: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
534: END IF;
535:
536: x_return_status := OKC_API.G_RET_STS_SUCCESS;
537: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
538: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
539: END IF;
540: -- call START_ACTIVITY to create savepoint, check compatibility

Line 542: x_return_status := OKC_API.START_ACTIVITY(

538: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,l_proc_name);
539: END IF;
540: -- call START_ACTIVITY to create savepoint, check compatibility
541: -- and initialize message list
542: x_return_status := OKC_API.START_ACTIVITY(
543: p_api_name => l_api_name,
544: p_pkg_name => G_PKG_NAME,
545: p_init_msg_list => p_init_msg_list,
546: l_api_version => l_api_version,

Line 552: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

548: p_api_type => G_API_TYPE,
549: x_return_status => x_return_status);
550:
551: -- check if activity started successfully
552: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
553: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
554: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
555: raise OKC_API.G_EXCEPTION_ERROR;
556: END IF;

Line 553: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

549: x_return_status => x_return_status);
550:
551: -- check if activity started successfully
552: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
553: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
554: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
555: raise OKC_API.G_EXCEPTION_ERROR;
556: END IF;
557:

Line 554: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then

550:
551: -- check if activity started successfully
552: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
553: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
554: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
555: raise OKC_API.G_EXCEPTION_ERROR;
556: END IF;
557:
558: --

Line 555: raise OKC_API.G_EXCEPTION_ERROR;

551: -- check if activity started successfully
552: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
553: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
554: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) then
555: raise OKC_API.G_EXCEPTION_ERROR;
556: END IF;
557:
558: --
559: -- Validate input

Line 568: RAISE OKC_API.G_EXCEPTION_ERROR;

564: G_INVALID_VALUE,
565: 'COL_NAME',
566: 'Contract Header ID'
567: );
568: RAISE OKC_API.G_EXCEPTION_ERROR;
569: END IF;
570:
571: l_exists := 'N';
572: OPEN payment_csr(p_payment_type);

Line 582: RAISE OKC_API.G_EXCEPTION_ERROR;

578: 'COL_NAME',
579: 'Contract Header ID'
580: );
581: CLOSE payment_csr;
582: RAISE OKC_API.G_EXCEPTION_ERROR;
583: END IF;
584: CLOSE payment_csr;
585:
586: l_exists := 'N';

Line 597: RAISE OKC_API.G_EXCEPTION_ERROR;

593: 'COL_NAME',
594: 'Payment frequency'
595: );
596: CLOSE freq_csr;
597: RAISE OKC_API.G_EXCEPTION_ERROR;
598: END IF;
599: CLOSE freq_csr;
600:
601: IF (p_amount IS NULL) THEN

Line 608: RAISE OKC_API.G_EXCEPTION_ERROR;

604: G_INVALID_VALUE,
605: 'COL_NAME',
606: 'Payment amount'
607: );
608: RAISE OKC_API.G_EXCEPTION_ERROR;
609: END IF;
610:
611: IF (p_start_date IS NULL) THEN
612: okl_api.set_message(

Line 618: RAISE OKC_API.G_EXCEPTION_ERROR;

614: G_INVALID_VALUE,
615: 'COL_NAME',
616: 'Payment start date'
617: );
618: RAISE OKC_API.G_EXCEPTION_ERROR;
619: END IF;
620:
621: IF (p_period IS NULL) THEN
622: okl_api.set_message(

Line 628: RAISE OKC_API.G_EXCEPTION_ERROR;

624: G_INVALID_VALUE,
625: 'COL_NAME',
626: 'Payment period'
627: );
628: RAISE OKC_API.G_EXCEPTION_ERROR;
629: END IF;
630:
631:
632: get_total_capital_amount(

Line 640: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

636: p_chr_id => p_chr_id,
637: x_tot_capital_amount => l_tot_capital_amount
638: );
639:
640: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
641: okl_api.set_message(
642: G_APP_NAME,
643: G_CAPITAL_AMT_ERROR
644: );

Line 645: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

641: okl_api.set_message(
642: G_APP_NAME,
643: G_CAPITAL_AMT_ERROR
644: );
645: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
646: END IF;
647:
648: get_currency_precision(
649: x_return_status => x_return_status,

Line 653: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

649: x_return_status => x_return_status,
650: p_chr_id => p_chr_id,
651: x_precision => l_precision
652: );
653: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
654: RAISE OKC_API.G_EXCEPTION_ERROR;
655: END IF;
656:
657: --debug_message('CAP :'||l_tot_capital_amount);

Line 654: RAISE OKC_API.G_EXCEPTION_ERROR;

650: p_chr_id => p_chr_id,
651: x_precision => l_precision
652: );
653: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
654: RAISE OKC_API.G_EXCEPTION_ERROR;
655: END IF;
656:
657: --debug_message('CAP :'||l_tot_capital_amount);
658: FOR line_rec IN line_csr(p_chr_id)

Line 681: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

677: p_frequency => p_frequency,
678: p_strm_count => l_strm_count,
679: x_strm_tbl => l_strm_tbl
680: );
681: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
682: RAISE OKC_API.G_EXCEPTION_ERROR;
683: END IF;
684:
685: -- Populate output steam table

Line 682: RAISE OKC_API.G_EXCEPTION_ERROR;

678: p_strm_count => l_strm_count,
679: x_strm_tbl => l_strm_tbl
680: );
681: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
682: RAISE OKC_API.G_EXCEPTION_ERROR;
683: END IF;
684:
685: -- Populate output steam table
686: l_index := NVL(l_out_strm_tbl.LAST,0); -- get the last record

Line 718: when OKC_API.G_EXCEPTION_ERROR then

714: x_msg_data => x_msg_data);
715:
716: EXCEPTION
717:
718: when OKC_API.G_EXCEPTION_ERROR then
719: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
720: p_api_name => l_api_name,
721: p_pkg_name => G_PKG_NAME,
722: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 719: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

715:
716: EXCEPTION
717:
718: when OKC_API.G_EXCEPTION_ERROR then
719: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
720: p_api_name => l_api_name,
721: p_pkg_name => G_PKG_NAME,
722: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
723: x_msg_count => x_msg_count,

Line 722: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

718: when OKC_API.G_EXCEPTION_ERROR then
719: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
720: p_api_name => l_api_name,
721: p_pkg_name => G_PKG_NAME,
722: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
723: x_msg_count => x_msg_count,
724: x_msg_data => x_msg_data,
725: p_api_type => G_API_TYPE);
726:

Line 727: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

723: x_msg_count => x_msg_count,
724: x_msg_data => x_msg_data,
725: p_api_type => G_API_TYPE);
726:
727: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
728: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
729: p_api_name => l_api_name,
730: p_pkg_name => G_PKG_NAME,
731: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 728: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

724: x_msg_data => x_msg_data,
725: p_api_type => G_API_TYPE);
726:
727: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
728: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
729: p_api_name => l_api_name,
730: p_pkg_name => G_PKG_NAME,
731: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
732: x_msg_count => x_msg_count,

Line 731: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

727: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
728: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
729: p_api_name => l_api_name,
730: p_pkg_name => G_PKG_NAME,
731: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
732: x_msg_count => x_msg_count,
733: x_msg_data => x_msg_data,
734: p_api_type => G_API_TYPE);
735:

Line 737: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

733: x_msg_data => x_msg_data,
734: p_api_type => G_API_TYPE);
735:
736: when OTHERS then
737: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
738: p_api_name => l_api_name,
739: p_pkg_name => G_PKG_NAME,
740: p_exc_name => 'OTHERS',
741: x_msg_count => x_msg_count,