DBA Data[Home] [Help]

APPS.OKL_PAYMENT_SPLIT_PVT dependencies on OKL_API

Line 11: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

7:
8: -- Global Variables
9: G_INIT_NUMBER NUMBER := -9999;
10: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_PAYMENT_SPLIT_PVT';
11: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
12: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
13:
14:
15: subtype rgpv_rec_type IS OKL_RULE_PUB.rgpv_rec_type;

Line 39: okl_api.end_activity(

35: x_msg_out VARCHAR2(2000);
36:
37: BEGIN
38:
39: okl_api.end_activity(
40: X_msg_count => x_msg_count,
41: X_msg_data => x_msg_data
42: );
43:

Line 152: okl_api.set_message(

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(
153: G_APP_NAME,
154: G_LLA_CHR_ID
155: );
156: RAISE curr_failed;

Line 164: okl_api.set_message(

160:
161: OPEN curr_csr(l_currency_code);
162: FETCH curr_csr INTO l_precision;
163: IF curr_csr%NOTFOUND THEN
164: okl_api.set_message(
165: G_APP_NAME,
166: G_INVALID_VALUE,
167: 'COL_NAME',
168: 'CURRENCY CODE'

Line 324: okl_api.set_message(

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,
327: 'OKL_SQLCODE',
328: SQLCODE,

Line 436: okl_api.set_message(

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,
438: G_UNEXPECTED_ERROR,
439: 'OKL_SQLCODE',
440: SQLCODE,

Line 562: okl_api.set_message(

558: --
559: -- Validate input
560: --
561: IF (p_chr_id IS NULL) THEN
562: okl_api.set_message(
563: G_APP_NAME,
564: G_INVALID_VALUE,
565: 'COL_NAME',
566: 'Contract Header ID'

Line 575: okl_api.set_message(

571: l_exists := 'N';
572: OPEN payment_csr(p_payment_type);
573: FETCH payment_csr INTO l_exists;
574: IF payment_csr%NOTFOUND THEN
575: okl_api.set_message(
576: G_APP_NAME,
577: G_INVALID_VALUE,
578: 'COL_NAME',
579: 'Contract Header ID'

Line 590: okl_api.set_message(

586: l_exists := 'N';
587: OPEN freq_csr(p_frequency);
588: FETCH freq_csr INTO l_exists;
589: IF freq_csr%NOTFOUND THEN
590: okl_api.set_message(
591: G_APP_NAME,
592: G_INVALID_VALUE,
593: 'COL_NAME',
594: 'Payment frequency'

Line 602: okl_api.set_message(

598: END IF;
599: CLOSE freq_csr;
600:
601: IF (p_amount IS NULL) THEN
602: okl_api.set_message(
603: G_APP_NAME,
604: G_INVALID_VALUE,
605: 'COL_NAME',
606: 'Payment amount'

Line 612: okl_api.set_message(

608: RAISE OKC_API.G_EXCEPTION_ERROR;
609: END IF;
610:
611: IF (p_start_date IS NULL) THEN
612: okl_api.set_message(
613: G_APP_NAME,
614: G_INVALID_VALUE,
615: 'COL_NAME',
616: 'Payment start date'

Line 622: okl_api.set_message(

618: RAISE OKC_API.G_EXCEPTION_ERROR;
619: END IF;
620:
621: IF (p_period IS NULL) THEN
622: okl_api.set_message(
623: G_APP_NAME,
624: G_INVALID_VALUE,
625: 'COL_NAME',
626: 'Payment period'

Line 641: okl_api.set_message(

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: );
645: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 713: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

709: x_strm_tbl(i) := l_out_strm_tbl(i);
710: END LOOP;
711:
712: --Call End Activity
713: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
714: x_msg_data => x_msg_data);
715:
716: EXCEPTION
717: