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 1625: lx_quote_tbl OKL_AM_UTIL_PVT.quote_tbl_type;

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

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

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

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

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

Line 2042: OKL_AM_UTIL_PVT.get_line_quotes (

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

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

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

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

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

Line 2068: l_quote_type := OKL_AM_UTIL_PVT.get_lookup_meaning(

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

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

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

Line 2094: OKL_AM_UTIL_PVT.get_contract_product_details(

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

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

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

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

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

Line 2131: OKL_AM_UTIL_PVT.get_contract_product_details(

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

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

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

Line 2219: OKL_AM_UTIL_PVT.get_contract_product_details(

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

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

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

Line 2265: OKL_AM_UTIL_PVT.get_contract_product_details(

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

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

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

Line 2697: OKL_AM_UTIL_PVT.get_func_currency_org(

2693: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'Begins(+)');
2694: END IF;
2695:
2696: -- Get the functional currency from AM_Util
2697: OKL_AM_UTIL_PVT.get_func_currency_org(
2698: x_org_id => l_org_id,
2699: x_currency_code => l_functional_currency_code);
2700:
2701: IF (is_debug_statement_on) THEN

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

2699: x_currency_code => l_functional_currency_code);
2700:
2701: IF (is_debug_statement_on) THEN
2702: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2703: 'after call to OKL_AM_UTIL_PVT.get_func_currency_org :l_org_id :'||l_org_id);
2704: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2705: 'after call to OKL_AM_UTIL_PVT.get_func_currency_org :l_functional_currency_code :'||l_functional_currency_code);
2706: END IF;
2707:

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

2701: IF (is_debug_statement_on) THEN
2702: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2703: 'after call to OKL_AM_UTIL_PVT.get_func_currency_org :l_org_id :'||l_org_id);
2704: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2705: 'after call to OKL_AM_UTIL_PVT.get_func_currency_org :l_functional_currency_code :'||l_functional_currency_code);
2706: END IF;
2707:
2708:
2709: -- Get the currency conversion details from ACCOUNTING_Util

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

2830: l_rgd_code := 'AMTGAL';
2831: END IF;
2832:
2833: --get the rule attributes
2834: l_rule_khr_id := okl_am_util_pvt.get_rule_chr_id (l_qtev_rec);
2835:
2836: IF (is_debug_statement_on) THEN
2837: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2838: 'Before call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);

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

2834: l_rule_khr_id := okl_am_util_pvt.get_rule_chr_id (l_qtev_rec);
2835:
2836: IF (is_debug_statement_on) THEN
2837: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2838: 'Before call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);
2839: END IF;
2840:
2841: OKL_AM_UTIL_PVT.get_rule_record(
2842: p_rgd_code => l_rgd_code,

Line 2841: OKL_AM_UTIL_PVT.get_rule_record(

2837: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2838: 'Before call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);
2839: END IF;
2840:
2841: OKL_AM_UTIL_PVT.get_rule_record(
2842: p_rgd_code => l_rgd_code,
2843: p_rdf_code => l_rule_code,
2844: p_chr_id => l_rule_khr_id,
2845: p_cle_id => NULL,

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

2848: p_message_yn => FALSE);
2849:
2850: IF (is_debug_statement_on) THEN
2851: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2852: 'after call to OKL_AM_UTIL_PVT.get_rule_record :'||l_return_status);
2853: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2854: 'l_rgd_code :'||l_rgd_code);
2855: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2856: 'l_rule_code :'||l_rule_code);

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

2889:
2890: --+++++++++ rmunjulu 3797384 Future Dated Term Qte -- End ++++++++++++++++
2891: IF (is_debug_statement_on) THEN
2892: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2893: 'Before call to OKL_AM_UTIL_PVT.get_formula_value :'||l_return_status);
2894: END IF;
2895: -- Get the formula value for the formula for Net Gain/Loss Formula
2896: OKL_AM_UTIL_PVT.get_formula_value (
2897: p_formula_name => l_formula_name,

Line 2896: OKL_AM_UTIL_PVT.get_formula_value (

2892: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2893: 'Before call to OKL_AM_UTIL_PVT.get_formula_value :'||l_return_status);
2894: END IF;
2895: -- Get the formula value for the formula for Net Gain/Loss Formula
2896: OKL_AM_UTIL_PVT.get_formula_value (
2897: p_formula_name => l_formula_name,
2898: p_chr_id => l_rule_khr_id,
2899: p_cle_id => NULL,
2900: p_additional_parameters => l_params,

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

2901: x_formula_value => x_net_gain_loss,
2902: x_return_status => l_return_status);
2903: IF (is_debug_statement_on) THEN
2904: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2905: 'after call to OKL_AM_UTIL_PVT.get_formula_value :'||l_return_status);
2906: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2907: 'l_formula_name :'||l_formula_name);
2908: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
2909: 'l_rule_khr_id :'||l_rule_khr_id);

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

3278: END IF;
3279:
3280: -- SECHAWLA 18-FEB-03 Bug # 2807201 : end moved code
3281:
3282: l_rule_chr_id := okl_am_util_pvt.get_rule_chr_id (lp_quot_rec);
3283:
3284: -- SECHAWLA 28-FEB-03 Bug # 2757175 : Added a not null validation for l_rule_chr_id
3285: IF l_rule_chr_id IS NULL THEN
3286: x_return_status := OKL_API.G_RET_STS_ERROR;

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

3631: l_params(1).value := lp_quot_rec.id;
3632:
3633: IF (is_debug_statement_on) THEN
3634: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
3635: 'before call to OKL_AM_UTIL_PVT.get_formula_value :'||l_return_status);
3636: END IF;
3637:
3638: -- rmunjulu LOANS_ENHANCEMENTS Evaluate Quote perdiem amount formula and set quote perdiem value
3639: OKL_AM_UTIL_PVT.get_formula_value(

Line 3639: OKL_AM_UTIL_PVT.get_formula_value(

3635: 'before call to OKL_AM_UTIL_PVT.get_formula_value :'||l_return_status);
3636: END IF;
3637:
3638: -- rmunjulu LOANS_ENHANCEMENTS Evaluate Quote perdiem amount formula and set quote perdiem value
3639: OKL_AM_UTIL_PVT.get_formula_value(
3640: p_formula_name => 'QUOTE_PERDIEM_AMOUNT',
3641: p_chr_id => lx_quot_rec.khr_id,
3642: p_cle_id => NULL,
3643: p_additional_parameters => l_params,

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

3645: x_return_status => l_return_status);
3646:
3647: IF (is_debug_statement_on) THEN
3648: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
3649: 'After call to OKL_AM_UTIL_PVT.get_formula_value :'||l_return_status);
3650: END IF;
3651:
3652: IF (l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
3653: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 3721: OKL_AM_UTIL_PVT.process_messages (

3717:
3718: /* -- rmunjulu messages come twice so this fix
3719: -- rmunjulu TNA 4059175 Added process message here to get the messages
3720: -- Save messages in database
3721: OKL_AM_UTIL_PVT.process_messages (
3722: p_trx_source_table => 'OKL_TRX_QUOTES_V',
3723: p_trx_id => lx_quot_rec.id,
3724: x_return_status => l_return_status);
3725:

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

3763: -- Save messages in database
3764:
3765: IF (is_debug_statement_on) THEN
3766: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
3767: 'Before call to OKL_AM_UTIL_PVT.process_messages :'||l_return_status);
3768: END IF;
3769:
3770: OKL_AM_UTIL_PVT.process_messages (
3771: p_trx_source_table => 'OKL_TRX_QUOTES_V',

Line 3770: OKL_AM_UTIL_PVT.process_messages (

3766: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
3767: 'Before call to OKL_AM_UTIL_PVT.process_messages :'||l_return_status);
3768: END IF;
3769:
3770: OKL_AM_UTIL_PVT.process_messages (
3771: p_trx_source_table => 'OKL_TRX_QUOTES_V',
3772: p_trx_id => lx_quot_rec.id,
3773: x_return_status => l_return_status);
3774:

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

3787:
3788:
3789: IF (is_debug_statement_on) THEN
3790: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
3791: 'Before call to okl_am_util_pvt.get_user_profile_option_name :'||l_return_status);
3792: END IF;
3793:
3794: l_user_profile_name := okl_am_util_pvt.get_user_profile_option_name(
3795: p_profile_option_name => 'OKL_MANUAL_TERMINATION_QUOTE_REP',

Line 3794: l_user_profile_name := okl_am_util_pvt.get_user_profile_option_name(

3790: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_STATEMENT,L_MODULE_NAME,
3791: 'Before call to okl_am_util_pvt.get_user_profile_option_name :'||l_return_status);
3792: END IF;
3793:
3794: l_user_profile_name := okl_am_util_pvt.get_user_profile_option_name(
3795: p_profile_option_name => 'OKL_MANUAL_TERMINATION_QUOTE_REP',
3796: x_return_status => l_return_status);
3797:
3798: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN

Line 3851: OKL_AM_UTIL_PVT.process_messages (

3847: p_transaction_id => lx_quot_rec.id,
3848: p_event_name => 'oracle.apps.okl.am.manualquote'); -- SECHAWLA 02-JAN-03 2724951 Changed the event name
3849:
3850: -- Save messages in database
3851: OKL_AM_UTIL_PVT.process_messages (
3852: p_trx_source_table => 'OKL_TRX_QUOTES_V',
3853: p_trx_id => lx_quot_rec.id,
3854: x_return_status => l_return_status);
3855:

Line 3859: OKL_AM_UTIL_PVT.process_messages (

3855:
3856: ELSE -- if not auto to manual -- rmunjulu TNA 4059175 Added this if
3857:
3858: -- Save messages in database
3859: OKL_AM_UTIL_PVT.process_messages (
3860: p_trx_source_table => 'OKL_TRX_QUOTES_V',
3861: p_trx_id => lx_quot_rec.id,
3862: x_return_status => l_return_status);
3863:

Line 3907: OKL_AM_UTIL_PVT.process_messages (

3903: RAISE OKL_API.G_EXCEPTION_ERROR;
3904: END IF;
3905:
3906: -- Save messages in database
3907: OKL_AM_UTIL_PVT.process_messages (
3908: p_trx_source_table => 'OKL_TRX_QUOTES_V',
3909: p_trx_id => lx_quot_rec.id,
3910: x_return_status => l_return_status);
3911: