1847: COMMIT WORK;
1848: END IF;
1849:
1850: -- Standard call to get message count and IF count is get message info.
1851: FND_MSG_PUB.Count_And_Get
1852: (p_count => x_msg_count,
1853: p_data => x_msg_data );
1854:
1855: v_total_records := v_total_records + 1;
1890: EXCEPTION
1891: WHEN FND_API.G_EXC_ERROR THEN
1892: ROLLBACK TO Update_rep_task_hist;
1893: x_return_status := FND_API.G_RET_STS_ERROR ;
1894: FND_MSG_PUB.Count_And_Get
1895: (p_count => x_msg_count,
1896: p_data => x_msg_data
1897: );
1898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1897: );
1898: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1899: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1900: ROLLBACK TO Update_rep_task_hist;
1901: FND_MSG_PUB.Count_And_Get
1902: ( p_count => x_msg_count,
1903: p_data => x_msg_data
1904: );
1905: when no_data_found then
1920:
1921: WHEN OTHERS THEN
1922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1923: ROLLBACK TO Update_rep_task_hist;
1924: IF FND_MSG_PUB.Check_Msg_Level
1925: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1926: THEN
1927: FND_MSG_PUB.Add_Exc_Msg
1928: (G_PKG_NAME ,
1921: WHEN OTHERS THEN
1922: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1923: ROLLBACK TO Update_rep_task_hist;
1924: IF FND_MSG_PUB.Check_Msg_Level
1925: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1926: THEN
1927: FND_MSG_PUB.Add_Exc_Msg
1928: (G_PKG_NAME ,
1929: l_api_name );
1923: ROLLBACK TO Update_rep_task_hist;
1924: IF FND_MSG_PUB.Check_Msg_Level
1925: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1926: THEN
1927: FND_MSG_PUB.Add_Exc_Msg
1928: (G_PKG_NAME ,
1929: l_api_name );
1930: END IF;
1931: FND_MSG_PUB.Count_And_Get
1927: FND_MSG_PUB.Add_Exc_Msg
1928: (G_PKG_NAME ,
1929: l_api_name );
1930: END IF;
1931: FND_MSG_PUB.Count_And_Get
1932: (p_count => x_msg_count,
1933: p_data => x_msg_data );
1934: IF (g_debug > 0 ) THEN
1935: csd_gen_utility_pvt.add('others '||sqlerrm||to_char(sqlcode));