1329: SAVEPOINT l_program_name;
1330: END IF;
1331:
1332: IF p_init_msg_list = G_TRUE THEN
1333: FND_MSG_PUB.initialize;
1334: END IF;
1335:
1336: IF p_cashflow_level_tbl.COUNT = 0 THEN
1337: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_REQD_LEVELS');
1369: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1370:
1371: IF p_transaction_control = G_TRUE THEN
1372: ROLLBACK TO l_program_name;
1373: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1374: END IF;
1375:
1376: x_return_status := G_RET_STS_ERROR;
1377:
1378: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1379:
1380: IF p_transaction_control = G_TRUE THEN
1381: ROLLBACK TO l_program_name;
1382: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1383: END IF;
1384:
1385: x_return_status := G_RET_STS_UNEXP_ERROR;
1386:
1396: p_token3_value => sqlerrm);
1397:
1398: IF p_transaction_control = G_TRUE THEN
1399: ROLLBACK TO l_program_name;
1400: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1401: END IF;
1402:
1403: x_return_status := G_RET_STS_UNEXP_ERROR;
1404:
1427: SAVEPOINT l_program_name;
1428: END IF;
1429:
1430: IF p_init_msg_list = G_TRUE THEN
1431: FND_MSG_PUB.initialize;
1432: END IF;
1433:
1434: IF p_cashflow_level_tbl.COUNT = 0 AND p_cashflow_header_rec.stream_type_id IS NOT NULL THEN
1435: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_REQD_LEVELS');
1481: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1482:
1483: IF p_transaction_control = G_TRUE THEN
1484: ROLLBACK TO l_program_name;
1485: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1486: END IF;
1487:
1488: x_return_status := G_RET_STS_ERROR;
1489:
1490: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1491:
1492: IF p_transaction_control = G_TRUE THEN
1493: ROLLBACK TO l_program_name;
1494: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1495: END IF;
1496:
1497: x_return_status := G_RET_STS_UNEXP_ERROR;
1498:
1508: p_token3_value => sqlerrm);
1509:
1510: IF p_transaction_control = G_TRUE THEN
1511: ROLLBACK TO l_program_name;
1512: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1513: END IF;
1514:
1515: x_return_status := G_RET_STS_UNEXP_ERROR;
1516:
1587: SAVEPOINT l_program_name;
1588: END IF;
1589:
1590: IF p_init_msg_list = G_TRUE THEN
1591: FND_MSG_PUB.initialize;
1592: END IF;
1593:
1594: get_source_table (
1595: p_source_object_code => p_source_object_code
1746: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1747:
1748: IF p_transaction_control = G_TRUE THEN
1749: ROLLBACK TO l_program_name;
1750: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1751: END IF;
1752:
1753: x_return_status := G_RET_STS_ERROR;
1754:
1755: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1756:
1757: IF p_transaction_control = G_TRUE THEN
1758: ROLLBACK TO l_program_name;
1759: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1760: END IF;
1761:
1762: x_return_status := G_RET_STS_UNEXP_ERROR;
1763:
1773: p_token3_value => sqlerrm);
1774:
1775: IF p_transaction_control = G_TRUE THEN
1776: ROLLBACK TO l_program_name;
1777: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1778: END IF;
1779:
1780: x_return_status := G_RET_STS_UNEXP_ERROR;
1781:
1840: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1841:
1842: IF p_transaction_control = G_TRUE THEN
1843: ROLLBACK TO l_program_name;
1844: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1845: END IF;
1846:
1847: x_return_status := G_RET_STS_ERROR;
1848:
1849: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1850:
1851: IF p_transaction_control = G_TRUE THEN
1852: ROLLBACK TO l_program_name;
1853: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1854: END IF;
1855:
1856: x_return_status := G_RET_STS_UNEXP_ERROR;
1857:
1867: p_token3_value => sqlerrm);
1868:
1869: IF p_transaction_control = G_TRUE THEN
1870: ROLLBACK TO l_program_name;
1871: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1872: END IF;
1873:
1874: x_return_status := G_RET_STS_UNEXP_ERROR;
1875:
1907: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1908:
1909: IF p_transaction_control = G_TRUE THEN
1910: ROLLBACK TO l_program_name;
1911: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1912: END IF;
1913:
1914: x_return_status := G_RET_STS_ERROR;
1915:
1916: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1917:
1918: IF p_transaction_control = G_TRUE THEN
1919: ROLLBACK TO l_program_name;
1920: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1921: END IF;
1922:
1923: x_return_status := G_RET_STS_UNEXP_ERROR;
1924:
1934: p_token3_value => sqlerrm);
1935:
1936: IF p_transaction_control = G_TRUE THEN
1937: ROLLBACK TO l_program_name;
1938: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1939: END IF;
1940:
1941: x_return_status := G_RET_STS_UNEXP_ERROR;
1942:
1970: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1971:
1972: IF p_transaction_control = G_TRUE THEN
1973: ROLLBACK TO l_program_name;
1974: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1975: END IF;
1976:
1977: x_return_status := G_RET_STS_ERROR;
1978:
1979: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1980:
1981: IF p_transaction_control = G_TRUE THEN
1982: ROLLBACK TO l_program_name;
1983: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1984: END IF;
1985:
1986: x_return_status := G_RET_STS_UNEXP_ERROR;
1987:
1997: p_token3_value => sqlerrm);
1998:
1999: IF p_transaction_control = G_TRUE THEN
2000: ROLLBACK TO l_program_name;
2001: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2002: END IF;
2003:
2004: x_return_status := G_RET_STS_UNEXP_ERROR;
2005:
2428: SAVEPOINT l_program_name;
2429: END IF;
2430:
2431: IF p_init_msg_list = G_TRUE THEN
2432: FND_MSG_PUB.initialize;
2433: END IF;
2434:
2435: OPEN get_estimate_details_csr;
2436: FETCH get_estimate_details_csr INTO estimate_details_csr_rec;
2580: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2581:
2582: IF p_transaction_control = G_TRUE THEN
2583: ROLLBACK TO l_program_name;
2584: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2585: END IF;
2586:
2587: x_return_status := G_RET_STS_ERROR;
2588:
2589: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2590:
2591: IF p_transaction_control = G_TRUE THEN
2592: ROLLBACK TO l_program_name;
2593: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2594: END IF;
2595:
2596: x_return_status := G_RET_STS_UNEXP_ERROR;
2597:
2607: p_token3_value => sqlerrm);
2608:
2609: IF p_transaction_control = G_TRUE THEN
2610: ROLLBACK TO l_program_name;
2611: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2612: END IF;
2613:
2614: x_return_status := G_RET_STS_UNEXP_ERROR;
2615: