434: **************************************/
435: BEGIN
436: SELECT gle.legal_entity_name
437: INTO g_legal_entity_name
438: FROM gmf_legal_entities gle
439: WHERE gle.legal_entity_id = g_legal_entity_id ;
440: EXCEPTION
441: WHEN NO_DATA_FOUND then
442: gmf_util.log(l_procedure_name || ': No data found in gmf_legal_entities query');
438: FROM gmf_legal_entities gle
439: WHERE gle.legal_entity_id = g_legal_entity_id ;
440: EXCEPTION
441: WHEN NO_DATA_FOUND then
442: gmf_util.log(l_procedure_name || ': No data found in gmf_legal_entities query');
443: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
444: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
445: END IF;
446: RAISE;
2529: **************************************/
2530: BEGIN
2531: SELECT gle.legal_entity_name
2532: INTO g_legal_entity_name
2533: FROM gmf_legal_entities gle
2534: WHERE gle.legal_entity_id = g_legal_entity_id ;
2535: EXCEPTION
2536: WHEN NO_DATA_FOUND then
2537: gmf_util.log(l_procedure_name || ': No data found in gmf_legal_entities query');
2533: FROM gmf_legal_entities gle
2534: WHERE gle.legal_entity_id = g_legal_entity_id ;
2535: EXCEPTION
2536: WHEN NO_DATA_FOUND then
2537: gmf_util.log(l_procedure_name || ': No data found in gmf_legal_entities query');
2538: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
2539: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
2540: END IF;
2541: RAISE;