DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_SERVICE_PVT dependencies on FND_MSG_PUB

Line 1352: FND_MSG_PUB.initialize;

1348: SAVEPOINT l_program_name;
1349: END IF;
1350:
1351: IF p_init_msg_list = G_TRUE THEN
1352: FND_MSG_PUB.initialize;
1353: END IF;
1354:
1355: get_currency_code (
1356: p_parent_object_id => p_service_rec.parent_object_id

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

1506: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1507:
1508: IF p_transaction_control = G_TRUE THEN
1509: ROLLBACK TO l_program_name;
1510: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1511: END IF;
1512:
1513: x_return_status := G_RET_STS_ERROR;
1514:

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

1515: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1516:
1517: IF p_transaction_control = G_TRUE THEN
1518: ROLLBACK TO l_program_name;
1519: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1520: END IF;
1521:
1522: x_return_status := G_RET_STS_UNEXP_ERROR;
1523:

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

1533: p_token3_value => sqlerrm);
1534:
1535: IF p_transaction_control = G_TRUE THEN
1536: ROLLBACK TO l_program_name;
1537: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1538: END IF;
1539:
1540: x_return_status := G_RET_STS_UNEXP_ERROR;
1541:

Line 1639: FND_MSG_PUB.initialize;

1635: SAVEPOINT l_program_name;
1636: END IF;
1637:
1638: IF p_init_msg_list = G_TRUE THEN
1639: FND_MSG_PUB.initialize;
1640: END IF;
1641:
1642: -- Fetch Line Relationships info
1643: get_line_relations_tbl (p_service_id => p_service_id

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

1720: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1721:
1722: IF p_transaction_control = G_TRUE THEN
1723: ROLLBACK TO l_program_name;
1724: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1725: END IF;
1726:
1727: x_return_status := G_RET_STS_ERROR;
1728:

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

1729: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1730:
1731: IF p_transaction_control = G_TRUE THEN
1732: ROLLBACK TO l_program_name;
1733: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1734: END IF;
1735:
1736: x_return_status := G_RET_STS_UNEXP_ERROR;
1737:

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

1747: p_token3_value => sqlerrm);
1748:
1749: IF p_transaction_control = G_TRUE THEN
1750: ROLLBACK TO l_program_name;
1751: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1752: END IF;
1753:
1754: x_return_status := G_RET_STS_UNEXP_ERROR;
1755:

Line 1795: FND_MSG_PUB.initialize;

1791: SAVEPOINT l_program_name;
1792: END IF;
1793:
1794: IF p_init_msg_list = G_TRUE THEN
1795: FND_MSG_PUB.initialize;
1796: END IF;
1797:
1798: get_currency_code (
1799: p_parent_object_id => p_service_rec.parent_object_id

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

1948: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1949:
1950: IF p_transaction_control = G_TRUE THEN
1951: ROLLBACK TO l_program_name;
1952: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1953: END IF;
1954:
1955: x_return_status := G_RET_STS_ERROR;
1956:

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

1957: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1958:
1959: IF p_transaction_control = G_TRUE THEN
1960: ROLLBACK TO l_program_name;
1961: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1962: END IF;
1963:
1964: x_return_status := G_RET_STS_UNEXP_ERROR;
1965:

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

1975: p_token3_value => sqlerrm);
1976:
1977: IF p_transaction_control = G_TRUE THEN
1978: ROLLBACK TO l_program_name;
1979: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1980: END IF;
1981:
1982: x_return_status := G_RET_STS_UNEXP_ERROR;
1983:

Line 2017: FND_MSG_PUB.initialize;

2013: SAVEPOINT l_program_name;
2014: END IF;
2015:
2016: IF p_init_msg_list = G_TRUE THEN
2017: FND_MSG_PUB.initialize;
2018: END IF;
2019:
2020: create_service (
2021: p_api_version => G_API_VERSION

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

2046: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2047:
2048: IF p_transaction_control = G_TRUE THEN
2049: ROLLBACK TO l_program_name;
2050: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2051: END IF;
2052:
2053: x_return_status := G_RET_STS_ERROR;
2054:

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

2055: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2056:
2057: IF p_transaction_control = G_TRUE THEN
2058: ROLLBACK TO l_program_name;
2059: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2060: END IF;
2061:
2062: x_return_status := G_RET_STS_UNEXP_ERROR;
2063:

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

2073: p_token3_value => sqlerrm);
2074:
2075: IF p_transaction_control = G_TRUE THEN
2076: ROLLBACK TO l_program_name;
2077: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2078: END IF;
2079:
2080: x_return_status := G_RET_STS_UNEXP_ERROR;
2081:

Line 2122: FND_MSG_PUB.initialize;

2118: SAVEPOINT l_program_name;
2119: END IF;
2120:
2121: IF p_init_msg_list = G_TRUE THEN
2122: FND_MSG_PUB.initialize;
2123: END IF;
2124:
2125: get_service_rec (
2126: p_service_id => p_source_service_id

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

2221: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2222:
2223: IF p_transaction_control = G_TRUE THEN
2224: ROLLBACK TO l_program_name;
2225: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2226: END IF;
2227:
2228: x_return_status := G_RET_STS_ERROR;
2229:

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

2230: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2231:
2232: IF p_transaction_control = G_TRUE THEN
2233: ROLLBACK TO l_program_name;
2234: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2235: END IF;
2236:
2237: x_return_status := G_RET_STS_UNEXP_ERROR;
2238:

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

2248: p_token3_value => sqlerrm);
2249:
2250: IF p_transaction_control = G_TRUE THEN
2251: ROLLBACK TO l_program_name;
2252: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2253: END IF;
2254:
2255: x_return_status := G_RET_STS_UNEXP_ERROR;
2256:

Line 2293: FND_MSG_PUB.initialize;

2289: SAVEPOINT l_program_name;
2290: END IF;
2291:
2292: IF p_init_msg_list = G_TRUE THEN
2293: FND_MSG_PUB.initialize;
2294: END IF;
2295:
2296: i := 0;
2297: FOR l_subline IN c_sublines LOOP

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

2359: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2360:
2361: IF p_transaction_control = G_TRUE THEN
2362: ROLLBACK TO l_program_name;
2363: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2364: END IF;
2365:
2366: x_return_status := G_RET_STS_ERROR;
2367:

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

2368: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2369:
2370: IF p_transaction_control = G_TRUE THEN
2371: ROLLBACK TO l_program_name;
2372: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2373: END IF;
2374:
2375: x_return_status := G_RET_STS_UNEXP_ERROR;
2376:

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

2386: p_token3_value => sqlerrm);
2387:
2388: IF p_transaction_control = G_TRUE THEN
2389: ROLLBACK TO l_program_name;
2390: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2391: END IF;
2392:
2393: x_return_status := G_RET_STS_UNEXP_ERROR;
2394: