1264: RAISE OKL_API.G_EXCEPTION_ERROR;
1265: END IF;
1266: IF l_all_lines_overriden = 'Y' THEN
1267: IF(l_debug_enabled='Y') THEN
1268: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
1269: ,'begin debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
1270: END IF;
1271: okl_lease_quote_cashflow_pvt.delete_cashflows(
1272: p_api_version => G_API_VERSION
1265: END IF;
1266: IF l_all_lines_overriden = 'Y' THEN
1267: IF(l_debug_enabled='Y') THEN
1268: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
1269: ,'begin debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
1270: END IF;
1271: okl_lease_quote_cashflow_pvt.delete_cashflows(
1272: p_api_version => G_API_VERSION
1273: ,p_init_msg_list => G_FALSE
1267: IF(l_debug_enabled='Y') THEN
1268: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
1269: ,'begin debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
1270: END IF;
1271: okl_lease_quote_cashflow_pvt.delete_cashflows(
1272: p_api_version => G_API_VERSION
1273: ,p_init_msg_list => G_FALSE
1274: ,p_transaction_control => G_FALSE
1275: ,p_source_object_code => 'LEASE_QUOTE'
1277: ,x_return_status => x_return_status
1278: ,x_msg_count => x_msg_count
1279: ,x_msg_data => x_msg_data);
1280: IF(l_debug_enabled='Y') THEN
1281: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
1282: ,'End debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
1283: END IF;
1284:
1285: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1278: ,x_msg_count => x_msg_count
1279: ,x_msg_data => x_msg_data);
1280: IF(l_debug_enabled='Y') THEN
1281: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
1282: ,'End debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
1283: END IF;
1284:
1285: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1286: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1310:
1311: IF (lv_cash_flow_exists = 'YES') THEN
1312:
1313: IF(l_debug_enabled='Y') THEN
1314: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow'
1315: ,'begin debug call update_cashflow');
1316: END IF;
1317: OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow (
1318: p_api_version => G_API_VERSION
1313: IF(l_debug_enabled='Y') THEN
1314: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow'
1315: ,'begin debug call update_cashflow');
1316: END IF;
1317: OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow (
1318: p_api_version => G_API_VERSION
1319: ,p_init_msg_list => G_FALSE
1320: ,p_transaction_control => G_FALSE
1321: ,p_cashflow_header_rec => l_payment_header_rec
1323: ,x_return_status => x_return_status
1324: ,x_msg_count => x_msg_count
1325: ,x_msg_data => x_msg_data);
1326: IF(l_debug_enabled='Y') THEN
1327: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow'
1328: ,'end debug call update_cashflow');
1329: END IF;
1330:
1331: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1334: RAISE OKL_API.G_EXCEPTION_ERROR;
1335: END IF;
1336: ELSE
1337: IF(l_debug_enabled='Y') THEN
1338: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow'
1339: ,'begin debug call create_cashflow');
1340: END IF;
1341: OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow (
1342: p_api_version => G_API_VERSION
1337: IF(l_debug_enabled='Y') THEN
1338: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow'
1339: ,'begin debug call create_cashflow');
1340: END IF;
1341: OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow (
1342: p_api_version => G_API_VERSION
1343: ,p_init_msg_list => G_FALSE
1344: ,p_transaction_control => G_FALSE
1345: ,p_cashflow_header_rec => l_payment_header_rec
1347: ,x_return_status => x_return_status
1348: ,x_msg_count => x_msg_count
1349: ,x_msg_data => x_msg_data);
1350: IF(l_debug_enabled='Y') THEN
1351: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow'
1352: ,'end debug call create_cashflow');
1353: END IF;
1354:
1355: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1624: RAISE OKL_API.G_EXCEPTION_ERROR;
1625: END IF;
1626:
1627: IF(l_debug_enabled='Y') THEN
1628: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
1629: ,'begin debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
1630: END IF;
1631: okl_lease_quote_cashflow_pvt.delete_cashflows(
1632: p_api_version => G_API_VERSION
1625: END IF;
1626:
1627: IF(l_debug_enabled='Y') THEN
1628: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
1629: ,'begin debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
1630: END IF;
1631: okl_lease_quote_cashflow_pvt.delete_cashflows(
1632: p_api_version => G_API_VERSION
1633: ,p_init_msg_list => G_FALSE
1627: IF(l_debug_enabled='Y') THEN
1628: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
1629: ,'begin debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
1630: END IF;
1631: okl_lease_quote_cashflow_pvt.delete_cashflows(
1632: p_api_version => G_API_VERSION
1633: ,p_init_msg_list => G_FALSE
1634: ,p_transaction_control => G_FALSE
1635: ,p_source_object_code => 'LEASE_QUOTE'
1637: ,x_return_status => x_return_status
1638: ,x_msg_count => x_msg_count
1639: ,x_msg_data => x_msg_data);
1640: IF(l_debug_enabled='Y') THEN
1641: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
1642: ,'End debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
1643: END IF;
1644:
1645: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1638: ,x_msg_count => x_msg_count
1639: ,x_msg_data => x_msg_data);
1640: IF(l_debug_enabled='Y') THEN
1641: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
1642: ,'End debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
1643: END IF;
1644:
1645: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1646: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1962: ELSE
1963: IF (lv_cash_flow_exists = 'YES') THEN
1964:
1965: IF(l_debug_enabled='Y') THEN
1966: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow'
1967: ,'begin debug call update_cashflow');
1968: END IF;
1969: OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow (
1970: p_api_version => G_API_VERSION
1965: IF(l_debug_enabled='Y') THEN
1966: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow'
1967: ,'begin debug call update_cashflow');
1968: END IF;
1969: OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow (
1970: p_api_version => G_API_VERSION
1971: ,p_init_msg_list => G_FALSE
1972: ,p_transaction_control => G_FALSE
1973: ,p_cashflow_header_rec => l_payment_header_rec
1975: ,x_return_status => x_return_status
1976: ,x_msg_count => x_msg_count
1977: ,x_msg_data => x_msg_data);
1978: IF(l_debug_enabled='Y') THEN
1979: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_CASHFLOW_PVT.update_cashflow'
1980: ,'end debug call update_cashflow');
1981: END IF;
1982:
1983: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
1987: END IF;
1988: ELSE
1989:
1990: IF(l_debug_enabled='Y') THEN
1991: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow'
1992: ,'begin debug call create_cashflow');
1993: END IF;
1994: OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow (
1995: p_api_version => G_API_VERSION
1990: IF(l_debug_enabled='Y') THEN
1991: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow'
1992: ,'begin debug call create_cashflow');
1993: END IF;
1994: OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow (
1995: p_api_version => G_API_VERSION
1996: ,p_init_msg_list => G_FALSE
1997: ,p_transaction_control => G_FALSE
1998: ,p_cashflow_header_rec => l_payment_header_rec
2000: ,x_return_status => x_return_status
2001: ,x_msg_count => x_msg_count
2002: ,x_msg_data => x_msg_data);
2003: IF(l_debug_enabled='Y') THEN
2004: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_CASHFLOW_PVT.create_cashflow'
2005: ,'end debug call create_cashflow');
2006: END IF;
2007:
2008: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2173: RAISE OKL_API.G_EXCEPTION_ERROR;
2174: END IF;
2175:
2176: IF(l_debug_enabled='Y') THEN
2177: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
2178: ,'begin debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
2179: END IF;
2180: okl_lease_quote_cashflow_pvt.delete_cashflows(
2181: p_api_version => G_API_VERSION
2174: END IF;
2175:
2176: IF(l_debug_enabled='Y') THEN
2177: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
2178: ,'begin debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
2179: END IF;
2180: okl_lease_quote_cashflow_pvt.delete_cashflows(
2181: p_api_version => G_API_VERSION
2182: ,p_init_msg_list => G_FALSE
2176: IF(l_debug_enabled='Y') THEN
2177: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
2178: ,'begin debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
2179: END IF;
2180: okl_lease_quote_cashflow_pvt.delete_cashflows(
2181: p_api_version => G_API_VERSION
2182: ,p_init_msg_list => G_FALSE
2183: ,p_transaction_control => G_FALSE
2184: ,p_source_object_code => 'QUOTED_FEE'
2186: ,x_return_status => x_return_status
2187: ,x_msg_count => x_msg_count
2188: ,x_msg_data => x_msg_data);
2189: IF(l_debug_enabled='Y') THEN
2190: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
2191: ,'End debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
2192: END IF;
2193:
2194: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2187: ,x_msg_count => x_msg_count
2188: ,x_msg_data => x_msg_data);
2189: IF(l_debug_enabled='Y') THEN
2190: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
2191: ,'End debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
2192: END IF;
2193:
2194: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2195: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2342: RAISE OKL_API.G_EXCEPTION_ERROR;
2343: END IF;
2344:
2345: IF(l_debug_enabled='Y') THEN
2346: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
2347: ,'begin debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
2348: END IF;
2349: okl_lease_quote_cashflow_pvt.delete_cashflows(
2350: p_api_version => G_API_VERSION
2343: END IF;
2344:
2345: IF(l_debug_enabled='Y') THEN
2346: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
2347: ,'begin debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
2348: END IF;
2349: okl_lease_quote_cashflow_pvt.delete_cashflows(
2350: p_api_version => G_API_VERSION
2351: ,p_init_msg_list => G_FALSE
2345: IF(l_debug_enabled='Y') THEN
2346: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
2347: ,'begin debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
2348: END IF;
2349: okl_lease_quote_cashflow_pvt.delete_cashflows(
2350: p_api_version => G_API_VERSION
2351: ,p_init_msg_list => G_FALSE
2352: ,p_transaction_control => G_FALSE
2353: ,p_source_object_code => 'QUOTED_ASSET'
2355: ,x_return_status => x_return_status
2356: ,x_msg_count => x_msg_count
2357: ,x_msg_data => x_msg_data);
2358: IF(l_debug_enabled='Y') THEN
2359: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
2360: ,'End debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
2361: END IF;
2362:
2363: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2356: ,x_msg_count => x_msg_count
2357: ,x_msg_data => x_msg_data);
2358: IF(l_debug_enabled='Y') THEN
2359: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.okl_lease_quote_cashflow_pvt.delete_cash_flows'
2360: ,'End debug call okl_lease_quote_cashflow_pvt.delete_cash_flows');
2361: END IF;
2362:
2363: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN
2364: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2572:
2573: IF lv_cash_flow_exists = 'YES' THEN
2574:
2575: IF(l_debug_enabled='Y') THEN
2576: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_CASHFLOW_PVT.delete_cashflows'
2577: ,'begin debug call delete_cashflows');
2578: END IF;
2579: OKL_LEASE_QUOTE_CASHFLOW_PVT.delete_cashflows (
2580: p_api_version => G_API_VERSION
2575: IF(l_debug_enabled='Y') THEN
2576: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_CASHFLOW_PVT.delete_cashflows'
2577: ,'begin debug call delete_cashflows');
2578: END IF;
2579: OKL_LEASE_QUOTE_CASHFLOW_PVT.delete_cashflows (
2580: p_api_version => G_API_VERSION
2581: ,p_init_msg_list => G_FALSE
2582: ,p_transaction_control => G_FALSE
2583: ,p_source_object_code => l_source_object_code
2586: ,x_msg_count => x_msg_count
2587: ,x_msg_data => x_msg_data);
2588:
2589: IF(l_debug_enabled='Y') THEN
2590: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,'okl.plsql.OKL_LEASE_QUOTE_CASHFLOW_PVT.delete_cashflows'
2591: ,'end debug call delete_cashflows');
2592: END IF;
2593:
2594: IF x_return_status = G_RET_STS_UNEXP_ERROR THEN