|#000|adding log for approve failure
|#000|reformatting mapper queries