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_APPLICATION_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_APPLICATION_PVT';
11: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
12: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
13:
14: -- Bug# 7661717 - Added Record type and table type
15: TYPE line_csr_rec IS RECORD (id NUMBER, capital_amount NUMBER);

Line 42: okl_api.end_activity(

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

Line 137: okl_api.set_message(

133: IF lrule_csr%ISOPEN THEN
134: CLOSE lrule_csr;
135: END IF;
136: x_return_status := OKC_API.G_RET_STS_ERROR;
137: okl_api.set_message(
138: G_APP_NAME,
139: G_UNEXPECTED_ERROR,
140: 'OKL_SQLCODE',
141: SQLCODE,

Line 228: okl_api.set_message(

224: IF l_ro_sl_rule_csr%ISOPEN THEN
225: CLOSE l_ro_sl_rule_csr;
226: END IF;
227: x_return_status := OKC_API.G_RET_STS_ERROR;
228: okl_api.set_message(
229: G_APP_NAME,
230: G_UNEXPECTED_ERROR,
231: 'OKL_SQLCODE',
232: SQLCODE,

Line 310: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

306: x_msg_data OUT NOCOPY VARCHAR2,
307: x_rgpv_tbl OUT NOCOPY rgpv_tbl_type,
308: x_rg_count OUT NOCOPY NUMBER) IS
309: l_No_RG_Found BOOLEAN DEFAULT TRUE;
310: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
311: l_api_name CONSTANT VARCHAR2(30) := 'GET_CONTRACT_RULE_GROUP';
312: l_api_version CONSTANT NUMBER := 1.0;
313: ---------------------------------------------------------------------------
314: -- FUNCTION get_rec for: OKC_RULE_GROUPS_V

Line 455: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

451: p_rgd_code => p_rgd_code,
452: p_stream_id => p_stream_id,
453: x_rg_count => x_rg_count);
454: EXCEPTION
455: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
456: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(
457: p_api_name => l_api_name,
458: p_pkg_name => g_pkg_name,
459: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 456: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(

452: p_stream_id => p_stream_id,
453: x_rg_count => x_rg_count);
454: EXCEPTION
455: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
456: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(
457: p_api_name => l_api_name,
458: p_pkg_name => g_pkg_name,
459: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
460: x_msg_count => x_msg_count,

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

455: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
456: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(
457: p_api_name => l_api_name,
458: p_pkg_name => g_pkg_name,
459: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
460: x_msg_count => x_msg_count,
461: x_msg_data => x_msg_data,
462: p_api_type => g_api_type);
463:

Line 464: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

460: x_msg_count => x_msg_count,
461: x_msg_data => x_msg_data,
462: p_api_type => g_api_type);
463:
464: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
465: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(
466: p_api_name => l_api_name,
467: p_pkg_name => g_pkg_name,
468: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 465: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(

461: x_msg_data => x_msg_data,
462: p_api_type => g_api_type);
463:
464: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
465: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(
466: p_api_name => l_api_name,
467: p_pkg_name => g_pkg_name,
468: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
469: x_msg_count => x_msg_count,

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

464: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
465: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(
466: p_api_name => l_api_name,
467: p_pkg_name => g_pkg_name,
468: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
469: x_msg_count => x_msg_count,
470: x_msg_data => x_msg_data,
471: p_api_type => g_api_type);
472:

Line 474: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(

470: x_msg_data => x_msg_data,
471: p_api_type => g_api_type);
472:
473: WHEN OTHERS THEN
474: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(
475: p_api_name => l_api_name,
476: p_pkg_name => g_pkg_name,
477: p_exc_name => 'OTHERS',
478: x_msg_count => x_msg_count,

Line 497: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

493: x_msg_data OUT NOCOPY VARCHAR2,
494: x_rgpv_tbl OUT NOCOPY rgpv_tbl_type,
495: x_rg_count OUT NOCOPY NUMBER) IS
496: l_No_RG_Found BOOLEAN DEFAULT TRUE;
497: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
498: l_api_name CONSTANT VARCHAR2(30) := 'GET_RO_FEE_TOPLN_RG';
499: l_api_version CONSTANT NUMBER := 1.0;
500: ---------------------------------------------------------------------------
501: -- FUNCTION get_rec for: OKC_RULE_GROUPS_V

Line 638: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

634: p_rgd_code => p_rgd_code,
635: p_stream_id => p_stream_id,
636: x_rg_count => x_rg_count);
637: EXCEPTION
638: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
639: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(
640: p_api_name => l_api_name,
641: p_pkg_name => g_pkg_name,
642: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 639: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(

635: p_stream_id => p_stream_id,
636: x_rg_count => x_rg_count);
637: EXCEPTION
638: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
639: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(
640: p_api_name => l_api_name,
641: p_pkg_name => g_pkg_name,
642: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
643: x_msg_count => x_msg_count,

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

638: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
639: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(
640: p_api_name => l_api_name,
641: p_pkg_name => g_pkg_name,
642: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
643: x_msg_count => x_msg_count,
644: x_msg_data => x_msg_data,
645: p_api_type => g_api_type);
646:

Line 647: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

643: x_msg_count => x_msg_count,
644: x_msg_data => x_msg_data,
645: p_api_type => g_api_type);
646:
647: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
648: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(
649: p_api_name => l_api_name,
650: p_pkg_name => g_pkg_name,
651: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 648: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(

644: x_msg_data => x_msg_data,
645: p_api_type => g_api_type);
646:
647: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
648: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(
649: p_api_name => l_api_name,
650: p_pkg_name => g_pkg_name,
651: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
652: x_msg_count => x_msg_count,

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

647: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
648: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(
649: p_api_name => l_api_name,
650: p_pkg_name => g_pkg_name,
651: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
652: x_msg_count => x_msg_count,
653: x_msg_data => x_msg_data,
654: p_api_type => g_api_type);
655:

Line 657: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(

653: x_msg_data => x_msg_data,
654: p_api_type => g_api_type);
655:
656: WHEN OTHERS THEN
657: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(
658: p_api_name => l_api_name,
659: p_pkg_name => g_pkg_name,
660: p_exc_name => 'OTHERS',
661: x_msg_count => x_msg_count,

Line 679: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

675: x_rulv_tbl OUT NOCOPY rulv_tbl_type,
676: x_rule_count OUT NOCOPY NUMBER ) IS
677:
678:
679: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
680: l_api_name CONSTANT VARCHAR2(30) := 'GET_SLH_RULES';
681: l_api_version CONSTANT NUMBER := 1.0;
682: ---------------------------------------------------------------------------
683: -- FUNCTION get_rec for: OKC_RULES_V

Line 847: WHEN Okl_Api.G_EXCEPTION_ERROR THEN

843: p_rdf_code => p_rdf_code,
844: p_stream_id => p_stream_id,
845: x_Rule_Count => x_rule_Count);
846: EXCEPTION
847: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
848: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(
849: p_api_name => l_api_name,
850: p_pkg_name => g_pkg_name,
851: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 848: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(

844: p_stream_id => p_stream_id,
845: x_Rule_Count => x_rule_Count);
846: EXCEPTION
847: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
848: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(
849: p_api_name => l_api_name,
850: p_pkg_name => g_pkg_name,
851: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
852: x_msg_count => x_msg_count,

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

847: WHEN Okl_Api.G_EXCEPTION_ERROR THEN
848: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(
849: p_api_name => l_api_name,
850: p_pkg_name => g_pkg_name,
851: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
852: x_msg_count => x_msg_count,
853: x_msg_data => x_msg_data,
854: p_api_type => g_api_type);
855:

Line 856: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

852: x_msg_count => x_msg_count,
853: x_msg_data => x_msg_data,
854: p_api_type => g_api_type);
855:
856: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
857: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(
858: p_api_name => l_api_name,
859: p_pkg_name => g_pkg_name,
860: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 857: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(

853: x_msg_data => x_msg_data,
854: p_api_type => g_api_type);
855:
856: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
857: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(
858: p_api_name => l_api_name,
859: p_pkg_name => g_pkg_name,
860: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
861: x_msg_count => x_msg_count,

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

856: WHEN Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
857: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(
858: p_api_name => l_api_name,
859: p_pkg_name => g_pkg_name,
860: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
861: x_msg_count => x_msg_count,
862: x_msg_data => x_msg_data,
863: p_api_type => g_api_type);
864:

Line 866: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(

862: x_msg_data => x_msg_data,
863: p_api_type => g_api_type);
864:
865: WHEN OTHERS THEN
866: x_return_status := Okl_Api.HANDLE_EXCEPTIONS(
867: p_api_name => l_api_name,
868: p_pkg_name => g_pkg_name,
869: p_exc_name => 'OTHERS',
870: x_msg_count => x_msg_count,

Line 1086: okl_api.set_message(

1082: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1083: OPEN chr_csr(p_chr_id);
1084: FETCH chr_csr INTO l_currency_code;
1085: IF chr_csr%NOTFOUND THEN
1086: okl_api.set_message(
1087: G_APP_NAME,
1088: G_LLA_CHR_ID
1089: );
1090: RAISE curr_failed;

Line 1098: okl_api.set_message(

1094:
1095: OPEN curr_csr(l_currency_code);
1096: FETCH curr_csr INTO l_precision;
1097: IF curr_csr%NOTFOUND THEN
1098: okl_api.set_message(
1099: G_APP_NAME,
1100: G_INVALID_VALUE,
1101: 'COL_NAME',
1102: 'CURRENCY CODE'

Line 1250: okl_api.set_message(

1246: RAISE rule_failed;
1247: END IF;
1248:
1249: IF (x_slh_rule_count = 0) THEN
1250: okl_api.set_message(
1251: G_APP_NAME,
1252: G_NO_HEADER_PAYMENT
1253: );
1254: RAISE rule_failed;

Line 1295: okl_api.set_message(

1291: RAISE rule_failed;
1292: END IF;
1293:
1294: IF (x_sll_rule_count = 0) THEN
1295: okl_api.set_message(
1296: G_APP_NAME,
1297: G_NO_HEADER_PAYMENT
1298: );
1299: RAISE rule_failed;

Line 1374: okl_api.set_message(

1370: EXCEPTION
1371: WHEN rule_failed THEN
1372: x_return_status := OKC_API.G_RET_STS_ERROR;
1373: WHEN OTHERS THEN
1374: okl_api.set_message(
1375: G_APP_NAME,
1376: G_UNEXPECTED_ERROR,
1377: 'OKL_SQLCODE',
1378: SQLCODE,

Line 1418: p_init_msg_list => OKL_API.G_FALSE,

1414: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1415:
1416: get_contract_rule_group(
1417: p_api_version => 1.0,
1418: p_init_msg_list => OKL_API.G_FALSE,
1419: p_chr_id => p_chr_id,
1420: p_cle_id => NULL,
1421: p_stream_id => p_stream_id,
1422: p_rgd_code => 'LALEVL',

Line 1438: okl_api.set_message(

1434: RETURN;
1435:
1436: EXCEPTION
1437: WHEN check_header_failed THEN
1438: okl_api.set_message(
1439: G_APP_NAME,
1440: G_UNEXPECTED_ERROR,
1441: 'OKL_SQLCODE',
1442: SQLCODE,

Line 1528: okl_api.set_message(

1524:
1525: x_return_status := OKC_API.G_RET_STS_ERROR;
1526:
1527: WHEN OTHERS THEN
1528: okl_api.set_message(
1529: G_APP_NAME,
1530: G_UNEXPECTED_ERROR,
1531: 'OKL_SQLCODE',
1532: SQLCODE,

Line 1616: l_return_status := OKL_API.start_activity(l_api_name

1612: rule_failed EXCEPTION;
1613:
1614: BEGIN
1615:
1616: l_return_status := OKL_API.start_activity(l_api_name
1617: ,G_PKG_NAME
1618: ,p_init_msg_list
1619: ,p_api_version
1620: ,p_api_version

Line 1623: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1619: ,p_api_version
1620: ,p_api_version
1621: ,'_PVT'
1622: ,x_return_status);
1623: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1624: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1625: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1626: RAISE OKL_API.G_EXCEPTION_ERROR;
1627: END IF;

Line 1624: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1620: ,p_api_version
1621: ,'_PVT'
1622: ,x_return_status);
1623: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1624: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1625: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1626: RAISE OKL_API.G_EXCEPTION_ERROR;
1627: END IF;
1628: ---------------------------------------

Line 1625: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN

1621: ,'_PVT'
1622: ,x_return_status);
1623: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1624: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1625: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1626: RAISE OKL_API.G_EXCEPTION_ERROR;
1627: END IF;
1628: ---------------------------------------
1629: -- Get SLH - payment header information

Line 1626: RAISE OKL_API.G_EXCEPTION_ERROR;

1622: ,x_return_status);
1623: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1624: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1625: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
1626: RAISE OKL_API.G_EXCEPTION_ERROR;
1627: END IF;
1628: ---------------------------------------
1629: -- Get SLH - payment header information
1630: ---------------------------------------

Line 1646: OKL_API.set_message(

1642: RAISE rule_failed;
1643: END IF;
1644:
1645: IF (x_slh_rule_count = 0) THEN
1646: OKL_API.set_message(
1647: G_APP_NAME,
1648: G_NO_HEADER_PAYMENT
1649: );
1650: RAISE rule_failed;

Line 1680: OKL_API.set_message(

1676: RAISE rule_failed;
1677: END IF;
1678:
1679: IF (x_sll_rule_count = 0) THEN
1680: OKL_API.set_message(
1681: G_APP_NAME,
1682: G_NO_HEADER_PAYMENT
1683: );
1684: RAISE rule_failed;

Line 1849: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);

1845: END IF;
1846: END LOOP; -- end of SLL loop
1847: END LOOP; -- end of SLH loop
1848:
1849: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1850: EXCEPTION
1851: WHEN OTHERS THEN
1852: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1853: (

Line 1852: x_return_status := OKL_API.HANDLE_EXCEPTIONS

1848:
1849: OKL_API.END_ACTIVITY(x_msg_count, x_msg_data);
1850: EXCEPTION
1851: WHEN OTHERS THEN
1852: x_return_status := OKL_API.HANDLE_EXCEPTIONS
1853: (
1854: l_api_name,
1855: G_PKG_NAME,
1856: 'OTHERS',

Line 1978: okl_api.set_message(

1974: RAISE OKC_API.G_EXCEPTION_ERROR;
1975: END IF;
1976:
1977: IF (l_rule_present = 'Y') THEN -- Rule already present at Line level
1978: okl_api.set_message(
1979: G_APP_NAME,
1980: G_RULE_PRESENT_ERROR
1981: );
1982: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2000: okl_api.set_message(

1996: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1997: END IF;
1998:
1999: IF (l_rg_count = 0) THEN -- No Rule Groups
2000: okl_api.set_message(
2001: G_APP_NAME,
2002: G_NO_HEADER_PAYMENT
2003: );
2004: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2016: okl_api.set_message(

2012: x_tot_capital_amount => l_tot_capital_amount
2013: );
2014:
2015: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2016: okl_api.set_message(
2017: G_APP_NAME,
2018: G_CAPITAL_AMT_ERROR
2019: );
2020: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

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

2158: END IF;
2159: END LOOP;
2160:
2161: --Call End Activity
2162: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2163: x_msg_data => x_msg_data);
2164:
2165:
2166: EXCEPTION

Line 2347: okl_api.set_message(

2343: RAISE OKC_API.G_EXCEPTION_ERROR;
2344: END IF;
2345:
2346: IF (l_rule_present = 'Y') THEN -- Rule already present at Line level
2347: okl_api.set_message(
2348: G_APP_NAME,
2349: G_RULE_PRESENT_ERROR
2350: );
2351: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2369: okl_api.set_message(

2365: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2366: END IF;
2367:
2368: IF (l_rg_count = 0) THEN -- No Rule Groups
2369: okl_api.set_message(
2370: G_APP_NAME,
2371: G_NO_HEADER_PAYMENT
2372: );
2373: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2424: okl_api.set_message(

2420:
2421: END LOOP;
2422:
2423: IF ( l_line_count = 0 ) THEN
2424: okl_api.set_message(
2425: G_APP_NAME,
2426: 'OKL_NO_PROP_TAX_AST'
2427: );
2428: RAISE OKC_API.G_EXCEPTION_ERROR;

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

2494: END IF;
2495: END LOOP;
2496:
2497: --Call End Activity
2498: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2499: x_msg_data => x_msg_data);
2500:
2501:
2502: EXCEPTION

Line 2668: okl_api.set_message(

2664: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2665: RAISE OKC_API.G_EXCEPTION_ERROR;
2666: END IF;
2667: IF (l_rule_present IS NOT NULL AND l_rule_present = 'Y') THEN -- Rule already present at Line level
2668: okl_api.set_message(
2669: G_APP_NAME,
2670: G_RULE_PRESENT_ERROR
2671: );
2672: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2677: p_init_msg_list => OKL_API.G_FALSE,

2673: END IF;
2674:
2675: get_ro_fee_topln_rg(
2676: p_api_version => 1.0,
2677: p_init_msg_list => OKL_API.G_FALSE,
2678: p_chr_id => p_chr_id,
2679: p_cle_id => p_kle_id,
2680: p_stream_id => p_stream_id,
2681: p_rgd_code => 'LALEVL',

Line 2693: okl_api.set_message(

2689: END IF;
2690:
2691:
2692: IF (l_rg_count = 0) THEN -- No Rule Groups
2693: okl_api.set_message(
2694: G_APP_NAME,
2695: G_NO_HEADER_PAYMENT
2696: );
2697: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 2756: okl_api.set_message(

2752: CLOSE ro_fee_subline_csr;
2753:
2754: -- NO sub-lines found, error out.
2755: IF ( rowCnt < 1 ) THEN
2756: okl_api.set_message(
2757: p_app_name => G_APP_NAME,
2758: p_msg_name => 'OKL_RO_NO_SUB_LNS',
2759: p_token1 => 'FEE_LINE',
2760: p_token1_value => l_fee_name

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

2829: END IF;
2830: END LOOP;
2831:
2832: --Call End Activity
2833: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
2834: x_msg_data => x_msg_data);
2835:
2836:
2837: EXCEPTION

Line 3003: okl_api.set_message(

2999: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3000: RAISE OKC_API.G_EXCEPTION_ERROR;
3001: END IF;
3002: IF (l_rule_present IS NOT NULL AND l_rule_present = 'Y') THEN -- Rule already present at Line level
3003: okl_api.set_message(
3004: G_APP_NAME,
3005: G_RULE_PRESENT_ERROR
3006: );
3007: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 3012: p_init_msg_list => OKL_API.G_FALSE,

3008: END IF;
3009:
3010: get_ro_fee_topln_rg(
3011: p_api_version => 1.0,
3012: p_init_msg_list => OKL_API.G_FALSE,
3013: p_chr_id => p_chr_id,
3014: p_cle_id => p_kle_id,
3015: p_stream_id => p_stream_id,
3016: p_rgd_code => 'LALEVL',

Line 3028: okl_api.set_message(

3024: END IF;
3025:
3026:
3027: IF (l_rg_count = 0) THEN -- No Rule Groups
3028: okl_api.set_message(
3029: G_APP_NAME,
3030: G_NO_HEADER_PAYMENT
3031: );
3032: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 3091: okl_api.set_message(

3087: CLOSE ro_fee_subline_csr;
3088:
3089: -- NO sub-lines found, error out.
3090: IF ( rowCnt < 1 ) THEN
3091: okl_api.set_message(
3092: p_app_name => G_APP_NAME,
3093: p_msg_name => 'OKL_RO_NO_SUB_LNS',
3094: p_token1 => 'FEE_LINE',
3095: p_token1_value => l_fee_name

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

3164: END IF;
3165: END LOOP;
3166:
3167: --Call End Activity
3168: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3169: x_msg_data => x_msg_data);
3170:
3171:
3172: EXCEPTION

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

3364:
3365: --++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
3366:
3367: --Call End Activity
3368: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
3369: x_msg_data => x_msg_data);
3370:
3371:
3372: EXCEPTION