DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_FEE_PVT dependencies on FND_MSG_PUB

Line 1469: FND_MSG_PUB.initialize;

1465: SAVEPOINT l_program_name;
1466: END IF;
1467:
1468: IF p_init_msg_list = G_TRUE THEN
1469: FND_MSG_PUB.initialize;
1470: END IF;
1471:
1472: l_fee_rec := p_fee_rec;
1473: l_expense_level_tbl := p_expense_level_tbl;

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

1642: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1643:
1644: IF p_transaction_control = G_TRUE THEN
1645: ROLLBACK TO l_program_name;
1646: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1647: END IF;
1648:
1649: x_return_status := G_RET_STS_ERROR;
1650:

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

1651: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1652:
1653: IF p_transaction_control = G_TRUE THEN
1654: ROLLBACK TO l_program_name;
1655: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1656: END IF;
1657:
1658: x_return_status := G_RET_STS_UNEXP_ERROR;
1659:

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

1669: p_token3_value => sqlerrm);
1670:
1671: IF p_transaction_control = G_TRUE THEN
1672: ROLLBACK TO l_program_name;
1673: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1674: END IF;
1675:
1676: x_return_status := G_RET_STS_UNEXP_ERROR;
1677:

Line 1769: FND_MSG_PUB.initialize;

1765: SAVEPOINT l_program_name;
1766: END IF;
1767:
1768: IF p_init_msg_list = G_TRUE THEN
1769: FND_MSG_PUB.initialize;
1770: END IF;
1771:
1772: get_fee_rec (p_fee_id => p_fee_rec.id
1773: ,x_fee_rec => l_fee_rec

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

1890: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1891:
1892: IF p_transaction_control = G_TRUE THEN
1893: ROLLBACK TO l_program_name;
1894: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1895: END IF;
1896:
1897: x_return_status := G_RET_STS_ERROR;
1898:

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

1899: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1900:
1901: IF p_transaction_control = G_TRUE THEN
1902: ROLLBACK TO l_program_name;
1903: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1904: END IF;
1905:
1906: x_return_status := G_RET_STS_UNEXP_ERROR;
1907:

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

1917: p_token3_value => sqlerrm);
1918:
1919: IF p_transaction_control = G_TRUE THEN
1920: ROLLBACK TO l_program_name;
1921: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1922: END IF;
1923:
1924: x_return_status := G_RET_STS_UNEXP_ERROR;
1925:

Line 1966: FND_MSG_PUB.initialize;

1962: SAVEPOINT l_program_name;
1963: END IF;
1964:
1965: IF p_init_msg_list = G_TRUE THEN
1966: FND_MSG_PUB.initialize;
1967: END IF;
1968:
1969: l_fee_rec := p_fee_rec;
1970: l_expense_level_tbl := p_expense_level_tbl;

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

2138: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2139:
2140: IF p_transaction_control = G_TRUE THEN
2141: ROLLBACK TO l_program_name;
2142: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2143: END IF;
2144:
2145: x_return_status := G_RET_STS_ERROR;
2146:

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

2147: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2148:
2149: IF p_transaction_control = G_TRUE THEN
2150: ROLLBACK TO l_program_name;
2151: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2152: END IF;
2153:
2154: x_return_status := G_RET_STS_UNEXP_ERROR;
2155:

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

2165: p_token3_value => sqlerrm);
2166:
2167: IF p_transaction_control = G_TRUE THEN
2168: ROLLBACK TO l_program_name;
2169: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2170: END IF;
2171:
2172: x_return_status := G_RET_STS_UNEXP_ERROR;
2173:

Line 2399: FND_MSG_PUB.initialize;

2395: SAVEPOINT l_program_name;
2396: END IF;
2397:
2398: IF p_init_msg_list = G_TRUE THEN
2399: FND_MSG_PUB.initialize;
2400: END IF;
2401:
2402: create_fee (
2403: p_api_version => G_API_VERSION

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

2427: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2428:
2429: IF p_transaction_control = G_TRUE THEN
2430: ROLLBACK TO l_program_name;
2431: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2432: END IF;
2433:
2434: x_return_status := G_RET_STS_ERROR;
2435:

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

2436: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2437:
2438: IF p_transaction_control = G_TRUE THEN
2439: ROLLBACK TO l_program_name;
2440: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2441: END IF;
2442:
2443: x_return_status := G_RET_STS_UNEXP_ERROR;
2444:

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

2454: p_token3_value => sqlerrm);
2455:
2456: IF p_transaction_control = G_TRUE THEN
2457: ROLLBACK TO l_program_name;
2458: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2459: END IF;
2460:
2461: x_return_status := G_RET_STS_UNEXP_ERROR;
2462:

Line 2506: FND_MSG_PUB.initialize;

2502: SAVEPOINT l_program_name;
2503: END IF;
2504:
2505: IF p_init_msg_list = G_TRUE THEN
2506: FND_MSG_PUB.initialize;
2507: END IF;
2508:
2509: get_fee_rec (
2510: p_fee_id => p_source_fee_id

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

2640: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2641:
2642: IF p_transaction_control = G_TRUE THEN
2643: ROLLBACK TO l_program_name;
2644: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2645: END IF;
2646:
2647: x_return_status := G_RET_STS_ERROR;
2648:

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

2649: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2650:
2651: IF p_transaction_control = G_TRUE THEN
2652: ROLLBACK TO l_program_name;
2653: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2654: END IF;
2655:
2656: x_return_status := G_RET_STS_UNEXP_ERROR;
2657:

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

2667: p_token3_value => sqlerrm);
2668:
2669: IF p_transaction_control = G_TRUE THEN
2670: ROLLBACK TO l_program_name;
2671: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2672: END IF;
2673:
2674: x_return_status := G_RET_STS_UNEXP_ERROR;
2675:

Line 2715: FND_MSG_PUB.initialize;

2711: SAVEPOINT l_program_name;
2712: END IF;
2713:
2714: IF p_init_msg_list = G_TRUE THEN
2715: FND_MSG_PUB.initialize;
2716: END IF;
2717:
2718: SELECT fee_type INTO l_fee_type FROM okl_fees_b WHERE id = p_fee_id;
2719:

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

2807: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2808:
2809: IF p_transaction_control = G_TRUE THEN
2810: ROLLBACK TO l_program_name;
2811: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2812: END IF;
2813:
2814: x_return_status := G_RET_STS_ERROR;
2815:

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

2816: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2817:
2818: IF p_transaction_control = G_TRUE THEN
2819: ROLLBACK TO l_program_name;
2820: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2821: END IF;
2822:
2823: x_return_status := G_RET_STS_UNEXP_ERROR;
2824:

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

2834: p_token3_value => sqlerrm);
2835:
2836: IF p_transaction_control = G_TRUE THEN
2837: ROLLBACK TO l_program_name;
2838: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2839: END IF;
2840:
2841: x_return_status := G_RET_STS_UNEXP_ERROR;
2842: