DBA Data[Home] [Help]

APPS.OKL_LEASE_QUOTE_FEE_PVT dependencies on FND_MSG_PUB

Line 1481: FND_MSG_PUB.initialize;

1477: SAVEPOINT l_program_name;
1478: END IF;
1479:
1480: IF p_init_msg_list = G_TRUE THEN
1481: FND_MSG_PUB.initialize;
1482: END IF;
1483:
1484: l_fee_rec := p_fee_rec;
1485: l_expense_level_tbl := p_expense_level_tbl;

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

1654: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1655:
1656: IF p_transaction_control = G_TRUE THEN
1657: ROLLBACK TO l_program_name;
1658: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1659: END IF;
1660:
1661: x_return_status := G_RET_STS_ERROR;
1662:

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

1663: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1664:
1665: IF p_transaction_control = G_TRUE THEN
1666: ROLLBACK TO l_program_name;
1667: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1668: END IF;
1669:
1670: x_return_status := G_RET_STS_UNEXP_ERROR;
1671:

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

1681: p_token3_value => sqlerrm);
1682:
1683: IF p_transaction_control = G_TRUE THEN
1684: ROLLBACK TO l_program_name;
1685: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1686: END IF;
1687:
1688: x_return_status := G_RET_STS_UNEXP_ERROR;
1689:

Line 1781: FND_MSG_PUB.initialize;

1777: SAVEPOINT l_program_name;
1778: END IF;
1779:
1780: IF p_init_msg_list = G_TRUE THEN
1781: FND_MSG_PUB.initialize;
1782: END IF;
1783:
1784: get_fee_rec (p_fee_id => p_fee_rec.id
1785: ,x_fee_rec => l_fee_rec

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

1902: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1903:
1904: IF p_transaction_control = G_TRUE THEN
1905: ROLLBACK TO l_program_name;
1906: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1907: END IF;
1908:
1909: x_return_status := G_RET_STS_ERROR;
1910:

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

1911: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1912:
1913: IF p_transaction_control = G_TRUE THEN
1914: ROLLBACK TO l_program_name;
1915: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1916: END IF;
1917:
1918: x_return_status := G_RET_STS_UNEXP_ERROR;
1919:

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

1929: p_token3_value => sqlerrm);
1930:
1931: IF p_transaction_control = G_TRUE THEN
1932: ROLLBACK TO l_program_name;
1933: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1934: END IF;
1935:
1936: x_return_status := G_RET_STS_UNEXP_ERROR;
1937:

Line 1989: FND_MSG_PUB.initialize;

1985: SAVEPOINT l_program_name;
1986: END IF;
1987:
1988: IF p_init_msg_list = G_TRUE THEN
1989: FND_MSG_PUB.initialize;
1990: END IF;
1991:
1992: l_fee_rec := p_fee_rec;
1993: l_expense_level_tbl := p_expense_level_tbl;

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

2170: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2171:
2172: IF p_transaction_control = G_TRUE THEN
2173: ROLLBACK TO l_program_name;
2174: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2175: END IF;
2176:
2177: x_return_status := G_RET_STS_ERROR;
2178:

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

2179: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2180:
2181: IF p_transaction_control = G_TRUE THEN
2182: ROLLBACK TO l_program_name;
2183: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2184: END IF;
2185:
2186: x_return_status := G_RET_STS_UNEXP_ERROR;
2187:

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

2197: p_token3_value => sqlerrm);
2198:
2199: IF p_transaction_control = G_TRUE THEN
2200: ROLLBACK TO l_program_name;
2201: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2202: END IF;
2203:
2204: x_return_status := G_RET_STS_UNEXP_ERROR;
2205:

Line 2436: FND_MSG_PUB.initialize;

2432: SAVEPOINT l_program_name;
2433: END IF;
2434:
2435: IF p_init_msg_list = G_TRUE THEN
2436: FND_MSG_PUB.initialize;
2437: END IF;
2438:
2439: create_fee (
2440: p_api_version => G_API_VERSION

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

2464: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2465:
2466: IF p_transaction_control = G_TRUE THEN
2467: ROLLBACK TO l_program_name;
2468: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2469: END IF;
2470:
2471: x_return_status := G_RET_STS_ERROR;
2472:

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

2473: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2474:
2475: IF p_transaction_control = G_TRUE THEN
2476: ROLLBACK TO l_program_name;
2477: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2478: END IF;
2479:
2480: x_return_status := G_RET_STS_UNEXP_ERROR;
2481:

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

2491: p_token3_value => sqlerrm);
2492:
2493: IF p_transaction_control = G_TRUE THEN
2494: ROLLBACK TO l_program_name;
2495: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2496: END IF;
2497:
2498: x_return_status := G_RET_STS_UNEXP_ERROR;
2499:

Line 2543: FND_MSG_PUB.initialize;

2539: SAVEPOINT l_program_name;
2540: END IF;
2541:
2542: IF p_init_msg_list = G_TRUE THEN
2543: FND_MSG_PUB.initialize;
2544: END IF;
2545:
2546: get_fee_rec (
2547: p_fee_id => p_source_fee_id

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

2677: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2678:
2679: IF p_transaction_control = G_TRUE THEN
2680: ROLLBACK TO l_program_name;
2681: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2682: END IF;
2683:
2684: x_return_status := G_RET_STS_ERROR;
2685:

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

2686: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2687:
2688: IF p_transaction_control = G_TRUE THEN
2689: ROLLBACK TO l_program_name;
2690: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2691: END IF;
2692:
2693: x_return_status := G_RET_STS_UNEXP_ERROR;
2694:

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

2704: p_token3_value => sqlerrm);
2705:
2706: IF p_transaction_control = G_TRUE THEN
2707: ROLLBACK TO l_program_name;
2708: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2709: END IF;
2710:
2711: x_return_status := G_RET_STS_UNEXP_ERROR;
2712:

Line 2752: FND_MSG_PUB.initialize;

2748: SAVEPOINT l_program_name;
2749: END IF;
2750:
2751: IF p_init_msg_list = G_TRUE THEN
2752: FND_MSG_PUB.initialize;
2753: END IF;
2754:
2755: SELECT fee_type INTO l_fee_type FROM okl_fees_b WHERE id = p_fee_id;
2756:

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

2844: WHEN OKL_API.G_EXCEPTION_ERROR THEN
2845:
2846: IF p_transaction_control = G_TRUE THEN
2847: ROLLBACK TO l_program_name;
2848: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2849: END IF;
2850:
2851: x_return_status := G_RET_STS_ERROR;
2852:

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

2853: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2854:
2855: IF p_transaction_control = G_TRUE THEN
2856: ROLLBACK TO l_program_name;
2857: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2858: END IF;
2859:
2860: x_return_status := G_RET_STS_UNEXP_ERROR;
2861:

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

2871: p_token3_value => sqlerrm);
2872:
2873: IF p_transaction_control = G_TRUE THEN
2874: ROLLBACK TO l_program_name;
2875: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2876: END IF;
2877:
2878: x_return_status := G_RET_STS_UNEXP_ERROR;
2879: