402: +--------------------------------------------------------------*/
403:
404: IF FND_API.to_Boolean( p_init_msg_list )
405: THEN
406: FND_MSG_PUB.initialize;
407: END IF;
408:
409: --anuj
410: clean_tmp_gt;
1564: | fnd_api.g_ret_sts_error |
1565: | fnd_api.g_ret_sts_error |
1566: | fnd_api.g_ret_sts_success |
1567: | fnd_api.to_boolean |
1568: | fnd_msg_pub.check_msg_level |
1569: | fnd_msg_pub.count_and_get |
1570: | fnd_msg_pub.initialize |
1571: | |
1572: | ARGUMENTS : IN: |
1565: | fnd_api.g_ret_sts_error |
1566: | fnd_api.g_ret_sts_success |
1567: | fnd_api.to_boolean |
1568: | fnd_msg_pub.check_msg_level |
1569: | fnd_msg_pub.count_and_get |
1570: | fnd_msg_pub.initialize |
1571: | |
1572: | ARGUMENTS : IN: |
1573: | p_api_name |
1566: | fnd_api.g_ret_sts_success |
1567: | fnd_api.to_boolean |
1568: | fnd_msg_pub.check_msg_level |
1569: | fnd_msg_pub.count_and_get |
1570: | fnd_msg_pub.initialize |
1571: | |
1572: | ARGUMENTS : IN: |
1573: | p_api_name |
1574: | p_api_version |
1658: +--------------------------------------------------------------*/
1659:
1660: IF FND_API.to_Boolean( p_init_msg_list )
1661: THEN
1662: FND_MSG_PUB.initialize;
1663: arp_trx_validate.pg_message_tbl.DELETE;
1664: END IF;
1665:
1666: /*-----------------------------------------+
1845: /*---------------------------------------------------+
1846: | Get message count and if 1, return message data |
1847: +---------------------------------------------------*/
1848:
1849: FND_MSG_PUB.Count_And_Get(
1850: p_count => p_msg_count,
1851: p_data => p_msg_data
1852: );
1853:
1900: ROLLBACK TO Delete_Transaction_PUB;
1901: p_return_status := FND_API.G_RET_STS_ERROR;
1902: Display_Parameters;
1903:
1904: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1905: p_data => p_msg_data
1906: );
1907:
1908: WHEN FND_API.G_EXC_ERROR THEN
1913: ROLLBACK TO Delete_Transaction_PUB;
1914: p_return_status := FND_API.G_RET_STS_ERROR ;
1915: Display_Parameters;
1916:
1917: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1918: p_data => p_msg_data
1919: );
1920:
1921: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1925: ROLLBACK TO Delete_Transaction_PUB;
1926: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1927: Display_Parameters;
1928:
1929: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1930: p_data => p_msg_data
1931: );
1932:
1933: WHEN OTHERS THEN
1959:
1960: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1961: Display_Parameters;
1962:
1963: IF FND_MSG_PUB.Check_Msg_Level
1964: THEN
1965: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
1966: l_api_name
1967: );
1961: Display_Parameters;
1962:
1963: IF FND_MSG_PUB.Check_Msg_Level
1964: THEN
1965: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
1966: l_api_name
1967: );
1968: END IF;
1969:
1966: l_api_name
1967: );
1968: END IF;
1969:
1970: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1971: p_data => p_msg_data
1972: );
1973:
1974: