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;
1631: | fnd_api.g_ret_sts_error |
1632: | fnd_api.g_ret_sts_error |
1633: | fnd_api.g_ret_sts_success |
1634: | fnd_api.to_boolean |
1635: | fnd_msg_pub.check_msg_level |
1636: | fnd_msg_pub.count_and_get |
1637: | fnd_msg_pub.initialize |
1638: | |
1639: | ARGUMENTS : IN: |
1632: | fnd_api.g_ret_sts_error |
1633: | fnd_api.g_ret_sts_success |
1634: | fnd_api.to_boolean |
1635: | fnd_msg_pub.check_msg_level |
1636: | fnd_msg_pub.count_and_get |
1637: | fnd_msg_pub.initialize |
1638: | |
1639: | ARGUMENTS : IN: |
1640: | p_api_name |
1633: | fnd_api.g_ret_sts_success |
1634: | fnd_api.to_boolean |
1635: | fnd_msg_pub.check_msg_level |
1636: | fnd_msg_pub.count_and_get |
1637: | fnd_msg_pub.initialize |
1638: | |
1639: | ARGUMENTS : IN: |
1640: | p_api_name |
1641: | p_api_version |
1725: +--------------------------------------------------------------*/
1726:
1727: IF FND_API.to_Boolean( p_init_msg_list )
1728: THEN
1729: FND_MSG_PUB.initialize;
1730: arp_trx_validate.pg_message_tbl.DELETE;
1731: END IF;
1732:
1733: /*-----------------------------------------+
1912: /*---------------------------------------------------+
1913: | Get message count and if 1, return message data |
1914: +---------------------------------------------------*/
1915:
1916: FND_MSG_PUB.Count_And_Get(
1917: p_count => p_msg_count,
1918: p_data => p_msg_data
1919: );
1920:
1967: ROLLBACK TO Delete_Transaction_PUB;
1968: p_return_status := FND_API.G_RET_STS_ERROR;
1969: Display_Parameters;
1970:
1971: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1972: p_data => p_msg_data
1973: );
1974:
1975: WHEN FND_API.G_EXC_ERROR THEN
1980: ROLLBACK TO Delete_Transaction_PUB;
1981: p_return_status := FND_API.G_RET_STS_ERROR ;
1982: Display_Parameters;
1983:
1984: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1985: p_data => p_msg_data
1986: );
1987:
1988: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1992: ROLLBACK TO Delete_Transaction_PUB;
1993: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1994: Display_Parameters;
1995:
1996: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
1997: p_data => p_msg_data
1998: );
1999:
2000: WHEN OTHERS THEN
2026:
2027: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2028: Display_Parameters;
2029:
2030: IF FND_MSG_PUB.Check_Msg_Level
2031: THEN
2032: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2033: l_api_name
2034: );
2028: Display_Parameters;
2029:
2030: IF FND_MSG_PUB.Check_Msg_Level
2031: THEN
2032: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,
2033: l_api_name
2034: );
2035: END IF;
2036:
2033: l_api_name
2034: );
2035: END IF;
2036:
2037: FND_MSG_PUB.Count_And_Get( p_count => p_msg_count,
2038: p_data => p_msg_data
2039: );
2040:
2041: