151: NULL;
152: WHEN OTHERS THEN
153: p_return_status := FND_API.G_RET_STS_ERROR ;
154: ROLLBACK TO jl_vendor_merge;
155: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
156: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
157: FND_MSG_PUB.Add;
158: /*---------------------------------------------------------+
159: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
152: WHEN OTHERS THEN
153: p_return_status := FND_API.G_RET_STS_ERROR ;
154: ROLLBACK TO jl_vendor_merge;
155: FND_MESSAGE.SET_NAME('AR', 'HZ_MERGE_SQL_ERROR');
156: FND_MESSAGE.SET_TOKEN('ERROR' ,SQLERRM);
157: FND_MSG_PUB.Add;
158: /*---------------------------------------------------------+
159: | FND_MSG_PUB.Count_And_Get used to get the count of mesg.|
160: | in the message stack. If there is only one message in |