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_EC_EVALUATE_PVT dependencies on OKL_API

Line 15: l_return_value varchar2(200) := okl_api.g_miss_char;

11: SELECT meaning
12: FROM fnd_lookups fnd
13: WHERE fnd.lookup_type = p_lookup_type
14: AND fnd.lookup_code = p_lookup_code;
15: l_return_value varchar2(200) := okl_api.g_miss_char;
16: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.get_lookup_meaning';
17: l_debug_enabled varchar2(10);
18: is_debug_procedure_on boolean;
19: is_debug_statement_on boolean;

Line 1138: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false

1134: **/
1135:
1136: PROCEDURE validate(
1137: p_api_version IN number
1138: ,p_init_msg_list IN varchar2 DEFAULT okl_api.g_false
1139: ,x_return_status OUT nocopy varchar2
1140: ,x_msg_count OUT nocopy number
1141: ,x_msg_data OUT nocopy varchar2
1142: ,p_okl_ec_rec IN OUT nocopy okl_ec_rec_type

Line 1194: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

1190: l_varchar_value_tbl okl_varchar2_table_type;
1191: l_ec_values_tbl okl_ec_values_tbl_type;
1192: l_num_value_tbl okl_number_table_type;
1193: l_api_version CONSTANT number := 1.0;
1194: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
1195: l_msg_count number;
1196: l_msg_data varchar2(2000);
1197: l_init_msg_list varchar2(1) DEFAULT OKL_API.G_FALSE;
1198: l_function_name okl_data_src_fnctns_v.name%TYPE;

Line 1197: l_init_msg_list varchar2(1) DEFAULT OKL_API.G_FALSE;

1193: l_api_version CONSTANT number := 1.0;
1194: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
1195: l_msg_count number;
1196: l_msg_data varchar2(2000);
1197: l_init_msg_list varchar2(1) DEFAULT OKL_API.G_FALSE;
1198: l_function_name okl_data_src_fnctns_v.name%TYPE;
1199: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.validate';
1200: l_debug_enabled varchar2(10);
1201: is_debug_procedure_on boolean;

Line 1303: x_return_status := okl_api.g_ret_sts_success;

1299: ,l_module
1300: ,'end debug OKLRECUB.pls.pls call validate');
1301: END IF;
1302: x_eligible := true;
1303: x_return_status := okl_api.g_ret_sts_success;
1304: RETURN;
1305: END IF;
1306: IF (ec_tbl(i).mc_hdr = 'ALL' AND fun_ret = 0) THEN
1307: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 1313: x_return_status := okl_api.g_ret_sts_success;

1309: ,l_module
1310: ,'end debug OKLRECUB.pls.pls call validate');
1311: END IF;
1312: x_eligible := false;
1313: x_return_status := okl_api.g_ret_sts_success;
1314: RETURN;
1315: END IF;
1316: END IF;
1317: IF p_okl_ec_rec.validation_mode = 'QA' THEN

Line 1371: x_return_status := okl_api.g_ret_sts_success;

1367: ,l_module
1368: ,'end debug OKLRECUB.pls.pls call validate');
1369: END IF;
1370: x_eligible := true;
1371: x_return_status := okl_api.g_ret_sts_success;
1372: RETURN;
1373: END IF;
1374: IF (ec_tbl(i).mc_hdr = 'ALL' AND fun_ret = 0) THEN
1375: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 1381: x_return_status := okl_api.g_ret_sts_success;

1377: ,l_module
1378: ,'end debug OKLRECUB.pls.pls call validate');
1379: END IF;
1380: x_eligible := false;
1381: x_return_status := okl_api.g_ret_sts_success;
1382: RETURN;
1383: END IF;
1384: END IF;
1385: IF p_okl_ec_rec.validation_mode = 'QA' THEN

Line 1435: x_return_status := okl_api.g_ret_sts_success;

1431: ,l_module
1432: ,'end debug OKLRECUB.pls.pls call validate');
1433: END IF;
1434: x_eligible := true;
1435: x_return_status := okl_api.g_ret_sts_success;
1436: RETURN;
1437: END IF;
1438: IF (ec_tbl(i).mc_hdr = 'ALL' AND fun_ret = 0) THEN
1439: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 1445: x_return_status := okl_api.g_ret_sts_success;

1441: ,l_module
1442: ,'end debug OKLRECUB.pls.pls call validate');
1443: END IF;
1444: x_eligible := false;
1445: x_return_status := okl_api.g_ret_sts_success;
1446: RETURN;
1447: END IF;
1448: END IF;
1449: IF p_okl_ec_rec.validation_mode = 'QA' THEN

Line 1509: x_return_status := okl_api.g_ret_sts_success;

1505: ,l_module
1506: ,'end debug OKLRECUB.pls.pls call validate');
1507: END IF;
1508: x_eligible := true;
1509: x_return_status := okl_api.g_ret_sts_success;
1510: RETURN;
1511: END IF;
1512: IF (ec_tbl(i).mc_hdr = 'ALL' AND fun_ret = 0) THEN
1513: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 1519: x_return_status := okl_api.g_ret_sts_success;

1515: ,l_module
1516: ,'end debug OKLRECUB.pls.pls call validate');
1517: END IF;
1518: x_eligible := false;
1519: x_return_status := okl_api.g_ret_sts_success;
1520: RETURN;
1521: END IF;
1522: END IF;
1523: IF p_okl_ec_rec.validation_mode = 'QA' THEN

Line 1577: x_return_status := okl_api.g_ret_sts_success;

1573: ,l_module
1574: ,'end debug OKLRECUB.pls.pls call validate');
1575: END IF;
1576: x_eligible := true;
1577: x_return_status := okl_api.g_ret_sts_success;
1578: RETURN;
1579: END IF;
1580: IF (ec_tbl(i).mc_hdr = 'ALL' AND fun_ret = 0) THEN
1581: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 1587: x_return_status := okl_api.g_ret_sts_success;

1583: ,l_module
1584: ,'end debug OKLRECUB.pls.pls call validate');
1585: END IF;
1586: x_eligible := false;
1587: x_return_status := okl_api.g_ret_sts_success;
1588: RETURN;
1589: END IF;
1590: END IF;
1591: IF p_okl_ec_rec.validation_mode = 'QA' THEN

Line 1641: x_return_status := okl_api.g_ret_sts_success;

1637: ,l_module
1638: ,'end debug OKLRECUB.pls.pls call validate');
1639: END IF;
1640: x_eligible := true;
1641: x_return_status := okl_api.g_ret_sts_success;
1642: RETURN;
1643: END IF;
1644: IF (ec_tbl(i).mc_hdr = 'ALL' AND fun_ret = 0) THEN
1645: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 1651: x_return_status := okl_api.g_ret_sts_success;

1647: ,l_module
1648: ,'end debug OKLRECUB.pls.pls call validate');
1649: END IF;
1650: x_eligible := false;
1651: x_return_status := okl_api.g_ret_sts_success;
1652: RETURN;
1653: END IF;
1654: END IF;
1655: IF p_okl_ec_rec.validation_mode = 'QA' THEN

Line 1712: x_return_status := okl_api.g_ret_sts_success;

1708: ,l_module
1709: ,'end debug OKLRECUB.pls.pls call validate');
1710: END IF;
1711: x_eligible := true;
1712: x_return_status := okl_api.g_ret_sts_success;
1713: RETURN;
1714: END IF;
1715: IF (ec_tbl(i).mc_hdr = 'ALL' AND fun_ret = 0) THEN
1716: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 1722: x_return_status := okl_api.g_ret_sts_success;

1718: ,l_module
1719: ,'end debug OKLRECUB.pls.pls call validate');
1720: END IF;
1721: x_eligible := false;
1722: x_return_status := okl_api.g_ret_sts_success;
1723: RETURN;
1724: END IF;
1725: END IF;
1726: IF p_okl_ec_rec.validation_mode = 'QA' THEN

Line 1776: x_return_status := okl_api.g_ret_sts_success;

1772: ,l_module
1773: ,'end debug OKLRECUB.pls.pls call validate');
1774: END IF;
1775: x_eligible := true;
1776: x_return_status := okl_api.g_ret_sts_success;
1777: RETURN;
1778: END IF;
1779: IF (ec_tbl(i).mc_hdr = 'ALL' AND fun_ret = 0) THEN
1780: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 1786: x_return_status := okl_api.g_ret_sts_success;

1782: ,l_module
1783: ,'end debug OKLRECUB.pls.pls call validate');
1784: END IF;
1785: x_eligible := false;
1786: x_return_status := okl_api.g_ret_sts_success;
1787: RETURN;
1788: END IF;
1789: END IF;
1790: IF p_okl_ec_rec.validation_mode = 'QA' THEN

Line 1841: x_return_status := okl_api.g_ret_sts_success;

1837: ,l_module
1838: ,'end debug OKLRECUB.pls.pls call validate');
1839: END IF;
1840: x_eligible := true;
1841: x_return_status := okl_api.g_ret_sts_success;
1842: RETURN;
1843: END IF;
1844: IF (ec_tbl(i).mc_hdr = 'ALL' AND fun_ret = 0) THEN
1845: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 1851: x_return_status := okl_api.g_ret_sts_success;

1847: ,l_module
1848: ,'end debug OKLRECUB.pls.pls call validate');
1849: END IF;
1850: x_eligible := false;
1851: x_return_status := okl_api.g_ret_sts_success;
1852: RETURN;
1853: END IF;
1854: END IF;
1855: IF p_okl_ec_rec.validation_mode = 'QA' THEN

Line 1930: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

1926: ' x_msg_data ' ||
1927: x_msg_data);
1928: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
1929:
1930: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1931: RAISE okl_api.g_exception_unexpected_error;
1932: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1933: RAISE okl_api.g_exception_error;
1934: END IF;

Line 1931: RAISE okl_api.g_exception_unexpected_error;

1927: x_msg_data);
1928: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
1929:
1930: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1931: RAISE okl_api.g_exception_unexpected_error;
1932: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1933: RAISE okl_api.g_exception_error;
1934: END IF;
1935:

Line 1932: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

1928: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
1929:
1930: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1931: RAISE okl_api.g_exception_unexpected_error;
1932: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1933: RAISE okl_api.g_exception_error;
1934: END IF;
1935:
1936: IF p_okl_ec_rec.validation_mode = 'LOV' THEN

Line 1933: RAISE okl_api.g_exception_error;

1929:
1930: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
1931: RAISE okl_api.g_exception_unexpected_error;
1932: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
1933: RAISE okl_api.g_exception_error;
1934: END IF;
1935:
1936: IF p_okl_ec_rec.validation_mode = 'LOV' THEN
1937: IF (ec_tbl(i).mc_hdr = 'ONE' AND fun_ret = 1) THEN

Line 1944: x_return_status := okl_api.g_ret_sts_success;

1940: ,l_module
1941: ,'end debug OKLRECUB.pls.pls call validate');
1942: END IF;
1943: x_eligible := true;
1944: x_return_status := okl_api.g_ret_sts_success;
1945: RETURN;
1946: END IF;
1947: IF (ec_tbl(i).mc_hdr = 'ALL' AND fun_ret = 0) THEN
1948: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN

Line 1954: x_return_status := okl_api.g_ret_sts_success;

1950: ,l_module
1951: ,'end debug OKLRECUB.pls.pls call validate');
1952: END IF;
1953: x_eligible := false;
1954: x_return_status := okl_api.g_ret_sts_success;
1955: RETURN;
1956: END IF;
1957: END IF;
1958: IF p_okl_ec_rec.validation_mode = 'QA' THEN

Line 1994: x_return_status := okl_api.g_ret_sts_success;

1990: okl_debug_pub.log_debug(fnd_log.level_procedure
1991: ,l_module
1992: ,'end debug OKLRECUB.pls.pls call validate');
1993: END IF;
1994: x_return_status := okl_api.g_ret_sts_success;
1995: x_eligible := true;
1996: ELSE
1997: IF (l_debug_enabled = 'Y' AND is_debug_procedure_on) THEN
1998: okl_debug_pub.log_debug(fnd_log.level_procedure

Line 2002: x_return_status := okl_api.g_ret_sts_success;

1998: okl_debug_pub.log_debug(fnd_log.level_procedure
1999: ,l_module
2000: ,'end debug OKLRECUB.pls.pls call validate');
2001: END IF;
2002: x_return_status := okl_api.g_ret_sts_success;
2003: x_eligible := false;
2004: END IF;
2005:
2006: EXCEPTION

Line 2007: WHEN okl_api.g_exception_error THEN

2003: x_eligible := false;
2004: END IF;
2005:
2006: EXCEPTION
2007: WHEN okl_api.g_exception_error THEN
2008: IF get_ec%ISOPEN THEN
2009: CLOSE get_ec;
2010: END IF;
2011:

Line 2015: x_return_status := okl_api.g_ret_sts_error;

2011:
2012: IF get_ec_values%ISOPEN THEN
2013: CLOSE get_ec_values;
2014: END IF;
2015: x_return_status := okl_api.g_ret_sts_error;
2016:
2017: WHEN okl_api.g_exception_unexpected_error THEN
2018: IF get_ec%ISOPEN THEN
2019: CLOSE get_ec;

Line 2017: WHEN okl_api.g_exception_unexpected_error THEN

2013: CLOSE get_ec_values;
2014: END IF;
2015: x_return_status := okl_api.g_ret_sts_error;
2016:
2017: WHEN okl_api.g_exception_unexpected_error THEN
2018: IF get_ec%ISOPEN THEN
2019: CLOSE get_ec;
2020: END IF;
2021:

Line 2025: x_return_status := okl_api.g_ret_sts_unexp_error;

2021:
2022: IF get_ec_values%ISOPEN THEN
2023: CLOSE get_ec_values;
2024: END IF;
2025: x_return_status := okl_api.g_ret_sts_unexp_error;
2026:
2027: WHEN OTHERS THEN
2028:
2029: IF get_ec%ISOPEN THEN

Line 2037: OKL_API.set_message(p_app_name => g_app_name,

2033: IF get_ec_values%ISOPEN THEN
2034: CLOSE get_ec_values;
2035: END IF;
2036: -- unexpected error
2037: OKL_API.set_message(p_app_name => g_app_name,
2038: p_msg_name => g_unexpected_error,
2039: p_token1 => g_sqlcode_token,
2040: p_token1_value => sqlcode,
2041: p_token2 => g_sqlerrm_token,

Line 2057: ,P_init_msg_list In varchar2 Default Okl_api.G_false

2053: **/
2054:
2055: PROCEDURE get_adjustment_factor(
2056: p_api_version In number
2057: ,P_init_msg_list In varchar2 Default Okl_api.G_false
2058: ,x_return_status Out Nocopy varchar2
2059: ,x_msg_count Out Nocopy number
2060: ,x_msg_data Out Nocopy varchar2
2061: ,p_okl_ac_rec In okl_ac_rec_type

Line 2111: l_return_status varchar2(1) := okl_api.g_ret_sts_success;

2107: l_adjustment_factors_tbl okl_number_table_type;
2108: l_ac_values_tbl okl_ec_values_tbl_type;
2109: l_adj_fctr number;
2110: l_api_version CONSTANT number := 1.0;
2111: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
2112: l_msg_count number;
2113: l_msg_data varchar2(2000);
2114: l_init_msg_list varchar2(1) DEFAULT OKL_API.G_FALSE;
2115: l_function_name okl_data_src_fnctns_v.name%TYPE;

Line 2114: l_init_msg_list varchar2(1) DEFAULT OKL_API.G_FALSE;

2110: l_api_version CONSTANT number := 1.0;
2111: l_return_status varchar2(1) := okl_api.g_ret_sts_success;
2112: l_msg_count number;
2113: l_msg_data varchar2(2000);
2114: l_init_msg_list varchar2(1) DEFAULT OKL_API.G_FALSE;
2115: l_function_name okl_data_src_fnctns_v.name%TYPE;
2116: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.okl_ec_evaluate_pvt.get_adjustment_factor';
2117: l_debug_enabled varchar2(10);
2118: is_debug_procedure_on boolean;

Line 2314: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN

2310: ' x_msg_data ' ||
2311: l_msg_data);
2312: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
2313:
2314: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2315: RAISE okl_api.g_exception_unexpected_error;
2316: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2317: RAISE okl_api.g_exception_error;
2318: END IF;

Line 2315: RAISE okl_api.g_exception_unexpected_error;

2311: l_msg_data);
2312: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
2313:
2314: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2315: RAISE okl_api.g_exception_unexpected_error;
2316: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2317: RAISE okl_api.g_exception_error;
2318: END IF;
2319:

Line 2316: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN

2312: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
2313:
2314: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2315: RAISE okl_api.g_exception_unexpected_error;
2316: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2317: RAISE okl_api.g_exception_error;
2318: END IF;
2319:
2320: IF fun_ret <> 0 AND l_adjustment_factors_tbl.EXISTS(fun_ret) THEN

Line 2317: RAISE okl_api.g_exception_error;

2313:
2314: IF (l_return_status = okl_api.g_ret_sts_unexp_error) THEN
2315: RAISE okl_api.g_exception_unexpected_error;
2316: ELSIF (l_return_status = okl_api.g_ret_sts_error) THEN
2317: RAISE okl_api.g_exception_error;
2318: END IF;
2319:
2320: IF fun_ret <> 0 AND l_adjustment_factors_tbl.EXISTS(fun_ret) THEN
2321: l_adjustment_factor := l_adjustment_factor + l_adjustment_factors_tbl(fun_ret);

Line 2335: x_return_status := okl_api.g_ret_sts_success;

2331: ,l_module
2332: ,'end debug OKLRECUB.pls.pls call get_adjustment_factor');
2333: END IF;
2334: x_adjustment_factor := l_adjustment_factor;
2335: x_return_status := okl_api.g_ret_sts_success;
2336:
2337: EXCEPTION
2338: WHEN okl_api.g_exception_error THEN
2339: IF get_ac%ISOPEN THEN

Line 2338: WHEN okl_api.g_exception_error THEN

2334: x_adjustment_factor := l_adjustment_factor;
2335: x_return_status := okl_api.g_ret_sts_success;
2336:
2337: EXCEPTION
2338: WHEN okl_api.g_exception_error THEN
2339: IF get_ac%ISOPEN THEN
2340: CLOSE get_ac;
2341: END IF;
2342:

Line 2346: x_return_status := okl_api.g_ret_sts_error;

2342:
2343: IF get_ac_values%ISOPEN THEN
2344: CLOSE get_ac_values;
2345: END IF;
2346: x_return_status := okl_api.g_ret_sts_error;
2347:
2348: WHEN okl_api.g_exception_unexpected_error THEN
2349: IF get_ac%ISOPEN THEN
2350: CLOSE get_ac;

Line 2348: WHEN okl_api.g_exception_unexpected_error THEN

2344: CLOSE get_ac_values;
2345: END IF;
2346: x_return_status := okl_api.g_ret_sts_error;
2347:
2348: WHEN okl_api.g_exception_unexpected_error THEN
2349: IF get_ac%ISOPEN THEN
2350: CLOSE get_ac;
2351: END IF;
2352:

Line 2356: x_return_status := okl_api.g_ret_sts_unexp_error;

2352:
2353: IF get_ac_values%ISOPEN THEN
2354: CLOSE get_ac_values;
2355: END IF;
2356: x_return_status := okl_api.g_ret_sts_unexp_error;
2357:
2358: WHEN OTHERS THEN
2359:
2360: IF get_ac%ISOPEN THEN

Line 2368: OKL_API.set_message(p_app_name => g_app_name,

2364: IF get_ac_values%ISOPEN THEN
2365: CLOSE get_ac_values;
2366: END IF;
2367: -- unexpected error
2368: OKL_API.set_message(p_app_name => g_app_name,
2369: p_msg_name => g_unexpected_error,
2370: p_token1 => g_sqlcode_token,
2371: p_token1_value => sqlcode,
2372: p_token2 => g_sqlerrm_token,