854: return_error_code = 'EGO_INVALID_STATUS_CODE',
855: return_error_message = FND_MESSAGE.get_string ('EGO', 'EGO_INVALID_STATUS_CODE'),
856: ret_err_msg_lang = USERENV('LANG')
857: where Status not in (select lookup_code
858: from fnd_lookups
859: where Lookup_Type = 'EGO_PUBLICATION_STATUS')
860: and batch_id = p_batch_id;
861:
862: EGO_COMMON_PVT.WRITE_DIAGNOSTIC(p_log_level => FND_LOG.LEVEL_PROCEDURE