712: return;
713: end;
714: begin
715: select menu_id into menu_id
716: from fnd_menus_vl
717: where menu_name = X_MENU_NAME;
718: exception
719: when no_data_found then
720: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
717: where menu_name = X_MENU_NAME;
718: exception
719: when no_data_found then
720: fnd_message.set_name('FND', 'SQL_NO_DATA_FOUND');
721: fnd_message.set_token('TABLE', 'FND_MENUS_VL');
722: fnd_message.set_token('COLUMN', 'MENU_NAME');
723: fnd_message.set_token('VALUE', x_menu_name);
724: app_exception.raise_exception;
725: end;