286: **************************************/
287: BEGIN
288: SELECT gle.legal_entity_name
289: INTO g_legal_entity_name
290: FROM gmf_legal_entities gle
291: WHERE gle.legal_entity_id = g_legal_entity_id ;
292: EXCEPTION
293: WHEN NO_DATA_FOUND then
294: g_log_msg := l_procedure_name || ': No data found in gmf_legal_entities query';
290: FROM gmf_legal_entities gle
291: WHERE gle.legal_entity_id = g_legal_entity_id ;
292: EXCEPTION
293: WHEN NO_DATA_FOUND then
294: g_log_msg := l_procedure_name || ': No data found in gmf_legal_entities query';
295: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
296: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
297: END IF;
298: RAISE;
2006: **************************************/
2007: BEGIN
2008: SELECT gle.legal_entity_name
2009: INTO g_legal_entity_name
2010: FROM gmf_legal_entities gle
2011: WHERE gle.legal_entity_id = g_legal_entity_id ;
2012: EXCEPTION
2013: WHEN NO_DATA_FOUND then
2014: g_log_msg := l_procedure_name || ': No data found in gmf_legal_entities query';
2010: FROM gmf_legal_entities gle
2011: WHERE gle.legal_entity_id = g_legal_entity_id ;
2012: EXCEPTION
2013: WHEN NO_DATA_FOUND then
2014: g_log_msg := l_procedure_name || ': No data found in gmf_legal_entities query';
2015: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2016: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
2017: END IF;
2018: RAISE;