826: WHEN OTHERS THEN
827: IF (SQLCODE = -20001) THEN
828: ROLLBACK TO populate_cst_tables_grp;
829: x_return_status := FND_API.G_RET_STS_ERROR ;
830: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
831: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ar_match_rev_cogs_grp.populate_cst_tables : '||SQLERRM);
832: FND_MSG_PUB.Add;
833:
834: fnd_msg_pub.count_and_get (
827: IF (SQLCODE = -20001) THEN
828: ROLLBACK TO populate_cst_tables_grp;
829: x_return_status := FND_API.G_RET_STS_ERROR ;
830: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
831: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ar_match_rev_cogs_grp.populate_cst_tables : '||SQLERRM);
832: FND_MSG_PUB.Add;
833:
834: fnd_msg_pub.count_and_get (
835: p_encoded => fnd_api.g_false,
837: p_data => x_msg_data);
838: RETURN;
839: ELSE
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
841: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
842: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ar_match_rev_cogs_grp.populate_cst_tables : '||SQLERRM);
843: FND_MSG_PUB.Add;
844: END IF;
845:
838: RETURN;
839: ELSE
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
841: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
842: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','ar_match_rev_cogs_grp.populate_cst_tables : '||SQLERRM);
843: FND_MSG_PUB.Add;
844: END IF;
845:
846: IF PG_DEBUG in ('Y', 'C') THEN