[Home] [Help]
2195: l_tm_deduction_org_id NUMBER; --14798341
2196: l_counter NUMBER := 0;
2197:
2198: BEGIN
2199: -- Standard Start of API savepoint
2200: --SAVEPOINT net_accrual_engine;
2201:
2202: RETCODE := '0';
2203:
4627: EXCEPTION
4628:
4629: WHEN FND_API.G_EXC_ERROR THEN
4630: ROLLBACK TO net_accrual_offer;
4631: -- Standard call to get message count and if count=1, get the message
4632: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4633: p_count => l_msg_count,
4634: p_data => l_msg_data);
4635:
4637: RETCODE := '1';
4638:
4639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4640: ROLLBACK TO net_accrual_offer;
4641: -- Standard call to get message count and if count=1, get the message
4642: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4643: p_count => l_msg_count,
4644: p_data => l_msg_data);
4645:
4647: RETCODE := '1';
4648:
4649: WHEN OTHERS THEN
4650: ROLLBACK TO net_accrual_offer;
4651: -- Standard call to get message count and if count=1, get the message
4652: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4653: p_count => l_msg_count,
4654: p_data => l_msg_data);
4655: --ERRBUF := l_msg_data;
4679:
4680: WHEN FND_API.G_EXC_ERROR THEN
4681: --ROLLBACK TO net_accrual_engine;
4682: ROLLBACK;
4683: -- Standard call to get message count and if count=1, get the message
4684: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4685: p_count => l_msg_count,
4686: p_data => l_msg_data);
4687:
4689: RETCODE := '2';
4690:
4691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4692: ROLLBACK ;
4693: -- Standard call to get message count and if count=1, get the message
4694: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4695: p_count => l_msg_count,
4696: p_data => l_msg_data);
4697:
4699: RETCODE := '2';
4700:
4701: WHEN OTHERS THEN
4702: ROLLBACK ;
4703: -- Standard call to get message count and if count=1, get the message
4704: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
4705: p_count => l_msg_count,
4706: p_data => l_msg_data);
4707: --ERRBUF := l_msg_data;