DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_CASHFLOW_PVT dependencies on FND_MSG_PUB

Line 1335: FND_MSG_PUB.initialize;

1331: SAVEPOINT l_program_name;
1332: END IF;
1333:
1334: IF p_init_msg_list = G_TRUE THEN
1335: FND_MSG_PUB.initialize;
1336: END IF;
1337:
1338: IF p_cashflow_level_tbl.COUNT = 0 THEN
1339: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_REQD_LEVELS');

Line 1375: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1371: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1372:
1373: IF p_transaction_control = G_TRUE THEN
1374: ROLLBACK TO l_program_name;
1375: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1376: END IF;
1377:
1378: x_return_status := G_RET_STS_ERROR;
1379:

Line 1384: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1380: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1381:
1382: IF p_transaction_control = G_TRUE THEN
1383: ROLLBACK TO l_program_name;
1384: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1385: END IF;
1386:
1387: x_return_status := G_RET_STS_UNEXP_ERROR;
1388:

Line 1402: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1398: p_token3_value => sqlerrm);
1399:
1400: IF p_transaction_control = G_TRUE THEN
1401: ROLLBACK TO l_program_name;
1402: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1403: END IF;
1404:
1405: x_return_status := G_RET_STS_UNEXP_ERROR;
1406:

Line 1433: FND_MSG_PUB.initialize;

1429: SAVEPOINT l_program_name;
1430: END IF;
1431:
1432: IF p_init_msg_list = G_TRUE THEN
1433: FND_MSG_PUB.initialize;
1434: END IF;
1435:
1436: IF p_cashflow_level_tbl.COUNT = 0 AND p_cashflow_header_rec.stream_type_id IS NOT NULL THEN
1437: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME, p_msg_name => 'OKL_LEVEL_REQD_LEVELS');

Line 1487: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1483: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1484:
1485: IF p_transaction_control = G_TRUE THEN
1486: ROLLBACK TO l_program_name;
1487: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1488: END IF;
1489:
1490: x_return_status := G_RET_STS_ERROR;
1491:

Line 1496: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1492: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1493:
1494: IF p_transaction_control = G_TRUE THEN
1495: ROLLBACK TO l_program_name;
1496: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1497: END IF;
1498:
1499: x_return_status := G_RET_STS_UNEXP_ERROR;
1500:

Line 1514: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1510: p_token3_value => sqlerrm);
1511:
1512: IF p_transaction_control = G_TRUE THEN
1513: ROLLBACK TO l_program_name;
1514: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1515: END IF;
1516:
1517: x_return_status := G_RET_STS_UNEXP_ERROR;
1518:

Line 1595: FND_MSG_PUB.initialize;

1591: SAVEPOINT l_program_name;
1592: END IF;
1593:
1594: IF p_init_msg_list = G_TRUE THEN
1595: FND_MSG_PUB.initialize;
1596: END IF;
1597:
1598: get_source_table (
1599: p_source_object_code => p_source_object_code

Line 1761: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1757: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1758:
1759: IF p_transaction_control = G_TRUE THEN
1760: ROLLBACK TO l_program_name;
1761: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1762: END IF;
1763:
1764: x_return_status := G_RET_STS_ERROR;
1765:

Line 1770: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1766: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1767:
1768: IF p_transaction_control = G_TRUE THEN
1769: ROLLBACK TO l_program_name;
1770: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1771: END IF;
1772:
1773: x_return_status := G_RET_STS_UNEXP_ERROR;
1774:

Line 1788: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1784: p_token3_value => sqlerrm);
1785:
1786: IF p_transaction_control = G_TRUE THEN
1787: ROLLBACK TO l_program_name;
1788: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1789: END IF;
1790:
1791: x_return_status := G_RET_STS_UNEXP_ERROR;
1792:

Line 1855: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1851: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1852:
1853: IF p_transaction_control = G_TRUE THEN
1854: ROLLBACK TO l_program_name;
1855: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1856: END IF;
1857:
1858: x_return_status := G_RET_STS_ERROR;
1859:

Line 1864: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1860: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1861:
1862: IF p_transaction_control = G_TRUE THEN
1863: ROLLBACK TO l_program_name;
1864: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1865: END IF;
1866:
1867: x_return_status := G_RET_STS_UNEXP_ERROR;
1868:

Line 1882: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1878: p_token3_value => sqlerrm);
1879:
1880: IF p_transaction_control = G_TRUE THEN
1881: ROLLBACK TO l_program_name;
1882: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1883: END IF;
1884:
1885: x_return_status := G_RET_STS_UNEXP_ERROR;
1886:

Line 1922: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1918: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1919:
1920: IF p_transaction_control = G_TRUE THEN
1921: ROLLBACK TO l_program_name;
1922: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1923: END IF;
1924:
1925: x_return_status := G_RET_STS_ERROR;
1926:

Line 1931: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1927: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1928:
1929: IF p_transaction_control = G_TRUE THEN
1930: ROLLBACK TO l_program_name;
1931: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1932: END IF;
1933:
1934: x_return_status := G_RET_STS_UNEXP_ERROR;
1935:

Line 1949: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1945: p_token3_value => sqlerrm);
1946:
1947: IF p_transaction_control = G_TRUE THEN
1948: ROLLBACK TO l_program_name;
1949: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1950: END IF;
1951:
1952: x_return_status := G_RET_STS_UNEXP_ERROR;
1953:

Line 1985: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1981: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1982:
1983: IF p_transaction_control = G_TRUE THEN
1984: ROLLBACK TO l_program_name;
1985: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1986: END IF;
1987:
1988: x_return_status := G_RET_STS_ERROR;
1989:

Line 1994: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1990: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1991:
1992: IF p_transaction_control = G_TRUE THEN
1993: ROLLBACK TO l_program_name;
1994: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1995: END IF;
1996:
1997: x_return_status := G_RET_STS_UNEXP_ERROR;
1998:

Line 2012: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2008: p_token3_value => sqlerrm);
2009:
2010: IF p_transaction_control = G_TRUE THEN
2011: ROLLBACK TO l_program_name;
2012: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2013: END IF;
2014:
2015: x_return_status := G_RET_STS_UNEXP_ERROR;
2016:

Line 2443: FND_MSG_PUB.initialize;

2439: SAVEPOINT l_program_name;
2440: END IF;
2441:
2442: IF p_init_msg_list = G_TRUE THEN
2443: FND_MSG_PUB.initialize;
2444: END IF;
2445:
2446: OPEN get_estimate_details_csr;
2447: FETCH get_estimate_details_csr INTO estimate_details_csr_rec;

Line 2595: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2591: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2592:
2593: IF p_transaction_control = G_TRUE THEN
2594: ROLLBACK TO l_program_name;
2595: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2596: END IF;
2597:
2598: x_return_status := G_RET_STS_ERROR;
2599:

Line 2604: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2600: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2601:
2602: IF p_transaction_control = G_TRUE THEN
2603: ROLLBACK TO l_program_name;
2604: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2605: END IF;
2606:
2607: x_return_status := G_RET_STS_UNEXP_ERROR;
2608:

Line 2622: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

2618: p_token3_value => sqlerrm);
2619:
2620: IF p_transaction_control = G_TRUE THEN
2621: ROLLBACK TO l_program_name;
2622: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2623: END IF;
2624:
2625: x_return_status := G_RET_STS_UNEXP_ERROR;
2626: