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_AM_CREATE_QUOTE_PVT dependencies on OKL_AM_UTIL_PVT

Line 161: -- SECHAWLA 02-JAN-03 - Moved this procedure from okl_am_util_pvt to this API

157: -- OUT PL/SQL Table of Record achr_tbl_type
158: -- x_return_status OUT NOCOPY VARCHAR2
159: -- Version : 1.0
160: -- History : BAKUCHIB 28-DEC-2002 - 2699412 created
161: -- SECHAWLA 02-JAN-03 - Moved this procedure from okl_am_util_pvt to this API
162: -- GKADARKA 06-JAN-03 2736875 Added order by contract number asc in advance_contract_search
163: -- porcedure cursor.
164: -- BAKUCHIB 16-JAN-03 2748110
165: -- Modified the Advance_contract_search procedure

Line 964: 'before call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);

960: END IF;
961:
962: IF (is_debug_statement_on) THEN
963: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
964: 'before call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);
965: END IF;
966:
967:
968: OKL_AM_UTIL_PVT.get_rule_record(

Line 968: OKL_AM_UTIL_PVT.get_rule_record(

964: 'before call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);
965: END IF;
966:
967:
968: OKL_AM_UTIL_PVT.get_rule_record(
969: p_rgd_code => l_rgd_code,
970: p_rdf_code => l_rule_code,
971: p_chr_id => p_rule_chr_id,
972: p_cle_id => NULL,

Line 979: 'after call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);

975: p_message_yn => FALSE); -- RMUNJULU 11-DEC-02 2484327 Send FALSE to rule api
976:
977: IF (is_debug_statement_on) THEN
978: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
979: 'after call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);
980: END IF;
981:
982:
983: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN

Line 1083: 'before call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);

1079: END IF;
1080:
1081: IF (is_debug_statement_on) THEN
1082: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1083: 'before call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);
1084: END IF;
1085:
1086: OKL_AM_UTIL_PVT.get_rule_record(
1087: p_rgd_code => l_rgd_code,

Line 1086: OKL_AM_UTIL_PVT.get_rule_record(

1082: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1083: 'before call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);
1084: END IF;
1085:
1086: OKL_AM_UTIL_PVT.get_rule_record(
1087: p_rgd_code => l_rgd_code,
1088: p_rdf_code => l_rule_code,
1089: p_chr_id => p_rule_chr_id,
1090: p_cle_id => NULL,

Line 1097: 'after call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);

1093: p_message_yn => FALSE); -- RMUNJULU 11-DEC-02 2484327 Send FALSE to rule api
1094:
1095: IF (is_debug_statement_on) THEN
1096: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1097: 'after call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);
1098: END IF;
1099:
1100: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
1101: IF NVL (l_rulv_rec.rule_information1, '*') = 'Y' THEN

Line 1165: 'before call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);

1161: END IF;
1162:
1163: IF (is_debug_statement_on) THEN
1164: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1165: 'before call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);
1166: END IF;
1167:
1168: OKL_AM_UTIL_PVT.get_rule_record(
1169: p_rgd_code => l_rgd_code,

Line 1168: OKL_AM_UTIL_PVT.get_rule_record(

1164: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1165: 'before call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);
1166: END IF;
1167:
1168: OKL_AM_UTIL_PVT.get_rule_record(
1169: p_rgd_code => l_rgd_code,
1170: p_rdf_code => l_rule_code,
1171: p_chr_id => p_rule_chr_id,
1172: p_cle_id => NULL,

Line 1179: 'after call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);

1175: p_message_yn => TRUE);
1176:
1177: IF (is_debug_statement_on) THEN
1178: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1179: 'after call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);
1180: END IF;
1181:
1182: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
1183: IF NVL (l_rulv_rec.rule_information1, '-1') >= 0 THEN

Line 1262: l_rule_chr_id := okl_am_util_pvt.get_rule_chr_id (p_quot_rec);

1258: IF p_rule_chr_id IS NOT NULL
1259: OR p_rule_chr_id <> OKL_API.G_MISS_NUM THEN
1260: l_rule_chr_id := p_rule_chr_id;
1261: ELSE
1262: l_rule_chr_id := okl_am_util_pvt.get_rule_chr_id (p_quot_rec);
1263: END IF;
1264:
1265: IF (is_debug_statement_on) THEN
1266: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,

Line 1267: 'Before call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);

1263: END IF;
1264:
1265: IF (is_debug_statement_on) THEN
1266: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1267: 'Before call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);
1268: END IF;
1269: OKL_AM_UTIL_PVT.get_rule_record(
1270: p_rgd_code => l_rgd_code,
1271: p_rdf_code => l_rule_code,

Line 1269: OKL_AM_UTIL_PVT.get_rule_record(

1265: IF (is_debug_statement_on) THEN
1266: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1267: 'Before call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);
1268: END IF;
1269: OKL_AM_UTIL_PVT.get_rule_record(
1270: p_rgd_code => l_rgd_code,
1271: p_rdf_code => l_rule_code,
1272: p_chr_id => l_rule_chr_id,
1273: p_cle_id => NULL,

Line 1280: 'after call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);

1276: p_message_yn => TRUE);
1277:
1278: IF (is_debug_statement_on) THEN
1279: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1280: 'after call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);
1281: END IF;
1282:
1283: IF l_return_status = OKL_API.G_RET_STS_SUCCESS THEN
1284: IF NVL (l_rulv_rec.rule_information1, '-1') >= 0 THEN

Line 1373: 'before call to okl_am_util_pvt.get_rule_record :'||l_return_status);

1369: --SECHAWLA Bug # 2699412 02-JAN-03 Added the following code to check if auto quoets are allowed
1370:
1371: IF (is_debug_statement_on) THEN
1372: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1373: 'before call to okl_am_util_pvt.get_rule_record :'||l_return_status);
1374: END IF;
1375: --Check if auto quotes are allowed
1376: okl_am_util_pvt.get_rule_record( p_rgd_code => 'AMTQPR'
1377: ,p_rdf_code => 'AMCMTQ'

Line 1376: okl_am_util_pvt.get_rule_record( p_rgd_code => 'AMTQPR'

1372: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1373: 'before call to okl_am_util_pvt.get_rule_record :'||l_return_status);
1374: END IF;
1375: --Check if auto quotes are allowed
1376: okl_am_util_pvt.get_rule_record( p_rgd_code => 'AMTQPR'
1377: ,p_rdf_code => 'AMCMTQ'
1378: ,p_chr_id => p_khr_id
1379: ,p_cle_id => NULL
1380: ,p_message_yn => FALSE

Line 1388: 'after call to okl_am_util_pvt.get_rule_record :'||l_return_status);

1384: ,x_msg_data => l_msg_data);
1385:
1386: IF (is_debug_statement_on) THEN
1387: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
1388: 'after call to okl_am_util_pvt.get_rule_record :'||l_return_status);
1389: END IF;
1390:
1391: IF (l_return_status = OKL_API.G_RET_STS_SUCCESS) THEN
1392: -- Rule instance is found

Line 1626: lx_quote_tbl OKL_AM_UTIL_PVT.quote_tbl_type;

1622: l_name VARCHAR2(150);
1623:
1624: -- RMUNJULU -- 11-DEC-02 Bug # 2484327 -- Added parameters for checking
1625: -- related to asset level termination
1626: lx_quote_tbl OKL_AM_UTIL_PVT.quote_tbl_type;
1627:
1628: -- SECHAWLA 17-FEB-03 Bug 2804703 : new declarations
1629: l_sts_code okc_k_headers_b.sts_code%TYPE;
1630:

Line 1980: l_asset_qty := okl_am_util_pvt.get_asset_quantity(p_assn_tbl(i).p_asset_id);

1976:
1977: -- SECHAWLA Bug #2680542 : Added code to populate asset qty and quote qty, if null
1978: IF ((p_assn_tbl(i).p_asset_qty IS NULL) OR
1979: (p_assn_tbl(i).p_asset_qty = OKC_API.G_MISS_NUM)) THEN
1980: l_asset_qty := okl_am_util_pvt.get_asset_quantity(p_assn_tbl(i).p_asset_id);
1981: IF l_asset_qty IS NULL THEN
1982: x_return_status := OKL_API.G_RET_STS_ERROR;
1983: -- Can not create quote because the asset quantity is missing.
1984: OKC_API.SET_MESSAGE (

Line 2042: 'before call to OKL_AM_UTIL_PVT.get_line_quotes :'||l_return_status);

2038: -- quote based on asset level termination changes
2039:
2040: IF (is_debug_statement_on) THEN
2041: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2042: 'before call to OKL_AM_UTIL_PVT.get_line_quotes :'||l_return_status);
2043: END IF;
2044:
2045: -- Check if accepted quote exists for the asset
2046: OKL_AM_UTIL_PVT.get_line_quotes (

Line 2046: OKL_AM_UTIL_PVT.get_line_quotes (

2042: 'before call to OKL_AM_UTIL_PVT.get_line_quotes :'||l_return_status);
2043: END IF;
2044:
2045: -- Check if accepted quote exists for the asset
2046: OKL_AM_UTIL_PVT.get_line_quotes (
2047: p_kle_id => p_assn_tbl(i).p_asset_id,
2048: x_quote_tbl => lx_quote_tbl,
2049: x_return_status => x_return_status);
2050:

Line 2053: 'After call to OKL_AM_UTIL_PVT.get_line_quotes :'||l_return_status);

2049: x_return_status => x_return_status);
2050:
2051: IF (is_debug_statement_on) THEN
2052: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2053: 'After call to OKL_AM_UTIL_PVT.get_line_quotes :'||l_return_status);
2054: END IF;
2055:
2056: -- Check the return status
2057: IF x_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

Line 2069: 'before call to OKL_AM_UTIL_PVT.get_lookup_meaning :'||l_return_status);

2065: IF lx_quote_tbl.COUNT > 0 THEN
2066:
2067: IF (is_debug_statement_on) THEN
2068: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2069: 'before call to OKL_AM_UTIL_PVT.get_lookup_meaning :'||l_return_status);
2070: END IF;
2071:
2072: l_quote_type := OKL_AM_UTIL_PVT.get_lookup_meaning(
2073: 'OKL_QUOTE_TYPE',

Line 2072: l_quote_type := OKL_AM_UTIL_PVT.get_lookup_meaning(

2068: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2069: 'before call to OKL_AM_UTIL_PVT.get_lookup_meaning :'||l_return_status);
2070: END IF;
2071:
2072: l_quote_type := OKL_AM_UTIL_PVT.get_lookup_meaning(
2073: 'OKL_QUOTE_TYPE',
2074: lx_quote_tbl(lx_quote_tbl.FIRST).qtp_code,
2075: 'Y');
2076:

Line 2079: 'after call to OKL_AM_UTIL_PVT.get_lookup_meaning :'||l_return_status);

2075: 'Y');
2076:
2077: IF (is_debug_statement_on) THEN
2078: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2079: 'after call to OKL_AM_UTIL_PVT.get_lookup_meaning :'||l_return_status);
2080: END IF;
2081: -- Accepted quote QUOTE_NUMBER of quote type QUOTE_TYPE exists for
2082: -- asset ASSET_NUMBER. Cannot create another quote for the same asset.
2083: OKL_API.set_message (

Line 2098: OKL_AM_UTIL_PVT.get_contract_product_details(

2094:
2095: END IF;
2096:
2097: -- AKP:REPO-QUOTE-START Get the contract product details 6599890
2098: OKL_AM_UTIL_PVT.get_contract_product_details(
2099: p_khr_id => p_quot_rec.khr_id,
2100: x_deal_type => l_deal_type,
2101: x_rev_rec_method => l_rev_rec_method,
2102: x_int_cal_basis => l_int_cal_basis,

Line 2109: 'After call to OKL_AM_UTIL_PVT.get_contract_product_details :'||l_return_status);

2105:
2106:
2107: IF (is_debug_statement_on) THEN
2108: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2109: 'After call to OKL_AM_UTIL_PVT.get_contract_product_details :'||l_return_status);
2110: END IF;
2111:
2112:
2113: -- If error then throw exception

Line 2130: 'before call to OKL_AM_UTIL_PVT.get_contract_product_details :'||l_return_status);

2126: ) THEN
2127:
2128: IF (is_debug_statement_on) THEN
2129: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2130: 'before call to OKL_AM_UTIL_PVT.get_contract_product_details :'||l_return_status);
2131: END IF;
2132:
2133: -- AKP:REPO-QUOTE-START 6599890
2134: /* -- Get the contract product details

Line 2135: OKL_AM_UTIL_PVT.get_contract_product_details(

2131: END IF;
2132:
2133: -- AKP:REPO-QUOTE-START 6599890
2134: /* -- Get the contract product details
2135: OKL_AM_UTIL_PVT.get_contract_product_details(
2136: p_khr_id => p_quot_rec.khr_id,
2137: x_deal_type => l_deal_type,
2138: x_rev_rec_method => l_rev_rec_method,
2139: x_int_cal_basis => l_int_cal_basis,

Line 2146: 'After call to OKL_AM_UTIL_PVT.get_contract_product_details :'||l_return_status);

2142:
2143:
2144: IF (is_debug_statement_on) THEN
2145: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2146: 'After call to OKL_AM_UTIL_PVT.get_contract_product_details :'||l_return_status);
2147: END IF;
2148:
2149:
2150: -- If error then throw exception

Line 2223: OKL_AM_UTIL_PVT.get_contract_product_details(

2219: /* SECHAWLA 04-JAN-06 4915133 ; Moved this piece later in the code : move begin
2220: -- rmunjulu LOANS_ENHANCEMENTS 13-oct-05 moved this logic here.
2221: -- rmunjulu LOANS_ENHANCEMENTS Partial line termination for loans with Actual/Estimated Actual not allowed
2222: -- Get the contract product details
2223: OKL_AM_UTIL_PVT.get_contract_product_details(
2224: p_khr_id => p_quot_rec.khr_id,
2225: x_deal_type => l_deal_type,
2226: x_rev_rec_method => l_rev_rec_method,
2227: x_int_cal_basis => l_int_cal_basis,

Line 2264: 'before call to OKL_AM_UTIL_PVT.get_contract_product_details :'||l_return_status);

2260: IF (p_assn_tbl.COUNT < p_no_of_assets) OR (l_partial_asset_line) THEN
2261:
2262: IF (is_debug_statement_on) THEN
2263: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2264: 'before call to OKL_AM_UTIL_PVT.get_contract_product_details :'||l_return_status);
2265: END IF;
2266:
2267: -- Moved the above valdation here under this IF condition
2268: -- Get the contract product details

Line 2269: OKL_AM_UTIL_PVT.get_contract_product_details(

2265: END IF;
2266:
2267: -- Moved the above valdation here under this IF condition
2268: -- Get the contract product details
2269: OKL_AM_UTIL_PVT.get_contract_product_details(
2270: p_khr_id => p_quot_rec.khr_id,
2271: x_deal_type => l_deal_type,
2272: x_rev_rec_method => l_rev_rec_method,
2273: x_int_cal_basis => l_int_cal_basis,

Line 2279: 'After call to OKL_AM_UTIL_PVT.get_contract_product_details :'||l_return_status);

2275: x_return_status => l_return_status);
2276:
2277: IF (is_debug_statement_on) THEN
2278: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2279: 'After call to OKL_AM_UTIL_PVT.get_contract_product_details :'||l_return_status);
2280: END IF;
2281:
2282: -- If error then throw exception
2283: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN

Line 2335: l_icb_meaning := OKL_AM_UTIL_PVT.get_lookup_meaning(

2331: --Bug# 13447258: Partial Line Termination is not allowed for Float and Catchup-Cleanup Loan contracts
2332: IF l_partial_asset_line THEN
2333: IF l_int_cal_basis IN ('FLOAT','CATCHUP/CLEANUP') THEN
2334:
2335: l_icb_meaning := OKL_AM_UTIL_PVT.get_lookup_meaning(
2336: 'OKL_INTEREST_CALCULATION_BASIS',
2337: l_int_cal_basis,
2338: 'Y');
2339:

Line 2751: OKL_AM_UTIL_PVT.get_func_currency_org(

2747: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begins(+)');
2748: END IF;
2749:
2750: -- Get the functional currency from AM_Util
2751: OKL_AM_UTIL_PVT.get_func_currency_org(
2752: x_org_id => l_org_id,
2753: x_currency_code => l_functional_currency_code);
2754:
2755: IF (is_debug_statement_on) THEN

Line 2757: 'after call to OKL_AM_UTIL_PVT.get_func_currency_org :l_org_id :'||l_org_id);

2753: x_currency_code => l_functional_currency_code);
2754:
2755: IF (is_debug_statement_on) THEN
2756: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2757: 'after call to OKL_AM_UTIL_PVT.get_func_currency_org :l_org_id :'||l_org_id);
2758: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2759: 'after call to OKL_AM_UTIL_PVT.get_func_currency_org :l_functional_currency_code :'||l_functional_currency_code);
2760: END IF;
2761:

Line 2759: 'after call to OKL_AM_UTIL_PVT.get_func_currency_org :l_functional_currency_code :'||l_functional_currency_code);

2755: IF (is_debug_statement_on) THEN
2756: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2757: 'after call to OKL_AM_UTIL_PVT.get_func_currency_org :l_org_id :'||l_org_id);
2758: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2759: 'after call to OKL_AM_UTIL_PVT.get_func_currency_org :l_functional_currency_code :'||l_functional_currency_code);
2760: END IF;
2761:
2762:
2763: -- Get the currency conversion details from ACCOUNTING_Util

Line 2888: l_rule_khr_id := okl_am_util_pvt.get_rule_chr_id (l_qtev_rec);

2884: l_rgd_code := 'AMTGAL';
2885: END IF;
2886:
2887: --get the rule attributes
2888: l_rule_khr_id := okl_am_util_pvt.get_rule_chr_id (l_qtev_rec);
2889:
2890: IF (is_debug_statement_on) THEN
2891: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2892: 'Before call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);

Line 2892: 'Before call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);

2888: l_rule_khr_id := okl_am_util_pvt.get_rule_chr_id (l_qtev_rec);
2889:
2890: IF (is_debug_statement_on) THEN
2891: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2892: 'Before call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);
2893: END IF;
2894:
2895: OKL_AM_UTIL_PVT.get_rule_record(
2896: p_rgd_code => l_rgd_code,

Line 2895: OKL_AM_UTIL_PVT.get_rule_record(

2891: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2892: 'Before call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);
2893: END IF;
2894:
2895: OKL_AM_UTIL_PVT.get_rule_record(
2896: p_rgd_code => l_rgd_code,
2897: p_rdf_code => l_rule_code,
2898: p_chr_id => l_rule_khr_id,
2899: p_cle_id => NULL,

Line 2906: 'after call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);

2902: p_message_yn => FALSE);
2903:
2904: IF (is_debug_statement_on) THEN
2905: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2906: 'after call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);
2907: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2908: 'l_rgd_code :'||l_rgd_code);
2909: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2910: 'l_rule_code :'||l_rule_code);

Line 2947: 'Before call to OKL_AM_UTIL_PVT.get_formula_value :'||l_return_status);

2943:
2944: --+++++++++ rmunjulu 3797384 Future Dated Term Qte -- End ++++++++++++++++
2945: IF (is_debug_statement_on) THEN
2946: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2947: 'Before call to OKL_AM_UTIL_PVT.get_formula_value :'||l_return_status);
2948: END IF;
2949: -- Get the formula value for the formula for Net Gain/Loss Formula
2950: OKL_AM_UTIL_PVT.get_formula_value (
2951: p_formula_name => l_formula_name,

Line 2950: OKL_AM_UTIL_PVT.get_formula_value (

2946: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2947: 'Before call to OKL_AM_UTIL_PVT.get_formula_value :'||l_return_status);
2948: END IF;
2949: -- Get the formula value for the formula for Net Gain/Loss Formula
2950: OKL_AM_UTIL_PVT.get_formula_value (
2951: p_formula_name => l_formula_name,
2952: p_chr_id => l_rule_khr_id,
2953: p_cle_id => NULL,
2954: p_additional_parameters => l_params,

Line 2959: 'after call to OKL_AM_UTIL_PVT.get_formula_value :'||l_return_status);

2955: x_formula_value => x_net_gain_loss,
2956: x_return_status => l_return_status);
2957: IF (is_debug_statement_on) THEN
2958: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2959: 'after call to OKL_AM_UTIL_PVT.get_formula_value :'||l_return_status);
2960: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2961: 'l_formula_name :'||l_formula_name);
2962: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2963: 'l_rule_khr_id :'||l_rule_khr_id);

Line 3338: l_rule_chr_id := okl_am_util_pvt.get_rule_chr_id (lp_quot_rec);

3334: END IF;
3335:
3336: -- SECHAWLA 18-FEB-03 Bug # 2807201 : end moved code
3337:
3338: l_rule_chr_id := okl_am_util_pvt.get_rule_chr_id (lp_quot_rec);
3339:
3340: -- SECHAWLA 28-FEB-03 Bug # 2757175 : Added a not null validation for l_rule_chr_id
3341: IF l_rule_chr_id IS NULL THEN
3342: x_return_status := OKL_API.G_RET_STS_ERROR;

Line 3691: 'before call to OKL_AM_UTIL_PVT.get_formula_value :'||l_return_status);

3687: l_params(1).value := lp_quot_rec.id;
3688:
3689: IF (is_debug_statement_on) THEN
3690: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
3691: 'before call to OKL_AM_UTIL_PVT.get_formula_value :'||l_return_status);
3692: END IF;
3693:
3694: -- rmunjulu LOANS_ENHANCEMENTS Evaluate Quote perdiem amount formula and set quote perdiem value
3695: OKL_AM_UTIL_PVT.get_formula_value(

Line 3695: OKL_AM_UTIL_PVT.get_formula_value(

3691: 'before call to OKL_AM_UTIL_PVT.get_formula_value :'||l_return_status);
3692: END IF;
3693:
3694: -- rmunjulu LOANS_ENHANCEMENTS Evaluate Quote perdiem amount formula and set quote perdiem value
3695: OKL_AM_UTIL_PVT.get_formula_value(
3696: p_formula_name => 'QUOTE_PERDIEM_AMOUNT',
3697: p_chr_id => lx_quot_rec.khr_id,
3698: p_cle_id => NULL,
3699: p_additional_parameters => l_params,

Line 3705: 'After call to OKL_AM_UTIL_PVT.get_formula_value :'||l_return_status);

3701: x_return_status => l_return_status);
3702:
3703: IF (is_debug_statement_on) THEN
3704: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
3705: 'After call to OKL_AM_UTIL_PVT.get_formula_value :'||l_return_status);
3706: END IF;
3707:
3708: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3709: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3777: OKL_AM_UTIL_PVT.process_messages (

3773:
3774: /* -- rmunjulu messages come twice so this fix
3775: -- rmunjulu TNA 4059175 Added process message here to get the messages
3776: -- Save messages in database
3777: OKL_AM_UTIL_PVT.process_messages (
3778: p_trx_source_table => 'OKL_TRX_QUOTES_V',
3779: p_trx_id => lx_quot_rec.id,
3780: x_return_status => l_return_status);
3781:

Line 3826: 'Before call to OKL_AM_UTIL_PVT.process_messages :'||l_return_status);

3822: -- Save messages in database
3823:
3824: IF (is_debug_statement_on) THEN
3825: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
3826: 'Before call to OKL_AM_UTIL_PVT.process_messages :'||l_return_status);
3827: END IF;
3828:
3829: OKL_AM_UTIL_PVT.process_messages (
3830: p_trx_source_table => 'OKL_TRX_QUOTES_V',

Line 3829: OKL_AM_UTIL_PVT.process_messages (

3825: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
3826: 'Before call to OKL_AM_UTIL_PVT.process_messages :'||l_return_status);
3827: END IF;
3828:
3829: OKL_AM_UTIL_PVT.process_messages (
3830: p_trx_source_table => 'OKL_TRX_QUOTES_V',
3831: p_trx_id => lx_quot_rec.id,
3832: x_return_status => l_return_status);
3833:

Line 3850: 'Before call to okl_am_util_pvt.get_user_profile_option_name :'||l_return_status);

3846:
3847:
3848: IF (is_debug_statement_on) THEN
3849: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
3850: 'Before call to okl_am_util_pvt.get_user_profile_option_name :'||l_return_status);
3851: END IF;
3852:
3853: l_user_profile_name := okl_am_util_pvt.get_user_profile_option_name(
3854: p_profile_option_name => 'OKL_MANUAL_TERMINATION_QUOTE_REP',

Line 3853: l_user_profile_name := okl_am_util_pvt.get_user_profile_option_name(

3849: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
3850: 'Before call to okl_am_util_pvt.get_user_profile_option_name :'||l_return_status);
3851: END IF;
3852:
3853: l_user_profile_name := okl_am_util_pvt.get_user_profile_option_name(
3854: p_profile_option_name => 'OKL_MANUAL_TERMINATION_QUOTE_REP',
3855: x_return_status => l_return_status);
3856:
3857: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN

Line 3910: OKL_AM_UTIL_PVT.process_messages (

3906: p_transaction_id => lx_quot_rec.id,
3907: p_event_name => 'oracle.apps.okl.am.manualquote'); -- SECHAWLA 02-JAN-03 2724951 Changed the event name
3908:
3909: -- Save messages in database
3910: OKL_AM_UTIL_PVT.process_messages (
3911: p_trx_source_table => 'OKL_TRX_QUOTES_V',
3912: p_trx_id => lx_quot_rec.id,
3913: x_return_status => l_return_status);
3914:

Line 3918: OKL_AM_UTIL_PVT.process_messages (

3914:
3915: ELSE -- if not auto to manual -- rmunjulu TNA 4059175 Added this if
3916:
3917: -- Save messages in database
3918: OKL_AM_UTIL_PVT.process_messages (
3919: p_trx_source_table => 'OKL_TRX_QUOTES_V',
3920: p_trx_id => lx_quot_rec.id,
3921: x_return_status => l_return_status);
3922:

Line 3966: OKL_AM_UTIL_PVT.process_messages (

3962: RAISE OKL_API.G_EXCEPTION_ERROR;
3963: END IF;
3964:
3965: -- Save messages in database
3966: OKL_AM_UTIL_PVT.process_messages (
3967: p_trx_source_table => 'OKL_TRX_QUOTES_V',
3968: p_trx_id => lx_quot_rec.id,
3969: x_return_status => l_return_status);
3970: